Concept demo by Alex Mercer. Made-up principal and placeholder details. Not a live client setup. Back to the portfolio

Week-1 operating setup for a writer and civic lead

A first-week system for turning voice notes into tasks, staging publishing work, and keeping civic follow-ups from slipping. Example data only. Built by Alex Mercer, alexmercer.projects@gmail.com.

1. The tracker (idea to next physical step)

ItemLaneNext physical stepDone when
Raw voice notes and brainstormsCaptureOne shared Inbox folder in Drive; each memo transcribed and split into tasks the same dayEvery memo has a task list or is marked "idea only"
Newsletter, blog, and video publishingEditorialEditorial calendar sheet: piece, platform, draft link, status, publish date, assets ready (Y/N)Each piece staged on every platform it is meant for
Speaking requests and community meetingsCivicIntake note per request: who, date, ask, prep needed, travel, yes/no deadlineAnswered or declined by its deadline
Follow-ups with local stakeholdersCivicFollow-up log: person, last touch, what was promised, next dateNo promise older than 7 days without a touch
Inbox noiseAdminLabels and filters (below); one daily triage passInbox holds only "reply today" items

2. Async daily check-in (written, 3 lines; example)

Shipped yesterday: 2 drafts staged, 4 emails answered Today's top 3: speaking reply (due Fri), video description, meeting agenda Need from you (1 decision): approve Thursday's reader update

3. Inbox triage labels

  • 1 · Reply today: needs their voice; I draft, they approve
  • 2 · Waiting on: we are waiting for someone else; I chase on day 3
  • Speaking / Civic / Readers: sorted by filter, summarized weekly
  • Archive: newsletters and receipts, never deleted

4. Publishing staging checklist

  • Newsletter: title, subtitle, preview text, header image alt text, section/tags, scheduled send time, email and web both checked
  • Blog republication: import from the canonical URL, then check images and links
  • Video: title, description with links, chapters, thumbnail, captions reviewed, end screen
  • Assets: one Drive folder per piece: /Drafts /Audio /Graphics /Transcripts /Final

5. Calendar rules

  • Two protected focus blocks a day; requests offered only outside them
  • Every meeting gets a 3-line agenda the day before and notes plus owners after

Concept demo. The writer, the civic work, and every name, date and tool choice here are examples. This is a starting system, not a finished client engagement.