From the course: Excel for Marketers (2023)

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Common marketing metrics

Common marketing metrics - Microsoft Excel Tutorial

From the course: Excel for Marketers (2023)

Start my 1-month free trial Buy for my team

Common marketing metrics

“

- [Instructor] CPA, CPC, ROI, you're going to hear about those metrics a lot, but maybe you don't know how to calculate them yet in Excel. So, let's walk through how to do that. And here we have just some Google campaign data, Google ads spending and click-through rate, a conversion rate, et cetera. We're going to use this raw data to calculate for the whole set of campaigns what our different metrics are. So, first we're going to start with CPM. And CPM is the cost per 1,000 impressions, cost per mil is what it stands for. Mil is Latin for a thousand if you didn't know. So, the CPM is a combination of the impressions and the cost. So, let's sum up those two things. So equals sum and then we're going to select all the impressions here, control shift down or command shift down if you're on a Mac and then close that. So, now we have all the impressions summed up, 391,000. And we're going to also do the same for the cost.…

Contents