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