Why should I learn how to use the =QUERY function? I know what you’re thinking – why bother learning just another Google Sheets function? On the surface, you’re right, it is just another Google Sheets function but dig deeper and you’ll learn that =QUERY is more like the gateway to big data. The query function operates […]
How to Query Data in Google Sheets with =QUERY Function Read More »
Hi there. Fellow human here. Ever come across a case study that’s so complicated you have to re-read it five times? You’re not alone. That’s because it’s legit really hard to distill complex projects into simple stories. But it’s worth it. This post outlines ten tips for writing case studies—from planning it out to writing,
How to Write Case Studies So Humans Can Understand Them Read More »
What is Data Sampling? DATA SAMPLING is a process used to analyze a subset of data, in order to try and more quickly understand the entire data set. Let’s say my two sons dumped out 10,000 lego pieces onto their bedroom floor, and instead of cleaning it, I wanted to determine how many red lego pieces
How Google Analytics Data Sampling Works, Why it Matters, & How to Solve for It Read More »
Are you seeing data discrepancies between your backend system and Google Analytics? Often times you may find data discrepancies between your backend system (where website conversions are tracked manually) and data in Analytics platforms like Google Analytics (GA). Sound familiar? Then, read on! We’ve compiled some of our top tools for diagnosing what might be
How to Diagnose Google Analytics Data Discrepancies Read More »
Amazon has launched new metrics for brands advertising on the platform to better understand their audiences and who is buying on the platform. There are four new metrics that offer new-to-brand insights for advertisers. The metrics give an idea of what percent of purchasers and orders are new to brand versus returning customers coming from
Amazon New-to-Brand Metrics | PPC Hero Read More »
Google Analytics Custom Reports are an oldie but goodie. Pre-Google Data Studio, custom reports were our only way within the Google Interface to slice data outside of the default reports. Custom reports still provide a valuable way to quickly: Review & monitor custom metrics & dimensions in the interface Create a custom automated email report
How to Create a Custom Report in Google Analytics Read More »
From lead generation to online purchases, forms are everywhere. Unfortunately, nobody ever really wants to fill out a form, despite them being such a basic part of our online experience. A well-designed form helps to reduce the friction that stands between the user and what they want. On the flipside, a poorly-designed form can have serious
UX Checklist Series: Form Design Read More »
If you want to get real results from SEO… You’re going to need to arm yourself with the best tools. But, when you’re first starting out, it feels like everything is over your budget and you’re going to cripple yourself trying to pay for it all. Well, I’ve got news for you… It doesn’t have
The Best Free SEO Tools To Super Charge Your Search Rankings [2019] Read More »
As of this week, you can now become an official Amazon Advertiser with the launch of Amazon’s Learning Console. With the new Console, you can learn the basics of Amazon Advertising to get started and take a test to become an accredited in Sponsored Ads. Let’s take a dive into the parts of the console
Become an Accredited Amazon Advertiser Today Read More »
No matter your skill level or time in the biz, there is always an element of anxiety when tasked with creating a presentation for your clients. The goal of this guide is to boost your confidence before facing off with clients with an outline for how to present data in a meaningful way. Considerations First,
Guide for Delivering Impactful Client Presentations Read More »
