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:

• Reviews

• Customers

• Products

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
• Review Custom Data
• Custom Fields
• Customers
• Customer Top Topics
• Products

Reviews

• Endpoint: Reviews
• Update Method: UPSERT

• Table Name: [yotpo.reviews]

JSON Element	Database Column
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
email	email
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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