HVG's SKU Level Google Ads ROI Analysis Dashboard
Using this tool, is very easy.
Make sure you have access to Google Ads.
Follow the link here, or click on the button at the bottom of the page.
Select the account you want to run your analysis of as you set up the report.
Allow 1-2 minutes as the tool fetches your data to create the report.
The report is now ready, click the button that shows the report, or get the report link on the email you filled out, enjoy!
What exactly does this tool show?
It shows data from the last 30 days.
Specifically, you'll be able to get data related to:
How much did I spend on SKUs with 0 sales in the last 30 days compared to my total Ad Spend on Google Ads?
How much did I spend on SKUs with a COS of X-Y range?
COS = Cost of Sale = AdSpend/Revenue.
COS of 91% means if you sell a SKU for $50, the Ad Spend was 91% of $50, in this case Ad-Spend would be $45.5, very likely unprofitable.
How much could I save Monthly and Yearly if I stopped spending Ad Spend on items with 0 sales?
Based on the last 30 days performance of your fetched Google Ads data.
You also get an easy to digest overview of how much you've spent on Google Ads across the different SKUs based on how high their COS is:
And finally, you get a direct view on what zero sales SKUs exactly have spent your budgets:
