---
title: "Google Ads Account Explorer data warehouse table groups"
slug: "google-ads-account-explorer-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for Google Ads Account Explorer. See all the tables and the fields included in them."
updated: 2026-03-05T14:13:49Z
published: 2026-03-05T14:13:49Z
canonical: "docs.supermetrics.com/google-ads-account-explorer-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.

# Google Ads Account Explorer data warehouse table groups

Search fields

### Table: INVOICE

| \| account_id \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| The ID of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| The ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| account_id |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| The ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | The ID of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| account_name \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| The name of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| The name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| account_name |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| The name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | The name of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| amount_before_fees \| \| --- \| \| \\| Display name \\| Amount before fees (account) \\| \\| --- \\| --- \\| \\| Description \\| The amount before fees on account level \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Amount before fees (account) \| \| Description \| The amount before fees on account level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| amount_before_fees |
| \| Display name \| Amount before fees (account) \| \| --- \| --- \| \| Description \| The amount before fees on account level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Amount before fees (account) |
| Description | The amount before fees on account level |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| amount_invoice \| \| --- \| \| \\| Display name \\| Amount (invoice) \\| \\| --- \\| --- \\| \\| Description \\| Total invoice amount (including all fees) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Amount (invoice) \| \| Description \| Total invoice amount (including all fees) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| amount_invoice |
| \| Display name \| Amount (invoice) \| \| --- \| --- \| \| Description \| Total invoice amount (including all fees) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Amount (invoice) |
| Description | Total invoice amount (including all fees) |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| billed_cost \| \| --- \| \| \\| Display name \\| Billed cost (account) \\| \\| --- \\| --- \\| \\| Description \\| The billed cost on account level \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Billed cost (account) \| \| Description \| The billed cost on account level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| billed_cost |
| \| Display name \| Billed cost (account) \| \| --- \| --- \| \| Description \| The billed cost on account level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Billed cost (account) |
| Description | The billed cost on account level |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| budget_name \| \| --- \| \| \\| Display name \\| Budget name \\| \\| --- \\| --- \\| \\| Description \\| The name of the account budget \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Budget name \| \| Description \| The name of the account budget \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| budget_name |
| \| Display name \| Budget name \| \| --- \| --- \| \| Description \| The name of the account budget \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Budget name |
| Description | The name of the account budget |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| currency_code \| \| --- \| \| \\| Display name \\| Currency code \\| \\| --- \\| --- \\| \\| Description \\| The currency code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Currency code \| \| Description \| The currency code \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| currency_code |
| \| Display name \| Currency code \| \| --- \| --- \| \| Description \| The currency code \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Display name | Currency code |
| Description | The currency code |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| 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) |
| \| document_number \| \| --- \| \| \\| Display name \\| Document number \\| \\| --- \\| --- \\| \\| Description \\| The number of the document \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Document number \| \| Description \| The number of the document \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| document_number |
| \| Display name \| Document number \| \| --- \| --- \| \| Description \| The number of the document \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Document number |
| Description | The number of the document |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| document_type \| \| --- \| \| \\| Display name \\| Document type \\| \\| --- \\| --- \\| \\| Description \\| The type of the document \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Document type \| \| Description \| The type of the document \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| document_type |
| \| Display name \| Document type \| \| --- \| --- \| \| Description \| The type of the document \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Document type |
| Description | The type of the document |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| due_date \| \| --- \| \| \\| Display name \\| Due date \\| \\| --- \\| --- \\| \\| Description \\| The due date of the invoice \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Due date \| \| Description \| The due date of the invoice \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| due_date |
| \| Display name \| Due date \| \| --- \| --- \| \| Description \| The due date of the invoice \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Due date |
| Description | The due date of the invoice |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| fees_invoice \| \| --- \| \| \\| Display name \\| Fees (invoice) \\| \\| --- \\| --- \\| \\| Description \\| The total amount of fees on invoice level \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Fees (invoice) \| \| Description \| The total amount of fees on invoice level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| fees_invoice |
| \| Display name \| Fees (invoice) \| \| --- \| --- \| \| Description \| The total amount of fees on invoice level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Fees (invoice) |
| Description | The total amount of fees on invoice level |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| invalid_activity_amount \| \| --- \| \| \\| Display name \\| Invalid activity amount (account) \\| \\| --- \\| --- \\| \\| Description \\| The invalid activity amount on account level \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Invalid activity amount (account) \| \| Description \| The invalid activity amount on account level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| invalid_activity_amount |
| \| Display name \| Invalid activity amount (account) \| \| --- \| --- \| \| Description \| The invalid activity amount on account level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Invalid activity amount (account) |
| Description | The invalid activity amount on account level |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| issue_date \| \| --- \| \| \\| Display name \\| Issue date \\| \\| --- \\| --- \\| \\| Description \\| The issue date of the invoice \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Issue date \| \| Description \| The issue date of the invoice \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| issue_date |
| \| Display name \| Issue date \| \| --- \| --- \| \| Description \| The issue date of the invoice \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Issue date |
| Description | The issue date of the invoice |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| manager_account_id \| \| --- \| \| \\| Display name \\| Manager account ID \\| \\| --- \\| --- \\| \\| Description \\| The ID of the manager account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Manager account ID \| \| Description \| The ID of the manager account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| manager_account_id |
| \| Display name \| Manager account ID \| \| --- \| --- \| \| Description \| The ID of the manager account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Manager account ID |
| Description | The ID of the manager account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| manager_account_name \| \| --- \| \| \\| Display name \\| Manager account name \\| \\| --- \\| --- \\| \\| Description \\| The name of the manager account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Manager account name \| \| Description \| The name of the manager account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| manager_account_name |
| \| Display name \| Manager account name \| \| --- \| --- \| \| Description \| The name of the manager account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Manager account name |
| Description | The name of the manager account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| overdelivery_amount \| \| --- \| \| \\| Display name \\| Overdelivery amount (account) \\| \\| --- \\| --- \\| \\| Description \\| The overdelivery amount on account level \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Overdelivery amount (account) \| \| Description \| The overdelivery amount on account level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| overdelivery_amount |
| \| Display name \| Overdelivery amount (account) \| \| --- \| --- \| \| Description \| The overdelivery amount on account level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Overdelivery amount (account) |
| Description | The overdelivery amount on account level |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| payments_account_id \| \| --- \| \| \\| Display name \\| Payments account ID \\| \\| --- \\| --- \\| \\| Description \\| The ID used to identify the payments account associated with the billing setup \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payments account ID \| \| Description \| The ID used to identify the payments account associated with the billing setup \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payments_account_id |
| \| Display name \| Payments account ID \| \| --- \| --- \| \| Description \| The ID used to identify the payments account associated with the billing setup \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payments account ID |
| Description | The ID used to identify the payments account associated with the billing setup |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payments_account_name \| \| --- \| \| \\| Display name \\| Payments account name \\| \\| --- \\| --- \\| \\| Description \\| The name used to identify the payments account associated with the billing setup \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payments account name \| \| Description \| The name used to identify the payments account associated with the billing setup \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payments_account_name |
| \| Display name \| Payments account name \| \| --- \| --- \| \| Description \| The name used to identify the payments account associated with the billing setup \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payments account name |
| Description | The name used to identify the payments account associated with the billing setup |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payments_profile_id \| \| --- \| \| \\| Display name \\| Payments profile ID \\| \\| --- \\| --- \\| \\| Description \\| The ID used to identify the payments profile associated with the billing setup \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payments profile ID \| \| Description \| The ID used to identify the payments profile associated with the billing setup \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payments_profile_id |
| \| Display name \| Payments profile ID \| \| --- \| --- \| \| Description \| The ID used to identify the payments profile associated with the billing setup \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payments profile ID |
| Description | The ID used to identify the payments profile associated with the billing setup |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payments_profile_name \| \| --- \| \| \\| Display name \\| Payments profile name \\| \\| --- \\| --- \\| \\| Description \\| The name used to identify the payment profile associated with the billing setup \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payments profile name \| \| Description \| The name used to identify the payment profile associated with the billing setup \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payments_profile_name |
| \| Display name \| Payments profile name \| \| --- \| --- \| \| Description \| The name used to identify the payment profile associated with the billing setup \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payments profile name |
| Description | The name used to identify the payment profile associated with the billing setup |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| purchase_order \| \| --- \| \| \\| Display name \\| Purchase order \\| \\| --- \\| --- \\| \\| Description \\| The purchase order number of the account budget \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Purchase order \| \| Description \| The purchase order number of the account budget \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| purchase_order |
| \| Display name \| Purchase order \| \| --- \| --- \| \| Description \| The purchase order number of the account budget \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Purchase order |
| Description | The purchase order number of the account budget |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| tax_amount \| \| --- \| \| \\| Display name \\| Tax amount (account) \\| \\| --- \\| --- \\| \\| Description \\| The tax amount on account level \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Tax amount (account) \| \| Description \| The tax amount on account level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| tax_amount |
| \| Display name \| Tax amount (account) \| \| --- \| --- \| \| Description \| The tax amount on account level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Tax amount (account) |
| Description | The tax amount on account level |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |