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

 Yotpo Extractor Info

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. 2021.