Windsor brings all your Gainsight PX data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Gainsight PX Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| accounts__createDate | TEXT | accounts.createDate | accounts.createDate | accounts |
| accounts__customAttributes | OBJECT | accounts.customAttributes | accounts.customAttributes | accounts |
| accounts__dunsNumber | TEXT | accounts.dunsNumber | accounts.dunsNumber | accounts |
| accounts__id | TEXT | accounts.id | accounts.id | accounts |
| accounts__industry | TEXT | accounts.industry | accounts.industry | accounts |
| accounts__lastModifiedDate | TEXT | accounts.lastModifiedDate | accounts.lastModifiedDate | accounts |
| accounts__lastSeenDate | TEXT | accounts.lastSeenDate | accounts.lastSeenDate | accounts |
| accounts__location | TEXT | accounts.location | accounts.location | accounts |
| accounts__naicsCode | TEXT | accounts.naicsCode | accounts.naicsCode | accounts |
| accounts__name | TEXT | accounts.name | accounts.name | accounts |
| accounts__numberOfEmployees | TEXT | accounts.numberOfEmployees | accounts.numberOfEmployees | accounts |
| accounts__numberOfUsers | TEXT | accounts.numberOfUsers | accounts.numberOfUsers | accounts |
| accounts__parentGroupId | TEXT | accounts.parentGroupId | accounts.parentGroupId | accounts |
| accounts__plan | TEXT | accounts.plan | accounts.plan | accounts |
| accounts__propertyKeys | OBJECT | accounts.propertyKeys | accounts.propertyKeys | accounts |
| accounts__sfdcId | TEXT | accounts.sfdcId | accounts.sfdcId | accounts |
| accounts__sicCode | TEXT | accounts.sicCode | accounts.sicCode | accounts |
| accounts__trackedSubscriptionId | TEXT | accounts.trackedSubscriptionId | accounts.trackedSubscriptionId | accounts |
| accounts__website | TEXT | accounts.website | accounts.website | accounts |
| admin_attributes__apiName | TEXT | admin_attributes.apiName | admin_attributes.apiName | admin_attributes |
| admin_attributes__createdDate | NUMERIC | admin_attributes.createdDate | admin_attributes.createdDate | admin_attributes |
| admin_attributes__defaultValue | TEXT | admin_attributes.defaultValue | admin_attributes.defaultValue | admin_attributes |
| admin_attributes__description | TEXT | admin_attributes.description | admin_attributes.description | admin_attributes |
| admin_attributes__id | TEXT | admin_attributes.id | admin_attributes.id | admin_attributes |
| admin_attributes__internalName | TEXT | admin_attributes.internalName | admin_attributes.internalName | admin_attributes |
| admin_attributes__modifiedDate | NUMERIC | admin_attributes.modifiedDate | admin_attributes.modifiedDate | admin_attributes |
| admin_attributes__name | TEXT | admin_attributes.name | admin_attributes.name | admin_attributes |
| admin_attributes__origin | TEXT | admin_attributes.origin | admin_attributes.origin | admin_attributes |
| admin_attributes__state | TEXT | admin_attributes.state | admin_attributes.state | admin_attributes |
| admin_attributes__type | TEXT | admin_attributes.type | admin_attributes.type | admin_attributes |
| articles__articleKCs | OBJECT | articles.articleKCs | articles.articleKCs | articles |
| articles__articleName | TEXT | articles.articleName | articles.articleName | articles |
| articles__author | TEXT | articles.author | articles.author | articles |
| articles__createdDate | NUMERIC | articles.createdDate | articles.createdDate | articles |
| articles__id | TEXT | articles.id | articles.id | articles |
| articles__modifiedBy | OBJECT | articles.modifiedBy | articles.modifiedBy | articles |
| articles__modifiedDate | NUMERIC | articles.modifiedDate | articles.modifiedDate | articles |
| articles__productId | TEXT | articles.productId | articles.productId | articles |
| articles__productName | TEXT | articles.productName | articles.productName | articles |
| articles__releaseDate | TEXT | articles.releaseDate | articles.releaseDate | articles |
| articles__viewType | TEXT | articles.viewType | articles.viewType | articles |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| feature__featureLabels | OBJECT | feature.featureLabels | feature.featureLabels | feature |
| feature__id | TEXT | feature.id | feature.id | feature |
| feature__name | TEXT | feature.name | feature.name | feature |
| feature__parentFeatureId | TEXT | feature.parentFeatureId | feature.parentFeatureId | feature |
| feature__propertyKey | TEXT | feature.propertyKey | feature.propertyKey | feature |
| feature__status | TEXT | feature.status | feature.status | feature |
| feature__type | TEXT | feature.type | feature.type | feature |
| kcbot__createdBy | OBJECT | kcbot.createdBy | kcbot.createdBy | kcbot |
| kcbot__createdDate | NUMERIC | kcbot.createdDate | kcbot.createdDate | kcbot |
| kcbot__description | TEXT | kcbot.description | kcbot.description | kcbot |
| kcbot__environments | OBJECT | kcbot.environments | kcbot.environments | kcbot |
| kcbot__id | TEXT | kcbot.id | kcbot.id | kcbot |
| kcbot__modifiedBy | OBJECT | kcbot.modifiedBy | kcbot.modifiedBy | kcbot |
| kcbot__modifiedDate | NUMERIC | kcbot.modifiedDate | kcbot.modifiedDate | kcbot |
| kcbot__name | TEXT | kcbot.name | kcbot.name | kcbot |
| kcbot__priority | NUMERIC | kcbot.priority | kcbot.priority | kcbot |
| kcbot__productId | TEXT | kcbot.productId | kcbot.productId | kcbot |
| kcbot__productName | TEXT | kcbot.productName | kcbot.productName | kcbot |
| kcbot__status | TEXT | kcbot.status | kcbot.status | kcbot |
| segments__id | TEXT | segments.id | segments.id | segments |
| segments__name | TEXT | segments.name | segments.name | segments |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| user_attributes__apiName | TEXT | user_attributes.apiName | user_attributes.apiName | user_attributes |
| user_attributes__createdDate | NUMERIC | user_attributes.createdDate | user_attributes.createdDate | user_attributes |
| user_attributes__defaultValue | TEXT | user_attributes.defaultValue | user_attributes.defaultValue | user_attributes |
| user_attributes__description | TEXT | user_attributes.description | user_attributes.description | user_attributes |
| user_attributes__id | TEXT | user_attributes.id | user_attributes.id | user_attributes |
| user_attributes__internalName | TEXT | user_attributes.internalName | user_attributes.internalName | user_attributes |
| user_attributes__modifiedDate | NUMERIC | user_attributes.modifiedDate | user_attributes.modifiedDate | user_attributes |
| user_attributes__name | TEXT | user_attributes.name | user_attributes.name | user_attributes |
| user_attributes__origin | TEXT | user_attributes.origin | user_attributes.origin | user_attributes |
| user_attributes__state | TEXT | user_attributes.state | user_attributes.state | user_attributes |
| user_attributes__type | TEXT | user_attributes.type | user_attributes.type | user_attributes |
| users__accountId | TEXT | users.accountId | users.accountId | users |
| users__aptrinsicId | TEXT | users.aptrinsicId | users.aptrinsicId | users |
| users__createDate | NUMERIC | users.createDate | users.createDate | users |
| users__email | TEXT | users.email | users.email | users |
| users__firstName | TEXT | users.firstName | users.firstName | users |
| users__firstVisitDate | NUMERIC | users.firstVisitDate | users.firstVisitDate | users |
| users__gender | TEXT | users.gender | users.gender | users |
| users__globalUnsubscribe | BOOLEAN | users.globalUnsubscribe | users.globalUnsubscribe | users |
| users__id | TEXT | users.id | users.id | users |
| users__identifyId | TEXT | users.identifyId | users.identifyId | users |
| users__lastInferredLocation | OBJECT | users.lastInferredLocation | users.lastInferredLocation | users |
| users__lastModifiedDate | NUMERIC | users.lastModifiedDate | users.lastModifiedDate | users |
| users__lastName | TEXT | users.lastName | users.lastName | users |
| users__lastSeenDate | NUMERIC | users.lastSeenDate | users.lastSeenDate | users |
| users__lastVisitedUserAgentData | OBJECT | users.lastVisitedUserAgentData | users.lastVisitedUserAgentData | users |
| users__location | TEXT | users.location | users.location | users |
| users__numberOfVisits | NUMERIC | users.numberOfVisits | users.numberOfVisits | users |
| users__phone | TEXT | users.phone | users.phone | users |
| users__propertyKeys | OBJECT | users.propertyKeys | users.propertyKeys | users |
| users__role | TEXT | users.role | users.role | users |
| users__score | NUMERIC | users.score | users.score | users |
| users__sfdcContactId | TEXT | users.sfdcContactId | users.sfdcContactId | users |
| users__signUpDate | NUMERIC | users.signUpDate | users.signUpDate | users |
| users__subscriptionId | TEXT | users.subscriptionId | users.subscriptionId | users |
| users__title | TEXT | users.title | users.title | users |
| users__type | TEXT | users.type | users.type | users |