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 likewise see whether the conclusion rate has actually increased or decreased, how long it takes for contacts to reach that objective, and you can browse all contacts to see who did and didn’t reach the goal. ActiveCampaign’s Message Variables is my preferred function. It conserves me a lots of effort and time, and neither MailChimp nor ConvertKit (update: 9/2020 ConvertKit now has ” snippets”) has a similar feature.

Let’s say you have the very first name of just some of your contacts, which is the case with my list. I generally don’t require a given name to register to my list, but in some cases I get a first name, such as when somebody purchases a product. Wouldn’t it be great to welcome your contacts by name, in the cases 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 state “Hey there,” (Import Data From Active Campaign Api Into Google Sql). By developing a Message Variable in ActiveCampaign, I can easily change 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 shows up in the e-mail. If I don’t have the contact’s name, it defaults to “Hey,”. Where Message Variables truly save me a great deal of time is by allowing me use the very same automation over and over again for my webinars, and I can quickly change out all of the details.

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 bunch of different variables here, such as the date and time of the webinar, the price of the product, deal terms, coupon code, and more. Each time I run a brand-new webinar, I can change each of these variables to match any schedule changes or offer modifications.

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

Import Data From Active Campaign Api Into Google Sql

I have actually found that very difficult to do with ActiveCampaign. For awhile, I was editing e-mails in ActiveCampaign’s hybrid editor, which is quite clunky. For a very long time, I used ActiveCampaign’s hybrid HTML and WYSIWYG editor, which was triggered by a basic template I created. The user interface for the HTML editor looks like it was pulled from some free open-source task. Import Data From Active Campaign Api Into Google Sql.

However, including images is a little a task. You need to select them from a file browser. There’s no drag and drop choice. ActiveCampaign’s HTML email editor requires that you compose completely in HTML. The alternative to this, if you desire to have control over the HTML, is to edit pure HTML, with a sneak peek on the side.

Including images to ActiveCampaign’s abundant text editor is a clunky experience. You need different text boxes for above and listed below the image. Recently I have actually begun utilizing ActiveCampaign’s rich full-screen editor. They have some great templates, but I still wish to send out the plainest e-mail possible. They do have some plain-looking e-mails, but they have some degree of minimal formatting, which you can’t eliminate – Import Data From Active Campaign Api Into Google Sql.

Import Data From Active Campaign Api Into Google Sql

However, with some adjustments, I can make my email pretty standard. I can make it immediately take up the entire window, and I can tweak the typography to be a little larger, and have a bit more prominent. The most frustrating part of ActiveCampaign’s rich text editor is adding images. Imagine you have actually simply typed out a terrific e-mail. Import Data From Active Campaign Api Into Google Sql.

You can’t just add an image to a block of text. Rather, you have to create two blocks of text: one for before the image, and one for after the image. If you’ve made any formatting changes, you’ll have to keep an eye on those to remain constant. That’s one thing to deal with when you wish to include one image, but when you wish to add numerous, it ends up being 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’ve 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 truly plain email, offered you make a standard design template first.

Import Data From Active Campaign Api Into Google Sql

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

ConvertKit’s e-mail editing experience is really plain, however easy to navigate. Their design templates are restricted, which is fine with me, but their email modifying experience is a little easier in that you can create inline images, and you can produce a totally plain email, and even edit the underlying HTML. If you desire to make some fast edits to some emails in an automation, with ActiveCampaign, it’s cumbersome.

I’ll click on an email, and it takes me to the editor for that e-mail. Keep in mind that I can’t even Command + Click to open it in another tab. Whether they suggested to or not, ActiveCampaign has disabled Command + Click from the automation editor. If I wished to change backward and forward between numerous emails, I would intuitively be inclined open the very same automation in numerous tabs, then open the particular e-mails from each of those tabs.

Import Data From Active Campaign Api Into Google Sql

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

Again, it would save me a lot of time to have ConvertKit’s automation e-mail modifying experience on ActiveCampaign – Import Data From Active Campaign Api Into Google Sql. However picking an e-mail marketing platform is like selecting a spouse. ActiveCampaign makes up for it with their Message Variables, more robust automations, and advanced segmentation. Speaking of division, another factor I switched from MailChimp to ActiveCampaign was that MailChimp has limited segmentation alternatives.

You can combine characteristics with an AND/OR operator, and you can mix and match those groups of characteristics with another AND/OR operator. With MailChimp, you can only section by AND/OR, however MailChimp’s Pro strategy allows more sophisticated segmenting, for an additional $199 a month. In my look for the perfect email marketing platform, I saw many others, some of which I’ve 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 much easier to build, though they aren’t as versatile as ActiveCampaign’s, and their divisions options aren’t as sophisticated either. They also don’t have objective tracking, or Message Variables. MailChimp. You already understand that I changed from MailChimp to ActiveCampaign.