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 Long tail keywords
I was wondering feedback and input on creating long tail keywords associated with a question. With addition a landing page that addresses that problem with a few products. Using PPC to bid on long tail keywords, I would set a campaign for long tail keywords and have multiple ad groups with a close knit and similar sentences like "Top 10 highest rated summer dresses" and "Popular dresses for the summer weather." My landing page would address the question with a list of products like a buzz feed article format. 1. As it is on a subdomain blog with an add to cart feature, would interlink building be helpful in exchanging link juice. 2. Bidding on a long tail keyword is cheaper, but will they result in higher conversions since its hyper-specific question? And since it is a long tail keyword sentence. 2-3 smaller keywords between the sentence would also pick up on to Google search?
Paid Search Marketing | | petmkt0 -
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 -
Does sitewide SEO affect PPC Quality Score?
When evaluating a PPC landing page for Quality Score, does Google evaluate the other pages that the landing page is linked to? For example, if we have a well optimized page on the site for "Widgets", can it outscore a well optimized PPC landing page that is isolated in a "disallow" directory with no links into or out of the page? I'm not sure if I am making myself clear...
Paid Search Marketing | | CsmBill0 -
Will a javascript rewrite of city names on a home page from PPC traffic affect SEO negatively?
We have a client that was originally based out of Orlando and the entire website is SEO'ed for Orlando. In the long term we will start SEO'ing for Tampa. But In the short term, we want to drive traffic from Tampa to the website but we want that traffic to know the business specializes in Tampa service (he has local teams there). We are already using a ?_vsrefdom=changemynumber to change the phone number dynamically to a tampa area code for tracking purposes. We want to dynamically change all iterations of 'Orlando' with 'Tampa' using the same javascript. Does this cause any SEO problems or trip any alarms with Google?
Paid Search Marketing | | Highforge0 -
PPC Landing Pages and Rel Canonical
Hi Mozzers! Our company has hundreds of PPC landing pages which are essentially request a quote forms. We also have a request a quote form on our website that is for regular traffic. Currently we just added the "noindex" meta tag to all our PPC landing pages, but I think we can improve this. Should we remove the "noindex" tag, and instead add a rel canonical link pointing to our "main" request a quote form? Thoughts?
Paid Search Marketing | | Travis-W0 -
Best UK PPC management company
I'm looking to outsource my PPC management and would love some feedback on which companies are worth paying for this service? I'm worried as there are so many cold calling scam artists out there and I want to choose the best company for the job. I have been considering "Adrac" as they only charge when they save you money! Sounds too good to be true so I'm automatically sceptical. Can anyone vouch for Adrac or suggest a better/different company?
Paid Search Marketing | | niallfred0 -
SEOMOZ of PPC?
Hi The site I'd been following over the years last updated in May, so it's clearly not the authority it once was, I know there's a PPC post here about once a month but I was wondering where do the PPC brigade spend most of their time? My work is 50/50 atm but was once much more PPC focused, is there an SEOMOZ equiv. in the Paid Search world?
Paid Search Marketing | | xoffie0 -
What are the best sources for finding competitor PPC spending by category?
Can anyone provide sources for gathering paid search advertising spend for competitors, preferably by category? Thank you.
Paid Search Marketing | | JoeAmadon0