Windsor brings all your PostHog data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

PostHog Field Reference

Fields

ID	Type	Name	Description	Report
annotations__content	TEXT	annotations.content	annotations.content	annotations
annotations__created_at	TEXT	annotations.created_at	annotations.created_at	annotations
annotations__created_by	OBJECT	annotations.created_by	annotations.created_by	annotations
annotations__creation_type	TEXT	annotations.creation_type	annotations.creation_type	annotations
annotations__dashboard_item	TEXT	annotations.dashboard_item	annotations.dashboard_item	annotations
annotations__date_marker	TEXT	annotations.date_marker	annotations.date_marker	annotations
annotations__deleted	BOOLEAN	annotations.deleted	annotations.deleted	annotations
annotations__id	NUMERIC	annotations.id	annotations.id	annotations
annotations__scope	TEXT	annotations.scope	annotations.scope	annotations
annotations__updated_at	TEXT	annotations.updated_at	annotations.updated_at	annotations
cohorts__count	NUMERIC	cohorts.count	cohorts.count	cohorts
cohorts__created_at	TEXT	cohorts.created_at	cohorts.created_at	cohorts
cohorts__created_by	OBJECT	cohorts.created_by	cohorts.created_by	cohorts
cohorts__deleted	BOOLEAN	cohorts.deleted	cohorts.deleted	cohorts
cohorts__errors_calculating	NUMERIC	cohorts.errors_calculating	cohorts.errors_calculating	cohorts
cohorts__groups	OBJECT	cohorts.groups	cohorts.groups	cohorts
cohorts__id	NUMERIC	cohorts.id	cohorts.id	cohorts
cohorts__is_calculating	BOOLEAN	cohorts.is_calculating	cohorts.is_calculating	cohorts
cohorts__is_static	BOOLEAN	cohorts.is_static	cohorts.is_static	cohorts
cohorts__last_calculation	TEXT	cohorts.last_calculation	cohorts.last_calculation	cohorts
cohorts__name	TEXT	cohorts.name	cohorts.name	cohorts
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
events__distinct_id	TEXT	events.distinct_id	events.distinct_id	events
events__elements	OBJECT	events.elements	events.elements	events
events__elements_chain	TEXT	events.elements_chain	events.elements_chain	events
events__event	TEXT	events.event	events.event	events
events__id	TEXT	events.id	events.id	events
events__person	OBJECT	events.person	events.person	events
events__properties	OBJECT	events.properties	events.properties	events
events__timestamp	TEXT	events.timestamp	events.timestamp	events
feature_flags__active	BOOLEAN	feature_flags.active	feature_flags.active	feature_flags
feature_flags__created_at	TEXT	feature_flags.created_at	feature_flags.created_at	feature_flags
feature_flags__created_by	OBJECT	feature_flags.created_by	feature_flags.created_by	feature_flags
feature_flags__deleted	BOOLEAN	feature_flags.deleted	feature_flags.deleted	feature_flags
feature_flags__filters	OBJECT	feature_flags.filters	feature_flags.filters	feature_flags
feature_flags__id	NUMERIC	feature_flags.id	feature_flags.id	feature_flags
feature_flags__key	TEXT	feature_flags.key	feature_flags.key	feature_flags
feature_flags__name	TEXT	feature_flags.name	feature_flags.name	feature_flags
feature_flags__rollout_percentage	NUMERIC	feature_flags.rollout_percentage	feature_flags.rollout_percentage	feature_flags
insights__created_at	TEXT	insights.created_at	insights.created_at	insights
insights__created_by	OBJECT	insights.created_by	insights.created_by	insights
insights__deleted	BOOLEAN	insights.deleted	insights.deleted	insights
insights__description	TEXT	insights.description	insights.description	insights
insights__effective_privilege_level	NUMERIC	insights.effective_privilege_level	insights.effective_privilege_level	insights
insights__effective_restriction_level	NUMERIC	insights.effective_restriction_level	insights.effective_restriction_level	insights
insights__favorited	BOOLEAN	insights.favorited	insights.favorited	insights
insights__filters	OBJECT	insights.filters	insights.filters	insights
insights__filters_hash	TEXT	insights.filters_hash	insights.filters_hash	insights
insights__id	NUMERIC	insights.id	insights.id	insights
insights__is_sample	BOOLEAN	insights.is_sample	insights.is_sample	insights
insights__last_modified_at	TEXT	insights.last_modified_at	insights.last_modified_at	insights
insights__last_modified_by	OBJECT	insights.last_modified_by	insights.last_modified_by	insights
insights__last_refresh	TEXT	insights.last_refresh	insights.last_refresh	insights
insights__name	TEXT	insights.name	insights.name	insights
insights__order	TEXT	insights.order	insights.order	insights
insights__refreshing	BOOLEAN	insights.refreshing	insights.refreshing	insights
insights__result	OBJECT	insights.result	insights.result	insights
insights__saved	BOOLEAN	insights.saved	insights.saved	insights
insights__short_id	TEXT	insights.short_id	insights.short_id	insights
insights__tags	OBJECT	insights.tags	insights.tags	insights
insights__timezone	TEXT	insights.timezone	insights.timezone	insights
insights__updated_at	TEXT	insights.updated_at	insights.updated_at	insights
persons__created_at	TEXT	persons.created_at	persons.created_at	persons
persons__distinct_ids	OBJECT	persons.distinct_ids	persons.distinct_ids	persons
persons__id	TEXT	persons.id	persons.id	persons
persons__name	TEXT	persons.name	persons.name	persons
projects__access_control	BOOLEAN	projects.access_control	projects.access_control	projects
projects__api_token	TEXT	projects.api_token	projects.api_token	projects
projects__completed_snippet_onboarding	BOOLEAN	projects.completed_snippet_onboarding	projects.completed_snippet_onboarding	projects
projects__effective_membership_level	NUMERIC	projects.effective_membership_level	projects.effective_membership_level	projects
projects__id	NUMERIC	projects.id	projects.id	projects
projects__ingested_event	BOOLEAN	projects.ingested_event	projects.ingested_event	projects
projects__is_demo	BOOLEAN	projects.is_demo	projects.is_demo	projects
projects__name	TEXT	projects.name	projects.name	projects
projects__organization	TEXT	projects.organization	projects.organization	projects
projects__timezone	TEXT	projects.timezone	projects.timezone	projects
projects__uuid	TEXT	projects.uuid	projects.uuid	projects
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date