--- title: "Axon by AppLovin metrics and dimensions" slug: "axon-by-applovin-fields" description: "Explore the Axon by AppLovin metrics and dimensions available through Supermetrics. Find the fields you need for your ideal marketing reports." updated: 2026-03-18T08:00:51Z published: 2026-03-18T08:00:51Z canonical: "docs.supermetrics.com/axon-by-applovin-fields" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt > Use this file to discover all available pages before exploring further. # Axon by AppLovin metrics and dimensions > Supermetrics brings all your Axon by AppLovin data into [Google Sheets](https://workspace.google.com/marketplace/app/supermetrics/523876908005), [Looker Studio](https://supermetrics.com/products/looker-studio), [Power BI](https://supermetrics.com/products/power-bi), [Excel](https://supermetrics.com/products/excel), [BigQuery](https://supermetrics.com/products/bigquery), [Snowflake](https://supermetrics.com/products/snowflake), [Redshift](https://supermetrics.com/products/amazon-redshift), [Azure](https://supermetrics.com/products/azure-synapse) 27 metrics41 dimensionsSearch fields ### AD | \| ad \| \| --- \| \| \\| Field label \\| Ad name \\| \\| --- \\| --- \\| \\| Description \\| Ad name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Ad name \| \| Description \| Ad name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | ad | | \| Field label \| Ad name \| \| --- \| --- \| \| Description \| Ad name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Ad name | | Description | Ad name | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| ad_id \| \| --- \| \| \\| Field label \\| Ad ID \\| \\| --- \\| --- \\| \\| Description \\| Ad ID. This does not change if the ad name changes \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Ad ID \| \| Description \| Ad ID. This does not change if the ad name changes \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | ad_id | | \| Field label \| Ad ID \| \| --- \| --- \| \| Description \| Ad ID. This does not change if the ad name changes \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Ad ID | | Description | Ad ID. This does not change if the ad name changes | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| ad_type \| \| --- \| \| \\| Field label \\| Ad type \\| \\| --- \\| --- \\| \\| Description \\| Ad type (APPOPEN, GRAPHIC, PLAY, REWARD, or VIDEO) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Ad type \| \| Description \| Ad type (APPOPEN, GRAPHIC, PLAY, REWARD, or VIDEO) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | ad_type | | \| Field label \| Ad type \| \| --- \| --- \| \| Description \| Ad type (APPOPEN, GRAPHIC, PLAY, REWARD, or VIDEO) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Ad type | | Description | Ad type (APPOPEN, GRAPHIC, PLAY, REWARD, or VIDEO) | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| size \| \| --- \| \| \\| Field label \\| Ad size \\| \\| --- \\| --- \\| \\| Description \\| Ad size (BANNER, INTER, LEADER, MREC, NATIVE, or PRELOAD) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Ad size \| \| Description \| Ad size (BANNER, INTER, LEADER, MREC, NATIVE, or PRELOAD) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | size | | \| Field label \| Ad size \| \| --- \| --- \| \| Description \| Ad size (BANNER, INTER, LEADER, MREC, NATIVE, or PRELOAD) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Ad size | | Description | Ad size (BANNER, INTER, LEADER, MREC, NATIVE, or PRELOAD) | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### CAMPAIGN | \| campaign \| \| --- \| \| \\| Field label \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Campaign name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Campaign name \| \| Description \| Campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | campaign | | \| Field label \| Campaign name \| \| --- \| --- \| \| Description \| Campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Campaign name | | Description | Campaign name | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign_id_external \| \| --- \| \| \\| Field label \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| Unique reference to a campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Campaign ID \| \| Description \| Unique reference to a campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign_id_external | | \| Field label \| Campaign ID \| \| --- \| --- \| \| Description \| Unique reference to a campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Campaign ID | | Description | Unique reference to a campaign | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign_bid_goal \| \| --- \| \| \\| Field label \\| Campaign bid goal \\| \\| --- \\| --- \\| \\| Description \\| The campaign bid goal, expressed as a dollar value ($), for CPP and CPE campaigns. You must also request the campaign column when you request this one \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Campaign bid goal \| \| Description \| The campaign bid goal, expressed as a dollar value ($), for CPP and CPE campaigns. You must also request the campaign column when you request this one \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign_bid_goal | | \| Field label \| Campaign bid goal \| \| --- \| --- \| \| Description \| The campaign bid goal, expressed as a dollar value ($), for CPP and CPE campaigns. You must also request the campaign column when you request this one \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Campaign bid goal | | Description | The campaign bid goal, expressed as a dollar value ($), for CPP and CPE campaigns. You must also request the campaign column when you request this one | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### COHORT (CHECKOUT REVENUE) | \| checkout_usd_0d \| \| --- \| \| \\| Field label \\| Checkout revenue (d0) \\| \\| --- \\| --- \\| \\| Description \\| Total attributed checkout revenue that occurred within 24 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Checkout revenue (d0) \| \| Description \| Total attributed checkout revenue that occurred within 24 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | --- | | checkout_usd_0d | | \| Field label \| Checkout revenue (d0) \| \| --- \| --- \| \| Description \| Total attributed checkout revenue that occurred within 24 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Checkout revenue (d0) | | Description | Total attributed checkout revenue that occurred within 24 hours since the impression time | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| checkout_usd_1d \| \| --- \| \| \\| Field label \\| Checkout revenue (d1) \\| \\| --- \\| --- \\| \\| Description \\| Total attributed checkout revenue that occurred within 48 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Checkout revenue (d1) \| \| Description \| Total attributed checkout revenue that occurred within 48 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | checkout_usd_1d | | \| Field label \| Checkout revenue (d1) \| \| --- \| --- \| \| Description \| Total attributed checkout revenue that occurred within 48 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Checkout revenue (d1) | | Description | Total attributed checkout revenue that occurred within 48 hours since the impression time | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| checkout_usd_2d \| \| --- \| \| \\| Field label \\| Checkout revenue (d2) \\| \\| --- \\| --- \\| \\| Description \\| Total attributed checkout revenue that occurred within 72 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Checkout revenue (d2) \| \| Description \| Total attributed checkout revenue that occurred within 72 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | checkout_usd_2d | | \| Field label \| Checkout revenue (d2) \| \| --- \| --- \| \| Description \| Total attributed checkout revenue that occurred within 72 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Checkout revenue (d2) | | Description | Total attributed checkout revenue that occurred within 72 hours since the impression time | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| checkout_usd_3d \| \| --- \| \| \\| Field label \\| Checkout revenue (d3) \\| \\| --- \\| --- \\| \\| Description \\| Total attributed checkout revenue that occurred within 96 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Checkout revenue (d3) \| \| Description \| Total attributed checkout revenue that occurred within 96 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | checkout_usd_3d | | \| Field label \| Checkout revenue (d3) \| \| --- \| --- \| \| Description \| Total attributed checkout revenue that occurred within 96 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Checkout revenue (d3) | | Description | Total attributed checkout revenue that occurred within 96 hours since the impression time | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| checkout_usd_7d \| \| --- \| \| \\| Field label \\| Checkout revenue (d7) \\| \\| --- \\| --- \\| \\| Description \\| Total attributed checkout revenue that occurred within 192 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Checkout revenue (d7) \| \| Description \| Total attributed checkout revenue that occurred within 192 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | checkout_usd_7d | | \| Field label \| Checkout revenue (d7) \| \| --- \| --- \| \| Description \| Total attributed checkout revenue that occurred within 192 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Checkout revenue (d7) | | Description | Total attributed checkout revenue that occurred within 192 hours since the impression time | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | ### COHORT (CHECKOUTS) | \| checkouts_0d \| \| --- \| \| \\| Field label \\| Checkouts (d0) \\| \\| --- \\| --- \\| \\| Description \\| Attributed checkouts that occurred within 24 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Checkouts (d0) \| \| Description \| Attributed checkouts that occurred within 24 hours since the impression time \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | --- | | checkouts_0d | | \| Field label \| Checkouts (d0) \| \| --- \| --- \| \| Description \| Attributed checkouts that occurred within 24 hours since the impression time \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Checkouts (d0) | | Description | Attributed checkouts that occurred within 24 hours since the impression time | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| checkouts_1d \| \| --- \| \| \\| Field label \\| Checkouts (d1) \\| \\| --- \\| --- \\| \\| Description \\| Attributed checkouts that occurred within 48 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Checkouts (d1) \| \| Description \| Attributed checkouts that occurred within 48 hours since the impression time \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | checkouts_1d | | \| Field label \| Checkouts (d1) \| \| --- \| --- \| \| Description \| Attributed checkouts that occurred within 48 hours since the impression time \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Checkouts (d1) | | Description | Attributed checkouts that occurred within 48 hours since the impression time | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| checkouts_2d \| \| --- \| \| \\| Field label \\| Checkouts (d2) \\| \\| --- \\| --- \\| \\| Description \\| Attributed checkouts that occurred within 72 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Checkouts (d2) \| \| Description \| Attributed checkouts that occurred within 72 hours since the impression time \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | checkouts_2d | | \| Field label \| Checkouts (d2) \| \| --- \| --- \| \| Description \| Attributed checkouts that occurred within 72 hours since the impression time \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Checkouts (d2) | | Description | Attributed checkouts that occurred within 72 hours since the impression time | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| checkouts_3d \| \| --- \| \| \\| Field label \\| Checkouts (d3) \\| \\| --- \\| --- \\| \\| Description \\| Attributed checkouts that occurred within 96 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Checkouts (d3) \| \| Description \| Attributed checkouts that occurred within 96 hours since the impression time \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | checkouts_3d | | \| Field label \| Checkouts (d3) \| \| --- \| --- \| \| Description \| Attributed checkouts that occurred within 96 hours since the impression time \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Checkouts (d3) | | Description | Attributed checkouts that occurred within 96 hours since the impression time | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| checkouts_7d \| \| --- \| \| \\| Field label \\| Checkouts (d7) \\| \\| --- \\| --- \\| \\| Description \\| Attributed checkouts that occurred within 192 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Checkouts (d7) \| \| Description \| Attributed checkouts that occurred within 192 hours since the impression time \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | checkouts_7d | | \| Field label \| Checkouts (d7) \| \| --- \| --- \| \| Description \| Attributed checkouts that occurred within 192 hours since the impression time \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Checkouts (d7) | | Description | Attributed checkouts that occurred within 192 hours since the impression time | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | ### COHORT (CPP) | \| cpp_0d \| \| --- \| \| \\| Field label \\| CPP (d0) \\| \\| --- \\| --- \\| \\| Description \\| CPP within 24 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| CPP (d0) \| \| Description \| CPP within 24 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | --- | | cpp_0d | | \| Field label \| CPP (d0) \| \| --- \| --- \| \| Description \| CPP within 24 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | CPP (d0) | | Description | CPP within 24 hours since the impression time | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| cpp_1d \| \| --- \| \| \\| Field label \\| CPP (d1) \\| \\| --- \\| --- \\| \\| Description \\| CPP within 48 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| CPP (d1) \| \| Description \| CPP within 48 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | cpp_1d | | \| Field label \| CPP (d1) \| \| --- \| --- \| \| Description \| CPP within 48 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | CPP (d1) | | Description | CPP within 48 hours since the impression time | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| cpp_2d \| \| --- \| \| \\| Field label \\| CPP (d2) \\| \\| --- \\| --- \\| \\| Description \\| CPP within 72 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| CPP (d2) \| \| Description \| CPP within 72 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | cpp_2d | | \| Field label \| CPP (d2) \| \| --- \| --- \| \| Description \| CPP within 72 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | CPP (d2) | | Description | CPP within 72 hours since the impression time | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| cpp_3d \| \| --- \| \| \\| Field label \\| CPP (d3) \\| \\| --- \\| --- \\| \\| Description \\| CPP within 96 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| CPP (d3) \| \| Description \| CPP within 96 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | cpp_3d | | \| Field label \| CPP (d3) \| \| --- \| --- \| \| Description \| CPP within 96 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | CPP (d3) | | Description | CPP within 96 hours since the impression time | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| cpp_7d \| \| --- \| \| \\| Field label \\| CPP (d7) \\| \\| --- \\| --- \\| \\| Description \\| CPP within 192 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| CPP (d7) \| \| Description \| CPP within 192 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | cpp_7d | | \| Field label \| CPP (d7) \| \| --- \| --- \| \| Description \| CPP within 192 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | CPP (d7) | | Description | CPP within 192 hours since the impression time | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | ### COHORT (ROAS) | \| roas_0d \| \| --- \| \| \\| Field label \\| ROAS (d0) \\| \\| --- \\| --- \\| \\| Description \\| Checkout ROAS generated within 24 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| ROAS (d0) \| \| Description \| Checkout ROAS generated within 24 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | --- | | roas_0d | | \| Field label \| ROAS (d0) \| \| --- \| --- \| \| Description \| Checkout ROAS generated within 24 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Field label | ROAS (d0) | | Description | Checkout ROAS generated within 24 hours since the impression time | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| roas_1d \| \| --- \| \| \\| Field label \\| ROAS (d1) \\| \\| --- \\| --- \\| \\| Description \\| Checkout ROAS generated within 48 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| ROAS (d1) \| \| Description \| Checkout ROAS generated within 48 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | roas_1d | | \| Field label \| ROAS (d1) \| \| --- \| --- \| \| Description \| Checkout ROAS generated within 48 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Field label | ROAS (d1) | | Description | Checkout ROAS generated within 48 hours since the impression time | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| roas_2d \| \| --- \| \| \\| Field label \\| ROAS (d2) \\| \\| --- \\| --- \\| \\| Description \\| Checkout ROAS generated within 72 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| ROAS (d2) \| \| Description \| Checkout ROAS generated within 72 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | roas_2d | | \| Field label \| ROAS (d2) \| \| --- \| --- \| \| Description \| Checkout ROAS generated within 72 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Field label | ROAS (d2) | | Description | Checkout ROAS generated within 72 hours since the impression time | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| roas_3d \| \| --- \| \| \\| Field label \\| ROAS (d3) \\| \\| --- \\| --- \\| \\| Description \\| Checkout ROAS generated within 96 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| ROAS (d3) \| \| Description \| Checkout ROAS generated within 96 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | roas_3d | | \| Field label \| ROAS (d3) \| \| --- \| --- \| \| Description \| Checkout ROAS generated within 96 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Field label | ROAS (d3) | | Description | Checkout ROAS generated within 96 hours since the impression time | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| roas_7d \| \| --- \| \| \\| Field label \\| ROAS (d7) \\| \\| --- \\| --- \\| \\| Description \\| Checkout ROAS generated within 192 hours since the impression time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| ROAS (d7) \| \| Description \| Checkout ROAS generated within 192 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | roas_7d | | \| Field label \| ROAS (d7) \| \| --- \| --- \| \| Description \| Checkout ROAS generated within 192 hours since the impression time \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Field label | ROAS (d7) | | Description | Checkout ROAS generated within 192 hours since the impression time | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | ### CREATIVE | \| creative_set \| \| --- \| \| \\| Field label \\| Creative set name \\| \\| --- \\| --- \\| \\| Description \\| Creative set name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Creative set name \| \| Description \| Creative set name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | creative_set | | \| Field label \| Creative set name \| \| --- \| --- \| \| Description \| Creative set name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creative set name | | Description | Creative set name | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| creative_set_id \| \| --- \| \| \\| Field label \\| Creative set ID \\| \\| --- \\| --- \\| \\| Description \\| Creative set ID. This does not change if the creative set name changes \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Creative set ID \| \| Description \| Creative set ID. This does not change if the creative set name changes \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | creative_set_id | | \| Field label \| Creative set ID \| \| --- \| --- \| \| Description \| Creative set ID. This does not change if the creative set name changes \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creative set ID | | Description | Creative set ID. This does not change if the creative set name changes | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| ad_creative_type \| \| --- \| \| \\| Field label \\| Creative type \\| \\| --- \\| --- \\| \\| Description \\| Creative type (GRAPHIC, PLAYABLE, VIDEO, or VIDEO_PLAYABLE) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Creative type \| \| Description \| Creative type (GRAPHIC, PLAYABLE, VIDEO, or VIDEO_PLAYABLE) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | ad_creative_type | | \| Field label \| Creative type \| \| --- \| --- \| \| Description \| Creative type (GRAPHIC, PLAYABLE, VIDEO, or VIDEO_PLAYABLE) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creative type | | Description | Creative type (GRAPHIC, PLAYABLE, VIDEO, or VIDEO_PLAYABLE) | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### DATASOURCE | \| dataSourceName \| \| --- \| \| \\| Field label \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| | | --- | | dataSourceName | | \| Field label \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| | | Field label | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | Destinations | API, Data warehouse | | \| system_metadata.data_source_logins \| \| --- \| \| \\| Field label \\| Data source logins \\| \\| --- \\| --- \\| \\| Description \\| The data source login accounts that were used to authenticate against the data source \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source logins \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.data_source_logins | | \| Field label \| Data source logins \| \| --- \| --- \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Data source logins | | Description | The data source login accounts that were used to authenticate against the data source | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | | \| system_metadata.data_source_login_owners \| \| --- \| \| \\| Field label \\| Data source login owners \\| \\| --- \\| --- \\| \\| Description \\| The Supermetrics users that created the data source login connections \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source login owners \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.data_source_login_owners | | \| Field label \| Data source login owners \| \| --- \| --- \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Data source login owners | | Description | The Supermetrics users that created the data source login connections | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | ### OTHER | \| placement_type \| \| --- \| \| \\| Field label \\| Placement \\| \\| --- \\| --- \\| \\| Description \\| Placement type (APP_OPEN, ARRAY, BANNER, CTV, INTER, LEADER, MREC, NATIVE, or REWARDED_INTER) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Placement \| \| Description \| Placement type (APP_OPEN, ARRAY, BANNER, CTV, INTER, LEADER, MREC, NATIVE, or REWARDED_INTER) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | placement_type | | \| Field label \| Placement \| \| --- \| --- \| \| Description \| Placement type (APP_OPEN, ARRAY, BANNER, CTV, INTER, LEADER, MREC, NATIVE, or REWARDED_INTER) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Placement | | Description | Placement type (APP_OPEN, ARRAY, BANNER, CTV, INTER, LEADER, MREC, NATIVE, or REWARDED_INTER) | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| platform \| \| --- \| \| \\| Field label \\| Platform \\| \\| --- \\| --- \\| \\| Description \\| Android, IOS, Fire OS, or tvOS \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Platform \| \| Description \| Android, IOS, Fire OS, or tvOS \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | platform | | \| Field label \| Platform \| \| --- \| --- \| \| Description \| Android, IOS, Fire OS, or tvOS \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Platform | | Description | Android, IOS, Fire OS, or tvOS | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| country \| \| --- \| \| \\| Field label \\| Country \\| \\| --- \\| --- \\| \\| Description \\| Two letter country code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Country \| \| Description \| Two letter country code \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| | | country | | \| Field label \| Country \| \| --- \| --- \| \| Description \| Two letter country code \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| | | Field label | Country | | Description | Two letter country code | | Field type | dimension | | Data type | [string.geo.country](/apidocs/field-data-types#geographical) | | \| a_custom_page_id \| \| --- \| \| \\| Field label \\| Custom page ID \\| \\| --- \\| --- \\| \\| Description \\| The specific landing page \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Custom page ID \| \| Description \| The specific landing page \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | a_custom_page_id | | \| Field label \| Custom page ID \| \| --- \| --- \| \| Description \| The specific landing page \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | Field label | Custom page ID | | Description | The specific landing page | | Field type | dimension | | Data type | [string.text.url](/apidocs/field-data-types#text) | ### PERFORMANCE | \| impressions \| \| --- \| \| \\| Field label \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Number of impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Impressions \| \| Description \| Number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | --- | | impressions | | \| Field label \| Impressions \| \| --- \| --- \| \| Description \| Number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Impressions | | Description | Number of impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| clicks \| \| --- \| \| \\| Field label \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | clicks | | \| Field label \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| spend \| \| --- \| \| \\| Field label \\| Spend \\| \\| --- \\| --- \\| \\| Description \\| Advertiser spend \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Spend \| \| Description \| Advertiser spend \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | spend | | \| Field label \| Spend \| \| --- \| --- \| \| Description \| Advertiser spend \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Spend | | Description | Advertiser spend | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| sales \| \| --- \| \| \\| Field label \\| Sales \\| \\| --- \\| --- \\| \\| Description \\| Count of attributed sales events \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Sales \| \| Description \| Count of attributed sales events \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | sales | | \| Field label \| Sales \| \| --- \| --- \| \| Description \| Count of attributed sales events \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Sales | | Description | Count of attributed sales events | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| ctr \| \| --- \| \| \\| Field label \\| CTR \\| \\| --- \\| --- \\| \\| Description \\| The total click-through rate. (Clicks / Impressions) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| CTR \| \| Description \| The total click-through rate. (Clicks / Impressions) \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | ctr | | \| Field label \| CTR \| \| --- \| --- \| \| Description \| The total click-through rate. (Clicks / Impressions) \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Field label | CTR | | Description | The total click-through rate. (Clicks / Impressions) | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| cpm \| \| --- \| \| \\| Field label \\| CPM \\| \\| --- \\| --- \\| \\| Description \\| The total cost per mille. ((Spend / Impressions) * 1000) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| CPM \| \| Description \| The total cost per mille. ((Spend / Impressions) * 1000) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | cpm | | \| Field label \| CPM \| \| --- \| --- \| \| Description \| The total cost per mille. ((Spend / Impressions) * 1000) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | CPM | | Description | The total cost per mille. ((Spend / Impressions) * 1000) | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| cpc \| \| --- \| \| \\| Field label \\| CPC \\| \\| --- \\| --- \\| \\| Description \\| The total cost per click. (Spend / Clicks) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| CPC \| \| Description \| The total cost per click. (Spend / Clicks) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | cpc | | \| Field label \| CPC \| \| --- \| --- \| \| Description \| The total cost per click. (Spend / Clicks) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | CPC | | Description | The total cost per click. (Spend / Clicks) | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | ### QUERY | \| system_metadata.query_date_range_start \| \| --- \| \| \\| Field label \\| Start date \\| \\| --- \\| --- \\| \\| Description \\| The start date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Start date \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | --- | | system_metadata.query_date_range_start | | \| Field label \| Start date \| \| --- \| --- \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Start date | | Description | The start date of the requested query | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| system_metadata.query_date_range_end \| \| --- \| \| \\| Field label \\| End date \\| \\| --- \\| --- \\| \\| Description \\| The end date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| End date \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | system_metadata.query_date_range_end | | \| Field label \| End date \| \| --- \| --- \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | End date | | Description | The end date of the requested query | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| system_metadata.query_timezone \| \| --- \| \| \\| Field label \\| Timezone \\| \\| --- \\| --- \\| \\| Description \\| The timezone that is supplied to the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.timezone](/apidocs/field-data-types#time) \\| \| \| Field label \| Timezone \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| | | system_metadata.query_timezone | | \| Field label \| Timezone \| \| --- \| --- \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| | | Field label | Timezone | | Description | The timezone that is supplied to the query | | Field type | dimension | | Data type | [string.time.timezone](/apidocs/field-data-types#time) | | \| system_metadata.query_filters \| \| --- \| \| \\| Field label \\| Filters \\| \\| --- \\| --- \\| \\| Description \\| All filters used in the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Filters \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.query_filters | | \| Field label \| Filters \| \| --- \| --- \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Filters | | Description | All filters used in the query | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | | \| system_metadata.query_date_start \| \| --- \| \| \\| Field label \\| Start \\| \\| --- \\| --- \\| \\| Description \\| When the query was started \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Start \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | system_metadata.query_date_start | | \| Field label \| Start \| \| --- \| --- \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Start | | Description | When the query was started | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| system_metadata.query_date_end \| \| --- \| \| \\| Field label \\| End \\| \\| --- \\| --- \\| \\| Description \\| When the query completed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| End \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | system_metadata.query_date_end | | \| Field label \| End \| \| --- \| --- \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | End | | Description | When the query completed | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| system_metadata.query_duration \| \| --- \| \| \\| Field label \\| Duration \\| \\| --- \\| --- \\| \\| Description \\| The duration in seconds of the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.duration.seconds](/apidocs/field-data-types#duration) \\| \| \| Field label \| Duration \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| | | system_metadata.query_duration | | \| Field label \| Duration \| \| --- \| --- \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| | | Field label | Duration | | Description | The duration in seconds of the query | | Field type | dimension | | Data type | [int.duration.seconds](/apidocs/field-data-types#duration) | | \| system_metadata.query_accounts \| \| --- \| \| \\| Field label \\| Accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of accounts of which the data was pulled from \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Accounts \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.query_accounts | | \| Field label \| Accounts \| \| --- \| --- \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Accounts | | Description | A list of accounts of which the data was pulled from | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | | \| system_metadata.query_excluded_accounts \| \| --- \| \| \\| Field label \\| Excluded invalid accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Excluded invalid accounts \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.query_excluded_accounts | | \| Field label \| Excluded invalid accounts \| \| --- \| --- \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Excluded invalid accounts | | Description | A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | ### TIME | \| today \| \| --- \| \| \\| Field label \\| Today \\| \\| --- \\| --- \\| \\| Description \\| Today's date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Today \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| | | --- | | today | | \| Field label \| Today \| \| --- \| --- \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| | | Field label | Today | | Description | Today's date, e.g. 2017-01-31 | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | Destinations | API, Data warehouse | | \| year \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | year | | \| Field label \| Year \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | Field label | Year | | Field type | dimension | | Data type | [string.time.year](/apidocs/field-data-types#time) | | \| year_of_week \| \| --- \| \| \\| Field label \\| Year of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | year_of_week | | \| Field label \| Year of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | Field label | Year of week (Sun-Sat) | | Field type | dimension | | Data type | [string.time.year](/apidocs/field-data-types#time) | | \| year_of_week_iso \| \| --- \| \| \\| Field label \\| Year of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | year_of_week_iso | | \| Field label \| Year of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | Field label | Year of week (Mon-Sun) | | Field type | dimension | | Data type | [string.time.year](/apidocs/field-data-types#time) | | \| year_month \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | year_month | | \| Field label \| Year & month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | Field label | Year & month | | Field type | dimension | | Data type | [string.time.yearmonth](/apidocs/field-data-types#time) | | \| month \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | month | | \| Field label \| Month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | Field label | Month | | Field type | dimension | | Data type | [string.time.month](/apidocs/field-data-types#time) | | \| year_week \| \| --- \| \| \\| Field label \\| Year & week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| | | year_week | | \| Field label \| Year & week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| | | Field label | Year & week (Sun-Sat) | | Field type | dimension | | Data type | [string.time.yearweek](/apidocs/field-data-types#time) | | \| year_week_iso \| \| --- \| \| \\| Field label \\| Year & week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| | | year_week_iso | | \| Field label \| Year & week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| | | Field label | Year & week (Mon-Sun) | | Field type | dimension | | Data type | [string.time.yearweekiso](/apidocs/field-data-types#time) | | \| week \| \| --- \| \| \\| Field label \\| Week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.week](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| | | week | | \| Field label \| Week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| | | Field label | Week (Sun-Sat) | | Field type | dimension | | Data type | [string.time.week](/apidocs/field-data-types#time) | | \| week_iso \| \| --- \| \| \\| Field label \\| Week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.weekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| | | week_iso | | \| Field label \| Week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| | | Field label | Week (Mon-Sun) | | Field type | dimension | | Data type | [string.time.weekiso](/apidocs/field-data-types#time) | | \| day_of_month \| \| --- \| \| \\| Field label \\| Day of month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of month \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| | | day_of_month | | \| Field label \| Day of month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| | | Field label | Day of month | | Field type | dimension | | Data type | [string.time.dayofmonth](/apidocs/field-data-types#time) | | \| day_of_week_name \| \| --- \| \| \\| Field label \\| Day of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| | | day_of_week_name | | \| Field label \| Day of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| | | Field label | Day of week (Sun-Sat) | | Field type | dimension | | Data type | [string.time.dayofweek](/apidocs/field-data-types#time) | | \| day_of_week_name_iso \| \| --- \| \| \\| Field label \\| Day of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| | | day_of_week_name_iso | | \| Field label \| Day of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| | | Field label | Day of week (Mon-Sun) | | Field type | dimension | | Data type | [string.time.dayofweekiso](/apidocs/field-data-types#time) | | \| date \| \| --- \| \| \\| Field label \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | date | | \| Field label \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| atom \| \| --- \| \| \\| Field label \\| Datetime \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Datetime \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | atom | | \| Field label \| Datetime \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Datetime | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) |