+
Stream marketing data from ActiveCampaign to Snowflake
About ActiveCampaign
About SnowFlake
Connect ActiveCampaign to Snowflake in 2023
It is very simple to connect ActiveCampaign to Snowflake, it can be done in a fast and easy manner with Windsor.ai.
First Step
Follow the Tutorial Below:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
- Get the username
- Get the password
- Get the account
- Get the warehouse
- Get the database
- Get the schema
- Get the table name
Second step
1.You need to select ActiveCampaign as a Data Source and Grant Access to Windsor.ai.
2. In Select Destination select Snowflake as destination
3. Enter all the credentials required and click Save
4. Your data will now be streamed from ActiveCampaign to Snowflake. In case there is an error you will be notified.
ActiveCampaign metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Address address1 | TEXT | Address address1 |
| Address address2 | TEXT | Address address2 |
| Address allgroup | TEXT | Address allgroup |
| Address city | CITY | Address city |
| Address company name | TEXT | Address company name |
| Address country | COUNTRY | Address country |
| Address district | TEXT | Address district |
| Address ID | TEXT | Address ID |
| Address is default flag | TEXT | Address is default flag |
| Address state | TEXT | Address state |
| Address zip | TEXT | Address zip |
| Automation cdate | DATE | Automation creation date |
| Automation default screenshot | TEXT | Automation default screenshot |
| Automation entered | TEXT | Automation entered |
| Automation exited | TEXT | Automation exited |
| TEXT | Automation hidden | |
| Automation ID | TEXT | Automation ID |
| Automation mdate | DATE | Automation modification date |
| Automation name | TEXT | Automation name |
| Automation screenshot | TEXT | Automation screenshot |
| Automation status | TEXT | Automation status |
| Automation user ID | TEXT | Automation user ID |
| Campaign name | TEXT | Campaign name |
| Campaign activerss interval | TEXT | Campaign activerss interval |
| Campaign activerss items | TEXT | Campaign activerss items |
| Campaign activerss URL | TEXT | Campaign activerss URL |
| Campaign address ID | TEXT | Campaign address ID |
| Campaign analytics_campaign_name | TEXT | Campaign analytics_campaign_name |
| Campaign automation | TEXT | Campaign automation |
| Campaign base message ID | TEXT | Campaign base message ID |
| Campaign basetemplate ID | TEXT | Campaign basetemplate ID |
| Campaign bounce ID | TEXT | Campaign bounce ID |
| Campaign creation date | DATE | Campaign creation date |
| Campaign deletestamp | TEXT | Campaign deletestamp |
| Campaign embed_images | TEXT | Campaign embed_images |
| Campaign facebook | TEXT | Campaign facebook |
| Campaign form ID | TEXT | Campaign form ID |
| Campaign forwards | NUMERIC | Campaign forwards |
| Campaign hard bounces | NUMERIC | Campaign hard bounces |
| Campaign html unsub | NUMERIC | Campaign html unsub |
| Campaign html unsub data | TEXT | Campaign html unsub data |
| Campaign ID | TEXT | Campaign ID |
| Campaign ip4 | TEXT | Campaign ip4 |
| Campaign last step | TEXT | Campaign last step |
| Campaign date last sent to contact | DATE | Date the campaign last sent to a contact |
| Campaign link clicks | NUMERIC | Campaign link clicks |
| Campaign mail_cleanup | TEXT | Campaign mail_cleanup |
| Campaign mail_send | TEXT | Campaign mail_send |
| Campaign mail transfer | TEXT | Campaign mail transfer |
| Campaign mailer_log_file | TEXT | Campaign mailer_log_file |
| Campaign manage text | TEXT | Campaign manage text |
| Campaign modification date | DATE | Campaign modification date |
| Campaign opens | NUMERIC | Campaign opens |
| Campaign public | TEXT | Campaign public |
| Campaign realcid | TEXT | Campaign realcid |
| Campaign recurring | TEXT | Campaign recurring |
| Campaign reminder field | TEXT | Campaign reminder field |
| Campaign reminder format | TEXT | Campaign reminder format |
| Campaign reminder last cron run | TEXT | Campaign reminder last cron run |
| Campaign reminder offset | TEXT | Campaign reminder offset |
| Campaign reminder offset sign | TEXT | Campaign reminder offset sign |
| Campaign reminder offset type | TEXT | Campaign reminder offset type |
| Campaign reminder type | TEXT | Campaign reminder type |
| Campaign replies | NUMERIC | Campaign replies |
| Campaign replysys | TEXT | Campaign replysys |
| Campaign responder existing | TEXT | Campaign responder existing |
| Campaign responder offset | TEXT | Campaign responder offset |
| Campaign responder type | TEXT | Campaign responder type |
| Campaign schedule | TEXT | Campaign schedule |
| Campaign scheduled date | DATE | Campaign scheduled date |
| Campaign start sending date | DATE | Date the campaign started sending |
| Campaign segment ID | TEXT | Campaign segment ID |
| Campaign total contacts sent | NUMERIC | Total amount of contacts actually sent this campaign |
| Campaign send ID | TEXT | Campaign send ID |
| Campaign series ID | TEXT | Campaign series ID |
| Campaign social shares | NUMERIC | Campaign social shares |
| Campaign soft bounces | NUMERIC | Campaign soft bounces |
| Campaign source | TEXT | Campaign source |
| Campaign split content | TEXT | Campaign split content |
| Campaign split offset | TEXT | Campaign split offset |
| Campaign split offset type | TEXT | Campaign split offset type |
| Campaign split type | TEXT | Campaign split type |
| Campaign split winner awaiting | TEXT | Campaign split winner awaiting |
| Campaign split winner message ID | TEXT | Campaign split winner message ID |
| Campaign status | TEXT | Campaign status |
| Campaign subscriber clicks | NUMERIC | Campaign subscriber clicks |
| Campaign survey | TEXT | Campaign survey |
| Campaign text unsub | NUMERIC | Campaign text unsub |
| Campaign text unsub data | TEXT | Campaign text unsub data |
| Campaign thread ID | TEXT | Campaign thread ID |
| Campaign determined total contacts | NUMERIC | Total amount of contacts determined to receive this campaign |
| Campaign track links | TEXT | Campaign track links |
| Campaign track links analytics | TEXT | Campaign track links analytics |
| Campaign track reads | TEXT | Campaign track reads |
| Campaign track reads analytics | TEXT | Campaign track reads analytics |
| Campaign tweet | TEXT | Campaign tweet |
| ActiveCampaign campaign type | TEXT | ActiveCampaign campaign type |
| Campaign unique forwards | NUMERIC | Campaign unique forwards |
| Campaign unique link clicks | NUMERIC | Campaign unique link clicks |
| Campaign unique opens | NUMERIC | Campaign unique opens |
| Campaign unique replies | NUMERIC | Campaign unique replies |
| Campaign unsub reasons | NUMERIC | Campaign unsub reasons |
| Campaign unsubscribes | NUMERIC | Campaign unsubscribes |
| Campaign updates | DATE | Campaign updates |
| Campaign user | TEXT | Campaign user |
| Campaign user ID | TEXT | Campaign user ID |
| Campaign waitpreview | TEXT | Campaign waitpreview |
| Campaign willrecur | TEXT | Campaign willrecur |
| Contact adate | DATE | Contact adate |
| Contact bounced date | DATE | Contact bounced date |
| Contact bounced hard | TEXT | Contact bounced hard |
| Contact bounced soft | TEXT | Contact bounced soft |
| Contact cdate | DATE | Contact creation date |
| Contact deleted | TEXT | Contact deleted |
| Contact edate | DATE | Contact edate |
| Contact email | TEXT | Contact email |
| Contact email domain | TEXT | Contact email domain |
| Contact email local | TEXT | Contact email local |
| Contact first name | TEXT | Contact first name |
| Contact gravatar | TEXT | Contact gravatar |
| Contact hash | TEXT | Contact hash |
| Contact ID | TEXT | Contact ID |
| Contact ip | TEXT | Contact ip |
| Contact last name | TEXT | Contact last name |
| Contact organization | TEXT | Contact organization |
| Contact orgid | TEXT | Contact orgid |
| Contact phone | TEXT | Contact phone |
| Contact rating_tstamp | TEXT | Contact rating_tstamp |
| Contact segmentio_id | TEXT | Contact segmentio_id |
| Contact sentcnt | NUMERIC | Contact sentcnt |
| Contact socialdata_lastcheck | TEXT | Contact socialdata_lastcheck |
| Contact ua | TEXT | Contact ua |
| Contact udate | DATE | Contact update date |
| Deal account | TEXT | Deal account |
| Deal activity count | NUMERIC | Deal activity count |
| Deal cdate | DATE | Deal creation date |
| Deal contact | TEXT | Deal contact |
| Deal currency | TEXT | Deal currency |
| Deal customer account | TEXT | Deal customer account |
| Deal description | TEXT | Deal description |
| Deal edate | DATE | Deal edate |
| Deal group | TEXT | Deal group |
| Deal ID | TEXT | Deal ID |
| Deal mdate | DATE | Deal modification date |
| Deal next date | DATE | Deal next date |
| Deal next deal ID | TEXT | Deal next deal ID |
| Deal next task ID | TEXT | Deal next task ID |
| Deal organization | TEXT | Deal organization |
| Deal owner | TEXT | Deal owner |
| Deal percent | PERCENT | Deal percent |
| Deal stage | TEXT | Deal stage |
| Deal status | TEXT | Deal status |
| Deal task assignee | TEXT | Deal task assignee |
| Deal task automation | TEXT | Deal task automation |
| Deal task cdate | DATE | Deal task creation date |
| Deal task type | TEXT | Deal task type |
| Deal task done automation | TEXT | Deal task done automation |
| Deal task due date | DATE | Deal task due date |
| Deal task edate | DATE | Deal task edate |
| Deal task ID | TEXT | Deal task ID |
| Deal task note | TEXT | Deal task note |
| Deal task outcome info | TEXT | Deal task outcome info |
| Deal task outcome ID | TEXT | Deal task outcome ID |
| Deal task relid | TEXT | Deal task relid |
| Deal task reltype | TEXT | Deal task reltype |
| Deal task status | TEXT | Deal task status |
| Deal task title | TEXT | Deal task title |
| Deal task udate | DATE | Deal task update date |
| Deal task user | TEXT | Deal task user |
| Deal title | TEXT | Deal title |
| Deal value | NUMERIC | Deal value |
| Deal win probability | NUMERIC | Deal win probability |
| Deal win probability mdate | DATE | Deal win probability mdate |
| List analytics_domains | TEXT | List analytics_domains |
| List analytics_source | TEXT | List analytics_source |
| List analytics_ua | TEXT | List analytics_ua |
| List carboncopy | TEXT | List carboncopy |
| List cdate | DATE | List creation date |
| List deletestamp | TEXT | List deletestamp |
| List facebook session | TEXT | List facebook session |
| List full address | TEXT | List full address |
| List get_unsubscribe_reason | TEXT | List get_unsubscribe_reason |
| List ID | TEXT | List ID |
| List name | TEXT | List name |
| List optinmessageid | TEXT | List optinmessageid |
| List optin optout | TEXT | List optin optout |
| List optout conf | TEXT | List optout conf |
| List p_embed_image | TEXT | List p_embed_image |
| List p_use_analytics_link | TEXT | List p_use_analytics_link |
| List p_use_analytics_read | TEXT | List p_use_analytics_read |
| List p_use_captcha | TEXT | List p_use_captcha |
| List p_use_facebook | TEXT | List p_use_facebook |
| List p_use_tracking | TEXT | List p_use_tracking |
| List p_use_twitter | TEXT | List p_use_twitter |
| List private | TEXT | List private |
| List require name | TEXT | List require name |
| List send_last_broadcast | TEXT | List send_last_broadcast |
| List sender addr1 | TEXT | List sender addr1 |
| List sender addr2 | TEXT | List sender addr2 |
| List sender city | CITY | List sender city |
| List sender country | COUNTRY | List sender country |
| List sender name | TEXT | List sender name |
| List sender phone | TEXT | List sender phone |
| List sender reminder | TEXT | List sender reminder |
| List sender state | TEXT | List sender state |
| List sender URL | TEXT | List sender URL |
| List sender zip | TEXT | List sender zip |
| List string ID | TEXT | List string ID |
| List subscription_notify | TEXT | List subscription_notify |
| List to_name | TEXT | List to_name |
| List twitter_token | TEXT | List twitter_token |
| List twitter token secret | TEXT | List twitter token secret |
| List update date | DATE | List update date |
| List unsubscription notify | TEXT | List unsubscription notify |
| List user | TEXT | List user |
| List user ID | TEXT | List user ID |
| Message cdate | DATE | Message creation date |
| Message charset | TEXT | Message charset |
| Message ed_instanceid | TEXT | Message ed_instanceid |
| Message ed_version | TEXT | Message ed_version |
| Message encoding | TEXT | Message encoding |
| Message format | TEXT | Message format |
| Message from email | TEXT | Message from email |
| Message from name | TEXT | Message from name |
| TEXT | Message hidden | |
| Message html | TEXT | Message html |
| Message html fetch | TEXT | Message htmlfetch |
| Message ID | TEXT | Message ID |
| Message mdate | DATE | Message modification date |
| Message name | TEXT | Message name |
| Message preheader text | TEXT | Message preheader text |
| Message preview data | TEXT | Message preview data |
| Message preview mime | TEXT | Message preview mime |
| Message priority | TEXT | Message priority |
| Message reply2 | TEXT | Message reply2 |
| Message subject | TEXT | Message subject |
| Message text | TEXT | Message text |
| Message text fetch | TEXT | Message text fetch |
| Message user | TEXT | Message user |
| Message user ID | TEXT | Message user ID |
| Today | DATE | Today's date |
Easily connect ActiveCampaign to Snowflake
See the value and return on every marketing touchpoint
Providing 70+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.