Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | campaign_year | dim | |
| Year of week (Sun-Sat) | campaign_year_of_week | dim | ||
| Year of week (Mon-Sun) | campaign_year_of_week_iso | dim | ||
| Year & month | campaign_year_month | dim | ||
| Month | campaign_month | dim | ||
| Year & week (Sun-Sat) | campaign_year_week | dim | ||
| Year & week (Mon-Sun) | campaign_year_week_iso | dim | ||
| Week (Sun-Sat) | campaign_week | dim | ||
| Week (Mon-Sun) | campaign_week_iso | dim | ||
| Day of month | campaign_day_of_month | dim | ||
| Day of week (Sun-Sat) | campaign_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | campaign_day_of_week_name_iso | dim | ||
| Date | campaign_date | dim | ||
| Datetime | campaign_atom | dim | ||
| Account | Account ID | campaign_account_id | dim | A number that identifies your account. It will be automatically assigned when the account is created. |
| Account name | campaign_account_name | dim | Name of the account. The account name must be the same as the website owner (company name, trade name, etc.) that can be seen on the site that is displayed when the ad is clicked. | |
| Campaign | Campaign ID | campaign_campaign_id | dim | A number to identify the campaign. It will be automatically assigned when the campaign is created. |
| Campaign name | campaign_campaign_name | dim | The name of the campaign. | |
| Distribution settings | campaign_campaign_distribution_settings | dim | The distribution settings of the campaign. | |
| Distribution status | campaign_campaign_distribution_status | dim | The distribution status of the campaign. | |
| Campaign type | campaign_campaign_type | dim | This is one of the setting items when creating a campaign in Search Ads. You can manage the campaign according to the purpose by setting the campaign type. | |
| Campaign tracking ID | campaign_campaign_tracking_id | dim | The ID of campaign tracking. | |
| Tracking URL | campaign_tracking_url | dim | The tracking URL of the campaign. | |
| Start date | campaign_campaign_start_date | dim | The start date of the campaign. | |
| End date | campaign_campaign_end_date | dim | The end date of the campaign. | |
| Daily spending limit | campaign_daily_spending_limit | dim | The daily budget set for each campaign. | |
| Bid strategy | Portfolio bidding ID | campaign_portfolio_bidding_id | dim | The ID of the portfolio bidding. |
| Portfolio bidding name | campaign_portfolio_bidding_name | dim | The name of the portfolio bidding. | |
| Bid strategy type | campaign_bid_strategy_type | dim | The type of the bid strategy. | |
| Enhanced CPC | campaign_enhanced_cpc_enabled | dim | When Enhanced CPC is set, the keyword bid will be automatically adjusted to achieve as many conversion as possible. | |
| Other | Network | campaign_network | dim | The network the ad is shown on. |
| Click type | campaign_click_type | dim | The type of click. | |
| Device | campaign_device | dim | Devices to which advertisements are delivered, such as PCs, smartphones, and tablets, are called devices. | |
| Labels | campaign_labels | dim | Custom label specifies character strings to group page URLs. | |
| Conversions | Conversion name | campaign_conversion_name | dim | The name of the conversion. |
| Objective of conversion tracking | campaign_objective_of_conversion_tracking | dim | The Objective of Conversion Tracking. | |
| Impressions | campaign_impressions | met | Number of times an ad was displayed. | |
| Clicks | campaign_clicks | met | Number of times an ad was clicked. | |
| Cost | campaign_cost | met | The charge generated by clicking, default currency is in JPY. | |
| Cost (USD) | campaign_cost_usd | met | Cost converted to USD. | |
| Cost (EUR) | campaign_cost_eur | met | Cost converted to EUR. | |
| Cost (GBP) | campaign_cost_gbp | met | Cost converted to GBP. | |
| CTR | campaign_ctr | met | Click Through Rate, the ratio of clicks on the ad to the number of times the ad was viewed. It is calculated by Clicks / Impressions. | |
| Avg. CPC | campaign_avg_cpc | met | Average cost-per-click. It is calculated by Cost / Clicks. | |
| CPM | campaign_cpm | met | Cost Per Thousand impressions, using the Latin “Mille” instead of thousand. Average cost for displaying your ad 1000 times. Calculated by 1000 x total cost (or budget) / impressions. | |
| ROAS | campaign_roas | met | The effect you get on the advertising costs you invest, calculated by Conversion value / total cost. | |
| Invalid clicks | campaign_invalid_clicks | met | Clicks that we determine to be malicious, such as clicks by known malicious programs, specific duplicate clicks, or other abnormal clicks. These are “invalid clicks” or “suspected invalid clicks” and are excluded from billing. | |
| Conversions | campaign_conversions | met | A number of accomplishment (conversion) on the site, where users visited to the site by clicking an ad took an action such as purchasing a product, registering as a member, asking for materials, etc. Conversions refers to the first conversion that resulted of the period from 7 days to 90 days (counting period setting available) any of 1 click of an ad. | |
| Conversion rate | campaign_conversion_rate | met | The ratio of conversion amount that occurred to ad clicks. Calculated by number of conversion / number of clicks. | |
| Conversion value | campaign_conversion_value | met | The value of conversion. | |
| Cost per conversion | campaign_cost_per_conv | met | Cost per conversion. It is calculated by Cost / Conversion | |
| Value per conversion | campaign_value_per_conv | met | Value per conversion. It is calculated by Conversion Value / Conversion | |
| Conversion value per cost | campaign_conversion_value_per_cost | met | Conversion value per cost. It is calculated by Conversion Value / Cost | |
| Conversions (all) | campaign_all_conversion | met | The number of Conversions (all) counts all of conversions occurred within the period from 1 to 90 days (the period setting available). | |
| Conversion rate (all) | campaign_all_conversion_rate | met | The rate of all conversion. It is calculated by All conversion / clicks. | |
| Conversion value (all) | campaign_all_conversion_value | met | The value of all conversion. | |
| Cost per conversion (all) | campaign_cost_per_all_conv | met | The cost per all conversion. It is calculated by Cost / All conversion. | |
| Value per conversion (all) | campaign_value_per_all_conv | met | The value per all conversion. | |
| Conversion value per cost (all) | campaign_all_conversion_value_per_cost | met | All conversion value per cost. It is calculated by All conversion value / Cost | |
| Conversion across devices | campaign_cross_device_conversion | met | The number of conversion across devices. | |
| Time | Year | ad_year | dim | |
| Year of week (Sun-Sat) | ad_year_of_week | dim | ||
| Year of week (Mon-Sun) | ad_year_of_week_iso | dim | ||
| Year & month | ad_year_month | dim | ||
| Month | ad_month | dim | ||
| Year & week (Sun-Sat) | ad_year_week | dim | ||
| Year & week (Mon-Sun) | ad_year_week_iso | dim | ||
| Week (Sun-Sat) | ad_week | dim | ||
| Week (Mon-Sun) | ad_week_iso | dim | ||
| Day of month | ad_day_of_month | dim | ||
| Day of week (Sun-Sat) | ad_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | ad_day_of_week_name_iso | dim | ||
| Date | ad_date | dim | ||
| Datetime | ad_atom | dim | ||
| Ad group | Ad group ID | ad_adgroup_id | dim | The ID of the ad group. |
| Ad group name | ad_adgroup_name | dim | The name of the ad group. | |
| Adgroup tracking ID | ad_adgroup_tracking_id | dim | The tracking ID of the Adgroup. | |
| Ad | Ad ID | ad_ad_id | dim | The ID of the ad. |
| Ad Name | ad_ad_name | dim | The name of the ad. | |
| Ad Type | ad_ad_type | dim | The type of the ad. | |
| Ad distribution settings | ad_ad_distribution_settings | dim | The distribution settings of the ad. | |
| Ad editorial status | ad_ad_editorial_status | dim | The editorial status of the ad. | |
| Ad tracking ID | ad_ad_tracking_id | dim | The tracking ID of the ad. | |
| Display URL | ad_display_url | dim | The display URL of the ad. | |
| Destination URL | ad_destination_url | dim | The destination URL of the ad. | |
| Title1 | ad_title_1 | dim | The title 1 of the ad. | |
| Title2 | ad_title_2 | dim | The title 2 of the ad. | |
| Title3 | ad_title_3 | dim | The title 1 of the ad. | |
| Account | Account ID | ad_account_id | dim | A number that identifies your account. It will be automatically assigned when the account is created. |
| Account name | ad_account_name | dim | Name of the account. The account name must be the same as the website owner (company name, trade name, etc.) that can be seen on the site that is displayed when the ad is clicked. | |
| Campaign | Campaign ID | ad_campaign_id | dim | A number to identify the campaign. It will be automatically assigned when the campaign is created. |
| Campaign name | ad_campaign_name | dim | The name of the campaign. | |
| Campaign tracking ID | ad_campaign_tracking_id | dim | The ID of campaign tracking. | |
| Other | Click type | ad_click_type | dim | The type of click. |
| Network | ad_network | dim | The network the ad is shown on. | |
| Device | ad_device | dim | Devices to which advertisements are delivered, such as PCs, smartphones, and tablets, are called devices. | |
| Labels | ad_labels | dim | Custom label specifies character strings to group page URLs. | |
| Conversions | Conversion name | ad_conversion_name | dim | The name of the conversion. |
| Objective of conversion tracking | ad_objective_of_conversion_tracking | dim | The Objective of Conversion Tracking. | |
| Impressions | ad_impressions | met | Number of times an ad was displayed. | |
| Clicks | ad_clicks | met | Number of times an ad was clicked. | |
| Cost | ad_cost | met | The charge generated by clicking, default currency is in JPY. | |
| Cost (USD) | ad_cost_usd | met | Cost converted to USD. | |
| Cost (EUR) | ad_cost_eur | met | Cost converted to EUR. | |
| Cost (GBP) | ad_cost_gbp | met | Cost converted to GBP. | |
| CTR | ad_ctr | met | Click Through Rate, the ratio of clicks on the ad to the number of times the ad was viewed. It is calculated by Clicks / Impressions. | |
| Avg. CPC | ad_avg_cpc | met | Average cost-per-click. It is calculated by Cost / Clicks. | |
| CPM | ad_cpm | met | Cost Per Thousand impressions, using the Latin “Mille” instead of thousand. Average cost for displaying your ad 1000 times. Calculated by 1000 x total cost (or budget) / impressions. | |
| ROAS | ad_roas | met | The effect you get on the advertising costs you invest, calculated by Conversion value / total cost. | |
| Conversions | ad_conversions | met | A number of accomplishment (conversion) on the site, where users visited to the site by clicking an ad took an action such as purchasing a product, registering as a member, asking for materials, etc. Conversions refers to the first conversion that resulted of the period from 7 days to 90 days (counting period setting available) any of 1 click of an ad. | |
| Conversion rate | ad_conversion_rate | met | The ratio of conversion amount that occurred to ad clicks. Calculated by number of conversion / number of clicks. | |
| Conversion value | ad_conversion_value | met | The value of conversion. | |
| Cost per conversion | ad_cost_per_conv | met | Cost per conversion. It is calculated by Cost / Conversion | |
| Value per conversion | ad_value_per_conv | met | Value per conversion. It is calculated by Conversion Value / Conversion | |
| Conversion value per cost | ad_conversion_value_per_cost | met | Conversion value per cost. It is calculated by Conversion Value / Cost | |
| Conversions (all) | ad_all_conversion | met | The number of Conversions (all) counts all of conversions occurred within the period from 1 to 90 days (the period setting available). | |
| Conversion rate (all) | ad_all_conversion_rate | met | The rate of all conversion. It is calculated by All conversion / clicks. | |
| Conversion value (all) | ad_all_conversion_value | met | The value of all conversion. | |
| Cost per conversion (all) | ad_cost_per_all_conv | met | The cost per all conversion. It is calculated by Cost / All conversion. | |
| Value per conversion (all) | ad_value_per_all_conv | met | The value per all conversion. | |
| Conversion value per cost (all) | ad_all_conversion_value_per_cost | met | All conversion value per cost. It is calculated by All conversion value / Cost | |
| Conversion across devices | ad_cross_device_conversion | met | The number of conversion across devices. | |
| Time | Year | keywords_year | dim | |
| Year of week (Sun-Sat) | keywords_year_of_week | dim | ||
| Year of week (Mon-Sun) | keywords_year_of_week_iso | dim | ||
| Year & month | keywords_year_month | dim | ||
| Month | keywords_month | dim | ||
| Year & week (Sun-Sat) | keywords_year_week | dim | ||
| Year & week (Mon-Sun) | keywords_year_week_iso | dim | ||
| Week (Sun-Sat) | keywords_week | dim | ||
| Week (Mon-Sun) | keywords_week_iso | dim | ||
| Day of month | keywords_day_of_month | dim | ||
| Day of week (Sun-Sat) | keywords_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | keywords_day_of_week_name_iso | dim | ||
| Date | keywords_date | dim | ||
| Datetime | keywords_atom | dim | ||
| Keyword | Keyword | keywords_keyword | dim | The keyword used to describe the ad. |
| Keyword ID | keywords_keyword_id | dim | The ID of the keyword. | |
| Match type | keywords_match_type | dim | The keyword match type. | |
| Keyword distribution settings | keywords_keyword_distribution_settings | dim | The distribution settings of keyword. | |
| Keyword editorial status | keywords_keyword_editorial_status | dim | The editorial status of keyword. | |
| Keyword tracking ID | keywords_keyword_tracking_id | dim | The tracking ID of the keyword. | |
| Account | Account ID | keywords_account_id | dim | A number that identifies your account. It will be automatically assigned when the account is created. |
| Account name | keywords_account_name | dim | Name of the account. The account name must be the same as the website owner (company name, trade name, etc.) that can be seen on the site that is displayed when the ad is clicked. | |
| Campaign | Campaign ID | keywords_campaign_id | dim | A number to identify the campaign. It will be automatically assigned when the campaign is created. |
| Campaign name | keywords_campaign_name | dim | The name of the campaign. | |
| Campaign tracking ID | keywords_campaign_tracking_id | dim | The ID of campaign tracking. | |
| Adgroup | Ad Group ID | keywords_adgroup_id | dim | The ID of the ad group. |
| Ad group name | keywords_adgroup_name | dim | The name of the ad group. | |
| Adgroup bid | keywords_adgroup_bid | dim | Bid price for adgroup. | |
| Adgroup tracking ID | keywords_adgroup_tracking_id | dim | The tracking ID of the Adgroup. | |
| Other | Click type | keywords_click_type | dim | The type of click. |
| Network | keywords_network | dim | The network the ad is shown on. | |
| Device | keywords_device | dim | Devices to which advertisements are delivered, such as PCs, smartphones, and tablets, are called devices. | |
| Labels | keywords_labels | dim | Custom label specifies character strings to group page URLs. | |
| Conversions | Conversion name | keywords_conversion_name | dim | The name of the conversion. |
| Objective of conversion tracking | keywords_objective_of_conversion_tracking | dim | The Objective of Conversion Tracking. | |
| Impressions | keywords_impressions | met | Number of times an ad was displayed. | |
| Clicks | keywords_clicks | met | Number of times an ad was clicked. | |
| Cost | keywords_cost | met | The charge generated by clicking, default currency is in JPY. | |
| Cost (USD) | keywords_cost_usd | met | Cost converted to USD. | |
| Cost (EUR) | keywords_cost_eur | met | Cost converted to EUR. | |
| Cost (GBP) | keywords_cost_gbp | met | Cost converted to GBP. | |
| CTR | keywords_ctr | met | Click Through Rate, the ratio of clicks on the ad to the number of times the ad was viewed. It is calculated by Clicks / Impressions | |
| Avg. CPC | keywords_avg_cpc | met | Average cost-per-click. It is calculated by Cost / Clicks. | |
| CPM | keywords_cpm | met | Cost Per Thousand impressions, using the Latin “Mille” instead of thousand. Average cost for displaying your ad 1000 times. Calculated by 1000 x total cost (or budget) / impressions. | |
| ROAS | keywords_roas | met | The effect you get on the advertising costs you invest, calculated by Conversion value / total cost. | |
| Conversions | keywords_conversions | met | A number of accomplishment (conversion) on the site, where users visited to the site by clicking an ad took an action such as purchasing a product, registering as a member, asking for materials, etc. Conversions refers to the first conversion that resulted of the period from 7 days to 90 days (counting period setting available) any of 1 click of an ad. | |
| Conversion rate | keywords_conversion_rate | met | The ratio of conversion amount that occurred to ad clicks. Calculated by number of conversion / number of clicks. | |
| Conversion value | keywords_conversion_value | met | The value of conversion. | |
| Cost per conversion | keywords_cost_per_conv | met | Cost per conversion. It is calculated by Cost / Conversion | |
| Value per conversion | keywords_value_per_conv | met | Value per conversion. It is calculated by Conversion Value / Conversion | |
| Conversion value per cost | keywords_conversion_value_per_cost | met | Conversion value per cost. It is calculated by Conversion Value / Cost | |
| Conversions (all) | keywords_all_conversion | met | The number of Conversions (all) counts all of conversions occurred within the period from 1 to 90 days (the period setting available). | |
| Conversion rate (all) | keywords_all_conversion_rate | met | The rate of all conversion. It is calculated by All conversion / clicks. | |
| Conversion value (all) | keywords_all_conversion_value | met | The value of all conversion. | |
| Cost per conversion (all) | keywords_cost_per_all_conv | met | The cost per all conversion. It is calculated by Cost / All conversion. | |
| Value per conversion (all) | keywords_value_per_all_conv | met | The value per all conversion. | |
| Conversion value per cost (all) | keywords_all_conversion_value_per_cost | met | All conversion value per cost. It is calculated by All conversion value / Cost | |
| Conversion across devices | keywords_cross_device_conversion | met | The number of conversion across devices. | |
| Time | Year | geo_year | dim | |
| Year of week (Sun-Sat) | geo_year_of_week | dim | ||
| Year of week (Mon-Sun) | geo_year_of_week_iso | dim | ||
| Year & month | geo_year_month | dim | ||
| Month | geo_month | dim | ||
| Year & week (Sun-Sat) | geo_year_week | dim | ||
| Year & week (Mon-Sun) | geo_year_week_iso | dim | ||
| Week (Sun-Sat) | geo_week | dim | ||
| Week (Mon-Sun) | geo_week_iso | dim | ||
| Day of month | geo_day_of_month | dim | ||
| Day of week (Sun-Sat) | geo_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | geo_day_of_week_name_iso | dim | ||
| Date | geo_date | dim | ||
| Datetime | geo_atom | dim | ||
| Geo | Country/territory | geo_country_territory | dim | Country/territory where the event happened. |
| City | geo_city | dim | City where the event happened. | |
| Prefecture | geo_prefecture | dim | A region or area where the event happened. | |
| Location type | geo_location_type | dim | Location type. | |
| Location | geo_most_specific_location | dim | The location where the event happened. | |
| Metro area | geo_metro_area | dim | The metropolitan area where the event happened. | |
| Account | Account ID | geo_account_id | dim | A number that identifies your account. It will be automatically assigned when the account is created. |
| Account name | geo_account_name | dim | Name of the account. The account name must be the same as the website owner (company name, trade name, etc.) that can be seen on the site that is displayed when the ad is clicked. | |
| Campaign | Campaign ID | geo_campaign_id | dim | A number to identify the campaign. It will be automatically assigned when the campaign is created. |
| Campaign name | geo_campaign_name | dim | The name of the campaign. | |
| Campaign tracking ID | geo_campaign_tracking_id | dim | The ID of campaign tracking. | |
| Adgroup | Ad Group ID | geo_adgroup_id | dim | The ID of the ad group. |
| Ad group name | geo_adgroup_name | dim | The name of the ad group. | |
| Adgroup tracking ID | geo_adgroup_tracking_id | dim | The tracking ID of the Adgroup. | |
| Device | Network | geo_network | dim | The network the ad is shown on. |
| Device | geo_device | dim | Devices to which advertisements are delivered, such as PCs, smartphones, and tablets, are called devices. | |
| Conversions | Conversion name | geo_conversion_name | dim | The name of the conversion. |
| Objective of conversion tracking | geo_objective_of_conversion_tracking | dim | The Objective of Conversion Tracking. | |
| Impressions | geo_impressions | met | Number of times an ad was displayed. | |
| Clicks | geo_clicks | met | Number of times an ad was clicked. | |
| Cost | geo_cost | met | The charge generated by clicking, default currency is in JPY. | |
| Cost (USD) | geo_cost_usd | met | Cost converted to USD. | |
| Cost (EUR) | geo_cost_eur | met | Cost converted to EUR. | |
| Cost (GBP) | geo_cost_gbp | met | Cost converted to GBP. | |
| CTR | geo_ctr | met | Click Through Rate, the ratio of clicks on the ad to the number of times the ad was viewed. It is calculated by Clicks / Impressions. | |
| Avg. CPC | geo_avg_cpc | met | Average cost-per-click. It is calculated by Cost / Clicks. | |
| CPM | geo_cpm | met | Cost Per Thousand impressions, using the Latin “Mille” instead of thousand. Average cost for displaying your ad 1000 times. Calculated by 1000 x total cost (or budget) / impressions. | |
| ROAS | geo_roas | met | The effect you get on the advertising costs you invest, calculated by Conversion value / total cost. | |
| Conversions | geo_conversions | met | A number of accomplishment (conversion) on the site, where users visited to the site by clicking an ad took an action such as purchasing a product, registering as a member, asking for materials, etc. Conversions refers to the first conversion that resulted of the period from 7 days to 90 days (counting period setting available) any of 1 click of an ad. | |
| Conversion rate | geo_conversion_rate | met | The ratio of conversion amount that occurred to ad clicks. Calculated by number of conversion / number of clicks. | |
| Conversion value | geo_conversion_value | met | The value of conversion. | |
| Cost per conversion | geo_cost_per_conv | met | Cost per conversion. It is calculated by Cost / Conversion | |
| Value per conversion | geo_value_per_conv | met | Value per conversion. It is calculated by Conversion Value / Conversion | |
| Conversion value per cost | geo_conversion_value_per_cost | met | Conversion value per cost. It is calculated by Conversion Value / Cost | |
| Conversions (all) | geo_all_conversion | met | The number of Conversions (all) counts all of conversions occurred within the period from 1 to 90 days (the period setting available). | |
| Conversion rate (all) | geo_all_conversion_rate | met | The rate of all conversion. It is calculated by All conversion / clicks. | |
| Conversion value (all) | geo_all_conversion_value | met | The value of all conversion. | |
| Cost per conversion (all) | geo_cost_per_all_conv | met | The cost per all conversion. It is calculated by Cost / All conversion. | |
| Value per conversion (all) | geo_value_per_all_conv | met | The value per all conversion. | |
| Conversion value per cost (all) | geo_all_conversion_value_per_cost | met | All conversion value per cost. It is calculated by All conversion value / Cost | |
| Conversion across devices | geo_cross_device_conversion | met | The number of conversion across devices. |