The importance of clean data entry

Marketing Analytics in Google Sheets

Luke Pajer

Digital Marketing Specialist

Campaign performance spreadsheet

  • Entry Date (Date)
  • Source (String)
  • Campaign Name (String)
  • Impressions (Integer)
  • Clicks (Integer)
  • Click-Through Rate (CTR) (Percent)
1 https://support.google.com/
Marketing Analytics in Google Sheets

The data problem

example data set

Marketing Analytics in Google Sheets

The data problem

Marketing Analytics in Google Sheets

The solution: data validation

Validation message

  • Appears for valid cells
  • Provides more criteria
  • Optional in data Validation settings

Invalid message

  • Appears in flagged cells
  • Explains why the cell is flagged

Marketing Analytics in Google Sheets

Let's get to work!

Marketing Analytics in Google Sheets

Preparing Video For Download...