Looking at Revenue Across Adwords & Analytics
February 22, 2011
Last week, Hanapin Marketing conducted its monthly, company-wide training session where we take a look at a variety of PPC topics to further our understanding and develop as a company. For this session, one of the topics we covered was taking revenue across Adwords and Analytics, and I wanted to share a bit of what we presented with our readers.
For starters, if you aren’t tracking conversions in Adwords, or goals in Google Analytics check out these helpful tips from Jen to get you started on the right path. Adwords has multiple conversion types to choose from, including: purchases, sales, sign-ups, views of a page, and other. In addition, if you link your Google Analytics account to Adwords, you can import goal conversions so you don’t have to tag your conversion pages with the Adwords code. Please note that when you do link these accounts, your data in Analytics and Adwords won’t match up.
Adwords tracks the “first touch” while Analytics tracks the “last touch”. This means that the keyword that triggered your ad the first time a user visits gets the credit, even if they come back and convert with a different keyword later. When a user visits your site via one search query, Google leaves a cookie to track that visitor for the next 30 days. Now, from the Analytics point of view, when a user converts, Analytics records the last keyword that user searched and converted on, rather than the first keyword Analytics reports and then tracks users with a 6 month cookie.
When you download your reports from Adwords, it’s important to look at both one-per-click and many–per-click. A lot of times, it’s easy to ignore what your many-per-click column is telling you. However, this data comes from whenever any of your conversion scripts run within the 30 days after the initial ad click.
Utilizing Analytics to Increase Your Revenue
Google Analytics provides a ridiculously wonderful amount of information, and if you’re not using it to its full potential, you could really be missing out!
- A valuable metric for ecommerce accounts is cost per visit. You can compare this metric to your Adwords CPC to make sure that your account is profitable. Cost per visit is calculated by an average of how much revenue a keyword brought in versus how many visitors it received.
- Look at revenue from organic traffic for missed opportunities. It might be beneficial to advertise on those networks too.
- What products are generating revenue? You might consider breaking these products out into their own campaigns so that you can monitor their budgets separately.
- Look at the organic keywords generating revenue for missed opportunities.
- Take a look at your day parting information. You can break down the days into hours to allocate your budget the right way during peaks and lows.
- What are your keyword positions telling you? If you go to Traffic Sources in Analytics and drill down to Keyword Positions, you can see how much revenue a term generated in various positions. I’ve seen several instances where it’s more profitable to be in say, positions 3-5 rather than the top spot.
- Take a look at what countries your sales are coming from so you can make decisions on expansion and restrictions.
Getting an Accurate View of Revenue v. Cost with Excel
As I explained earlier, your Adwords and Google Analytics data won’t match up. There’s no reason not to put in a bit of effort and pull out your data in excel to review it all side by side. A few months back, Amy had a great instructional post for how to perform a VLOOKUP in Excel to review your historical stats. You can also use this handy function to pull out your cost data from Adwords with your revenue data in Google Analytics to calculate ROI and profit loss.
Here is an overview of how to do this, but for more detailed information on VLOOKUP and Concatenate check out Amy’s article referenced above.
- Download the necessary keyword data from Adwords into an Excel workbook – pay attention the time frame you use so that you can pull matching data from Analytics.
- In Analytics, go to Traffic Sources > Adwords > Keywords. (Accounts have to be linked). Select the same time frame as what you downloaded in Adwords
- Click on the Ecommerce tab to bring up the revenue column
- In the keyword column, click the second drop down menu and select match type (see screen shot below for help) You’ll need the match type info to concatenate your columns later
- Download this keyword data into a second sheet in the same Excel workbook
- From here, you want to pull your cost information in Adwords into the Analytics sheet so that it matches up with the correct search term
- In both sheets, you’ll want to concatenate the keyword and match type. This simply combines the information so you can pull it from the other sheet. To do this create a new column and put the formula =CONCATENATE(cell,cell)
- Then go to the Analytics sheet in your workbook and create another column called “Cost” to put the VLookup function in.
- When done correctly (Vlookup is tricky until you get used to it, but it’s totally worth it) you’ll be able to see your costs and revenues right next to each other.
- Now, create yet another column next to your VLookup for calculating ROI which is (Revenue-Investment)/Investment x 100.
- Okay, last column, scout’s honor… You can also calculate your profit loss by subtracting cost from revenue
Wait! So what do I do with this information? Well, from here, you’ll be able to see which keywords you’re throwing a lot of money at for very little result, or which keywords are genuine rockstars. This process should highlight areas where you should be spending less money (or pausing entirely) and keyword areas that could be broken out into their own campaigns.
There are a lot of ways to review your revenue v. cost on Google, and it’s a very important aspect of PPC to understand, as everything we do has to have some sort of payoff. Leave your sales/revenue tips and comments below!
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.
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
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.
PPC Hero Launches New Site!
We're excited to announce the launch of a brand new PPC Hero! We've redesigned the site to be more search friendly with a better navigation system and more opportunity to find the right resources quicker.
How To Get More Out Of Excel Solver
Excel Solver is a fantastic tool, but most examples only cover simple marketing use cases. We’ll cover the next steps of enhancing your models and how to automate the process.
Where You Should Focus Your Facebook Brand Awareness Efforts
Learn the basic metrics to focus on when you want to build awareness on Facebook.
Google To Release New Shopping And Travel Features
Several upcoming changes to Google Shopping and travel-related ads can be expected in the near future. Read to find out more.