Problem A client approached me with an evergreen problem: “My agency reporting sucks, can you help?”. Oh, I so had not heard that one before! (Actually I had). This was the client’s situation: Digital marketing agency is servicing around 20 customers. All reporting used to be done in standalone Excel files on client level. First […]
“Bad Leads” Problem Every Lead Gen Marketer Has – Time To Start Using Offline Conversion Uploads
If you are running paid lead generation campaigns in Google Ads (or Facebook Ads or Microsoft Advertising or LinkedIn Ads – make you choice here), you likely see that was majority of leads are just bad on arrival. In the campaigns I’ve seen in 9 years, the number of bad leads does not go below […]
Advanced Concepts in Make/Integromat: Handling Inconsistent Outputs of Preceding Modules
***Consider this article as a more advanced version of Magic Formula to Solve Complex Problems in Make*** Have your ever faced a situation where outputs of preceding module were not consistent in Make? For example, an item within an array would come as an array, but the next item with the same array would come […]
Magic Formula to Solve Complex Problems in Make/Integromat
Have you ever wondered if it’s possible to use coding approaches in Make to solve complex problems? It is! In the video below, I am showing how to use Set/Get Variables modules along with Router. If you master this combo, you’ll be able to build super powerful scenarios to solve really difficult problems. The sample […]
New BigQuery UI is Just Bad!
I would never believe I’d say something like this but Snowflake’s UI is terrible but Google is now far worse. Well done, Google! Here are several reasons why I think the new UI is just bad: It’s slow. Far slower than the previous UI. There is like 0.1s lag when you are typing your query. […]
Make/Integromat Case Study: Connecting GoFlow with QuickBooks via BigQuery
Problem A client has approached me with a seemingly simple problem – he wanted to connect GoFlow (on order management software) with QuickBooks (an accounting software). While a native integration between the systems already exists, it offers almost no customization and was simply not a fit for my client. I was tasked to: Build an […]
Make/Integromat Case Study: Automating Checkout Process on This Site
Problem In some of my articles, I offer content as a free download OR as a paid download – it’s a process which can be technically called as checkout. The challenge is to deliver the right files to the right customers no matter if they go via the free or the paid route. I had […]
Working with Arrays and Aggregations in Make/Integromat
In today’s video we’ll look at a real life example where you need to process an array and possibly do an aggregation of the iterated data. The sample data is an order from WooCommerce with multiple line items. The goal is to pass the line item data to a Google Sheets spreadsheet. Why this topic? […]
Yes, You Can Replace Google Ads Scripts with Make/Integromat
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** The problem I am solving today is replicating this 3 years old script Free Google Ads Script for Building Negative Keyword List to Negate Bad Search Terms entirely in Integromat. You might be wondering why I […]
Make/Integromat in Performance Marketing World
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** Integromat is a super powerful tool for automating your marketing workflows. However, the term “marketing” can mean many things. In the generic form, “marketing automation” with Integromat is usually about pushing contacts from a source system […]