My accounts today
Review & confirm
Your words on the left, the tidied version on the right. Confirm everything once.
Flags — last 7 days
Accounts
Supabase is master — edits here flow one way to the Google Sheet. Every change is logged with who and when.
Onboard from a document
Paste the onboarding questionnaire link. PMT reads it and fills the form — you check every field before anything is saved.
Projects
Accounts being launched, taken over, or in trouble. PMT is the master: the evening sync writes these into the Master Project Management file, and a hand edit there is overwritten and flagged here.
Problem candidates
Accounts whose daily entries reported a performance problem four weekdays in a row, and any a PM put forward. Confirm, decline, or ask for two more working days. Removals the PM has claimed as fixed wait for you first, then Affan.
Decisions
The two things only you decide: whether a stable account leaves its tab, and the second approval to remove a fixed problem account. The same items arrive in your 17:15 Slack bundle.
Performance
Account
Settings
Learnings
Notes, PDFs, Drive links and YouTube videos from our own accounts — tagged so a "try this" idea surfaces for the right kind of account. Never names an account.
Advice thresholds
The numbers every phase 4 rule runs on. Admin edits; managers read this page (an admin screen). A key left blank on an account's own Settings page uses the default here.
Reports
The retired reporting sheets, rebuilt from the account data PMT receives. Rates are worked out from each period's summed counts; totals never mix currencies. Click a row for the account's performance.
Data sources
The Google Ads scripts that send each MCC's accounts to PMT — one way, one token each. Daily at 06:00 (yesterday); Mondays the last 31 days again for corrections. Revoke stops a script on its next request.
Clean-up
Recurring rows older than two years, listed for your confirmation. Accounts, people, documents and project records are never on this page.
Reassign
Tick accounts, choose what changes and from when. The Daily Overview manager is who writes the daily entry and gets the nudges; the Account Manager stays the AM everywhere else. Every change is logged on the account.
SOPs
How we optimise, what we check and how we report. A reference for the team; only an admin edits it.
MCC / Agency partners
Basic contact info per MCC — separate from the MCC name already on each account and script token. Name it exactly the same way or the account count below won't find it.
People & settings
Adding a person here creates their login. They set their own password from a one-use link.