Use the Facebook Billing Data connector to pull invoice data from Facebook Business Manager and see the spend of multiple ad accounts in one view. Connect your invoice data with basic ad metrics such as impressions, clicks, and conversions.
Before you begin
Before you build reports, you need to connect the data source to Supermetrics.
Connection instructions: See our Facebook Billing Data connection guide.
Available metrics and dimensions: Find the full list of fields in our Facebook Billing Data field documentation.
Popular queries
These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.
Review invoice totals and outstanding amounts
See the total billed amount and what remains to be paid for each invoice this month, along with advertiser details and payment status — useful for keeping on top of outstanding balances across ad accounts.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | This month to date |
Metrics | Total amount, Amount due |
Dimensions | Advertiser name, Due date, Invoice date, Invoice ID, Payment status |
Suggested visualization | Table |
Understanding the data
Total amount: The total billed amount for the invoice.
Amount due: The amount still left to be paid, calculated as the billed amount minus any already paid amount.
Advertiser name: The name of the advertiser associated with the invoice.
Due date: The payment due date for the invoice.
Invoice date: The date the invoice was issued.
Invoice ID: The unique identifier for the invoice.
Payment status: The current payment status of the invoice, such as paid or unpaid.
View net amounts with campaign and download details
Get last month's net invoice amounts alongside advertiser, campaign, and download details — making it easy to reconcile billing with campaign activity and access invoices directly.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last month |
Metrics | Net amount |
Dimensions | Advertiser name, Campaign description, Download URI, Invoice date, Invoice ID |
Suggested visualization | Table |
Understanding the data
Net amount: The net amount of the campaign after adjustments.
Advertiser name: The name of the advertiser associated with the invoice.
Campaign description: A description of the campaign the invoice relates to.
Download URI: A direct link to download the invoice document.
Invoice date: The date the invoice was issued.
Invoice ID: The unique identifier for the invoice.
More resources
You might also be interested in: