Cubes¶

The following cubes are available for querying using the custom reports endpoint:

performance_stats¶

This cube has performance stats for all levels down to the ad level. It is recommended to use this cube when querying for native ads campaign data. The cube does not include keyword level metrics. Data for both search and native campaigns is provided - you can use the “Source” field to filter for a specific channel. Note that the cube does not include any over delivery spend adjustments which are available in the adjustment_stats cube.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Must be filtered	The ID of the advertiser.
Campaign ID	Dimension	Can be filtered	The ID of the campaign.
Ad Group ID	Dimension	Can be filtered	The ID of the ad group.
Ad ID	Dimension	Can be filtered	The ID of the ad.
Month	Dimension		Month will be represented as the first day of the month in YYYY-MM-DD’ format. Either Day, Week or Month must be queried.
Week	Dimension		Week will be represented as the first day of the week in YYYY-MM-DD’ format. This will always be Monday. Either Day, Week or Month must be queried.
Day	Dimension	Must be filtered	The date in YYYY-MM-DD format. Either Day, Week or Month must be queried.
Hour	Dimension	Can be filtered	The hour in integer format. For example, 1 means reporting stats between 1am and 2am.
Pricing Type	Dimension	Can be filtered	CPC, CPM
Device Type	Dimension	Can be filtered	Device type of the user: Desktop, Tablet, Phone, Unknown. Note that Device Type data is only available after the field is launched. If you run it for a previous date, it will return NONE in the Device Type column.
Source Name	Dimension	Can be filtered	Native, Search or Other.
Impressions	Fact		The number of impressions.
Clicks	Fact		The number of clicks.
Post Click Conversion Value	Fact		The Conversion Value attributed to Post Click Conversions.
Post Click Conversions	Fact		The total number of post click conversions.
Post Impression Conversions	Fact		The total number of post view conversions.
Post Impression Conversion Value	Fact		The value associated with the conversion event.
Conversions	Fact		The total number of conversions, includes both post click and post view conversions. For app install campaigns the default conversion windows are 7 days post-click and 1 day post view. For website conversions the default windows are 30 days post-click and 2 days post-view.
Total Conversions	Fact		A synonym for the Conversions field (is kept for backwards compatibility).
Total Conversion Value	Fact		The value associated with total post click and post impression conversions.
Spend	Fact		The unadjusted spend amount. Please note that adjustments - meaning any corrections due to issues like overcharging - can be queried using the adjustment_stats cube.
Average Position	Fact		Impression weighted average position.
Max Bid	Fact		The maximum bid value.
Ad Extn Impressions	Fact		Total impressions for which an ad extension was displayed.
Ad Extn Clicks	Fact		Total clicks on an ad extension link (rather than on the ad landing URL).
Ad Extn Conversions	Fact		Total conversions which were attributed back to an ad extension link click.
Ad Extn Spend	Fact		The spend resulting from clicking on an ad extension link.
Average CPC	Fact		The average CPC bid value.
Average CPM	Fact		The average CPM bid value.
CTR	Fact		The clickthrough rate.
Video Starts	Fact		The number of video starts.
Video Views	Fact		The number of video views.
Video 25% Complete	Fact		Number of times the video played to 25% of its length.
Video 50% Complete	Fact		Number of times the video played to 50% of its length.
Video 75% Complete	Fact		Number of times the video played to 75% of its length.
Video 100% Complete	Fact		Number of times the video played to 100% of its length.
Cost Per Video View	Fact		Average cost per video view.
Video Closed	Fact		The number of times the video was closed.
Video Skipped	Fact		The number of times the video was skipped.
Video after 30 seconds view	Fact		The number of times the video played longer than 30 seconds.
In App Post Click Convs	Fact		Total Post Click Conversions that occurred in the app after it was installed. These conversions occurred in the app, but were attributed to clicks made on an ad outside of the app.
In App Post View Convs	Fact		Total Post View Conversions that occurred in the app after it was installed. These conversions occurred in the app, but were attributed to impressions made on an ad outside of the app.
In App Post Install Convs	Fact		Total Post Install Conversions that occurred in the app after it was installed. These conversions occurred in the app, but were attributed to the installation made on an ad outside of the app.
Opens	Fact		Number of impressions of the Mail Ad asset.
Saves	Fact		Number of users who clicked save.
Save Rate	Fact		Rate of saves (over opens).
Forwards	Fact		Number of email addresses the email was forwarded to.
Forward Rate	Fact		Rate of forwards (over opens).
Click Outs	Fact		Number of users to clicked out to advertiser landing page.
Click Outs Rate	Fact		Rate of clickouts (over opens).
Fact Conversion Counting	Dimension	Can be filtered	The way your conversions were counted for the campaign during the report time range (ALL_PER_INTERACTION, ONE_PER_INTERACTION).
Interactions	Fact		The number of positive user interactions with an ad, like swipes, saves, opens, submits, and so on – for example, the number of carousel cards viewed. Note that video play interactions are only counted from sessions that qualify for an interactive impression.
Interaction Rate	Fact		The sum of all interactions (both positive and neutral) relative to the total number of impressions, expressed as a percentage – for example, .3. Note that neutral interactions include interactions like close or skip ad.
Interactive Impressions Rate	Fact		The sum of positive interactions impressions relative to the total number of impressions, expressed as a percentage – for example, .5.

Sample performance_stats cube report request:

{
   "cube": "performance_stats",
   "fields": [
       {
           "field": "Ad ID"
       },
       {
           "field": "Day"
       },
       {
           "field": "Impressions"
       },
       {
           "field": "Clicks"
       },
       {
           "field": "CTR"
       },
       {
           "field": "Total Conversion Value"
       },
       {
           "field": "Post Click Conv Value"
       },
       {
           "field": "Post Impr Conv Value"
       },
       {
           "field": "Ad Image URL",
           "alias": "URL"
       }

   ],
   "filters": [
       {
           "field": "Advertiser ID",
           "operator": "=",
           "value": 11610
       },
       {
           "field": "Campaign ID",
           "operator": "IN",
           "values": [
               336986136,
               336986133
           ]
       },
       {
           "field": "Day",
           "operator": "between",
           "from": "2014-09-01",
           "to": "2014-09-08"
       }
   ]
}

slot_performance_stats¶

