---
title: "Facebook Billing Data data warehouse table groups"
slug: "facebook-billing-data-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for Facebook Billing Data. See all the tables and the fields included in them."
updated: 2026-03-05T14:18:55Z
published: 2026-03-05T14:18:55Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Facebook Billing Data data warehouse table groups

Search fields<input type="text" id="field-search" placeholder="Search by field name, label, or description…" aria-label="Search fields by name, label, or description" autocomplete="off">

### Table: CAMPAIGN

| \| dataSourceName** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| --- |
| dataSourceName** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| invoices__advertiser_name** \| \| --- \| \| \\| Display name \\| Advertiser name \\| \\| --- \\| --- \\| \\| Description \\| Name of the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Advertiser name \| \| Description \| Name of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| invoices__advertiser_name** |
| \| Display name \| Advertiser name \| \| --- \| --- \| \| Description \| Name of the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Advertiser name |
| Description | Name of the advertiser |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| invoices__billing_period** \| \| --- \| \| \\| Display name \\| Billing period \\| \\| --- \\| --- \\| \\| Description \\| Billing period \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Billing period \| \| Description \| Billing period \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| invoices__billing_period** |
| \| Display name \| Billing period \| \| --- \| --- \| \| Description \| Billing period \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Billing period |
| Description | Billing period |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| invoices__campaigns__ad_account_id** \| \| --- \| \| \\| Display name \\| Ad account ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the ad account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad account ID \| \| Description \| ID of the ad account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| invoices__campaigns__ad_account_id** |
| \| Display name \| Ad account ID \| \| --- \| --- \| \| Description \| ID of the ad account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Ad account ID |
| Description | ID of the ad account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| invoices__campaigns__campaign_id** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| ID of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| invoices__campaigns__campaign_id** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| ID of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Description | ID of the campaign |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| invoices__campaigns__clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| Clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| invoices__campaigns__clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Description \| Clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Description | Clicks |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| invoices__campaigns__conversions** \| \| --- \| \| \\| Display name \\| Conversions \\| \\| --- \\| --- \\| \\| Description \\| Conversions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Conversions \| \| Description \| Conversions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| invoices__campaigns__conversions** |
| \| Display name \| Conversions \| \| --- \| --- \| \| Description \| Conversions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Conversions |
| Description | Conversions |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| invoices__campaigns__description** \| \| --- \| \| \\| Display name \\| Campaign description \\| \\| --- \\| --- \\| \\| Description \\| Description of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign description \| \| Description \| Description of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| invoices__campaigns__description** |
| \| Display name \| Campaign description \| \| --- \| --- \| \| Description \| Description of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign description |
| Description | Description of the campaign |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| invoices__campaigns__impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| Impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| invoices__campaigns__impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Description \| Impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Description | Impressions |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| invoices__campaigns__net_amount** \| \| --- \| \| \\| Display name \\| Net amount \\| \\| --- \\| --- \\| \\| Description \\| Net amount \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Net amount \| \| Description \| Net amount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| invoices__campaigns__net_amount** |
| \| Display name \| Net amount \| \| --- \| --- \| \| Description \| Net amount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Net amount |
| Description | Net amount |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| invoices__campaigns__tax_amount** \| \| --- \| \| \\| Display name \\| Tax amount \\| \\| --- \\| --- \\| \\| Description \\| Amount of tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Tax amount \| \| Description \| Amount of tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| invoices__campaigns__tax_amount** |
| \| Display name \| Tax amount \| \| --- \| --- \| \| Description \| Amount of tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Tax amount |
| Description | Amount of tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| invoices__campaigns__total_amount** \| \| --- \| \| \\| Display name \\| Total amount \\| \\| --- \\| --- \\| \\| Description \\| Total amount \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Total amount \| \| Description \| Total amount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| invoices__campaigns__total_amount** |
| \| Display name \| Total amount \| \| --- \| --- \| \| Description \| Total amount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Total amount |
| Description | Total amount |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| invoices__cdn_download_uri** \| \| --- \| \| \\| Display name \\| CDN download URI \\| \\| --- \\| --- \\| \\| Description \\| CDN download URI \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| CDN download URI \| \| Description \| CDN download URI \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| invoices__cdn_download_uri** |
| \| Display name \| CDN download URI \| \| --- \| --- \| \| Description \| CDN download URI \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | CDN download URI |
| Description | CDN download URI |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| invoices__currency** \| \| --- \| \| \\| Display name \\| Currency \\| \\| --- \\| --- \\| \\| Description \\| The currency of the invoice \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Currency \| \| Description \| The currency of the invoice \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| invoices__currency** |
| \| Display name \| Currency \| \| --- \| --- \| \| Description \| The currency of the invoice \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Display name | Currency |
| Description | The currency of the invoice |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| invoices__date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| invoices__date** |
| \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| invoices__download_uri** \| \| --- \| \| \\| Display name \\| Download URI \\| \\| --- \\| --- \\| \\| Description \\| Download URI \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Download URI \| \| Description \| Download URI \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| invoices__download_uri** |
| \| Display name \| Download URI \| \| --- \| --- \| \| Description \| Download URI \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Download URI |
| Description | Download URI |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| invoices__due_date** \| \| --- \| \| \\| Display name \\| Due date \\| \\| --- \\| --- \\| \\| Description \\| Due date \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Due date \| \| Description \| Due date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| invoices__due_date** |
| \| Display name \| Due date \| \| --- \| --- \| \| Description \| Due date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Due date |
| Description | Due date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| invoices__fb_id** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| invoices__fb_id** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| invoices__invoice_date** \| \| --- \| \| \\| Display name \\| Invoice date \\| \\| --- \\| --- \\| \\| Description \\| Date of the invoice \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Invoice date \| \| Description \| Date of the invoice \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| invoices__invoice_date** |
| \| Display name \| Invoice date \| \| --- \| --- \| \| Description \| Date of the invoice \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Invoice date |
| Description | Date of the invoice |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| invoices__invoice_id** \| \| --- \| \| \\| Display name \\| Invoice ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the invoice \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Invoice ID \| \| Description \| ID of the invoice \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| invoices__invoice_id** |
| \| Display name \| Invoice ID \| \| --- \| --- \| \| Description \| ID of the invoice \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Invoice ID |
| Description | ID of the invoice |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| invoices__invoice_type** \| \| --- \| \| \\| Display name \\| Invoice type \\| \\| --- \\| --- \\| \\| Description \\| Type of invoice \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Invoice type \| \| Description \| Type of invoice \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| invoices__invoice_type** |
| \| Display name \| Invoice type \| \| --- \| --- \| \| Description \| Type of invoice \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Invoice type |
| Description | Type of invoice |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| invoices__invoicing_entity** \| \| --- \| \| \\| Display name \\| Invoicing entity \\| \\| --- \\| --- \\| \\| Description \\| Entity who has issued the invoice \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Invoicing entity \| \| Description \| Entity who has issued the invoice \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| invoices__invoicing_entity** |
| \| Display name \| Invoicing entity \| \| --- \| --- \| \| Description \| Entity who has issued the invoice \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Invoicing entity |
| Description | Entity who has issued the invoice |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| invoices__liability_type** \| \| --- \| \| \\| Display name \\| Liability type \\| \\| --- \\| --- \\| \\| Description \\| Type of liability \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Liability type \| \| Description \| Type of liability \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| invoices__liability_type** |
| \| Display name \| Liability type \| \| --- \| --- \| \| Description \| Type of liability \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Liability type |
| Description | Type of liability |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| invoices__payment_status** \| \| --- \| \| \\| Display name \\| Payment status \\| \\| --- \\| --- \\| \\| Description \\| Payment status \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment status \| \| Description \| Payment status \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| invoices__payment_status** |
| \| Display name \| Payment status \| \| --- \| --- \| \| Description \| Payment status \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment status |
| Description | Payment status |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| invoices__payment_term** \| \| --- \| \| \\| Display name \\| Payment term \\| \\| --- \\| --- \\| \\| Description \\| Payment term \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment term \| \| Description \| Payment term \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| invoices__payment_term** |
| \| Display name \| Payment term \| \| --- \| --- \| \| Description \| Payment term \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment term |
| Description | Payment term |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |