ActiveCampaign Source

Renta supports data export from ActiveCampaign to following destinations:

  • Google BigQuery
  • Clickhouse
  • SQL Server
  • Google Spreadsheets

Integration creating in data warehouse (DWH)

  1. Go to integrations catalog;
  2. Select ActiveCampaign;
  3. Add a ActiveCampaign account that has the necessary data;
  4. Choose the added ActiveCampaign account;
  5. Specify the destination you want to import the data into;
  6. Go to the settings screen and set necessary configuration:

Parameters

Parameters contains 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, numbers and “_” symbol.

Update time

You can specify any update time that you need. Users choose early morning integration updates most often, for example 5 AM.

In that case your integration will update in period from 5 AM to 6 AM.

Integrations are updating 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:

  1. Install the extension Renta Spreadsheets Add-on.
  2. Then go to Google Sheets and in the Tools tab select Renta
  3. 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

NameDescriptionType
idID of the campaign that was created.INTEGER
subscriberidID of the subcriberINTEGER
listidID of the list this contact bounced from.INTEGER
formidForm ID used for the campaign.INTEGER
seriesidID of the series that this campaign is associated with.INTEGER
sdateThe date when the campaign should be sent out (not used for campaign types 'responder', 'reminder'). Example: '2010-11-05 08:40:00'DATE
udateUnsubscribe date.DATE
statusThe status of the campaign. Example: 0 = draft, 1 = scheduledSTRING
responderResponder.STRING
syncSynchronization.STRING
unsubreasonTotal number of unsubscribe reasons provided for unsubscriptions for this campaign.STRING
unsubcampaignidCampaign sent when unsubscribed.INTEGER
unsubmessageidMessage sent when unsubscribed.INTEGER
first_nameFirst name of contact.STRING
last_nameLast name of contact.STRING
ip4_subIP address of subscriber.STRING
sourceidID of the source.INTEGER
sourceid_autosyncID of the source that provides auto sync.STRING
ip4_lastLast used users IP address.STRING
ip4_unsubUsers IP address while unsubscribing.STRING
listnameName of the list.STRING
lidLid.INTEGER
ip4Users IP address.DATE
a_unsub_timeExact time when user unsubscribed.STRING
a_unsub_dateExact date when user unsubscribed.DATE
cdateExact date when user subscribed.DATE
emailUsers email.STRING
phoneUsers phone number.STRING
orgidOrganization ID.INTEGER
orgnameName of the organization.STRING
segmentio_idID of the segmentio.INTEGER
bounced_hardBounced Hard.STRING
bounced_softBounced soft.STRING
bounced_dateBounced date.DATE
ipIP address.STRING
uaUA.STRING
hashUnique hash for the contact.STRING
socialdata_lastcheckLast check of social data.STRING
email_localLocal email.STRING
email_domainDomain email.STRING
sentcntNubmer of sent contacts.STRING
ratingRating.STRING
rating_tstampRating DateSTRING
gravatarGravatar.STRING
deletedDeleted.STRING
adateAdate.DATE
edateEdate.DATE
nameName.STRING
listslistList.STRING
bouncescntBounced contacts.STRING
tagsTags.STRING
Action_textText of action.STRING
Action_typeType of action.STRING
Action_tstampTstamp of action.STRING
Field_idID of the field.INTEGER
Field_titleTitle of the field.STRING
Field_descriptDescription of the field.STRING
Field_typeType of field.STRING
Field_isrequiredRequired field.STRING
Field_perstagField perstag.STRING
Field_defvalDefault value of the field.STRING
Field_show_in_listField in the list.STRING
Field_rowsRow of the field.STRING
Field_colsCols of the field.STRING
Field_visibleVisible field.STRING
Field_serviceService of the field.STRING
Field_ordernumOrder number of the field.STRING
Field_cdateDate when field was created.DATE
Field_udateDate when field was updated.DATE
Field_valValue of the field.DATE
Field_relidRelationship ID field.INTEGER
Field_dataidINTEGER
Field_elementElement of the field.STRING
Field_optionsOptions of the field.STRING
Field_selectedSelected field.STRING
Field_tagTag of the field.DATE
Option_nameName of the option.STRING
Option_valueValue of option.STRING
Option_isdefaultDefault option.STRING
Campaign_History_idID of campaign history.INTEGER
Campaign_History_campaignnameCampaign name of campaign_history.STRING
Campaign_History_sdateSdate of campaign history.DATE
Campaign_History_emailEmail of campaign history.STRING
Campaign_History_subscriberidSubscriber ID of the campaign history.INTEGER
Geo_idGeographic location ID.INTEGER
Geo_tstampGeographic location tstamp.STRING
Geo_ip4Geographic location of IP address.DATE
Geo_country2Geographic location of country.STRING
Geo_countryGeographic location of country.STRING
Geo_stateGeographic location of state.STRING
Geo_cityGeographic location of city.STRING
Geo_zipGeographic location of ZIP Code.DATE
Geo_areaGeographic location of area.STRING
Geo_latGeographic location of lat.DATE
Geo_lonGeographic location of lon.DATE
Geo_tzGeographic location of tz.STRING
Geo_tz_offsetGeographic location of offset tz.STRING
Geo_tstamp_agoGeographic location tstamp ago.STRING
Automation_history_nameAutomation history name.STRING
Automation_history_adddateAutomation history addate.DATE
Automation_history_idID of automation history.INTEGER

Quotes and limits

Important note: Renta doesn’t provide any restrictions like amount of accounts, connectors, integrations or inserting date range.

Limits for ActiveCampaign:

  • 5 requests per second per account.

Link to the official documentation