Simple ROI Optimization

Posted under ppc, CPC, ROI, excel, analytics

Want a quick and easy way to max out your ROI?  Here is my quick tip…

Get your reports into excel in whichever manner you choose, (export to .csv, copy and paste, etc…)

Excel is smart enough to sort by equations and return only the results that fit the ‘answer’.  Set up custom sorting for the ROI and CPC columns.  Use a formula to return all results with a greater than average ROI and a less than average CPC.

The results will show you the keywords being bid for that are performing extremely well.  Go back into your paid search platform of choice and adjust your bids & budgets to focus on those keywords.

Sit back and get ready to make some more money!