--- title: "Basis data warehouse table groups" slug: "basis-data-warehouse-table-groups" description: "Explore the complete Supermetrics data warehouse table groups for Basis. See all the tables and the fields included in them." updated: 2026-05-15T09:00:48Z published: 2026-05-15T09:00:48Z canonical: "docs.supermetrics.com/basis-data-warehouse-table-groups" --- > ## 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. # Basis data warehouse table groups Search fields ### Table: CAMPAIGN | \| campaign__brand__brand_id \| \| --- \| \| \\| Display name \\| Brand ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the brand \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Brand ID \| \| Description \| ID of the brand \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | campaign__brand__brand_id | | \| Display name \| Brand ID \| \| --- \| --- \| \| Description \| ID of the brand \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Brand ID | | Description | ID of the brand | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign__brand__brand_name \| \| --- \| \| \\| Display name \\| Brand name \\| \\| --- \\| --- \\| \\| Description \\| Name of the brand \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Brand name \| \| Description \| Name of the brand \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign__brand__brand_name | | \| Display name \| Brand name \| \| --- \| --- \| \| Description \| Name of the brand \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Brand name | | Description | Name of the brand | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign__brand__client_id \| \| --- \| \| \\| Display name \\| Client ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the client \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Client ID \| \| Description \| ID of the client \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign__brand__client_id | | \| Display name \| Client ID \| \| --- \| --- \| \| Description \| ID of the client \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Client ID | | Description | ID of the client | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign__campaign_id \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| ID of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign__campaign_id | | \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| ID of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Campaign ID | | Description | ID of the campaign | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign__campaign_name \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Name of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign__campaign_name | | \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Campaign name | | Description | Name of the campaign | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign__client_name \| \| --- \| \| \\| Display name \\| Client name \\| \\| --- \\| --- \\| \\| Description \\| Name of the client \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Client name \| \| Description \| Name of the client \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign__client_name | | \| Display name \| Client name \| \| --- \| --- \| \| Description \| Name of the client \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Client name | | Description | Name of the client | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign__end_date \| \| --- \| \| \\| Display name \\| Campaign end date \\| \\| --- \\| --- \\| \\| Description \\| The last day of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Campaign end date \| \| Description \| The last day of the campaign \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | campaign__end_date | | \| Display name \| Campaign end date \| \| --- \| --- \| \| Description \| The last day of the campaign \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Campaign end date | | Description | The last day of the campaign | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| campaign__initiative_name \| \| --- \| \| \\| Display name \\| Initiative name \\| \\| --- \\| --- \\| \\| Description \\| Initiative name of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Initiative name \| \| Description \| Initiative name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign__initiative_name | | \| Display name \| Initiative name \| \| --- \| --- \| \| Description \| Initiative name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Initiative name | | Description | Initiative name of the campaign | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign__line_item__line_item_id \| \| --- \| \| \\| Display name \\| Line item ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the line item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Line item ID \| \| Description \| ID of the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign__line_item__line_item_id | | \| Display name \| Line item ID \| \| --- \| --- \| \| Description \| ID of the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Line item ID | | Description | ID of the line item | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign__line_item__line_item_name \| \| --- \| \| \\| Display name \\| Line item name \\| \\| --- \\| --- \\| \\| Description \\| Name of the line item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Line item name \| \| Description \| Name of the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign__line_item__line_item_name | | \| Display name \| Line item name \| \| --- \| --- \| \| Description \| Name of the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Line item name | | Description | Name of the line item | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign__start_date \| \| --- \| \| \\| Display name \\| Campaign start date \\| \\| --- \\| --- \\| \\| Description \\| The first day of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Campaign start date \| \| Description \| The first day of the campaign \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | campaign__start_date | | \| Display name \| Campaign start date \| \| --- \| --- \| \| Description \| The first day of the campaign \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Campaign start date | | Description | The first day of the campaign | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| campaign__stats__ad_serving_spend \| \| --- \| \| \\| Display name \\| Net ad server spend \\| \\| --- \\| --- \\| \\| Description \\| Amount of spend on ad serving \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Net ad server spend \| \| Description \| Amount of spend on ad serving \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | campaign__stats__ad_serving_spend | | \| Display name \| Net ad server spend \| \| --- \| --- \| \| Description \| Amount of spend on ad serving \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Net ad server spend | | Description | Amount of spend on ad serving | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| campaign__stats__click_conversions \| \| --- \| \| \\| Display name \\| Click conversions \\| \\| --- \\| --- \\| \\| Description \\| Total click conversions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Click conversions \| \| Description \| Total click conversions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaign__stats__click_conversions | | \| Display name \| Click conversions \| \| --- \| --- \| \| Description \| Total click conversions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Click conversions | | Description | Total click conversions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaign__stats__clicks \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Gross number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| Gross number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaign__stats__clicks | | \| Display name \| Clicks \| \| --- \| --- \| \| Description \| Gross number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks | | Description | Gross number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaign__stats__data_spend \| \| --- \| \| \\| Display name \\| Net data spend \\| \\| --- \\| --- \\| \\| Description \\| Detailed Net and Gross: Amount spent on audience data \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Net data spend \| \| Description \| Detailed Net and Gross: Amount spent on audience data \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | campaign__stats__data_spend | | \| Display name \| Net data spend \| \| --- \| --- \| \| Description \| Detailed Net and Gross: Amount spent on audience data \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Net data spend | | Description | Detailed Net and Gross: Amount spent on audience data | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| campaign__stats__date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | campaign__stats__date | | \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| campaign__stats__delivered_units \| \| --- \| \| \\| Display name \\| Delivered units \\| \\| --- \\| --- \\| \\| Description \\| Delivered units \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Delivered units \| \| Description \| Delivered units \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaign__stats__delivered_units | | \| Display name \| Delivered units \| \| --- \| --- \| \| Description \| Delivered units \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Delivered units | | Description | Delivered units | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaign__stats__impressions \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| The gross number of impressions won \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| The gross number of impressions won \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaign__stats__impressions | | \| Display name \| Impressions \| \| --- \| --- \| \| Description \| The gross number of impressions won \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions | | Description | The gross number of impressions won | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaign__stats__interactions \| \| --- \| \| \\| Display name \\| Number of interacts \\| \\| --- \\| --- \\| \\| Description \\| Total number of interactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Number of interacts \| \| Description \| Total number of interactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaign__stats__interactions | | \| Display name \| Number of interacts \| \| --- \| --- \| \| Description \| Total number of interactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Number of interacts | | Description | Total number of interactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaign__stats__inventory_spend \| \| --- \| \| \\| Display name \\| Net inventory spend \\| \\| --- \\| --- \\| \\| Description \\| Net inventory spend \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Net inventory spend \| \| Description \| Net inventory spend \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | campaign__stats__inventory_spend | | \| Display name \| Net inventory spend \| \| --- \| --- \| \| Description \| Net inventory spend \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Net inventory spend | | Description | Net inventory spend | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| campaign__stats__media_spend \| \| --- \| \| \\| Display name \\| Net media spend \\| \\| --- \\| --- \\| \\| Description \\| Net media spend \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Net media spend \| \| Description \| Net media spend \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | campaign__stats__media_spend | | \| Display name \| Net media spend \| \| --- \| --- \| \| Description \| Net media spend \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Net media spend | | Description | Net media spend | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| campaign__stats__total_conversions \| \| --- \| \| \\| Display name \\| Conversions \\| \\| --- \\| --- \\| \\| Description \\| Total conversion \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Conversions \| \| Description \| Total conversion \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaign__stats__total_conversions | | \| Display name \| Conversions \| \| --- \| --- \| \| Description \| Total conversion \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Conversions | | Description | Total conversion | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaign__stats__total_spend \| \| --- \| \| \\| Display name \\| Gross total spend \\| \\| --- \\| --- \\| \\| Description \\| Total amount spend on media, ad serving and data including margin or markup \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Gross total spend \| \| Description \| Total amount spend on media, ad serving and data including margin or markup \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | campaign__stats__total_spend | | \| Display name \| Gross total spend \| \| --- \| --- \| \| Description \| Total amount spend on media, ad serving and data including margin or markup \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Gross total spend | | Description | Total amount spend on media, ad serving and data including margin or markup | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| campaign__stats__total_view_conversions \| \| --- \| \| \\| Display name \\| Viewed \\| \\| --- \\| --- \\| \\| Description \\| Total view conversions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Viewed \| \| Description \| Total view conversions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaign__stats__total_view_conversions | | \| Display name \| Viewed \| \| --- \| --- \| \| Description \| Total view conversions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Viewed | | Description | Total view conversions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaign__stats__video_completions \| \| --- \| \| \\| Display name \\| AV 100% \\| \\| --- \\| --- \\| \\| Description \\| The number of times the audio or video ads was view to completion \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| AV 100% \| \| Description \| The number of times the audio or video ads was view to completion \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaign__stats__video_completions | | \| Display name \| AV 100% \| \| --- \| --- \| \| Description \| The number of times the audio or video ads was view to completion \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | AV 100% | | Description | The number of times the audio or video ads was view to completion | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaign__stats__video_starts \| \| --- \| \| \\| Display name \\| Video starts \\| \\| --- \\| --- \\| \\| Description \\| The number of times the audio or video ads was started to be viewed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Video starts \| \| Description \| The number of times the audio or video ads was started to be viewed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaign__stats__video_starts | | \| Display name \| Video starts \| \| --- \| --- \| \| Description \| The number of times the audio or video ads was started to be viewed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Video starts | | Description | The number of times the audio or video ads was started to be viewed | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaign__status \| \| --- \| \| \\| Display name \\| Campaign status \\| \\| --- \\| --- \\| \\| Description \\| The campaign's status: Planning, Live, or Approved \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign status \| \| Description \| The campaign's status: Planning, Live, or Approved \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign__status | | \| Display name \| Campaign status \| \| --- \| --- \| \| Description \| The campaign's status: Planning, Live, or Approved \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Campaign status | | Description | The campaign's status: Planning, Live, or Approved | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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) \| | | dataSourceName | | \| Display name \| 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) \| | | Display name | 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) |