This cube has slot performance stats for all levels down to the ad level. It is recommended to use this cube for per-card Carousel Ads reporting. The cube does not include keyword level metrics. Data for both search and native campaigns is provided - you can use the Source field to filter for a specific channel.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Must be filtered	The ID of the advertiser.
Campaign ID	Dimension	Can be filtered	The ID of the campaign.
Ad Group ID	Dimension	Can be filtered	The ID of the ad group.
Ad ID	Dimension	Can be filtered	The ID of the ad.
Month	Dimension		Month will be represented as the first day of the month in YYYY-MM-DD format. Either Day, Week or Month must be queried.
Week	Dimension		Week will be represented as the first day of the week in YYYY-MM-DD format. This will always be Monday. Either Day, Week or Month must be queried.
Day	Dimension	Must be filtered	The date in YYYY-MM-DD format. Either Day, Week or Month must be queried.
Hour	Dimension	Can be filtered	The hour in integer format. For example, 1 means reporting stats between 1am and 2am.
Pricing Type	Dimension	Can be filtered	CPC, CPM
Source	Dimension	Can be filtered	Integer value corresponding to various Source types.
Card ID	Dimension	Can be filtered	Ad slot asset Id.
Card Position	Dimension	Can be filtered	Ad slot Horizontal Index.
Ad Format Name	Dimension	Can be filtered	Category of Ad like Single Image, Mail Ad, Video, etc.
Rendered Type	Dimension	Can be filtered	Ad got rendered as Standard (e.g. Text) or Multiple (e.g. Carousel).
Impressions	Fact		The number of impressions.
Clicks	Fact	Can be filtered	The number of clicks.
Post Click Conversions	Fact		The total number of post click conversions.
Spend	Fact	Can be filtered	The unadjusted spend amount. Please note that adjustments - meaning any corrections due to issues like overcharging - can be queried using the adjustment_stats cube.
CTR	Fact		The clickthrough rate.

Sample slot_performance_stats cube report request:

{
"cube": "slot_performance_stats",
"schema": "advertiser",
"fields": [
{ "field": "Ad ID" }

,
{ "field": "Card ID" }

,
{ "field": "Card Position" }

,
{ "field": "Impressions" }

,
{ "field": "Clicks" }

,
{ "field": "Spend" }

,
{ "field": "CTR" }

,
{ "field": "Asset Title" }

],
"filters": [
{ "field": "Ad ID", "operator": "=", "value": "33360706478" }

,
{ "field": "Advertiser ID", "operator": "=", "value": "1547793" }

,
{ "field": "Day", "operator": "Between", "from": "2017-05-22", "to": "2017-06-12" }

]
}

site_performance_stats¶

This cube has site performance stats for all levels down to the ad group level. It is recommended to use this cube when querying for native ads campaign data. The cube does not include keyword level metrics. Note that the cube does not include any over delivery spend adjustments which are available in the adjustment_stats cube.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Can be filtered on	The ID of the advertiser.
Campaign ID	Dimension	Can be filtered on	The ID of the campaign.
Ad Group ID	Dimension	Can be filtered on	The ID of the ad group.
Day	Dimension	Must be filtered on	The day in YYYY-MM-DD format. Either Day, Week or Month must be queried.
Hour	Dimension	Must be filtered on	The hour in standard hour format. Either Hour, Day, Week or Month must be queried.
External Site Name	Dimension		Supply influenced by SITE_X_DEVICE bid modifiers can be identified via External Site Name column.
External Site Group Name	Dimension		Supply influenced by SITE_GROUP_X_DEVICE bid modifiers can be identified via External Site Group Name column.
Device Type	Dimension		Device type of the user: Desktop, Tablet, Phone, Unknown. Note that Device Type data is only available after the field is launched. If you run it for a previous date, it will return NONE in the Device Type column.
Bid Modifier	Dimension		The bid modifier used for the ad.
Average Bid	Dimension		The average bid for the ad.
Modified Bid	Dimension		The average bid multiplied by the bid modifier.
Spend	Fact		The unadjusted spend amount. Please note that adjustments - meaning any corrections due to issues like overcharging - can be queried using the adjustment_stats cube.
Impressions	Fact		The number of impressions.
Clicks	Fact		The number of clicks.
Post Click Conversions	Fact		The total number of post click conversions.
Post Impression Conversions	Fact		The total number of post view conversions.
Conversions	Fact		The total number of conversions, includes both post click and post view conversions. For app install campaigns the default conversion windows are 7 days post-click and 1 day post view. For website conversions, the default windows are 30 days post-click and 2 days post-view.
CTR	Fact		The clickthrough rate.
Average CPC	Fact		The average CPC bid value.
Average CPM	Fact		The average CPM bid value.
Fact Conversion Counting	Dimension	Can be filtered	The way your conversions were counted for the campaign during the report time range (ALL_PER_INTERACTION, ONE_PER_INTERACTION).

Note

The date/time values (i.e., Month, Week, Day, Hour) are all in the advertiser’s timezone. Note also that you can and must filter on the Day, but you cannot filter on the Week or Month.

Sample site_performance_stats cube report request:

{
  "cube": "site_performance_stats",
  "fields": [
      {
          "field": "Day"
      },
      {
          "field": "Advertiser ID"
      },
      {
          "field": "Advertiser Timezone"
      },
      {
          "field": "External Site Name"
      },
      {
          "field": "Device Type"
      },
      {
          "field": "Impressions"
      },
      {
          "field": "Clicks"
      },
      {
          "field": "Conversions"
      },
      {
          "field": "Spend"
      },
      {
          "field": "Native Bid"
      },
      {
          "field": "Average Bid"
      },
      {
          "field": "Bid Modifier"
      },
      {
          "field": "Modified Bid"
      },
      {
          "field": "Average CPM"
      }
  ],
  "filters": [
      {
          "field": "Advertiser ID",
          "operator": "=",
          "value": "5430"
      },
      {
          "field": "Day",
          "operator": "Between",
          "from": "2017-07-24",
          "to": "2017-07-30"
      }
  ]

}

campaign_bid_performance_stats¶

