--- title: "CJ Affiliate metrics and dimensions" slug: "cj-affiliate-fields" description: "Explore the complete list of CJ Affiliate (Commission Junction) metrics and dimensions available through Supermetrics. Find every data field you need to build your ideal marketing reports." updated: 2026-05-13T07:01:07Z published: 2026-05-13T07:01:07Z --- > ## 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. # CJ Affiliate metrics and dimensions > Supermetrics brings all your CJ Affiliate 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) 11 metrics56 dimensionsSearch fields ### ACCOUNT | \| account_id** \| \| --- \| \| \\| Field label \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| Account ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Account ID \| \| Description \| Account ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | account_id** | | \| Field label \| Account ID \| \| --- \| --- \| \| Description \| Account ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Account ID | | Description | Account ID | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| account_name** \| \| --- \| \| \\| Field label \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Account name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Account name \| \| Description \| Account name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | account_name** | | \| Field label \| Account name \| \| --- \| --- \| \| Description \| Account name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Account name | | Description | Account name | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| company_id** \| \| --- \| \| \\| Field label \\| Company ID \\| \\| --- \\| --- \\| \\| Description \\| Company ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Company ID \| \| Description \| Company ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_id** | | \| Field label \| Company ID \| \| --- \| --- \| \| Description \| Company ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Company ID | | Description | Company ID | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### ACTION | \| action_name** \| \| --- \| \| \\| Field label \\| Action name \\| \\| --- \\| --- \\| \\| Description \\| Name of the action (as specified by the advertiser) for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Action name \| \| Description \| Name of the action (as specified by the advertiser) for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | action_name** | | \| Field label \| Action name \| \| --- \| --- \| \| Description \| Name of the action (as specified by the advertiser) for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Action name | | Description | Name of the action (as specified by the advertiser) for the commission | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| action_id** \| \| --- \| \| \\| Field label \\| Action ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier of an advertiser's defined action associated with the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Action ID \| \| Description \| Unique identifier of an advertiser's defined action associated with the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | action_id** | | \| Field label \| Action ID \| \| --- \| --- \| \| Description \| Unique identifier of an advertiser's defined action associated with the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Action ID | | Description | Unique identifier of an advertiser's defined action associated with the commission | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| action_type** \| \| --- \| \| \\| Field label \\| Action type \\| \\| --- \\| --- \\| \\| Description \\| Action type for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Action type \| \| Description \| Action type for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | action_type** | | \| Field label \| Action type \| \| --- \| --- \| \| Description \| Action type for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Action type | | Description | Action type for the commission | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### ADVERTISER | \| advertiser_name** \| \| --- \| \| \\| Field label \\| Advertiser name \\| \\| --- \\| --- \\| \\| Description \\| Name of the advertiser for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advertiser name \| \| Description \| Name of the advertiser for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | advertiser_name** | | \| Field label \| Advertiser name \| \| --- \| --- \| \| Description \| Name of the advertiser for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Advertiser name | | Description | Name of the advertiser for the commission | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| advertiser_id** \| \| --- \| \| \\| Field label \\| Advertiser ID \\| \\| --- \\| --- \\| \\| Description \\| CID of the advertiser for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advertiser ID \| \| Description \| CID of the advertiser for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | advertiser_id** | | \| Field label \| Advertiser ID \| \| --- \| --- \| \| Description \| CID of the advertiser for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Advertiser ID | | Description | CID of the advertiser for the commission | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### COMMISSION | \| order_id** \| \| --- \| \| \\| Field label \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| Advertiser-assigned identification number for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order ID \| \| Description \| Advertiser-assigned identification number for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | order_id** | | \| Field label \| Order ID \| \| --- \| --- \| \| Description \| Advertiser-assigned identification number for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Order ID | | Description | Advertiser-assigned identification number for the order | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| item_id** \| \| --- \| \| \\| Field label \\| Item ID \\| \\| --- \\| --- \\| \\| Description \\| Id for item/s purchased. If multiple items, it will be a comma-separated lists \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item ID \| \| Description \| Id for item/s purchased. If multiple items, it will be a comma-separated lists \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | item_id** | | \| Field label \| Item ID \| \| --- \| --- \| \| Description \| Id for item/s purchased. If multiple items, it will be a comma-separated lists \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Item ID | | Description | Id for item/s purchased. If multiple items, it will be a comma-separated lists | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| commission_id** \| \| --- \| \| \\| Field label \\| Commission ID \\| \\| --- \\| --- \\| \\| Description \\| Commission identification number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Commission ID \| \| Description \| Commission identification number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | commission_id** | | \| Field label \| Commission ID \| \| --- \| --- \| \| Description \| Commission identification number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Commission ID | | Description | Commission identification number | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| posting_datetime** \| \| --- \| \| \\| Field label \\| Posting datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime on which the commission is posted \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Posting datetime \| \| Description \| Datetime on which the commission is posted \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | posting_datetime** | | \| Field label \| Posting datetime \| \| --- \| --- \| \| Description \| Datetime on which the commission is posted \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Posting datetime | | Description | Datetime on which the commission is posted | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| posting_date** \| \| --- \| \| \\| Field label \\| Posting date \\| \\| --- \\| --- \\| \\| Description \\| Date on which the commission is posted \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Posting date \| \| Description \| Date on which the commission is posted \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | posting_date** | | \| Field label \| Posting date \| \| --- \| --- \| \| Description \| Date on which the commission is posted \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Posting date | | Description | Date on which the commission is posted | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| event_datetime** \| \| --- \| \| \\| Field label \\| Event datetime \\| \\| --- \\| --- \\| \\| Description \\| Event datetime for the commission in UTC time zone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Event datetime \| \| Description \| Event datetime for the commission in UTC time zone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | event_datetime** | | \| Field label \| Event datetime \| \| --- \| --- \| \| Description \| Event datetime for the commission in UTC time zone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Event datetime | | Description | Event datetime for the commission in UTC time zone | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| event_date** \| \| --- \| \| \\| Field label \\| Event date \\| \\| --- \\| --- \\| \\| Description \\| Event date for the commission in UTC time zone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Event date \| \| Description \| Event date for the commission in UTC time zone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | event_date** | | \| Field label \| Event date \| \| --- \| --- \| \| Description \| Event date for the commission in UTC time zone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Event date | | Description | Event date for the commission in UTC time zone | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| locking_datetime** \| \| --- \| \| \\| Field label \\| Locking datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime on which the commission is locked for extending or correcting \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Locking datetime \| \| Description \| Datetime on which the commission is locked for extending or correcting \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | locking_datetime** | | \| Field label \| Locking datetime \| \| --- \| --- \| \| Description \| Datetime on which the commission is locked for extending or correcting \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Locking datetime | | Description | Datetime on which the commission is locked for extending or correcting | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| locking_date** \| \| --- \| \| \\| Field label \\| Locking date \\| \\| --- \\| --- \\| \\| Description \\| Date on which the commission is locked for extending or correcting \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Locking date \| \| Description \| Date on which the commission is locked for extending or correcting \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | locking_date** | | \| Field label \| Locking date \| \| --- \| --- \| \| Description \| Date on which the commission is locked for extending or correcting \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Locking date | | Description | Date on which the commission is locked for extending or correcting | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| status** \| \| --- \| \| \\| Field label \\| Status \\| \\| --- \\| --- \\| \\| Description \\| Status of the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Status \| \| Description \| Status of the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | status** | | \| Field label \| Status \| \| --- \| --- \| \| Description \| Status of the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Status | | Description | Status of the commission | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| source** \| \| --- \| \| \\| Field label \\| Source \\| \\| --- \\| --- \\| \\| Description \\| Source for the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Source \| \| Description \| Source for the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | source** | | \| Field label \| Source \| \| --- \| --- \| \| Description \| Source for the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Source | | Description | Source for the transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| coupon** \| \| --- \| \| \\| Field label \\| Coupon \\| \\| --- \\| --- \\| \\| Description \\| The coupon/voucher used in the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Coupon \| \| Description \| The coupon/voucher used in the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | coupon** | | \| Field label \| Coupon \| \| --- \| --- \| \| Description \| The coupon/voucher used in the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Coupon | | Description | The coupon/voucher used in the transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| new_to_file** \| \| --- \| \| \\| Field label \\| New to file \\| \\| --- \\| --- \\| \\| Description \\| Indicates if the customer is new or existing to the advertiser (advertiser defined) \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| New to file \| \| Description \| Indicates if the customer is new or existing to the advertiser (advertiser defined) \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | new_to_file** | | \| Field label \| New to file \| \| --- \| --- \| \| Description \| Indicates if the customer is new or existing to the advertiser (advertiser defined) \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | New to file | | Description | Indicates if the customer is new or existing to the advertiser (advertiser defined) | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| is_cross_device** \| \| --- \| \| \\| Field label \\| Is cross-device \\| \\| --- \\| --- \\| \\| Description \\| Indicates if a transaction was attributed using cross-device tracking \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Is cross-device \| \| Description \| Indicates if a transaction was attributed using cross-device tracking \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | is_cross_device** | | \| Field label \| Is cross-device \| \| --- \| --- \| \| Description \| Indicates if a transaction was attributed using cross-device tracking \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Is cross-device | | Description | Indicates if a transaction was attributed using cross-device tracking | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| customer_country** \| \| --- \| \| \\| Field label \\| Customer country \\| \\| --- \\| --- \\| \\| Description \\| Country where the transaction occurred (ISO 3166-1 alpha-2 country code, e.g. FR, DE, NL, ES) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Customer country \| \| Description \| Country where the transaction occurred (ISO 3166-1 alpha-2 country code, e.g. FR, DE, NL, ES) \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | customer_country** | | \| Field label \| Customer country \| \| --- \| --- \| \| Description \| Country where the transaction occurred (ISO 3166-1 alpha-2 country code, e.g. FR, DE, NL, ES) \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | Field label | Customer country | | Description | Country where the transaction occurred (ISO 3166-1 alpha-2 country code, e.g. FR, DE, NL, ES) | | Field type | dimension | | Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) | | \| reviewed_status** \| \| --- \| \| \\| Field label \\| Reviewed status \\| \\| --- \\| --- \\| \\| Description \\| Indicates if an advertiser has reviewed a transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Reviewed status \| \| Description \| Indicates if an advertiser has reviewed a transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | reviewed_status** | | \| Field label \| Reviewed status \| \| --- \| --- \| \| Description \| Indicates if an advertiser has reviewed a transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Reviewed status | | Description | Indicates if an advertiser has reviewed a transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| original** \| \| --- \| \| \\| Field label \\| Original \\| \\| --- \\| --- \\| \\| Description \\| Displays either a '1' indicating an original transaction or a '0' indicating a non-original or corrected transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Original \| \| Description \| Displays either a '1' indicating an original transaction or a '0' indicating a non-original or corrected transaction \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | original** | | \| Field label \| Original \| \| --- \| --- \| \| Description \| Displays either a '1' indicating an original transaction or a '0' indicating a non-original or corrected transaction \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Original | | Description | Displays either a '1' indicating an original transaction or a '0' indicating a non-original or corrected transaction | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| commissions** \| \| --- \| \| \\| Field label \\| Commissions \\| \\| --- \\| --- \\| \\| Description \\| Total number of commissions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Commissions \| \| Description \| Total number of commissions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | commissions** | | \| Field label \| Commissions \| \| --- \| --- \| \| Description \| Total number of commissions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Commissions | | Description | Total number of commissions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| sale_amount_usd** \| \| --- \| \| \\| Field label \\| Sale amount (USD) \\| \\| --- \\| --- \\| \\| Description \\| Sale amount in USD \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Sale amount (USD) \| \| Description \| Sale amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | sale_amount_usd** | | \| Field label \| Sale amount (USD) \| \| --- \| --- \| \| Description \| Sale amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Sale amount (USD) | | Description | Sale amount in USD | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| order_discount_usd** \| \| --- \| \| \\| Field label \\| Order discount (USD) \\| \\| --- \\| --- \\| \\| Description \\| Discount associated with the order in USD \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order discount (USD) \| \| Description \| Discount associated with the order in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | order_discount_usd** | | \| Field label \| Order discount (USD) \| \| --- \| --- \| \| Description \| Discount associated with the order in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Order discount (USD) | | Description | Discount associated with the order in USD | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| advertiser_commission_usd** \| \| --- \| \| \\| Field label \\| Advertiser commission (USD) \\| \\| --- \\| --- \\| \\| Description \\| Advertiser commission amount in USD \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Advertiser commission (USD) \| \| Description \| Advertiser commission amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | advertiser_commission_usd** | | \| Field label \| Advertiser commission (USD) \| \| --- \| --- \| \| Description \| Advertiser commission amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Advertiser commission (USD) | | Description | Advertiser commission amount in USD | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| publisher_commission_usd** \| \| --- \| \| \\| Field label \\| Publisher commission (USD) \\| \\| --- \\| --- \\| \\| Description \\| Publisher commission amount in USD \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Publisher commission (USD) \| \| Description \| Publisher commission amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | publisher_commission_usd** | | \| Field label \| Publisher commission (USD) \| \| --- \| --- \| \| Description \| Publisher commission amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Publisher commission (USD) | | Description | Publisher commission amount in USD | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| cj_fee_usd** \| \| --- \| \| \\| Field label \\| CJ fee (USD) \\| \\| --- \\| --- \\| \\| Description \\| CJ fee in USD \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| CJ fee (USD) \| \| Description \| CJ fee in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | cj_fee_usd** | | \| Field label \| CJ fee (USD) \| \| --- \| --- \| \| Description \| CJ fee in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | CJ fee (USD) | | Description | CJ fee in USD | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| sale_amount_adv_currency** \| \| --- \| \| \\| Field label \\| Sale amount (advertiser currency) \\| \\| --- \\| --- \\| \\| Description \\| Sale amount in the advertiser's currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Sale amount (advertiser currency) \| \| Description \| Sale amount in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | sale_amount_adv_currency** | | \| Field label \| Sale amount (advertiser currency) \| \| --- \| --- \| \| Description \| Sale amount in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Sale amount (advertiser currency) | | Description | Sale amount in the advertiser's currency | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| order_discount_adv_currency** \| \| --- \| \| \\| Field label \\| Order discount (advertiser currency) \\| \\| --- \\| --- \\| \\| Description \\| Discount associated with the order in the advertiser's currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order discount (advertiser currency) \| \| Description \| Discount associated with the order in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | order_discount_adv_currency** | | \| Field label \| Order discount (advertiser currency) \| \| --- \| --- \| \| Description \| Discount associated with the order in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Order discount (advertiser currency) | | Description | Discount associated with the order in the advertiser's currency | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| advertiser_commission_adv_currency** \| \| --- \| \| \\| Field label \\| Advertiser commission (advertiser currency) \\| \\| --- \\| --- \\| \\| Description \\| Advertiser commission amount in the advertiser's currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Advertiser commission (advertiser currency) \| \| Description \| Advertiser commission amount in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | advertiser_commission_adv_currency** | | \| Field label \| Advertiser commission (advertiser currency) \| \| --- \| --- \| \| Description \| Advertiser commission amount in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Advertiser commission (advertiser currency) | | Description | Advertiser commission amount in the advertiser's currency | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| publisher_commission_pub_currency** \| \| --- \| \| \\| Field label \\| Publisher commission (publisher currency) \\| \\| --- \\| --- \\| \\| Description \\| Publisher commission amount in the publisher's currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Publisher commission (publisher currency) \| \| Description \| Publisher commission amount in the publisher's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | publisher_commission_pub_currency** | | \| Field label \| Publisher commission (publisher currency) \| \| --- \| --- \| \| Description \| Publisher commission amount in the publisher's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Publisher commission (publisher currency) | | Description | Publisher commission amount in the publisher's currency | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| cj_fee_adv_currency** \| \| --- \| \| \\| Field label \\| CJ fee (advertiser currency) \\| \\| --- \\| --- \\| \\| Description \\| CJ fee in the advertiser's currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| CJ fee (advertiser currency) \| \| Description \| CJ fee in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | cj_fee_adv_currency** | | \| Field label \| CJ fee (advertiser currency) \| \| --- \| --- \| \| Description \| CJ fee in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | CJ fee (advertiser currency) | | Description | CJ fee in the advertiser's currency | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | ### 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) | ### PUBLISHER | \| publisher_name** \| \| --- \| \| \\| Field label \\| Publisher name \\| \\| --- \\| --- \\| \\| Description \\| Name of the publisher for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher name \| \| Description \| Name of the publisher for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | publisher_name** | | \| Field label \| Publisher name \| \| --- \| --- \| \| Description \| Name of the publisher for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Publisher name | | Description | Name of the publisher for the commission | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| publisher_id** \| \| --- \| \| \\| Field label \\| Publisher CID \\| \\| --- \\| --- \\| \\| Description \\| CID of the publisher for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher CID \| \| Description \| CID of the publisher for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | publisher_id** | | \| Field label \| Publisher CID \| \| --- \| --- \| \| Description \| CID of the publisher for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Publisher CID | | Description | CID of the publisher for the commission | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| website_name** \| \| --- \| \| \\| Field label \\| Website name \\| \\| --- \\| --- \\| \\| Description \\| Name of the publisher website \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Website name \| \| Description \| Name of the publisher website \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | website_name** | | \| Field label \| Website name \| \| --- \| --- \| \| Description \| Name of the publisher website \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Website name | | Description | Name of the publisher website | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| website_id** \| \| --- \| \| \\| Field label \\| Website ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the publisher website \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Website ID \| \| Description \| ID of the publisher website \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | website_id** | | \| Field label \| Website ID \| \| --- \| --- \| \| Description \| ID of the publisher website \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Website ID | | Description | ID of the publisher website | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### 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) |