Power BI Connector for Google Ads

Build 24.0.9062

CampaignCriterion

A campaign criterion.

Table Specific Information

Select

Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the Ads console.

To use the nondefault fields, explicitly select them in your query.

Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the Ads API.

Columns

Name Type Behavior Description
CampaignCriterionAdScheduleDayOfWeek String ATTRIBUTE Day of the week the schedule applies to. This field is required for CREATE operations and is prohibited on UPDATE operations.

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

CampaignCriterionAdScheduleEndHour Int ATTRIBUTE Ending hour in 24 hour time; 24 signifies end of the day. This field must be between 0 and 24, inclusive. This field is required for CREATE operations and is prohibited on UPDATE operations.
CampaignCriterionAdScheduleEndMinute String ATTRIBUTE Minutes after the end hour at which this schedule ends. The schedule is exclusive of the end minute. This field is required for CREATE operations and is prohibited on UPDATE operations.

使用できる値は次のとおりです。FIFTEEN, FORTY_FIVE, THIRTY, UNKNOWN, UNSPECIFIED, ZERO

CampaignCriterionAdScheduleStartHour Int ATTRIBUTE Starting hour in 24 hour time. This field must be between 0 and 23, inclusive. This field is required for CREATE operations and is prohibited on UPDATE operations.
CampaignCriterionAdScheduleStartMinute String ATTRIBUTE Minutes after the start hour at which this schedule starts. This field is required for CREATE operations and is prohibited on UPDATE operations.

使用できる値は次のとおりです。FIFTEEN, FORTY_FIVE, THIRTY, UNKNOWN, UNSPECIFIED, ZERO

CampaignCriterionAgeRangeType String ATTRIBUTE Type of the age range.

使用できる値は次のとおりです。AGE_RANGE_18_24, AGE_RANGE_25_34, AGE_RANGE_35_44, AGE_RANGE_45_54, AGE_RANGE_55_64, AGE_RANGE_65_UP, AGE_RANGE_UNDETERMINED, UNKNOWN, UNSPECIFIED

CampaignCriterionBidModifier String ATTRIBUTE The modifier for the bids when the criterion matches. The modifier must be in the range: 0.1 - 10.0. Most targetable criteria types support modifiers. Use 0 to opt out of a Device type.
CampaignCriterionBrandListSharedSet String ATTRIBUTE Shared set resource name of the brand list.
CampaignCriterionCampaign String ATTRIBUTE Immutable. The campaign to which the criterion belongs.
CampaignCriterionCarrierCarrierConstant String ATTRIBUTE The Carrier constant resource name.
CampaignCriterionCombinedAudienceCombinedAudience String ATTRIBUTE The CombinedAudience resource name.
CampaignCriterionContentLabelType String ATTRIBUTE Content label type, required for CREATE operations.

使用できる値は次のとおりです。BELOW_THE_FOLD, BRAND_SUITABILITY_CONTENT_FOR_FAMILIES, BRAND_SUITABILITY_GAMES_FIGHTING, BRAND_SUITABILITY_GAMES_MATURE, BRAND_SUITABILITY_HEALTH_SENSITIVE, BRAND_SUITABILITY_HEALTH_SOURCE_UNDETERMINED, BRAND_SUITABILITY_NEWS_RECENT, BRAND_SUITABILITY_NEWS_SENSITIVE, BRAND_SUITABILITY_NEWS_SOURCE_NOT_FEATURED, BRAND_SUITABILITY_POLITICS, BRAND_SUITABILITY_RELIGION, EMBEDDED_VIDEO, JUVENILE, LIVE_STREAMING_VIDEO, PARKED_DOMAIN, PROFANITY, SEXUALLY_SUGGESTIVE, SOCIAL_ISSUES, TRAGEDY, UNKNOWN, UNSPECIFIED, VIDEO, VIDEO_NOT_YET_RATED, VIDEO_RATING_DV_G, VIDEO_RATING_DV_MA, VIDEO_RATING_DV_PG, VIDEO_RATING_DV_T

CampaignCriterionCriterionId Long ATTRIBUTE Output only. The ID of the criterion. This field is ignored during mutate.
CampaignCriterionCustomAffinityCustomAffinity String ATTRIBUTE The CustomInterest resource name.
CampaignCriterionCustomAudienceCustomAudience String ATTRIBUTE The CustomAudience resource name.
CampaignCriterionDeviceType String ATTRIBUTE Type of the device.

使用できる値は次のとおりです。CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN, UNSPECIFIED

