Build campaign tracking URLs for your blog posts and marketing links. Fill in the fields below and copy the generated URL.
inputs_YYYY_MM.json on the server. Cinch $ are reported directly; all other channel $ are derived from counts × avg ticket at view time.pos_YYYY_MM.json. ISI LubeSoft is the primary source — NG2 fills in stores not yet converted. LubeSoft always wins if a store appears in both.index.html directly from the server.index.html to replace the live file. Current file is auto-backed up first.
raw.crm_capture_rate straight from the shared Google Sheet John edits
weekly — the same data a Sunday cron job already pulls on a fixed schedule. Use "Sync Now"
instead of waiting for the cron run whenever you know the Sheet edit is already done.
raw.crm_capture_rate entirely.
Safe to run any time — a failed sync leaves the existing data untouched.
| Store # | City | Franchise | Manager | Manager mobile | Store phone | Actions |
|---|---|---|---|---|---|---|
| Vendor | Token | Stores | Status | Actions |
|---|---|---|---|---|
| Channel | Cost | Scope | Actions |
|---|---|---|---|
parse_dripdrop_export.py or the Admin Upload → DripDrop Data tab.
| Store | Month | Cards Mailed | HH Responses | HH Resp. Rate | Total Visits | Ticket Avg | Revenue |
|---|---|---|---|---|---|---|---|
| Store | Month | Campaigns | Cards Mailed | HH Responses | Total Visits | Revenue |
|---|---|---|---|---|---|---|
| Store | Campaign Type | Billing Frequency | Budget (per period) | Approx Monthly Budget |
|---|---|---|---|---|
| Store | Month | Cost | CPL | ROAS | Capped? |
|---|---|---|---|---|---|
| ⚠ Capped — |
| Emails sent | Delivered | SMS sent | Delivered | Mail shipped | |
|---|---|---|---|---|---|
| Total |
| Store | # | Coupon | Type (ISI) | Redeemed | Share of store | Discount each | Avg ticket | New / Repeat / Rescued | Attributed by Cinch (email / SMS / mail) | Detail coverage |
|---|---|---|---|---|---|---|---|---|---|---|
| Store | Tickets with a coupon | Avg ticket with | Avg ticket without | Coupons redeemed | Discount given | Detail coverage |
|---|---|---|---|---|---|---|
Re-pull the full "Business Summary and Statistics" report (all stores) for the flagged week from the ISI portal, then upload it below. The filename must keep ISI's own export naming (e.g. "2026_week_38_LubeSoft Reports-Sales-Business Summary and Statistics.csv"). Correction applies automatically within about 5 minutes of upload — you'll get a confirmation email either way (corrected, or still bad and needs another re-pull).
| Page title | ||
| Subtitle | ||
| Footer credit | ||
| Hatch legend text |
| Stage | Day range | Color | |
|---|---|---|---|
| Row | Subtitle 1 | Subtitle 2 | |
|---|---|---|---|
| # | Type | Title | |
|---|---|---|---|
| Row | Headline | Breakdown | |
|---|---|---|---|
| Color | Description | |
|---|---|---|
| Phone | Type | Store | Customer | Logged | |
|---|---|---|---|---|---|
| Nothing in the registry yet. | |||||
| Metric | Thresholds | Actions |
|---|---|---|
| No metrics in this category yet. | ||
Customers who haven't been in for a while. New ones are added every night — call them, then record what happened. Your notes and statuses are kept.
The Hub's saved goals for every store: Pace is the baseline, Target is the goal, Push is the stretch. Each set is saved once and never rewritten; a new official run is published the Monday after the third full week of each month. Tap a store to see its next months.
| Store | ||||
|---|---|---|---|---|
| ▶ Pace only Provisional Push > Overdrive | ||||
|
Loading…
|
||||
| Subtotal |
| All stores | |
|---|---|