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

A free Google Sheets™️ Add-On to calculate cost per mille inside any cell of your spreadsheet.

  • ✅ Calculate Costs
  • ✅ Compare Costs across ad spend
  • ✅ Analyze your best performing ads
CPM custom function in action on a sheet

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