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 |
|
Group or Site |
Dimension |
The section group value. Site is no longer available. |
|
Group |
Dimension |
The native supply group, i.e., |
|
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" }
]
}