Campaign Type Mapping in Sheets + BigQuery
Campaign naming conventions can be a mess.
We use a combination of a Google Sheets Tracking Plan + Google BigQuery data warehouse to wrangle this problem out of existence.
Drop us a note in the comments (or in our Slack group, accessible from the footer at codingisforlosers.com) to see how you could implement this mapping structure for your team.