This cube has native bid adjustments stats for all levels down to the ad group level. It is recommended to use this cube when evaluating group-level bid modifiers. Note that the cube does not include any site-level modifiers or overdelivery spend adjustments.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Can be filtered on	The ID of the advertiser.
Campaign ID	Dimension	Can be filtered on	The ID of the campaign.
Section ID	Dimension	Can be filtered on	The ID of the section.
Ad Group ID	Dimension	Can be filtered on	The ID of the ad group.
Day	Dimension	Must be filtered on	The date in YYYY-MM-DD format. Either Day, Week or Month must be queried.
Supply Type	Dimension		The supply type is `SECTION_GROUP`.
Group or Site	Dimension		The section group value. Site is no longer available.
Group	Dimension		The native supply group, i.e., `GROUP_1A`, `GROUP_1B`, `GROUP_2A`, `GROUP_2B`, `GROUP_3A`, `GROUP_3B`.
Bid Modifier	Dimension		The bid modifier used for the ad.
Average Bid	Dimension		The average bid for the ad.
Modified Bid	Dimension		The average bid multiplied by the bid modifier.
Impressions	Fact		The number of impressions.
Clicks	Fact		The number of clicks.
Post Click Conversions	Fact		The total number of post click conversions.
Post Impression Conversions	Fact		The total number of post view conversions.
Conversions	Fact		The total number of conversions, includes both post click and post view conversions. For app install campaigns the default conversion windows are 7 days post-click and 1 day post view. For website conversions, the default windows are 30 days post-click and 2 days post-view.
Cost	Fact
CTR	Derived Fact		The clickthrough rate.
Average CPC	Derived Fact		The average CPC bid value.
Fact Conversion Counting	Dimension	Can be filtered	The way your conversions were counted for the campaign during the report time range (ALL_PER_INTERACTION, ONE_PER_INTERACTION).

Note

The date/time values (i.e., Month, Week, Day, Hour) are all in the advertiser’s timezone. Note also that you can and must filter on the Day, but you cannot filter on the Week or Month.

Sample campaign_bid_performance_stats report request:

{
  "cube": "campaign_bid_performance_stats",
  "fields": [
      {
          "field": "Advertiser ID"
      },
      {
          "field": "Campaign ID"
      },
      {
          "field": "Ad Group ID"
      },
      {
          "field": "Day"
      },
      {
          "field": "Supply Type"
      },
      {
          "field": "Group or Site"
      },
      {
          "field": "Bid Modifier"
      },
      {
          "field": "Average Bid"
      },
      {
          "field": "Modified Bid"
      },
      {
          "field": "Impressions"
      },
      {
          "field": "Clicks"
      },
      {
          "field": "Conversions"
      },
      {
          "field": "Post Click Conversions"
      },
      {
          "field": "Post Impression Conversions"
      },
      {
          "field": "Cost"
      },
      {
          "field": "CTR"
      },
      {
          "field": "Average CPC"
      }
  ],
  "filters": [
      {
          "field": "Advertiser ID",
          "operator": "=",
          "value": "5430"
      },
      {
          "field": "Day",
          "operator": "Between",
          "from": "2017-07-25",
          "to": "2017-07-31"
      }
   ]
}

structured_snippet_extension_stats¶

This cube has Structured snippet extension stats for all levels down to the ad level. This cube only contains search performance data that resulted from a Structured snippet extension impression. Note that the cube does not include any over-delivery spend adjustments which are available in the adjustment_stats cube. Use this for getting metrics on Structured snippet extension performance.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Must be filtered on	The ID of the advertiser.
Campaign ID	Dimension	Can be filtered on	The ID of the campaign.
Ad Group ID	Dimension	Can be filtered on	The ID of the ad group.
Ad ID	Dimension	Can be filtered on	The ID of the ad.
Keyword ID	Dimension	Can be filtered on	The ID of the keyword.
Structured Snippet Extn ID	Dimension	Can be filtered on	The ad extension ID corresponding to the Structured Snippet extension.
Month	Dimension		Month will be represented as the first day of the month in YYYY-MM-DD’ format. Either Day, Week or Month must be queried.
Week	Dimension		Week will be represented as the first day of the week in YYYY-MM-DD’ format. This will always be Monday. Either Day, Week or Month must be queried.
Day	Dimension	Must be filtered on	The date in YYYY-MM-DD format. Either Day, Week or Month must be queried.
Device type	Dimension	Can be filtered on	SmartPhone, Desktop, Tablet or UNKNOWN.
Structured Snippet Text	Dimension	Can be filtered on	Structured Snippet text displayed on the Ad.
Pricing Type	Dimension	Can be filtered on	CPC, CPM
Source	Dimension	Can be filtered on	Integer value corresponding to various Source types.
Destination URL	Dimension	Can be filtered on	The actual served URL post macro-expansion. Can only be requested if both Ad ID and Keyword ID are requested. Note that requesting Destination URL granularity will result in considerably longer report generation times - only request this data if you really need it.
Impressions	Fact		The number of impressions.
Clicks	Fact		The number of clicks.
Conversions	Fact		The total number of conversions includes both post click and post view conversions.
Spend	Fact		The unadjusted spend amount. Please note that adjustments - meaning any corrections due to issues like overcharging - can be queried using the adjustment_stats cube.
Average Position	Fact		The impression weighted average position.
Max Bid	Fact		The maximum bid value.
Average CPC	Fact		The average CPC bid value.
Average Cost-per-install	Fact		The average cost per install.
Average Cost-per-action	Fact		The average cost per action.
Average CPM	Fact		The average cost per impression.
CTR	Fact		The clickthrough rate.

Sample structured_snippet_extension cube report request:

{
 "cube" : "structured_snippet_extension",
 "fields" : [
   { "field" : "Advertiser ID" },
   { "field" : "Campaign ID" },
   { "field" : "Ad Group ID" },
   { "field" : "Ad ID" },
   { "field" : "Keyword ID" },
   { "field" : "Structured Snippet Extn ID" },
   { "field" : "Structured Snippet Text" },
   { "field" : "Device Type" },
   { "field" : "Month" },
   { "field" : "Week" },
   { "field" : "Day" },
   { "field" : "Source" },
   { "field" : "Pricing Type" },
   { "field" : "Destination URL" },
   { "field" : "Impressions" },
   { "field" : "Clicks" },
   { "field" : "Conversions" },
   { "field" : "Spend" },
   { "field" : "Average Position" },
   { "field" : "Max Bid" },
   { "field" : "Average CPC" },
   { "field" : "Average Cost-per-install" },
   { "field" : "Average Cost-per-action" },
   { "field" : "Average CPM" },
   { "field" : "CTR" }
 ],
 "filters": [
      {
          "field": "Advertiser ID",
          "operator": "=",
          "value": 929757
      },
      {
          "field": "Campaign ID",
          "operator": "IN",
          "values": [
              331195036,
              331273097
          ]
      },
      {
          "field": "Day",
          "operator": "between",
          "from": "2017-09-01",
          "to": "2017-09-08"
      }]
 }

product_ad_performance_stats¶

