Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | datascape_year | dim | |
| Year of week (Sun-Sat) | datascape_year_of_week | dim | ||
| Year of week (Mon-Sun) | datascape_year_of_week_iso | dim | ||
| Year & month | datascape_year_month | dim | ||
| Month | datascape_month | dim | ||
| Year & week (Sun-Sat) | datascape_year_week | dim | ||
| Year & week (Mon-Sun) | datascape_year_week_iso | dim | ||
| Week (Sun-Sat) | datascape_week | dim | ||
| Week (Mon-Sun) | datascape_week_iso | dim | ||
| Day of month | datascape_day_of_month | dim | ||
| Day of week (Sun-Sat) | datascape_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | datascape_day_of_week_name_iso | dim | ||
| Date | datascape_date | dim | ||
| Datetime | datascape_atom | dim | ||
| App | App name | datascape_app | dim | Name of the app. |
| App token | datascape_app_token | dim | App ID in the Adjust system. | |
| Store ID | datascape_store_id | dim | Store app ID. | |
| Store type | datascape_store_type | dim | Store from where the app was installed. | |
| Campaign | Campaign name | datascape_campaign_network | dim | Campaign name from the network. |
| Campaign ID | datascape_campaign_id_network | dim | Campaign ID from the network. | |
| Adgroup name | datascape_adgroup_network | dim | Adgroup name from the network. | |
| Adgroup ID | datascape_adgroup_id_network | dim | Adgroup ID from the network. | |
| Ad name | datascape_ad_name | dim | Creative name from the network. | |
| Ad ID | datascape_ad_id | dim | Creative ID from the network. | |
| Source name | datascape_source_network | dim | Name of the source network. Optional value dependent on the network. | |
| Source ID | datascape_source_id_network | dim | ID of the source network. | |
| Partner | Channel | datascape_channel | dim | A combination of partner_name and network. |
| Partner name | datascape_partner_name | dim | Partner's name in the Adjust system. | |
| Partner ID | datascape_partner_id | dim | Partner's ID in the Adjust system. | |
| Currency | Currency name | datascape_currency | dim | Currency name. |
| Currency code | datascape_currency_code | dim | 3-character value ISO 4217. | |
| Device | Device type | datascape_device_type | dim | Group by device type |
| OS name | datascape_os_name | dim | Group by OS names | |
| Platform | datascape_platform | dim | The device operating system/platform. See list of supported platforms below. | |
| Geo | Country | datascape_country | dim | Country name. |
| Country code | datascape_country_code | dim | 2-character value ISO 3166. | |
| Region | datascape_region | dim | Business region | |
| Clicks | datascape_clicks | met | The number of times a user clicked on a creative. | |
| Clicks (attribution) | datascape_attribution_clicks | met | The number of times a user clicked on a creative. | |
| Clicks (network) | datascape_network_clicks | met | The number of clicks reported by the network. | |
| Click Conversion Rate (CCR) | datascape_click_conversion_rate | met | The average number of clicks it takes for a user to install your app. (Installs/ Clicks). | |
| CTR | datascape_ctr | met | Click through rate (clicks/impressions weighted by impressions). | |
| Impressions | datascape_impressions | met | The total number of ad impressions measured for your campaigns. | |
| Impressions (attribution) | datascape_attribution_impressions | met | Number of times the creatives were displayed. | |
| Impressions (network) | datascape_network_impressions | met | Number of impressions reported by the network. | |
| Impression Conversion Rate (ICR) | datascape_impression_conversion_rate | met | The percentage of app installs per ad impressions served. (Installs/Impressions). | |
| Sessions | datascape_sessions | met | The total number of sessions, including installs (first sessions), reinstalls, reattributions, and reattribution reinstalls that have occurred. | |
| Base sessions | datascape_base_sessions | met | The number of user sessions, excluding installs and reattributions. | |
| Installs | datascape_installs | met | Number of installs | |
| Installs (network) | datascape_network_installs | met | Number of installs reported by the network. | |
| Installs diff (network) | datascape_network_installs_diff | met | Shows an absolute value with the difference between the Attribution and Network sources. | |
| Uninstalls | datascape_uninstalls | met | Number of uninstalls | |
| Reinstalls | datascape_reinstalls | met | Number of reinstalls | |
| Total events | datascape_events | met | The total number of all triggered events. | |
| Avg. DAUs | datascape_daus | met | Average daily active users | |
| Avg. WAUs | datascape_waus | met | Average weekly active users | |
| Avg. MAUs | datascape_maus | met | Average monthly active users | |
| Deattributions | datascape_deattributions | met | The total number of users that are removed away from the first attribution source to a reattribution source. | |
| Reattributions | datascape_reattributions | met | The total number of reattributions that have occurred. | |
| Reattribution reinstalls | datascape_reattribution_reinstalls | met | Number of reinstalls that also led to a reattribution. | |
| LAT installs | datascape_limit_ad_tracking_installs | met | Number of installs from devices with Limit Ad Tracking enabled | |
| LAT install rate | datascape_limit_ad_tracking_install_rate | met | Proportion of installs from devices with Limit Ad Tracking enabled (limit ad tracking installs/installs) | |
| LAT reattributions | datascape_limit_ad_tracking_reattributions | met | Number of reattributions from devices with Limit Ad Tracking enabled | |
| LAT reattribution rate | datascape_limit_ad_tracking_reattribution_rate | met | Proportion of installs from devices with Limit Ad Tracking enabled (limit ad tracking reattributions/reattributions) | |
| GDPR forgets | datascape_gdpr_forgets | met | The total number of users who have exercised their right to be forgotten. Adjust permanently deletes the historical personal data for all of these users but retains their aggregated data for dashboard reporting. Their device data will no longer be received by Adjust or appear anywhere in the Adjust dashboard in the future. | |
| Rejected installs | datascape_rejected_installs | met | Number of rejected installs (rejected installs anon IP + rejected installs too many engagements + rejected installs distribution outlier + rejected installs click injection | |
| Rejected installs (Anonymous IP) | datascape_rejected_installs_anon_ip | met | Number of rejected installs due to anonymous IP | |
| Rejected installs (too many engagements) | datascape_rejected_installs_too_many_engagements | met | Number of rejected installs due to too many engagements | |
| Rejected installs distribution outlier | datascape_rejected_installs_distribution_outlier | met | Number of rejected installs due to distribution outliers | |
| Rejected installs click injection | datascape_rejected_installs_click_injection | met | Number of rejected installs due to engagement injection | |
| Rejected installs invalid signature | datascape_rejected_installs_invalid_signature | met | Number of rejected installs due to a missing or invalid SDK Signature | |
| Rejected reattributions | datascape_rejected_reattributions | met | Number of rejected reattributions (rejected reattributions anon IP + rejected reattributions too many engagements + rejected reattributions distribution outlier + rejected reattributions click injection). | |
| Rejected reattributions (Anonymous IP) | datascape_rejected_reattributions_anon_ip | met | Number of rejected reattributions due to anonymous IP | |
| Rejected reattributions too many engagements | datascape_rejected_reattributions_too_many_engagements | met | Number of rejected reattributions due to too many engagements | |
| Rejected reattributions distribution outliers | datascape_rejected_reattributions_distribution_outlier | met | Number of rejected reattributions due to distribution outliers | |
| Rejected reattributions click injection | datascape_rejected_reattributions_click_injection | met | Number rejected reattributions due to engagement injection | |
| Rejected install rate | datascape_rejected_install_rate | met | Rejected install rate (rejected installs/(installs + rejected installs)) | |
| Rejected install anon IP rate | datascape_rejected_install_anon_ip_rate | met | Rate of rejected installs due to anonymous IP (rejected installs anon IP/(installs + rejected installs)) | |
| Rejected install too many engagements rate | datascape_rejected_install_too_many_engagements_rate | met | Rate of rejected installs due to too many engagements (rejected installs too many engagements/(installs + rejected installs)) | |
| Rejected install distribution outlier rate | datascape_rejected_install_distribution_outlier_rate | met | Rate of rejected installs due to distribution outliers (rejected installs distribution outlier/(installs + rejected installs)) | |
| Rejected install click injection rate | datascape_rejected_install_click_injection_rate | met | Rate of rejected installs due to engagement injection (rejected installs click injection/(installs + rejected installs)) | |
| Rejected reattribution rate | datascape_rejected_reattribution_rate | met | Rejected reattributions rate (rejected reattributions/(reattributions + rejected reattributions)) | |
| Rejected reattribution (Anonymous IP rate) | datascape_rejected_reattribution_anon_ip_rate | met | Rate of rejected reattributions due to anonymous IP (rejected reattributions anon IP/(reattributions + rejected reattributions)) | |
| Rejected reattribution too many engagements rate | datascape_rejected_reattribution_too_many_engagements_rate | met | Rate of rejected reattributions due to too many engagements (rejected reattributions too many engagements/(reattributions + rejected reattributions)) | |
| Rejected reattribution distribution outlier rate | datascape_rejected_reattribution_distribution_outlier_rate | met | Rate of rejected reattributions due to distribution outliers (rejected reattributions distribution outlier/(reattributions + rejected reattributions)) | |
| Rejected reattribution click injection rate | datascape_rejected_reattribution_click_injection_rate | met | Rate of rejected reattributions due to engagement injection (rejected reattributions click injection/(reattributions + rejected reattributions)) | |
| Ad spend | datascape_cost | met | The amount of money spent on ads. Calculated as the sum of click cost + impression cost + install cost + event cost. | |
| Ad spend (attribution) | datascape_adjust_cost | met | The amount of money spent on ads. Calculated using only data retrieved using Adjust’s cost-on-engagement method. Calculated as the sum of click_cost + impression_cost + install_cost + event_cost. | |
| Ad spend (network) | datascape_network_cost | met | Shows ad spend data retrieved using the Network API. Calculated as the sum of click_cost + impression_cost + install_cost+ event_cost. | |
| Ad spend (network - SKAdNetwork) | datascape_network_ad_spend_skan | met | The amount of ad spend related to SKAdNetwork campaigns, as reported by the network partner. | |
| Ad spend diff (network) | datascape_network_cost_diff | met | Shows an absolute value with the difference between the Attribution and Network sources. Calculated as Ad spend (attribution) - Ad spend (network). | |
| Click cost | datascape_click_cost | met | The costs of clicks. | |
| Paid clicks | datascape_paid_clicks | met | The number of clicks, for which there is cost data | |
| Paid installs | datascape_paid_installs | met | The number of installs, for which there is cost data | |
| Paid impressions | datascape_paid_impressions | met | The number of impressions, for which there is cost data | |
| Install cost | datascape_install_cost | met | The costs of installs. | |
| Impression cost | datascape_impression_cost | met | The costs of impressions. | |
| Event cost | datascape_event_cost | met | The costs of events. | |
| Effective cost per click | datascape_ecpc | met | Effective cost per click (ecpc = Ad spend / paid clicks) | |
| eCPI (all installs) | datascape_ecpi_all | met | Effective cost per install on all installs (Ad spend / installs) | |
| eCPI (paid installs) | datascape_ecpi | met | Effective cost per install on paid installs. Calculated as Ad Spend (Network) / Paid installs. | |
| eCPI (network) | datascape_network_ecpi | met | Effective cost per install reported by the network API. (Ad spend (network) / Network installs) | |
| eCPM (attribution) | datascape_ecpm | met | Effective cost per mille (one thousand impressions) reported by the Attribution ad spend source. (Ad spend / paid impressions * 1000) | |
| Revenue | datascape_revenue | met | The total revenue your app has generated within a selected timeframe based on the tracked revenue events reported by the Adjust SDK or as recorded via server-to-server event tracking. | |
| All revenue | datascape_all_revenue | met | The amount of revenue, generated by an app, calculated using all revenue sources. | |
| Ad revenue | datascape_ad_revenue | met | The total revenue generated by serving in-app ads. | |
| Revenue events | datascape_revenue_events | met | Number of revenue events | |
| Revenue (cohort) | datascape_cohort_revenue | met | Total revenue from users who were (re)attributed within your selected timeframe. | |
| Ad revenue (cohort) | datascape_cohort_ad_revenue | met | Total ad revenue from users who installed in your selected timeframe. | |
| All revenue (cohort) | datascape_cohort_all_revenue | met | All cohort revenue (cohort revenue + cohort ad revenue) | |
| Gross profit | datascape_gross_profit | met | The cohorted gross profit. | |
| Gross profit (cohort) | datascape_cohort_gross_profit | met | The gross profit (cohort all revenue - cost) | |
| ROI | datascape_return_on_investment | met | The ROI metric (cohort gross profit / Ad spend) | |
| Revenue-to-cost ratio | datascape_revenue_to_cost | met | The revenue-to-cost ratio (cohort all revenue / ad spend). | |
| ROAS (all revenue) | datascape_roas | met | Return on ad spend, calculated using all sources of revenue. (Cohort revenue + Cohort ad revenue) / Ad spend. | |
| ROAS (ad revenue) | datascape_roas_ad | met | Return on ad spend, calculated using only ad revenue. Cohort ad revenue / Ad spend. | |
| ROAS (IAP revenue) | datascape_roas_iap | met | Return on ad spend, calculated using only in-app revenue. Cohort revenue / Ad spend. | |
| Time | Year | kpis_year | dim | |
| Year of week (Sun-Sat) | kpis_year_of_week | dim | ||
| Year of week (Mon-Sun) | kpis_year_of_week_iso | dim | ||
| Year & month | kpis_year_month | dim | ||
| Month | kpis_month | dim | ||
| Year & week (Sun-Sat) | kpis_year_week | dim | ||
| Year & week (Mon-Sun) | kpis_year_week_iso | dim | ||
| Week (Sun-Sat) | kpis_week | dim | ||
| Week (Mon-Sun) | kpis_week_iso | dim | ||
| Day of month | kpis_day_of_month | dim | ||
| Day of week (Sun-Sat) | kpis_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | kpis_day_of_week_name_iso | dim | ||
| Date | kpis_date | dim | ||
| Datetime | kpis_atom | dim | ||
| Event | Event name | kpis_event | dim | Name of the event. Only compatible with 'Revenue' and 'Events' metrics |
| Event token | kpis_eventss | dim | Name of the event. | |
| App | App name | kpis_apps | dim | Grouping per-app |
| App token | kpis_app_id | dim | ID of the app | |
| Tracker | Tracker name | kpis_trackers | dim | Tracker grouping allows you to break data down by tracker, in line with the tracker tree. |
| Tracker token | kpis_trackerss | dim | ID of the tracker. | |
| Campaign | Campaign | kpis_campaigns | dim | Campaign trackers |
| Tracker token (campaign) | kpis_tracker_token_campaign | dim | The tracker token of campaign. | |
| Ad group | kpis_adgroups | dim | If the tracker token is present, then results will be grouped by adgroups scoped by that tracker token. If the tracker token is not present, then the results will be grouped by all adgroups. | |
| Tracker token (ad group) | kpis_tracker_token_adgroup | dim | The tracker token of ad group. | |
| Creative | kpis_creatives | dim | If the tracker token is present, then results will be grouped by creatives scoped by that tracker token. If the tracker token is not present, then the results will be grouped by all creatives. | |
| Tracker token (creative) | kpis_tracker_token_creative | dim | The tracker token of creative. | |
| Network | kpis_networks | dim | If the tracker token is present, then results will be grouped by networks scoped by that tracker token. If the tracker token is not present, then results will be grouped by all networks. | |
| Tracker token (network) | kpis_tracker_token_network | dim | The tracker token of network. | |
| Partner | kpis_partners | dim | Group by partner name | |
| Geo | Country | kpis_countries | dim | Group by country |
| Region | kpis_regions | dim | Group by business region | |
| Device | Device type | kpis_device_types | dim | Group by device type |
| OS name | kpis_os_names | dim | Group by OS names | |
| Events | kpis_events | met | Number of events. | |
| Clicks | kpis_clicks | met | Number of clicks | |
| Impressions | kpis_impressions | met | Number of impressions | |
| Revenue | kpis_revenue | met | Total revenue (in the app's reporting currency) | |
| All revenue | kpis_all_revenue | met | revenue + ad_revenue | |
| Revenue events | kpis_revenue_events | met | Number of revenue events | |
| CTR | kpis_ctr | met | Click through rate (clicks/impressions weighted by impressions). | |
| Sessions | kpis_sessions | met | Number of sessions | |
| Installs | kpis_installs | met | Number of installs | |
| Uninstalls | kpis_uninstalls | met | Number of uninstalls | |
| Reinstalls | kpis_reinstalls | met | Number of reinstalls | |
| Conversion rate | kpis_click_conversion_rate | met | Click conversion rate (an average of installs/clicks weighted by clicks). | |
| Impression CVR | kpis_impression_conversion_rate | met | Impression conversion rate (an average of installs/impressions weighted by impressions). | |
| Reattributions | kpis_reattributions | met | Number of reattributions | |
| Reattribution reinstalls | kpis_reattribution_reinstalls | met | Number of reinstalls that also led to a reattribution | |
| Deattributions | kpis_deattributions | met | Number of deattributions | |
| Cohort revenue | kpis_cohort_revenue | met | Total revenue from users who were (re)attributed within your selected timeframe | |
| Avg. DAUs | kpis_daus | met | Average daily active users | |
| Avg. WAUs | kpis_waus | met | Average weekly active users | |
| Avg. MAUs | kpis_maus | met | Average monthly active users | |
| LAT installs | kpis_limit_ad_tracking_installs | met | Number of installs from devices with Limit Ad Tracking enabled | |
| LAT install rate | kpis_limit_ad_tracking_install_rate | met | Proportion of installs from devices with Limit Ad Tracking enabled (limit ad tracking installs/installs) | |
| LAT reattributions | kpis_limit_ad_tracking_reattributions | met | Number of reattributions from devices with Limit Ad Tracking enabled | |
| LAT reattribution rate | kpis_limit_ad_tracking_reattribution_rate | met | Proportion of installs from devices with Limit Ad Tracking enabled (limit ad tracking reattributions/reattributions) | |
| GDPR forgets | kpis_gdpr_forgets | met | The total number of users who have exercised their right to be forgotten. Adjust permanently deletes the historical personal data for all of these users but retains their aggregated data for dashboard reporting. Their device data will no longer be received by Adjust or appear anywhere in the Adjust dashboard in the future. | |
| Cohort ad revenue | kpis_cohort_ad_revenue | met | Total ad revenue from users who installed in your selected timeframe | |
| Cohort all revenue | kpis_cohort_all_revenue | met | All cohort revenue (cohort revenue + cohort ad revenue) | |
| Rejected installs | kpis_rejected_installs | met | Number of rejected installs (rejected installs anon IP + rejected installs too many engagements + rejected installs distribution outlier + rejected installs click injection | |
| Rejected installs (Anonymous IP) | kpis_rejected_installs_anon_ip | met | Number of rejected installs due to anonymous IP | |
| Rejected installs (too many engagements) | kpis_rejected_installs_too_many_engagements | met | Number of rejected installs due to too many engagements | |
| Rejected installs distribution outlier | kpis_rejected_installs_distribution_outlier | met | Number of rejected installs due to distribution outliers | |
| Rejected installs click injection | kpis_rejected_installs_click_injection | met | Number of rejected installs due to engagement injection | |
| Rejected installs invalid signature | kpis_rejected_installs_invalid_signature | met | Number of rejected installs due to a missing or invalid SDK Signature | |
| Rejected reattributions | kpis_rejected_reattributions | met | Number of rejected reattributions (rejected reattributions anon IP + rejected reattributions too many engagements + rejected reattributions distribution outlier + rejected reattributions click injection | |
| Rejected reattributions (Anonymous IP) | kpis_rejected_reattributions_anon_ip | met | Number of rejected reattributions due to anonymous IP | |
| Rejected reattributions too many engagements | kpis_rejected_reattributions_too_many_engagements | met | Number of rejected reattributions due to too many engagements | |
| Rejected reattributions distribution outliers | kpis_rejected_reattributions_distribution_outlier | met | Number of rejected reattributions due to distribution outliers | |
| Rejected reattributions click injection | kpis_rejected_reattributions_click_injection | met | Number rejected reattributions due to engagement injection | |
| Rejected install rate | kpis_rejected_install_rate | met | Rejected install rate (rejected installs/(installs + rejected installs)) | |
| Rejected install anon IP rate | kpis_rejected_install_anon_ip_rate | met | Rate of rejected installs due to anonymous IP (rejected installs anon IP/(installs + rejected installs)) | |
| Rejected install too many engagements rate | kpis_rejected_install_too_many_engagements_rate | met | Rate of rejected installs due to too many engagements (rejected installs too many engagements/(installs + rejected installs)) | |
| Rejected install distribution outlier rate | kpis_rejected_install_distribution_outlier_rate | met | Rate of rejected installs due to distribution outliers (rejected installs distribution outlier/(installs + rejected installs)) | |
| Rejected install click injection rate | kpis_rejected_install_click_injection_rate | met | Rate of rejected installs due to engagement injection (rejected installs click injection/(installs + rejected installs)) | |
| Rejected reattribution rate | kpis_rejected_reattribution_rate | met | Rejected reattributions rate (rejected reattributions/(reattributions + rejected reattributions)) | |
| Rejected reattribution (Anonymous IP rate) | kpis_rejected_reattribution_anon_ip_rate | met | Rate of rejected reattributions due to anonymous IP (rejected reattributions anon IP/(reattributions + rejected reattributions)) | |
| Rejected reattribution too many engagements rate | kpis_rejected_reattribution_too_many_engagements_rate | met | Rate of rejected reattributions due to too many engagements (rejected reattributions too many engagements/(reattributions + rejected reattributions)) | |
| Rejected reattribution distribution outlier rate | kpis_rejected_reattribution_distribution_outlier_rate | met | Rate of rejected reattributions due to distribution outliers (rejected reattributions distribution outlier/(reattributions + rejected reattributions)) | |
| Rejected reattribution click injection rate | kpis_rejected_reattribution_click_injection_rate | met | Rate of rejected reattributions due to engagement injection (rejected reattributions click injection/(reattributions + rejected reattributions)) | |
| Install cost | kpis_install_cost | met | Install cost | |
| CPC | kpis_click_cost | met | Click cost | |
| Impression cost | kpis_impression_cost | met | Impression cost | |
| Event cost | kpis_event_cost | met | Event cost | |
| Total cost | kpis_cost | met | Total cost (click cost + impression cost + install cost + event cost) | |
| Ecost | kpis_ecost | met | Total cost for eCPI, eCPC, and eCPM (ecost = click cost + impression cost + install cost) | |
| Paid installs | kpis_paid_installs | met | The number of installs, for which there is cost data | |
| Paid clicks | kpis_paid_clicks | met | The number of clicks, for which there is cost data | |
| Paid impressions | kpis_paid_impressions | met | The number of impressions, for which there is cost data | |
| Cost per event | kpis_cpe | met | Total cost per event (cpe = event cost / paid events) | |
| Effective cost per click | kpis_ecpc | met | Effective cost per click (ecpc = ecpi cost / paid clicks) | |
| Effective cost per install | kpis_ecpi | met | Effective cost per install (ecpi cost / paid installs) | |
| Effective cost per mille | kpis_ecpm | met | Effective cost per mille (one thousand impressions) (ecpi cost / paid impressions * 1000) | |
| Cohort gross profit | kpis_cohort_gross_profit | met | The gross profit (cohort all revenue - cost) | |
| ROI | kpis_return_on_investment | met | The ROI metric (cohort gross profit / cost) | |
| Revenue-to-cost ratio | kpis_rcr | met | The revenue-to-cost ratio (cohort all revenue / cost) | |
| Return on ad spend | kpis_roas | met | Return on ad spend (cohort all revenue / cost *100) |