Calculating spend averages with excel for online ads
A while back while talking to a friend about his career changes he uttered the following phrase: “Yes it’s different but it’s also the same, everything leads to Excel”, me a self declared fan of Excel and anything that might make my work life easier smiled and laughed. This phrase is so real and there […]
Design Thinking Process:
When doing a task or activity for the first time, it usually takes longer than on following iterations. The first couple of times you are still struggling to remember how you did it and why you did it that way. By the 100th time you don’t think about it anymore, you are a well oiled […]
The Importance of Tracking the Right Event
As Google shifts more and more into automation and allowing its algorithm to take over almost full control of a campaign (Performance Max) it’s becoming increasingly more important to give Google the right signals to optimize for. We’ve seen time and time again that Google is able to hit its tCPA or tROAS goals if […]
The Power of Data visualization and Storytelling with Data
When we think of data analysis, we think of numbers, spreadsheets, and insights, but does data analysis end with just finding insights? Well, the answer is ”No”. What if I say there is an even harder task than the current method of simply finding insights – it is referred to as the “Visualization and Communication”. […]
Automation 101: Macros
When we think about automation or automating tasks we either think of a magic solution that will do our work and let us sip margaritas while a computer does our job for us, or, if your experience has been bad, you might think of automation as too complex of a solution for a simple issue […]
Set Up An Automated Budget Pacing Report With Supermetrics
As busy professionals, we all wish we could have a bit more time.Time is always a limiting factor. But in a world of automation, there’s always a way to free up your minutes and make your life a little easier. Let’s get to it! We use Supermetrics to help with this. Here’s the simple equation […]
Pixel Based Tracking versus 1st Party Data Attribution
The more sources of marketing attribution and tracking data you use, the more confused you are likely to become, but why is that? As online marketers increase ad spend, marketing channels, and complexity of campaigns, the need for accurate marketing performance becomes critical. The increased ad spend adds more pressure to perform. The dreams of […]
How to Setup Google Ads Conversion Action Sets
What are and how to set up Google Ads conversion action sets, allowing advertisers to set different events by campaign in Google Ads (released in 2019).
Fix Avg. % Calculation Error in Google Data Studio
Data Studio does not always calculate percentages correctly by default. Some metrics need additional manipulation.
Introduction to Google Analytics Segments
Learn about the power of custom segments in Google Analytics with this quick guide. You’ll be able to create your own segments in no-time!