This cube has product ad performance stats for all levels down to the ad level. Use this cube when querying for native ads campaign data. It is only available for native ads. The cube does not include keyword level metrics. Data for both search and native campaigns is provided - you can use the “Source” field to filter for a specific channel. Note that the cube does not include any over delivery spend adjustments which are available in the adjustment_stats cube.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Must be filtered	The ID of the advertiser.
Campaign ID	Dimension	Can be filtered	The ID of the campaign.
Ad Group ID	Dimension	Can be filtered	The ID of the ad group.
Product Ad ID	Dimension	Can be filtered	The ID of the Product ad.
Month	Dimension		Month will be represented as the first day of the month in YYYY-MM-DD’ format. Either Day, Week or Month must be queried.
Week	Dimension		Week will be represented as the first day of the week in YYYY-MM-DD’ format. This will always be Monday. Either Day, Week or Month must be queried.
Day	Dimension	Must be filtered	The date in YYYY-MM-DD format. Either Day, Week or Month must be queried.
Hour	Dimension	Can be filtered	The hour in integer format. For example, 1 means reporting stats between 1am and 2am.
Pricing Type	Dimension	Can be filtered	CPC, CPM
Device Type	Dimension	Can be filtered	Device type of the user: Desktop, Tablet, Phone, Unknown. Note that Device Type data is only available after the field is launched. If you run it for a previous date, it will return NONE in the Device Type column.
Source Name	Dimension	Can be filtered	Native, Search, or Other.
Impressions	Fact		The number of impressions.
Clicks	Fact		The number of clicks.
Post Click Conversions	Fact		The total number of post click conversions.
Post Impression Conversions	Fact		The total number of post view conversions.
Conversions	Fact		The total number of conversions, includes both post click and post view conversions. For app install campaigns the default conversion windows are 7 days post-click and 1 day post view. For website conversions the default windows are 30 days post-click and 2 days post-view.
Total Conversions	Fact		A synonym for the Conversions field (is kept for backwards compatibility).
Spend	Fact		The unadjusted spend amount. Please note that adjustments - meaning any corrections due to issues like overcharging - can be queried using the adjustment_stats cube.
Average Position	Fact		Impression weighted average position.
Max Bid	Fact		The maximum bid value.
Ad Extn Impressions	Fact		Total impressions for which an ad extension was displayed.
Ad Extn Clicks	Fact		Total clicks on an ad extension link (rather than on the ad landing URL).
Ad Extn Conversions	Fact		Total conversions which were attributed back to an ad extension link click.
Ad Extn Spend	Fact		The spend resulting from clicking on an ad extension link.
Average CPC	Fact		The average CPC bid value.
Average CPM	Fact		The average CPM bid value.
CTR	Fact		The clickthrough rate.
Video Starts	Fact		The number of video starts.
Video Views	Fact		The number of video views.
Video 25% Complete	Fact		Number of times the video played to 25% of its length.
Video 50% Complete	Fact		Number of times the video played to 50% of its length.
Video 75% Complete	Fact		Number of times the video played to 75% of its length.
Video 100% Complete	Fact		Number of times the video played to 100% of its length.
Cost Per Video View	Fact		Average cost per video view.
Video Closed	Fact		The number of times the video was closed.
Video Skipped	Fact		The number of times the video was skipped.
Video after 30 seconds view	Fact		The number of times the video played longer than 30 seconds.
In App Post Click Convs	Fact		Total Post Click Conversions that occurred in the app after it was installed. These conversions occurred in the app, but were attributed to clicks made on an ad outside of the app.
In App Post View Convs	Fact		Total Post View Conversions that occurred in the app after it was installed. These conversions occurred in the app, but were attributed to impressions made on an ad outside of the app.
In App Post Install Convs	Fact		Total Post Install Conversions that occurred in the app after it was installed. These conversions occurred in the app, but were attributed to the installation made on an ad outside of the app.
Opens	Fact		Number of impressions of the Mail Ad asset.
Saves	Fact		Number of users who clicked save.
Save Rate	Fact		Rate of saves (over opens).
Forwards	Fact		Number of email addresses the email was forwarded to.
Forward Rate	Fact		Rate of forwards (over opens).
Click Outs	Fact		Number of users to clicked out to advertiser landing page.
Click Outs Rate	Fact		Rate of clickouts (over opens).
Fact Conversion Counting	Dimension	Can be filtered	The way your conversions were counted for the campaign during the report time range (ALL_PER_INTERACTION, ONE_PER_INTERACTION).

Sample product_ad_performance cube report request:

{
   "cube": "product_ad_performance_stats",
   "fields": [
       {
           "field": "Product Ad ID"
       },
       {
           "field": "Day"
       },
       {
           "field": "Impressions"
       },
       {
           "field": "Clicks"
       },
       {
           "field": "CTR",
       }
   ],
   "filters": [
       {
           "field": "Advertiser ID",
           "operator": "=",
           "value": 11610
       },
       {
           "field": "Campaign ID",
           "operator": "IN",
           "values": [
               336986136,
               336986133
           ]
       },
       {
           "field": "Day",
           "operator": "between",
           "from": "2014-09-01",
           "to": "2014-09-08"
       }
   ]
}

adjustment_stats¶

This cube provides performance metrics for over delivery adjustments for spend, which are not available in other cubes.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Must be filtered	The ID of the advertiser.
Campaign ID	Dimension	Can be filtered	The ID of the campaign.
Day	Dimension	Must be filtered	The date in YYYY-MM-DD format.
Pricing Type	Dimension	Can be filtered	CPC, CPM
Source Name	Dimension	Can be filtered	Native, Search or Other.
Is Adjustment	Dim	Can be filtered	For adjustment rows (‘Is Adjustment’ = ‘Y’) all fact values other than Spend are always blank. Pricing Type and Source values are also blank.
Adjustment Type	Dim	Can be filtered	If you request a report at Campaign ID granularity (‘Campaign ID’ is in your fields list), then you will get only campaign adjustment rows (plus unadjusted rows). If you request a report at Advertiser ID granularity (‘Advertiser ID’ is in your fields list), then you will potentially get both account adjustments (Adjustment Type = ‘Account’) and rolled up campaign adjustment (Adjustment Type = ‘Campaign’), as well as unadjusted rows (Adjustment Type = ‘None’).
Impressions	Fact		The number of impressions.
Clicks	Fact		The number of clicks.
Conversions	Fact		The total number of conversions includes both post click and post view conversions.
Spend	Fact		The spend amount.
Average Position	Fact		Impression weighted average position.

