Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Account | Account name | campaign_a_account | dim | The name of the account. |
| Account ID | campaign_a_account_id | dim | The ID of the account. | |
| Account currency | campaign_a_campaign__account_currency | dim | The currency of the account. | |
| Campaign | Campaign name | campaign_a_campaign_name | dim | The name of the campaign. |
| Campaign ID | campaign_a_campaign_id | dim | A unique identifier for the campaign. | |
| Campaign type | campaign_a_campaign_type | dim | The type of campaign (e.g., search, display, sponsored products). | |
| Campaign status | campaign_a_status | dim | The current status of the campaign (e.g., active, paused, ended). | |
| Promoted brands IDs | campaign_a_promoted_brands_ids | dim | A list of the brand IDs that are being promoted in the campaign. | |
| Click attribution window | campaign_a_click_attribution_window | dim | The length of time that clicks are attributed to the campaign. | |
| View attribution window | campaign_a_view_attribution_window | dim | The length of time that views are attributed to the campaign. | |
| Budget | campaign_a_budget | dim | The total budget for the campaign. | |
| Budget spent | campaign_a_budget_spent | dim | The amount of budget that has been spent so far on the campaign. | |
| Budget remaining | campaign_a_budget_remaining | dim | The amount of budget that is still available for the campaign. | |
| Created at datetime | campaign_a_created_at | dim | The date and time when the campaign was created. | |
| Updated at datetime | campaign_a_updated_at | dim | The date and time when the campaign was last updated. | |
| Created at date | campaign_a_created_at_date | dim | The date when the campaign was created. | |
| Updated at date | campaign_a_updated_at_date | dim | The date when the campaign was last updated. | |
| Start date | campaign_a_start_date | dim | The date when the campaign will start running. | |
| End date | campaign_a_end_date | dim | The date when the campaign will stop running. | |
| Time | Year | campaign_a_campaign__year | dim | |
| Year of week (Sun-Sat) | campaign_a_campaign__year_of_week | dim | ||
| Year of week (Mon-Sun) | campaign_a_campaign__year_of_week_iso | dim | ||
| Year & month | campaign_a_campaign__year_month | dim | ||
| Month | campaign_a_campaign__month | dim | ||
| Year & week (Sun-Sat) | campaign_a_campaign__year_week | dim | ||
| Year & week (Mon-Sun) | campaign_a_campaign__year_week_iso | dim | ||
| Week (Sun-Sat) | campaign_a_campaign__week | dim | ||
| Week (Mon-Sun) | campaign_a_campaign__week_iso | dim | ||
| Day of month | campaign_a_campaign__day_of_month | dim | ||
| Day of week (Sun-Sat) | campaign_a_campaign__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | campaign_a_campaign__day_of_week_name_iso | dim | ||
| Date | campaign_a_campaign__date | dim | ||
| Datetime | campaign_a_campaign__atom | dim | ||
| Date | Impressions | campaign_a_campaign__impressions | met | The number of times your ads were displayed. |
| Clicks | campaign_a_campaign__clicks | met | The number of clicks on your ads. | |
| CTR | campaign_a_campaign__ctr | met | Click-through rate (CTR) is calculated by dividing the number of clicks by the number of impressions. | |
| Cost | campaign_a_campaign__spend | met | Total spend including any platform fees. | |
| Cost (USD) | campaign_a_campaign__spend_usd | met | Spend converted to USD. | |
| Cost (EUR) | campaign_a_campaign__spend_eur | met | Spend converted to EUR. | |
| Cost (GBP) | campaign_a_campaign__spend_gbp | met | Spend converted to GBP. | |
| CPM | campaign_a_campaign__cpm | met | Cost per mille. | |
| CPC | campaign_a_campaign__cpc | met | The average cost-per-click coming from Open Auction (CPC pricing model) campaign types. It is calculated by dividing the total click ad spend by the total number of clicks. | |
| Unique visitors | campaign_a_campaign__unique_visitors | met | The number of distinct shoppers who have been exposed to an ad in the reporting time period. Each shopper is counted only once, even if a shopper viewed an ad multiple times. Note about aggregation: It's possible that the sum of unique visitors across multiple rows does not equal the total row. E.g., the same shopper may see your ad on Monday and Wednesday. At the week level the shopper is counted as one unique visitor. But, at the day level they are counted once on Monday and once again on Wednesday. This is expected, because identifying a shopper as unique depends on the dimension level. | |
| Frequency | campaign_a_campaign__frequency | met | The average number of times an ad is displayed to the same shopper. Calculated by dividing the total number of impressions by unique visitors. | |
| Orders | campaign_a_campaign__attributed_orders | met | Attributed orders. | |
| Units | campaign_a_campaign__attributed_units | met | The number of units sold that can be attributed to your ads. | |
| Sales | campaign_a_campaign__attributed_sales | met | The revenue that can be attributed to your ads. | |
| ROAS | campaign_a_campaign__roas | met | Return on ad spend (ROAS) is calculated by dividing the number of Attributed sales by the total Ad spend. | |
| Account | Account name | line_item_a_account | dim | The name of the account. |
| Account ID | line_item_a_account_id | dim | The ID of the account. | |
| Account currency | line_item_a_line_item__account_currency | dim | The currency of the account. | |
| Line item | Line item name | line_item_a_line_item_name | dim | The name of the line item. |
| Line item ID | line_item_a_line_item_id | dim | A unique identifier for the line item. | |
| Line item type | line_item_a_line_item_type | dim | The type of line item (e.g., search, display, sponsored products). | |
| Line item status | line_item_a_status | dim | The current status of the line item (e.g., active, paused, ended). | |
| Target retailer ID | line_item_a_target_retailer_id | dim | The ID of the retailer that the line item is targeting. | |
| Budget | line_item_a_budget | dim | The total budget for the line item. | |
| Budget spent | line_item_a_budget_spent | dim | The amount of budget that has been spent so far on the line item. | |
| Budget remaining | line_item_a_budget_remaining | dim | The amount of budget that is still available for the line item. | |
| Created at | line_item_a_created_at | dim | The date and time when the line item was created. | |
| Updated at | line_item_a_updated_at | dim | The date and time when the line item was last updated. | |
| Created at date | line_item_a_created_at_date | dim | The date when the campaign was created. | |
| Updated at date | line_item_a_updated_at_date | dim | The date when the campaign was last updated. | |
| Start date | line_item_a_start_date | dim | The date when the line item will start running. | |
| End date | line_item_a_end_date | dim | The date when the line item will stop running. | |
| Time | Year | line_item_a_line_item__year | dim | |
| Year of week (Sun-Sat) | line_item_a_line_item__year_of_week | dim | ||
| Year of week (Mon-Sun) | line_item_a_line_item__year_of_week_iso | dim | ||
| Year & month | line_item_a_line_item__year_month | dim | ||
| Month | line_item_a_line_item__month | dim | ||
| Year & week (Sun-Sat) | line_item_a_line_item__year_week | dim | ||
| Year & week (Mon-Sun) | line_item_a_line_item__year_week_iso | dim | ||
| Week (Sun-Sat) | line_item_a_line_item__week | dim | ||
| Week (Mon-Sun) | line_item_a_line_item__week_iso | dim | ||
| Day of month | line_item_a_line_item__day_of_month | dim | ||
| Day of week (Sun-Sat) | line_item_a_line_item__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | line_item_a_line_item__day_of_week_name_iso | dim | ||
| Date | line_item_a_line_item__date | dim | ||
| Datetime | line_item_a_line_item__atom | dim | ||
| Campaign | Campaign name | line_item_a_line_item__campaign_name | dim | Campaign name of the requested report. |
| Campaign ID | line_item_a_line_item__campaign_id | dim | Campaign ID of the requested report. | |
| Retailer | Retailer name | line_item_a_line_item__retailer_name | dim | Retailer name of the requested report. |
| Retailer ID | line_item_a_line_item__retailer_id | dim | Retailer ID of the requested report. | |
| Impressions | line_item_a_line_item__impressions | met | The number of times your ads were displayed. | |
| Clicks | line_item_a_line_item__clicks | met | The number of clicks on your ads. | |
| CTR | line_item_a_line_item__ctr | met | Click-through rate (CTR) is calculated by dividing the number of clicks by the number of impressions. | |
| Cost | line_item_a_line_item__spend | met | Total spend including any platform fees. | |
| Cost (USD) | line_item_a_line_item__spend_usd | met | Spend converted to USD. | |
| Cost (EUR) | line_item_a_line_item__spend_eur | met | Spend converted to EUR. | |
| Cost (GBP) | line_item_a_line_item__spend_gbp | met | Spend converted to GBP. | |
| CPM | line_item_a_line_item__cpm | met | Cost per mille. | |
| CPC | line_item_a_line_item__cpc | met | The average cost-per-click coming from Open Auction (CPC pricing model) campaign types. It is calculated by dividing the total click ad spend by the total number of clicks. | |
| Unique visitors | line_item_a_line_item__unique_visitors | met | The number of distinct shoppers who have been exposed to an ad in the reporting time period. Each shopper is counted only once, even if a shopper viewed an ad multiple times. Note about aggregation: It's possible that the sum of unique visitors across multiple rows does not equal the total row. E.g., the same shopper may see your ad on Monday and Wednesday. At the week level the shopper is counted as one unique visitor. But, at the day level they are counted once on Monday and once again on Wednesday. This is expected, because identifying a shopper as unique depends on the dimension level. | |
| Frequency | line_item_a_line_item__frequency | met | The average number of times an ad is displayed to the same shopper. Calculated by dividing the total number of impressions by unique visitors. | |
| Orders | line_item_a_line_item__attributed_orders | met | Attributed orders. | |
| Units | line_item_a_line_item__attributed_units | met | The number of units sold that can be attributed to your ads. | |
| Sales | line_item_a_line_item__attributed_sales | met | The revenue that can be attributed to your ads. | |
| ROAS | line_item_a_line_item__roas | met | Return on ad spend (ROAS) is calculated by dividing the number of Attributed sales by the total Ad spend. | |
| Assisted sales | line_item_a_line_item__assisted_sales | met | Assisted sales. | |
| Assisted units | line_item_a_line_item__assisted_units | met | Assisted units. | |
| Account | Account name | product_a_account | dim | The name of the account. |
| Account ID | product_a_account_id | dim | The ID of the account. | |
| Account currency | product_a_product__account_currency | dim | The currency of the account. | |
| Campaign | Campaign name | product_a_campaign_name | dim | The name of the campaign. |
| Campaign ID | product_a_campaign_id | dim | A unique identifier for the campaign. | |
| Campaign type | product_a_campaign_type | dim | The type of campaign (e.g., search, display, sponsored products). | |
| Campaign status | product_a_status | dim | The current status of the campaign (e.g., active, paused, ended). | |
| Promoted brands IDs | product_a_promoted_brands_ids | dim | A list of the brand IDs that are being promoted in the campaign. | |
| Click attribution window | product_a_click_attribution_window | dim | The length of time that clicks are attributed to the campaign. | |
| View attribution window | product_a_view_attribution_window | dim | The length of time that views are attributed to the campaign. | |
| Budget | product_a_budget | dim | The total budget for the campaign. | |
| Budget spent | product_a_budget_spent | dim | The amount of budget that has been spent so far on the campaign. | |
| Budget remaining | product_a_budget_remaining | dim | The amount of budget that is still available for the campaign. | |
| Created at datetime | product_a_created_at | dim | The date and time when the campaign was created. | |
| Updated at datetime | product_a_updated_at | dim | The date and time when the campaign was last updated. | |
| Created at date | product_a_created_at_date | dim | The date when the campaign was created. | |
| Updated at date | product_a_updated_at_date | dim | The date when the campaign was last updated. | |
| Start date | product_a_start_date | dim | The date when the campaign will start running. | |
| End date | product_a_end_date | dim | The date when the campaign will stop running. | |
| Time | Year | product_a_product__year | dim | |
| Year of week (Sun-Sat) | product_a_product__year_of_week | dim | ||
| Year of week (Mon-Sun) | product_a_product__year_of_week_iso | dim | ||
| Year & month | product_a_product__year_month | dim | ||
| Month | product_a_product__month | dim | ||
| Year & week (Sun-Sat) | product_a_product__year_week | dim | ||
| Year & week (Mon-Sun) | product_a_product__year_week_iso | dim | ||
| Week (Sun-Sat) | product_a_product__week | dim | ||
| Week (Mon-Sun) | product_a_product__week_iso | dim | ||
| Day of month | product_a_product__day_of_month | dim | ||
| Day of week (Sun-Sat) | product_a_product__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | product_a_product__day_of_week_name_iso | dim | ||
| Date | product_a_product__date | dim | ||
| Datetime | product_a_product__atom | dim | ||
| Brand & Product | Brand ID | product_a_product__brand_id | dim | Advertised product brand ID. |
| Brand name | product_a_product__brand_name | dim | Advertised product brand name; names are standardized across retailers. | |
| Advertised product ID | product_a_product__adv_product_id | dim | Advertised product ID; this references the same ID used in Catalogs. | |
| Advertised product name | product_a_product__adv_product_name | dim | Advertised product name. | |
| Advertised product category | product_a_product__adv_product_category | dim | Category of product advertised; categories are standardized across brands and retailers, which may differ from retailer-specific categories. | |
| Impressions | product_a_product__impressions | met | The number of times your ads were displayed. | |
| Clicks | product_a_product__clicks | met | The number of clicks on your ads. | |
| CTR | product_a_product__ctr | met | Click-through rate (CTR) is calculated by dividing the number of clicks by the number of impressions. | |
| Cost | product_a_product__spend | met | Total spend including any platform fees. | |
| Cost (USD) | product_a_product__spend_usd | met | Spend converted to USD. | |
| Cost (EUR) | product_a_product__spend_eur | met | Spend converted to EUR. | |
| Cost (GBP) | product_a_product__spend_gbp | met | Spend converted to GBP. | |
| CPM | product_a_product__cpm | met | Cost per mille. | |
| CPC | product_a_product__cpc | met | The average cost-per-click coming from Open Auction (CPC pricing model) campaign types. It is calculated by dividing the total click ad spend by the total number of clicks. | |
| Orders | product_a_product__attributed_orders | met | Attributed orders. | |
| Units | product_a_product__attributed_units | met | The number of units sold that can be attributed to your ads. | |
| Sales | product_a_product__attributed_sales | met | The revenue that can be attributed to your ads. | |
| ROAS | product_a_product__roas | met | Return on ad spend (ROAS) is calculated by dividing the number of Attributed sales by the total Ad spend. | |
| Account | Account name | page_type_a_account | dim | The name of the account. |
| Account ID | page_type_a_account_id | dim | The ID of the account. | |
| Account currency | page_type_a_page_type__account_currency | dim | The currency of the account. | |
| Campaign | Campaign name | page_type_a_campaign_name | dim | The name of the campaign. |
| Campaign ID | page_type_a_campaign_id | dim | A unique identifier for the campaign. | |
| Campaign type | page_type_a_campaign_type | dim | The type of campaign (e.g., search, display, sponsored products). | |
| Campaign status | page_type_a_status | dim | The current status of the campaign (e.g., active, paused, ended). | |
| Promoted brands IDs | page_type_a_promoted_brands_ids | dim | A list of the brand IDs that are being promoted in the campaign. | |
| Click attribution window | page_type_a_click_attribution_window | dim | The length of time that clicks are attributed to the campaign. | |
| View attribution window | page_type_a_view_attribution_window | dim | The length of time that views are attributed to the campaign. | |
| Budget | page_type_a_budget | dim | The total budget for the campaign. | |
| Budget spent | page_type_a_budget_spent | dim | The amount of budget that has been spent so far on the campaign. | |
| Budget remaining | page_type_a_budget_remaining | dim | The amount of budget that is still available for the campaign. | |
| Created at datetime | page_type_a_created_at | dim | The date and time when the campaign was created. | |
| Updated at datetime | page_type_a_updated_at | dim | The date and time when the campaign was last updated. | |
| Created at date | page_type_a_created_at_date | dim | The date when the campaign was created. | |
| Updated at date | page_type_a_updated_at_date | dim | The date when the campaign was last updated. | |
| Start date | page_type_a_start_date | dim | The date when the campaign will start running. | |
| End date | page_type_a_end_date | dim | The date when the campaign will stop running. | |
| Time | Year | page_type_a_page_type__year | dim | |
| Year of week (Sun-Sat) | page_type_a_page_type__year_of_week | dim | ||
| Year of week (Mon-Sun) | page_type_a_page_type__year_of_week_iso | dim | ||
| Year & month | page_type_a_page_type__year_month | dim | ||
| Month | page_type_a_page_type__month | dim | ||
| Year & week (Sun-Sat) | page_type_a_page_type__year_week | dim | ||
| Year & week (Mon-Sun) | page_type_a_page_type__year_week_iso | dim | ||
| Week (Sun-Sat) | page_type_a_page_type__week | dim | ||
| Week (Mon-Sun) | page_type_a_page_type__week_iso | dim | ||
| Day of month | page_type_a_page_type__day_of_month | dim | ||
| Day of week (Sun-Sat) | page_type_a_page_type__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | page_type_a_page_type__day_of_week_name_iso | dim | ||
| Date | page_type_a_page_type__date | dim | ||
| Datetime | page_type_a_page_type__atom | dim | ||
| Page type | Page type | page_type_a_page_type__page_type_name | dim | Type of retailer web page an ad creative rendered on, such as home page, browse pages, search pages, product detail pages, checkout pages etc.. |
| Impressions | page_type_a_page_type__impressions | met | The number of times your ads were displayed. | |
| Clicks | page_type_a_page_type__clicks | met | The number of clicks on your ads. | |
| CTR | page_type_a_page_type__ctr | met | Click-through rate (CTR) is calculated by dividing the number of clicks by the number of impressions. | |
| Cost | page_type_a_page_type__spend | met | Total spend including any platform fees. | |
| Cost (USD) | page_type_a_page_type__spend_usd | met | Spend converted to USD. | |
| Cost (EUR) | page_type_a_page_type__spend_eur | met | Spend converted to EUR. | |
| Cost (GBP) | page_type_a_page_type__spend_gbp | met | Spend converted to GBP. | |
| CPM | page_type_a_page_type__cpm | met | Cost per mille. | |
| CPC | page_type_a_page_type__cpc | met | The average cost-per-click coming from Open Auction (CPC pricing model) campaign types. It is calculated by dividing the total click ad spend by the total number of clicks. | |
| Orders | page_type_a_page_type__attributed_orders | met | Attributed orders. | |
| Units | page_type_a_page_type__attributed_units | met | The number of units sold that can be attributed to your ads. | |
| Sales | page_type_a_page_type__attributed_sales | met | The revenue that can be attributed to your ads. | |
| ROAS | page_type_a_page_type__roas | met | Return on ad spend (ROAS) is calculated by dividing the number of Attributed sales by the total Ad spend. | |
| Account | Account name | keyword_a_account | dim | The name of the account. |
| Account ID | keyword_a_account_id | dim | The ID of the account. | |
| Account currency | keyword_a_keyword__account_currency | dim | The currency of the account. | |
| Campaign | Campaign name | keyword_a_campaign_name | dim | The name of the campaign. |
| Campaign ID | keyword_a_campaign_id | dim | A unique identifier for the campaign. | |
| Campaign type | keyword_a_campaign_type | dim | The type of campaign (e.g., search, display, sponsored products). | |
| Campaign status | keyword_a_status | dim | The current status of the campaign (e.g., active, paused, ended). | |
| Promoted brands IDs | keyword_a_promoted_brands_ids | dim | A list of the brand IDs that are being promoted in the campaign. | |
| Click attribution window | keyword_a_click_attribution_window | dim | The length of time that clicks are attributed to the campaign. | |
| View attribution window | keyword_a_view_attribution_window | dim | The length of time that views are attributed to the campaign. | |
| Budget | keyword_a_budget | dim | The total budget for the campaign. | |
| Budget spent | keyword_a_budget_spent | dim | The amount of budget that has been spent so far on the campaign. | |
| Budget remaining | keyword_a_budget_remaining | dim | The amount of budget that is still available for the campaign. | |
| Created at datetime | keyword_a_created_at | dim | The date and time when the campaign was created. | |
| Updated at datetime | keyword_a_updated_at | dim | The date and time when the campaign was last updated. | |
| Created at date | keyword_a_created_at_date | dim | The date when the campaign was created. | |
| Updated at date | keyword_a_updated_at_date | dim | The date when the campaign was last updated. | |
| Start date | keyword_a_start_date | dim | The date when the campaign will start running. | |
| End date | keyword_a_end_date | dim | The date when the campaign will stop running. | |
| Time | Year | keyword_a_keyword__year | dim | |
| Year of week (Sun-Sat) | keyword_a_keyword__year_of_week | dim | ||
| Year of week (Mon-Sun) | keyword_a_keyword__year_of_week_iso | dim | ||
| Year & month | keyword_a_keyword__year_month | dim | ||
| Month | keyword_a_keyword__month | dim | ||
| Year & week (Sun-Sat) | keyword_a_keyword__year_week | dim | ||
| Year & week (Mon-Sun) | keyword_a_keyword__year_week_iso | dim | ||
| Week (Sun-Sat) | keyword_a_keyword__week | dim | ||
| Week (Mon-Sun) | keyword_a_keyword__week_iso | dim | ||
| Day of month | keyword_a_keyword__day_of_month | dim | ||
| Day of week (Sun-Sat) | keyword_a_keyword__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | keyword_a_keyword__day_of_week_name_iso | dim | ||
| Date | keyword_a_keyword__date | dim | ||
| Datetime | keyword_a_keyword__atom | dim | ||
| Keyword | Keyword | keyword_a_keyword__keyword | dim | Keyword. |
| Impressions | keyword_a_keyword__impressions | met | The number of times your ads were displayed. | |
| Clicks | keyword_a_keyword__clicks | met | The number of clicks on your ads. | |
| CTR | keyword_a_keyword__ctr | met | Click-through rate (CTR) is calculated by dividing the number of clicks by the number of impressions. | |
| Cost | keyword_a_keyword__spend | met | Total spend including any platform fees. | |
| Cost (USD) | keyword_a_keyword__spend_usd | met | Spend converted to USD. | |
| Cost (EUR) | keyword_a_keyword__spend_eur | met | Spend converted to EUR. | |
| Cost (GBP) | keyword_a_keyword__spend_gbp | met | Spend converted to GBP. | |
| CPM | keyword_a_keyword__cpm | met | Cost per mille. | |
| CPC | keyword_a_keyword__cpc | met | The average cost-per-click coming from Open Auction (CPC pricing model) campaign types. It is calculated by dividing the total click ad spend by the total number of clicks. | |
| Orders | keyword_a_keyword__attributed_orders | met | Attributed orders. | |
| Units | keyword_a_keyword__attributed_units | met | The number of units sold that can be attributed to your ads. | |
| Sales | keyword_a_keyword__attributed_sales | met | The revenue that can be attributed to your ads. | |
| ROAS | keyword_a_keyword__roas | met | Return on ad spend (ROAS) is calculated by dividing the number of Attributed sales by the total Ad spend. | |
| Account | Account name | attributed_transaction_a_account | dim | The name of the account. |
| Account ID | attributed_transaction_a_account_id | dim | The ID of the account. | |
| Campaign | Campaign name | attributed_transaction_a_campaign_name | dim | The name of the campaign. |
| Campaign ID | attributed_transaction_a_campaign_id | dim | A unique identifier for the campaign. | |
| Time | Year | attributed_transaction_a_attributed_transaction__year | dim | |
| Year of week (Sun-Sat) | attributed_transaction_a_attributed_transaction__year_of_week | dim | ||
| Year of week (Mon-Sun) | attributed_transaction_a_attributed_transaction__year_of_week_iso | dim | ||
| Year & month | attributed_transaction_a_attributed_transaction__year_month | dim | ||
| Month | attributed_transaction_a_attributed_transaction__month | dim | ||
| Year & week (Sun-Sat) | attributed_transaction_a_attributed_transaction__year_week | dim | ||
| Year & week (Mon-Sun) | attributed_transaction_a_attributed_transaction__year_week_iso | dim | ||
| Week (Sun-Sat) | attributed_transaction_a_attributed_transaction__week | dim | ||
| Week (Mon-Sun) | attributed_transaction_a_attributed_transaction__week_iso | dim | ||
| Day of month | attributed_transaction_a_attributed_transaction__day_of_month | dim | ||
| Day of week (Sun-Sat) | attributed_transaction_a_attributed_transaction__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | attributed_transaction_a_attributed_transaction__day_of_week_name_iso | dim | ||
| Date | attributed_transaction_a_attributed_transaction__date | dim | ||
| Datetime | attributed_transaction_a_attributed_transaction__atom | dim | ||
| Advertisement date | attributed_transaction_a_attributed_transaction__adv_date | dim | Date of advertisement. | |
| Advertised hour | attributed_transaction_a_attributed_transaction__adv_hour | dim | Hour of advertisement. | |
| Purchased date | attributed_transaction_a_attributed_transaction__purchased_date | dim | Date of the attributed product purchase. | |
| Purchased hour | attributed_transaction_a_attributed_transaction__purchased_hour | dim | Hour of the attributed product purchase. | |
| Days difference | attributed_transaction_a_attributed_transaction__days_difference | dim | Days between advertisement and purchase. | |
| Ad delivery | Line item name | attributed_transaction_a_attributed_transaction__line_item_name | dim | Line item name of the requested report. |
| Line item ID | attributed_transaction_a_attributed_transaction__line_item_id | dim | Line item ID of the requested report. | |
| Retailer name | attributed_transaction_a_attributed_transaction__retailer_name | dim | Retailer name of the retailer the line item served on. | |
| Page type | attributed_transaction_a_attributed_transaction__page_type_name | dim | Type of retailer web page an ad creative rendered on, such as home page, browse pages, search pages, product detail pages, checkout pages etc.. | |
| Keyword | attributed_transaction_a_attributed_transaction__keyword | dim | Keyword or phrase used to land on the search page where an ad creative rendered. | |
| Attribution | Advertisement engagement | attributed_transaction_a_attributed_transaction__adv_engagement | dim | Type of ad engagement the purchase was attributed to. |
| Advertisement to purchased product relationship | attributed_transaction_a_attributed_transaction__adv_to_purchased_product_relationship | dim | Attribution rule used to match the impression or click to a sale. | |
| Sales channel | attributed_transaction_a_attributed_transaction__sales_channel | dim | Sales channel the attributed purchase was made through. | |
| Attribution window | attributed_transaction_a_attributed_transaction__attribution_window | dim | Click and view attribution window of the requested report. | |
| Product | Advertised product name | attributed_transaction_a_attributed_transaction__adv_product_name | dim | Advertised product name. |
| Advertised product ID | attributed_transaction_a_attributed_transaction__adv_product_id | dim | Advertised product ID; this references the same ID used in Catalogs. | |
| Advertised product category | attributed_transaction_a_attributed_transaction__adv_product_category | dim | Category of product advertised; categories are standardized across brands and retailers, which may differ from retailer-specific categories. | |
| Advertised product GTIN | attributed_transaction_a_attributed_transaction__adv_product_gtin | dim | Advertised product Global Trade Item Number (GTIN), if available; also known as European Article Number (EAN) or Universal Product Code (UPC). | |
| Advertised product MPN | attributed_transaction_a_attributed_transaction__adv_product_mpn | dim | Advertised product Manufacturer Part Number (MPN), if available. | |
| Purchased product name | attributed_transaction_a_attributed_transaction__purchased_product_name | dim | Purchased product name. | |
| Purchased product ID | attributed_transaction_a_attributed_transaction__purchased_product_id | dim | Purchased product ID; this references the same ID used in Catalogs. | |
| Purchased product category | attributed_transaction_a_attributed_transaction__purchased_product_category | dim | Category of product purchased; categories are standardized across brands and retailers, which may differ from retailer-specific categories. | |
| Purchased product GTIN | attributed_transaction_a_attributed_transaction__purchased_product_gtin | dim | Purchased product Global Trade Item Number (GTIN), if available; also known as European Article Number (EAN) or Universal Product Code (UPC). | |
| Purchased product MPN | attributed_transaction_a_attributed_transaction__purchased_product_mpn | dim | Purchased product Manufacturer Part Number (MPN), if available. | |
| Attributed sales | attributed_transaction_a_attributed_transaction__attributed_sales | met | Sales revenue attributed to a click or impression. | |
| Attributed units | attributed_transaction_a_attributed_transaction__attributed_units | met | Units sold attributed to a click or impression. |