---
title: "CJ Affiliate metrics and dimensions"
slug: "cj-affiliate-fields"
description: "Explore the CJ Affiliate (Commission Junction) metrics and dimensions available through Supermetrics. Find the fields you need for your ideal marketing reports."
updated: 2026-05-13T07:01:07Z
published: 2026-05-13T07:01:07Z
canonical: "docs.supermetrics.com/cj-affiliate-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.

# 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) |