Sample adjustment_stats cube report request:

{
   "cube": "adjustment_stats",
   "fields": [
       {
           "field": "Advertiser ID"
       },
       {
           "field": "Campaign ID"
       },
       {
           "field": "Source",
           "alias": "Channel"
       },
       {
           "field": "Clicks"
       },
       {
           "field": "CTR"
       },
       {
           "field": "Is Adjustment"
       },
       {
           "field": "Adjustment Type"
       },
       {
           "field": "Spend"
       }
   ],
   "filters": [
       {
           "field": "Advertiser ID",
           "operator": "=",
           "value": 929757
       },
       {
           "field": "Campaign ID",
           "operator": "IN",
           "values": [
               331195036,
               331273097
           ]
       },
       {
           "field": "Day",
           "operator": "between",
           "from": "2014-09-01",
           "to": "2014-09-08"
       }
   ]
}

keyword_stats¶

This cube provides standard performance metrics at all entity levels of the account down to the keyword level. This cube does not include any over delivery adjustments for spend. Use this for getting metrics around keyword performance. Note that the cube does not include any over delivery spend adjustments which are available in the adjustment_stats cube.

Note

Both Search and Native data are available by applying the Source field to the cube filter.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Must be filtered	The ID of the advertiser.
Campaign ID	Dimension	Can be filtered	The ID of the campaign.
Ad Group ID	Dimension	Can be filtered	The ID of the ad group.
Ad ID	Dimension	Can be filtered	The ID of the ad.
Keyword ID	Dimension	Can be filtered	The ID of the keyword. Must be included in any query.
Destination URL	Dimension		The actual served URL post macro-expansion. Can only be requested if both Ad ID and Keyword ID are requested. Note that requesting Destination URL granularity will result in considerably longer report generation times - only request this data if you really need it.
Day	Dimension	Must be filtered	The date in YYYY-MM-DD format. Must be included in every query.
Device Type	Dimension		Device type of the user: Desktop, Tablet, Phone, Unknown. Note that Device Type data is only available after the field is launched. If you run it for a previous date, it will return NONE in the Device Type column.
Source Name	Dimension	Can be filtered. By default, the report will filter to Search traffic only.	Native, Search, or Other.
Impressions	Fact		The number of impressions.
Clicks	Fact		The number of clicks.
Post Click Conversions	Fact		The total number of post click conversions.
Post Impression Conversions	Fact		The total number of post view conversions.
Conversions	Fact		The total number of conversions, includes both post click and post view conversions. For app install campaigns the default conversion windows are 7 days post-click and 1 day post view. For website conversions the default windows are 30 days post-click and 2 days post-view.
Total Conversions	Fact		A synonym for the Conversions field (is kept for backwards compatibility).
Spend	Fact		The unadjusted spend amount. Please note that adjustments - meaning any corrections due to issues like overcharging - can be queried using the adjustment_stats cube.
Average Position	Fact		Impression weighted average position
Max Bid	Fact		Impression weighted average position.
Average CPC	Fact		The average CPC bid value.
Average CPM	Fact		The average CPM bid value.
CTR	Fact		The clickthrough rate.

Sample keyword_stats cube report request:

{
   "cube": "keyword_stats",
   "fields": [
       {
           "field": "Day"
       },
       {
           "field": "Ad Group ID"
       },
       {
           "field": "Ad ID"
       },
       {
           "field": "Keyword ID"
       },
       {
           "field": "Keyword Value",
           "alias": "Keyword"
       },
       {
           "field": "Keyword Match Type"
       },
       {
           "field": "Impressions"
       },
       {
           "field": "Clicks"
       },
       {
           "field": "Spend"
       }
   ],
   "filters": [
       {
           "field": "Advertiser ID",
           "operator": "=",
           "value": 929757
       },
       {
           "field": "Campaign ID",
           "operator": "IN",
           "values": [
               331195036,
               331273097
           ]
       },
       {
           "field": "Day",
           "operator": "between",
           "from": "2014-09-01",
           "to": "2014-09-08"
       }
   ]
}

search_stats¶

This cube contains keyword level performance data, and also allows querying for the search queries that triggered keywords and ads, as well as for keyword level performance by device. Note that the cube does not include any over delivery spend adjustments which are available in the adjustment_stats cube.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Must be filtered	The ID of the advertiser.
Campaign ID	Dimension	Can be filtered	The ID of the campaign.
Ad Group ID	Dimension	Can be filtered	The ID of the ad group.
Ad ID	Dimension	Can be filtered	The ID of the ad.
Keyword id	Dimension	Can be filtered	The id of the keyword.
Delivered Match Type	Dimension		Match type set the keyword delivered on.
Search Term	Dimension		The phrase canon user search query.
Device Type	Dimension		Device type of the user: Desktop, Tablet, Phone, Unknown.
Destination URL	Dimension		The actual served URL post macro-expansion. Can only be requested if both Ad ID and Keyword ID are requested. Note that requesting Destination URL granularity will result in considerably longer report generation times - only request this data if you really need it.
Day	Dimension	Must be filtered	The date in in YYYY-MM-DD’ format. Must be included in every query.
Impressions	Fact		The number of impressions.
Clicks	Fact		The number of clicks.
Spend	Fact		The unadjusted spend amount. Please note that adjustments - meaning any corrections due to issues like overcharging - can be queried using the adjustment_stats cube.
Conversions	Fact		The total number of conversions, includes both post click and post view conversions. For app install campaigns the default conversion windows are 7 days post-click and 1 day post view. For website conversions the default windows are 30 days post-click and 2 days post-view.
Post Click Conversions	Fact		The total number of post click conversions.
Post Impression Conversions	Fact		The total number of post view conversions.
Average Position	Fact		Impression weighted average position.
Max Bid	Fact		Maximum bid for the requested time interval.
Average CPC	Fact		The average CPC value.
CTR	Fact		The clickthrough rate.
Impression Share	Fact		Share of Impressions that the Advertiser or Campaign served to a given Keyword, after factoring in Targeting. For example, if Campaign X served 10 impressions to the keyword ‘basketball,’ and a total of 100 bidded searches occurred on ‘basketball’ during the time period selected, then Campaign X has an Impression Share of 10% for the term ‘basketball’.
Click Share	Fact		Share of Clicks that the Advertiser or Campaign received on a given Keyword, after factoring in Targeting. For example, if Campaign X had 10 Clicks to the keyword ‘basketball,’ and a total of 100 Clicks occurred on ‘basketball’ during the time period selected, then Campaign X has a Click Share of 10% for the term ‘basketball’
Conversion Share	Fact		Share of Conversions that the Advertiser or Campaign received on a given Keyword, after factoring in Targeting. For example, if Campaign X had 10 Conversions to the keyword ‘basketball,’ and a total of 100 Conversions occurred on ‘basketball’ during the time period selected, then Campaign X has a Conversion Share of 10% for the term ‘basketball’.

