CRM index · The Loyalty Tax Engine

Pick your CRM first.

Create or map the five TBT fields. Then go back to the Make or Zapier guide. Native = sign in and go. API = subject to your aggregator granting access. Bridge = Google Sheets, blueprint 01e. Default gap 25 bps. Default: email the broker, not the client.

12 CRMsv1.0Five TBT fieldsGap default 25 bps$99 AUD once

Open the file for your CRM in a browser. Each one has the connect method, the field map for that CRM, the Make watch to import, the last-step swap, and the Zapier first / last modules. The engine in the middle does not change.

4Native sign-in — Salesforce, HubSpot, Pipedrive, Zoho CRM
5API — aggregator must grant access, or fall back to 01e
3Sheets bridge — ActivePipe, BrokerEngine, AFG Suite360

Every CRM, these five

LabelInternal nameType
TBT current ratetbt_current_rateNumber — map an existing current-rate field if you already store it
TBT new-money ratetbt_new_money_rateNumber — broker-maintained new-money / retention reference
TBT loyalty gap (bps)tbt_loyalty_gap_bpsNumber — (current − new-money) × 100. Gate default ≥ 25
TBT loyalty statetbt_loyalty_stateSingle-line text — due / queued / sent / touched / opt_out
TBT last loyalty touchtbt_last_loyalty_touchDate — stops a second hit inside seven days

Salesforce appends __c. Pipedrive generates a hash — paste it over YOUR_*_HASH. Full translation: 05-templates/CRM-Field-Map.csv.

Two paths after you pick a CRM

Make setup guide — import the watch + outreach. About twenty-five minutes for a native CRM.
Zapier setup guide — two Zaps built by hand (Zapier cannot import a workflow file). Use that guide plus this CRM file for the first and last steps.

Default: notify you. Do not email the client.

auto_email_client stays false until you have tested the loop on yourself. Support: matt@thebrokertimes.com.au.