Introduction

Datasources and destinations

Fields listing for PostHog

Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Browser
Browser value captured on the event. Example: Chrome
Field IDbrowser
TypeTEXT
Data Typedimension
Browser Version
Browser version captured on the event. Example: 123.0.6312.86
Field IDbrowser_version
TypeTEXT
Data Typedimension
City
City attached to the event. Example: Paris
Field IDcity
TypeCITY
Data Typedimension
Country Code
Two-letter country code attached to the event. Example: FR
Field IDcountry_code
TypeCOUNTRY_CODE
Data Typedimension
Current Url
Current page URL stored on the event. Example: https://example.com/pricing
Field IDcurrent_url
TypeURL
Data Typedimension
Device Id
Device identifier attached to the event. Example: 8bb53d57-6b5b-45da-b1fd-8dd8f4e7b63b
Field IDdevice_id
TypeTEXT
Data Typedimension
Device Type
Device category associated with the event. Example: Desktop
Field IDdevice_type
TypeTEXT
Data Typedimension
Distinct Id
Distinct identifier attached to the event. Example: user_42
Field IDdistinct_id
TypeTEXT
Data Typedimension
Elements Chain
Serialized PostHog DOM elements chain. Example: a.btn.btn-primary
Field IDelements_chain
TypeTEXT
Data Typedimension
Elements Json
Raw PostHog elements array serialized as JSON. Example: [{"tag_name":"a","text":"Buy now"}]
Field IDelements_json
TypeTEXT
Data Typedimension
Event Id
Unique PostHog event identifier. Example: 018f4d28-6d7d-0000-74db-2e5fd46f989e
Field IDevent_id
TypeTEXT
Data Typedimension
Event Name
Tracked PostHog event name. Example: $pageview
Field IDevent_name
TypeTEXT
Data Typedimension
Event Time
UTC timestamp when the event fired. Example: 2026-03-18T10:11:12.123456Z
Field IDevent_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Host
Hostname captured on the event. Example: example.com
Field IDhost
TypeTEXT
Data Typedimension
Lib
SDK library marker attached to the event. Example: web
Field IDlib
TypeTEXT
Data Typedimension
OS
Operating system attached to the event. Example: Mac OS X
Field IDos
TypeTEXT
Data Typedimension
OS Version
Operating system version attached to the event. Example: 14.4.1
Field IDos_version
TypeTEXT
Data Typedimension
Pathname
Pathname captured on the event. Example: /pricing
Field IDpathname
TypeTEXT
Data Typedimension
Person Json
Raw PostHog person object serialized as JSON. Example: {"is_identified":true,"distinct_ids":["user_42"]}
Field IDperson_json
TypeTEXT
Data Typedimension
Project Id
Numeric PostHog project identifier configured on the authorization. Example: 12345
Field IDproject_id
TypeNUMBER
Data Typedimension
Properties Json
Raw event properties serialized as JSON. Example: {"$browser":"Chrome","plan":"pro"}
Field IDproperties_json
TypeTEXT
Data Typedimension
Records
Constant row counter for each exported event. Example: 1
Field IDrecords
TypeNUMBER
Data Typemetric
Referrer
Referrer stored on the event. Example: https://www.google.com/
Field IDreferrer
TypeURL
Data Typedimension
Region
Region attached to the event. Example: Ile-de-France
Field IDregion
TypeREGION
Data Typedimension
Session Id
Session identifier attached to the event. Example: 0195a14f-39d6-76e1-8ec1-c1f52f36dd1a
Field IDsession_id
TypeTEXT
Data Typedimension
UTM Campaign
UTM campaign attached to the event. Example: spring_launch
Field IDutm_campaign
TypeTEXT
Data Typedimension
UTM Medium
UTM medium attached to the event. Example: email
Field IDutm_medium
TypeTEXT
Data Typedimension
UTM Source
UTM source attached to the event. Example: newsletter
Field IDutm_source
TypeTEXT
Data Typedimension