Sample search_stats cube report request:

 {
  "cube": "search_stats",
  "fields": [
      {
          "field": "Day"
      },
      {
          "field": "Keyword ID"
      },
      {
          "field": "Keyword Value",
          "alias": "Keyword"
      },
      {
          "field": "Search Term"
      },
      {
          "field": "Clicks"
      },
      {
          "field": "Conversions"
      },
      {
          "field": "Spend"
      }
  ],
  "filters": [
      {
          "field": "Advertiser ID",
          "operator": "=",
          "value": 929757
      },
      {
          "field": "Campaign ID",
          "operator": "IN",
          "values": [
              331195036,
              331273097
          ]
      },
      {
          "field": "Day",
          "operator": "between",
          "from": "2014-09-01",
          "to": "2014-09-08"
      }
   ]
}

ad_extension_details¶

This cube only contains search performance data that resulted from an ad extension impression. Note that the cube does not include any over delivery spend adjustments which are available in the adjustment_stats cube. Use this for getting metrics on ad extension performance.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Must be filtered	The ID of the advertiser.
Campaign ID	Dimension	Can be filtered	The ID of the campaign.
Ad Group ID	Dimension	Can be filtered	The ID of the ad group.
Ad ID	Dimension	Can be filtered	The ID of the ad.
Keyword ID	Dimension	Can be filtered	The ID of the keyword.
Ad Extn ID	Dimension	Can be filtered	The ID of the ad extension.
Device Type	Dimension	Can be filtered	Device type of the user: Desktop, Tablet, Phone, Unknown.
Month	Dimension		Month will be represented as the first day of the month in YYYY-MM-DD’ format.
Week	Dimension		Week will be represented as the first day of the week in YYYY-MM-DD’ format.
Day	Dimension	Must be filtered	The date in YYYY-MM-DD format.
Pricing Type	Dimension	Can be filtered	The pricing type.
Destination URL	Dimension		The actual served URL post macro-expansion. Can only be requested if both Ad ID and Keyword ID are requested. Note that requesting Destination URL granularity will result in considerably longer report generation times - only request this data if you really need it.
Impressions	Fact		The number of impressions.
Clicks	Fact		The number of clicks.
Conversions	Fact		The total number of conversions includes both post click and post view conversions.
Spend	Fact		The unadjusted spend amount. Please note that adjustments - meaning any corrections due to issues like overcharging - can be queried using the adjustment_stats cube.
Average Position	Fact		The impression weighted average position.
Max Bid	Fact		The maximum bid value.
Call Conversion	Fact		The total number of calls received.
Average CPC	Fact		The average CPC bid value.
Average Cost-per-install	Derived Fact		The average cost per install.
Average CPM	Derived Fact		The average cost per impression.
CTR	Fact		The clickthrough rate.
Average Call Duration	Derived Fact		The average call duration.

Important

The destination url in the report for a given ad extension id is not the definitive url that was served. One url is picked to be representative of the group.

Sample ad_extension_details cube report request:

{
  "cube": "ad_extension_details",
  "fields": [
      {
          "field": "Advertiser ID"
      },
      {
          "field": "Campaign ID"
      },
      {
          "field": "Ad Extn ID",
          "alias": "Ad Extension ID"
      },
      {
          "field": "Impressions"
      },
      {
          "field": "Clicks"
      },
      {
          "field": "CTR"
      }
  ],
  "filters": [
      {
          "field": "Advertiser ID",
          "operator": "=",
          "value": 929757
      },
      {
          "field": "Campaign ID",
          "operator": "IN",
          "values": [
              331195036,
              331273097
          ]
      },
      {
          "field": "Day",
          "operator": "between",
          "from": "2014-09-01",
          "to": "2014-09-08"
      }]
 }

call_extension_stats¶

This cube provides detailed information about click to call conversion details at account, campaign and ad group levels. Both search and native ads data are included in the response. Use this cube to get detailed information about conversions on click 2 call ad extensions.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Can be filtered	ID of the advertiser.
Campaign ID	Dimension	Can be filtered	ID of the campaign.
Ad Group ID	Dimension	Can be filtered	ID of the ad group.
Month	Dimension
Week	Dimension
Day	Dimension	Must be filtered
Caller Name	Dimension		Name of the Caller.
Caller Area Code	Dimension		Caller Area Code.
Caller Number	Dimension		Caller number.
Call Start Time	Dimension		Call Start Time in UTC.
Call End Time	Dimension		Call End Time in UTC.
Call Status	Dimension		Status of the Call Received, ANSWER/NOANSWER.
Call Duration	Dimension		Duration of the call in seconds.

Note

This cube only contains data that results from an Click To Call Ad Extension impression.

Sample call_extension_stats cube report request:

{
 "cube": "call_extension_stats",
 "fields": [

     {
         "field": "Advertiser ID"
     },
     {
         "field": "Day"
     },
     {
         "field": "Campaign ID"
     },
     {
         "field": "Ad Group ID"
     }
 ],
 "filters": [
   {
        "field": "Advertiser ID",
        "operator": "=",
        "value": 11610
   },
   {
        "field": "Campaign ID",
        "operator": "IN",
        "values": [
           336986136,
           336986133
        ]
   },
   {
        "field": "Day",
        "operator": "between",
        "from": "2016-04-27",
        "to": "2016-04-28"
   }]
}

user_stats¶

