CampaignAsset
A link between a Campaign and an Asset.
Columns
| Name | Type | Behavior | Description |
| AdGroupId | Long | SEGMENT | Output only. The ID of the ad group. |
| CampaignId | Long | SEGMENT | Output only. The ID of the campaign. |
| CampaignAssetAsset | String | ATTRIBUTE | Immutable. The asset which is linked to the campaign. |
| CampaignAssetCampaign | String | ATTRIBUTE | Immutable. The campaign to which the asset is linked. |
| CampaignAssetFieldType | String | ATTRIBUTE | Immutable. Role that the asset takes under the linked campaign.
使用できる値は次のとおりです。AD_IMAGE, BOOK_ON_GOOGLE, BUSINESS_LOGO, BUSINESS_MESSAGE, BUSINESS_NAME, CALL, CALLOUT, CALL_TO_ACTION, CALL_TO_ACTION_SELECTION, DEMAND_GEN_CAROUSEL_CARD, DESCRIPTION, HEADLINE, HOTEL_CALLOUT, HOTEL_PROPERTY, LANDING_PAGE_PREVIEW, LANDSCAPE_LOGO, LEAD_FORM, LOGO, LONG_DESCRIPTION, LONG_HEADLINE, MANDATORY_AD_TEXT, MARKETING_IMAGE, MEDIA_BUNDLE, MOBILE_APP, PORTRAIT_MARKETING_IMAGE, PRICE, PROMOTION, RELATED_YOUTUBE_VIDEOS, SITELINK, SQUARE_MARKETING_IMAGE, STRUCTURED_SNIPPET, TALL_PORTRAIT_MARKETING_IMAGE, UNKNOWN, VIDEO, YOUTUBE_VIDEO |
| CampaignAssetPrimaryStatus | String | ATTRIBUTE | Output only. Provides the PrimaryStatus of this asset link.
使用できる値は次のとおりです。ELIGIBLE, LIMITED, NOT_ELIGIBLE, PAUSED, PENDING, REMOVED, UNKNOWN |
| CampaignAssetPrimaryStatusDetails | String | ATTRIBUTE | Output only. Provides the details of the primary status and its associated |
| CampaignAssetPrimaryStatusReasons | String | ATTRIBUTE | Output only. Provides a list of reasons for why an asset is not serving or
使用できる値は次のとおりです。ASSET_APPROVED_LABELED, ASSET_DISAPPROVED, ASSET_LINK_PAUSED, ASSET_LINK_REMOVED, ASSET_UNDER_REVIEW, UNKNOWN |
| CampaignAssetResourceName | String | ATTRIBUTE | Immutable. The resource name of the campaign asset. |
| CampaignAssetSource | String | ATTRIBUTE | Output only. Source of the campaign asset link.
使用できる値は次のとおりです。ADVERTISER, AUTOMATICALLY_CREATED, UNKNOWN |
| CampaignAssetStatus | String | ATTRIBUTE | Status of the campaign asset.
使用できる値は次のとおりです。ENABLED, PAUSED, REMOVED, UNKNOWN |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| AbsoluteTopImpressionPercentage | Double | METRIC | Search absolute top impression share is the percentage of your Search ad |
| AllConversions | Double | METRIC | The total number of conversions. This includes all conversions regardless |
| AllConversionsFromInteractionsRate | Double | METRIC | All conversions from interactions (as oppose to view through conversions) |
| AllConversionsValue | Double | METRIC | The value of all conversions. |
| AverageCost | Double | METRIC | The average amount you pay per interaction. This amount is the total cost |
| AverageCpc | Double | METRIC | The total cost of all clicks divided by the total number of clicks |
| AverageCpe | Double | METRIC | The average amount that you've been charged for an ad engagement. This |
| AverageCpm | Double | METRIC | Average cost-per-thousand impressions (CPM). |
| Clicks | Long | METRIC | The number of clicks. |
| Conversions | Double | METRIC | The number of conversions. This only includes conversion actions which |
| ConversionsFromInteractionsRate | Double | METRIC | Conversions from interactions divided by the number of ad interactions |
| ConversionsValue | Double | METRIC | The value of conversions. This only includes conversion actions which |
| CostMicros | Long | METRIC | The sum of your cost-per-click (CPC) and cost-per-thousand impressions |
| CostPerAllConversions | Double | METRIC | The cost of ad interactions divided by all conversions. |
| CostPerConversion | Double | METRIC | The cost of ad interactions divided by conversions. This only includes |
| CrossDeviceConversions | Double | METRIC | Conversions from when a customer clicks on a Google Ads ad on one device, |
| Ctr | Double | METRIC | The number of clicks your ad receives (Clicks) divided by the number |
| EngagementRate | Double | METRIC | How often people engage with your ad after it's shown to them. This is the |
| Engagements | Long | METRIC | The number of engagements. |
| Impressions | Long | METRIC | Count of how often your ad has appeared on a search results page or |
| InteractionEventTypes | String | METRIC | The types of payable and free interactions.
使用できる値は次のとおりです。CLICK, ENGAGEMENT, NONE, UNKNOWN, VIDEO_VIEW |
| InteractionRate | Double | METRIC | How often people interact with your ad after it is shown to them. |
| Interactions | Long | METRIC | The number of interactions. |
| PhoneCalls | Long | METRIC | Number of offline phone calls. |
| PhoneImpressions | Long | METRIC | Number of offline phone impressions. |
| PhoneThroughRate | Double | METRIC | Number of phone calls received (phone_calls) divided by the number of |
| TopImpressionPercentage | Double | METRIC | The percent of your ad impressions that are shown adjacent to the top |
| TrueviewAverageCpv | Double | METRIC | The average amount you pay each time someone views your ad. |
| ValuePerAllConversions | Double | METRIC | The value of all conversions divided by the number of all conversions. |
| ValuePerConversion | Double | METRIC | The value of conversions divided by the number of conversions. This only |
| VideoTrueviewViewRate | Double | METRIC | The number of TrueView views your video ad receives divided by its number |
| VideoTrueviewViews | Long | METRIC | The number of TrueView views your video ads received. |
| AdNetworkType | String | SEGMENT | Ad network type.
使用できる値は次のとおりです。CONTENT, DISCOVER, GMAIL, GOOGLE_OWNED_CHANNELS, GOOGLE_TV, MAPS, MIXED, SEARCH, SEARCH_PARTNERS, UNKNOWN, YOUTUBE |
| AdSubNetworkType | String | SEGMENT | Ad sub network type. Currently only available for ads running as part of
使用できる値は次のとおりです。UNKNOWN, UNSEGMENTED, YOUTUBE_INFEED, YOUTUBE_INSTREAM, YOUTUBE_SHORTS |
| AssetInteractionTargetAsset | String | SEGMENT | The asset resource name. |
| AssetInteractionTargetInteractionOnThisAsset | Bool | SEGMENT | Only used with CustomerAsset, CampaignAsset and AdGroupAsset metrics. Indicates whether the interaction metrics occurred on the asset itself or a different asset or ad unit. |
| ClickType | String | SEGMENT | Click type.
使用できる値は次のとおりです。AD_IMAGE, APP_DEEPLINK, BREADCRUMBS, BROADBAND_PLAN, CALLS, CALL_TRACKING, CLICK_ON_ENGAGEMENT_AD, CLICK_TO_MESSAGE_LANDING_PAGE_CLICK, CLICK_TO_MESSAGE_THIRD_PARTY_CLICK, CROSS_NETWORK, GET_DIRECTIONS, HOTEL_BOOK_ON_GOOGLE_ROOM_SELECTION, HOTEL_PRICE, LOCATION_EXPANSION, LOCATION_FORMAT_CALL, LOCATION_FORMAT_DIRECTIONS, LOCATION_FORMAT_IMAGE, LOCATION_FORMAT_LANDING_PAGE, LOCATION_FORMAT_MAP, LOCATION_FORMAT_STORE_INFO, LOCATION_FORMAT_TEXT, MOBILE_CALL_TRACKING, OFFER_PRINTS, OTHER, PRICE_EXTENSION, PRODUCT_AD_APP_DEEPLINK, PRODUCT_ASSETS, PRODUCT_EXTENSION_CLICKS, PRODUCT_LISTING_ADS_COUPON, PRODUCT_LISTING_AD_CLICKS, PRODUCT_LISTING_AD_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE, PRODUCT_LISTING_AD_TRANSACTABLE, PROMOTION_EXTENSION, SHOPPING_COMPARISON_LISTING, SHOWCASE_AD_CATEGORY_LINK, SHOWCASE_AD_LOCAL_PRODUCT_LINK, SHOWCASE_AD_LOCAL_STOREFRONT_LINK, SHOWCASE_AD_ONLINE_PRODUCT_LINK, SITELINKS, STORE_LOCATOR, SWIPEABLE_GALLERY_AD_HEADLINE, SWIPEABLE_GALLERY_AD_SEE_MORE, SWIPEABLE_GALLERY_AD_SITELINK_FIVE, SWIPEABLE_GALLERY_AD_SITELINK_FOUR, SWIPEABLE_GALLERY_AD_SITELINK_ONE, SWIPEABLE_GALLERY_AD_SITELINK_THREE, SWIPEABLE_GALLERY_AD_SITELINK_TWO, SWIPEABLE_GALLERY_AD_SWIPES, TRAVEL_ASSETS, UNKNOWN, URL_CLICKS, VEHICLE_ASSETS, VIDEO_APP_STORE_CLICKS, VIDEO_CALL_TO_ACTION_CLICKS, VIDEO_CARD_ACTION_HEADLINE_CLICKS, VIDEO_CHANNEL_CLICK, VIDEO_END_CAP_CLICKS, VIDEO_RELATED_VIDEOS_CLICK, VIDEO_WEBSITE_CLICKS, VISUAL_SITELINKS, WIRELESS_PLAN |
| ConversionAction | String | SEGMENT | Resource name of the conversion action. |
| ConversionActionCategory | String | SEGMENT | Conversion action category.
使用できる値は次のとおりです。ADD_TO_CART, BEGIN_CHECKOUT, BOOK_APPOINTMENT, CONTACT, CONVERTED_LEAD, DEFAULT, DOWNLOAD, ENGAGEMENT, GET_DIRECTIONS, IMPORTED_LEAD, OUTBOUND_CLICK, PAGE_VIEW, PHONE_CALL_LEAD, PURCHASE, QUALIFIED_LEAD, REQUEST_QUOTE, SIGNUP, STORE_SALE, STORE_VISIT, SUBMIT_LEAD_FORM, SUBSCRIBE_PAID, UNKNOWN, YOUTUBE_FOLLOW_ON_VIEWS |
| ConversionActionName | String | SEGMENT | Conversion action name. |
| Date | Date | SEGMENT | Date to which metrics apply. |
| DayOfWeek | String | SEGMENT | Day of the week, for example, MONDAY.
使用できる値は次のとおりです。FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, WEDNESDAY |
| Device | String | SEGMENT | Device to which metrics apply.
使用できる値は次のとおりです。CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN |
| ExternalConversionSource | String | SEGMENT | External conversion source.
使用できる値は次のとおりです。AD_CALL_METRICS, ANALYTICS, ANALYTICS_SEARCH_ADS_360, ANDROID_FIRST_OPEN, ANDROID_IN_APP, APP_UNSPECIFIED, CLICK_TO_CALL, DISPLAY_AND_VIDEO_360_FLOODLIGHT, FIREBASE, FIREBASE_SEARCH_ADS_360, FLOODLIGHT, GOOGLE_ATTRIBUTION, GOOGLE_HOSTED, GOOGLE_PLAY, IOS_FIRST_OPEN, IOS_IN_APP, SALESFORCE, SEARCH_ADS_360, STORE_SALES, STORE_SALES_CRM, STORE_SALES_DIRECT_UPLOAD, STORE_SALES_PAYMENT_NETWORK, STORE_VISITS, THIRD_PARTY_APP_ANALYTICS, UNKNOWN, UPLOAD, UPLOAD_CALLS, WEBPAGE, WEBSITE_CALL_METRICS |
| Month | Date | SEGMENT | Month as represented by the date of the first day of a month. Formatted as |
| MonthOfYear | String | SEGMENT | Month of the year, for example, January.
使用できる値は次のとおりです。APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN |
| 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. |
| Slot | String | SEGMENT | Position of the ad.
使用できる値は次のとおりです。CONTENT, MIXED, SEARCH_OTHER, SEARCH_PARTNER_OTHER, SEARCH_PARTNER_TOP, SEARCH_SIDE, SEARCH_TOP, UNKNOWN |
| Week | Date | SEGMENT | Week as defined as Monday through Sunday, and represented by the date of |
| 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. |