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 -
Are there any recent studies of organic CTR vs. PPC CTR?
Pretty much the title. I am putting together a "game plan" for my CEO, where I would like to touch on the difference in CTR between SERP organic results and SERP PPC results. I've found a few blog posts that talks about PPC being responsible for 15% of all clicks, where 1-5 organic results are responsible for 68ish % and the rest being on 6-10 and page 2/3. However, I do not see any sources in these articles, which begs the question, where are these numbers taken from? Any suggestions? My own gut feeling (and SERP behaviour) tells me that these numbers might actually be super accurate, but since my business plan will most likely end up in the hands of our board of directors, I would very much like to back up my action points for growth, with actual sources. Thanks in advance.
Paid Search Marketing | | Nikolaj-Landrock1 -
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 - 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 -
Adwords Search with Display select. Better ROI than just Adwords Search only?
What is your experience running Adwords Search with Display select? Are you getting a better ROI then just running Adwords Search only?
Paid Search Marketing | | marketvantageteam0 -
PPC Billing
I'd like to add PPC as a service for my company. However I'm at a loss as to how to charge for it. I've received cold calls from those "SEO guys" charging $200 for PPC services. But I doubt that they're very profitable or even ethical. For you PPC guys, are you billing hourly on top of the campaign, and how are you outlining this for your customers? Thanks!
Paid Search Marketing | | WilliamBay0 -
Starting Fresh with a New PPC Account
I've inherited an Adwords account with a few years' worth of history. The account has changed hands a lot though and there's a lot of clutter and confusing account architecture (confusing and redundant campaigns, thousands of inactive long-long-tail keywords for every match type, etc.). I have a new architecture/strategy in mind but I'm unsure if I should start a new account from scratch, pause 90% of things and start some new campaigns, or delete a bunch of stuff permanently and start some new campaigns. My fear with the pausing option is that I'll have to wade through a bunch of clutter in my daily management and reporting - I like to keep things clean. My fear with deleting is losing data - I'd like to be able to always look back at how things were. And my fear with the new account from scratch method is losing whatever account/campaign quality score or historical value the account has built over time and the logistics of having to stop the old account to create a new account. Can you even have 2 accounts with the same domain or would I have to delete the old account before launching the new? For all my past PPC accounts, I started them more or less from scratch so this is new to me. Any advice/insights would be most appreciated. Thanks! Jeff
Paid Search Marketing | | jeff.gibson0 -
PPC ad guidelines?
I learned Google PPC years ago and got certified by Google. Back then and for a long time since I know it was best practice to capitalize words in your domain name. I know Google no longer does this and that words in your domain name of your ad are now all lowercase. I hear recommendations and see them practice that adding keywords in a directory are a good way to still get capitalized words in your ad. When I learned PPC, I was told your display URL and your destination URL had to match. Now I'm seeing ads where that is not the case. If I have an ad that takes someone to my homepage of a coupon site, can I have a display URL that says: mysite.com/Coupons Even if the destination URL is just mysite.com ? I'm seeing conflicting things online and it's hard because I don't know what the current guidelines are after this change.
Paid Search Marketing | | DanDeceuster0