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
-
Will pausing my AdWords PPC campaigns impact my organic rankings?
Over 95% of my revenue comes from organic search; less than 5% comes from AdWords PPC (all other sources account for about 1-2%). My ROI on AdWords is roughly zero. It's negative if you include opportunity costs. My question is: if I pause all of my AdWords campaigns, is there ANY chance that my organic rankings (and organic click-through rates) will suffer? This is really two questions. First, could Google retaliate to my reduced ad spending by dropping my rankings? Second, will searchers think differently about my organic link if they don't also see the accompanying paid link on the SERP?
Paid Search Marketing | | ahirai2 -
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 -
PPC sessions being counted as organic in GA
I am coming across a very frustrating phenomenon in one of my PPC campaign reporting. In short: I believe that GA is counting some of my PPC sessions as organic (not provided). Has anybody come across this before? I believe they are being counted as organic because of the following: the website is brand new and does not rank for anything but their branded terms the few keywords showing up in GA are the terms we target our PPC towards the amount of sessions of Paid Search (in channels) and AdWords sessions don't match up (The number of actual PPC clicks is substantially higher than the Paid Search sessions) PPC clicks and sessions don't even match up in the AdWords part of GA GWT shows 0% CTR for any non branded terms Tell me I am crazy, but I really don't think I am. I just don't have the hard evidence to back it up. Any help is greatly appreciated.
Paid Search Marketing | | Rebecca.Holloway0 -
Can you market to someone 30 days AFTER they visit your site via PPC?
Hi all, I'm looking to market to visitors 30 days AFTER they have been to a website. Their is a coupon this business wants to run every 30 days to its' repeat customers (and if they purchase again); thus, 30 days more will resume. I'm aware that your remarketing list can capture audiences from 30, 60, and 90 days past. I'm talking about future display ads running 30 days after visitor has cookies enabled. Thanks for your help! Cole
Paid Search Marketing | | ColeLusby0 -
PPC - Fixing the campaign so ads always rank in positions 1 - 3
Hi everyone, I have more of a SEO background than a PPC one so excuse me if this question seems simple. I have inherited a Google Adwords campaign and want to accomplish the following Fix the campaign so the ads only appear in positions 1 – 3. The campaign came with a relatively good structure. Is there some way I can fix the settings to accomplish this? Conversion rates are high but quality scores vary from 6 -10 Thanks
Paid Search Marketing | | Carla_Dawson0 -
Cost per click on PPC
What is the best way to get a good cpc estimate other than actually running the campaign? I have had several people asking for budgets and wasn't sure how to answer. Any suggestions?
Paid Search Marketing | | ClickIt0 -
FB PPC Conversion Tracking Script
Hi guys, Is there any way to install a FB conversion script for their PPC (in the same way as the shopping directories use)? I know this was possible about 1.5-2 years ago via a feature they have released in Beta at that time, but this seem to no longer be a choice. There is nothing in the FB help, I found no such option in their settings and the FB support does not answer (what;s new here 🙂 ) We can always try alternatives - as Google Analytics or Prosper202 ... but this time we would prefer FB scripts if possible. Thanks in advance T
Paid Search Marketing | | tolik10 -
Do you take Seo and ppc management on competitor sites?
I would love to hear what everyone thinks : I wanted to know what people do about seo and ppc when the keywords and industries overlap.
Paid Search Marketing | | DavidKonigsberg0