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

You can also see whether the conclusion rate has actually increased or reduced, the length of time it considers contacts to reach that goal, and you can browse all contacts to see who did and didn’t reach the goal. ActiveCampaign’s Message Variables is my favorite feature. It conserves me a load of time and effort, and neither MailChimp nor ConvertKit (update: 9/2020 ConvertKit now has ” snippets”) has a comparable feature.

Let’s say you have the given name of just some of your contacts, which holds true with my list. I normally don’t need a given name to register to my list, but in some cases I get a given name, such as when someone buys an item. Wouldn’t it be good to welcome your contacts by name, in the events when you have it? You can do this, however it’s troublesome.

I’m also filtering for generic terms added by other systems, such as a dash, or “Visitor.” If they have a very first name, I state “Hey,” and then their given name. If they do not, I just say “Hey there,” (Import Data From Active Campaign Api Into Google Sql). By developing a Message Variable in ActiveCampaign, I can easily alter my welcoming according to whether I have the contact’s given name.

Import Data From Active Campaign Api Into Google Sql

I developed a variable that’s simply %greeting-hey%. If I have the contact’s name, it appears in the email. If I don’t have the contact’s name, it defaults to “Hey,”. Where Message Variables actually conserve me a lot of time is by allowing me utilize the exact same automation over and over again for my webinars, and I can rapidly alter out all of the information.

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

Here are variables for a webinar I run called “Bust Through Creative Blocks.” You can see I have a lot of various variables here, such as the date and time of the webinar, the cost of the product, offer terms, coupon code, and more. Each time I run a brand-new webinar, I can alter each of these variables to match any schedule changes or offer changes.

And here it remains in an email. This message variable enables me to easily change out a countdown timer. I did discuss earlier that a person of the cons of ActiveCampaign is their email modifying experience. I switched from MailChimp, and MailChimp takes place to have the very best email editing experience. I actually like to send basic e-mails.

Import Data From Active Campaign Api Into Google Sql

I have actually discovered that extremely hard to do with ActiveCampaign. For some time, I was editing e-mails in ActiveCampaign’s hybrid editor, which is rather clunky. For a long time, I used ActiveCampaign’s hybrid HTML and WYSIWYG editor, which was activated by a fundamental template I created. The interface for the HTML editor looks like it was pulled from some free open-source project. Import Data From Active Campaign Api Into Google Sql.

Nevertheless, adding images is a little bit of a chore. You have to choose them from a file web browser. There’s no drag and drop alternative. ActiveCampaign’s HTML email editor requires that you compose completely in HTML. The option to this, if you wish to have control over the HTML, is to edit pure HTML, with a preview on the side.

Including images to ActiveCampaign’s abundant full-screen editor is a clunky experience. You require separate text boxes for above and listed below the image. Lately I have actually started utilizing ActiveCampaign’s rich full-screen editor. They have some nice design templates, however I still want to send the simplest email possible. They do have some plain-looking e-mails, but they have some degree of very little formatting, which you can’t get rid of – Import Data From Active Campaign Api Into Google Sql.

Import Data From Active Campaign Api Into Google Sql

But, with some modifications, I can make my e-mail pretty standard. I can make it immediately take up the entire window, and I can fine-tune the typography to be a little bigger, and have a bit more leading. The most aggravating part of ActiveCampaign’s abundant text editor is adding images. Envision you’ve just typed out an excellent e-mail. Import Data From Active Campaign Api Into Google Sql.

You can’t simply include an image to a block of text. Instead, you need to produce two blocks of text: one for before the image, and one for after the image. If you’ve made any formatting modifications, you’ll need to keep an eye on those to stay constant. That’s something to handle when you want to add one image, however when you desire to include several, it becomes a huge chore.

They even have a basic mage editor where you can crop the image – Import Data From Active Campaign Api Into Google Sql. MailChimp’s editor is the very best I have actually seen in all of the e-mail marketing platforms I have actually tried. You have access to the underlying code, so you can develop a genuinely plain email, offered you make a standard design template initially.

Import Data From Active Campaign Api Into Google Sql

MailChimp’s integrated image editor is incredibly powerful. You can resize, crop, and include custom-made text to your images. I miss MailChimp’s email-editing experience (Import Data From Active Campaign Api Into Google Sql). It would save me a little time to have that very same experience on ActiveCampaign. However the highly-customizable automations I can construct on ActiveCampaign more than offset that possible time savings.

ConvertKit’s email editing experience is extremely plain, but simple to browse. Their templates are limited, which is fine with me, but their email editing experience is a little easier because you can develop inline images, and you can create a completely plain email, and even edit the underlying HTML. If you wish to make some quick edits to some e-mails in an automation, with ActiveCampaign, it’s cumbersome.

I’ll click an email, and it takes me to the editor for that email. Keep in mind that I can’t even Command + Click to open it in another tab. Whether they indicated to or not, ActiveCampaign has handicapped Command + Click from the automation editor. If I wished to switch back and forth in between various emails, I would intuitively be inclined open the exact same automation in various tabs, then open the respective e-mails from each of those tabs.

Import Data From Active Campaign Api Into Google Sql

In the Automations section, there’s a “Handle Messages” location. From here, you can see all of the messages in each of your automations. You can modify every one, or you can Command + Click to open each in a brand-new tab to more quickly modify your entire sequence. Import Data From Active Campaign Api Into Google Sql. Contrast that with ConvertKit’s Sequences.

Again, it would conserve me a great deal of time to have ConvertKit’s automation email modifying experience on ActiveCampaign – Import Data From Active Campaign Api Into Google Sql. But picking an email marketing platform resembles choosing a partner. ActiveCampaign offsets it with their Message Variables, more robust automations, and advanced division. Mentioning division, another factor I switched from MailChimp to ActiveCampaign was that MailChimp has actually restricted division alternatives.

You can combine characteristics with an AND/OR operator, and you can blend and match those groups of qualities with another AND/OR operator. With MailChimp, you can just section by AND/OR, however MailChimp’s Pro strategy allows more advanced segmenting, for an additional $199 a month. In my search for the ideal email marketing platform, I saw lots of others, some of which I have actually already discussed.

Import Data From Active Campaign Api Into Google Sql

ConvertKit. If I weren’t on ActiveCampaign, I would most likely be utilizing ConvertKit. Their automations are a lot easier to construct, though they aren’t as versatile as ActiveCampaign’s, and their segmentations options aren’t as sophisticated either. They also don’t have goal tracking, or Message Variables. MailChimp. You currently understand that I changed from MailChimp to ActiveCampaign.