Google Ads Account Explorer fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Google Ads Account Explorer data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

Early Access7 metrics41 dimensions

ACCOUNT

account_name
Field label Account name
Description The name of the account
Field type dimension
Data type string.text.value
account_id
Field label Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
budget_name
Field label Budget name
Description The name of the account budget
Field type dimension
Data type string.text.value
amount_before_fees
Field label Amount before fees (account)
Description The amount before fees on account level
Field type metric
Data type float.currency.value
billed_cost
Field label Billed cost (account)
Description The billed cost on account level
Field type metric
Data type float.currency.value
tax_amount
Field label Tax amount (account)
Description The tax amount on account level
Field type metric
Data type float.currency.value
invalid_activity_amount
Field label Invalid activity amount (account)
Description The invalid activity amount on account level
Field type metric
Data type float.currency.value
overdelivery_amount
Field label Overdelivery amount (account)
Description The overdelivery amount on account level
Field type metric
Data type float.currency.value

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DOCUMENT

document_number
Field label Document number
Description The number of the document
Field type dimension
Data type string.text.value
issue_date
Field label Issue date
Description The issue date of the invoice
Field type dimension
Data type string.time.date
due_date
Field label Due date
Description The due date of the invoice
Field type dimension
Data type string.time.date
currency_code
Field label Currency code
Description The currency code
Field type dimension
Data type string.currency.code
document_type
Field label Document type
Description The type of the document
Field type dimension
Data type string.text.value
purchase_order
Field label Purchase order
Description The purchase order number of the account budget
Field type dimension
Data type string.text.value

INVOICE

amount_invoice
Field label Amount (invoice)
Description Total invoice amount (including all fees)
Field type metric
Data type float.currency.value
fees_invoice
Field label Fees (invoice)
Description The total amount of fees on invoice level
Field type metric
Data type float.currency.value

MANAGER ACCOUNT

manager_account_name
Field label Manager account name
Description The name of the manager account
Field type dimension
Data type string.text.value
manager_account_id
Field label Manager account ID
Description The ID of the manager account
Field type dimension
Data type string.text.value

PAYMENT ACCOUNT

payments_account_id
Field label 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
payments_account_name
Field label 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
payments_profile_id
Field label 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
payments_profile_name
Field label 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

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime