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

Yotpo Predefined Reports

  • Dark
    Light
  • PDF

Article summary

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

FieldData TypeDimension/Metric
id system schemaIntegerDimension
created_at system schemaStringDimension
contentStringDimension
emailStringDimension
deletedBooleanDimension
nameStringDimension
reviewer_typeStringDimension
scoreIntegerMetric
sentimentFloatMetric
skuStringDimension
titleStringDimension
updated_atStringDimension
user_referenceStringDimension
votes_downIntegerMetric
votes_upIntegerMetric

Daily Email Analytics

FieldData TypeDimension/Metric
since_date system schemaStringDimension
answers_from_emailsIntegerMetric
click_throughsIntegerMetric
date_aggregation_byStringDimension
email_typeStringDimension
emails_failedIntegerMetric
emails_openedIntegerMetric
emails_sentIntegerMetric
invalid_addressIntegerMetric
marked_spamIntegerMetric
reviews_from_emailsIntegerMetric
arrived_earlyIntegerMetric
unsubscribedIntegerMetric
until_dateStringDimension

Email Analytics Raw

FieldData TypeDimension/Metric
order_id system schemaStringDimension
arrived_early_timestampStringDimension
content_creation_timestampStringDimension
coupon_codeStringDimension
email_addressStringDimension
email_sent_timestampStringDimension
email_typeStringDimension
failed_timestampStringDimension
invalid_address_timestampStringDimension
marked_spam_timestampStringDimension
opened_timestampStringDimension
clicked_through_timestampStringDimension
order_timestampStringDimension
platformStringDimension
product_idStringDimension
reminder_numIntegerMetric
review_formStringDimension
review_typeStringDimension
skuStringDimension
trr_bundle_idStringDimension
trr_bundle_subjectStringDimension
unsubscribed_timestampStringDimension

Email Unsubscribers

FieldData TypeDimension/Metric
id system schemaIntegerDimension
email_type_idIntegerDimension
unsubscirbed_by_nameStringDimension
user_emailStringDimension

Orders

FieldData TypeDimension/Metric
created_at system schemaStringDimension
order_id system schemaStringDimension
order_dateStringDimension
order_line_idIntegerDimension
product_descriptionStringDimension
product_idIntegerDimension
product_nameStringDimension
product_skuStringDimension
product_urlStringDimension
user_emailStringDimension
user_nameStringDimension

Product Grouping

FieldData TypeDimension/Metric
created_at system schemaStringDimension
id system schemaIntegerDimension
account_idIntegerDimension
display_nameStringDimension
products_appsRecordDimension
updated_atStringDimension

Products

FieldData TypeDimension/Metric
created_at system schemaStringDimension
id system schemaIntegerDimension
average_scoreFloatMetric
categoryRecordDimension
descriptionStringDimension
external_product_idStringDimension
blacklistedBooleanDimension
imagesRecordDimension
nameStringDimension
product_specsRecordDimension
total_reviewsIntegerMetric
updated_atStringDimension
urlStringDimension

Review For Specific Products

FieldData TypeDimension/Metric
id system schemaIntegerDimension
created_at system schemaStringDimension
contentStringDimension
custom_fieldsRecordDimension
product_domain_keyStringDimension
product_embedded_widget_linkStringDimension
product_idIntegerDimension
product_image_urlStringDimension
product_linkStringDimension
product_nameStringDimension
product_social_linksRecordDimension
product_testimonials_product_linkStringDimension
scoreIntegerMetric
sentimentFloatMetric
source_review_idStringDimension
titleStringDimension
userRecordDimension
verified_buyerBooleanDimension
votes_downIntegerMetric
votes_upIntegerMetric

Was this article helpful?