Summary In today's episode, I walk through how to use Google Data Studio's Date Hour Minute field to measure website traffic in the 10-minute window before and after a TV commercial airs. Here's what this means for you. You gain a practical method for evaluating whether your television advertising actually drives measurable traffic to your…
Talesa asks, “What tips do you have on Google Analytics best practices for consistent reporting? What do you look at monthly, quarterly, yearly, even daily?” Start with this simple question: what do you need to make decisions on at those frequencies? What decisions do you need to make daily, weekly, monthly, quarterly, and yearly? That…
Summary In today's episode, I walk through how to analyze returning users in Google Analytics and why they matter for your marketing strategy. Here's what this means for you. You'll discover that your existing audience often delivers more value than chasing new leads, and you can identify gaps in how you serve them. You'll also…
Monina asks, “What tools are useful to help marketers dig deep into their organization’s data?” The answer to this question depends on the level of skill a marketer has in data science, specifically the technical and statistical skillsets. I’d put the available tools in categories of beginner, intermediate, and advanced. Beginner tools help marketers extract…
Chelsea asks, “How do you organize and track which display ads you’re running and where?” You should be keeping track of all ads with Google Analytics UTM tracking codes, governed in a Google Sheet, measured in Google Data Studio. Watch the video for full details. Can’t see anything? Watch it on YouTube here. Listen to…
Summary In today's episode, I break down how to organize and track display ads using Google Analytics UTM tracking codes, spreadsheets for governance, and Data Studio for reporting. Here's what this means for you. You'll gain a complete taxonomy framework that lets you see exactly which ads, vendors, and content pieces drive real performance across…
Summary In today's episode, I walk through a spectrum of data visualization tools ranging from simple animation makers to professional-grade software for creating beautiful information graphics. Here's what this means for you. You'll find the right tool for your skill level and use case, whether you're a beginner sketching quick visuals or a seasoned analyst…
Marina asks, “How do you add a comparison of a metric over dates in a table in Google Data Studio?” While this has been requested in Google Data Studio’s feature requests, it’s not available in the application now. But there’s a bigger issue at play: techniques to engineer this sort of thing, like calculated fields,…
Glen asks, “What’s the best way to use Google Data Studio for marketing reporting?” While I appreciate the sentiment, there is no one best way. Rather, there are ways to think about setting up Google Data Studio that help you get the answers you want as quickly as possible, Google Data Studio Dashboard best practices.…
