--- title: "Awin metrics and dimensions" slug: "awin-fields" description: "Explore the complete list of Awin metrics and dimensions available through Supermetrics. Find every data field you need to build your ideal marketing reports." updated: 2026-03-05T14:15:45Z published: 2026-03-05T14:15:45Z canonical: "docs.supermetrics.com/awin-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. # Awin metrics and dimensions > Supermetrics brings all your Awin 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) 79 metrics111 dimensionsSearch fields ### ACCOUNT | \| pub__advertiser_id \| \| --- \| \| \\| Field label \\| Advertiser ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advertiser ID \| \| Description \| ID of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | pub__advertiser_id | | \| Field label \| Advertiser ID \| \| --- \| --- \| \| Description \| ID of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Advertiser ID | | Description | ID of the advertiser | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub__advertiser_name \| \| --- \| \| \\| Field label \\| Advertiser name \\| \\| --- \\| --- \\| \\| Description \\| Name of the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advertiser name \| \| Description \| Name of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub__advertiser_name | | \| Field label \| Advertiser name \| \| --- \| --- \| \| Description \| Name of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Advertiser name | | Description | Name of the advertiser | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub__publisher_id \| \| --- \| \| \\| Field label \\| Publisher ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher ID \| \| Description \| ID of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub__publisher_id | | \| Field label \| Publisher ID \| \| --- \| --- \| \| Description \| ID of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Publisher ID | | Description | ID of the publisher | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub__publisher_name \| \| --- \| \| \\| Field label \\| Publisher name \\| \\| --- \\| --- \\| \\| Description \\| Name of the publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher name \| \| Description \| Name of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub__publisher_name | | \| Field label \| Publisher name \| \| --- \| --- \| \| Description \| Name of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Publisher name | | Description | Name of the publisher | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub__creative_id \| \| --- \| \| \\| Field label \\| Creative ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Creative ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub__creative_id | | \| Field label \| Creative ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creative ID | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub__creative_name \| \| --- \| \| \\| Field label \\| Creative name \\| \\| --- \\| --- \\| \\| Description \\| Name of the creative \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Creative name \| \| Description \| Name of the creative \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub__creative_name | | \| Field label \| Creative name \| \| --- \| --- \| \| Description \| Name of the creative \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creative name | | Description | Name of the creative | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub__tag_name \| \| --- \| \| \\| Field label \\| Tag name \\| \\| --- \\| --- \\| \\| Description \\| Tag name of the creative, used by the advertiser to group creatives \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Tag name \| \| Description \| Tag name of the creative, used by the advertiser to group creatives \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub__tag_name | | \| Field label \| Tag name \| \| --- \| --- \| \| Description \| Tag name of the creative, used by the advertiser to group creatives \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Tag name | | Description | Tag name of the creative, used by the advertiser to group creatives | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub_dwh__advertiser_id \| \| --- \| \| \\| Field label \\| Advertiser ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advertiser ID \| \| Description \| ID of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub_dwh__advertiser_id | | \| Field label \| Advertiser ID \| \| --- \| --- \| \| Description \| ID of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Advertiser ID | | Description | ID of the advertiser | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub_dwh__advertiser_name \| \| --- \| \| \\| Field label \\| Advertiser name \\| \\| --- \\| --- \\| \\| Description \\| Name of the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advertiser name \| \| Description \| Name of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub_dwh__advertiser_name | | \| Field label \| Advertiser name \| \| --- \| --- \| \| Description \| Name of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Advertiser name | | Description | Name of the advertiser | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub_dwh__publisher_id \| \| --- \| \| \\| Field label \\| Publisher ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher ID \| \| Description \| ID of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub_dwh__publisher_id | | \| Field label \| Publisher ID \| \| --- \| --- \| \| Description \| ID of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Publisher ID | | Description | ID of the publisher | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub_dwh__publisher_name \| \| --- \| \| \\| Field label \\| Publisher name \\| \\| --- \\| --- \\| \\| Description \\| Name of the publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher name \| \| Description \| Name of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub_dwh__publisher_name | | \| Field label \| Publisher name \| \| --- \| --- \| \| Description \| Name of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Publisher name | | Description | Name of the publisher | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub_dwh__creative_id \| \| --- \| \| \\| Field label \\| Creative ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Creative ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub_dwh__creative_id | | \| Field label \| Creative ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creative ID | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub_dwh__creative_name \| \| --- \| \| \\| Field label \\| Creative name \\| \\| --- \\| --- \\| \\| Description \\| Name of the creative \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Creative name \| \| Description \| Name of the creative \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub_dwh__creative_name | | \| Field label \| Creative name \| \| --- \| --- \| \| Description \| Name of the creative \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creative name | | Description | Name of the creative | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pub_dwh__tag_name \| \| --- \| \| \\| Field label \\| Tag name \\| \\| --- \\| --- \\| \\| Description \\| Tag name of the creative, used by the advertiser to group creatives \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Tag name \| \| Description \| Tag name of the creative, used by the advertiser to group creatives \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pub_dwh__tag_name | | \| Field label \| Tag name \| \| --- \| --- \| \| Description \| Tag name of the creative, used by the advertiser to group creatives \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Tag name | | Description | Tag name of the creative, used by the advertiser to group creatives | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea__advertiser_id \| \| --- \| \| \\| Field label \\| Advertiser ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advertiser ID \| \| Description \| ID of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea__advertiser_id | | \| Field label \| Advertiser ID \| \| --- \| --- \| \| Description \| ID of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Advertiser ID | | Description | ID of the advertiser | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea__advertiser_name \| \| --- \| \| \\| Field label \\| Advertiser name \\| \\| --- \\| --- \\| \\| Description \\| Name of the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advertiser name \| \| Description \| Name of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea__advertiser_name | | \| Field label \| Advertiser name \| \| --- \| --- \| \| Description \| Name of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Advertiser name | | Description | Name of the advertiser | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea__publisher_id \| \| --- \| \| \\| Field label \\| Publisher ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher ID \| \| Description \| ID of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea__publisher_id | | \| Field label \| Publisher ID \| \| --- \| --- \| \| Description \| ID of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Publisher ID | | Description | ID of the publisher | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea__publisher_name \| \| --- \| \| \\| Field label \\| Publisher name \\| \\| --- \\| --- \\| \\| Description \\| Name of the publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher name \| \| Description \| Name of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea__publisher_name | | \| Field label \| Publisher name \| \| --- \| --- \| \| Description \| Name of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Publisher name | | Description | Name of the publisher | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea__creative_id \| \| --- \| \| \\| Field label \\| Creative ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Creative ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea__creative_id | | \| Field label \| Creative ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creative ID | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea__creative_name \| \| --- \| \| \\| Field label \\| Creative name \\| \\| --- \\| --- \\| \\| Description \\| Name of the creative \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Creative name \| \| Description \| Name of the creative \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea__creative_name | | \| Field label \| Creative name \| \| --- \| --- \| \| Description \| Name of the creative \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creative name | | Description | Name of the creative | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea__tag_name \| \| --- \| \| \\| Field label \\| Tag name \\| \\| --- \\| --- \\| \\| Description \\| Tag name of the creative, used by the advertiser to group creatives \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Tag name \| \| Description \| Tag name of the creative, used by the advertiser to group creatives \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea__tag_name | | \| Field label \| Tag name \| \| --- \| --- \| \| Description \| Tag name of the creative, used by the advertiser to group creatives \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Tag name | | Description | Tag name of the creative, used by the advertiser to group creatives | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea_dwh__advertiser_id \| \| --- \| \| \\| Field label \\| Advertiser ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advertiser ID \| \| Description \| ID of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea_dwh__advertiser_id | | \| Field label \| Advertiser ID \| \| --- \| --- \| \| Description \| ID of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Advertiser ID | | Description | ID of the advertiser | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea_dwh__advertiser_name \| \| --- \| \| \\| Field label \\| Advertiser name \\| \\| --- \\| --- \\| \\| Description \\| Name of the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advertiser name \| \| Description \| Name of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea_dwh__advertiser_name | | \| Field label \| Advertiser name \| \| --- \| --- \| \| Description \| Name of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Advertiser name | | Description | Name of the advertiser | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea_dwh__publisher_id \| \| --- \| \| \\| Field label \\| Publisher ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher ID \| \| Description \| ID of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea_dwh__publisher_id | | \| Field label \| Publisher ID \| \| --- \| --- \| \| Description \| ID of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Publisher ID | | Description | ID of the publisher | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea_dwh__publisher_name \| \| --- \| \| \\| Field label \\| Publisher name \\| \\| --- \\| --- \\| \\| Description \\| Name of the publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher name \| \| Description \| Name of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea_dwh__publisher_name | | \| Field label \| Publisher name \| \| --- \| --- \| \| Description \| Name of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Publisher name | | Description | Name of the publisher | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea_dwh__creative_id \| \| --- \| \| \\| Field label \\| Creative ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Creative ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea_dwh__creative_id | | \| Field label \| Creative ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creative ID | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea_dwh__creative_name \| \| --- \| \| \\| Field label \\| Creative name \\| \\| --- \\| --- \\| \\| Description \\| Name of the creative \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Creative name \| \| Description \| Name of the creative \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea_dwh__creative_name | | \| Field label \| Creative name \| \| --- \| --- \| \| Description \| Name of the creative \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creative name | | Description | Name of the creative | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| crea_dwh__tag_name \| \| --- \| \| \\| Field label \\| Tag name \\| \\| --- \\| --- \\| \\| Description \\| Tag name of the creative, used by the advertiser to group creatives \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Tag name \| \| Description \| Tag name of the creative, used by the advertiser to group creatives \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | crea_dwh__tag_name | | \| Field label \| Tag name \| \| --- \| --- \| \| Description \| Tag name of the creative, used by the advertiser to group creatives \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Tag name | | Description | Tag name of the creative, used by the advertiser to group creatives | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### ADVERTISER | \| trans__advertiser_id \| \| --- \| \| \\| Field label \\| Advertiser ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advertiser ID \| \| Description \| ID of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | trans__advertiser_id | | \| Field label \| Advertiser ID \| \| --- \| --- \| \| Description \| ID of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Advertiser ID | | Description | ID of the advertiser | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__advertiser_country \| \| --- \| \| \\| Field label \\| Advertiser country \\| \\| --- \\| --- \\| \\| Description \\| The country of the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Advertiser country \| \| Description \| The country of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | trans__advertiser_country | | \| Field label \| Advertiser country \| \| --- \| --- \| \| Description \| The country of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | Field label | Advertiser country | | Description | The country of the advertiser | | Field type | dimension | | Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) | ### CLICK | \| trans__click_ref \| \| --- \| \| \\| Field label \\| Click reference \\| \\| --- \\| --- \\| \\| Description \\| Click reference for transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Click reference \| \| Description \| Click reference for transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | trans__click_ref | | \| Field label \| Click reference \| \| --- \| --- \| \| Description \| Click reference for transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Click reference | | Description | Click reference for transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__click_date \| \| --- \| \| \\| Field label \\| Click date \\| \\| --- \\| --- \\| \\| Description \\| The date of the click \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Click date \| \| Description \| The date of the click \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | trans__click_date | | \| Field label \| Click date \| \| --- \| --- \| \| Description \| The date of the click \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Click date | | Description | The date of the click | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| trans__click_date_time \| \| --- \| \| \\| Field label \\| Click date and time \\| \\| --- \\| --- \\| \\| Description \\| The date and time of the click \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Click date and time \| \| Description \| The date and time of the click \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | trans__click_date_time | | \| Field label \| Click date and time \| \| --- \| --- \| \| Description \| The date and time of the click \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Click date and time | | Description | The date and time of the click | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| trans__click_device \| \| --- \| \| \\| Field label \\| Click device \\| \\| --- \\| --- \\| \\| Description \\| Device where click happened \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Click device \| \| Description \| Device where click happened \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__click_device | | \| Field label \| Click device \| \| --- \| --- \| \| Description \| Device where click happened \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Click device | | Description | Device where click happened | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### COMMISSION | \| trans__order_ref \| \| --- \| \| \\| Field label \\| Order reference \\| \\| --- \\| --- \\| \\| Description \\| The reference of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order reference \| \| Description \| The reference of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | trans__order_ref | | \| Field label \| Order reference \| \| --- \| --- \| \| Description \| The reference of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Order reference | | Description | The reference of the order | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__sale_currency \| \| --- \| \| \\| Field label \\| Sale currency \\| \\| --- \\| --- \\| \\| Description \\| Currency of the sale \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Sale currency \| \| Description \| Currency of the sale \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__sale_currency | | \| Field label \| Sale currency \| \| --- \| --- \| \| Description \| Currency of the sale \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Sale currency | | Description | Currency of the sale | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__commission_currency \| \| --- \| \| \\| Field label \\| Commission currency \\| \\| --- \\| --- \\| \\| Description \\| Currency of the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Commission currency \| \| Description \| Currency of the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__commission_currency | | \| Field label \| Commission currency \| \| --- \| --- \| \| Description \| Currency of the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Commission currency | | Description | Currency of the commission | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__commission_status \| \| --- \| \| \\| Field label \\| Commission status \\| \\| --- \\| --- \\| \\| Description \\| Status of the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Commission status \| \| Description \| Status of the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__commission_status | | \| Field label \| Commission status \| \| --- \| --- \| \| Description \| Status of the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Commission status | | Description | Status of the commission | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__paid_to_publisher \| \| --- \| \| \\| Field label \\| Paid to publisher \\| \\| --- \\| --- \\| \\| Description \\| Whether transaction commission has been paid to publisher or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Paid to publisher \| \| Description \| Whether transaction commission has been paid to publisher or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | trans__paid_to_publisher | | \| Field label \| Paid to publisher \| \| --- \| --- \| \| Description \| Whether transaction commission has been paid to publisher or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Paid to publisher | | Description | Whether transaction commission has been paid to publisher or not | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| trans__payment_id \| \| --- \| \| \\| Field label \\| Payment ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the payment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Payment ID \| \| Description \| The unique ID of the payment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__payment_id | | \| Field label \| Payment ID \| \| --- \| --- \| \| Description \| The unique ID of the payment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Payment ID | | Description | The unique ID of the payment | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### CUSTOMER | \| trans__customer_country \| \| --- \| \| \\| Field label \\| Customer country \\| \\| --- \\| --- \\| \\| Description \\| Country of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer country \| \| Description \| Country of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | trans__customer_country | | \| Field label \| Customer country \| \| --- \| --- \| \| Description \| Country of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Customer country | | Description | Country of the customer | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__ip_hash \| \| --- \| \| \\| Field label \\| IP hash \\| \\| --- \\| --- \\| \\| Description \\| Hash of the IP address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| IP hash \| \| Description \| Hash of the IP address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__ip_hash | | \| Field label \| IP hash \| \| --- \| --- \| \| Description \| Hash of the IP address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | IP hash | | Description | Hash of the IP address | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### DATASOURCE | \| dataSourceName \| \| --- \| \| \\| Field label \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| | | --- | | dataSourceName | | \| Field label \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| | | Field label | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | Destinations | API, Data warehouse | | \| system_metadata.data_source_logins \| \| --- \| \| \\| Field label \\| Data source logins \\| \\| --- \\| --- \\| \\| Description \\| The data source login accounts that were used to authenticate against the data source \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source logins \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.data_source_logins | | \| Field label \| Data source logins \| \| --- \| --- \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Data source logins | | Description | The data source login accounts that were used to authenticate against the data source | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | | \| system_metadata.data_source_login_owners \| \| --- \| \| \\| Field label \\| Data source login owners \\| \\| --- \\| --- \\| \\| Description \\| The Supermetrics users that created the data source login connections \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source login owners \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.data_source_login_owners | | \| Field label \| Data source login owners \| \| --- \| --- \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Data source login owners | | Description | The Supermetrics users that created the data source login connections | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | ### PERFORMANCE | \| pub__impressions \| \| --- \| \| \\| Field label \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Number of impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Impressions \| \| Description \| Number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | --- | | pub__impressions | | \| Field label \| Impressions \| \| --- \| --- \| \| Description \| Number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Impressions | | Description | Number of impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub__clicks \| \| --- \| \| \\| Field label \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub__clicks | | \| Field label \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub__ctr \| \| --- \| \| \\| Field label \\| CTR \\| \\| --- \\| --- \\| \\| Description \\| Clicks / Impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.percentage](/apidocs/field-data-types#number) \\| \| \| Field label \| CTR \| \| Description \| Clicks / Impressions \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | pub__ctr | | \| Field label \| CTR \| \| --- \| --- \| \| Description \| Clicks / Impressions \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | Field label | CTR | | Description | Clicks / Impressions | | Field type | metric | | Data type | [float.number.percentage](/apidocs/field-data-types#number) | | \| pub_dwh__impressions \| \| --- \| \| \\| Field label \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Number of impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Impressions \| \| Description \| Number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub_dwh__impressions | | \| Field label \| Impressions \| \| --- \| --- \| \| Description \| Number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Impressions | | Description | Number of impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub_dwh__clicks \| \| --- \| \| \\| Field label \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub_dwh__clicks | | \| Field label \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub_dwh__ctr \| \| --- \| \| \\| Field label \\| CTR \\| \\| --- \\| --- \\| \\| Description \\| Clicks / Impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.percentage](/apidocs/field-data-types#number) \\| \| \| Field label \| CTR \| \| Description \| Clicks / Impressions \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | pub_dwh__ctr | | \| Field label \| CTR \| \| --- \| --- \| \| Description \| Clicks / Impressions \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | Field label | CTR | | Description | Clicks / Impressions | | Field type | metric | | Data type | [float.number.percentage](/apidocs/field-data-types#number) | | \| crea__impressions \| \| --- \| \| \\| Field label \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Number of impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Impressions \| \| Description \| Number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea__impressions | | \| Field label \| Impressions \| \| --- \| --- \| \| Description \| Number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Impressions | | Description | Number of impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea__clicks \| \| --- \| \| \\| Field label \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea__clicks | | \| Field label \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea__ctr \| \| --- \| \| \\| Field label \\| CTR \\| \\| --- \\| --- \\| \\| Description \\| Clicks / Impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.percentage](/apidocs/field-data-types#number) \\| \| \| Field label \| CTR \| \| Description \| Clicks / Impressions \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | crea__ctr | | \| Field label \| CTR \| \| --- \| --- \| \| Description \| Clicks / Impressions \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | Field label | CTR | | Description | Clicks / Impressions | | Field type | metric | | Data type | [float.number.percentage](/apidocs/field-data-types#number) | | \| crea_dwh__impressions \| \| --- \| \| \\| Field label \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Number of impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Impressions \| \| Description \| Number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea_dwh__impressions | | \| Field label \| Impressions \| \| --- \| --- \| \| Description \| Number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Impressions | | Description | Number of impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea_dwh__clicks \| \| --- \| \| \\| Field label \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea_dwh__clicks | | \| Field label \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea_dwh__ctr \| \| --- \| \| \\| Field label \\| CTR \\| \\| --- \\| --- \\| \\| Description \\| Clicks / Impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.percentage](/apidocs/field-data-types#number) \\| \| \| Field label \| CTR \| \| Description \| Clicks / Impressions \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | crea_dwh__ctr | | \| Field label \| CTR \| \| --- \| --- \| \| Description \| Clicks / Impressions \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | Field label | CTR | | Description | Clicks / Impressions | | Field type | metric | | Data type | [float.number.percentage](/apidocs/field-data-types#number) | ### PUBLISHER | \| trans__publisher_id \| \| --- \| \| \\| Field label \\| Publisher ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher ID \| \| Description \| ID of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | trans__publisher_id | | \| Field label \| Publisher ID \| \| --- \| --- \| \| Description \| ID of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Publisher ID | | Description | ID of the publisher | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__site_name \| \| --- \| \| \\| Field label \\| Site name \\| \\| --- \\| --- \\| \\| Description \\| Name of the site \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Site name \| \| Description \| Name of the site \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__site_name | | \| Field label \| Site name \| \| --- \| --- \| \| Description \| Name of the site \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Site name | | Description | Name of the site | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__publisher_url \| \| --- \| \| \\| Field label \\| Publisher URL \\| \\| --- \\| --- \\| \\| Description \\| The URL of the publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Publisher URL \| \| Description \| The URL of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | trans__publisher_url | | \| Field label \| Publisher URL \| \| --- \| --- \| \| Description \| The URL of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | Field label | Publisher URL | | Description | The URL of the publisher | | Field type | dimension | | Data type | [string.text.url](/apidocs/field-data-types#text) | | \| trans__commission_sharing_publisher_id \| \| --- \| \| \\| Field label \\| Commission sharing publisher ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the commission sharing publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Commission sharing publisher ID \| \| Description \| ID of the commission sharing publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__commission_sharing_publisher_id | | \| Field label \| Commission sharing publisher ID \| \| --- \| --- \| \| Description \| ID of the commission sharing publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Commission sharing publisher ID | | Description | ID of the commission sharing publisher | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__commission_sharing_selected_rate_publisher_id \| \| --- \| \| \\| Field label \\| Commission sharing selected rate publisher ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the commission sharing selected rate publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Commission sharing selected rate publisher ID \| \| Description \| ID of the commission sharing selected rate publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__commission_sharing_selected_rate_publisher_id | | \| Field label \| Commission sharing selected rate publisher ID \| \| --- \| --- \| \| Description \| ID of the commission sharing selected rate publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Commission sharing selected rate publisher ID | | Description | ID of the commission sharing selected rate publisher | | 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) | ### REGION | \| pub__region \| \| --- \| \| \\| Field label \\| Region \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Region \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | --- | | pub__region | | \| Field label \| Region \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | Field label | Region | | Field type | dimension | | Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) | | \| pub__currency \| \| --- \| \| \\| Field label \\| Currency \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Currency \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | pub__currency | | \| Field label \| Currency \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Field label | Currency | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | | \| pub_dwh__region \| \| --- \| \| \\| Field label \\| Region \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Region \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | pub_dwh__region | | \| Field label \| Region \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | Field label | Region | | Field type | dimension | | Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) | | \| pub_dwh__currency \| \| --- \| \| \\| Field label \\| Currency \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Currency \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | pub_dwh__currency | | \| Field label \| Currency \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Field label | Currency | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | | \| crea__region \| \| --- \| \| \\| Field label \\| Region \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Region \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | crea__region | | \| Field label \| Region \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | Field label | Region | | Field type | dimension | | Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) | | \| crea__currency \| \| --- \| \| \\| Field label \\| Currency \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Currency \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | crea__currency | | \| Field label \| Currency \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Field label | Currency | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | | \| crea_dwh__region \| \| --- \| \| \\| Field label \\| Region \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Region \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | crea_dwh__region | | \| Field label \| Region \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | Field label | Region | | Field type | dimension | | Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) | | \| crea_dwh__currency \| \| --- \| \| \\| Field label \\| Currency \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Currency \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | crea_dwh__currency | | \| Field label \| Currency \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Field label | Currency | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | ### 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 | | \| pub__year \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Description \\| Year \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Description \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | pub__year | | \| Field label \| Year \| \| --- \| --- \| \| Description \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | Field label | Year | | Description | Year | | Field type | dimension | | Data type | [string.time.year](/apidocs/field-data-types#time) | | \| pub__yearmonth \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Description \\| Year and month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Description \| Year and month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | pub__yearmonth | | \| Field label \| Year & month \| \| --- \| --- \| \| Description \| Year and month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | Field label | Year & month | | Description | Year and month | | Field type | dimension | | Data type | [string.time.yearmonth](/apidocs/field-data-types#time) | | \| pub__month \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Description \\| Month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Description \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | pub__month | | \| Field label \| Month \| \| --- \| --- \| \| Description \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | Field label | Month | | Description | Month | | Field type | dimension | | Data type | [string.time.month](/apidocs/field-data-types#time) | | \| pub_dwh__year \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Description \\| Year \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Description \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | pub_dwh__year | | \| Field label \| Year \| \| --- \| --- \| \| Description \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | Field label | Year | | Description | Year | | Field type | dimension | | Data type | [string.time.year](/apidocs/field-data-types#time) | | \| pub_dwh__yearmonth \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Description \\| Year and month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Description \| Year and month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | pub_dwh__yearmonth | | \| Field label \| Year & month \| \| --- \| --- \| \| Description \| Year and month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | Field label | Year & month | | Description | Year and month | | Field type | dimension | | Data type | [string.time.yearmonth](/apidocs/field-data-types#time) | | \| pub_dwh__month \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Description \\| Month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Description \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | pub_dwh__month | | \| Field label \| Month \| \| --- \| --- \| \| Description \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | Field label | Month | | Description | Month | | Field type | dimension | | Data type | [string.time.month](/apidocs/field-data-types#time) | | \| pub_dwh__date \| \| --- \| \| \\| Field label \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Date \| \| Description \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | pub_dwh__date | | \| Field label \| Date \| \| --- \| --- \| \| Description \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Date | | Description | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| crea__year \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Description \\| Year \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Description \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | crea__year | | \| Field label \| Year \| \| --- \| --- \| \| Description \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | Field label | Year | | Description | Year | | Field type | dimension | | Data type | [string.time.year](/apidocs/field-data-types#time) | | \| crea__yearmonth \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Description \\| Year and month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Description \| Year and month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | crea__yearmonth | | \| Field label \| Year & month \| \| --- \| --- \| \| Description \| Year and month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | Field label | Year & month | | Description | Year and month | | Field type | dimension | | Data type | [string.time.yearmonth](/apidocs/field-data-types#time) | | \| crea__month \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Description \\| Month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Description \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | crea__month | | \| Field label \| Month \| \| --- \| --- \| \| Description \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | Field label | Month | | Description | Month | | Field type | dimension | | Data type | [string.time.month](/apidocs/field-data-types#time) | | \| crea_dwh__year \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Description \\| Year \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Description \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | crea_dwh__year | | \| Field label \| Year \| \| --- \| --- \| \| Description \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | Field label | Year | | Description | Year | | Field type | dimension | | Data type | [string.time.year](/apidocs/field-data-types#time) | | \| crea_dwh__yearmonth \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Description \\| Year and month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Description \| Year and month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | crea_dwh__yearmonth | | \| Field label \| Year & month \| \| --- \| --- \| \| Description \| Year and month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | Field label | Year & month | | Description | Year and month | | Field type | dimension | | Data type | [string.time.yearmonth](/apidocs/field-data-types#time) | | \| crea_dwh__month \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Description \\| Month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Description \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | crea_dwh__month | | \| Field label \| Month \| \| --- \| --- \| \| Description \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | Field label | Month | | Description | Month | | Field type | dimension | | Data type | [string.time.month](/apidocs/field-data-types#time) | | \| crea_dwh__date \| \| --- \| \| \\| Field label \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Date \| \| Description \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | crea_dwh__date | | \| Field label \| Date \| \| --- \| --- \| \| Description \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Date | | Description | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | | \| trans__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) \| | | trans__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) | ### TRANSACTION | \| trans__campaign \| \| --- \| \| \\| Field label \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Name of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Campaign name \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | trans__campaign | | \| Field label \| Campaign name \| \| --- \| --- \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Campaign name | | Description | Name of the campaign | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__transaction_id \| \| --- \| \| \\| Field label \\| Transaction ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Transaction ID \| \| Description \| ID of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__transaction_id | | \| Field label \| Transaction ID \| \| --- \| --- \| \| Description \| ID of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Transaction ID | | Description | ID of the transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__transaction_query_id \| \| --- \| \| \\| Field label \\| Transaction query ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the transaction query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Transaction query ID \| \| Description \| The unique ID of the transaction query \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__transaction_query_id | | \| Field label \| Transaction query ID \| \| --- \| --- \| \| Description \| The unique ID of the transaction query \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Transaction query ID | | Description | The unique ID of the transaction query | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__type \| \| --- \| \| \\| Field label \\| Transaction type \\| \\| --- \\| --- \\| \\| Description \\| The type of the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Transaction type \| \| Description \| The type of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__type | | \| Field label \| Transaction type \| \| --- \| --- \| \| Description \| The type of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Transaction type | | Description | The type of the transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__transaction_url \| \| --- \| \| \\| Field label \\| Transaction URL \\| \\| --- \\| --- \\| \\| Description \\| URL of the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Transaction URL \| \| Description \| URL of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | trans__transaction_url | | \| Field label \| Transaction URL \| \| --- \| --- \| \| Description \| URL of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | Field label | Transaction URL | | Description | URL of the transaction | | Field type | dimension | | Data type | [string.text.url](/apidocs/field-data-types#text) | | \| trans__transaction_date \| \| --- \| \| \\| Field label \\| Transaction date \\| \\| --- \\| --- \\| \\| Description \\| The date and time of the click \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Transaction date \| \| Description \| The date and time of the click \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | trans__transaction_date | | \| Field label \| Transaction date \| \| --- \| --- \| \| Description \| The date and time of the click \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Transaction date | | Description | The date and time of the click | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| trans__transaction_date_time \| \| --- \| \| \\| Field label \\| Transaction date and time \\| \\| --- \\| --- \\| \\| Description \\| The date and time of the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Transaction date and time \| \| Description \| The date and time of the transaction \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | trans__transaction_date_time | | \| Field label \| Transaction date and time \| \| --- \| --- \| \| Description \| The date and time of the transaction \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Transaction date and time | | Description | The date and time of the transaction | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| trans__decline_reason \| \| --- \| \| \\| Field label \\| Transaction decline reason \\| \\| --- \\| --- \\| \\| Description \\| The decline reason of the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Transaction decline reason \| \| Description \| The decline reason of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__decline_reason | | \| Field label \| Transaction decline reason \| \| --- \| --- \| \| Description \| The decline reason of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Transaction decline reason | | Description | The decline reason of the transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__transaction_device \| \| --- \| \| \\| Field label \\| Transaction device \\| \\| --- \\| --- \\| \\| Description \\| Device where transaction happened \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Transaction device \| \| Description \| Device where transaction happened \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__transaction_device | | \| Field label \| Transaction device \| \| --- \| --- \| \| Description \| Device where transaction happened \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Transaction device | | Description | Device where transaction happened | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__voucher_code_used \| \| --- \| \| \\| Field label \\| Voucher code used \\| \\| --- \\| --- \\| \\| Description \\| Whether voucher code was used or not for transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Voucher code used \| \| Description \| Whether voucher code was used or not for transaction \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | trans__voucher_code_used | | \| Field label \| Voucher code used \| \| --- \| --- \| \| Description \| Whether voucher code was used or not for transaction \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Voucher code used | | Description | Whether voucher code was used or not for transaction | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| trans__voucher_code \| \| --- \| \| \\| Field label \\| Voucher code \\| \\| --- \\| --- \\| \\| Description \\| The voucher code that was used for the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Voucher code \| \| Description \| The voucher code that was used for the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__voucher_code | | \| Field label \| Voucher code \| \| --- \| --- \| \| Description \| The voucher code that was used for the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Voucher code | | Description | The voucher code that was used for the transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__amended \| \| --- \| \| \\| Field label \\| Amended \\| \\| --- \\| --- \\| \\| Description \\| Whether transaction has been amended or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Amended \| \| Description \| Whether transaction has been amended or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | trans__amended | | \| Field label \| Amended \| \| --- \| --- \| \| Description \| Whether transaction has been amended or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Amended | | Description | Whether transaction has been amended or not | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| trans__amend_reason \| \| --- \| \| \\| Field label \\| Amend reason \\| \\| --- \\| --- \\| \\| Description \\| Reason why transaction was amended \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Amend reason \| \| Description \| Reason why transaction was amended \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__amend_reason | | \| Field label \| Amend reason \| \| --- \| --- \| \| Description \| Reason why transaction was amended \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Amend reason | | Description | Reason why transaction was amended | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__transaction_parts \| \| --- \| \| \\| Field label \\| Transaction parts \\| \\| --- \\| --- \\| \\| Description \\| Transaction parts \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Transaction parts \| \| Description \| Transaction parts \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__transaction_parts | | \| Field label \| Transaction parts \| \| --- \| --- \| \| Description \| Transaction parts \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Transaction parts | | Description | Transaction parts | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__custom_parameters \| \| --- \| \| \\| Field label \\| Custom parameters \\| \\| --- \\| --- \\| \\| Description \\| List of custom parameters and values \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Custom parameters \| \| Description \| List of custom parameters and values \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | trans__custom_parameters | | \| Field label \| Custom parameters \| \| --- \| --- \| \| Description \| List of custom parameters and values \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Custom parameters | | Description | List of custom parameters and values | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| trans__commission_amount \| \| --- \| \| \\| Field label \\| Commission amount \\| \\| --- \\| --- \\| \\| Description \\| The amount of commission \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Commission amount \| \| Description \| The amount of commission \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | trans__commission_amount | | \| Field label \| Commission amount \| \| --- \| --- \| \| Description \| The amount of commission \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Commission amount | | Description | The amount of commission | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| trans__sale_amount \| \| --- \| \| \\| Field label \\| Sale amount \\| \\| --- \\| --- \\| \\| Description \\| The amount of sale \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Sale amount \| \| Description \| The amount of sale \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | trans__sale_amount | | \| Field label \| Sale amount \| \| --- \| --- \| \| Description \| The amount of sale \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Sale amount | | Description | The amount of sale | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| trans__old_sale_amount \| \| --- \| \| \\| Field label \\| Old sale amount \\| \\| --- \\| --- \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Old sale amount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | trans__old_sale_amount | | \| Field label \| Old sale amount \| \| --- \| --- \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Old sale amount | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| trans__old_commission_amount \| \| --- \| \| \\| Field label \\| Old commission amount \\| \\| --- \\| --- \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Old commission amount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | trans__old_commission_amount | | \| Field label \| Old commission amount \| \| --- \| --- \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Old commission amount | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| trans__original_sale_amount \| \| --- \| \| \\| Field label \\| Original sale amount \\| \\| --- \\| --- \\| \\| Description \\| The original sale amount \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Original sale amount \| \| Description \| The original sale amount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | trans__original_sale_amount | | \| Field label \| Original sale amount \| \| --- \| --- \| \| Description \| The original sale amount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Original sale amount | | Description | The original sale amount | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| trans__lapse_time \| \| --- \| \| \\| Field label \\| Lapse time \\| \\| --- \\| --- \\| \\| Description \\| The conversion time in seconds \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Lapse time \| \| Description \| The conversion time in seconds \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | trans__lapse_time | | \| Field label \| Lapse time \| \| --- \| --- \| \| Description \| The conversion time in seconds \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Lapse time | | Description | The conversion time in seconds | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| trans__network_fee \| \| --- \| \| \\| Field label \\| Network fee \\| \\| --- \\| --- \\| \\| Description \\| Network fee of the transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Network fee \| \| Description \| Network fee of the transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | trans__network_fee | | \| Field label \| Network fee \| \| --- \| --- \| \| Description \| Network fee of the transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Network fee | | Description | Network fee of the transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | ### TRANSACTIONS | \| pub__pending_no \| \| --- \| \| \\| Field label \\| Pending transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Pending transactions \| \| Description \| Number of pending transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | --- | | pub__pending_no | | \| Field label \| Pending transactions \| \| --- \| --- \| \| Description \| Number of pending transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Pending transactions | | Description | Number of pending transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub__pending_value \| \| --- \| \| \\| Field label \\| Pending value \\| \\| --- \\| --- \\| \\| Description \\| Value of pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Pending value \| \| Description \| Value of pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub__pending_value | | \| Field label \| Pending value \| \| --- \| --- \| \| Description \| Value of pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Pending value | | Description | Value of pending transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub__pending_comm \| \| --- \| \| \\| Field label \\| Pending commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Pending commission \| \| Description \| Commission of the pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub__pending_comm | | \| Field label \| Pending commission \| \| --- \| --- \| \| Description \| Commission of the pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Pending commission | | Description | Commission of the pending transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub__confirmed_no \| \| --- \| \| \\| Field label \\| Confirmed transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Confirmed transactions \| \| Description \| Number of confirmed transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub__confirmed_no | | \| Field label \| Confirmed transactions \| \| --- \| --- \| \| Description \| Number of confirmed transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Confirmed transactions | | Description | Number of confirmed transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub__confirmed_value \| \| --- \| \| \\| Field label \\| Confirmed value \\| \\| --- \\| --- \\| \\| Description \\| Value of confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Confirmed value \| \| Description \| Value of confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub__confirmed_value | | \| Field label \| Confirmed value \| \| --- \| --- \| \| Description \| Value of confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Confirmed value | | Description | Value of confirmed transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub__confirmed_comm \| \| --- \| \| \\| Field label \\| Confirmed commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Confirmed commission \| \| Description \| Commission of the confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub__confirmed_comm | | \| Field label \| Confirmed commission \| \| --- \| --- \| \| Description \| Commission of the confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Confirmed commission | | Description | Commission of the confirmed transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub__bonus_no \| \| --- \| \| \\| Field label \\| Bonus transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Bonus transactions \| \| Description \| Number of bonus transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub__bonus_no | | \| Field label \| Bonus transactions \| \| --- \| --- \| \| Description \| Number of bonus transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Bonus transactions | | Description | Number of bonus transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub__bonus_value \| \| --- \| \| \\| Field label \\| Bonus value \\| \\| --- \\| --- \\| \\| Description \\| Value of the bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Bonus value \| \| Description \| Value of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub__bonus_value | | \| Field label \| Bonus value \| \| --- \| --- \| \| Description \| Value of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Bonus value | | Description | Value of the bonus transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub__bonus_comm \| \| --- \| \| \\| Field label \\| Bonus commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Bonus commission \| \| Description \| Commission of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub__bonus_comm | | \| Field label \| Bonus commission \| \| --- \| --- \| \| Description \| Commission of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Bonus commission | | Description | Commission of the bonus transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub__total_no \| \| --- \| \| \\| Field label \\| Total transactions \\| \\| --- \\| --- \\| \\| Description \\| Total number of transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Total transactions \| \| Description \| Total number of transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub__total_no | | \| Field label \| Total transactions \| \| --- \| --- \| \| Description \| Total number of transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Total transactions | | Description | Total number of transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub__total_value \| \| --- \| \| \\| Field label \\| Total value \\| \\| --- \\| --- \\| \\| Description \\| Total value of transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total value \| \| Description \| Total value of transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub__total_value | | \| Field label \| Total value \| \| --- \| --- \| \| Description \| Total value of transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Total value | | Description | Total value of transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub__total_comm \| \| --- \| \| \\| Field label \\| Total commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the all transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total commission \| \| Description \| Commission of the all transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub__total_comm | | \| Field label \| Total commission \| \| --- \| --- \| \| Description \| Commission of the all transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Total commission | | Description | Commission of the all transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub__declined_no \| \| --- \| \| \\| Field label \\| Declined transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Declined transactions \| \| Description \| Number of declined transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub__declined_no | | \| Field label \| Declined transactions \| \| --- \| --- \| \| Description \| Number of declined transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Declined transactions | | Description | Number of declined transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub__declined_value \| \| --- \| \| \\| Field label \\| Declined value \\| \\| --- \\| --- \\| \\| Description \\| Value of the declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Declined value \| \| Description \| Value of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub__declined_value | | \| Field label \| Declined value \| \| --- \| --- \| \| Description \| Value of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Declined value | | Description | Value of the declined transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub__declined_comm \| \| --- \| \| \\| Field label \\| Declined commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Declined commission \| \| Description \| Commission of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub__declined_comm | | \| Field label \| Declined commission \| \| --- \| --- \| \| Description \| Commission of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Declined commission | | Description | Commission of the declined transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub_dwh__pending_no \| \| --- \| \| \\| Field label \\| Pending transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Pending transactions \| \| Description \| Number of pending transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub_dwh__pending_no | | \| Field label \| Pending transactions \| \| --- \| --- \| \| Description \| Number of pending transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Pending transactions | | Description | Number of pending transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub_dwh__pending_value \| \| --- \| \| \\| Field label \\| Pending value \\| \\| --- \\| --- \\| \\| Description \\| Value of pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Pending value \| \| Description \| Value of pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub_dwh__pending_value | | \| Field label \| Pending value \| \| --- \| --- \| \| Description \| Value of pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Pending value | | Description | Value of pending transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub_dwh__pending_comm \| \| --- \| \| \\| Field label \\| Pending commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Pending commission \| \| Description \| Commission of the pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub_dwh__pending_comm | | \| Field label \| Pending commission \| \| --- \| --- \| \| Description \| Commission of the pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Pending commission | | Description | Commission of the pending transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub_dwh__confirmed_no \| \| --- \| \| \\| Field label \\| Confirmed transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Confirmed transactions \| \| Description \| Number of confirmed transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub_dwh__confirmed_no | | \| Field label \| Confirmed transactions \| \| --- \| --- \| \| Description \| Number of confirmed transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Confirmed transactions | | Description | Number of confirmed transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub_dwh__confirmed_value \| \| --- \| \| \\| Field label \\| Confirmed value \\| \\| --- \\| --- \\| \\| Description \\| Value of confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Confirmed value \| \| Description \| Value of confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub_dwh__confirmed_value | | \| Field label \| Confirmed value \| \| --- \| --- \| \| Description \| Value of confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Confirmed value | | Description | Value of confirmed transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub_dwh__confirmed_comm \| \| --- \| \| \\| Field label \\| Confirmed commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Confirmed commission \| \| Description \| Commission of the confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub_dwh__confirmed_comm | | \| Field label \| Confirmed commission \| \| --- \| --- \| \| Description \| Commission of the confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Confirmed commission | | Description | Commission of the confirmed transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub_dwh__bonus_no \| \| --- \| \| \\| Field label \\| Bonus transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Bonus transactions \| \| Description \| Number of bonus transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub_dwh__bonus_no | | \| Field label \| Bonus transactions \| \| --- \| --- \| \| Description \| Number of bonus transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Bonus transactions | | Description | Number of bonus transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub_dwh__bonus_value \| \| --- \| \| \\| Field label \\| Bonus value \\| \\| --- \\| --- \\| \\| Description \\| Value of the bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Bonus value \| \| Description \| Value of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub_dwh__bonus_value | | \| Field label \| Bonus value \| \| --- \| --- \| \| Description \| Value of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Bonus value | | Description | Value of the bonus transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub_dwh__bonus_comm \| \| --- \| \| \\| Field label \\| Bonus commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Bonus commission \| \| Description \| Commission of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub_dwh__bonus_comm | | \| Field label \| Bonus commission \| \| --- \| --- \| \| Description \| Commission of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Bonus commission | | Description | Commission of the bonus transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub_dwh__total_no \| \| --- \| \| \\| Field label \\| Total transactions \\| \\| --- \\| --- \\| \\| Description \\| Total number of transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Total transactions \| \| Description \| Total number of transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub_dwh__total_no | | \| Field label \| Total transactions \| \| --- \| --- \| \| Description \| Total number of transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Total transactions | | Description | Total number of transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub_dwh__total_value \| \| --- \| \| \\| Field label \\| Total value \\| \\| --- \\| --- \\| \\| Description \\| Total value of transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total value \| \| Description \| Total value of transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub_dwh__total_value | | \| Field label \| Total value \| \| --- \| --- \| \| Description \| Total value of transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Total value | | Description | Total value of transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub_dwh__total_comm \| \| --- \| \| \\| Field label \\| Total commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the all transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total commission \| \| Description \| Commission of the all transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub_dwh__total_comm | | \| Field label \| Total commission \| \| --- \| --- \| \| Description \| Commission of the all transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Total commission | | Description | Commission of the all transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub_dwh__declined_no \| \| --- \| \| \\| Field label \\| Declined transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Declined transactions \| \| Description \| Number of declined transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | pub_dwh__declined_no | | \| Field label \| Declined transactions \| \| --- \| --- \| \| Description \| Number of declined transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Declined transactions | | Description | Number of declined transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| pub_dwh__declined_value \| \| --- \| \| \\| Field label \\| Declined value \\| \\| --- \\| --- \\| \\| Description \\| Value of the declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Declined value \| \| Description \| Value of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub_dwh__declined_value | | \| Field label \| Declined value \| \| --- \| --- \| \| Description \| Value of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Declined value | | Description | Value of the declined transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| pub_dwh__declined_comm \| \| --- \| \| \\| Field label \\| Declined commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Declined commission \| \| Description \| Commission of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | pub_dwh__declined_comm | | \| Field label \| Declined commission \| \| --- \| --- \| \| Description \| Commission of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Declined commission | | Description | Commission of the declined transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea__pending_no \| \| --- \| \| \\| Field label \\| Pending transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Pending transactions \| \| Description \| Number of pending transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea__pending_no | | \| Field label \| Pending transactions \| \| --- \| --- \| \| Description \| Number of pending transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Pending transactions | | Description | Number of pending transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea__pending_value \| \| --- \| \| \\| Field label \\| Pending value \\| \\| --- \\| --- \\| \\| Description \\| Value of pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Pending value \| \| Description \| Value of pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea__pending_value | | \| Field label \| Pending value \| \| --- \| --- \| \| Description \| Value of pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Pending value | | Description | Value of pending transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea__pending_comm \| \| --- \| \| \\| Field label \\| Pending commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Pending commission \| \| Description \| Commission of the pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea__pending_comm | | \| Field label \| Pending commission \| \| --- \| --- \| \| Description \| Commission of the pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Pending commission | | Description | Commission of the pending transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea__confirmed_no \| \| --- \| \| \\| Field label \\| Confirmed transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Confirmed transactions \| \| Description \| Number of confirmed transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea__confirmed_no | | \| Field label \| Confirmed transactions \| \| --- \| --- \| \| Description \| Number of confirmed transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Confirmed transactions | | Description | Number of confirmed transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea__confirmed_value \| \| --- \| \| \\| Field label \\| Confirmed value \\| \\| --- \\| --- \\| \\| Description \\| Value of confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Confirmed value \| \| Description \| Value of confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea__confirmed_value | | \| Field label \| Confirmed value \| \| --- \| --- \| \| Description \| Value of confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Confirmed value | | Description | Value of confirmed transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea__confirmed_comm \| \| --- \| \| \\| Field label \\| Confirmed commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Confirmed commission \| \| Description \| Commission of the confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea__confirmed_comm | | \| Field label \| Confirmed commission \| \| --- \| --- \| \| Description \| Commission of the confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Confirmed commission | | Description | Commission of the confirmed transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea__bonus_no \| \| --- \| \| \\| Field label \\| Bonus transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Bonus transactions \| \| Description \| Number of bonus transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea__bonus_no | | \| Field label \| Bonus transactions \| \| --- \| --- \| \| Description \| Number of bonus transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Bonus transactions | | Description | Number of bonus transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea__bonus_value \| \| --- \| \| \\| Field label \\| Bonus value \\| \\| --- \\| --- \\| \\| Description \\| Value of the bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Bonus value \| \| Description \| Value of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea__bonus_value | | \| Field label \| Bonus value \| \| --- \| --- \| \| Description \| Value of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Bonus value | | Description | Value of the bonus transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea__bonus_comm \| \| --- \| \| \\| Field label \\| Bonus commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Bonus commission \| \| Description \| Commission of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea__bonus_comm | | \| Field label \| Bonus commission \| \| --- \| --- \| \| Description \| Commission of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Bonus commission | | Description | Commission of the bonus transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea__total_no \| \| --- \| \| \\| Field label \\| Total transactions \\| \\| --- \\| --- \\| \\| Description \\| Total number of transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Total transactions \| \| Description \| Total number of transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea__total_no | | \| Field label \| Total transactions \| \| --- \| --- \| \| Description \| Total number of transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Total transactions | | Description | Total number of transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea__total_value \| \| --- \| \| \\| Field label \\| Total value \\| \\| --- \\| --- \\| \\| Description \\| Total value of transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total value \| \| Description \| Total value of transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea__total_value | | \| Field label \| Total value \| \| --- \| --- \| \| Description \| Total value of transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Total value | | Description | Total value of transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea__total_comm \| \| --- \| \| \\| Field label \\| Total commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the all transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total commission \| \| Description \| Commission of the all transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea__total_comm | | \| Field label \| Total commission \| \| --- \| --- \| \| Description \| Commission of the all transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Total commission | | Description | Commission of the all transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea__declined_no \| \| --- \| \| \\| Field label \\| Declined transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Declined transactions \| \| Description \| Number of declined transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea__declined_no | | \| Field label \| Declined transactions \| \| --- \| --- \| \| Description \| Number of declined transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Declined transactions | | Description | Number of declined transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea__declined_value \| \| --- \| \| \\| Field label \\| Declined value \\| \\| --- \\| --- \\| \\| Description \\| Value of the declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Declined value \| \| Description \| Value of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea__declined_value | | \| Field label \| Declined value \| \| --- \| --- \| \| Description \| Value of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Declined value | | Description | Value of the declined transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea__declined_comm \| \| --- \| \| \\| Field label \\| Declined commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Declined commission \| \| Description \| Commission of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea__declined_comm | | \| Field label \| Declined commission \| \| --- \| --- \| \| Description \| Commission of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Declined commission | | Description | Commission of the declined transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea_dwh__pending_no \| \| --- \| \| \\| Field label \\| Pending transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Pending transactions \| \| Description \| Number of pending transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea_dwh__pending_no | | \| Field label \| Pending transactions \| \| --- \| --- \| \| Description \| Number of pending transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Pending transactions | | Description | Number of pending transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea_dwh__pending_value \| \| --- \| \| \\| Field label \\| Pending value \\| \\| --- \\| --- \\| \\| Description \\| Value of pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Pending value \| \| Description \| Value of pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea_dwh__pending_value | | \| Field label \| Pending value \| \| --- \| --- \| \| Description \| Value of pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Pending value | | Description | Value of pending transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea_dwh__pending_comm \| \| --- \| \| \\| Field label \\| Pending commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the pending transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Pending commission \| \| Description \| Commission of the pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea_dwh__pending_comm | | \| Field label \| Pending commission \| \| --- \| --- \| \| Description \| Commission of the pending transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Pending commission | | Description | Commission of the pending transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea_dwh__confirmed_no \| \| --- \| \| \\| Field label \\| Confirmed transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Confirmed transactions \| \| Description \| Number of confirmed transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea_dwh__confirmed_no | | \| Field label \| Confirmed transactions \| \| --- \| --- \| \| Description \| Number of confirmed transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Confirmed transactions | | Description | Number of confirmed transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea_dwh__confirmed_value \| \| --- \| \| \\| Field label \\| Confirmed value \\| \\| --- \\| --- \\| \\| Description \\| Value of confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Confirmed value \| \| Description \| Value of confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea_dwh__confirmed_value | | \| Field label \| Confirmed value \| \| --- \| --- \| \| Description \| Value of confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Confirmed value | | Description | Value of confirmed transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea_dwh__confirmed_comm \| \| --- \| \| \\| Field label \\| Confirmed commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the confirmed transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Confirmed commission \| \| Description \| Commission of the confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea_dwh__confirmed_comm | | \| Field label \| Confirmed commission \| \| --- \| --- \| \| Description \| Commission of the confirmed transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Confirmed commission | | Description | Commission of the confirmed transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea_dwh__bonus_no \| \| --- \| \| \\| Field label \\| Bonus transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Bonus transactions \| \| Description \| Number of bonus transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea_dwh__bonus_no | | \| Field label \| Bonus transactions \| \| --- \| --- \| \| Description \| Number of bonus transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Bonus transactions | | Description | Number of bonus transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea_dwh__bonus_value \| \| --- \| \| \\| Field label \\| Bonus value \\| \\| --- \\| --- \\| \\| Description \\| Value of the bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Bonus value \| \| Description \| Value of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea_dwh__bonus_value | | \| Field label \| Bonus value \| \| --- \| --- \| \| Description \| Value of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Bonus value | | Description | Value of the bonus transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea_dwh__bonus_comm \| \| --- \| \| \\| Field label \\| Bonus commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the bonus transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Bonus commission \| \| Description \| Commission of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea_dwh__bonus_comm | | \| Field label \| Bonus commission \| \| --- \| --- \| \| Description \| Commission of the bonus transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Bonus commission | | Description | Commission of the bonus transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea_dwh__total_no \| \| --- \| \| \\| Field label \\| Total transactions \\| \\| --- \\| --- \\| \\| Description \\| Total number of transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Total transactions \| \| Description \| Total number of transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea_dwh__total_no | | \| Field label \| Total transactions \| \| --- \| --- \| \| Description \| Total number of transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Total transactions | | Description | Total number of transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea_dwh__total_value \| \| --- \| \| \\| Field label \\| Total value \\| \\| --- \\| --- \\| \\| Description \\| Total value of transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total value \| \| Description \| Total value of transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea_dwh__total_value | | \| Field label \| Total value \| \| --- \| --- \| \| Description \| Total value of transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Total value | | Description | Total value of transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea_dwh__total_comm \| \| --- \| \| \\| Field label \\| Total commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the all transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total commission \| \| Description \| Commission of the all transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea_dwh__total_comm | | \| Field label \| Total commission \| \| --- \| --- \| \| Description \| Commission of the all transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Total commission | | Description | Commission of the all transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea_dwh__declined_no \| \| --- \| \| \\| Field label \\| Declined transactions \\| \\| --- \\| --- \\| \\| Description \\| Number of declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Declined transactions \| \| Description \| Number of declined transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | crea_dwh__declined_no | | \| Field label \| Declined transactions \| \| --- \| --- \| \| Description \| Number of declined transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Declined transactions | | Description | Number of declined transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| crea_dwh__declined_value \| \| --- \| \| \\| Field label \\| Declined value \\| \\| --- \\| --- \\| \\| Description \\| Value of the declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Declined value \| \| Description \| Value of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea_dwh__declined_value | | \| Field label \| Declined value \| \| --- \| --- \| \| Description \| Value of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Declined value | | Description | Value of the declined transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| crea_dwh__declined_comm \| \| --- \| \| \\| Field label \\| Declined commission \\| \\| --- \\| --- \\| \\| Description \\| Commission of the declined transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Declined commission \| \| Description \| Commission of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | crea_dwh__declined_comm | | \| Field label \| Declined commission \| \| --- \| --- \| \| Description \| Commission of the declined transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Declined commission | | Description | Commission of the declined transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) |