How do you assess PPC ROI?
-
I thought this would be pretty straightforward, but I'm trying to put together my first PPC ROI spreadsheet and it's turning out to be much more complicated than I had anticipated. Would anyone be willing to tell me what you look at to determine the return you're getting on PPC -- and if you're using AdWords and Analytics, what screens/reports you rely on? It seems to be more complex than simply comparing Paid Search Revenue to spend ... but I could be overcomplicating things.
-
To be fair in your example, the Adwords click did (on average) have some effect on the ultimate sale. If the customer never came through the door looking for red widgets, they may not have purchased the blue widgets from you? There are a few different reports in Analytics that can help you see this:
- Conversions > Multi-channel funnels > Attribution Modeling Tool (I think this is available to everyone now). If last-click interaction is by far the most important for you, you can select this in the tool and select the primary dimension of Source/Medium. Drill into Google / cpc and you should see the data you're looking for there.
- Conversions > Multi-channel funnels > Top conversion paths. Select primary dimension Source/Medium Path. This will should you the different parts that Adwords played in each conversion. You can also pick a secondary dimension of Adwords Campaign Path to see more info.
-
I'm not sure you can cover every angle or scenario.
We've found our data to be reliable enough to make good decisions.
-
How do you determine which revenue is directly attributable to AdWords?
-
Yes. Then you'll have to factor in the other costs associated with the sale like shipping, handling, discounts, etc.
There are some unknown variables such as repeat sales that are acquired from the initial conversion and/or volume purchases made after the initial conversion (assuming there are any).
-
Do you rely on AdWords' cost per conversion numbers?
-
I'm looking to compare spend to revenue from transactions that are directly attributable to that spend. So if I know how much I spent between Oct 1 and Oct 31, I want to know how much revenue resulted from those clicks. Not how many transactions occurred during that period, since that might include clicks from before Oct 1.
The problem is, AdWords includes conversions where the paid click might not actually be responsible for the transaction. If someone searches [red widgets], clicks an ad, comes to our website, leaves without purchasing, searches [blue widgets], clicks an organic result, and purchases, Analytics will correctly attribute that sale to organic. AdWords, however, will include that conversion in its cost/conv metric. Skewing the cost/conv number lower, I might add.
I've spoken with several AdWords/Analytics googlers about this, and they don't seem to know of a report that does what I want. I guess I'm wondering if others are trying to measure the same thing, or if they're comfortable with the less precise AdWords-supplied cost/conv figures.
-
I sell a downloadable product and a significant amount of my revenue is from Google adwords. We track the conversion rate of every keyword. An important factor is the click through ratio. You can get a lot of clicks and few orders. The important thing is to get the balance right. Any keyword with the word free will get a lot of clicks but very few orders.
Another important factor is to ensure that you are using negative keywords properly. On my site we sell generic set of speeches. We would have a negative keywords for therapy or disorder. Somebody looking for content to help with a speech is not interested in speech therapy or speech disorders.
Another area is to check your ROI in different countries, and only bid for clicks in countries where you can make an adequate ROI
-
Know your margins and watch the cost per conversion for your products.
Eventually, you'll get a good idea of what I call a "conversion threshold" which tells me what I can expect to spend to convert that product to a sale. From my experience, once the conversion threshold is determined, it won't deviate far from it over time.
If my net on the product is $20 and my conversion threshold is $12 then I'm making money (excluding cost for shipping, handling, promo discounts etc).
If the threshold his $18 or $22 then I re-think what to do with the product.
I'd put together a report that shows product cost, retail price, margin, net and cost per conversion. It should be quite telling.
-
I built my own Google Analytics custom reports which I export and add a few equations to in order to track ROI. I do it for a subscription site so it's not quite as complicated as it would be for an eCommerce site, where each purchase can have different items, margins, cost of goods sold, etc. What are you looking to see beyond paid search revenue to spend?
GA may be making this easier in 2013 with their "Universal Analytics" offering: http://analytics.blogspot.com/2012/10/google-analytics-summit-2013-whats-new.html.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
PPC: how to get rid of an ad appearing on a keyword we don't want?
Hi, Our ad on Google Ads is appearing for a search we don't want. it isn't in our search keywords and when i try and ad it to our negative ones, we get the error " You cannot exclude keywords that are targeted " which i assume means that google thinks we are bidding on it? We have a selection of broad phrase matches so i can only think that this is where it's coming from? Do you have any tips on tracking down which keyword is generating this ad and how we can turn it off? (we don't want to pay for clicks on this search if possible!) Btw - i have turned off each keyword in turn to test it = nothing. have then paused the whole campaign = gets rid of the ad (but this is our most successful campaign so i can't just turn it off). Any advice super super welcome. thank you!
Paid Search Marketing | | Fubra1 -
Seeking Critique on PPC Campaign Gameplan
Background: We're a home service business with potential for recurring clients. In the past, I've run PPC campaigns for a much larger company, and was profitable, but the business model was vastly different. The campaign also took place during their busy season, allowing flexibility I won't receive here. Campaign Details: AdWords only SERPs only (not partner network) Desktop users only Data Available: Lots of past data was incomplete, prompting my best estimates and judgment calls. For past leads data, I'm using Google as lead source (organic + local pack rankings), generated specifically from our quote form. Since our quote form doesn't render on Mobile/Tablet, I omitted those visits from our Analytics data, and only target Desktop in the campaign. I wound up with the following statistics: Organic (any web search), Desktop visitors who viewed our quote form page: Number of overall pageviews Number of overall leads generated from our quote form Number of overall leads which converted to sales And for our sales/numbers end of things: % our clients choose targeted package Revenue of initial sale on that package Profit generated from sale on that package Using these numbers, I calculated the % of clickers likely to bounce, complete the form, convert to clients, etc. Using our sales records, I calculated revenue/profit expected from each. And with that, I calculated the highest CPC to break even (unacceptable, obviously), as well as the projected ROI from lower, more reasonable CPCs. Notes: We're a home service business. Not all homes are created equal. Through data, I found our clients average home size and the average estimate for that home. Due to incomplete records, I can't know which Google _clients _are specific to our quote form. Some likely called through the local pack or manually dialed and said "Google" if our staff asked. To combat this, I found the % of Google _leads _who completed the quote form vs. phone call, email and applied it to clients for a reliable estimate (our system removes the quote form identifier upon lead to client conversion). I'm not factoring in the % of clients who become recurring customers as I don't have this data. Given that it's much higher than 0%, I think this allows a LOT of breathing room on my estimates. Many of our clients have stayed with us for years. If only a small number convert to long-term status, the current ROI shoots WAY up. Similar to above, I'm also not factoring in the % of clients who don't choose the initial package, but instead choose a lesser package. Again, I think this provides breathing room. Any PPC campaign will have a plethora of variables, especially intangible issues (damages, refunds, etc). I feel I have the important things down, but I'm far from an expert. I'd love to receive any advice or things I'm overlooking. Thanks.
Paid Search Marketing | | kirmeliux1 -
How to find a good PPC firm
Hi guys, I'm completely new to PPC. I want to hire a firm to help drive PPC traffic to credit card landing pages. Our starting budget is limited ($2,000/month for everything) but can grow to about $5,000 if we see results. My questions are: Where can I find a list of good PPC firms that fits my vertical (credit cards) and budget? What are the key questions I should ask a PPC firm before I hire them? Is there a "Beginner's Guide to PPC" type of whitepaper, ebook, article, or course I can take to educate myself? Thanks in advance!
Paid Search Marketing | | Brand_Psychic0 -
PPC seems to have had a seriously negative impact on organic rankings?!?
We've been targeting a keyword on behalf of a client for the last few months. The page had good content and had been steadily climbing the rankings. It reached a position of #12 and then suddenly dropped off. Within 2 weeks it was out of the top 50 and is now around the 10th or 11th page (useless). This drop off matched exactly with the cleint switching on a low level PPC campaign, driving traffic from this specific keyword. The stats on this have shown a really high bounce rate (so we'll need to ask some other questions about content) - but could this be the reason that organic stats have taken a hammering? If Google associated people landing n that page from that keyword (even though its paid) as not finding relevant content, I'm assuming this could have a negative impact on the organic rank? Any Thoughts Welcome....!!!
Paid Search Marketing | | Purestone0 -
PPC for a music shop - advice
Hi, I'm pretty new to this but I'm doing my best, so I've created a few campaigns such as 'Guitars' and 'Drums' and started to add keywords to each one such as 'buy guitars online' etc would it also be wise to add brands to this campaign? or should I create a completely different campaign focusing solely on brands? What would you recommend? Thanks, Dan
Paid Search Marketing | | Sparkstone0 -
Recommend a PPC book
Hello everyone, I recently read Danny Doves book, Search engine optimisation secrets, and loved it. I was wondering if anyone had read a similar book on the PPC side which they could recommend that touches on similar topics such as advanced techniques but also the practical side such as billing and dealing with customers etc...
Paid Search Marketing | | RikkiD220 -
Tagging Bing PPC
I am trying to tag my bing cpc in GA using the URL builder tool: http://www.google.com/support/analytics/bin/answer.py?answer=55578 It is incredibly tedious, and in order to get to the level of adwords, I have to create a unique URL for each keyword! Ahh, please tell me there is a better way!
Paid Search Marketing | | QuickLearnTraining0 -
Recommended tools for PPC competitive intelligence?
Do you guys have any tools you recommend for spying on your PPC competition? Trying to figure out which competitive intelligence tool offers the most value. http://searchengineland.com/tips-for-spying-on-your-ppc-competitors-89988
Paid Search Marketing | | qlkasdjfw0