Import Data From Active Campaign Api Into Google Sql

To start building an automation in ActiveCampaign, start with a “trigger.” There are a number of ways you can activate an automation, consisting of: When a tag is added When a contact registers for a list When a contact submits a type E-commerce and on-site choices (offered in the “Pro” plan) When the contact reaches a specific point in another automation.
From there, you can start building the actions in your automation. Some actions that are offered in ActiveCampaign’s automations are: Send out an email Inform a staff member Wait conditions If/then conditionals Split traffic for screening Skip to other parts of the automation Track goals (The contact can skip to the objective’s location in the automation.) Start or end another automation, or end the existing automation Post a webhook Subscribe or unsubscribe the contact to/from lists Update contact details Add and eliminate tags Include a note Lead scoring, SMS and website messages, and Facebook Customized Audience management are all “Pro” features – Import Data From Active Campaign Api Into Google Sql.
Contrast with ConvertKit‘s Automations, which are more minimal. On ConvertKit, you can set off an automation when: The contact sends a kind The contact buys A tag is included to the contact A custom field is upgraded with a particular value From there, you can produce Conditions, to check whether the contact has a certain tag or customized field value.
Import Data From Active Campaign Api Into Google Sql
You can likewise develop Events, which are a bit like ActiveCampaign’s Objectives, but without the reporting. You can track an Occasion when: A tag is added or removed The contact purchases A date occurs A custom field is updated with a specific worth You don’t develop e-mails in ConvertKit’s Automations.
For more on how ActiveCampaign compares to ConvertKit, read my ConvertKit vs ActiveCampaign comparison. The primary way I construct my list is through an email course. ActiveCampaign makes it easy for me to build my email course exactly how I wish to build it. Lots of online marketers build really basic email sequences for their “email courses.” A contact register, and after that that contact instantly starts getting lessons.
It was simple to construct with ActiveCampaign, however impossible when I was with MailChimp. I do not do that approach. My email course is by hand synced with this countdown timer on my site. You have to register by Friday night, and a new course starts each Monday morning. When I initially tried this methodology, I was on MailChimp.
Import Data From Active Campaign Api Into Google Sql
Here’s the automation I use to welcome new students to my Style Pitfalls course. There’s a couple of things going on here: The automation sends out all contacts a “welcome e-mail (Import Data From Active Campaign Api Into Google Sql).” The automation confirms that it’s not Friday. If it’s not Friday, the automation waits till it is Friday. At 11am, it sends a “pump up” email to get the students ready for next week’s course, and motivate them to share it with friends.
The contact will start getting lessons the following Monday early morning. If it is Friday and after 7pm, the contact missed out on registration for next week’s class. They’ll get the pump up e-mail the following Friday early morning, and lessons the Monday after that. It was impossible for me to automate this with MailChimp.
When I run a webinar, I don’t wish 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 use to promote an evergreen webinar: First it validates that they haven’t currently purchased the item I pitch in the webinar.
Import Data From Active Campaign Api Into Google Sql
Then it sends out a series of e-mails to get them thinking about the webinar, and to motivate them to sign up. If they register, they immediately hit the “Objective” toward completion of the webinar, and the automation ends. If they don’t sign up, they get added to an automation promoting a rebroadcast of the webinar. Import Data From Active Campaign Api Into Google Sql.
This enables me to personalize my messaging, in other automations, based upon the contact’s engagement with the webinar. Here’s the WebinarJam integration panel: I can include tags based upon whether the contact signed up, attended, missed out on, or based upon for how long they stayed in the webinar. These tags can then activate automations within ActiveCampaign.
It costs me money, and it makes it most likely that my e-mails go to spam or Gmail’s promotions tab. People who don’t open my e-mails make it harder for other emails to get to individuals who really want them! The “Pro” strategy of ActiveCampaign has lead scoring constructed in.
Import Data From Active Campaign Api Into Google Sql
Here’s an automation I got from ActiveCampaign’s library of automations, which I utilize to inform which contacts aren’t engaging with my e-mails. When a contact subscribes, this automation includes a “0 days” tag. As time passes, it includes new tags for 7 days, one month, 60 days, etc Each time they open an email, a separate automation eliminates them from this automation, eliminates all of those tags, and begins this automation over again.
This automation can be overwhelming in the beginning, and this is one of those cases where I want ActiveCampaign had a more out-of-the-box option. However, since you can do anything with ActiveCampaign, sometimes you need to construct things from scratch. ActiveCampaign has an option to erase inactive subscribers, which I do not advise.
Some customers don’t have tracking turned on, so their opens aren’t recorded. Others still wish to be subscribed however have been hectic. Here’s my reactivation sequence: I send one email asking if they still wish to be subscribed, and briefly discussing why I keep my e-mail list tidy. In one week, I send them another email (if they currently clicked on the verification link in the previous email, they’ve currently been gotten rid of 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

The automation then unsubscribes them. My e-mails likewise have a link to a type where they can enter their email address to let me understand that they do not have tracking enabled. This kind adds a tag that I utilize to filter those contacts out. Import Data From Active Campaign Api Into Google Sql. I utilized to add this tag when they clicked a link, but when individuals don’t have tracking on, it makes those links not work so reliably! I just send a simple “do you still desire my e-mails?” verification.