Facebook Billing Data metrics and dimensions

Early Access10 metrics44 dimensions

Search fields

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

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

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