Connectors

/

Yotpo

Yotpo

Marketing Analytics

Sync Yotpo data anywhere.

Yotpo is a customer content marketing platform that helps businesses generate and leverage customer reviews, photos, and Q&A to increase sales and build brand loyalty. The platform offers a suite of tools that enable businesses to collect and showcase user-generated content across various channels, including their website, social media, and email marketing campaigns. Yotpo also provides advanced analytics and insights to help businesses understand their customers' behavior and preferences, as well as tools to engage with customers and respond to their feedback. Overall, Yotpo helps businesses create a more authentic and engaging customer experience that drives growth and customer loyalty.

  • Standard
  • Alpha
  • 6 streams
Sync Yotpo dataRead the docs
  • 6Streams
  • 50+Destinations
One connector

Everything Yotpo can do in Airbyte

  • Sync to your warehouse

    Land 6 Yotpo tables in 50+ destinations on a schedule you control.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • One authorization

    Authenticate Yotpo once and Airbyte keeps every scheduled sync running on it.

  • Cloud or self-hosted

    Run the Yotpo connector on Cloud, Self-Managed Enterprise.

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • NamespacesNot supported
  • Available onCloud, Self-Managed Enterprise
  • Destinations50+ Airbyte connectors
  • Connector version0.2.16

Set up in 15 steps

  1. First, navigate to the Yotpo source connector on Airbyte's website.
  2. Click on the ""Get Source"" button to download the connector.
  3. Once downloaded, extract the files from the zipped folder.
  4. Open the extracted folder and locate the ""config.json"" file.
  5. Open the ""config.json"" file and enter your Yotpo API credentials.
  6. Save the changes to the ""config.json"" file.
  7. Open a terminal or command prompt and navigate to the directory where the connector files are located.
  8. Run the command ""docker-compose up"" to start the connector.
  9. Once the connector is running, navigate to the Airbyte UI in your web browser.
  10. Click on ""Sources"" in the left-hand menu and then click ""New Source"".
  11. Select ""Yotpo"" from the list of available sources.
  12. Enter a name for the source and click ""Next"".
  13. Enter the connection details for your Yotpo account, including your API credentials.
  14. Test the connection to ensure that the source is properly connected.
  15. Once the connection is successful, save the source and begin syncing data from Yotpo to your destination.
6 streams

Every table you can sync from Yotpo

  • email_analytics

    Retrieves aggregated data for email metrics

  • raw_data

    Returns detailed data about every email sent from Yotpo

  • reviews

    Retrieves product reviews

  • unsubscribers

    Lists users who have unsubscribed from emails

  • webhooks

    Lists all webhooks created for the account

  • webhook_events

    Lists available webhook event types

Authentication

Authenticate Yotpo once

  • Access Token

    Access token recieved as a result of API call to https://api.yotpo.com/oauth/token (Ref- https://apidocs.yotpo.com/reference/yotpo-authentication)

FAQ

Common questions

What is ETL?

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

What data can you extract from Yotpo?

Yotpo's API provides access to a wide range of data related to customer reviews, ratings, and user-generated content. The following are the categories of data that can be accessed through Yotpo's API:

1. Reviews and Ratings: Yotpo's API provides access to all customer reviews and ratings for a particular product or service.

2. User-Generated Content: Yotpo's API allows access to user-generated content such as photos, videos, and social media posts related to a particular product or service.

3. Customer Data: Yotpo's API provides access to customer data such as name, email address, and location.

4. Analytics: Yotpo's API allows access to analytics data such as conversion rates, click-through rates, and engagement metrics.

5. Product Data: Yotpo's API provides access to product data such as product descriptions, pricing, and inventory levels.

6. Order Data: Yotpo's API allows access to order data such as order status, shipping information, and payment details.

7. Marketing Data: Yotpo's API provides access to marketing data such as campaign performance, email open rates, and click-through rates.

Overall, Yotpo's API provides a comprehensive set of data that can be used to gain insights into customer behavior, improve product offerings, and optimize marketing strategies.

How do I transfer data from Yotpo?

1. First, navigate to the Yotpo source connector on Airbyte's website.
2. Click on the ""Get Source"" button to download the connector.
3. Once downloaded, extract the files from the zipped folder.
4. Open the extracted folder and locate the ""config.json"" file.
5. Open the ""config.json"" file and enter your Yotpo API credentials.
6. Save the changes to the ""config.json"" file.
7. Open a terminal or command prompt and navigate to the directory where the connector files are located.
8. Run the command ""docker-compose up"" to start the connector.
9. Once the connector is running, navigate to the Airbyte UI in your web browser.
10. Click on ""Sources"" in the left-hand menu and then click ""New Source"".
11. Select ""Yotpo"" from the list of available sources.
12. Enter a name for the source and click ""Next"".
13. Enter the connection details for your Yotpo account, including your API credentials.
14. Test the connection to ensure that the source is properly connected.
15. Once the connection is successful, save the source and begin syncing data from Yotpo to your destination.

What are top ETL tools to transfer data from Yotpo?

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

What is ELT?

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

Difference between ETL and ELT?

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Explore
All connectors

Start moving Yotpo data today

Free for 14 days on Airbyte Cloud. Set up the Yotpo connector once and let Airbyte keep it in sync.

Try it freeTalk to sales