The user_stats cube is the next iteration of the audiences _stats cube, and provides a breakdown across various targeting attributes, such as age, gender, device, geo (country, state, dma, city, zip), both for the physical location of the user and the location of his or her interest.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Must be filtered	ID of the advertiser.
Campaign ID	Dimension	Can be filtered	ID of the campaign.
Audience ID	Dimension	Can be filtered	ID of the Audience that received Impressions.
Audience Name	Dimension	Can be filtered	Name of the Audience that received Impressions.
Audience Type	Dimension	Can be filtered	Type of the Audience that received Impressions [General Interest Category/Custom Audience/Custom Segment].
Audience Status	Dimension	Can be filtered	Status of the Audience that received Impressions (ON, OFF).
Ad Group ID	Dimension	Can be filtered	ID of the ad group.
Day	Dimension	Must be filtered	The date in in YYYY-MM-DD format.
Pricing Type	Dimension	Can be filtered	The pricing type.
Source Name	Dimension	Can be filtered	Native, Search or Other.
Gender	Dimension	Can be filtered	The gender of the user: F, M, or U.
Age	Dimension	Can be filtered	Age group of the user: 18-24, 25-34, 35-44, 45-54, 55-64.
Device Type	Dimension	Can be filtered	Device type of the user: Desktop, Tablet, Phone, Unknown.
Country	Dimension	Can be filtered	Name of the user’s country.
State	Dimension	Can be filtered	Name of the user’s state.
City	Dimension	Can be filtered	Name of the user’s City.
Zip	Dimension	Can be filtered	Zip code of the user.
DMA WOEID	Dimension	Can be filtered	The Where on Earth ID associated with the DMA.
City WOEID	Dimension	Can be filtered	The Where on Earth ID associated with the City.
State WOEID	Dimension	Can be filtered	The Where on Earth ID associated with the State.
Zip WOEID	Dimension	Can be filtered	The Where on Earth ID associated with the Zip Code.
Country WOEID	Dimension	Can be filtered	The Where on Earth ID associated with the Country.
Location Type	Dimension	Can be filtered	Flags whether the location listed in the report indicates the physical location of the user or the location of their intent (for Search).
Impressions	Fact		The number of impressions.
Clicks	Fact		The number of clicks.
Post Click Conversions	Fact		The total number of post click conversions.
Post Impression Conversions	Fact		The total number of post view conversions.
Conversions	Fact		The total number of conversions, which includes both post click and post view conversions. For app install campaigns, the default conversion windows are 7 days post-click and 1 day post view. For website conversions, the default windows are 30 days post-click and 2 days post-view.
Total Conversions	Fact		A synonym for the Conversions field (maintained for backwards compatibility).
Spend	Fact		The unadjusted spend amount. Note that adjustments - meaning any corrections due to issues like overcharging - can be queried using the adjustment_stats cube.
Reblogs	Derived Fact		The count of Tumblr Reblogs.
Reblog Rate	Derived Fact		The rate of Tumblr Reblogs (over Impressions).
Likes	Derived Fact		The count of Tumblr Likes.
Like Rate	Derived Fact		Rate of Tumblr Likes (over Impressions).
Follows	Derived Fact		The count of Tumblr Follows.
Follow Rate	Derived Fact		The rate of Tumblr Follows (over Impressions).
Engagements	Derived Fact		The count of total Tumblr Engagements.
Paid Engagements	Derived Fact		Total of revenue-bearing Impressions.
Engagement Rate	Derived Fact		The rate of total Tumblr Engagements (over Impressions).
Paid Engagement Rate	Derived Fact		The rate of revenue-bearing Engagements (over Impressions).”
Video Starts	Fact		The number of video starts.
Video Views	Fact		The number of video views.
Video 25% Complete	Fact		The number of times the video played to 25% of its length.
Video 50% Complete	Fact		The number of times the video played to 50% of its length.
Video 75% Complete	Fact		The number of times the video played to 75% of its length.
Video 100% Complete	Fact		The number of times the video played to 100% of its length.
Cost Per Video View	Fact		The average cost per video view.
Video Closed	Fact		The number of times the video was closed.
Video Skipped	Fact		The number of times the video was skipped.
Video after 30 seconds view	Fact		The number of times the video played longer than 30 seconds.
Ad Extn Impressions	Fact		Total impressions for which an ad extension was displayed.
Ad Extn Clicks	Fact		Total clicks on an ad extension link (rather than the main link).
Ad Extn Spend	Fact		Total spend associated to an ad extension.
Average Position	Fact		The average position of the ad.
Landing Page Type	Dimension		The landing page type.
Fact Conversion Counting	Dimension	Can be filtered	The way your conversions were counted for the campaign during the report time range (ALL_PER_INTERACTION, ONE_PER_INTERACTION).

Sample user_stats cube report request:

{
  "cube": "user_stats",
  "fields": [
      {
          "field": "Advertiser ID"
      },
      {
          "field": "Campaign ID"
      },
      {
          "field": "Source"
      },
      {
          "field": "Country"
      },
      {
          "field": "Device"
      },
      {
          "field": "Day"
      },
      {
          "field": "Impressions"
      }
  ],
  "filters": [
      {
          "field": "Advertiser ID",
          "operator": "=",
          "value": 929757
      },
      {
          "field": "Campaign ID",
          "operator": "IN",
          "values": [
              331195036,
              331273097
          ]
      },
      {
          "field": "Day",
          "operator": "between",
          "from": "2015-12-01",
          "to": "2015-12-08"
      }
  ]
}

product_ads¶

This data is available to advertisers who are running Native Product Ads campaigns. Use this to get product group as well as product level reporting. Over delivery spend adjustments are not included

Field	Type	Attributes	Description
Advertiser ID	Dim	canFilterOn	ID of the advertiser.
Campaign ID	Dim	canFilterOn	ID of the shopping campaigns.
Ad Group ID	Dim	canFilterOn	ID of the ad group.
Offer ID	Dim	canFilterOn	ID of the offer, same value as the id field in the product feed. This is the merchant-side ID of the product.
Category ID	Dim	canFilterOn	ID of the product category, foreign key to the product_categories dimension.
Category Name	Dim		The name associated with the Category ID.
Device	Dimension		SmartPhone, Tablet or Desktop.
Product Type	Dim	canFilterOn	The merchant’s own product category string, same value as the “product type” field in the product feed.
Brand	Dim	canFilterOn	Brand of the offer, same value as the “brand” field in the product feed.
Offer Group ID	Dim	canFilterOn	The id of the leaf product group node that won the auction.
Product ID	Dim	canFilterOn	The id of the product. This is the Yahoo-side ID given to the product.
Product Name	Dim	canFilterOn	The Name of the product.
Custom Label 0	Dim	canFilterOn	One of 5 different custom labels that can be applied to a Product.
Custom Label 1	Dim	canFilterOn	One of 5 different custom labels that can be applied to a Product.
Custom Label 2	Dim	canFilterOn	One of 5 different custom labels that can be applied to a Product.
Custom Label 3	Dim	canFilterOn	One of 5 different custom labels that can be applied to a Product.
Custom Label 4	Dim	canFilterOn	One of 5 different custom labels that can be applied to a Product.
Source	Dim	canFilterOn	Source=1 represents native traffic. Source=2 represents search traffic.
Device Type	Dim	canFilterOn	Device type of the user: Desktop, Tablet, Phone, Unknown.
Month	Dim	canFilterOn	Month will be represented as the first day of the month in YYYY-MM-DD’ format.
Week	Dim	canFilterOn	Week will be represented as the first day of the week in YYYY-MM-DD’ format.
Day	Dim	mustFilterOn	The date in in YYYY-MM-DD’ format.
Impressions	Fact		The number of impressions.
Clicks	Fact		The number of clicks.
Post View Conversions	Fact		The total number of post view conversions.
Post Click Conversions	Fact		The total number of post click conversions.
Total Conversions	Fact		Total number of conversions.
Spend	Fact		Total spend.
Average CPC	Fact		The average CPC value.
CTR	Fact		The clickthrough rate.

