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, e.g. 2017 |
| Year of week (Sun-Sat) | yearOfWeek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
| Month | month | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearWeek | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| Hour | hour | dim | Hour in a 24-hour clock, e.g. 18 | |
| ACCOUNT | Account name | profile_name | dim | Name of the Apple Search Ads account |
| Account ID | profile_id | dim | Name of the Apple Search Ads account | |
| Currency | currency | dim | The campaign currency | |
| CAMPAIGN | Campaign name | campaign_name | dim | |
| Campaign ID | campaign_id | dim | ||
| Campaign status | campaign_status | dim | ||
| Campaign serving status | serving_status | dim | Whether the campaign/ad group is actually serving or not | |
| Campaign serving status reasons | serving_state_reasons | dim | When a campaign is not running, a list of reasons will be returned | |
| Campaign display status | display_status | dim | Whether campaign is RUNNING, ON_HOLD, PAUSED or DELETED | |
| Campaign countries or regions | countries_or_regions | dim | List of all App Store countries or regions in which you want to promote your app | |
| Campaign countries or regions serving status reasons | countries_or_regions_serving_state_reasons | dim | When a campaign is not running, a list of reasons will be returned | |
| Ad channel type | ad_channel_type | dim | The channel type of ads used in a campaign | |
| Campaign supply sources | supply_sources | dim | The supply source of ads used in a campaign | |
| Campaign modification date | modification_date | dim | ||
| Campaign modification time | modification_time | dim | ||
| Campaign total budget | total_budget | dim | Total budget of the campaign in the account currency | |
| Campaign daily budget | daily_budget | dim | Daily budget of the campaign in the account currency, if set | |
| AD | Ad ID | ad_id | dim | Unique identifier representing the assignment relationship between an Ad Group and a Creative |
| Ad language | ad_language | dim | The language used in the ad text | |
| Creative ID | creative_id | dim | Unique identifier for a creative | |
| Ad name | ad_name | dim | A unique name of the ad assigned to an ad group | |
| Creative type | creative_type | dim | The type of creative. Values are CUSTOM_PRODUCT_PAGE, CREATIVE_SET | |
| Ad status | ad_status | dim | The status of the ad | |
| Ad display status | ad_display_status | dim | The indicator of the status of an ad assignment with an ad group | |
| Ad display state reasons | ad_serving_state_reasons | dim | Reasons provided when an ad isn’t running | |
| Is ad deleted | ad_is_deleted | dim | Indicates whether the ad has been deleted or not. Values are TRUE, FALSE | |
| Ad creation date | ad_creation_date | dim | The date the ad was created | |
| Ad creation time | ad_creation_time | dim | The date and time the ad was created | |
| Ad modification date | ad_modification_date | dim | The date of the most recent modification of the ad | |
| Ad modification time | ad_modification_time | dim | The date and time of the most recent modification of the ad | |
| AD GROUP | Ad group name | ad_group_name | dim | |
| Ad group ID | ad_group_id | dim | ||
| Ad group status | ad_group_status | dim | ||
| Ad group serving status | ad_group_serving_status | dim | ||
| Ad group serving state reasons | ad_group_serving_state_reasons | dim | ||
| Automated keywords opt-in | automated_keywords_opt_in | dim | ||
| KEYWORD | Keyword | keyword | dim | |
| Keyword ID | keyword_id | dim | ||
| Keyword status | keyword_status | dim | ||
| Keyword display status | keyword_display_status | dim | ||
| SEARCH TERM | Search term | search_term | dim | |
| Search term source | search_term_source | dim | ||
| Match type | match_type | dim | ||
| CREATIVE SET | Creative set name | creative_set_name | dim | |
| Creative set ID | creative_set_id | dim | ||
| Creative set display status | creative_set_display_status | dim | ||
| Creative set status | creative_set_status | dim | ||
| Creative set language display name | creative_set_language_display_name | dim | ||
| Ad format | ad_format | dim | ||
| DEVICE | Device type | device_class | dim | The type of devices that the promoted application supports |
| USER | Gender | gender | dim | |
| Age range | age_range | dim | ||
| GEO | App Store country | country_or_region | dim | The App Store country or region where you are promoting your app |
| User country | country_code | dim | Country where the campaign ads are served in | |
| Admin area | admin_area | dim | The adminArea dimension is a group of States or the equivalent according to its associated country | |
| Locality | locality | dim | The locality dimension is the city or the equivalent according to its associated admin area | |
| APP | App name | app_name | dim | Name of the app promoted by the campaign |
| App ID | app_id | dim | ID of the app promoted by the campaign | |
| Link to app | app_link | dim | Link to the App Store listing of the app promoted by the campaign | |
| Link to app creator | app_creator_link | dim | Link to the App Store listing of the creator of the app promoted by the campaign | |
| Primary category | app_primary_category | dim | Primary category of the app promoted by the campaign | |
| Categories | app_categories | dim | All categories of the app promoted by the campaign | |
| Description | app_description | dim | Description of the app promoted by the campaign | |
| App price | app_formatted_price | dim | Price of the app promoted by the campaign | |
| App price currency | app_currency | dim | Currency of the app price | |
| Supported devices | app_supported_devices | dim | List of devices that app supports | |
| Age rating | app_content_advisory_rating | dim | App age rating | |
| Advisories | app_advisories | dim | App advisories | |
| Language codes | app_language_codes | dim | Languages supported by the app | |
| Minimum OS version | app_minimum_os_version | dim | Minimum operating system version required by the app promoted by the campaign | |
| File size (mb) | app_file_size_mb | dim | App file size in megabytes | |
| Is Game Center enabled | app_is_game_center_enabled | dim | ||
| Average user rating | app_average_rating | dim | Average rating given by users for the app | |
| User rating count | app_rating_count | dim | Number of ratings given by users for the app | |
| Average user rating (current version) | app_average_rating_current_version | dim | Average rating given by users for the current version of the app | |
| User rating count (current version) | app_rating_count_current_version | dim | Number of ratings given by users for the current version the app | |
| Release date | app_release_date | dim | App release date | |
| Current version release date | app_current_version_release_date | dim | Release date of the latest version of the app | |
| Release notes | app_release_notes | dim | Release notes of the latest version of the app promoted by the campaign | |
| Current version | app_version | dim | Current version of the app promoted by the campaign | |
| APP IMAGES | App logo 60px URL | app_artwork_60_url | dim | URL of the 60 pixel logo of the app |
| App logo 60px | app_artwork_60_image | dim | The 60 pixel logo of the app | |
| App logo 512px URL | app_artwork_512_url | dim | URL of the 512 pixel logo of the app | |
| App logo 512px | app_artwork_512_image | dim | The 512 pixel logo of the app | |
| Screenshot #1 URL | app_screenshot_1_url | dim | URL of the 1st screenshot image of the app in the App Store | |
| Screenshot #1 | app_screenshot_1_image | dim | 1st screenshot image of the app in the App Store | |
| Screenshot #2 URL | app_screenshot_2_url | dim | URL of the 2nd screenshot image of the app in the App Store | |
| Screenshot #2 | app_screenshot_2_image | dim | 2nd screenshot image of the app in the App Store | |
| Screenshot #3 URL | app_screenshot_3_url | dim | URL of the 3rd screenshot image of the app in the App Store | |
| Screenshot #3 | app_screenshot_3_image | dim | 3rd screenshot image of the app in the App Store | |
| Screenshot #4 URL | app_screenshot_4_url | dim | URL of the 4th screenshot image of the app in the App Store | |
| Screenshot #4 | app_screenshot_4_image | dim | 4th screenshot image of the app in the App Store | |
| BASIC | Impressions | impressions | met | The number of times your ad appeared in App Store search results within the reporting time period |
| Taps | taps | met | The number of times your ad was tapped by users within the reporting time period | |
| Installs | installs | met | The total number of newDownloads or redownloads resulting from an ad within the reporting period. Search Ads installs are attributed within a 30‑day tap-through window | |
| Cost | cost | met | The total spend of a campaign in the currency used in the campaign | |
| Cost (EUR) | cost_eur | met | The total spend of a campaign converted to euros | |
| Cost (USD) | cost_usd | met | The total spend of a campaign converted to US dollars | |
| Cost (GBP) | cost_gbp | met | The total spend of a campaign converted to British pounds | |
| Tap-through rate | ttr | met | The tap-through rate (TTR) is the number of times your ad was tapped by users divided by the total impressions your ad received | |
| Conversion rate | conversion_rate | met | The total number of conversions received within a period, divided by total number of taps within the same period | |
| Cost per tap | cpc | met | The CPT (Cost per tap) is treated by the API the same as CPC (Cost per click). The ratio is spend over taps | |
| Cost per acquisition | cpa | met | The average cost-per-acquisition (CPA) is the total spend divided by the number of installs received within a period | |
| INSTALL TYPE | New downloads | newDownloads | met | The enumerated app downloads from new users who have never before installed your app |
| Re-downloads | redownloads | met | The enumerated re-installs from users who have previously installed your app | |
| Limit Ad Tracking installs | latOnInstalls | met | The installs from users who have enabled Limit Ad Tracking (LAT) on their device | |
| Non-Limit Ad Tracking installs | latOffInstalls | met | The installs from users who have not enabled Limit Ad Tracking (LAT) on their device |