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