ActiveCampaign Source
Renta supports data export from ActiveCampaign to the following destinations:
Snowflake
Google BigQuery
Amazon S3
Clickhouse
SQL Server
Google Spreadsheets
Integration creating in data warehouse (DWH)
Go to the integrations catalog;
Select ActiveCampaign;
Add an ActiveCampaign account that has the necessary data;
Choose the added ActiveCampaign account;
Specify the destination you want to import the data into;
Go to the settings screen and set the necessary configuration:
Parameters
Parameters contain the list of parameters and metrics available for export. Specify the parameters required for uploading.
As a result, Renta will create the table that will contain the selected parameters data. The order of the selected parameters in the Rentas interface will match to the order of the table columns.
Integration name
There is an auto-generated name for your integration and here you can edit it as much as you like.
Both Cyrillic and Latin are permitted, but not more than 100 symbols.
The integration name is displayed on the Integration List page.
Table name
There is an auto-generated name for your table and here you can edit it as much as you like.
Only Latin is permitted, with numbers and “_” symbol.
Update time
You can specify any updated time that you need. Users choose early morning integration updates most often, for example 5 AM.
In that case, your integration will update in the period from 5 AM to 6 AM.
Integrations are updated according to the time zone selected in your profile settings.
Integration creating in Google Spreadsheets
Take advantage of the free extension available in the Google Workspace Marketplace. In order to do it:
Install the extension Renta Spreadsheets Add-on.
Then go to Google Sheets and in the Tools tab select Renta
Press the Run button.
After that, a workspace with integration settings will open in the right sidebar. Detailed instructions for creating an integration are available at this link. Please note that all integrations created in Google Spreadsheets are also available for management in the web version of Renta.
Data Structure
Name | Description | Type |
---|---|---|
id | ID of the campaign that was created. | INTEGER |
subscriberid | ID of the subcriber | INTEGER |
listid | ID of the list this contact bounced from. | INTEGER |
formid | Form ID used for the campaign. | INTEGER |
seriesid | ID of the series that this campaign is associated with. | INTEGER |
sdate | The date when the campaign should be sent out (not used for campaign types 'responder', 'reminder'). Example: '2010-11-05 08:40:00' | DATE |
udate | Unsubscribe date. | DATE |
status | The status of the campaign. Example: 0 = draft, 1 = scheduled | STRING |
responder | Responder. | STRING |
sync | Synchronization. | STRING |
unsubreason | Total number of unsubscribe reasons provided for unsubscriptions for this campaign. | STRING |
unsubcampaignid | Campaign sent when unsubscribed. | INTEGER |
unsubmessageid | Message sent when unsubscribed. | INTEGER |
first_name | First name of contact. | STRING |
last_name | Last name of contact. | STRING |
ip4_sub | IP address of subscriber. | STRING |
sourceid | ID of the source. | INTEGER |
sourceid_autosync | ID of the source that provides auto sync. | STRING |
ip4_last | Last used users IP address. | STRING |
ip4_unsub | Users IP address while unsubscribing. | STRING |
listname | Name of the list. | STRING |
lid | Lid. | INTEGER |
ip4 | Users IP address. | DATE |
a_unsub_time | Exact time when user unsubscribed. | STRING |
a_unsub_date | Exact date when user unsubscribed. | DATE |
cdate | Exact date when user subscribed. | DATE |
Users email. | STRING | |
phone | Users phone number. | STRING |
orgid | Organization ID. | INTEGER |
orgname | Name of the organization. | STRING |
segmentio_id | ID of the segmentio. | INTEGER |
bounced_hard | Bounced Hard. | STRING |
bounced_soft | Bounced soft. | STRING |
bounced_date | Bounced date. | DATE |
ip | IP address. | STRING |
ua | UA. | STRING |
hash | Unique hash for the contact. | STRING |
socialdata_lastcheck | Last check of social data. | STRING |
email_local | Local email. | STRING |
email_domain | Domain email. | STRING |
sentcnt | Nubmer of sent contacts. | STRING |
rating | Rating. | STRING |
rating_tstamp | Rating Date | STRING |
gravatar | Gravatar. | STRING |
deleted | Deleted. | STRING |
adate | Adate. | DATE |
edate | Edate. | DATE |
name | Name. | STRING |
listslist | List. | STRING |
bouncescnt | Bounced contacts. | STRING |
tags | Tags. | STRING |
Action_text | Text of action. | STRING |
Action_type | Type of action. | STRING |
Action_tstamp | Tstamp of action | STRING |
Field_id | ID of the field. | INTEGER |
Field_title | Title of the field. | STRING |
Field_descript | Description of the field. | STRING |
Field_type | Type of field. | STRING |
Field_isrequired | Required field. | STRING |
Field_perstag | Field perstag. | STRING |
Field_defval | Default value of the field. | STRING |
Field_show_in_list | Field in the list. | STRING |
Field_rows | Row of the field. | STRING |
Field_cols | Cols of the field. | STRING |
Field_visible | Visible field. | STRING |
Field_service | Service of the field. | STRING |
Field_ordernum | Order number of the field. | STRING |
Field_cdate | Date when field was created. | DATE |
Field_udate | Date when field was updated. | DATE |
Field_val | Value of the field. | DATE |
Field_relid | Relationship ID field. | INTEGER |
Field_dataid | INTEGER | |
Field_element | Element of the field. | STRING |
Field_options | Options of the field. | STRING |
Field_selected | Selected field. | STRING |
Field_tag | Tag of the field. | DATE |
Option_name | Name of the option. | STRING |
Option_value | Value of option. | STRING |
Option_isdefault | Default option. | STRING |
Campaign_History_id | ID of campaign history. | INTEGER |
Campaign_History_campaignname | Campaign name of campaign_history. | STRING |
Campaign_History_sdate | Sdate of campaign history. | DATE |
Campaign_History_email | Email of campaign history. | STRING |
Campaign_History_subscriberid | Subscriber ID of the campaign history. | INTEGER |
Geo_id | Geographic location ID. | INTEGER |
Geo_tstamp | Geographic location tstamp. | STRING |
Geo_ip4 | Geographic location of IP address. | DATE |
Geo_country2 | Geographic location of country. | STRING |
Geo_country | Geographic location of country. | STRING |
Geo_state | Geographic location of state. | STRING |
Geo_city | Geographic location of city. | STRING |
Geo_zip | Geographic location of ZIP Code. | DATE |
Geo_area | Geographic location of area. | STRING |
Geo_lat | Geographic location of lat. | DATE |
Geo_lon | Geographic location of lon. | DATE |
Geo_tz | Geographic location of tz. | STRING |
Geo_tz_offset | Geographic location of offset tz. | STRING |
Geo_tstamp_ago | Geographic location tstamp ago. | STRING |
Automation_history_name | Automation history name. | STRING |
Automation_history_adddate | Automation history addate. | DATE |
Automation_history_id | ID of automation history. | INTEGER |