How To Use Analytics Custom Reports To Optimize E-Commerce Accounts & Increase ROAS
June 29, 2012
As an account manager of a handful of e-commerce clients, return on ad spend (ROAS), is the key metric I look at to optimize my accounts. Of course, return on investment (ROI) is even better, but it’s not often, at least in my experience, that you get a client with access to their product margins and overhead costs. I normally get a loose estimation of these things, and we work out a goal ROAS together. With, of course, increasing volume being the goal of equal or greater value.
So, to meet this end, I’ve started using a custom report in Analytics that tells me all of my AdWords information, shows me conversion rates along the conversion funnel so I can easily identify areas to concentrate optimization efforts, and shows me REAL ROAS figures. If your site charges shipping and/or tax (you are legally require to charge tax at least to those customers in your company’s state), and you’re just using the top-line revenue numbers to figure your ROAS–you’re doing it wrong! You need to factor out shipping and tax costs to find your actual product revenue. There are some sites that use shipping charges as a way to get a bit more profit, so make sure to discuss that with your client to see if you should attribute any revenue to the shipping charges.
So, here’s the how-to: first of all, you need to have e-commerce tracking and conversion funnel goals in place. If you need help with setting that up, check this article out.
I use four different tabs for my report, so create these four tabs with these metrics and dimension drilldowns:
1. Cost and Revenue
I use this tab to get a quick & dirty look at cost versus revenue numbers by campaign. Like I mentioned before, this revenue number isn’t factoring out the shipping or tax, but again–quick & dirty! It gives me a quick glance to to see which campaigns are looking shabby. You can click the campaign that’s crappy to see the ad groups that are crappy, and click the ad groups to see the keywords (this is the point of the dimension drilldowns).
2. Revenue Breakdown
I use this tab to get the real ROAS. Factor out that shipping and tax, or you’re basically just lying to the client. Again, keep clicking through the dimensions to find the areas you need to concentrate on optimizing or find the areas that are great so you can duplicate their strategies.
3. Site Performance
This tab helps me further hone in where to make my optimizations. Here, I can see the percentage of people who visit that add something to their cart and the percentage of people who add something to their cart and actually purchase something. This helps me figure out if people are getting turned off somewhere in the check-out process or if they just hate the landing page. So, by now, you’ve done a quick down and dirty analysis of which campaigns/ad groups/keywords need help, you’ve figured out the real ROAS to make sure you’ve got the bad seeds, and now you’ve focused in the problem by finding where in the conversion funnel people are getting turned off. If you’re not seeing anything alarming in this tab–great!! Your problems are somewhere in the last tab.
4. AdWords Stats
With this tab, you can find out where your CPCs are for your identified crappy campaigns/ad groups/keywords and all of your AdWords metrics. This will hopefully help you identify where you can make some improvements in you AdWords campaign to better your ROAS.
So, there you have it–my Analytics custom report, how to make it, and how I use it for increasing e-commerce ROAS. Now, tell me if I’m missing anything! Or, how would/do you do this report differently?
Hanapin's PPC Resources Are Now Ungated!
You can now access Hanapin's whitepapers and toolkits without having to fill out a form!
View Ad Creative Through The Eyes Of Your Searchers
Learn to understand that ads do not live in the vacuum of an excel sheet and common practices should be tested.
[New Webinar!] 11 Red Flags To Watch Out For When Working With An Agency
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
Leveraging Analytics For Remarketing: Picking The Ripest Fruit
Remarketing prevalence is well founded based on competitive returns in both volume and efficiency. With that said, this "low hanging fruit" world isn't always easy to pick.
How To Analyze Time-Of-Day Performance For Luxury Products
The importance of ad schedules varies across industries, services, and products. For e-commerce companies that sell luxury goods, ad schedules are more crucial.
One Week Left to Save 25% at Hero Conf London!
You still have time to join us for Hero Conf London, 24-26 October at etc.venues St Paul's at 25% off the conference price. But time is running out.
4 Common Questions Prospects Ask Me During The Sales Process
There’s always new, hot topics and questions we get asked by prospects to see what our company’s take is, and how we go about implementing from a services perspective. Read what our most common questions are.
Mobile Price Extensions Rolling Out In AdWords
It looks like "Christmas in July" has come to Google. Recently announced price extensions are designed to help mobile marketers qualify clicks and inform prospective consumers.
[New Whitepaper!] 4 Ways To Survive PPC Campaigns for the Healthcare Market...
This whitepaper will highlight four examples of how thinking at the corners can help boost your PPC performance in the healthcare industry.
Create Visually Appealing Reports With Google Data Studio
When we talk about what tasks tend to eat up a significant chunk of time, reporting is surely mentioned. You may want to explore another option - Google Data Studio.
Liveblogging 2016 DoubleClick Announcements
Today is the day we learn more about the latest DoubleClick updates. Follow along live as we share DoubleClick's announcements as well as our opinions.
The 2016 Top 25 Most Influential PPC Experts
After a month of voting, rigorous research and data analysis, we are excited to announce the wildly anticipated list of the Top 25 Most Influential PPC Experts for 2016.
[New Webinar with AdEspresso!] 4 Effective Strategies for Facebook Lead Gen...
In this new webinar, AdEspresso and Hanapin experts discuss four effective strategies to use Facebook Lead Gen Ads for your business.