Yotpo Extractor Info

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

 Screen_Shot_2020-09-04_at_7.51.58_PM.png

 

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 

email 

email 

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

Was this article helpful?
0 out of 0 found this helpful