How To Connect And Collect Data From Active Campaign To Google Sheets

You can likewise see whether the completion rate has 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 function. It conserves me a lots of time and effort, and neither MailChimp nor ConvertKit (upgrade: 9/2020 ConvertKit now has ” bits”) has an equivalent feature.
Let’s say you have the given name of just some of your contacts, which is the case with my list. I generally do not require a given name to sign up to my list, but sometimes I get a first name, such as when someone purchases an item. Would not it be good to greet your contacts by name, in the events when you have it? You can do this, however it’s cumbersome.
I’m also filtering for generic terms added by other systems, such as a dash, or “Guest.” If they have a very first name, I state “Hey,” and then their given name. If they do not, I just state “Hey there,” (How To Connect And Collect Data From Active Campaign To Google Sheets). By constructing a Message Variable in ActiveCampaign, I can easily alter my greeting according to whether or not I have the contact’s given name.
How To Connect And Collect Data From Active Campaign To Google Sheets
I developed a variable that’s merely %greeting-hey%. If I have the contact’s name, it reveals up 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 use the very same automation over and over once again for my webinars, and I can rapidly change out all of the details.

Here are variables for a webinar I run called “Bust Through Creative Blocks.” You can see I have a lot of different variables here, such as the date and time of the webinar, the cost of the product, deal terms, voucher code, and more. Each time I run a brand-new webinar, I can change each of these variables to match any schedule changes or deal changes.
And here it is in an email. This message variable enables me to easily change out a countdown timer. I did mention earlier that one of the cons of ActiveCampaign is their email modifying experience. I changed from MailChimp, and MailChimp occurs to have the finest e-mail editing experience. I really like to send simple e-mails.
How To Connect And Collect Data From Active Campaign To Google Sheets
I’ve discovered that extremely hard to do with ActiveCampaign. For awhile, I was editing e-mails in ActiveCampaign’s hybrid editor, which is quite cumbersome. For a long period of time, I used ActiveCampaign’s hybrid HTML and WYSIWYG editor, which was triggered by a basic design template I developed. The interface for the HTML editor looks like it was pulled from some totally free open-source job. How To Connect And Collect Data From Active Campaign To Google Sheets.
However, including images is a little a chore. You need to pick them from a file browser. There’s no drag and drop alternative. ActiveCampaign’s HTML e-mail editor requires that you compose totally 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.
Adding images to ActiveCampaign’s abundant full-screen editor is a clunky experience. You need different text boxes for above and listed below the image. Lately I have started utilizing ActiveCampaign’s rich text editor. They have some good design templates, however I still wish to send the plainest email possible. They do have some plain-looking emails, however they have some degree of minimal formatting, which you can’t get rid of – How To Connect And Collect Data From Active Campaign To Google Sheets.
How To Connect And Collect Data From Active Campaign To Google Sheets
However, with some modifications, I can make my email quite standard. I can make it immediately use up the entire window, and I can fine-tune the typography to be somewhat larger, and have a bit more leading. The most aggravating part of ActiveCampaign’s rich text editor is including images. Imagine you have actually just typed out a great e-mail. How To Connect And Collect Data From Active Campaign To Google Sheets.
You can’t merely include an image to a block of text. Rather, you need to create two blocks of text: one for before the image, and one for after the image. If you’ve made any format modifications, you’ll have to watch on those to stay consistent. That’s something to handle when you desire to add one image, however when you wish to include a number of, it becomes a huge chore.
They even have a fundamental mage editor where you can crop the image – How To Connect And Collect Data From Active Campaign To Google Sheets. MailChimp’s editor is the best I have actually seen in all of the email marketing platforms I have actually attempted. You have access to the underlying code, so you can produce a truly plain email, provided you make a basic template first.
How To Connect And Collect Data From Active Campaign To Google Sheets
MailChimp’s integrated image editor is incredibly effective. You can resize, crop, and include customized text to your images. I miss out on MailChimp’s email-editing experience (How To Connect And Collect Data From Active Campaign To Google Sheets). It would save me a little time to have that very same experience on ActiveCampaign. But the highly-customizable automations I can construct on ActiveCampaign more than offset that potential time savings.
ConvertKit’s email editing experience is very plain, however easy to navigate. Their templates are limited, which is fine with me, however their e-mail editing experience is slightly much easier because you can create inline images, and you can develop a totally plain e-mail, and even edit the underlying HTML. If you wish to make some quick edits to some emails 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 implied to or not, ActiveCampaign has disabled Command + Click from the automation editor. If I wanted to switch back and forth in between numerous e-mails, I would intuitively be inclined open the very same automation in various tabs, then open the respective emails from each of those tabs.
How To Connect And Collect Data From Active Campaign To Google Sheets
In the Automations section, there’s a “Manage 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 new tab to more quickly modify your whole series. How To Connect And Collect Data From Active Campaign To Google Sheets. Contrast that with ConvertKit’s Sequences.
Once again, it would conserve me a great deal of time to have ConvertKit’s automation email modifying experience on ActiveCampaign – How To Connect And Collect Data From Active Campaign To Google Sheets. But choosing an email marketing platform is like choosing a spouse. ActiveCampaign makes up for it with their Message Variables, more robust automations, and advanced segmentation. Mentioning division, another factor I switched from MailChimp to ActiveCampaign was that MailChimp has actually restricted segmentation alternatives.
You can combine qualities with an AND/OR operator, and you can mix and match those groups of traits with another AND/OR operator. With MailChimp, you can just segment by AND/OR, nevertheless MailChimp’s Pro strategy enables more sophisticated segmenting, for an additional $199 a month. In my search for the ideal email marketing platform, I saw many others, some of which I have actually currently pointed out.
How To Connect And Collect Data From Active Campaign To Google Sheets
ConvertKit. If I weren’t on ActiveCampaign, I would most likely be utilizing ConvertKit. Their automations are a lot easier to develop, though they aren’t as versatile as ActiveCampaign’s, and their segmentations choices aren’t as sophisticated either. They likewise don’t have goal tracking, or Message Variables. MailChimp. You currently know that I changed from MailChimp to ActiveCampaign.