Here’s a sheet with all the calculations for digital marketing metrics that you might need. Check out this post if you want to know how to use some of them in Excel (and more Excel magic). If there’s any more you think need to be on here, just comment or shoot me a message!
How to Calculate Clickthrough Rate (CTR)
A key metric in all digital marketing activity. How much are people interacting with your ad or content?
How to Calculate Cost Per Click (CPC)
Another key metric, showing how much you are paying for each click to your site
How to Calculate Conversion Rate (CVR)
How often do visitors to your site complete a conversion
How to Calculate Cost per Conversion (CPA)
How much do you need to spend to drive one conversion
How to Calculate Return on Ad Spend (ROAS)
How much more revenue do you generate per dollar spent (usually displayed as whole numbers or percentage)
How to Calculate Engagement Rate (mainly for social measurement)
How often to people engage with content in some way (likes, shares, comments etc.)
How to Calculate Cost per Mille (CPM)
A display metric measuring how much you spend for 1000 impressions of your ad
