Amplitude fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

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

Early Access1 metrics53 dimensions

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

DEVICE

device_type
Field label Device type
Description The type of device
Field type dimension
Data type string.text.value
device_family
Field label Device family
Description The family of the device
Field type dimension
Data type string.text.value
device_carrier
Field label Device carrier
Description The carrier of the device
Field type dimension
Data type string.text.value
operating_system_name
Field label Operating system name
Description The name of the operating system
Field type dimension
Data type string.text.value
operating_system_version
Field label Operating system version
Description The version of the operating system
Field type dimension
Data type string.text.value
platform
Field label Platform
Description The platform on which the event occurred
Field type dimension
Data type string.text.value
language
Field label Language
Description The language set on the device
Field type dimension
Data type string.language.value
ip_address
Field label IP address
Description The IP address of the device
Field type dimension
Data type string.text.value

EVENT

event_type
Field label Event type
Description The type of event that occurred
Field type dimension
Data type string.text.value
is_attribution_event
Field label Is attribution event
Description Indicates whether the event is an attribution event
Field type dimension
Data type bool
number_of_events
Field label Events
Description Number of users
Field type metric
Data type int.number.value

GEO

city
Field label City
Description The city where the event occurred
Field type dimension
Data type string.geo.city
country
Field label Country
Description The country where the event occurred
Field type dimension
Data type string.geo.country
dma
Field label DMA
Description The designated market area where the event occurred
Field type dimension
Data type string.geo.region
region
Field label Region
Description The region where the event occurred
Field type dimension
Data type string.geo.region
location_latitude
Field label Location latitude
Description The latitude of the location where the event occurred
Field type dimension
Data type string.geo.latitude
location_longitude
Field label Location longitude
Description The longitude of the location where the event occurred
Field type dimension
Data type string.geo.longitude

IDENTIFIER

event_id
Field label Event ID
Description Unique identifier for the event
Field type dimension
Data type string.text.value
session_id
Field label Session ID
Description Unique identifier for the session
Field type dimension
Data type string.text.value
insert_id
Field label Insert ID
Description The ID for insert
Field type dimension
Data type string.text.value
amplitude_id
Field label Amplitude ID
Description Unique identifier for the user in Amplitude
Field type dimension
Data type string.text.value
device_id
Field label Device ID
Description Unique identifier for the device
Field type dimension
Data type string.text.value
user_id
Field label User ID
Description Unique identifier for the user
Field type dimension
Data type string.text.value
uuid
Field label UUID
Description Universally unique identifier
Field type dimension
Data type string.text.value
idfa
Field label IDFA
Description Identifier for Advertiser
Field type dimension
Data type string.text.value
app_id
Field label App ID
Description The application ID
Field type dimension
Data type string.text.value
amplitude_attribution_ids
Field label Amplitude attribution IDs
Description Amplitude attribution IDs
Field type dimension
Data type string.text.value

PROJECT

project_name
Field label Project name
Description Name of the Amplitude project
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