Sample product_ads cube report request:

{
  "cube": "product_ads",
  "fields": [
      {
          "field": "Advertiser ID"
      },
      {
          "field": "Campaign ID"
      },
      {
          "field": "Product Group ID"
      },
      {
          "field": "Item ID"
      },
      {
          "field": "Day"
      },
      {
          "field": "Impressions"
      },
      {
          "field": "Clicks"
      },
      {
          "field": "Average CPC"
      },
      {
          "field": "Spend"
      }
  ],
  "filters": [
      {
          "field": "Advertiser ID",
          "operator": "=",
          "value": 929757
      },
      {
          "field": "Campaign ID",
          "operator": "IN",
          "values": [
              3311225,
              3311447
          ]
      },
      {
          "field": "Day",
          "operator": "between",
          "from": "2014-04-15",
          "to": "2014-04-16"
      }
  ]
}

conversion_rules_stats¶

This cube provides a breakdown of stats by conversion rules, conversion categories, and other conversion-related info. See the Conversion Rules section for more details on creating and managing conversion rules.

Field	Type	Attributes	Description
Advertiser ID	Dim	Must be filtered	The ID of the advertiser.
Campaign ID	Dim	Can be filtered	The ID of the campaign.
Ad Group ID	Dim	Can be filtered	The ID of the ad group.
Rule ID	Dimension	Can be filtered	The id associated with the conversion rule.
Rule Name	Dimension	Can be filtered	The name associated with the conversion.
Category Name	Dimension	Can be filtered	The category associated with conversion.
Conversion Device	Dimension	Can be filtered	SmartPhone, Tablet or Desktop. This is the device the conversion event occurred on, and it can be different from the device associated with the impression or click. Device on other reports is the device associated with the impression, click events.
Keyword ID	Dimension	Can be filtered	The Id of the keyword. This will be blank for Native Campaigns.
Keyword Value	Dimension		The actual keyword.
Source Name	Dimension	Can be filtered	Native, Search or Other.
Price Type	Dimension	Can be filtered	The pricy type.
Day	Dimension	Must be filtered	The date in in YYYY-MM-DD’ format. Must be included in every query.
Post View Conversions	Fact		The total number of post view conversions.
Post Click Conversions	Fact		The total number of post click conversions.
Conversion Value	Fact		The actual value associated with the conversion event.
Post Click Conversion Value	Fact		The Conversion Value attributed to Post Click Conversions.
Post View Conversion Value	Fact		The Conversion Value attributed to Post View Conversions.
Conversions	Fact		The total number of conversions, includes both post click and post view conversions. For app install campaigns the default conversion windows are 7 days post-click and 1 day post view. For website conversions the default windows are 30 days post-click and 2 days post-view.
In App Post Click Convs	Fact		Total Post Click Conversions that occurred in the app after it was installed. These conversions occurred in the app, but were attributed to clicks made on an ad outside of the app.
In App Post View Convs	Fact		Total Post View Conversions that occurred in the app after it was installed. These conversions occurred in the app, but were attributed to impressions made on an ad outside of the app.
In App Post Install Convs	Fact		Total Post Install Conversions that occurred in the app after it was installed. These conversions occurred in the app, but were attributed to the installation made on an ad outside of the app.
Landing Page Type	Dimension		The landing page type.
Fact Conversion Counting	Dimension	Can be filtered	The way your conversions were counted for the campaign during the report time range (ALL_PER_INTERACTION, ONE_PER_INTERACTION).

Sample conversion_rules_stats cube report request:

{
  "cube": "conversion_rules_stats",
  "fields": [
      {
          "field": "Advertiser ID"
      },
      {
          "field": "Campaign ID"
      },
      {
          "field": "Ad Group ID"
      },
      {
          "field": "Day"
      },
      {
          "field": "Rule ID"
      },
      {
          "field": "Rule Name"
      },
      {
          "field": "Conversion Device"
      },
      {
          "field": "Conversion Value"
      }
  ],
  "filters": [
      {
          "field": "Advertiser ID",
          "operator": "=",
          "value": 929757
      },
      {
          "field": "Campaign ID",
          "operator": "IN",
          "values": [
              3311225,
              3311447
          ]
      },
      {
          "field": "Day",
          "operator": "between",
          "from": "2015-05-24",
          "to": "2015-05-27"
      }
  ]
}

domain_performance_stats¶

This cube has domain performance stats for all levels down to the ad group level. It is recommended to use this cube when querying for native ads campaign data.

Field	Type	Attributes	Description
Advertiser ID	Dimension	Must be filtered	The ID of the advertiser.
Clicks	Fact		The number of clicks.
Spend	Fact		The unadjusted spend amount.
Impressions	Fact		The number of impressions.
Top Domain	Dimension	Can be filtered on	The top level web domain where the ad was served.
Package Name	Dimension	Can be filtered on	The mobile package name where the ad was served.

{
  "cube": "domain_performance_stats",
  "fields": [
  { "field": "Advertiser ID" }
  ,
  { "field": "Impressions" }
  ,
  { "field": "Clicks" }
  ,
  { "field": "Spend" }
  ,
  { "field": "Top Domain" }
  ,
  { "field": "Package Name" }
  ],
 "filters": [
  { "field": "Advertiser ID", "operator": "=", "value": 1234 }
  ,
  { "field": "Campaign ID", "operator": "IN", "values": [ 3366778899, 3366778844, ] }
  ,
  { "field": "Day", "operator": "between", "from": "2020-06-25", "to": "2020-06-30" }
 ]
}