Retently Connector Reference
The Retently connector exposes 98 fields (11 metrics, 87 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Retently Fields
Retently campaigns fields
The campaigns report of the Retently connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| campaigns__channel | TEXT | campaigns.channel | campaigns.channel |
| campaigns__id | TEXT | campaigns.id | campaigns.id |
| campaigns__isActive | BOOLEAN | campaigns.isActive | campaigns.isActive |
| campaigns__metric | TEXT | campaigns.metric | campaigns.metric |
| campaigns__name | TEXT | campaigns.name | campaigns.name |
| campaigns__templateid | TEXT | campaigns.templateId | campaigns.templateId |
| campaigns__type | TEXT | campaigns.type | campaigns.type |
Retently companies fields
The companies report of the Retently connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| companies__companyName | TEXT | companies.companyName | companies.companyName |
| companies__contactsCount | NUMERIC | companies.contactsCount | companies.contactsCount |
| companies__createdDate | TEXT | companies.createdDate | companies.createdDate |
| companies__cxMetrics | OBJECT | companies.cxMetrics | companies.cxMetrics |
| companies__domain | TEXT | companies.domain | companies.domain |
| companies__id | TEXT | companies.id | companies.id |
| companies__industryName | TEXT | companies.industryName | companies.industryName |
| companies__tags | OBJECT | companies.tags | companies.tags |
Retently customers fields
The customers report of the Retently connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| customers__companyId | TEXT | customers.companyId | customers.companyId |
| customers__companyName | TEXT | customers.companyName | customers.companyName |
| customers__createdDate | TEXT | customers.createdDate | customers.createdDate |
| customers__email | TEXT | customers.email | customers.email |
| customers__firstName | TEXT | customers.firstName | customers.firstName |
| customers__id | TEXT | customers.id | customers.id |
| customers__lastName | TEXT | customers.lastName | customers.lastName |
| customers__properties | OBJECT | customers.properties | customers.properties |
| customers__tags | OBJECT | customers.tags | customers.tags |
Retently feedback fields
The feedback report of the Retently connector includes 31 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| feedback__additionalQuestions | OBJECT | feedback.additionalQuestions | feedback.additionalQuestions |
| feedback__assigned | TEXT | feedback.assigned | feedback.assigned |
| feedback__campaignId | TEXT | feedback.campaignId | feedback.campaignId |
| feedback__campaignName | TEXT | feedback.campaignName | feedback.campaignName |
| feedback__channel | TEXT | feedback.channel | feedback.channel |
| feedback__checkbox | BOOLEAN | feedback.checkbox | feedback.checkbox |
| feedback__city | CITY | feedback.city | feedback.city |
| feedback__comment | TEXT | feedback.comment | feedback.comment |
| feedback__companyId | TEXT | feedback.companyId | feedback.companyId |
| feedback__companyName | TEXT | feedback.companyName | feedback.companyName |
| feedback__country | COUNTRY | feedback.country | feedback.country |
| feedback__createdDate | TEXT | feedback.createdDate | feedback.createdDate |
| feedback__customerId | TEXT | feedback.customerId | feedback.customerId |
| feedback__customProps | OBJECT | feedback.customProps | feedback.customProps |
| feedback__email | TEXT | feedback.email | feedback.email |
| feedback__feedbackTags | OBJECT | feedback.feedbackTags | feedback.feedbackTags |
| feedback__feedbackTagsNew | OBJECT | feedback.feedbackTagsNew | feedback.feedbackTagsNew |
| feedback__feedbackTopics | OBJECT | feedback.feedbackTopics | feedback.feedbackTopics |
| feedback__firstName | TEXT | feedback.firstName | feedback.firstName |
| feedback__id | TEXT | feedback.id | feedback.id |
| feedback__isBogus | BOOLEAN | feedback.isBogus | feedback.isBogus |
| feedback__jobTitle | TEXT | feedback.jobTitle | feedback.jobTitle |
| feedback__lastName | TEXT | feedback.lastName | feedback.lastName |
| feedback__metricsType | TEXT | feedback.metricsType | feedback.metricsType |
| feedback__notes | OBJECT | feedback.notes | feedback.notes |
| feedback__ratingCategory | TEXT | feedback.ratingCategory | feedback.ratingCategory |
| feedback__resolved | BOOLEAN | feedback.resolved | feedback.resolved |
| feedback__score | NUMERIC | feedback.score | feedback.score |
| feedback__state | TEXT | feedback.state | feedback.state |
| feedback__status | TEXT | feedback.status | feedback.status |
| feedback__tags | OBJECT | feedback.tags | feedback.tags |
Retently nps fields
The nps report of the Retently connector includes 10 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| nps__detractors | NUMERIC | nps.detractors | nps.detractors |
| nps__detractorsCount | NUMERIC | nps.detractorsCount | nps.detractorsCount |
| nps__metricsType | TEXT | nps.metricsType | nps.metricsType |
| nps__passives | NUMERIC | nps.passives | nps.passives |
| nps__passivesCount | NUMERIC | nps.passivesCount | nps.passivesCount |
| nps__promoters | NUMERIC | nps.promoters | nps.promoters |
| nps__promotersCount | NUMERIC | nps.promotersCount | nps.promotersCount |
| nps__score | NUMERIC | nps.score | nps.score |
| nps__scoreSum | NUMERIC | nps.scoreSum | nps.scoreSum |
| nps__totalResponses | NUMERIC | nps.totalResponses | nps.totalResponses |
Retently outbox fields
The outbox report of the Retently connector includes 19 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| outbox__additionalRecipients | OBJECT | outbox.additionalRecipients | outbox.additionalRecipients |
| outbox__attributes | OBJECT | outbox.attributes | outbox.attributes |
| outbox__campaign | TEXT | outbox.campaign | outbox.campaign |
| outbox__campaignId | TEXT | outbox.campaignId | outbox.campaignId |
| outbox__channel | TEXT | outbox.channel | outbox.channel |
| outbox__companyId | TEXT | outbox.companyId | outbox.companyId |
| outbox__companyName | TEXT | outbox.companyName | outbox.companyName |
| outbox__customerId | TEXT | outbox.customerId | outbox.customerId |
| outbox__detailedStatus | OBJECT | outbox.detailedStatus | outbox.detailedStatus |
| outbox__email | TEXT | outbox.email | outbox.email |
| outbox__firstName | TEXT | outbox.firstName | outbox.firstName |
| outbox__lastName | TEXT | outbox.lastName | outbox.lastName |
| outbox__mandrillMessageId | TEXT | outbox.mandrillMessageId | outbox.mandrillMessageId |
| outbox__personTags | OBJECT | outbox.personTags | outbox.personTags |
| outbox__sentBy | TEXT | outbox.sentBy | outbox.sentBy |
| outbox__sentDate | TEXT | outbox.sentDate | outbox.sentDate |
| outbox__status | TEXT | outbox.status | outbox.status |
| outbox__subject | TEXT | outbox.subject | outbox.subject |
| outbox__surveyTemplateId | TEXT | outbox.surveyTemplateId | outbox.surveyTemplateId |
Retently reports fields
The reports report of the Retently connector includes 5 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| reports__campaignId | TEXT | reports.campaignId | reports.campaignId |
| reports__deliveryStats | OBJECT | reports.deliveryStats | reports.deliveryStats |
| reports__last | OBJECT | reports.last | reports.last |
| reports__questionsStats | OBJECT | reports.questionsStats | reports.questionsStats |
| reports__trend | OBJECT | reports.trend | reports.trend |
Retently templates fields
The templates report of the Retently connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| templates__channel | TEXT | templates.channel | templates.channel |
| templates__id | TEXT | templates.id | templates.id |
| templates__metric | TEXT | templates.metric | templates.metric |
| templates__name | TEXT | templates.name | templates.name |
Retently other fields
The Retently connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |
