---
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
canonical: "docs.supermetrics.com/facebook-billing-data-data-warehouse-table-groups"
---

> ## 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

### 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) |