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 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 Conversions 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 Conversions 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 Conversions 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).

Sample performance_stats cube report request:

{
   "cube": "performance_stats",
   "fields": [
       {
           "field": "Ad ID"
       },
       {
           "field": "Day"
       },
       {
           "field": "Impressions"
       },
       {
           "field": "Clicks"
       },
       {
           "field": "CTR"
       },
       {
           "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"
       }
   ]
}

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 date in YYYY-MM-DD format. Either Day, Week or Month must be queried.
External Site Name Dimension   The site name where the ad was displayed.
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.

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.

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"
      }
   ]
}

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 Conversions 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 Conversions 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 Conversions 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).

Sample performance_stats cube report request:

{
   "cube": "product_ad_performance_stats",
   "fields": [
       {
           "field": "Product Ad ID"
       },
       {
           "field": "Day"
       },
       {
           "field": "Impressions"
       },
       {
           "field": "Clicks"
       },
       {
           "field": "CTR"
       },
       {
           "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"
       }
   ]
}

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.

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 Gemini 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 Impression Conversion Value Fact   The Conversion Value attributed to Post Impression 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 Conversions 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 Conversions 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 Conversions 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.

Sample conversion_rules_stats cube report request:

{
  "cube": "conversion_rules_stats",
  "fields": [
      {
          "field": "Advertiser ID"
      },
      {
          "field": "Campaign ID"
      },
      {
          "field": "Ad Group ID"
      },
      {
          "field": "Product 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"
      }
  ]
}

lead_gen_stats

This cube provides detailed information about Lead Generation details at the account, campaign, ad group and ad levels. Both search and native ads data are included in the response. Use this cube to get detailed information about Lead Gen Ad Format by displaying  username, phone number and email

Field Type Attributes Description
Advertiser ID Dimension canFilterOn The ID of the advertiser.
Campaign ID Dimension canFilterOn The ID of the campaign.
Ad Group ID Dimension canFilterOn The ID of the ad group.
Ad ID Dimension canFilterOn The ID of the ad.
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 mustFilterOn The date in in YYYY-MM-DD format.
Name Dimension   The user name.
Phone Number Dimension   The user phone number.
Email Dimension   The user email.

Note

This cube only contains data that resulted from an Lead Gen Ad Extension impression.


Sample lead_gen_stats cube report request:

{
"cube": "lead_gen_stats",
"fields": [

      {
        "field":"Day"
      },
      {
        "field":"Source"
      },
      {
        "field":"Advertiser ID"
      },
      {
        "field":"Campaign ID"
      },
      {
        "field":"Ad Group ID"
      },
      {
        "field":"Ad ID"
      },
      {
        "field":"Name"
      },
      {
        "field":"Phone Number"
      },
      {
        "field":"Email"
      }

],
"filters": [
    {
       "field": "Advertiser ID","operator": "=","value": 11610
    },
    {
       "field": "Day","operator": "between","from": "2016-04-27","to": "2016-04-28"
    }
 ]
}