Power BI Connector for Google Ads

Build 24.0.9062

SmartCampaignSearchTermView

A Smart campaign search term view.

Columns

Name Type Behavior Description
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
SmartCampaignSearchTermViewCampaign String ATTRIBUTE Output only. The Smart campaign the search term served in.
SmartCampaignSearchTermViewResourceName String ATTRIBUTE Output only. The resource name of the Smart campaign search term view. Smart campaign search term view resource names have the form: customers/{customer_id}/smartCampaignSearchTermViews/{campaign_id}~{URL-base64_search_term}
SmartCampaignSearchTermViewSearchTerm String ATTRIBUTE Output only. The search term.
Clicks Long METRIC The number of clicks.
CostMicros Long METRIC The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
Impressions Long METRIC Count of how often your ad has appeared on a search results page or website on the Google Network.
Date Date SEGMENT Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.
DayOfWeek String SEGMENT Day of the week, for example, MONDAY.

使用できる値は次のとおりです。FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, UNSPECIFIED, WEDNESDAY

Month Date SEGMENT Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
MonthOfYear String SEGMENT Month of the year, for example, January.

使用できる値は次のとおりです。APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN, UNSPECIFIED

Period String SEGMENT Predefined date range.

使用できる値は次のとおりです。TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN

Quarter Date SEGMENT Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, for example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
Week Date SEGMENT Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
Year Int SEGMENT Year, formatted as yyyy.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062