CampaignCriterionDisplayName String ATTRIBUTE Output only. The display name of the criterion. This field is ignored for mutates.
CampaignCriterionGenderType String ATTRIBUTE Type of the gender.

使用できる値は次のとおりです。FEMALE, MALE, UNDETERMINED, UNKNOWN, UNSPECIFIED

CampaignCriterionIncomeRangeType String ATTRIBUTE Type of the income range.

使用できる値は次のとおりです。INCOME_RANGE_0_50, INCOME_RANGE_50_60, INCOME_RANGE_60_70, INCOME_RANGE_70_80, INCOME_RANGE_80_90, INCOME_RANGE_90_UP, INCOME_RANGE_UNDETERMINED, UNKNOWN, UNSPECIFIED

CampaignCriterionIpBlockIpAddress String ATTRIBUTE The IP address of this IP block.
CampaignCriterionKeywordMatchType String ATTRIBUTE The match type of the keyword.

使用できる値は次のとおりです。BROAD, EXACT, PHRASE, UNKNOWN, UNSPECIFIED

CampaignCriterionKeywordText String ATTRIBUTE The text of the keyword (at most 80 characters and 10 words).
CampaignCriterionKeywordThemeFreeFormKeywordTheme String ATTRIBUTE Free-form text to be matched to a Smart Campaign keyword theme constant on a best-effort basis.
CampaignCriterionKeywordThemeKeywordThemeConstant String ATTRIBUTE The resource name of a Smart Campaign keyword theme constant. keywordThemeConstants/{keyword_theme_id}~{sub_keyword_theme_id}
CampaignCriterionLanguageLanguageConstant String ATTRIBUTE The language constant resource name.
CampaignCriterionListingScopeDimensions String ATTRIBUTE Scope of the campaign criterion.
CampaignCriterionLocalServiceIdServiceId String ATTRIBUTE The criterion resource name.
CampaignCriterionLocationGeoTargetConstant String ATTRIBUTE The geo target constant resource name.
CampaignCriterionLocationGroup String ATTRIBUTE Immutable. Location Group
CampaignCriterionLocationGroupEnableCustomerLevelLocationAssetSet Bool ATTRIBUTE Denotes that the latest customer level asset set is used for targeting. Used with radius and radius_units. Cannot be used with feed, geo target constants or feed item sets. When using asset sets, either this field or location_group_asset_sets should be specified. Both cannot be used at the same time. This can only be set in CREATE operations.
CampaignCriterionLocationGroupFeed String ATTRIBUTE Feed specifying locations for targeting. Cannot be set with AssetSet fields. This is required and must be set in CREATE operations.
CampaignCriterionMobileAppCategoryMobileAppCategoryConstant String ATTRIBUTE The mobile app category constant resource name.
CampaignCriterionMobileApplicationAppId String ATTRIBUTE A string that uniquely identifies a mobile application to Google Ads API. The format of this string is '{platform}-{platform_native_id}', where platform is '1' for iOS apps and '2' for Android apps, and where platform_native_id is the mobile application identifier native to the corresponding platform. For iOS, this native identifier is the 9 digit string that appears at the end of an App Store URL (for example, '476943146' for 'Flood-It! 2' whose App Store link is 'http://itunes.apple.com/us/app/flood-it!-2/id476943146'). For Android, this native identifier is the application's package name (for example, 'com.labpixies.colordrips' for 'Color Drips' given Google Play link 'https://play.google.com/store/apps/details?id=com.labpixies.colordrips'). A well formed app id for Google Ads API would thus be '1-476943146' for iOS and '2-com.labpixies.colordrips' for Android. This field is required and must be set in CREATE operations.
CampaignCriterionMobileApplicationName String ATTRIBUTE Name of this mobile application.
CampaignCriterionMobileDeviceMobileDeviceConstant String ATTRIBUTE The mobile device constant resource name.
CampaignCriterionNegative Bool ATTRIBUTE Immutable. Whether to target (false) or exclude (true) the criterion.
CampaignCriterionOperatingSystemVersionOperatingSystemVersionConstant String ATTRIBUTE The operating system version constant resource name.
CampaignCriterionParentalStatusType String ATTRIBUTE Type of the parental status.

使用できる値は次のとおりです。NOT_A_PARENT, PARENT, UNDETERMINED, UNKNOWN, UNSPECIFIED

