Yotpo

Yotpo ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v2
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Yotpo Client Id Yotpo Client Secret
Replication Type	Key based Replication Full Replication
Replication Key	DATE NA
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Overview	Reviews
RawData	DynamicCouponCodes
DynamicCouponCodeStatistics	AllProducts
ProductGroups	WidgetSiteReviews

UnSubscribers

Integrate Yotpo with Daton

1. Signin to Daton

2. Select Yotpo from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your yotpo client id and yotpo client secret.

5. After providing the details to authorize Daton to periodically extract data from Yotpo.

6. Post successful authentication you will be prompted to choose from the list of available tables

7. Then select all required fields for each table

8. Submit the integration.

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Yotpo Data

Overview

Purpose: View a summary of all metrics as an itemized list for a specified email type.Data can be segmented by email type and grouped by various metrics.

Source API Documentation https://apidocs.yotpo.com/reference#summary

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
email_type	STRING
start_date	DATE
end_date	DATE
answers_from_emails	NUMERIC
arrived_early	NUMERIC
click_throughs	NUMERIC
emails_failed	NUMERIC
emails_opened	NUMERIC
emails_sent	NUMERIC
invalid_address	NUMERIC
marked_spam	NUMERIC
reviews_from_emails	NUMERIC
unsubscribed	NUMERIC

Reviews

Purpose:Reviews are the core content generated using Yotpo. Yotpo helps generating reviews which can then later be displayed on the store's site and published on social networks.

Source API Documentation https://apidocs.yotpo.com/reference#retrieve-all-reviews

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	INTEGER
title	STRING
content	STRING
score	NUMERIC
votes_up	NUMERIC
votes_down	NUMERIC
created_at	TIMESTAMP
updated_at	TIMESTAMP
sentiment	NUMERIC
sku	STRING
name	STRING
email	STRING
reviewer_type	STRING
deleted	BOOLEAN
user_reference	STRING

RawData

Purpose: Use this request to return detailed data about every email sent from Yotpo including the email recipient, when the email was received, order information, delivery success or failure, when the email was opened, clicks, unsubscribe, etc.

Source API Documentation https://apidocs.yotpo.com/reference#raw-data

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
email_address	STRING
order_id	STRING
order_timestamp	TIMESTAMP
product_id	STRING
sku	STRING
email_type	STRING
reminder_num	STRING
trr_bundle_id	STRING
trr_bundle_subject	STRING
review_type	STRING
coupon_code	STRING
email_sent_timestamp	TIMESTAMP
opened_timestamp	TIMESTAMP
clicked_through_timestamp	TIMESTAMP
content_creation_timestamp	TIMESTAMP
review_form	STRING
platform	STRING
invalid_address_timestamp	TIMESTAMP
failed_timestamp	TIMESTAMP
unsubscribed_timestamp	TIMESTAMP
marked_spam_timestamp	TIMESTAMP
arrived_early_timestamp	TIMESTAMP

DynamicCouponCodes

Purpose: Retrieves all Coupons created in yotpo System.

Source API Documentation https://apidocs.yotpo.com/reference#introduction-to-coupons

Replication: Full based Replication

Replication Key: NA

Fields

Name	Target Datatype
code	STRING

DynamicCouponCodeStatistics

Purpose: Retrieves all Coupons with statistics created in yotpo System.

Source API Documentation https://apidocs.yotpo.com/reference#retrieve-unique-code-statistics

Replication: Full Based Replication

Replication Key: NA

Fields

Name	Target Datatype
map_review	NUMERIC
map_review_share	NUMERIC

AllProducts

Purpose: Use this endpoint to retrieves a list of all of your store's products.

Source API Documentation https://apidocs.yotpo.com/reference#retrieve-all-products

Replication: Full Based Replication

Replication Key: NA

Fields

Name	Target Datatype
id	NUMERIC
created_at	TIMESTAMP
updated_at	TIMESTAMP
blacklisted	BOOLEAN
average_score	NUMERIC
total_reviews	NUMERIC
url	STRING
external_product_id	INTEGER
name	STRING
description	STRING
product_specs	RECORD
category	RECORD
images	RECORD

ProductGroups

Purpose: Retrieve product groups for account

Source API Documentation https://apidocs.yotpo.com/reference#retrieve-product-groups-for-account

Replication: Full Based Replication

Replication Key: NA

Fields

Name	Target Datatype
id	INTEGER
display_name	STRING
account_id	INTEGER

WidgetSiteReviews

Purpose: Retrieves all widget site reviews for yotpo system.

Source API Documentation https://apidocs.yotpo.com/reference#retrieve-widget-site-reviews

Replication: Full-Based Replication

Replication Key: NA

Fields

Name	Target Datatype
id	INTEGER
score	NUMERIC
votes_up	NUMERIC
votes_down	NUMERIC
content	STRING
title	STRING
sentiment	NUMERIC
created_at	TIMESTAMP
verified_buyer	BOOLEAN
product_id	INTEGER
user	RECORD

UnSubscribers

Purpose: Retrieve a List of unsubscribers for yotpo system.

Source API Documentation https://apidocs.yotpo.com/reference#retrieve-a-list-of-unsubscribers

Replication: Full-Based Replication

Replication Key: NA

Fields

Name	Target Datatype
id	INTEGER
user_email	STRING
email_type_id	NUMERIC
unsubscribed_by_name	STRING