Windsor brings all your Retently data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Retently Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| campaigns__channel | TEXT | campaigns.channel | campaigns.channel | campaigns |
| campaigns__id | TEXT | campaigns.id | campaigns.id | campaigns |
| campaigns__isActive | BOOLEAN | campaigns.isActive | campaigns.isActive | campaigns |
| campaigns__metric | TEXT | campaigns.metric | campaigns.metric | campaigns |
| campaigns__name | TEXT | campaigns.name | campaigns.name | campaigns |
| campaigns__templateId | TEXT | campaigns.templateId | campaigns.templateId | campaigns |
| campaigns__type | TEXT | campaigns.type | campaigns.type | campaigns |
| companies__companyName | TEXT | companies.companyName | companies.companyName | companies |
| companies__contactsCount | NUMERIC | companies.contactsCount | companies.contactsCount | companies |
| companies__createdDate | TEXT | companies.createdDate | companies.createdDate | companies |
| companies__cxMetrics | OBJECT | companies.cxMetrics | companies.cxMetrics | companies |
| companies__domain | TEXT | companies.domain | companies.domain | companies |
| companies__id | TEXT | companies.id | companies.id | companies |
| companies__industryName | TEXT | companies.industryName | companies.industryName | companies |
| companies__tags | OBJECT | companies.tags | companies.tags | companies |
| customers__companyId | TEXT | customers.companyId | customers.companyId | customers |
| customers__companyName | TEXT | customers.companyName | customers.companyName | customers |
| customers__createdDate | TEXT | customers.createdDate | customers.createdDate | customers |
| customers__email | TEXT | customers.email | customers.email | customers |
| customers__firstName | TEXT | customers.firstName | customers.firstName | customers |
| customers__id | TEXT | customers.id | customers.id | customers |
| customers__lastName | TEXT | customers.lastName | customers.lastName | customers |
| customers__properties | OBJECT | customers.properties | customers.properties | customers |
| customers__tags | OBJECT | customers.tags | customers.tags | customers |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| feedback__additionalQuestions | OBJECT | feedback.additionalQuestions | feedback.additionalQuestions | feedback |
| feedback__assigned | TEXT | feedback.assigned | feedback.assigned | feedback |
| feedback__campaignId | TEXT | feedback.campaignId | feedback.campaignId | feedback |
| feedback__campaignName | TEXT | feedback.campaignName | feedback.campaignName | feedback |
| feedback__channel | TEXT | feedback.channel | feedback.channel | feedback |
| feedback__checkbox | BOOLEAN | feedback.checkbox | feedback.checkbox | feedback |
| feedback__city | CITY | feedback.city | feedback.city | feedback |
| feedback__comment | TEXT | feedback.comment | feedback.comment | feedback |
| feedback__companyId | TEXT | feedback.companyId | feedback.companyId | feedback |
| feedback__companyName | TEXT | feedback.companyName | feedback.companyName | feedback |
| feedback__country | COUNTRY | feedback.country | feedback.country | feedback |
| feedback__createdDate | TEXT | feedback.createdDate | feedback.createdDate | feedback |
| feedback__customProps | OBJECT | feedback.customProps | feedback.customProps | feedback |
| feedback__customerId | TEXT | feedback.customerId | feedback.customerId | feedback |
| feedback__email | TEXT | feedback.email | feedback.email | feedback |
| feedback__feedbackTags | OBJECT | feedback.feedbackTags | feedback.feedbackTags | feedback |
| feedback__feedbackTagsNew | OBJECT | feedback.feedbackTagsNew | feedback.feedbackTagsNew | feedback |
| feedback__feedbackTopics | OBJECT | feedback.feedbackTopics | feedback.feedbackTopics | feedback |
| feedback__firstName | TEXT | feedback.firstName | feedback.firstName | feedback |
| feedback__id | TEXT | feedback.id | feedback.id | feedback |
| feedback__isBogus | BOOLEAN | feedback.isBogus | feedback.isBogus | feedback |
| feedback__jobTitle | TEXT | feedback.jobTitle | feedback.jobTitle | feedback |
| feedback__lastName | TEXT | feedback.lastName | feedback.lastName | feedback |
| feedback__metricsType | TEXT | feedback.metricsType | feedback.metricsType | feedback |
| feedback__notes | OBJECT | feedback.notes | feedback.notes | feedback |
| feedback__ratingCategory | TEXT | feedback.ratingCategory | feedback.ratingCategory | feedback |
| feedback__resolved | BOOLEAN | feedback.resolved | feedback.resolved | feedback |
| feedback__score | NUMERIC | feedback.score | feedback.score | feedback |
| feedback__state | TEXT | feedback.state | feedback.state | feedback |
| feedback__status | TEXT | feedback.status | feedback.status | feedback |
| feedback__tags | OBJECT | feedback.tags | feedback.tags | feedback |
| nps__detractors | NUMERIC | nps.detractors | nps.detractors | nps |
| nps__detractorsCount | NUMERIC | nps.detractorsCount | nps.detractorsCount | nps |
| nps__metricsType | TEXT | nps.metricsType | nps.metricsType | nps |
| nps__passives | NUMERIC | nps.passives | nps.passives | nps |
| nps__passivesCount | NUMERIC | nps.passivesCount | nps.passivesCount | nps |
| nps__promoters | NUMERIC | nps.promoters | nps.promoters | nps |
| nps__promotersCount | NUMERIC | nps.promotersCount | nps.promotersCount | nps |
| nps__score | NUMERIC | nps.score | nps.score | nps |
| nps__scoreSum | NUMERIC | nps.scoreSum | nps.scoreSum | nps |
| nps__totalResponses | NUMERIC | nps.totalResponses | nps.totalResponses | nps |
| outbox__additionalRecipients | OBJECT | outbox.additionalRecipients | outbox.additionalRecipients | outbox |
| outbox__attributes | OBJECT | outbox.attributes | outbox.attributes | outbox |
| outbox__campaign | TEXT | outbox.campaign | outbox.campaign | outbox |
| outbox__campaignId | TEXT | outbox.campaignId | outbox.campaignId | outbox |
| outbox__channel | TEXT | outbox.channel | outbox.channel | outbox |
| outbox__companyId | TEXT | outbox.companyId | outbox.companyId | outbox |
| outbox__companyName | TEXT | outbox.companyName | outbox.companyName | outbox |
| outbox__customerId | TEXT | outbox.customerId | outbox.customerId | outbox |
| outbox__detailedStatus | OBJECT | outbox.detailedStatus | outbox.detailedStatus | outbox |
| outbox__email | TEXT | outbox.email | outbox.email | outbox |
| outbox__firstName | TEXT | outbox.firstName | outbox.firstName | outbox |
| outbox__lastName | TEXT | outbox.lastName | outbox.lastName | outbox |
| outbox__mandrillMessageId | TEXT | outbox.mandrillMessageId | outbox.mandrillMessageId | outbox |
| outbox__personTags | OBJECT | outbox.personTags | outbox.personTags | outbox |
| outbox__sentBy | TEXT | outbox.sentBy | outbox.sentBy | outbox |
| outbox__sentDate | TEXT | outbox.sentDate | outbox.sentDate | outbox |
| outbox__status | TEXT | outbox.status | outbox.status | outbox |
| outbox__subject | TEXT | outbox.subject | outbox.subject | outbox |
| outbox__surveyTemplateId | TEXT | outbox.surveyTemplateId | outbox.surveyTemplateId | outbox |
| reports__campaignId | TEXT | reports.campaignId | reports.campaignId | reports |
| reports__deliveryStats | OBJECT | reports.deliveryStats | reports.deliveryStats | reports |
| reports__last | OBJECT | reports.last | reports.last | reports |
| reports__questionsStats | OBJECT | reports.questionsStats | reports.questionsStats | reports |
| reports__trend | OBJECT | reports.trend | reports.trend | reports |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| templates__channel | TEXT | templates.channel | templates.channel | templates |
| templates__id | TEXT | templates.id | templates.id | templates |
| templates__metric | TEXT | templates.metric | templates.metric | templates |
| templates__name | TEXT | templates.name | templates.name | templates |
| today | DATE | Today | Today's date |