Get Count of Rows With Specific Values From a Comma Separated List
Here’s an example of the data we have: We want to get a list of the industries with a count of users in each industry. Step 1. Download as .csv and turn into JSON Download the file as a .csv and upload it here: https://www.convertcsv.com/csv-to-json.htm. Default settings will work, just copy the result data when […]
The weaknesses of ActiveCampaign (2022)
I love ActiveCampaign. Ever since I started using it a couple of years ago, I’ve worked with a few dozen clients using it and convinced several people to switch providers. That said, ActiveCampaign (I’ll call it AC for short) has a few unfortunate weaknesses. These become more apparent for larger companies with more custom needs, […]
How to automatically show clients how many hours you’ve tracked
Like many freelance consultants, I charge clients by the hour and bill every two weeks. The problem is sometimes I accumulate quite a bit of time between invoices and some clients are surprised when they see the invoice for the last two weeks. I thought to myself: there’s gotta be a better way to let […]
How to Get Notified of New Upwork Job Posts in Your Niche Within a Minute
One of the best ways to make money on Upwork is to be the first person to respond to any job posts in your niche.In this post, I’ll show you how to get notified instantly every time something is posted in a niche that you’re familiar with so that you can get in there and […]
Building a custom checkout and donation-based sponsor-matching system
“I hired Gio and his team at Datos to help me launch an online course. From the beginning I found Gio (and his team) to be professional and stellar communicators. Beyond that was his knowledge of a world I could not have navigated on my own. Gio was able to put resources together that had […]
How to make a dynamic WordPress page with Javascript
Have you ever wanted to make a page change depending on where visitors are coming from, or create a page with a few slight variations? What you want to avoid is duplicating the page and making multiple versions. What if you want to update some of the copy or design in the page? Now you’ll […]
How to Send Dynamic Time-Based Email Reminders with ActiveCampaign
Out of the box, ActiveCampaign provides a way to send emails based on a dynamic date field (such as sending a reminder one day before a call). But it doesn’t provide a way to send email reminders a set amount of time before a dynamic event, such as a call or webinar. For any event […]
Dynamic quiz results email for How I Met My Dog
How I Met My Dog created a new quiz where users could answer personality questions about themselves and up to four of their dogs. These answers are processed with custom code to give the user results and insights about how their personality compares to their dog(s)’. The team hired me to take those results and […]
How to integrate Clickfunnels emails and site tracking with ActiveCampaign (the optimal way)
There are a few ways to integrate ActiveCampaign with Clickfunnels, each with their drawbacks. I’ll cover all three and let you decide what you want to use! You can click the links to skip to the method you want to use. 1. Use the built-in integration with Clickfunnels and ActiveCampaign. Drawbacks: it doesn’t trigger ActiveCampaign […]
How to create an automated email welcome sequence with multiple entry points in ActiveCampaign
If you collect email subscribers from multiple different locations and offer different content in return, you’re going to run into a couple of complications. 1. If a current subscriber wants a second email-gated piece of content, you want to send it to them without welcoming them twice. 2. You have to know which piece of […]
