Yotpo Connector Reference

The Yotpo connector exposes 58 fields (5 metrics, 53 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Yotpo Fields

Yotpo email_analytics fields

The email_analytics report of the Yotpo connector includes 3 fields.

ID	Type	Name	Description
email_analytics__since	TEXT	email_analytics.since	email_analytics.since
email_analytics__until	TEXT	email_analytics.until	email_analytics.until
email_analytics__values	OBJECT	email_analytics.values	email_analytics.values

Yotpo raw_data fields

The raw_data report of the Yotpo connector includes 21 fields.

ID	Type	Name	Description
raw_data__arrived_early_timestamp	TEXT	raw_data.arrived_early_timestamp	raw_data.arrived_early_timestamp
raw_data__clicked_through_timestamp	TEXT	raw_data.clicked_through_timestamp	raw_data.clicked_through_timestamp
raw_data__content_creation_timestamp	TEXT	raw_data.content_creation_timestamp	raw_data.content_creation_timestamp
raw_data__coupon_code	TEXT	raw_data.coupon_code	raw_data.coupon_code
raw_data__email_address	TEXT	raw_data.email_address	raw_data.email_address
raw_data__email_sent_timestamp	TEXT	raw_data.email_sent_timestamp	raw_data.email_sent_timestamp
raw_data__email_type	TEXT	raw_data.email_type	raw_data.email_type
raw_data__failed_timestamp	TEXT	raw_data.failed_timestamp	raw_data.failed_timestamp
raw_data__invalid_address_timestamp	TEXT	raw_data.invalid_address_timestamp	raw_data.invalid_address_timestamp
raw_data__marked_spam_timestamp	TEXT	raw_data.marked_spam_timestamp	raw_data.marked_spam_timestamp
raw_data__opened_timestamp	TEXT	raw_data.opened_timestamp	raw_data.opened_timestamp
raw_data__order_id	TEXT	raw_data.order_id	raw_data.order_id
raw_data__order_timestamp	TEXT	raw_data.order_timestamp	raw_data.order_timestamp
raw_data__platform	TEXT	raw_data.platform	raw_data.platform
raw_data__product_id	TEXT	raw_data.product_id	raw_data.product_id
raw_data__reminder_num	NUMERIC	raw_data.reminder_num	raw_data.reminder_num
raw_data__review_type	TEXT	raw_data.review_type	raw_data.review_type
raw_data__sku	TEXT	raw_data.sku	raw_data.sku
raw_data__trr_bundle_id	TEXT	raw_data.trr_bundle_id	raw_data.trr_bundle_id
raw_data__trr_bundle_subject	TEXT	raw_data.trr_bundle_subject	raw_data.trr_bundle_subject
raw_data__unsubscribed_timestamp	TEXT	raw_data.unsubscribed_timestamp	raw_data.unsubscribed_timestamp

Yotpo reviews fields

The reviews report of the Yotpo connector includes 18 fields.

ID	Type	Name	Description
reviews__archived	BOOLEAN	reviews.archived	reviews.archived
reviews__content	TEXT	reviews.content	reviews.content
reviews__created_at	TIMESTAMP	reviews.created_at	reviews.created_at
reviews__deleted	BOOLEAN	reviews.deleted	reviews.deleted
reviews__email	TEXT	reviews.email	reviews.email
reviews__escalated	BOOLEAN	reviews.escalated	reviews.escalated
reviews__id	TEXT	reviews.id	reviews.id
reviews__incentive_type	TEXT	reviews.incentive_type	reviews.incentive_type
reviews__is_incentivized	BOOLEAN	reviews.is_incentivized	reviews.is_incentivized
reviews__name	TEXT	reviews.name	reviews.name
reviews__reviewer_type	TEXT	reviews.reviewer_type	reviews.reviewer_type
reviews__score	NUMERIC	reviews.score	reviews.score
reviews__sentiment	NUMERIC	reviews.sentiment	reviews.sentiment
reviews__sku	TEXT	reviews.sku	reviews.sku
reviews__title	TEXT	reviews.title	reviews.title
reviews__updated_at	TIMESTAMP	reviews.updated_at	reviews.updated_at
reviews__votes_down	NUMERIC	reviews.votes_down	reviews.votes_down
reviews__votes_up	NUMERIC	reviews.votes_up	reviews.votes_up

Yotpo unsubscribers fields

The unsubscribers report of the Yotpo connector includes 4 fields.

ID	Type	Name	Description
unsubscribers__email_type_id	TEXT	unsubscribers.email_type_id	unsubscribers.email_type_id
unsubscribers__id	TEXT	unsubscribers.id	unsubscribers.id
unsubscribers__unsubscribed_by_name	TEXT	unsubscribers.unsubscribed_by_name	unsubscribers.unsubscribed_by_name
unsubscribers__user_email	TEXT	unsubscribers.user_email	unsubscribers.user_email

Yotpo webhooks fields

The webhooks report of the Yotpo connector includes 5 fields.

ID	Type	Name	Description
webhooks__id	TEXT	webhooks.id	webhooks.id
webhooks__url	TEXT	webhooks.url	webhooks.url
webhooks__version	TEXT	webhooks.version	webhooks.version
webhooks__webhook_event_id	TEXT	webhooks.webhook_event_id	webhooks.webhook_event_id
webhooks__webhook_event_name	TEXT	webhooks.webhook_event_name	webhooks.webhook_event_name

Yotpo other fields

The Yotpo connector has 7 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
webhook_events__description	TEXT	webhook_events.description	webhook_events.description	webhook_events
webhook_events__name	TEXT	webhook_events.name	webhook_events.name	webhook_events