Yotpo V2

Yotpo ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v1, v3
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	Products
Questions	Collections
ReviewMetadata

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
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: Full-Based Replication

Replication Key: NA

Fields

Name	Target Datatype
id	NUMERIC
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
archived	BOOLEAN
escalated	BOOLEAN

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	NUMERIC
review_type	STRING
email_sent_timestamp	TIMESTAMP
opened_timestamp	TIMESTAMP
review_form	STRING
content_creation_timestamp	TIMESTAMP
platform	STRING
failed_timestamp	TIMESTAMP
invalid_address_timestamp	TIMESTAMP
coupon_code	STRING
clicked_through_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/retrieve-all-unique-coupon-codes

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: Retrieves a list of all of your store's products.

Source API Documentation: https://core-api.yotpo.com/v1.0/reference/retrieve-all-products

Replication: Full Based Replication

Replication Key: NA

Fields

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

ProductGroups

Purpose: Retrieve product groups for account

Source API Documentation: https://core-api.yotpo.com/v1.0/reference/retrieve-product-groups-for-account

Replication: Full Based Replication

Replication Key: NA

Fields

Name	Target Datatype
id	NUMERIC
display_name	STRING
account_id	NUMERIC

WidgetSiteReviews

Purpose: Retrieves all widget site reviews

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

Replication: Full-Based Replication

Replication Key: NA

Fields

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

UnSubscribers

Purpose: Retrieve a List of unsubscribers

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	NUMERIC
user_email	STRING
email_type_id	NUMERIC
unsubscribed_by_name	STRING

Products

Purpose: Retrieves a list of all of your store's products

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

Replication: Full-Based Replication

Replication Key: NA

Fields

Name	Target Datatype
yotpo_id	NUMERIC
external_id	STRING
name	STRING
description	STRING
status	STRING
url	STRING
is_valid_url	BOOLEAN
image_url	STRING
price	NUMERIC
compare_at_price	NUMERIC
currency	STRING
inventory_quantity	NUMERIC
is_discontinued	BOOLEAN
group_name	STRING
brand	STRING
sku	STRING
mpn	STRING
gtins	RECORD
custom_properties	RECORD
created_at	DATETIME
updated_at	DATETIME
store_id	STRING
is_valid_url_format	BOOLEAN
handle	STRING
external_created_at	DATETIME
external_updated_at	DATETIME

Questions

Purpose: Retrieve all Questions

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	NUMERIC
content	STRING
asker	RECORD
user_type	STRING
created_at	TIMESTAMP
archived	BOOLEAN
published	BOOLEAN
allow_sent	BOOLEAN
answers	RECORD
products_app	RECORD

Collections

Purpose: Retrieves a list of all store's collections.

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

Replication: Full-Based Replication

Replication Key: NA

Fields

NAME	TARGET DATATYPE
yotpo_id	NUMERIC
external_id	STRING
name	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP

ReviewMetadata

Purpose: Retrieve a review's order, customer, and product metadata

Source API Documentation: https://apidocs.yotpo.com/reference/get-review-metadata-by-review-id

Replication: Full-Based Replication

Replication Key: NA

Fields

NAME	TARGET DATATYPE
order	RECORD
customer	RECORD
product	RECORD