Yotpo Predefined Reports
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Yotpo Predefined Reports

  • Dark
    Light
  • PDF

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 system schema Integer Dimension
created_at system schema 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 system schema 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 system schema 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 system schema Integer Dimension
email_type_id Integer Dimension
unsubscirbed_by_name String Dimension
user_email String Dimension

Orders

Field Data Type Dimension/Metric
created_at system schema String Dimension
order_id system schema 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 system schema String Dimension
id system schema 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 system schema String Dimension
id system schema 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 system schema Integer Dimension
created_at system schema 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

Was this article helpful?