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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |
