Retently Connector Reference

11 metrics87 dimensions

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 TIMESTAMP 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 TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date