Better Sheets All add-ons

CPM Custom Function

Custom Function for Google Sheets™

Built by Better Sheets · Free on the Google Workspace Marketplace · No account needed

What CPM Custom Function does

CPM adds one formula to Google Sheets: =CPM(cost, views). It gives you the cost per 1,000 views (cost per mille) in any cell. $500 for 1,000,000 views is a CPM of $0.50.

  • ✅ Compare ad costs fairly, even when the costs and view counts are very different.
  • ✅ Works for any unit: views, impressions, listeners, subscribers or units.
  • ✅ To use it, type =CPM(B1, B2), where B1 is the cost and B2 is the views.
The CPM formula: $500 for 1,000,000 views is $0.50

How CPM Custom Function uses your Google data

  • Adds the =CPM() custom function to your spreadsheet, so you can work out cost per thousand impressions in any cell.
  • Reads only the numbers you pass to =CPM() and returns the result in that cell.
  • Runs entirely inside Google Sheets. It does not send your spreadsheet data anywhere else.

Google permissions it asks for

See and change the spreadsheet it is installed in https://www.googleapis.com/auth/spreadsheets.currentonly
Show its menu and sidebar inside Google Sheets https://www.googleapis.com/auth/script.container.ui

Full details: CPM Custom Function Privacy Policy · Terms of Service