Facebook Billing Data fields

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

Supermetrics brings all your Facebook Billing Data data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

Early Access10 metrics43 dimensions

CAMPAIGN

invoices__campaigns__net_amount
Field label Net amount
Description Net amount
Field type metric
Data type float.currency.value
invoices__campaigns__tax_amount
Field label Tax amount
Description Amount of tax
Field type metric
Data type float.currency.value
invoices__campaigns__total_amount
Field label Total amount
Description Total amount
Field type metric
Data type float.currency.value
invoices__campaigns__impressions
Field label Impressions
Description Impressions
Field type metric
Data type int.number.value
invoices__campaigns__clicks
Field label Clicks
Description Clicks
Field type metric
Data type int.number.value
invoices__campaigns__conversions
Field label Conversions
Description Conversions
Field type metric
Data type int.number.value
invoices__campaigns__ctr
Field label CTR
Description Click through rate. (Clicks / Impressions)
Field type metric
Data type float.number.ratio
invoices__campaigns__cpm
Field label CPM
Description Cost per 1000 impressions. (Total amount / Impressions * 1000)
Field type metric
Data type int.number.value
invoices__campaigns__cpa
Field label CPA
Description Cost per acquisition. (Total amount / Conversions)
Field type metric
Data type float.currency.value

CAMPAIGNS

invoices__campaigns__campaign_id
Field label Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
invoices__campaigns__ad_account_id
Field label Ad account ID
Description ID of the ad account
Field type dimension
Data type string.text.value
invoices__campaigns__description
Field label Campaign description
Description Description of the campaign
Field type dimension
Data type string.text.value

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

INVOICE

invoices__fb_id
Field label 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_id
Field label Invoice ID
Description ID of the invoice
Field type dimension
Data type string.text.value
invoices__invoice_type
Field label Invoice type
Description Type of invoice
Field type dimension
Data type string.text.value
invoices__invoicing_entity
Field label Invoicing entity
Description Entity who has issued the invoice
Field type dimension
Data type string.text.value
invoices__currency
Field label Currency
Description The currency of the invoice
Field type dimension
Data type string.currency.code
invoices__advertiser_name
Field label Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
invoices__billing_period
Field label Billing period
Description Billing period
Field type dimension
Data type string.time.date
invoices__invoice_date
Field label Invoice date
Description Date of the invoice
Field type dimension
Data type string.time.date
invoices__due_date
Field label Due date
Description Due date
Field type dimension
Data type string.time.date
invoices__payment_term
Field label Payment term
Description Payment term
Field type dimension
Data type string.text.value
invoices__payment_status
Field label Payment status
Description Payment status
Field type dimension
Data type string.text.value
invoices__liability_type
Field label Liability type
Description Type of liability
Field type dimension
Data type string.text.value
invoices__download_uri
Field label Download URI
Description Download URI
Field type dimension
Data type string.text.url
invoices__cdn_download_uri
Field label CDN download URI
Description CDN download URI
Field type dimension
Data type string.text.url
invoices__amount_due
Field label Amount due
Description The amount left to be paid, it is equal to the billed amount minus already paid amount
Field type metric
Data type float.currency.value

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
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
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
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

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
invoices__year
Field label Year
Field type dimension
Data type string.time.year
invoices__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
invoices__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
invoices__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
invoices__month
Field label Month
Field type dimension
Data type string.time.month
invoices__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
invoices__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
invoices__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
invoices__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
invoices__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
invoices__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
invoices__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
invoices__date
Field label Date
Field type dimension
Data type string.time.date
invoices__atom
Field label Datetime
Field type dimension
Data type string.time.datetime