Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| 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 | ||
| 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 | An unique ID provided for each campaign. |
| Campaign name | ad_campaign_name | dim | The name of the campaign. | |
| Campaign delivery settings | ad_campaign_delivery_settings | dim | The delivery settings of the campaign. | |
| Campaign type | ad_campaign_type | dim | The campaign type. | |
| Campaign delivery type | ad_campaign_delivery_type | dim | The campaign delivery type. | |
| Campaign labels | ad_campaign_labels | dim | The campaign labels. | |
| Campaign goals | ad_campaign_goals | dim | The campaign's goal set to achieve your business goal appears. NONE appears when a campaign doesn't have a goal. | |
| Campaign buying type | ad_campaign_buying_type | dim | The buying type of the campaign. | |
| Destination URL (campaign banner) | ad_destination_url_campaign_banner | dim | The destination URL when user clicks campaign banner. | |
| Ad group | Ad Group ID | ad_adgroup_id | dim | An unique ID provided for each ad group. |
| Ad group name | ad_adgroup_name | dim | The name of the ad group. | |
| Ad group delivery settings | ad_adgroup_delivery_settings | dim | The delivery setting of the ad group. | |
| Ad group labels | ad_adgroup_labels | dim | The labels of the ad group. | |
| Ad | Ad ID | ad_ad_id | dim | An unique ID provided for each ad. |
| Ad Name | ad_ad_name | dim | A name to identify the ad. For banner and responsive ad types, the media name of your image or video appears as default. You can change the ad name afterward. | |
| Ad title | ad_ad_title | dim | The title of the ad. | |
| Ad Type | ad_ad_type | dim | It shows the device and number of characters in the ad. You can set this type when creating ads. You can check it on the list of ads viewed. | |
| Responsive ads type | ad_responsive_ads_type | dim | Responsive ad types appear. Assets (multiple elements): this ad type changes the contents of your ads by using multiple images and titles you uploaded. Fixed: this ad type shows fixed contents. | |
| Ad delivery settings | ad_ad_delivery_settings | dim | The delivery setting of the ad. | |
| Ad layout | ad_ad_layout | dim | The layout of the ad. | |
| Ad labels | ad_ad_labels | dim | The labels of the ad. | |
| Ad distribution | ad_ad_distribution | dim | Ad distribution. | |
| Description 1 | ad_description_1 | dim | The first description of the ad. | |
| Description 2 | ad_description_2 | dim | The second description of the ad. | |
| Display URL | ad_display_url | dim | The display URL of the ad. | |
| Destination URL ID | ad_destination_url_id | dim | The ID of the ad URL. | |
| Destination URL | ad_destination_url | dim | The destination URL of the ad. | |
| Dynamic image extensions | ad_dynamic_image_extensions | dim | The dynamic image extensions option of the ad. | |
| Final URL | ad_final_url | dim | Enter a URL that appears when a user clicks your ad. | |
| Tracking URL | ad_tracking_url | dim | To track your ads, add a tracking URL. You don't need this setting when you don't. | |
| Media | Media ID | ad_media_id | dim | An unique ID provided for each media (image, video). |
| Media name | ad_media_name | dim | A name to identify the media (image, video) set to ads. | |
| Media file name | ad_media_file_name | dim | A name to identify the media file attached to ads. | |
| Main media format | ad_main_media_format | dim | the main media format of the ads. | |
| Pixel size | ad_pixel_size | dim | Pixel size (length x width) for media (image, video) set to ads. | |
| Keyword | Search keyword ID | ad_search_keyword_id | dim | The ID of the search keyword. |
| Search keyword | ad_search_keyword | dim | Performance per search keyword appears. The search keyword column will be blank for the performance of the ad group if the search keyword targeting isn't set up. | |
| Content keyword ID | ad_content_keyword_id | dim | The ID of the content keyword. | |
| Content keyword | ad_content_keyword | dim | Performance per content keyword appears. The content keyword column will be blank for the performance of the ad group if the content keyword targeting isn't set up or only the Exclude content keyword is associated. | |
| Conversion | Conversion ID | ad_conversion_id | dim | The ID of the conversion. |
| Conversion name | ad_conversion_name | dim | Name of conversion. | |
| Objective of conversion tracking | ad_objective_of_conversion_tracking | dim | The Objective of Conversion Tracking. | |
| Conversion group ID | ad_conversion_group_id | dim | The ID of conversion group. | |
| Conversion group name | ad_conversion_group_name | dim | The name of conversion group. | |
| App | App name | ad_app_name | dim | App name set for the campaign. |
| App OS | ad_app_os | dim | App OS set for the campaign. | |
| App ID/Package name | ad_app_id | dim | App ID/ package name set for the campaign. | |
| Web/App | ad_web_app | dim | Web/app set for the campaign. | |
| Device | Device | ad_device | dim | Devices to which advertisements are delivered, such as PCs, smartphones, and tablets, are called devices. |
| OS | ad_os | dim | OS of the device used. | |
| Carrier | ad_carrier | dim | Name of the carrier. | |
| Package name | ad_package_name | dim | Name of the package. | |
| Geo | Prefecture ID | ad_prefecture_id | dim | The region/area ID. |
| Prefectures | ad_prefecture | dim | A region or area where the event happened. | |
| City ID | ad_city_id | dim | The ID of the city. | |
| City name | ad_city_name | dim | City where the event happened. | |
| Ward ID | ad_ward_id | dim | The ward ID. | |
| Ward name | ad_ward_name | dim | The ward name. | |
| Target radius | ad_radius_target | dim | Target radius where the event happened. | |
| Distance from target location | ad_radius_distance | dim | Distance from target location where the event happened. | |
| Audience | Gender | ad_gender | dim | Gender of person who viewed the ad. |
| Age | ad_age | dim | Age of the person who viewed the ad. | |
| Impressions | ad_impressions | met | The number of times your ads appear. It includes ad appearances outside of a user's visible area. | |
| Clicks | ad_clicks | met | The number of times your ad was clicked by internet users. This indicates the traffic to your website. | |
| Cost | ad_cost | met | Total amount of advertising cost, 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 your ad received to the number of times your ad is shown. It is calculated by Clicks / Impressions. | |
| Avg. CPC | ad_avg_cpc | met | Average cost-per-click. It is calculated by Cost / Clicks. | |
| Avg. CPM | ad_avg_cpm | met | The average advertising cost per 1,000 impressions. Calculated by total cost (or budget) / impressions x 1000. | |
| ROAS | ad_roas | met | The effect you get on the advertising costs you invest, calculated by Conversion value / total cost. | |
| Conversions | ad_conversions | met | The number of valuable actions (purchase, membership registry, document request, etc.) by users who clicked your ad or visited your website after viewing the paid video for 10 seconds or more. This metric counts regardless of the conversion-counting setting. When the counting type is One per click, the multiple conversions resulted from one conversion action count one while Many per click count all conversions. This value doesn't include view-through conversions. | |
| Cost/conv. | ad_cost_per_conv | met | Advertising cost per conversion. It is calculated by Cost / Conversions. | |
| Conv. value | ad_conversion_value | met | The value of sales, etc. generated by Conversions. The sum of Value per conversion set for conversion tracking tag is shown. | |
| Conv. value/conv. | ad_value_per_conv | met | The value of sales, etc. generated per “Conversion.”. It is calculated by Conversion Value / Conversions. | |
| Conv. value/cost | ad_conversion_value_per_cost | met | This indicates how much you earned in relation to your advertising cost. When you set sales amount as a conversion value, it is called return on ad spend (ROAS). It is calculated by Conversion Value / Cost. | |
| Cross-device conv. | ad_cross_device_conversion | met | A number of valuable actions (purchase, membership registry, document request, etc.) using the different device from the ad click. | |
| View-through conversions | ad_view_through_conv | met | The number of actions (purchase, membership registry, document request, etc.) by users who didn't click ads nor view videos appear. They reached your site with a different path. | |
| Conversions (all) | ad_all_conversion | met | The number of valuable actions (purchase, membership registry, document request, etc.) by users who clicked your ad or visited your website after viewing the paid video for 10 seconds or more. This metric counts regardless of the conversion-counting setting. When the counting type is One per click, the multiple conversions brought by one conversion action count one while Many per click count all conversions. | |
| Cost/conv. (all) | ad_cost_per_all_conv | met | Advertising cost per all conversion. It is calculated by Cost / All conversion. | |
| Conv. value (all) | ad_all_conversion_value | met | The value of sales, etc. brought by Conversion (all). The sum of Value per conv. set for conversion tracking tag is shown. | |
| Conv. value (all)/conv. (all) | ad_all_conv_value_per_all_conv | met | The value of sales, etc. generated per Conversion (all). Calculated by Conv. value (all) / conv.(all). | |
| Conv. value (all)/cost | ad_all_conversion_value_per_cost | met | This indicates how much you earned in relation to your advertising cost. When you set sales amount as a conversion value, it is called return on ad spend (ROAS). It is calculated by All conversion value / Cost. | |
| Conversions (via click) | ad_conversions_via_ad_click | met | The number of valuable actions (purchase, membership registry, document request, etc.) by users who clicked your ad and visited your website. When the counting type is One per click, the multiple conversions resulted from one conversion action count one while Many per click count all conversions. | |
| Conv. rate (via click) | ad_conversion_rate_via_ad_click | met | A ratio of valuable actions (purchase, membership registry, document request, etc.) by users who clicked your ad and visited your website. Calculated by Conversions (via click) / clicks. | |
| Cost/conv. (via click) | ad_cost_per_conv_via_ad_click | met | Advertising cost per “Conversion”. Calculated by Cost / conversions (via click). | |
| Conv. value (via click) | ad_conv_value_via_ad_click | met | The value of sales, etc. generated per Conversion (via click). The sum of Value per conv. set for conversion tracking tag appears. | |
| Conv. value (via click)/conv. (via click) | ad_value_per_conv_via_ad_click | met | The value of sales, etc. generated per Conversion (via click). Calculated by Conv. value (via click) / conversions (via click). | |
| Conv. value (via click)/cost | ad_conv_value_via_ad_click_per_cost | met | This indicates how much you earned in relation to your advertising cost. When you set sales amount as a conversion value, it is called return on ad spend (ROAS). Calculated by Conv. value (via ad click) / cost. | |
| Viewable impressions | ad_viewable_impressions | met | The number of ad appearances in a user's visible area appears. To check the number of ad appearances outside of a user's visible area, see Impressions. | |
| Viewable impressions rate | ad_viewable_impressions_rate | met | The ratio of viewable impressions to measured impressions. Viewable impression rate = Viewable impressions / measured impressions. | |
| Viewable clicks | ad_viewable_clicks | met | The number of clicks for ad appearance that are counted as viewable impressions. | |
| Viewable CTR | ad_viewable_ctr | met | A ratio showing the number of viewable clicks to the viewable impressions. Viewable CTR = viewable clicks / viewable impressions. | |
| Measured impressions | ad_measured_impressions | met | The number of impressions that can be counted as viewable impressions. Depending on ad places, viewable impressions may not be counted. The impressions are counted with client-side measurement. | |
| Measured impression rate | ad_measured_impressions_rate | met | The ratio of impressions that can be counted as viewable impressions. Depending on ad places, viewable impressions may not be counted. Measured impression rate = measured impressions / impressions. | |
| Viewable impressions per panel | ad_viewable_impressions_per_panel | met | Number of viewable impressions per panel. | |
| Video views | ad_video_views | met | Number of video view started. Includes short views that are not charged. | |
| 3 sec video views | ad_video_views_to_3_sec | met | Number of video views for 3 seconds or more. | |
| 10 sec video views | ad_video_views_to_10_sec | met | The number of video viewed longer than 11 seconds. If the video is shorter than 11 seconds, the video view is counted when the video is watched to the end. For CPV, the number of paid video view has the same value with this 10 sec video views. | |
| 25% video views | ad_video_views_to_25 | met | The number of times the video is viewed to 25% of total time. | |
| 50% video views | ad_video_views_to_50 | met | The number of times the video is viewed to 50% of total time. | |
| 75% video views | ad_video_views_to_75 | met | The number of times the video is viewed to 75% of total time. | |
| 95% video views | ad_video_views_to_95 | met | The number of times the video is viewed to 95% of total time. | |
| 100% video views | ad_video_views_to_100 | met | The number of times the video is viewed to 100% of total time. | |
| Paid video views (CPV) | ad_paid_video_views | met | Number of paid video view. | |
| 25% video views rate | ad_video_views_to_25_rate | met | The rate at which videos are viewed to 25% of their total length relative to the total number of videos initiated appears. Calculated by 25% video views/ Video views. | |
| 50% video views rate | ad_video_views_to_50_rate | met | The rate at which videos are viewed to 50% of their total length relative to the total number of videos initiated appears. Calculated by 50% video views/ Video views. | |
| 75% video views rate | ad_video_views_to_75_rate | met | The rate at which videos are viewed to 75% of their total length relative to the total number of videos initiated appears. Calculated by 75% video views/ Video views. | |
| 95% video views rate | ad_video_views_to_95_rate | met | The rate at which videos are viewed to 95% of their total length relative to the total number of videos initiated appears. Calculated by 95% video views/ Video views. | |
| Video view through rate | ad_video_view_through_rate | met | The rate at which videos are viewed to the end (100% of their total length) relative to the total number of videos initiated appears. Calculated by 100% video views/ Video views. | |
| Paid video views rate (CPV) | ad_paid_video_views_rate | met | The rate at which paid videos are viewed relative to the total number of videos initiated appears. Calculated by Paid video views/ Video views. |