Yotpo Predefined Reports

Overview

The Yotpo datasource in Rivery comes with the below predefined reports. Each report will have a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

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