Facebook Billing Data data warehouse table groups

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

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
invoices__advertiser_name
Display name Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
invoices__billing_period
Display name Billing period
Description Billing period
Field type dimension
Data type string.time.date
invoices__campaigns__ad_account_id
Display name Ad account ID
Description ID of the ad account
Field type dimension
Data type string.text.value
invoices__campaigns__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
invoices__campaigns__clicks
Display name Clicks
Description Clicks
Field type metric
Data type int.number.value
invoices__campaigns__conversions
Display name Conversions
Description Conversions
Field type metric
Data type int.number.value
invoices__campaigns__description
Display name Campaign description
Description Description of the campaign
Field type dimension
Data type string.text.value
invoices__campaigns__impressions
Display name Impressions
Description Impressions
Field type metric
Data type int.number.value
invoices__campaigns__net_amount
Display name Net amount
Description Net amount
Field type metric
Data type float.currency.value
invoices__campaigns__tax_amount
Display name Tax amount
Description Amount of tax
Field type metric
Data type float.currency.value
invoices__campaigns__total_amount
Display name Total amount
Description Total amount
Field type metric
Data type float.currency.value
invoices__cdn_download_uri
Display name CDN download URI
Description CDN download URI
Field type dimension
Data type string.text.url
invoices__currency
Display name Currency
Description The currency of the invoice
Field type dimension
Data type string.currency.code
invoices__date
Display name Date
Field type dimension
Data type string.time.date
invoices__download_uri
Display name Download URI
Description Download URI
Field type dimension
Data type string.text.url
invoices__due_date
Display name Due date
Description Due date
Field type dimension
Data type string.time.date
invoices__fb_id
Display name Facebook's internal ID
Description This is the technical ID of the invoice. Usually you don't need to use this, but rather use Invoice ID
Field type dimension
Data type string.text.value
invoices__invoice_date
Display name Invoice date
Description Date of the invoice
Field type dimension
Data type string.time.date
invoices__invoice_id
Display name Invoice ID
Description ID of the invoice
Field type dimension
Data type string.text.value
invoices__invoice_type
Display name Invoice type
Description Type of invoice
Field type dimension
Data type string.text.value
invoices__invoicing_entity
Display name Invoicing entity
Description Entity who has issued the invoice
Field type dimension
Data type string.text.value
invoices__liability_type
Display name Liability type
Description Type of liability
Field type dimension
Data type string.text.value
invoices__payment_status
Display name Payment status
Description Payment status
Field type dimension
Data type string.text.value
invoices__payment_term
Display name Payment term
Description Payment term
Field type dimension
Data type string.text.value