CampaignCriterionPlacementUrl String ATTRIBUTE URL of the placement. For example, 'http://www.domain.com'.
CampaignCriterionProximityAddressCityName String ATTRIBUTE Name of the city.
CampaignCriterionProximityAddressCountryCode String ATTRIBUTE Country code.
CampaignCriterionProximityAddressPostalCode String ATTRIBUTE Postal code.
CampaignCriterionProximityAddressProvinceCode String ATTRIBUTE Province or state code.
CampaignCriterionProximityAddressProvinceName String ATTRIBUTE Province or state name.
CampaignCriterionProximityAddressStreetAddress String ATTRIBUTE Street address line 1.
CampaignCriterionProximityGeoPointLatitudeInMicroDegrees Int ATTRIBUTE Micro degrees for the latitude.
CampaignCriterionProximityGeoPointLongitudeInMicroDegrees Int ATTRIBUTE Micro degrees for the longitude.
CampaignCriterionProximityRadius Double ATTRIBUTE The radius of the proximity.
CampaignCriterionProximityRadiusUnits String ATTRIBUTE The unit of measurement of the radius. Default is KILOMETERS.

使用できる値は次のとおりです。KILOMETERS, MILES, UNKNOWN, UNSPECIFIED

CampaignCriterionResourceName String ATTRIBUTE Immutable. The resource name of the campaign criterion. Campaign criterion resource names have the form: customers/{customer_id}/campaignCriteria/{campaign_id}~{criterion_id}
CampaignCriterionStatus String ATTRIBUTE The status of the criterion.

使用できる値は次のとおりです。ENABLED, PAUSED, REMOVED, UNKNOWN, UNSPECIFIED

CampaignCriterionTopicPath String ATTRIBUTE The category to target or exclude. Each subsequent element in the array describes a more specific sub-category. For example, 'Pets & Animals', 'Pets', 'Dogs' represents the 'Pets & Animals/Pets/Dogs' category.
CampaignCriterionTopicTopicConstant String ATTRIBUTE The Topic Constant resource name.
CampaignCriterionType String ATTRIBUTE Output only. The type of the criterion.

使用できる値は次のとおりです。AD_SCHEDULE, AGE_RANGE, APP_PAYMENT_MODEL, AUDIENCE, BRAND, BRAND_LIST, CARRIER, COMBINED_AUDIENCE, CONTENT_LABEL, CUSTOM_AFFINITY, CUSTOM_AUDIENCE, CUSTOM_INTENT, DEVICE, GENDER, INCOME_RANGE, IP_BLOCK, KEYWORD, KEYWORD_THEME, LANGUAGE, LIFE_EVENT, LISTING_GROUP, LISTING_SCOPE, LOCAL_SERVICE_ID, LOCATION, LOCATION_GROUP, MOBILE_APPLICATION, MOBILE_APP_CATEGORY, MOBILE_DEVICE, NEGATIVE_KEYWORD_LIST, OPERATING_SYSTEM_VERSION, PARENTAL_STATUS, PLACEMENT, PROXIMITY, SEARCH_THEME, TOPIC, UNKNOWN, UNSPECIFIED, USER_INTEREST, USER_LIST, WEBPAGE, YOUTUBE_CHANNEL, YOUTUBE_VIDEO

CampaignCriterionUserInterestUserInterestCategory String ATTRIBUTE The UserInterest resource name.
CampaignCriterionUserListUserList String ATTRIBUTE The User List resource name.
CampaignCriterionWebpageConditions String ATTRIBUTE Conditions, or logical expressions, for webpage targeting. The list of webpage targeting conditions are and-ed together when evaluated for targeting. An empty list of conditions indicates all pages of the campaign's website are targeted. This field is required for CREATE operations and is prohibited on UPDATE operations.
CampaignCriterionWebpageCoveragePercentage Double ATTRIBUTE Website criteria coverage percentage. This is the computed percentage of website coverage based on the website target, negative website target and negative keywords in the ad group and campaign. For instance, when coverage returns as 1, it indicates it has 100% coverage. This field is read-only.
CampaignCriterionWebpageCriterionName String ATTRIBUTE The name of the criterion that is defined by this parameter. The name value will be used for identifying, sorting and filtering criteria with this type of parameters. This field is required for CREATE operations and is prohibited on UPDATE operations.
CampaignCriterionWebpageSampleSampleUrls String ATTRIBUTE Webpage sample urls
CampaignCriterionYoutubeChannelChannelId String ATTRIBUTE The YouTube uploader channel id or the channel code of a YouTube channel.
CampaignCriterionYoutubeVideoVideoId String ATTRIBUTE YouTube video id as it appears on the YouTube watch page.
CustomerId Long ATTRIBUTE Output only. The ID of the customer.

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