Integration Specifications
This article will help you learn about how Daasity replicates data from Yotpo, limitations to the data we can extract and where the data is stored in the Yotpo schema.
Integration Overview
Yotpo is an eCommerce retention marketing platform that drives repeat shopper sales with connected solutions for reviews, SMS, email, loyalty, and subscriptions.
This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.
Integration Availability
This integration is available for:
Enterprise
Growth
API Endpoints
The Daasity Yotpo extractor is built based on this Yotpo API documentation. The following endpoints are used by Daasity to replicate data from Yotpo:
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Yotpo integration illustrating the different tables and keys to join across tables.
Yotpo Schema
The Daasity Yotpo extractor creates these tables using the endpoints and replication methods listed. The data is mapped from the source API endpoint to the table based on the mapping logic outlined in each table.
Reviews
Endpoint: Reviews
Update Method: UPSERT
Table Name: [
yotpo.reviews]
id
review_id
title
title
content
content
score
score
votes_up
votes_up
votes_down
votes_down
created_at
created_at
updated_at
updated_at
sentiment
sentiment
sku
sku
name
name
reviewer_type
reviewer_type
deleted
deleted
user_reference
user_reference
__source_id
Unique id (entered by customer) during integration setup
MD5(id:__source_id)
__sync_key
Reviews Custom Data
Endpoint: Reviews
Update Method: UPSERT
Table Name: [
yotpo.review_custom_data]
id
review_id
cf_id
custom_field_id
MD5(id + cf_id + app_key)
__sync_key
Custom Fields
Endpoint: Reviews
Update Method: UPSERT
Table Name: [
yotpo.custom_fields]
cf_id
custom_field_id
cf_dat::title
title
cf_data::value
value
cf_data::field_type
field_type
cf_data::form_id
form_id
MD5(cf_id + app_key)
__sync_key
Customers
Endpoint: Customers
Update Method: UPSERT
Table Name: [
yotpo.customers]
customer::customer_email
customer_email
reviews_statistics::total_reviews
reviews_statistics_total_reviews
reviews_statistics::avg_product_rating
reviews_statistics_avg_product_rating
reviews_statistics::avg_site_rating
reviews_statistics_avg_site_rating
reviews_statistics::total_avg_rating
reviews_statistics_total_avg_rating
reviews_statistics::sentiment_avg_product
reviews_statistics_sentiment_avg_product
reviews_statistics::sentiment_avg_site
reviews_statistics_sentiment_avg_site
reviews_statistics::total_avg_sentiment
reviews_statistics_total_avg_sentiment
loyalty_statistics::points_earned
loyalty_statistics_points_earned
loyalty_statistics::point_balance
loyalty_statistics_point_balance
loyalty_statistics::total_redemptions
loyalty_statistics_total_redemptions
loyalty_statistics::total_points_redeemed
loyalty_statistics_total_points_redeemed
loyalty_statistics::vip_tier_name
loyalty_statistics_vip_tier_name
loyalty_statistics::successfull_referales
loyalty_statistics_successfull_referales
loyalty_statistics::referrales_made_and_clicked
loyalty_statistics_referrales_made_and_clicked
loyalty_statistics::is_referred_by_other_customer
loyalty_statistics_is_referred_by_other_customer
MD5(customer::customer_email + app_key)
__sync_key
Customer Top Topics
Endpoint: Customers
Update Method: UPSERT
Table Name: [
yotpo.customer_top_topics]
customer::customer_email
customer_email
top_topic
review_statistics_top_topic
MD5(customer::customer_email + top_topic + app_key
__sync_key
Products
Endpoint: Products
Update Method: UPSERT
Table Name: [
yotpo.products]
id
product_id
external_product_id
external_product_id
description
description
url
url
name
name
category::id
category_id
category::name
category_name
average_score
average_score
total_reviews
total_reviews
created_at
created_at
updated_at
updated_at
MD5(id + app_key)
__sync_key
Was this helpful?