Facebook Business Invoice: Most-used fields

The table below gives information about most-used fields that you can import from Facebook Business Invoice. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
account_name	account_name	The name of the associated ad account.	dimension
ad_account_id	ad_account_id	The unique identifier for the associated ad account.	dimension
ad_account_name	ad_account_name	The name of the associated ad account.	dimension
advertiser_name	advertiser_name	The name of the advertiser associated with the invoice or credit.	dimension
amount	amount	The total amount of the invoice.	metric
amount_due.amount	amount_due.amount	The total amount currently due on the invoice.	metric
amount_due.amount_in_hundredths	amount_due.amount_in_hundredths	The amount due for an invoice or credit, expressed in hundredths of the currency’s smallest unit (e.g., cents for USD).	metric
amount_due.currency	amount_due.currency	The currency in which the amount due is denominated.	dimension
amount_due.offsetted_amount	amount_due.offsetted_amount	The amount due after any offsets or adjustments have been applied.	metric
balance.amount	balance.amount	The current balance amount on the credit line.	metric
balance.currency	balance.currency	The currency of the current balance on the credit line.	dimension
billed_amount_details.currency	billed_amount_details.currency	The currency in which the billed amounts are denominated.	dimension
billed_amount_details.net_amount	billed_amount_details.net_amount	The net amount of the billing, excluding taxes and other charges.	metric
billed_amount_details.net_amount_in_millis	billed_amount_details.net_amount_in_millis	The net amount of the billing, excluding taxes, expressed in thousandths of the currency’s smallest unit.	metric
billed_amount_details.tax_amount	billed_amount_details.tax_amount	The amount of tax applied to the billing.	metric
billed_amount_details.tax_amount_in_millis	billed_amount_details.tax_amount_in_millis	The amount of tax applied to the billing, expressed in thousandths of the currency’s smallest unit.	metric
billed_amount_details.total_amount	billed_amount_details.total_amount	The total billed amount, including net amount and taxes.	metric
billed_amount_details.total_amount_in_millis	billed_amount_details.total_amount_in_millis	The total billed amount, including net amount and taxes, expressed in thousandths of the currency’s smallest unit.	metric
billing_period	billing_period	The period for which the invoice was issued.	dimension
business_id	business_id	The unique identifier of the business associated with the invoice.	dimension
business_name	business_name	The registered name of the business entity.	dimension
campaign_name	campaign_name	The name of the advertising campaign.	dimension
credit_available.amount	credit_available.amount	The amount of credit available on the credit line.	metric
credit_available.currency	credit_available.currency	The currency of the credit available on the credit line.	dimension
credit_type	credit_type	The category or classification of the credit line (e.g., ADS_BUSINESS, ADS_SEQUENTIAL, WHATSAPP_BUSINESS).	dimension
currency	currency	The currency used for the invoice.	dimension
download_uri	download_uri	The Uniform Resource Identifier (URI) where the invoice document can be downloaded.	dimension
due_date	due_date	The date by which the invoice payment is expected.	dimension
entity	entity	The business entity to which the invoice pertains.	dimension
id	id	The unique identifier for the invoice or credit memo.	dimension
invoice_date	invoice_date	The date when the invoice was issued.	dimension
invoice_date_iso	invoice_date_iso	The date the invoice was issued, in ISO 8601 format.	dimension
invoice_id	invoice_id	The unique identifier for the invoice.	dimension
invoice_type	invoice_type	The type of the invoice, such as ‘INV’ for Invoice or ‘CM’ for Credit Memo.	dimension
liability_type	liability_type	The classification of the financial liability (e.g., invoice, credit).	dimension
month	month	The month of the billing period or insights data.	metric
owner_business.id	owner_business.id	The unique identifier of the business account that owns or is responsible for the credit line or payment.	metric
owner_business.name	owner_business.name	The name of the business account that owns or is responsible for the credit line or payment.	dimension
owner_business_name	owner_business_name	The name of the business account that owns or is responsible for the extended credit payment.	dimension
payment_status	payment_status	The current payment status of the invoice.	dimension
payment_term	payment_term	The agreed-upon terms for payment, such as net 30 days.	dimension
type	type	Indicates the category of the financial record, such as an invoice, credit, or charge, providing a classification for the financial transaction.	dimension
year	year	The year of the billing period or insights data.	metric