Use the Facebook Billing Data data source 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 the basic ad metrics such as impressions, clicks and conversions.
For a full list of metrics and dimensions available in our Facebook Billing Data data source connector, take a look at our Facebook Billing Data documentation.
Once you’ve connected to Facebook Billing Data, you’re ready to create your first queries!
Try these queries
See the following use cases for examples on how to use the metrics and dimensions.
See total amount and amount due
Take a look at the invoices and their due amounts.
The "Total amount" metric shows the total amount.
The "Amount due" metric shows the amount left to be paid, it is equal to the billed amount minus the already paid amount.
For best results in Looker Studio, use the table chart type.
- Set the date range to This month to date.
- Select the Total amount and Amount due metrics.
- Select the Advertiser name, Due date, Invoice date, Invoice ID, and Payment status dimensions to include these details in the query.
See net amount with details
View the net amount along with details about the advertiser and campaign. In this example, we include the link to download the invoice as well as the invoice date and ID.
The "Net amount" metric shows the net amount of the campaign.
For best results in Looker Studio, use the table chart type.
- Set the date range to Last month.
- Select the Net amount metric.
- Select the Advertiser name, Campaign description, Download URI, Invoice date, and Invoice ID dimensions.
More resources
You might also be interested in: