PostHog Connector Reference

6 metrics77 dimensions

The PostHog connector exposes 83 fields (6 metrics, 77 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


PostHog Fields

PostHog annotations fields

The annotations report of the PostHog connector includes 10 fields.

ID Type Name Description
annotations__content TEXT annotations.content annotations.content
annotations__created_at TIMESTAMP annotations.created_at annotations.created_at
annotations__created_by OBJECT annotations.created_by annotations.created_by
annotations__creation_type TEXT annotations.creation_type annotations.creation_type
annotations__dashboard_item TEXT annotations.dashboard_item annotations.dashboard_item
annotations__date_marker TEXT annotations.date_marker annotations.date_marker
annotations__deleted BOOLEAN annotations.deleted annotations.deleted
annotations__id TEXT annotations.id annotations.id
annotations__scope TEXT annotations.scope annotations.scope
annotations__updated_at TIMESTAMP annotations.updated_at annotations.updated_at

PostHog cohorts fields

The cohorts report of the PostHog connector includes 11 fields.

ID Type Name Description
cohorts__count NUMERIC cohorts.count cohorts.count
cohorts__created_at TIMESTAMP cohorts.created_at cohorts.created_at
cohorts__created_by OBJECT cohorts.created_by cohorts.created_by
cohorts__deleted BOOLEAN cohorts.deleted cohorts.deleted
cohorts__errors_calculating NUMERIC cohorts.errors_calculating cohorts.errors_calculating
cohorts__groups OBJECT cohorts.groups cohorts.groups
cohorts__id TEXT cohorts.id cohorts.id
cohorts__is_calculating BOOLEAN cohorts.is_calculating cohorts.is_calculating
cohorts__is_static BOOLEAN cohorts.is_static cohorts.is_static
cohorts__last_calculation TEXT cohorts.last_calculation cohorts.last_calculation
cohorts__name TEXT cohorts.name cohorts.name

PostHog events fields

The events report of the PostHog connector includes 8 fields.

ID Type Name Description
events__distinct_id TEXT events.distinct_id events.distinct_id
events__elements OBJECT events.elements events.elements
events__elements_chain TEXT events.elements_chain events.elements_chain
events__event TEXT events.event events.event
events__id TEXT events.id events.id
events__person OBJECT events.person events.person
events__properties OBJECT events.properties events.properties
events__timestamp TEXT events.timestamp events.timestamp

PostHog feature_flags fields

The feature_flags report of the PostHog connector includes 9 fields.

ID Type Name Description
feature_flags__active BOOLEAN feature_flags.active feature_flags.active
feature_flags__created_at TIMESTAMP feature_flags.created_at feature_flags.created_at
feature_flags__created_by OBJECT feature_flags.created_by feature_flags.created_by
feature_flags__deleted BOOLEAN feature_flags.deleted feature_flags.deleted
feature_flags__filters OBJECT feature_flags.filters feature_flags.filters
feature_flags__id TEXT feature_flags.id feature_flags.id
feature_flags__key TEXT feature_flags.key feature_flags.key
feature_flags__name TEXT feature_flags.name feature_flags.name
feature_flags__rollout_percentage NUMERIC feature_flags.rollout_percentage feature_flags.rollout_percentage

PostHog insights fields

The insights report of the PostHog connector includes 23 fields.

ID Type Name Description
insights__created_at TIMESTAMP insights.created_at insights.created_at
insights__created_by OBJECT insights.created_by insights.created_by
insights__deleted BOOLEAN insights.deleted insights.deleted
insights__description TEXT insights.description insights.description
insights__effective_privilege_level NUMERIC insights.effective_privilege_level insights.effective_privilege_level
insights__effective_restriction_level NUMERIC insights.effective_restriction_level insights.effective_restriction_level
insights__favorited BOOLEAN insights.favorited insights.favorited
insights__filters OBJECT insights.filters insights.filters
insights__filters_hash TEXT insights.filters_hash insights.filters_hash
insights__id TEXT insights.id insights.id
insights__is_sample BOOLEAN insights.is_sample insights.is_sample
insights__last_modified_at TIMESTAMP insights.last_modified_at insights.last_modified_at
insights__last_modified_by OBJECT insights.last_modified_by insights.last_modified_by
insights__last_refresh TEXT insights.last_refresh insights.last_refresh
insights__name TEXT insights.name insights.name
insights__order TEXT insights.order insights.order
insights__refreshing BOOLEAN insights.refreshing insights.refreshing
insights__result OBJECT insights.result insights.result
insights__saved BOOLEAN insights.saved insights.saved
insights__short_id TEXT insights.short_id insights.short_id
insights__tags OBJECT insights.tags insights.tags
insights__timezone TEXT insights.timezone insights.timezone
insights__updated_at TIMESTAMP insights.updated_at insights.updated_at

PostHog persons fields

The persons report of the PostHog connector includes 6 fields.

ID Type Name Description
persons__created_at TIMESTAMP persons.created_at persons.created_at
persons__distinct_ids OBJECT persons.distinct_ids persons.distinct_ids
persons__id TEXT persons.id persons.id
persons__name TEXT persons.name persons.name
persons__properties OBJECT persons.properties persons.properties
persons__uuid TEXT persons.uuid persons.uuid

PostHog projects fields

The projects report of the PostHog connector includes 11 fields.

ID Type Name Description
projects__access_control BOOLEAN projects.access_control projects.access_control
projects__api_token TEXT projects.api_token projects.api_token
projects__completed_snippet_onboarding BOOLEAN projects.completed_snippet_onboarding projects.completed_snippet_onboarding
projects__effective_membership_level NUMERIC projects.effective_membership_level projects.effective_membership_level
projects__id TEXT projects.id projects.id
projects__ingested_event BOOLEAN projects.ingested_event projects.ingested_event
projects__is_demo BOOLEAN projects.is_demo projects.is_demo
projects__name TEXT projects.name projects.name
projects__organization TEXT projects.organization projects.organization
projects__timezone TEXT projects.timezone projects.timezone
projects__uuid TEXT projects.uuid projects.uuid

PostHog other fields

The PostHog connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date