Step 1: Google Cloud Setup (one-time)
- Go to Google Cloud Console → select your project
- Enable the Google Sheets API
- Use your existing OAuth Client ID (or create one: APIs & Services → Credentials → OAuth 2.0 Client ID, Web application)
- Add your dashboard URL to Authorized JavaScript origins (e.g.
http://localhost:8000)
Step 2: Ticket Sales Sheet
Create a Google Sheet with one tab per event. Each tab layout:
- Row 1: A1="Event", B1=event name, D1="Event Date", E1=date, F1="City: SA" or "City: HOU"
- Row 2: blank
- Row 3: headers — Report Date | Calls | Tickets Online (GA ON)
- Row 4+: daily data. The last row's ticket total is the final attendance count.
Step 3: Campaign Data Sheet
- Create a new Google Sheet with columns: Date | Platform | Campaign | Impressions | Clicks | Cost
- For Google Ads: install the official Google Ads add-on and schedule automatic refresh
- For Meta Ads: add rows manually from Meta Ads Manager, or use Google Apps Script
- Set the Platform column to "Google" or "Meta" for each row
City detection: The dashboard reads the City field from each ticket tab's Row 1 (F1). Campaigns can also be tagged with "SA-" or "HOU-" prefix for city filtering.
2 separate sheets = separate access. The ticket entry person never sees ad spend. Only people you share each sheet with can see its data.