Drip is an email marketing automation software designed for ecommerce brands, helping online retailers convert leads into paying customers. Using Drip’s simple, user-friendly visual campaign builder, you can design email campaigns based on specific subscriber behavior to maximize sales and repeat purchases by the subscriber.
You can replicate the data from your Drip account to a Destination database or data warehouse using Hevo Pipelines. Hevo ingests the data objects in Full Load mode. Refer to section, Data Model for the list of supported objects.
Drip authenticates API requests from Hevo to access your account data with HTTP Basic authentication.
Prerequisites
Obtaining the Account ID and API Token
You require an account ID and an API token to authenticate Hevo on your Drip account.
Obtaining the Account ID
Perform the following steps to obtain your account ID:
-
Log in to your Drip account.
-
Copy the account ID from the URL path of the Drip dashboard, and save it securely like any other password. For example, if the URL path is https://www.getdrip.com/123456/dashboard, the account ID is 123456. Use this ID while configuring your Hevo Pipeline.
Obtaining the API Token
Perform the following steps to retrieve your API token:
-
Log in to your Drip account.
-
In the left navigation pane, click Settings, and then click User Settings.
-
In the User Info page, scroll down to find your API Token.
-
Copy the API token and save it securely like any other password. Use this token while configuring your Hevo Pipeline.
Configuring Drip as a Source
Perform the following steps to configure Drip as the Source in your Pipeline:
-
Click PIPELINES in the Navigation Bar.
-
Click + CREATE PIPELINE in the Pipelines List View.
-
In the Select Source Type page, select Drip.
-
In the Configure your Drip Source page, specify the following:
-
Pipeline Name: A unique name for your Pipeline, not exceeding 255 characters.
-
Account ID: The ID of the account from which data is to be ingested.
-
API Key: The API token for your Drip account, to enable Hevo to access your data.
Note: Each user in Drip has a unique API token.
-
Click TEST & CONTINUE.
-
Proceed to configuring the data ingestion and setting up the Destination.
Data Replication
For Teams Created |
Default Ingestion Frequency |
Minimum Ingestion Frequency |
Maximum Ingestion Frequency |
Custom Frequency Range (in Hrs) |
Before Release 2.21 |
1 Hr |
1 Hr |
24 Hrs |
1-24 |
After Release 2.21 |
6 Hrs |
30 Mins |
24 Hrs |
1-24 |
Note: The custom frequency must be set in hours as an integer value. For example, 1, 2, or 3 but not 1.5 or 1.75.
Hevo ingests all the objects in Full Load mode in each run of the Pipeline.
Schema and Primary Keys
Hevo uses the following schema to upload the records in the Destination database:
Data Model
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
Object |
Description |
Subscribers (People) |
Contains the details of your active and inactive subscribers. |
Single-Email Campaigns (Broadcasts) |
Contains the details of your email-series campaigns. An email series campaign is a set of predetermined emails triggered by certain customer actions to maximize their engagement. |
Email Series Campaigns (Campaigns) |
Contains the details of your email-series campaigns. An email series campaign is a set of predetermined emails triggered by certain customer actions to maximize their engagement. |
Forms |
Contains the details of all the forms in your Drip account. Forms are used to collect personal information about your website visitors such as their name and email address in return for a product, service, or free trial. For example, users can provide their name and email address to sign up for your newsletter. |
Conversions (Goals) |
Contains the details of the conversions recorded for your Drip account. |
Read the detailed Hevo documentation for the following related topics:
Source Considerations
-
Pagination: An API response for each Drip object fetches one page with up to 100 records, except the response for the Subscribers object, that can contain up to 1000 records per page.
-
Rate Limit: Drip imposes a limit of 3600 API calls per hour. If the limit is exceeded, Hevo defers the ingestion till the limits reset.
Limitations
-
Hevo currently does not support deletes. Therefore, any data deleted in the Source may continue to exist in the Destination.
-
The data is loaded in Full Load mode in each Pipeline run. As a result, you cannot load the historical data alone at any time.
-
Hevo does not load an Event into the Destination table if its size exceeds 128 MB, which may lead to discrepancies between your Source and Destination data. To avoid such a scenario, ensure that each row in your Source objects contains less than 100 MB of data.
Revision History
Refer to the following table for the list of key updates made to this page:
Date |
Release |
Description of Change |
Jan-07-2025 |
NA |
Updated the Limitations section to add information on Event size. |
Mar-05-2024 |
2.21 |
Updated the ingestion frequency table in the Data Replication section. |
Jun-21-2022 |
1.91 |
New document. |