Windsor brings all your Amplitude data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Amplitude Field Reference
Fields
| Id | Type | Name | Description | Report |
|---|---|---|---|---|
| active_users__date | TEXT | active_users.date | active_users.date | active_users |
| active_users__statistics | OBJECT | active_users.statistics | active_users.statistics | active_users |
| annotations__date | TEXT | annotations.date | annotations.date | annotations |
| annotations__details | TEXT | annotations.details | annotations.details | annotations |
| annotations__id | NUMERIC | annotations.id | annotations.id | annotations |
| annotations__label | TEXT | annotations.label | annotations.label | annotations |
| average_session_length__date | TEXT | average_session_length.date | average_session_length.date | average_session_length |
| average_session_length__length | NUMERIC | average_session_length.length | average_session_length.length | average_session_length |
| cohorts__appId | NUMERIC | cohorts.appId | cohorts.appId | cohorts |
| cohorts__archived | BOOLEAN | cohorts.archived | cohorts.archived | cohorts |
| cohorts__chart_id | TEXT | cohorts.chart_id | cohorts.chart_id | cohorts |
| cohorts__createdAt | NUMERIC | cohorts.createdAt | cohorts.createdAt | cohorts |
| cohorts__definition | OBJECT | cohorts.definition | cohorts.definition | cohorts |
| cohorts__description | TEXT | cohorts.description | cohorts.description | cohorts |
| cohorts__edit_id | TEXT | cohorts.edit_id | cohorts.edit_id | cohorts |
| cohorts__finished | BOOLEAN | cohorts.finished | cohorts.finished | cohorts |
| BOOLEAN | cohorts.hidden | cohorts.hidden | cohorts | |
| cohorts__id | TEXT | cohorts.id | cohorts.id | cohorts |
| cohorts__is_official_content | BOOLEAN | cohorts.is_official_content | cohorts.is_official_content | cohorts |
| cohorts__is_predictive | BOOLEAN | cohorts.is_predictive | cohorts.is_predictive | cohorts |
| cohorts__lastComputed | NUMERIC | cohorts.lastComputed | cohorts.lastComputed | cohorts |
| cohorts__lastMod | NUMERIC | cohorts.lastMod | cohorts.lastMod | cohorts |
| cohorts__last_viewed | NUMERIC | cohorts.last_viewed | cohorts.last_viewed | cohorts |
| cohorts__location_id | TEXT | cohorts.location_id | cohorts.location_id | cohorts |
| cohorts__metadata | OBJECT | cohorts.metadata | cohorts.metadata | cohorts |
| cohorts__name | TEXT | cohorts.name | cohorts.name | cohorts |
| cohorts__owners | OBJECT | cohorts.owners | cohorts.owners | cohorts |
| cohorts__popularity | NUMERIC | cohorts.popularity | cohorts.popularity | cohorts |
| cohorts__published | BOOLEAN | cohorts.published | cohorts.published | cohorts |
| cohorts__shortcut_ids | OBJECT | cohorts.shortcut_ids | cohorts.shortcut_ids | cohorts |
| cohorts__size | NUMERIC | cohorts.size | cohorts.size | cohorts |
| cohorts__type | TEXT | cohorts.type | cohorts.type | cohorts |
| cohorts__view_count | NUMERIC | cohorts.view_count | cohorts.view_count | cohorts |
| cohorts__viewers | OBJECT | cohorts.viewers | cohorts.viewers | cohorts |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| events__$insert_id | TEXT | events.$insert_id | events.$insert_id | events |
| events__$insert_key | TEXT | events.$insert_key | events.$insert_key | events |
| events__$schema | NUMERIC | events.$schema | events.$schema | events |
| events__adid | TEXT | events.adid | events.adid | events |
| events__amplitude_attribution_ids | TEXT | events.amplitude_attribution_ids | events.amplitude_attribution_ids | events |
| events__amplitude_event_type | TEXT | events.amplitude_event_type | events.amplitude_event_type | events |
| events__amplitude_id | NUMERIC | events.amplitude_id | events.amplitude_id | events |
| events__app | NUMERIC | events.app | events.app | events |
| events__city | TEXT | events.city | events.city | events |
| events__client_event_time | TEXT | events.client_event_time | events.client_event_time | events |
| events__client_upload_time | TEXT | events.client_upload_time | events.client_upload_time | events |
| events__country | TEXT | events.country | events.country | events |
| events__data | OBJECT | events.data | events.data | events |
| events__data_type | TEXT | events.data_type | events.data_type | events |
| events__device_brand | TEXT | events.device_brand | events.device_brand | events |
| events__device_carrier | TEXT | events.device_carrier | events.device_carrier | events |
| events__device_family | TEXT | events.device_family | events.device_family | events |
| events__device_id | TEXT | events.device_id | events.device_id | events |
| events__device_manufacturer | TEXT | events.device_manufacturer | events.device_manufacturer | events |
| events__device_model | TEXT | events.device_model | events.device_model | events |
| events__device_type | TEXT | events.device_type | events.device_type | events |
| events__dma | TEXT | events.dma | events.dma | events |
| events__event_id | NUMERIC | events.event_id | events.event_id | events |
| events__event_properties | OBJECT | events.event_properties | events.event_properties | events |
| events__event_time | TEXT | events.event_time | events.event_time | events |
| events__event_type | TEXT | events.event_type | events.event_type | events |
| events__global_user_properties | OBJECT | events.global_user_properties | events.global_user_properties | events |
| events__group_properties | OBJECT | events.group_properties | events.group_properties | events |
| events__groups | OBJECT | events.groups | events.groups | events |
| events__idfa | TEXT | events.idfa | events.idfa | events |
| events__ip_address | TEXT | events.ip_address | events.ip_address | events |
| events__is_attribution_event | BOOLEAN | events.is_attribution_event | events.is_attribution_event | events |
| events__language | TEXT | events.language | events.language | events |
| events__library | TEXT | events.library | events.library | events |
| events__location_lat | NUMERIC | events.location_lat | events.location_lat | events |
| events__location_lng | NUMERIC | events.location_lng | events.location_lng | events |
| events__os_name | TEXT | events.os_name | events.os_name | events |
| events__os_version | TEXT | events.os_version | events.os_version | events |
| events__partner_id | TEXT | events.partner_id | events.partner_id | events |
| events__paying | BOOLEAN | events.paying | events.paying | events |
| events__plan | OBJECT | events.plan | events.plan | events |
| events__platform | TEXT | events.platform | events.platform | events |
| events__processed_time | TEXT | events.processed_time | events.processed_time | events |
| events__region | TEXT | events.region | events.region | events |
| events__sample_rate | NUMERIC | events.sample_rate | events.sample_rate | events |
| events__server_received_time | TEXT | events.server_received_time | events.server_received_time | events |
| events__server_upload_time | TEXT | events.server_upload_time | events.server_upload_time | events |
| events__session_id | NUMERIC | events.session_id | events.session_id | events |
| events__source_id | TEXT | events.source_id | events.source_id | events |
| events__start_version | TEXT | events.start_version | events.start_version | events |
| events__user_creation_time | TEXT | events.user_creation_time | events.user_creation_time | events |
| events__user_id | TEXT | events.user_id | events.user_id | events |
| events__user_properties | OBJECT | events.user_properties | events.user_properties | events |
| events__uuid | TEXT | events.uuid | events.uuid | events |
| events__version_name | TEXT | events.version_name | events.version_name | events |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |