CampaignBudget
A campaign budget.
View-Specific Information
Select
Google Ads does not allow every column to be selected in a single query, as some data conflicts if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes are 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 using the following supported operators: =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, NOT IN . Note that all filters must be joined by AND, as OR is not supported by the Ads API.
Columns
| Name | Type | Behavior | Description |
| CampaignId | Long | SEGMENT | Output only. The ID of the campaign. |
| CampaignBudgetAlignedBiddingStrategyId | Long | ATTRIBUTE | ID of the portfolio bidding strategy that this shared campaign budget |
| CampaignBudgetAmountMicros | Long | ATTRIBUTE | The average daily amount to be spent by the campaign. |
| CampaignBudgetDeliveryMethod | String | ATTRIBUTE | The delivery method that determines the rate at which the campaign budget
使用できる値は次のとおりです。ACCELERATED, STANDARD, UNKNOWN |
| CampaignBudgetExplicitlyShared | Bool | ATTRIBUTE | Specifies whether the budget is explicitly shared. Defaults to true if |
| CampaignBudgetHasRecommendedBudget | Bool | ATTRIBUTE | Output only. Indicates whether there is a recommended budget for this |
| CampaignBudgetId | Long | ATTRIBUTE | Output only. The ID of the campaign budget. |
| CampaignBudgetName | String | ATTRIBUTE | The name of the campaign budget. |
| CampaignBudgetPeriod | String | ATTRIBUTE | Immutable. Period over which to spend the budget. Defaults to DAILY if not
使用できる値は次のとおりです。CUSTOM_PERIOD, DAILY, UNKNOWN |
| CampaignBudgetRecommendedBudgetAmountMicros | Long | ATTRIBUTE | Output only. The recommended budget amount. If no recommendation is |
| CampaignBudgetRecommendedBudgetEstimatedChangeWeeklyClicks | Long | ATTRIBUTE | Output only. The estimated change in weekly clicks if the recommended |
| CampaignBudgetRecommendedBudgetEstimatedChangeWeeklyCostMicros | Long | ATTRIBUTE | Output only. The estimated change in weekly cost in micros if the |
| CampaignBudgetRecommendedBudgetEstimatedChangeWeeklyInteractions | Long | ATTRIBUTE | Output only. The estimated change in weekly interactions if the recommended |
| CampaignBudgetRecommendedBudgetEstimatedChangeWeeklyViews | Long | ATTRIBUTE | Output only. The estimated change in weekly views if the recommended budget |
| CampaignBudgetReferenceCount | Long | ATTRIBUTE | Output only. The number of campaigns actively using the budget. |
| CampaignBudgetResourceName | String | ATTRIBUTE | Immutable. The resource name of the campaign budget. |
| CampaignBudgetStatus | String | ATTRIBUTE | Output only. The status of this campaign budget. This field is read-only.
使用できる値は次のとおりです。ENABLED, REMOVED, UNKNOWN |
| CampaignBudgetTotalAmountMicros | Long | ATTRIBUTE | The total amount to be spent by the campaign over its entire duration. |
| CampaignBudgetType | String | ATTRIBUTE | Immutable. The type of the campaign budget.
使用できる値は次のとおりです。FIXED_CPA, LOCAL_SERVICES, SMART_CAMPAIGN, STANDARD, UNKNOWN |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| 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. |
| 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. |
| ViewThroughConversions | Long | METRIC | The total number of view-through conversions. |
| AdSubNetworkType | String | SEGMENT | Ad sub network type. Currently only available for ads running as part of
使用できる値は次のとおりです。UNKNOWN, UNSEGMENTED, YOUTUBE_INFEED, YOUTUBE_INSTREAM, YOUTUBE_SHORTS |
| BudgetCampaignAssociationStatusCampaign | String | SEGMENT | The campaign resource name. |
| BudgetCampaignAssociationStatusStatus | String | SEGMENT | Budget campaign association status.
使用できる値は次のとおりです。ENABLED, REMOVED, UNKNOWN |
| 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. |
| 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 |
| 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 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |