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 […]
Category: Analytics
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 […]
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 […]
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“. […]
How to Get Marketing Data to Snowflake
Advanced advertisers and analysts may find themselves in a situation where working with marketing data in Google Sheets or Excel or Google Data Studio is simply not good enough because: They need to do complex transformations of the raw data. They need to enrich the raw data with internal data sources. They need to “own […]
How to Get Google Ads Data to Google Data Studio along with Other Data Sources
Okay, this may sound like yet another useless article about getting Google Ads data into Google Data Studio. Most of the marketing community knows that Google itself provides a free Google Data Studio connector for Google Ads which will get you going in minutes. This is the connector: You just select the connector, then select […]