• This thread is just the tip of the iceberg.The people ahead of the curve aren't Googling for answers — they're already in here, having the conversations you haven't found yet. DealerRefresh is free.Get the full picture →

Adwords ROI formula

anthonycapital

Hanging Paper
Apr 24, 2013
65
17
First Name
Anthony
Hello,

I was reading PCGs report on AdWords and I thought I would provide a sample formula dealers can use to measure ROI.

example value.PNG

It doesn't really matter what "x" is. You can define these in google analytics and import it automatically into adwords (as value for conversion). Then look at the "All Conv. value" column.

all-conv- value.PNG

One last step. I'm sure these is a more elegant way of doing this, but:

example-ROI.PNG

Presto! You know have ROI! In this example, if you exclude Brand terms, this hypothetical campaign got a 7.7x ROI. If the expected ad cost was $500/unit, it beat expectations by 11%. Again, you can choose any value for x, just stick with it so you can compare month/month changes. x doesn't effect the ROI calculation, it only effects the percent change vs expected. This is also a good way to split apart brand terms! Your brand terms should have a 10-20x better ROI than non brand terms. (You have already paid for them! ;)

Forms and leads are statistically provable. For example for most dealers ~80 unique vdps = 1 sale.
Key page views get a little bit fuzzy - but you can always leave that off if there are any concerns.

PS! Once you have this setup Google can auto bid on this using ROAS. Hope this helps!
 
Great work AC!
Forms and leads are statistically provable. For example for most dealers ~80 unique vdps = 1 sale.
Key page views get a little bit fuzzy - but you can always leave that off if there are any concerns.

Here's an Uncle Joe traffic secret:
Look at sales divided by "VDP counts from returning visitors" (especially those who return 3x or more).

You'll find it's such a powerful indicator that you can use "VDP counts from returning visitors" as a proxy to predict future sales :)
 

✨ AI Highlights

Anthony Capital presents a practical Google AdWords ROI formula for dealers that assigns monetary values to conversions (forms, leads, page views) and calculates return on investment by comparing total conversion value against ad spend. The thread emphasizes that dealers can define and automate conversion values through Google Analytics to track performance, with the example showing a 7.7x ROI excluding brand terms. Joe Pistell adds that VDP (Vehicle Detail Page) views from returning visitors, especially repeat visitors, serve as a powerful predictor of actual sales and can be used as a reliable proxy metric for forecasting dealer performance.

Replies Views 2 2,447 Started Last Reply