Problem Yet another customer approached me to solve their reporting needs when it comes to digital marketing campaigns. The customer wanted to aggregate these sources: Google Ads (ad group level) Microsoft Advertising (ad group level) Ringba (call tracking and routing system) A few reference tables in Google Sheets The expected outcome was a nice Power […]
Author: Daniel Zrust
Make.com Case Study: Loose Match Search with OpenAI and Some Boring Text Generation
Problem A customer needed to quickly understand the most common technical issues affecting particular car models on the US market. While NHTSA publishes these issues on daily basis for each car model, it’s not user friendly to work with. The requirement was to simply “ask” via email while providing the car model and get a […]
Make.com Case Study: Offline Conversion Uploads for Real
Problem The customer has been struggling with a major challenge: how to start tracking conversions with their values which mirror important events for his business? The customer is not interested in the predefined automated conversions in Google Ads which are often useless and only drive your spend up (e.g. “Clicks to call, Local actions – […]
How to Upload Offline Conversions from CRM to Microsoft Advertising?
My favorite topic is back. This time we’ll be solving a super-niche problem – uploading offline conversions to Microsoft Advertising (formerly knows as Bing Ads) in an automated fashion. Wait…what? You can upload conversion to Microsoft? Yes, you can! Why Should You Care? Let’s say you run a search lead gen campaign on Bing and […]
Make.com Case Study: Automated Data Collection with Uneditable Forms
Problem A client needed to build a simple data collection workflow on a very low budget. One of the requirements was to use as few apps as possible. The problem to solve was relatively simple – every month, the client needs to collect simple data from over 150 individuals. Until now, the process was 100% […]
The Report Google Ads Won’t Give You: Cost Pacing
When running Google Ads campaigns (feel free to change for Facebook Ads, LinkedIn Ads, Microsoft Advertising…), you always need to know how much you’ll spend by the end of the month. Ideally, this information is automatically pushed to you on a regular basis so you don’t have to regularly go to a spreadsheet to get […]
Make.com Case Study: Automated Page Generation in WordPress from Airtable Records
Problem A client needed to build a simple WordPress directory of certain businesses in specific locations on his existing WordPress site. The caveat was that his inputs are residing in several tables in Airtable and the client has NO HTML knowledge. The goal was to: Allow the client to generate new pages containing relevant businesses […]
Common Challenges in PPC Reporting Projects
I’ve been involved in quite a few reporting projects over the past few years so I want to share my experience with challenges which keep appearing over and over. I am not going to provide solutions for all the points below since the solutions tend to be very specific for each project. Take this article […]
Dark Side of PPC Automation
Browsing various PPC blogs (including mine) can create an impression that automation in the PPC/digital marketing world can solve all major advertisers’ problems. But is it really the case? Unfortunately not! In this article I will look back at the last 7 years when I was heavily automating anything I could when running (mainly) PPC […]
Make/Integromat Case Study: Web App to Simplify Management of PPC Shopping Feed
Problem A client needed to simplify the management of their massive Google Ads shopping feed. The client is running this setup: They have around 300,000 unique items in their feed. In reality, there are “only” around 12,000 unique physical products spread over 23 different combinations of e-shop domains and countries. The client needs to frequently […]