Delighted Connector Reference
9 metrics24 dimensions
The Delighted connector exposes 33 fields (9 metrics, 24 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Delighted Fields
Delighted bounces fields
The bounces report of the Delighted connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| bounces__bounced_at | NUMERIC | bounces.bounced_at | bounces.bounced_at |
| bounces__email | TEXT | bounces.email | bounces.email |
| bounces__name | TEXT | bounces.name | bounces.name |
| bounces__person_id | TEXT | bounces.person_id | bounces.person_id |
Delighted people fields
The people report of the Delighted connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| people__created_at | NUMERIC | people.created_at | people.created_at |
| people__email | TEXT | people.email | people.email |
| people__id | TEXT | people.id | people.id |
| people__last_responded_at | NUMERIC | people.last_responded_at | people.last_responded_at |
| people__last_sent_at | NUMERIC | people.last_sent_at | people.last_sent_at |
| people__name | TEXT | people.name | people.name |
| people__next_survey_scheduled_at | NUMERIC | people.next_survey_scheduled_at | people.next_survey_scheduled_at |
| people__phone_number | TEXT | people.phone_number | people.phone_number |
Delighted survey_responses fields
The survey_responses report of the Delighted connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| survey_responses__additional_answers | OBJECT | survey_responses.additional_answers | survey_responses.additional_answers |
| survey_responses__comment | TEXT | survey_responses.comment | survey_responses.comment |
| survey_responses__created_at | NUMERIC | survey_responses.created_at | survey_responses.created_at |
| survey_responses__id | TEXT | survey_responses.id | survey_responses.id |
| survey_responses__notes | OBJECT | survey_responses.notes | survey_responses.notes |
| survey_responses__permalink | TEXT | survey_responses.permalink | survey_responses.permalink |
| survey_responses__person | TEXT | survey_responses.person | survey_responses.person |
| survey_responses__person_properties | OBJECT | survey_responses.person_properties | survey_responses.person_properties |
| survey_responses__score | NUMERIC | survey_responses.score | survey_responses.score |
| survey_responses__survey_type | TEXT | survey_responses.survey_type | survey_responses.survey_type |
| survey_responses__tags | OBJECT | survey_responses.tags | survey_responses.tags |
| survey_responses__updated_at | NUMERIC | survey_responses.updated_at | survey_responses.updated_at |
Delighted unsubscribes fields
The unsubscribes report of the Delighted connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| unsubscribes__email | TEXT | unsubscribes.email | unsubscribes.email |
| unsubscribes__name | TEXT | unsubscribes.name | unsubscribes.name |
| unsubscribes__person_id | TEXT | unsubscribes.person_id | unsubscribes.person_id |
| unsubscribes__unsubscribed_at | NUMERIC | unsubscribes.unsubscribed_at | unsubscribes.unsubscribed_at |
Delighted other fields
The Delighted 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 |
