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 |