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 |