Rotary Market Research Program · SOP
For: Chau Phan, Ela Requinto, and the VA who runs the sequence
Built: 2026-09-24 from Tim's plan of the same day
Status: Tim calls this eight tenths done. It gets finished with Chau at the Tuesday call, 2026-09-29. Everything to confirm is in section 9.
One source, many views. This SOP says WHO does each step, WHEN, HOW MANY, and in what ORDER. It never copies the words people say. The words live in exactly two files:
| File | Holds | Used by |
|---|---|---|
2_Rotary_VA_Outreach.md (called SEQUENCE below) |
Every email, the VA call script, the voicemail, the text, booking words, outcome codes | The VA |
1_Rotary_Call_Script.md (called CALL SCRIPT below) |
Chau's call, Step 1 to Step 12, the branch, the row rules | Chau |
If a section number below does not match the file, find the section by its name. Both files were being revised on 2026-09-24.
Tim's plan, his words, 2026-09-24:
"ask why they stopped going. ask what they need to start going. ask what problems they have in business. ask what goals they have. if the door opens use it. if not just grow the group and trust compounding interest and market data."
"email, follow up email, phone call, text message, last call email. It's the structure."
"the VA's job is to set an appointment with Chau, and it's just market research."
1. PRIORITY
FIRST: this program. It is "the one that compounds the most over time": every call grows Rotary, and every call puts a business owner's own words about their problems into the tracker.
WAITS: the cold emails for the four priority two avatars (optometry and dental, vet, DME and home health, CPA and bookkeeping). They run second, and they are written from the quotes this program collects (the VOC_FEED tab, Step 9).
2. ROLES
| Who | Does | Hands off to |
|---|---|---|
The VA [AWAITING FROM CHAU: VA name] |
Loads the tracker. Sends every touch in the sequence. Makes the VA calls. Books Chau's calls. Sends every confirmation and reminder. Logs every touch the same day. | Chau, the moment a call is booked |
| Ela Requinto, VA leader | Builds the tracker and the SETUP numbers. Checks the sheet every workday. Runs the Friday numbers and the VOC_FEED. | Chau, every Friday |
| Chau Phan | Gives the list. Holds her two weekly slots. Holds every call, recorded. Logs the row. Sends every RMB invite. Handles the door and books the sales call live. Reads the Friday numbers. | Tim, at the Tuesday coaching call |
| Tim Winfrey | Reads the numbers at the Tuesday coaching call. Owns no step. |
Every step, one name
| Step | What | Runs it | Checks it |
|---|---|---|---|
| 0 | Clear the gate | Chau | Ela |
| 1 | Get the list | Chau | Ela |
| 2 | Load the tracker | Ela builds, VA loads | Ela |
| 3 | Run the sequence, per person | VA | Ela, every workday |
| 4 | Book the call with Chau | VA | Ela, every workday |
| 5 | Hold the call | Chau | |
| 6 | Log the row | Chau | Ela, every Friday |
| 7 | Send the RMB invite | Chau | Ela, every Friday |
| 8 | Handle the door | Chau | Ela, every Friday |
| 9 | Weekly review | Ela | Chau reads it, Tim sees it Tuesday |
3. EVERY STEP, IN ORDER
Order for the VA inside any one workday, highest first:
- Replies and callbacks (Step 3.7). A person who wrote back is ready now.
- Booking, confirmations and reminders (Step 4).
- Follow ups due today: Email 2, call 1, text, call 2, last call email (Steps 3.2 to 3.6).
- New starts, Email 1 (Step 3.1).
If the shift runs out, what drops is item 4, never items 1 to 3. Missed new starts get added to the next workdays (Step 9).
STEP 0 · CLEAR THE GATE
- WHAT: Replace every
[AWAITING ...]tag in SEQUENCE and CALL SCRIPT, and tick every box in SEQUENCE § 8 BEFORE THE FIRST SEND. - HOW:
- At the Tuesday call, Chau answers every item in section 9 of this SOP, out loud.
- Ela types each answer into the file, at the tag, the same day.
- Chau confirms the sending address exists, her Fathom recording works, and her two weekly slots are on her calendar.
- Ela searches both files for the word
AWAITING.
- WHEN AND HOW MANY: Once, before the first Email 1. Every tag, zero left.
- DONE WHEN: Ela's search finds zero
AWAITINGin both files, and all five boxes in SEQUENCE § 8 are ticked. Nothing sends before this.
STEP 1 · GET THE LIST
- WHAT: The list of former D5170 members Chau may contact as membership chair.
- HOW:
- Pull the names from the source Chau confirms in Step 0 (
[AWAITING FROM CHAU: source of the contact list, and who is allowed to hold it], the same tag as SEQUENCE § 8). - Keep five fields only: first name, last name, club, email, phone.
- Mark the people who left for business obligations
Priority 1(the 2026-09-17 decision: these come first). Everyone else isPriority 2. - ⛔ Never copy the termination reason, the member record, or any other field into the list. Chau's line of 2026-09-17 holds: "I can't export that and use it for my market research." The priority mark is the only trace of the reason, and it says nothing about the person.
- Count the rows. That count is N.
- Send the file and N to Ela.
- Pull the names from the source Chau confirms in Step 0 (
- WHEN AND HOW MANY: Once, within 2 workdays after Step 0.
- DONE WHEN: Ela has one file with N rows and six columns (the five fields plus priority), and N is typed into the SETUP tab.
STEP 2 · LOAD THE TRACKER
2A · Ela builds the sheet.
- WHAT: One sheet with four tabs:
TRACKER,SETUP,WEEKLY,VOC_FEED(section 6). - HOW:
- Create
TRACKERwith the 39 columns in section 6, in that order, as row 1. - Create
SETUPand fill: N, the window (30 or 90 days), W, daily starts, weekly starts, the booking rate assumption, calls per week, the first start date, every RMB evening date inside the window, Chau's two weekly slots, the VA's name. Use the formulas in section 4. - Create
WEEKLYwith the columns in section 7, one row per week. - Create
VOC_FEEDwith the columns in section 6.
- Create
- WHEN AND HOW MANY: Once, the same day the list arrives.
- DONE WHEN: Four tabs exist, and SETUP shows daily starts as a whole number.
2B · The VA loads the names.
- WHAT: One row per person in
TRACKER. - HOW:
- Paste the list into columns B to F (Name, Club, Email, Phone, Priority).
- Remove duplicates: same email or same phone means the same person. Keep one row. Type the number removed into SETUP.
- Fill column A (Row #, 1 to the last row), column G (Source) with
CHAU_LIST, and column H (VA) with your name. - Sort: all
Priority 1rows on top, thenPriority 2. - Leave every other column blank.
- WHEN AND HOW MANY: Once, within 1 workday after 2A. All N rows.
- DONE WHEN: TRACKER row count equals N minus the duplicates removed, and every row has Row #, Priority, Source and VA filled.
STEP 3 · RUN THE SEQUENCE, PER PERSON
Rules on every touch: SEQUENCE § 0 RULES THE VA FOLLOWS ON EVERY TOUCH. Read it before your first shift.
The schedule. Day numbers are business days, Mon to Fri, per SEQUENCE § 6 TIMING TABLE. When you finish a touch, type the next touch and its date into columns N (Next step) and O (Next step date). The date comes from this table, or from the formula in section 6.
| Started (Email 1) | Email 2 (Day 3) | Call 1 (Day 5) | Text (Day 6) | Call 2 (Day 8) | Last call email (Day 10) |
|---|---|---|---|---|---|
| Monday | Wednesday | Friday | next Monday | next Wednesday | next Friday |
| Tuesday | Thursday | next Monday | next Tuesday | next Thursday | Monday, week 3 |
| Wednesday | Friday | next Tuesday | next Wednesday | next Friday | Tuesday, week 3 |
| Thursday | next Monday | next Wednesday | next Thursday | Monday, week 3 | Wednesday, week 3 |
| Friday | next Tuesday | next Thursday | next Friday | Tuesday, week 3 | Thursday, week 3 |
Time zone. Recipients are Pacific. Manila is 15 hours ahead of Pacific until Sunday 2026-11-01, and 16 hours ahead after that. So 8:00 am Pacific is 11:00 pm Manila now, and midnight Manila after November 1.
3.1 · SEND EMAIL 1
- WHAT: First touch to the next [daily starts] rows with a blank Start date, top down.
- HOW: SEQUENCE § 1 EMAIL 1. One email per person. Fill
{first_name}and{club}, and the RMB evening from SETUP (the next date on the list). Send, or schedule it to land 8 to 10 am Pacific. Then log: Start date = today, Last touchE1, Last touch date = today, OutcomeSENT, Next stepE2, Next step date from the table. - WHEN AND HOW MANY: Every workday, Monday to Friday, [daily starts] people (section 4), landing 8 to 10 am Pacific.
- DONE WHEN: [daily starts] rows show
E1with today's date.
3.2 · SEND EMAIL 2
- WHAT: Follow up to every row with Next step
E2due today and no reply. - HOW: SEQUENCE § 2 EMAIL 2 (FOLLOW UP), as a reply in the same thread as Email 1. Log
E2, Next stepCALL, date from the table. - WHEN AND HOW MANY: Every workday, every row due today, landing 8 to 10 am Pacific.
- DONE WHEN: Zero rows show Next step
E2with a date of today or earlier.
3.3 · MAKE CALL 1
- WHAT: Phone call to every row with Next step
CALLdue today and no reply. - HOW: SEQUENCE § 3.1 Live script. No answer: leave the SEQUENCE § 3.2 Voicemail. For what people say, use SEQUENCE § 3.3 Short answers. Log
CALL(they answered) orVMwith OutcomeNO_ANSWER_VM. Type anything they said into Their words, in quotes. They said yes: go to Step 4 now. No answer: Next stepTXT, date from the table. - WHEN AND HOW MANY: Every workday, every row due today, inside a call window: 8:30 to 10:00 am or 4:00 to 5:30 pm Pacific. Write which window you used in Their words (
AMorPM) so call 2 goes in the other one. - DONE WHEN: Zero rows show Next step
CALLwith a date of today or earlier.
3.4 · SEND THE TEXT
- WHAT: Text to every row with Next step
TXTdue today, where call 1 did not connect. - HOW: SEQUENCE § 4 TEXT MESSAGE. Only after call 1 and the voicemail happened. Never before. Log
TXT, Next stepCALL2, date from the table. - WHEN AND HOW MANY: Every workday, every row due today.
- DONE WHEN: Zero rows show Next step
TXTwith a date of today or earlier.
3.5 · MAKE CALL 2
- WHAT: Second call to every row with Next step
CALL2due today and still no answer, reply or opt out. - HOW: SEQUENCE § 3.4 Second call attempt, in the other call window from call 1. No voicemail. Log
CALL2, OutcomeNO_ANSWERif nobody picks up, Next stepE3, date from the table. - WHEN AND HOW MANY: Every workday, every row due today.
- DONE WHEN: Zero rows show Next step
CALL2with a date of today or earlier.
3.6 · SEND THE LAST CALL EMAIL
- WHAT: Last touch to every row with Next step
E3due today and still no reply. - HOW: SEQUENCE § 5 LAST CALL EMAIL, as a new email, not a reply. Log
E3, OutcomeSEQUENCE_DONE, Next stepnone, Next step date blank. - WHEN AND HOW MANY: Every workday, every row due today, landing 8 to 10 am Pacific.
- DONE WHEN: Zero rows show Next step
E3with a date of today or earlier.
3.7 · ANSWER EVERY REPLY
- WHAT: Every email reply, text reply, returned call and voicemail from a person on the list.
- HOW: SEQUENCE § 0 rule 5. Type their words into Their words, in quotes. The first time they reply or answer live, type today's date into Reached. Then:
- Yes to a call: Step 4, now.
- Not now: thank them. Outcome
REPLIED_LATER. Next stepcheck backwith their date, only if they gave one. On that date, send one short note offering two times (SEQUENCE § 7.1). No date given: Next stepnone. - No, or take me off: Outcome
OPT_OUT(orREPLIED_NO), Do not contactY, Next stepnone. Never touch the row again. - Wants the RMB evening but not the call: Outcome
RMB_ONLY, RMB interestY, Next stepRMB invite (Chau), Next step date today. Chau sends it (Step 7). - Email bounced: Outcome
BOUNCED. Keep going on the phone and text touches on their normal dates. No phone either: OutcomeSEQUENCE_DONE. - Wrong number: Outcome
WRONG_NUMBER. Skip the calls and the text, keep the emails on their normal dates.
- WHEN AND HOW MANY: First thing every shift, before any other touch. All of them.
- DONE WHEN: At the end of the shift, the inbox, the text app and the voicemail have zero unanswered messages from people on the list.
3.8 · ELA'S DAILY CHECK
- WHAT: Proof that today's touches happened and were logged.
- HOW:
- Filter TRACKER: Next step date is today or earlier, Next step is not
none, Do not contact is blank. - The filter should return only rows waiting on Chau (
Chau call,RMB invite (Chau)). Any VA row that shows up is a missed touch. Message the VA with the Row #s. - Count rows with Start date = today. It should equal daily starts.
- Type today's date into SETUP, "Last daily check".
- Filter TRACKER: Next step date is today or earlier, Next step is not
- WHEN AND HOW MANY: Every workday, at the end of the VA's shift. Every row.
- DONE WHEN: The filter shows zero VA rows, and SETUP shows today's date as the last daily check.
STEP 4 · BOOK THE CALL WITH CHAU
- WHAT: Turn every yes into a time on Chau's calendar.
- HOW:
- SEQUENCE § 7.1 What the VA says to lock a time. Offer two specific times inside Chau's two weekly slots (SETUP tab). Never a calendar link.
- Ask phone or Zoom. Confirm the number or email, and their time zone.
- Ask the recording question in SEQUENCE § 7.1.
- Put the call on Chau's calendar (
[AWAITING FROM CHAU: how the VA puts calls on Chau's calendar]). Title: their name and club. Body: Row #, phone number or Zoom link. - Send the confirmation in SEQUENCE § 7.1, within one hour.
- Log: Booked (day and time), Booked on (today), Format, Recording OK, Outcome
REPLIED_YESorCONNECTED_BOOKED, Next stepChau call, Next step date = the call date. - The workday before the call: send the reminder text in SEQUENCE § 7.1.
- No show (SOP default, confirm Tuesday): the same day, send one short email offering two new times. They miss the second one too: Outcome
SEQUENCE_DONE, Next stepnone.
- WHEN AND HOW MANY: Every yes, within one hour of seeing it during the shift. Reminders the workday before each call.
- DONE WHEN: Every yes row has Booked and Booked on filled, a confirmation sent within the hour, and a reminder sent the workday before.
STEP 5 · HOLD THE CALL
- WHAT: A 15 to 20 minute recorded market research call.
- HOW:
- Two minutes before: open the row. Read the VA's Their words column so you know what they already said. Start Fathom.
- Run CALL SCRIPT Step 1 to Step 11, in order, keeping THE RULES FOR THE WHOLE CALL and Lines Chau never says.
- Consent: CALL SCRIPT Step 1, out loud, before the first question (also SEQUENCE § 7.1, the recording consent note). A no means stop Fathom and take notes by hand.
- Health, family, a loss or a move: go to CALL SCRIPT THE BRANCH.
- Keep to CALL SCRIPT The clock. Running long: protect Steps 6 and 7.
- WHEN AND HOW MANY: Only inside your two weekly slots,
[AWAITING FROM CHAU: two open time slots each week for these calls]. Every booked call. The weekly count is in section 4. - DONE WHEN: A Fathom recording exists (or handwritten notes, if they said no), and Call held has today's date.
STEP 6 · LOG THE ROW
- WHAT: Their words, in the tracker, before the next call.
- HOW:
- CALL SCRIPT Step 12 AFTER THE CALL, 5 MINUTES, minute by minute, following The rules for the row.
- Fill columns W to AI (section 6), and Next step (column N) using the Step 12 list.
- Fill Call held (today) and Avatar:
OPT_DENTAL,VET,DME_HH,CPA_BK, orOTHER. - Names they gave you at "who comes to mind": add one new row per name at the bottom of TRACKER. Source =
referral: [the person who named them]. Add whatever contact details they gave. The VA starts them like any other row.
- WHEN AND HOW MANY: Within 5 minutes of hanging up, before the next call. Every call.
- DONE WHEN: Columns W to AI have no blank cell for that row (
not askedandnot saidcount as filled), and the recording link is pasted.
STEP 7 · SEND THE RMB INVITE
- WHAT: The invitation to the next Rotary Means Business evening.
- HOW:
- On the call, at CALL SCRIPT Step 8, send it while you are still on the phone. (Tim's plan names Chau as the sender. The channel is open:
[AWAITING FROM CHAU: who sends the mixer details, you or the VA, and by text or email].) - It carries: the date, the time, the place, the format, any cost, that they come as your guest, and how to reply.
- Also send one to every row showing Next step
RMB invite (Chau). The VA put those there from Step 3.7. - Log Invitation sent as
Y [date]orN [reason]. OnRMB invite (Chau)rows, change Next step tonone. - The workday after each RMB evening, type that evening's date into RMB attended for every person on the tracker who came.
- On the call, at CALL SCRIPT Step 8, send it while you are still on the phone. (Tim's plan names Chau as the sender. The channel is open:
- WHEN AND HOW MANY: During every call, and the same day for every
RMB invite (Chau)row. Attendance within one workday after each evening. - DONE WHEN: Every row with a call held or
RMB_ONLYhas Invitation sent filled, and every RMB evening has its attendees marked by the next workday.
STEP 8 · HANDLE THE DOOR
- WHAT: Raise the business once, with the out. On a yes, book the separate call before hanging up.
- HOW:
- CALL SCRIPT Step 9 THE DOOR, WITH THE OUT. Route A or Route B, never both, following The rules for the door.
- Yes: CALL SCRIPT Step 10. Book the one part sales call live, on this call, and put it on your calendar. Fill Sales call booked on (today) and Next step
sales call booked [date]. - No: CALL SCRIPT Step 11 THE WARM CLOSE.
- Heavy call: skip it, per CALL SCRIPT THE BRANCH.
- Log Door opened per CALL SCRIPT Step 12, rule 5.
- The sales call itself runs outside this SOP. Tim's rule for it: "get their exact number of what they think they need."
- WHEN AND HOW MANY: Once per call, at about minute 17.
- DONE WHEN: Every held call has Door opened filled, and every
Yrow has a sales call date booked before the call ended.
STEP 9 · WEEKLY REVIEW
- WHAT: The week in seven numbers, and the week's quotes handed to the priority two cold emails.
- HOW:
- Ela, Friday: run the 3.8 daily check across the whole week.
- Ela: fill one row on WEEKLY with the seven numbers in section 7, using the COUNTIFS in section 6. Add the SEQUENCE § 7.2 Friday totals (emails sent, dials, answers of 2 minutes or longer, calls requested, calls booked, RMB yes), counted from the sent folder and the phone log.
- Ela: people started this week fewer than 5 × daily starts? Spread the shortfall across next week's starts and type the new number into SETUP.
- Ela, from the end of week 2: replace the booking rate assumption in SETUP with the real one (section 4).
- Ela: copy every row whose call was held this week and whose Avatar is not
OTHERinto VOC_FEED. These rows are the market research for the priority two cold emails. - Ela: message Chau: "WEEKLY is filled", with the seven numbers in the message.
- Chau: read the row before Tuesday. For any low number, read its line in section 7. Bring the row to the Tuesday coaching call.
- WHEN AND HOW MANY: Every Friday, by the end of Ela's shift. Chau reads it by Monday. Tim sees it Tuesday.
- DONE WHEN: WEEKLY has this week's row with all seven numbers, VOC_FEED has this week's rows, and Chau has the message.
4. VOLUME MATH
Tim: "If there are hundreds of people, we just divide it. Let's see if we could knock it out in the next 30 days. If there are thousands of people, we divide it over three months."
The formula
| Line | Formula |
|---|---|
| N | Names on the tracker after duplicates are removed |
| Window | N under 300: 30 days = 4 weeks = W = 20 working days. N of 300 or more: 90 days = 13 weeks = W = 65 working days. |
| Holidays | Subtract every US holiday that falls on a weekday inside the window from W. A 90 day window starting in October holds Thanksgiving (Thursday 2026-11-26) and Christmas (Friday 2026-12-25). The worked examples below ignore holidays. |
| Daily starts (d) | N ÷ W, rounded up |
| Weekly starts | 5 × d |
| Last start | Working day N ÷ d, rounded up |
| Booking rate (B) | ⚠ ASSUMPTION: 10% of people started book a call with Chau. Replace with the real number after week 2 (below). |
| Calls per week for Chau | Weekly starts × B. This is the steady state from about week 3. Bookings trail the start by up to 10 business days. |
| Calls per slot | Calls per week ÷ 2 |
| Chau's hours per week | Calls per week × 30 minutes (CALL SCRIPT The clock, about 20 minutes, plus 5 minutes for Step 12, plus 5 minutes spare) |
| VA actions per workday | Up to 6 × d once the pipeline is full (week 3 on). Each person gets up to six actions: Email 1, Email 2, call 1, text, call 2, last call email. |
| VA minutes per workday | ⚠ ASSUMPTION: 14 minutes per person across the whole sequence (2 minutes per email, 3 per call, 1 for the text, 1 for logging). d × 14. Replace with the VA's real time after week 1. |
| Total calls | N × B |
| End of the program | The window is the START window. The last last call email goes out 9 business days after the last start, and the last calls land a week or two after that. |
Why 10%, and why it is only an assumption. No published booking rate exists for this exact motion (NOT FOUND in the reactivation research). The nearest vendor numbers are 15 to 30% participation in win loss interviews (Clozd) and 32 to 39% engagement from lapsed association members (PropFuel). 10% sits below both on purpose, because these people left.
Replacing it with the real number. At the Friday review of week 2, Ela computes: people from week 1 who booked ÷ people started in week 1. Some week 1 rows are still one to four days short of their last touch, so treat it as a first read. Recompute every Friday using only rows started at least 10 business days ago. Type it into SETUP and every number below it updates.
Capacity check. If calls per slot × 30 minutes is longer than a slot, tell Chau on Tuesday.
Worked examples
| N = 150 | N = 500 | N = 2,000 | |
|---|---|---|---|
| Window | 30 days | 90 days | 90 days |
| W | 20 | 65 | 65 |
| Daily starts, d | 150 ÷ 20 = 7.5, so 8 | 500 ÷ 65 = 7.7, so 8 | 2,000 ÷ 65 = 30.8, so 31 |
| Weekly starts | 40 | 40 | 155 |
| Last start | working day 19 | working day 63 | working day 65 |
| Calls per week at 10% (assumption) | 4 | 4 | 16 (15.5 rounded up) |
| Calls per slot | 2 | 2 | 8 |
| Chau's hours per week | 2 | 2 | 8 (4 hours per slot) |
| Total calls at 10% | 15 | 50 | 200 |
| VA actions per workday, full pipeline | up to 48 | up to 48 | up to 186 |
| VA time per workday (assumption) | about 1 hour 50 minutes | about 1 hour 50 minutes | about 7 hours 15 minutes |
How far off the assumption can be. Calls per week for Chau at other booking rates:
| Booking rate | N = 150 | N = 500 | N = 2,000 |
|---|---|---|---|
| 5% | 2 | 2 | 8 |
| 10% (the assumption) | 4 | 4 | 16 |
| 20% | 8 | 8 | 31 |
5. WEEKLY RHYTHM
The week is Monday to Friday. All times Pacific.
The VA, every workday, in this order: (1) replies, (2) booking, confirmations and reminders, (3) follow ups due today, (4) new starts. Emails land 8 to 10 am. Calls go 8:30 to 10:00 am or 4:00 to 5:30 pm.
| Day | The VA | Ela | Chau |
|---|---|---|---|
| Monday | Daily block. [daily starts] new starts. | Daily check at the end of the VA's shift. | Confirm this week's two slots are still clear. |
| Tuesday | Daily block. [daily starts] new starts. | Daily check. | Coaching call with Tim. Bring last Friday's WEEKLY row. |
| Wednesday | Daily block. [daily starts] new starts. | Daily check. | |
| Thursday | Daily block. [daily starts] new starts. | Daily check. | |
| Friday | Daily block. [daily starts] new starts. | Daily check, then the weekly review (Step 9). | Read the WEEKLY row. |
Slot 1 [AWAITING FROM CHAU: day and time] |
Reminder texts sent the workday before. | Hold the booked calls (Step 5), log each row within 5 minutes (Step 6), invite during the call (Step 7), door once (Step 8). | |
Slot 2 [AWAITING FROM CHAU: day and time] |
Reminder texts sent the workday before. | Same as slot 1. |
The first two weeks ramp. Week 1 has only Email 1, Email 2 and some first calls. Week 2 adds the texts, second calls and last call emails. From week 3 the VA runs every touch type every day, and Chau's calls reach the weekly number in section 4.
6. THE TRACKER
Where it lives: [AWAITING FROM CHAU: where the tracker lives, a Google Sheet or GoHighLevel] (CALL SCRIPT Step 12). The formulas below are written for a Google Sheet.
One row per person. Every column from SEQUENCE § 7.2 and every column from CALL SCRIPT Step 12 The row is here. Name, Club and Next step are shared by both. Columns marked SOP are added so the numbers in section 7 can be counted.
TRACKER tab
| Col | Column | Filled by | From | What goes in it |
|---|---|---|---|---|
| A | Row # | VA | SOP | 1, 2, 3 ... |
| B | Name | VA | SEQUENCE, CALL SCRIPT | First and last |
| C | Club | VA | SEQUENCE, CALL SCRIPT | The club they belonged to |
| D | VA | SEQUENCE (Email / Phone, split) | As provided | |
| E | Phone | VA | SEQUENCE (Email / Phone, split) | As provided |
| F | Priority | VA | SOP | 1 or 2, from Chau's list |
| G | Source | VA | SOP | CHAU_LIST or referral: [name] |
| H | VA | VA | SOP | The VA who owns the row |
| I | Start date | VA | SEQUENCE | Date Email 1 went out |
| J | Last touch | VA | SEQUENCE | E1, E2, CALL, VM, TXT, CALL2, E3 |
| K | Last touch date | VA | SEQUENCE | Date |
| L | Outcome | VA | SEQUENCE | One code from SEQUENCE § 7.2 Outcome codes |
| M | Their words | VA | SEQUENCE | Anything they said or wrote, word for word, in quotes |
| N | Next step | VA, then Chau | SEQUENCE, CALL SCRIPT | VA: E2, CALL, TXT, CALL2, E3, Chau call, RMB invite (Chau), check back, none. After the call, Chau writes one from CALL SCRIPT Step 12 rule 6. |
| O | Next step date | VA, then Chau | SOP | The date N is due |
| P | Reached (date) | VA | SOP | Date of their first reply or first live answer |
| Q | Do not contact | VA | SEQUENCE | Y or blank |
| R | Booked | VA | SEQUENCE | Day and time of the call with Chau |
| S | Booked on (date) | VA | SOP | The date the booking was made |
| T | Format | VA | SEQUENCE | Phone or Zoom |
| U | Recording OK | VA | SEQUENCE | Y, N, or blank |
| V | RMB interest | VA | SEQUENCE | Y, N, MAYBE |
| W | Left when | Chau | CALL SCRIPT | |
| X | Why they left (their words) | Chau | CALL SCRIPT | In quotes |
| Y | What would bring them back (their words) | Chau | CALL SCRIPT | In quotes |
| Z | RMB interest (their words) | Chau | CALL SCRIPT | In quotes |
| AA | Business type | Chau | CALL SCRIPT | |
| AB | About the business (their words) | Chau | CALL SCRIPT | In quotes |
| AC | Goals (their words) | Chau | CALL SCRIPT | In quotes |
| AD | Business problems (their words) | Chau | CALL SCRIPT | In quotes |
| AE | Small tasks (their words) | Chau | CALL SCRIPT | In quotes |
| AF | Hours a week (their number) | Chau | CALL SCRIPT | Their number |
| AG | Invitation sent Y/N | Chau | CALL SCRIPT | Y [date] or N [reason] |
| AH | Door opened Y/N | Chau | CALL SCRIPT | Per CALL SCRIPT Step 12 rule 5 |
| AI | Recording link | Chau | CALL SCRIPT | Fathom link |
| AJ | Call held (date) | Chau | SOP | Date of the call |
| AK | Avatar | Chau | SOP | OPT_DENTAL, VET, DME_HH, CPA_BK, OTHER |
| AL | Sales call booked on (date) | Chau | SOP | The date she booked it (the meeting date goes in N) |
| AM | RMB attended (date) | Chau | SOP | Date of the evening they came to |
Next step date formulas (Start date is column I, row 2 shown):
| Next step | Formula |
|---|---|
E2 |
=WORKDAY($I2,2) |
CALL |
=WORKDAY($I2,4) |
TXT |
=WORKDAY($I2,5) |
CALL2 |
=WORKDAY($I2,7) |
E3 |
=WORKDAY($I2,9) |
SETUP tab
N · duplicates removed · window (30 or 90) · W · daily starts · weekly starts · booking rate (marked ASSUMPTION until replaced) · calls per week · first start date · every RMB evening date in the window · Chau's slot 1 and slot 2 · VA name · last daily check.
WEEKLY tab
One row per week. Column A = that Monday's date, column B = that Friday's date. Then the seven numbers in section 7, and the SEQUENCE § 7.2 Friday totals.
Count formula, one per number, changing only the column letter:
=COUNTIFS(TRACKER!I:I,">="&A2,TRACKER!I:I,"<="&B2) counts people started (column I). Use P for reached, S for booked, AJ for calls held, AL for sales calls booked, AM for RMB attendees.
Doors opened: =COUNTIFS(TRACKER!AJ:AJ,">="&A2,TRACKER!AJ:AJ,"<="&B2,TRACKER!AH:AH,"Y*")
VOC_FEED tab
Row # · Avatar · Business type · About the business (their words) · Goals (their words) · Business problems (their words) · Small tasks (their words) · Hours a week (their number) · Recording link · Week.
7. NUMBERS TO WATCH EVERY WEEK
| # | Number | Counted from | When it is low, it tells you | First move, and whose |
|---|---|---|---|---|
| 1 | People started | Start date (I) this week | The VA is not starting [daily starts] a day, or the list is not loaded. | Ela: check the 3.8 counts, then the VA's shift hours against the section 4 load. |
| 2 | Reached | Reached (P) this week | The contact data is bad, emails are landing in spam, or calls are going outside the call windows. | Ela: count BOUNCED and WRONG_NUMBER in Outcome. Send Email 1 to your own inbox and see where it lands. |
| 3 | Booked | Booked on (S) this week | People talk but do not book. The times offered do not fit, or the ask is not landing. Compare booked ÷ started with the 10% assumption. | Ela: read this week's Their words (M) for the reasons. Chau: add earlier or later times to her slots. |
| 4 | Calls held | Call held (AJ) this week | No shows. The confirmation or the reminder did not go out. | Ela: check every booked row got both (Step 4). |
| 5 | Doors opened | Door opened (AH) starts with Y, call held this week | Not a failure on its own. Tim: "if not just grow the group." It is only a problem if the door was never raised. | Ela: check AH is filled on every held call, and not raised appears only on heavy calls. |
| 6 | RMB attendees | RMB attended (AM) this week | The invite did not go out on the call, the evening was too close or too far, or the guest rules got in the way. | Ela: check Invitation sent (AG) on every held call. Chau: check the evening dates in SETUP. |
| 7 | Sales calls booked | Sales call booked on (AL) this week | Doors opened but the call was not booked live. | Ela: list the rows with AH = Y and AL blank. Chau: call each one this week. |
8. DONE CONDITION FOR THE WHOLE PROGRAM
The program is done when every row in TRACKER, including referral rows added along the way, is in one of two states, and Ela's filter proves it.
- Had a call: Call held (AJ) has a date, and columns W to AI are all filled. A quote,
not askedornot saidcounts as filled. - Finished the sequence: Outcome is
SEQUENCE_DONE, or the sequence ended early onREPLIED_LATER,REPLIED_NO,CONNECTED_DECLINED,OPT_OUTorRMB_ONLY.
Ela's proof: filter TRACKER for Call held blank AND Outcome not in the list in state 2. The filter returns zero rows. Then filter Booked filled AND Call held blank AND Outcome not SEQUENCE_DONE. That also returns zero.
9. TO CONFIRM WITH CHAU TUESDAY
Every open item from SEQUENCE, CALL SCRIPT and this SOP, in one list. Where two files ask the same thing, it appears once with both sources.
A. The open tags (nothing sends until these are filled)
- Sender name. SEQUENCE § 1, § 2, § 5.
- Sender email address. SEQUENCE § 1.
- VA name. SEQUENCE § 3.1, § 3.2, § 4, § 7.1. Also this SOP, section 2.
- VA callback number. SEQUENCE § 3.2.
- Two open time slots each week for these calls, with the day and time of each. SEQUENCE § 7.1. Also this SOP, Step 5 and section 5.
- Source of the contact list, and who is allowed to hold it. SEQUENCE § 8. Also this SOP, Step 1.
- The RMB evening: date, place, format. SEQUENCE § 1, § 2, § 3.1, § 5 and CALL SCRIPT Step 8. The starts roll for 30 or 90 days, so this SOP needs every evening date inside the window, not only the next one.
- Whether former members can attend RMB as guests, the chapter's name, and any cost for them. SEQUENCE § 8 and CALL SCRIPT Step 8.
- Exactly who hears the recording. CALL SCRIPT Step 1.
- Who sends the mixer details, Chau or the VA, and by text or email. CALL SCRIPT Step 8. Tim's plan names Chau.
- Where the tracker lives, a Google Sheet or GoHighLevel. CALL SCRIPT Step 12. Also this SOP, section 6.
B. The decisions CALL SCRIPT already lists
- The ten items in CALL SCRIPT, TO REFINE WITH CHAU TUESDAY (a no at the invite, route A or B, company name at the door, the name ask, heavy calls, length, the "bring them back" column, and the three tags above).
C. New from this SOP
- How the VA puts calls on Chau's calendar. Step 4.
- How many calls fit in each slot. At N = 2,000 and a 10% booking rate, each slot holds 8 calls, about 4 hours. Section 4.
- Start days. SEQUENCE § 6 says Email 1 goes out Tuesday, Wednesday or Thursday. Tim's plan says the VA starts new people daily. This SOP follows Tim, Monday to Friday. Pick one.
- Where business comes up. RESOLVED 2026-09-24: SEQUENCE § 0 rule 1 and § 3.3 now match CALL SCRIPT step 9 (version 2). The VA's answer to "Are you selling something?" says Chau is a business owner too and may say so if she can help, and the person is free to say no.
- The no show rule in Step 4, item 8 (one rebook offer, then close). An SOP default.
- Referral names go into the same sequence as new rows (Step 6, item 4). An SOP default.
- The 300 name cutoff between 30 and 90 days. Set in this SOP from Tim's "hundreds" and "thousands". At N = 500 and a 30 day window, daily starts would be 25, not 8.
- The 10% booking rate and the 14 minutes per person VA time. Both assumptions, both replaced with real numbers after week 2 and week 1.
D. Other open items (not Rotary, listed so nothing is lost)
- The VOC research slots (software, task and bottleneck, by avatar). This program's VOC_FEED is one of the ways they get filled.
- The actual bill rate per client.
- The Corwin Li contradiction, 4 hours written vs 40 hours spoken.
- The KPI sheet: dials, answers, appointments requested, appointments booked.
- Scope, rate, SOW and SLA for the Member Minder Pro / DapDB account.
SUGGESTIONS FOR TUESDAY
Not part of the SOP. Ideas only, for Tim and Chau to take or leave.
- If "knock it out in 30 days" means finished, not started, put every start in the first 11 working days so the last email lands by working day 20. At N = 150, that is 14 starts a day instead of 8.
- At N = 2,000, split the list across two VAs (16 starts a day each). One VA would be at about 7 hours a day, and Chau at about 8 hours of calls a week. Or stretch the window.
- Log the first real booking rate when week 2 closes. The references found no published number for this motion, so Chau's will be the first.
- Give referral names their own first email that says who suggested them. A warm name reads a cold Email 1 as cold. It would be one short variant in SEQUENCE § 1.
- Pin the Friday WEEKLY row to the Trello board, the live surface, so Tim sees it before the Tuesday call without asking.
Built 2026-09-24 from Tim's plan of 2026-09-24, 2_Rotary_VA_Outreach.md (revised version with call 2 on Day 8) and 1_Rotary_Call_Script.md (version 2).