Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | |
| Year of week (Sun-Sat) | yearOfWeek | dim | ||
| Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | weekIso | dim | ||
| Day of month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| Date | date | dim | ||
| MARKETER | Account ID | marketer_id | dim | Marketer's ID |
| Account | marketer_name | dim | Marketer's name | |
| Account currency | marketer_currency | dim | Marketer's currency | |
| Is account enabled | is_marketer_enabled | dim | Indicates whether the marketer is enabled | |
| Account created date | marketer_created_at | dim | The date when the Marketer was created | |
| CAMPAIGN | Campaign ID | campaign_id | dim | Campaign ID |
| Campaign name | campaign_name | dim | Campaign name | |
| Is campaign enabled | is_campaign_enabled | dim | Indicates whether the campaign is enabled | |
| Campaign CPC | campaign_cpc | dim | Cost per click | |
| Min. campaign CPC | campaign_min_cpc | dim | The minimal possible cost per click | |
| Campaign budget currency | campaign_currency | dim | The currency of the Budget | |
| Is campaign archived | is_campaign_archived | dim | Indicates whether the campaign is archived | |
| Expiration of promoted links | campaign_expiration_of_promoted_links | dim | A number specifying within how many days promoted links are expired | |
| Content type | campaign_content_type | dim | The content type of campaign | |
| Campaign updated date | campaign_updated_at | dim | The date when the campaign was last modified | |
| Campaign created date | campaign_created_at | dim | The date when the campaign was created | |
| Campaign start time | campaign_start_time | dim | Time of the day when this campaign should start | |
| Campaign optimization type | campaign_optimization_type | dim | The campaign optimization type | |
| Campaign On Air type | campaign_on_air_type | dim | Represents the scheduling type for the campaign to be On Air | |
| Is campaign On Air | is_campaign_on_air | dim | Indicates whether the campaign is On Air | |
| Campaign On Air reason | campaign_on_air_reason | dim | Indicates a meaningful reason in case the campaign is On Air | |
| BUDGET | Budget ID | budget_id | dim | The ID of the budget |
| Budget name | budget_name | dim | The name of the budget | |
| Is shared budget | is_budget_shared | dim | Whether the budget is shared between Campaigns or not | |
| Budget amount | budget_amount | dim | The monetary amount of the budget | |
| Budget currency | budget_currency | dim | The currency denomination applied to the budget amount | |
| Budget remaining | budget_amount_remaining | dim | The unspent monetary amount remaining on the budget | |
| Budget spent | budget_amount_spent | dim | The spent monetary amount of the budget | |
| Budget created date | budget_created_at | dim | The time when the budget was created | |
| Budget updated date | budget_updated_at | dim | The last modification date of the budget | |
| Budget start date | budget_start_date | dim | The date the budget is scheduled to begin spending | |
| Budget end date | budget_end_date | dim | The date the budget is scheduled to stop spending | |
| Budget runs forever | budget_runs_forever | dim | Whether the budged has an end date or not | |
| Budget refresh period | budget_type | dim | Budget refresh period CAMPAIGN/MONTHLY/DAILY | |
| Budget spending pace | budget_pacing | dim | Controls how fast the budget will be spent SPEND_ASAP/AUTOMATIC/DAILY_TARGET | |
| Budgets daily target | budget_daily_target | dim | The maximum amount of spend that is allowed per day | |
| Budgets allowed maximum amount | budget_maximum_amount | dim | The maximum amount allowed | |
| PLATFORM | Platform type | platform_type | dim | Platform type |
| Platform OS | platform_breakdown_os | dim | Platform result breakdown by operating system | |
| Platform browser | platform_breakdown_browser | dim | Platform result breakdown by browser | |
| PROMOTED LINK | Promoted link ID | promoted_link_id | dim | The ID of the promoted link |
| Promoted link text | promoted_link_text | dim | The text of the promoted link | |
| Promoted link updated date | promoted_link_updated_at | dim | The date when the promoted link was last modified | |
| Promoted link created date | promoted_link_created_at | dim | The date when the promoted link was created | |
| Promoted link URL | promoted_link_url | dim | The URL visitors will be sent to upon clicking the promoted link | |
| Promoted link section name | promoted_link_section_name | dim | The section name of the site the promoted link URL points to | |
| Promoted link status | promoted_link_approval_status | dim | The approval status of the promoted link | |
| Promoted link rejection reasons | promoted_link_approval_status_reasons | dim | The rejection reasons of the promoted link | |
| Is promoted link editable | is_promoted_link_editable | dim | Indicated whether the promoted link is editable | |
| Promoted link image url | promoted_link_image_url | dim | The URL of the promoted link image | |
| Is promoted link enabled | is_promoted_link_enabled | dim | Designates whether this promoted link will be served | |
| Is promoted link archived | is_promoted_link_archived | dim | Designates whether this promoted link is archived | |
| Promoted link language | promoted_link_lang | dim | The 2-letter code for the language of this promoted link | |
| Promoted link CPC adjustment | promoted_link_cpc_adjustment | dim | Cost Per Click adjustment bid based on the campaign's CPC | |
| Promoted link base URL | promoted_link_base_url | dim | The URL that the promoted link was created with | |
| Promoted link document ID | promoted_link_document_id | dim | The ID of the document to which this promoted link belongs | |
| Is promoted link On Air | is_promoted_link_on_air | dim | Indicates whether the promoted link is On Air (can be served) | |
| Promoted link On Air reason | promoted_link_on_air_reason | dim | Indicates a meaningful reason in case the On Air property is false | |
| PUBLISHER | Publisher ID | publisher_id | dim | The ID of the publisher |
| Publisher name | publisher_name | dim | The name of the publisher | |
| Publisher site URL | publisher_url | dim | URL of the publisher site | |
| Publisher blocking status | publisher_blocking_status | dim | Blocking status of the publisher | |
| Publisher is OEN | is_publisher_oen | dim | Whether this publisher is OEN (Outbrain Extended Network) publisher | |
| SECTION | Section ID | section_id | dim | The ID of the section |
| Section name | section_name | dim | The name of the section | |
| Section site URL | section_url | dim | URL of the section site | |
| Section blocking status | section_block_status | dim | Blocking status of the section | |
| Section is OEN | is_section_oen | dim | Whether this section is OEN (Outbrain Extended Network) section | |
| GEO | Country name | geo_breakdown_country_name | dim | Breakdown by country name |
| Country code | geo_breakdown_country_code | dim | Breakdown by country code | |
| Region name | geo_breakdown_region_name | dim | Breakdown by region name | |
| Region code | geo_breakdown_region_code | dim | Breakdown by region code | |
| DMA name | geo_breakdown_dma_name | dim | Breakdown by designated market area name | |
| DMA code | geo_breakdown_dma_code | dim | Breakdown by designated market area code | |
| CONVERSIONS | Performance conversion name | performance_conversion_name | dim | The conversion pixel name |
| DEPRECATED | Promoted link CPC | promoted_link_cpc | dim | Cost Per Click. Please note that this field will be removed on 2020-04-20 |
| CPC per ad enabled | is_campaign_cpc_per_ad_enabled | dim | Indicates whether or not the "CPC Per Ad" feature is enabled for this campaign. Please note that this field will be removed on 2020-04-20 | |
| PERFORMANCE | Impressions | impressions | met | Total number of promoted links impressions |
| Clicks | clicks | met | Total promoted links clicks | |
| CTR | ctr | met | The average CTR (Click Through Rate) percentage | |
| CPM | cpm | met | Cost per thousand impressions, average cost to have your ad served 1000 times | |
| Spend | spend | met | The total amount of money spent | |
| Spend (USD) | spend_usd | met | The total amount of money spent in USD | |
| Spend (EUR) | spend_eur | met | The total amount of money spent in EUR | |
| Spend (GBP) | spend_gbp | met | The total amount of money spent in GBP | |
| Clicks CPA | clicks_cpa | met | The average CPA (Cost Per Acquisition) calculated for conversions from clicks | |
| Total CPA | total_cpa | met | The average CPA (Cost Per Acquisition) calculated for all conversions | |
| Effective CPC | ecpc | met | The effective (calculated) average CPC (Cost Per Click) | |
| Total conversions | total_conversions | met | The total number of conversions calculated | |
| Click conversions | clicks_conversions | met | The total number of conversions from clicks calculated | |
| View-through conversions | view_conversions | met | The total number of view-through conversions calculated | |
| Conversion rate | conversion_rate | met | The average rate of conversions from clicks per click percentage | |
| View-through conversions rate | view_conversion_rate | met | The average rate of view-through conversions per viewable impression percentage | |
| Total conversions amount | total_sum_value | met | The total amount of money reported for all conversions | |
| Total click conversion amount | clicks_sum_value | met | The total amount of money reported for conversions from clicks | |
| Total view-through conversion amount | view_sum_value | met | The total amount of money reported for view-through conversions | |
| Average conversion amount | total_average_value | met | The average amount of money reported for all conversions | |
| Average click conversion amount | clicks_average_value | met | The average amount of money reported for conversions from clicks | |
| Average view-through conversion amount | view_average_value | met | The average amount of money reported for view-through conversions |