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 […]
Category: Tools
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 […]
Case Study: Solving Digital Marketing Agency Reporting in 2 Weeks
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 […]
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 […]
Google Ads Keyword Planner Data to Google Sheets
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** I’ve always wanted to be able to easily get Google Ads Keyword Planner data to Google Sheets. The best case scenario was to provide inputs in a Google Sheet and then have “some magic” download the […]
Jak Stáhnout Sklik Data do BigQuery
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** Pro Sklik existuje řada skriptů (především od Standy Jílka), které umožňují stahovat data z Skliku do Google Sheetů. Nebudu tedy nosit dříví do lesa a raději zkusím stáhnout data o výkonu kampaní z Skliku rovnou do […]
Dealing with Cookie Apocalypse: Data ETL and Performance Reporting
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** The ongoing advertising cookie sunset poses serious challenges to reporting your campaign results. If your site does not use any sneaky cookie consent designs, you can expect to lose around 60-90% of advertising cookies. This means […]
Make/Integromat in the BI World: Will It Work?
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** I’ve always wondered whether you can use Integromat for making your life easier in the BI/analytics world where I am partially coming from. As I’ve been becoming more familiar with Integromat ecosystem I can say “yes“. […]