Integration overview
Yotpo is primarily used as a product review platform, allowing customers to review products they purchase from a store. Yotpo also provides a “sentiment” score by crawling the review text and scoring it with a score of 1% - 100%, with 100% being the best reviews and 1% the worst.
The Daasity<>Yotpo Integration makes review information by SKU available to users for analysis of top and bottom performing products from their customers' point of view and by sales. This rich qualitative data can help guide merchandising and product development decisions, as well as marketing.
This integration is available for:
- Growth
- Pro V1 & V2 (Merchants with their own dedicated Looker instance)
ERD
ENDPOINTS
Retrieve All Reviews | https://apidocs.yotpo.com/reference#retrieve-all-reviews |
Retrieve Orders from the Yotpo System | https://apidocs.yotpo.com/reference#retrieve-orders-from-the-yotpo-system |
RETRIEVE ALL REVIEWS
JSON Element |
Database Colum |
id |
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 |
Incremental data extraction
Use the since_updated_at for earliest update date of returned reviews.
Historical data extraction
Use since_date to extract history to get earliest creation date of returned reviews.
Sync Key - to prevent duplicate data entries
MD5(id:__source_id)
RETRIEVE ALL ORDERS
JSON Element |
Database Colum |
Order_id |
Order_id |
Order_line_id |
Order_line_id |
Order_date |
Order_date |
Product_id |
Product_id |
User_email |
User_email |
User_name |
User_name |
Product_name |
Product_name |
Product_sku |
Product_sku |
Product_url |
Product_url |
Product_description |
Product_description |
Created_at |
Created_at |
__Source_id |
Unique id (entered by customer) during integration setup |
Incremental data extraction
Use since_date filter to get only records that have been created_at after date parameter.
Sync Key - to prevent duplicate data entries
MD5(order_id:order_line_id:order_date:created_at:__source_id)
All contents copyright of Daasity, Inc. 2020