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

Let’s state you have the given name of just a few of your contacts, which holds true with my list. I typically don’t require a very first name to register to my list, but in some cases I get a first name, such as when someone purchases a product. Wouldn’t it be good to welcome your contacts by name, in the cases when you have it? You can do this, however it’s cumbersome.

I’m likewise filtering for generic terms included by other systems, such as a dash, or “Guest.” If they have a given name, I say “Hey,” and after that their first name. If they don’t, I just say “Hey there,” (Import Data From Active Campaign Api Into Google Sql). By constructing a Message Variable in ActiveCampaign, I can quickly change my greeting according to whether I have the contact’s very first name.

Import Data From Active Campaign Api Into Google Sql

I developed a variable that’s merely %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 truly conserve me a lot of time is by enabling me utilize the very same automation over and over once 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 bunch of different variables here, such as the date and time of the webinar, the cost of the item, deal terms, discount coupon code, and more. Each time I run a new webinar, I can change each of these variables to match any schedule modifications or deal changes.

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

Import Data From Active Campaign Api Into Google Sql

I have actually found that really hard to do with ActiveCampaign. For some time, I was modifying e-mails in ActiveCampaign’s hybrid editor, which is rather cumbersome. For a long period of time, I used ActiveCampaign’s hybrid HTML and WYSIWYG editor, which was set off by a standard design template I produced. The user interface for the HTML editor looks like it was pulled from some totally free open-source project. Import Data From Active Campaign Api Into Google Sql.

However, adding images is a little a task. You need to select them from a file browser. There’s no drag and drop option. ActiveCampaign’s HTML email editor requires that you make up entirely in HTML. The alternative to this, if you wish to have control over the HTML, is to modify pure HTML, with a preview on the side.

Including images to ActiveCampaign’s rich text editor is a clunky experience. You require separate text boxes for above and listed below the image. Recently I have actually started using ActiveCampaign’s rich text editor. They have some great design templates, however I still desire to send out the plainest email possible. They do have some plain-looking e-mails, however they have some degree of very little format, which you can’t remove – 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 fundamental. I can make it automatically take up the whole window, and I can modify the typography to be slightly larger, and have a bit more prominent. The most discouraging part of ActiveCampaign’s abundant text editor is adding images. Envision you’ve just typed out an excellent email. Import Data From Active Campaign Api Into Google Sql.

You can’t just add an image to a block of text. Rather, you need to produce two blocks of text: one for before the image, and one for after the image. If you have actually made any formatting modifications, you’ll need to watch on those to remain constant. That’s one thing to handle when you wish to include one image, but when you want to include numerous, it becomes a big chore.

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

Import Data From Active Campaign Api Into Google Sql

MailChimp’s integrated image editor is exceptionally powerful. You can resize, crop, and add 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 conserve me a little time to have that same experience on ActiveCampaign. But the highly-customizable automations I can build on ActiveCampaign more than make up for that possible time savings.

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

I’ll click on an e-mail, and it takes me to the editor for that e-mail. Note 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 in between numerous emails, I would intuitively be inclined open the exact same automation in various tabs, then open the particular e-mails from each of those tabs.

Import Data From Active Campaign Api Into Google Sql

In the Automations section, there’s a “Manage Messages” area. 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 new tab to more quickly edit your whole series. Import Data From Active Campaign Api Into Google Sql. Contrast that with ConvertKit’s Series.

Once again, it would conserve me a great deal of time to have ConvertKit’s automation e-mail editing 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 offsets it with their Message Variables, more robust automations, and advanced division. Mentioning segmentation, another factor I changed from MailChimp to ActiveCampaign was that MailChimp has restricted division alternatives.

You can integrate qualities with an AND/OR operator, and you can mix and match those groups of qualities with another AND/OR operator. With MailChimp, you can only section by AND/OR, however MailChimp’s Pro strategy allows more advanced segmenting, for an additional $199 a month. In my search for the perfect email marketing platform, I saw numerous others, a few of which I have actually already mentioned.

Import Data From Active Campaign Api Into Google Sql

ConvertKit. If I weren’t on ActiveCampaign, I would most likely be using ConvertKit. Their automations are a lot easier to construct, though they aren’t as versatile as ActiveCampaign’s, and their divisions choices aren’t as advanced either. They likewise do not have objective tracking, or Message Variables. MailChimp. You already understand that I changed from MailChimp to ActiveCampaign.