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.

IDTypeNameDescription
annotations__contentTEXTannotations.contentannotations.content
annotations__created_atTIMESTAMPannotations.created_atannotations.created_at
annotations__created_byOBJECTannotations.created_byannotations.created_by
annotations__creation_typeTEXTannotations.creation_typeannotations.creation_type
annotations__dashboard_itemTEXTannotations.dashboard_itemannotations.dashboard_item
annotations__date_markerTEXTannotations.date_markerannotations.date_marker
annotations__deletedBOOLEANannotations.deletedannotations.deleted
annotations__idTEXTannotations.idannotations.id
annotations__scopeTEXTannotations.scopeannotations.scope
annotations__updated_atTIMESTAMPannotations.updated_atannotations.updated_at

PostHog cohorts fields

The cohorts report of the PostHog connector includes 11 fields.

IDTypeNameDescription
cohorts__countNUMERICcohorts.countcohorts.count
cohorts__created_atTIMESTAMPcohorts.created_atcohorts.created_at
cohorts__created_byOBJECTcohorts.created_bycohorts.created_by
cohorts__deletedBOOLEANcohorts.deletedcohorts.deleted
cohorts__errors_calculatingNUMERICcohorts.errors_calculatingcohorts.errors_calculating
cohorts__groupsOBJECTcohorts.groupscohorts.groups
cohorts__idTEXTcohorts.idcohorts.id
cohorts__is_calculatingBOOLEANcohorts.is_calculatingcohorts.is_calculating
cohorts__is_staticBOOLEANcohorts.is_staticcohorts.is_static
cohorts__last_calculationTEXTcohorts.last_calculationcohorts.last_calculation
cohorts__nameTEXTcohorts.namecohorts.name

PostHog events fields

The events report of the PostHog connector includes 8 fields.

IDTypeNameDescription
events__distinct_idTEXTevents.distinct_idevents.distinct_id
events__elementsOBJECTevents.elementsevents.elements
events__elements_chainTEXTevents.elements_chainevents.elements_chain
events__eventTEXTevents.eventevents.event
events__idTEXTevents.idevents.id
events__personOBJECTevents.personevents.person
events__propertiesOBJECTevents.propertiesevents.properties
events__timestampTEXTevents.timestampevents.timestamp

PostHog feature_flags fields

The feature_flags report of the PostHog connector includes 9 fields.

IDTypeNameDescription
feature_flags__activeBOOLEANfeature_flags.activefeature_flags.active
feature_flags__created_atTIMESTAMPfeature_flags.created_atfeature_flags.created_at
feature_flags__created_byOBJECTfeature_flags.created_byfeature_flags.created_by
feature_flags__deletedBOOLEANfeature_flags.deletedfeature_flags.deleted
feature_flags__filtersOBJECTfeature_flags.filtersfeature_flags.filters
feature_flags__idTEXTfeature_flags.idfeature_flags.id
feature_flags__keyTEXTfeature_flags.keyfeature_flags.key
feature_flags__nameTEXTfeature_flags.namefeature_flags.name
feature_flags__rollout_percentageNUMERICfeature_flags.rollout_percentagefeature_flags.rollout_percentage

PostHog insights fields

The insights report of the PostHog connector includes 23 fields.

IDTypeNameDescription
insights__created_atTIMESTAMPinsights.created_atinsights.created_at
insights__created_byOBJECTinsights.created_byinsights.created_by
insights__deletedBOOLEANinsights.deletedinsights.deleted
insights__descriptionTEXTinsights.descriptioninsights.description
insights__effective_privilege_levelNUMERICinsights.effective_privilege_levelinsights.effective_privilege_level
insights__effective_restriction_levelNUMERICinsights.effective_restriction_levelinsights.effective_restriction_level
insights__favoritedBOOLEANinsights.favoritedinsights.favorited
insights__filtersOBJECTinsights.filtersinsights.filters
insights__filters_hashTEXTinsights.filters_hashinsights.filters_hash
insights__idTEXTinsights.idinsights.id
insights__is_sampleBOOLEANinsights.is_sampleinsights.is_sample
insights__last_modified_atTIMESTAMPinsights.last_modified_atinsights.last_modified_at
insights__last_modified_byOBJECTinsights.last_modified_byinsights.last_modified_by
insights__last_refreshTEXTinsights.last_refreshinsights.last_refresh
insights__nameTEXTinsights.nameinsights.name
insights__orderTEXTinsights.orderinsights.order
insights__refreshingBOOLEANinsights.refreshinginsights.refreshing
insights__resultOBJECTinsights.resultinsights.result
insights__savedBOOLEANinsights.savedinsights.saved
insights__short_idTEXTinsights.short_idinsights.short_id
insights__tagsOBJECTinsights.tagsinsights.tags
insights__timezoneTEXTinsights.timezoneinsights.timezone
insights__updated_atTIMESTAMPinsights.updated_atinsights.updated_at

PostHog persons fields

The persons report of the PostHog connector includes 6 fields.

IDTypeNameDescription
persons__created_atTIMESTAMPpersons.created_atpersons.created_at
persons__distinct_idsOBJECTpersons.distinct_idspersons.distinct_ids
persons__idTEXTpersons.idpersons.id
persons__nameTEXTpersons.namepersons.name
persons__propertiesOBJECTpersons.propertiespersons.properties
persons__uuidTEXTpersons.uuidpersons.uuid

PostHog projects fields

The projects report of the PostHog connector includes 11 fields.

IDTypeNameDescription
projects__access_controlBOOLEANprojects.access_controlprojects.access_control
projects__api_tokenTEXTprojects.api_tokenprojects.api_token
projects__completed_snippet_onboardingBOOLEANprojects.completed_snippet_onboardingprojects.completed_snippet_onboarding
projects__effective_membership_levelNUMERICprojects.effective_membership_levelprojects.effective_membership_level
projects__idTEXTprojects.idprojects.id
projects__ingested_eventBOOLEANprojects.ingested_eventprojects.ingested_event
projects__is_demoBOOLEANprojects.is_demoprojects.is_demo
projects__nameTEXTprojects.nameprojects.name
projects__organizationTEXTprojects.organizationprojects.organization
projects__timezoneTEXTprojects.timezoneprojects.timezone
projects__uuidTEXTprojects.uuidprojects.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.

IDTypeNameDescriptionReport
data_fetched_atTIMESTAMPData fetched atUTC 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.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date