Yotpo predefined reports

The Yotpo data source in Data Integration includes predefined reports. Each report contains a list of customizable fields (if any) and the schema mapping. Due to the standardized nature of these reports, there are locked fields that will only be accessible through the custom reporting feature.

All reviews

Field	Data Type	Dimension/Metric
id	Integer	Dimension
created_at	String	Dimension
content	String	Dimension
email	String	Dimension
deleted	Boolean	Dimension
name	String	Dimension
reviewer_type	String	Dimension
score	Integer	Metric
sentiment	Float	Metric
sku	String	Dimension
title	String	Dimension
updated_at	String	Dimension
user_reference	String	Dimension
votes_down	Integer	Metric
votes_up	Integer	Metric

Daily email analytics

Field	Data Type	Dimension/Metric
since_date	String	Dimension
answers_from_emails	Integer	Metric
click_throughs	Integer	Metric
date_aggregation_by	String	Dimension
email_type	String	Dimension
emails_failed	Integer	Metric
emails_opened	Integer	Metric
emails_sent	Integer	Metric
invalid_address	Integer	Metric
marked_spam	Integer	Metric
reviews_from_emails	Integer	Metric
arrived_early	Integer	Metric
unsubscribed	Integer	Metric
until_date	String	Dimension

Email analytics raw

Field	Data Type	Dimension/Metric
order_id	String	Dimension
arrived_early_timestamp	String	Dimension
content_creation_timestamp	String	Dimension
coupon_code	String	Dimension
email_address	String	Dimension
email_sent_timestamp	String	Dimension
email_type	String	Dimension
failed_timestamp	String	Dimension
invalid_address_timestamp	String	Dimension
marked_spam_timestamp	String	Dimension
opened_timestamp	String	Dimension
clicked_through_timestamp	String	Dimension
order_timestamp	String	Dimension
platform	String	Dimension
product_id	String	Dimension
reminder_num	Integer	Metric
review_form	String	Dimension
review_type	String	Dimension
sku	String	Dimension
trr_bundle_id	String	Dimension
trr_bundle_subject	String	Dimension
unsubscribed_timestamp	String	Dimension

Email unsubscribers

Field	Data Type	Dimension/Metric
id	Integer	Dimension
email_type_id	Integer	Dimension
unsubscirbed_by_name	String	Dimension
user_email	String	Dimension

Orders

Field	Data Type	Dimension/Metric
created_at	String	Dimension
order_id	String	Dimension
order_date	String	Dimension
order_line_id	Integer	Dimension
product_description	String	Dimension
product_id	Integer	Dimension
product_name	String	Dimension
product_sku	String	Dimension
product_url	String	Dimension
user_email	String	Dimension
user_name	String	Dimension

Product grouping

Field	Data Type	Dimension/Metric
created_at	String	Dimension
id	Integer	Dimension
account_id	Integer	Dimension
display_name	String	Dimension
products_apps	Record	Dimension
updated_at	String	Dimension

Products

Field	Data Type	Dimension/Metric
created_at	String	Dimension
id	Integer	Dimension
average_score	Float	Metric
category	Record	Dimension
description	String	Dimension
external_product_id	String	Dimension
blacklisted	Boolean	Dimension
images	Record	Dimension
name	String	Dimension
product_specs	Record	Dimension
total_reviews	Integer	Metric
updated_at	String	Dimension
url	String	Dimension

Review for specific products

Field	Data Type	Dimension/Metric
id	Integer	Dimension
created_at	String	Dimension
content	String	Dimension
custom_fields	Record	Dimension
product_domain_key	String	Dimension
product_embedded_widget_link	String	Dimension
product_id	Integer	Dimension
product_image_url	String	Dimension
product_link	String	Dimension
product_name	String	Dimension
product_social_links	Record	Dimension
product_testimonials_product_link	String	Dimension
score	Integer	Metric
sentiment	Float	Metric
source_review_id	String	Dimension
title	String	Dimension
user	Record	Dimension
verified_buyer	Boolean	Dimension
votes_down	Integer	Metric
votes_up	Integer	Metric