Import Data From Active Campaign Api Into Google Sql

Import Data From Active Campaign Api Into Google Sql

Import Data From Active Campaign Api Into Google SqlImport Data From Active Campaign Api Into Google Sql

To start constructing an automation in ActiveCampaign, begin with a “trigger.” There are a number of methods you can set off an automation, including: When a tag is added When a contact registers for a list When a contact submits a form E-commerce and on-site choices (offered in the “Pro” strategy) When the contact reaches a particular point in another automation.

From there, you can begin building the actions in your automation. Some actions that are offered in ActiveCampaign’s automations are: Send out an e-mail Notify a staff member Wait conditions If/then conditionals Split traffic for screening Avoid to other parts of the automation Track objectives (The contact can avoid to the objective’s location in the automation.) Start or end another automation, or end the present automation Post a webhook Subscribe or unsubscribe the contact to/from lists Update contact information Add and get rid of tags Add a note Lead scoring, SMS and site messages, and Facebook Custom-made Audience management are all “Pro” features – Import Data From Active Campaign Api Into Google Sql.

Contrast with ConvertKit‘s Automations, which are more limited. On ConvertKit, you can activate an automation when: The contact submits a form The contact purchases A tag is contributed to the contact A custom-made field is upgraded with a specific value From there, you can create Conditions, to check whether the contact has a particular tag or custom-made field worth.

Import Data From Active Campaign Api Into Google Sql

You can also produce Occasions, which are a bit like ActiveCampaign’s Objectives, however without the reporting. You can track an Event when: A tag is added or eliminated The contact makes a purchase A date occurs A custom field is updated with a certain value You don’t produce e-mails in ConvertKit’s Automations.

For more on how ActiveCampaign compares to ConvertKit, read my ConvertKit vs ActiveCampaign contrast. The main way I construct my list is through an email course. ActiveCampaign makes it easy for me to build my e-mail course precisely how I wish to construct it. Lots of marketers build very simple email sequences for their “e-mail courses.” A contact signs up, and after that that contact instantly begins getting lessons.

It was easy to develop with ActiveCampaign, but difficult when I was with MailChimp. I do not do that technique. My email course is manually synced with this countdown timer on my website. You have to register by Friday night, and a new course starts each Monday morning. When I first attempted this approach, I was on MailChimp.

Import Data From Active Campaign Api Into Google Sql

Here’s the automation I utilize to invite brand-new trainees to my Style Pitfalls course. There’s a few things going on here: The automation sends out all contacts a “welcome email (Import Data From Active Campaign Api Into Google Sql).” The automation verifies that it’s not Friday. If it’s not Friday, the automation waits up until it is Friday. At 11am, it sends out a “pump up” email to get the students prepared for next week’s course, and encourage them to share it with buddies.

The contact will begin getting lessons the following Monday morning. If it is Friday and after 7pm, the contact missed registration for next week’s class. They’ll get the pump up e-mail the following Friday morning, and lessons the Monday after that. It was impossible for me to automate this with MailChimp.

When I run a webinar, I do not desire to send the exact same email to everyone on my list. I want to send them the proper e-mail for their level of engagement – Import Data From Active Campaign Api Into Google Sql. Import Data From Active Campaign Api Into Google Sql. Here’s the automation I utilize to promote an evergreen webinar: First it verifies that they have not currently acquired the item I pitch in the webinar.

Import Data From Active Campaign Api Into Google Sql

Then it sends out a series of emails to get them thinking about the webinar, and to encourage them to register. If they register, they immediately struck the “Objective” towards the end of the webinar, and the automation ends. If they don’t register, they get contributed to an automation promoting a rebroadcast of the webinar. Import Data From Active Campaign Api Into Google Sql.

This allows me to customize my messaging, in other automations, based upon the contact’s engagement with the webinar. Here’s the WebinarJam integration panel: I can add tags based upon whether the contact signed up, attended, missed out on, or based upon the length of time they remained in the webinar. These tags can then activate automations within ActiveCampaign.

It costs me money, and it makes it more most likely that my emails go to spam or Gmail’s promos tab. People who do not open my e-mails make it harder for other emails to get to individuals who really want them! The “Pro” strategy of ActiveCampaign has actually lead scoring developed in.

Import Data From Active Campaign Api Into Google Sql

Here’s an automation I got from ActiveCampaign’s library of automations, which I use to inform which contacts aren’t engaging with my e-mails. When a contact subscribes, this automation adds a “0 days” tag. As time passes, it adds brand-new tags for 7 days, one month, 60 days, etc Each time they open an e-mail, a separate automation eliminates them from this automation, eliminates all of those tags, and begins this automation over again.

This automation can be overwhelming initially, and this is among those cases where I wish ActiveCampaign had a more out-of-the-box service. However, due to the fact that you can do anything with ActiveCampaign, sometimes you need to develop things from scratch. ActiveCampaign has an alternative to delete non-active subscribers, which I don’t suggest.

Some customers do not have actually tracking switched on, so their opens aren’t tape-recorded. Others still wish to be subscribed but have actually been busy. Here’s my reactivation series: I send one e-mail asking if they still want to be subscribed, and briefly explaining why I keep my e-mail list tidy. In one week, I send them another email (if they already clicked the confirmation link in the previous e-mail, they have actually currently been eliminated from the automation utilizing a separate automation) – Import Data From Active Campaign Api Into Google Sql.

Import Data From Active Campaign Api Into Google Sql

Import Data From Active Campaign Api Into Google SqlImport Data From Active Campaign Api Into Google Sql

The automation then unsubscribes them. My emails also have a link to a form where they can enter their email address to let me understand that they do not have tracking made it possible for. This type includes a tag that I utilize to filter those contacts out. Import Data From Active Campaign Api Into Google Sql. I used to add this tag when they clicked on a link, however when people don’t have tracking on, it makes those links not work so reliably! I just send a simple “do you still want my e-mails?” confirmation.