Wrap-up

Marketing Analytics in Google Sheets

Luke Pajer

Digital Marketing Specialist

Data validation

• Mitigate bad data entry
• Types of validation
  • Dropdowns
  • Text validation
  • Checkboxes
  • Many more

Regular expressions

• A special search pattern
  • Made of a sequence of characters
• How we used them
  • Modify Stings
    • REGEXREPLACE()
    • REGEXEXTRACT()
  • Aggregate by category (Sum, Average, etc...)
    • REGEXMATCH()

Building a dynamic dashboard

• Charts can be made dynamic with filtered tables powered by dropdowns
• A dashboard should be:
  • Easy to understand (For executives/clients)
  • Contain actionable insights (For strategists)

Next steps

• Try out different data validation options
• Challenge yourself with difficult regular expression tasks
• Build dashboards when possible, rather than one-off charts

Congratulations!

Marketing Analytics in Google Sheets