Share:

📋 Master Lead Sheet takes ~4 min (lots of live CRM pulls)

WTD 13 Nov–18 Nov · last week 6 Nov–12 Nov

📅 Showing data as of 18/11/2026, 01:12:35 CT. Auto-updates 7am daily · click 🔄 Refresh for a live update (~4 min) — that becomes the new latest for everyone.
Received (week-to-date)
10,188
9,556 fresh · 632 recycled
Received (last full week)
15,894
13,870 fresh · 2,024 recycled
Left to distribute
16,201
14,279 fresh · 1,922 recycled

📊 Command snapshot — received this week by supplier · leads left (released + uncleaned) · vs target (week 86% elapsed)

In pipe = the CRM's real uncleaned queue (1,395 waiting to be cleaned), shown at 75% — cleaning removes ~15%, and part of the queue is recycled, which never joins fresh. Effective fresh = released + in pipe = what the city actually has behind it.
CityKIDSXADULTLPALANRecycledLeft
fresh
Left
recyc
In pipe
uncleaned
Effective
fresh
ReceivedTarget%
Florida463432120319191,6991471551,8541,40100%
Orlando04902608091,93598682,00383900%
Dallas240385115265516962441208161,05600%
Houston26936486251607363161208561,03000%
NY1,2203772603823,5793312463,8252,01400%
Chicago260533159220451,7432931281,8711,21700%
Boston199388143223351,1033561251,22898800%
Nashville84210205125145011038558663800%
Unknown58787033102,2873422,2891,00500%
TOTAL3,3222,9261,1602,41731514,2791,9221,04915,32810,18800%

🎯 This week — buying tracker (week 13th November · 86% elapsed · baseline 8wk to 07/16/2026)

Ordered vs Received — "Exp. by now" & "Proj. Thu" use the 8-week day-of-week curve, so a normal Thu dip / Sun low doesn't read as behind.
Supplier lineOrderedReceivedExp. by nowPaceProj. ThuCPL $Cost / booking
Blue Rooms KIDS1,5003,3223,133106%3,774$23.22—
Blue Rooms ADULT1,7002,9261,943151%3,174$11.02—
Lead Pronto2,4551,1601,26991%1,327$20.02$437 ⚠
Alan7002,4172,044118%2,669$15.58$1056 ⚠
TOTAL6,3559,8258,389117%10,944Blue Rooms CPL = wk of 08-14 · Alan = 2026-06 · LP GBP→USD
Cost / booking = that supplier's spend ÷ its bookings, week of 11-06. Yellow row + ⚠ = lead pricing is an estimate, not real spend (Alan = stale monthly sheet, Lead Pronto = sparse weekly average) — treat as indicative only. Blue Rooms rows use actual dashboard spend.

Daily arrivals this week — by supplier line

DayKIDSADULTLPAlanRecycTotal
11-13 Fri790592216723392,360
11-14 Sat66853819452731,930
11-15 Sun63865122830801,825
11-16 Mon6215812562031421,803
11-17 Tue5805202466431172,106
11-18 Wed2544201314116

Usage vs stock

Rolling usage out to bookers1,629/dayMon–Thu · Fri ~1,509
Fresh released (available pool, per lead)14,279+ 1,922 recycled
In pipe — waiting to be cleaned1,0461,395 in queue × 75%
Effective fresh available15,325released + in pipe
Est. usage rest of week1,6291 days left
Projected fresh stock end of week14,815effective − usage + incoming supply

📈 Normal week — what we usually get (8-week average per day · to 07/16/2026)

The typical daily arrivals by supplier. Leads peak Mon–Tue and dip Thu; the swing is mostly Recycled (dead on Sun). This is the baseline behind "Exp. by now".
DayKIDSADULTLPAlanRecycledTotal
Fri4963371933433701,739
Sat5252992013373391,701
Sun5013372393181521,547
Mon5643352293843641,876
Tue5173082283745081,935
Wed5303271792884641,788
Thu4522481672524021,521
WEEK3,5852,1911,4362,2962,59912,107
⏱ Pacing — week of 13th November (10-day rolling; Fri counted separately)
Today's distribution
⏳ Not yet
usually ~11am ET / ~4pm UK
Received vs target
—
10,188 of 0 · ▏= week 86%
Week elapsed
86%
day 6 of 7 (Fri–Thu)
Distribution used
65%
5,217 of ~8,025 expected
Likely to distribute (rest of week)
3,234
2 days left × ~49 bookers × ~33/booker (Fri 32)
Days to go
2
2 distribution days · week ends 19 Nov (Thu)
Bookers on (CRM)
49
Mon–Thu avg · Fri ~47
Leads / booker
33
Mon–Thu · Fri ~32 · run-rate 1,629/day

📅 This stage last week (by day 6 of the week · last week 6 Nov–11 Nov) — behind last week

This week (so far)Last week (same point)vs last week
Received (leads in)10,18813,502-3,314 (-25%)
— of which fresh9,55611,766-2,210 (-19%)
Distributed5,2176,118-901 (-15%)

1 · What's LEFT — available to distribute now, by city

Live snapshot, classified per lead by marketing code. N1N, CMN, 4AB, 5AB, 6AB, FL01 and any code ending R count as Recycled — they are re-sends, not fresh. City is derived from the code, so it will not tie exactly to the distribution team split.
CityFreshRecycledTotal
Florida1,6991471,846
Orlando1,935982,033
Dallas696244940
Houston7363161,052
NY3,5793313,910
Chicago1,7432932,036
Boston1,1033561,459
Nashville501103604
Unknown2,287342,321
TOTAL14,2791,92216,201
Of the 16,201 available, 1,922 (11.9%) are recycled codes:
Recycled code familyLeads · % of pool
N1N842 5.2%
6AB517 3.2%
Ends R430 2.7%
5AB113 0.7%
FL0115 0.1%
4AB4 0.0%
CMN1 0.0%

2 · Received vs Target — leads in this week vs sheet target (13th November)

▏marker = week elapsed (86%). Bars past it are ahead of pace, short of it behind. "vs pace" = % received − % week.
CityReceivedTarget%vs week pacevs pace
Florida1,40100%
-86
Dallas1,05600%
-86
Chicago1,21700%
-86
Boston98800%
-86
TOTAL10,18800%-86

2b · ORDERED vs RECEIVED — by supplier (this week 13th November · ▏= week 86% elapsed; recycled isn't ordered)

How much of what was ordered has actually arrived. Bars past the ▏marker are on/ahead of pace for the week.
SupplierOrderedReceived%vs week pace
KIDSX (Blue Rooms kids)1,5003,322221%
ADULT (Blue Rooms adult)1,7002,926172%
Lead Pronto2,4551,16047%
Alan7002,417345%
TOTAL (paid)6,3559,825155%

📅 Daily log — leads LEFT, DISTRIBUTED out + ordered vs given (newest first · each supplier cell = ordered / given, week-to-date)

Recorded every cron run. The CRM keeps no history of "available to distribute", so this is the only record of what we had left on a given day.
DateLeft freshLeft recycDist freshDist recycKIDSADULTLPAlanReceivedTarget
2026-11-1814,2791,922001,500 / 3,3221,700 / 2,9262,455 / 1,160700 / 2,41710,1880

3 · What we Received — leads in (fresh / recycled)

This week-to-date (13 Nov–18 Nov)
CityFreshRecycledTotal
Florida1,307941,401
Orlando80534839
Dallas986701,056
Houston947831,030
NY1,8821322,014
Chicago1,142751,217
Boston93652988
Nashville60434638
Unknown947581,005
TOTAL9,55663210,188
Last full week (6 Nov–12 Nov)
CityFreshRecycledTotal
Florida2,2843922,676
Orlando1,4011431,544
Dallas1,4272251,652
Houston1,4512241,675
NY1,9383312,269
Chicago1,8893282,217
Boston1,4921691,661
Nashville8811711,052
Unknown1,107411,148
TOTAL13,8702,02415,894

4 · DELIVERED BY — suppliers (last full week)

SupplierFreshRecycledTotal
Blue Rooms9,4652469,711
Alan2,8733133,186
Lead Pronto1,532401,572
Neil01,3211,321
Organic0104104
TOTAL13,8702,02415,894

5 · WHO GETS THEM — bookers (52 bookers · this week so far vs last week vs target)

Target per booker: 25 fresh + 8 recycled per weekday · 20 + 5 Friday = 120 fresh / 37 recycled (157) per full week.
BookerThis wk
fresh
This wk
recyc
Last wk
fresh
Last wk
recyc
Target/wk
F / R
Summer A16241653120 / 37
Debbi H15161811120 / 37
Eduardo G14531812120 / 37
Stephen R14511660120 / 37
Kieran R14401597120 / 37
Bobbie M14101620120 / 37
Andrew L13901630120 / 37
Andrew B13241640120 / 37
Edmond M13501460120 / 37
Paola G128417416120 / 37
Hanna L13001542120 / 37
Lisa M12801780120 / 37
Michelle M12801502120 / 37
Alecia H12701542120 / 37
Chyna-Rae C12701511120 / 37
Selina M12501490120 / 37
Jennifer D120310741120 / 37
Zebbie R12031490120 / 37
David P11131007120 / 37
Evan C10741620120 / 37
Rosario A11101671120 / 37
Jill S11011641120 / 37
Estrella D11101630120 / 37
Bari M10901632120 / 37
Brian P99414012120 / 37
Eva M101014612120 / 37
Jeffrey S95613211120 / 37
Martha M9801735120 / 37
Rob A9601570120 / 37
Jamie H9501222120 / 37
Erica S9149333120 / 37
Kevin W9501550120 / 37
Victoria M9222084120 / 37
Carly L9301540120 / 37
Cheryl S8841460120 / 37
Joselyn P89320210120 / 37
Ali R893859120 / 37
Perry K91013211120 / 37
Sherri B90011064120 / 37
Miguel S90016513120 / 37
Debra S83013817120 / 37
Jonathan M7601600120 / 37
Sarah S731300120 / 37
Dalis F6701680120 / 37
Damien H65013312120 / 37
Jessica W63011850120 / 37
Scott T3901604120 / 37
Corban A3001572120 / 37
Charles B3001560120 / 37
Jorge B2909211120 / 37
Francisco M2001400120 / 37
mike h1000120 / 37
TOTAL5,154637,544370

📇 By marketing code × city (last full week · leads → bookings per code)

The CRM-Leads grain in one place: every code with its city + supplier (canonical classify), leads split fresh/recycled, and conversion to booking. Click any column to sort.
CodeCitySupplierLeadsFreshRecycBookedConv%
##NYKIDSXNYBlue Rooms1,0351,0350191.8%
##ORL1FXOrlandoBlue Rooms957957060.6%
##CHI1FXChicagoBlue Rooms7157150212.9%
##FL1FXFloridaBlue Rooms6586580223.3%
##BOS1FXBostonBlue Rooms5505500295.3%
##DAL1FXDallasBlue Rooms5045040183.6%
##HOU1FXHoustonBlue Rooms4614610286.1%
##FLKIDSXFloridaBlue Rooms4554550122.6%
##FL3ABFloridaAlan451451010.2%
##ATKIDSXUnknownBlue Rooms4324320173.9%
##FLKIDSXPFloridaBlue Rooms4294290214.9%
##ATKIDSXPUnknownBlue Rooms376376071.9%
##ORLP2OrlandoLead Pronto353353061.7%
##BOSKIDSXBostonBlue Rooms3243240103.1%
##CHIKIDSXChicagoBlue Rooms2992990103.3%
##NY3ABNYAlan284284000.0%
##CHIKIDSXPChicagoBlue Rooms2702700134.8%
##NA1FXNashvilleBlue Rooms2702700165.9%
##CHI3ABChicagoAlan269269010.4%
##NYKIDSXPNYBlue Rooms26826803211.9%
##HOU3ABHoustonAlan257257000.0%
##NALP2NashvilleLead Pronto2522520166.3%
##HOUKIDSXPHoustonBlue Rooms227227083.5%
##DALKIDSXPDallasBlue Rooms2232230177.6%
##CHILP2ChicagoLead Pronto2212210135.9%
##HOUKIDSXHoustonBlue Rooms210210083.8%
##BOSLP2BostonLead Pronto202202073.5%
##AT3ABUnknownAlan194194000.0%
##DALKIDSXDallasBlue Rooms1921920136.8%
##DAL3ABDallasAlan191191000.0%
##FLP2FloridaLead Pronto1781780126.7%
##BOSKIDSXPBostonBlue Rooms1691690137.7%
##DALP2DallasLead Pronto137137064.4%
##NY3CX1FNYAlan130130053.8%
##BOS3ABBostonAlan129129000.0%
##CHI6ABChicagoNeil113011300.0%
##NA3ABNashvilleAlan111111000.0%
##AT1FXUnknownBlue Rooms105105032.9%
##FL01FloridaOrganic104010454.8%
##HOULP2HoustonLead Pronto101101033.0%
##NYN1NNYNeil9009011.1%
##NYLP2NYLead Pronto8888089.1%
##NAKIDSXPNashvilleBlue Rooms8585055.9%
##NAKIDSXNashvilleBlue Rooms85850910.6%
##FL6ABFloridaNeil8008011.3%
##HOU3CX1FHoustonAlan7070011.4%
##CHIN1NChicagoNeil7007011.4%
##NY3CX1MNYAlan6565069.2%
##DALN1NDallasNeil6306311.6%
##HOU6ABHoustonNeil6106111.6%
##DAL6ABDallasNeil5705700.0%
##BOSN1NBostonNeil5505500.0%
##NY6ABNYNeil5505547.3%
##HOUN1NHoustonNeil5405400.0%
##DAL3CX1FDallasAlan5454059.3%
##FLKIDSXRFloridaBlue Rooms5305300.0%
##NY1FXNYBlue Rooms505001020.0%
##NYCMNNYNeil47047510.6%
##CHICMNChicagoNeil4304337.0%
##NY1FXRNYAlan4304300.0%
##FL3CX1FFloridaAlan4343012.3%
##FLN1NFloridaNeil4204212.4%
##DAL3CX1MDallasAlan4040012.5%
##ORL6ABOrlandoNeil4004012.5%
##BOS6ABBostonNeil3803800.0%
##NA6ABNashvilleNeil3803800.0%
##NAN1NNashvilleNeil3603600.0%
##HOUFB31MHoustonAlan3535012.9%
##CHI3CX1FChicagoAlan3535000.0%
##FL5ABFloridaNeil3503500.0%
##BO3CX1FBostonAlan3434012.9%
##ORLN1NOrlandoNeil3303300.0%
##FLCMNFloridaNeil3303313.0%
##HOU3CX1MHoustonAlan3333039.1%
##NY5ABNYNeil3203226.3%
##NACMNNashvilleNeil30030723.3%
##ORL3CX1FOrlandoAlan3030000.0%
##NYKIDSXRNYBlue Rooms3003000.0%
##FLFB31MFloridaAlan2828013.6%
##HOUKIDSXRHoustonBlue Rooms2702700.0%
##FL1FXRFloridaAlan2602613.8%
##CHI3CX1MChicagoAlan2626000.0%
##HOUCMNHoustonNeil2402428.3%
##NA3CX1FNashvilleAlan24240416.7%
##CHI5ABChicagoNeil2402400.0%
##CHISNAPChicagoBlue Rooms2323000.0%
##CHI1FXRChicagoAlan2302300.0%
##BO3CX1MBostonAlan2323014.3%
##ORLCMNOrlandoNeil2202200.0%
##BOSSNAPBostonBlue Rooms2222014.5%
##HOU1FXRHoustonAlan2202200.0%
##DAL1FXRDallasAlan2202200.0%
##DAL5ABDallasNeil2202200.0%
##FL3CX1MFloridaAlan21210419.0%
##BOFB31MBostonAlan2121000.0%
##DALKIDSXRDallasBlue Rooms2002000.0%
##DALCMNDallasNeil1901915.3%
##CHIKIDSXPRChicagoBlue Rooms1901900.0%
##ORL3CX1MOrlandoAlan1919000.0%
##AT1FXRUnknownAlan1801800.0%
##CHIKIDSXRChicagoBlue Rooms1801800.0%
##ORL1FXROrlandoAlan1701715.9%
##DALFB31MDallasAlan1717000.0%
##ORLFB31MOrlandoAlan1717015.9%
##ATKIDSXRUnknownBlue Rooms1701700.0%
##DALFB32MDallasAlan1616016.3%
##BOSKIDSXRBostonBlue Rooms1601600.0%
##NA5ABNashvilleNeil1601600.0%
##HOUFB32MHoustonAlan1515016.7%
##NA1FXRNashvilleAlan1501500.0%
##ORLP2ROrlandoLead Pronto1501516.7%
##BOS5ABBostonNeil1501500.0%
##BOS1FXRBostonAlan1501500.0%
##BOSCMNBostonNeil1401417.1%
##NAKIDSXRNashvilleBlue Rooms1401400.0%
##HOU5ABHoustonNeil1401400.0%
##ORLSNAPOrlandoBlue Rooms1313000.0%
##NY3CX1FRNYAlan1301300.0%
##NALP2RNashvilleLead Pronto1301300.0%
##HOUSNAPHoustonBlue Rooms1212000.0%
##NAFB31MNashvilleAlan1111000.0%
##DALSNAPDallasBlue Rooms1111019.1%
##DALFB31FDallasAlan10100110.0%
##NY3CX1MRNYAlan1001000.0%
##DALFB32FDallasAlan99000.0%
##NA3CX1MNashvilleAlan99000.0%
##CHIFB31FChicagoAlan99000.0%
##HOUFB31MRHoustonAlan808112.5%
##FLSNAPFloridaBlue Rooms88000.0%
##HOUFB32FHoustonAlan88000.0%
##FLFB31MRFloridaAlan70700.0%
##NAFB32FNashvilleAlan77000.0%
##NAFB32MNashvilleAlan77000.0%
##NYKIDSXPRNYBlue Rooms70700.0%
##HOUFB33MHoustonAlan66000.0%
##CHIFB31MChicagoAlan66000.0%
##CHIFB32FChicagoAlan66000.0%
##FL3CX1FRFloridaAlan60600.0%
##NY3CX2MNYAlan66000.0%
##HOUFB31FHoustonAlan66000.0%
##NAFB31FNashvilleAlan66000.0%
##DAL3CX3MDallasAlan66000.0%
##DALP2RDallasLead Pronto60600.0%
##ORL5ABOrlandoNeil60600.0%
##DAL3CX1FRDallasAlan60600.0%
##ATKIDSXPRUnknownBlue Rooms60600.0%
##NAFB33FNashvilleAlan550120.0%
##BOFB31FBostonAlan55000.0%
##DALGXDallasBlue Rooms55000.0%
##FLFB32FFloridaAlan55000.0%
##ORLGXOrlandoBlue Rooms55000.0%
##DALFB31MRDallasAlan50500.0%
##NY3CX2FNYAlan550120.0%
##BOFB32FRBostonAlan40400.0%
##CHIFB31MRChicagoAlan40400.0%
##NA3CX1FRNashvilleAlan40400.0%
##BOSLP2RBostonLead Pronto40400.0%
##NASSNAPNashvilleBlue Rooms44000.0%
##NAFB33MNashvilleAlan44000.0%
##DAL3CX2FDallasAlan44000.0%
##BOFB32MBostonAlan44000.0%
##ORLFB31MROrlandoAlan40400.0%
##CHIGXChicagoBlue Rooms44000.0%
##CHIFB31FRChicagoAlan40400.0%
##ORLFB32FOrlandoAlan33000.0%
##HOUFB33FHoustonAlan33000.0%
##HOUGXHoustonBlue Rooms33000.0%
##BOSGXBostonBlue Rooms33000.0%
##ORLFB31FOrlandoAlan33000.0%
##BO3CX1FRBostonAlan30300.0%
##DAL3CX3FDallasAlan33000.0%
##DALKIDSXPRDallasBlue Rooms30300.0%
##ORL3CX1FROrlandoAlan30300.0%
##CHISNAPRChicagoBlue Rooms30300.0%
##CHI3CX1FRChicagoAlan30300.0%
##DALFB33MDallasAlan33000.0%
##HOUKIDSXPRHoustonBlue Rooms30300.0%
##HOU3CX2FHoustonAlan22000.0%
##NYFB31FNYAlan22000.0%
##FLGXFloridaBlue Rooms22000.0%
##CHIFB32MChicagoAlan220150.0%
##NY3CX2MRNYAlan20200.0%
##BO3CX2FBostonAlan22000.0%
##NAKIDSXPRNashvilleBlue Rooms20200.0%
##FLKIDSXPRFloridaBlue Rooms20200.0%
##HOUFB32MRHoustonAlan20200.0%
##FLFB31FFloridaAlan22000.0%
##HOUFB31FRHoustonAlan20200.0%
##BO3CX3FBostonAlan22000.0%
##HOU3CX1FRHoustonAlan20200.0%
##FL3CX2MFloridaAlan22000.0%
##HOU3CX1MRHoustonAlan20200.0%
##BOSKIDSXPRBostonBlue Rooms10100.0%
##DALFB32MRDallasAlan10100.0%
##DALFB33FDallasAlan11000.0%
##CHI3CX3MChicagoAlan11000.0%
##HOU3CX2MHoustonAlan11000.0%
##DALFB32FRDallasAlan10100.0%
##NAFB32MRNashvilleAlan10100.0%
##BOFB32MRBostonAlan10100.0%
##HOU3CX3MHoustonAlan11000.0%
##DAL3CX2MDallasAlan11000.0%
##BOSSNAPRBostonBlue Rooms10100.0%
##NYSNAPNYBlue Rooms11000.0%
##BOFB32FBostonAlan11000.0%
##CHI4ABChicagoAlan10100.0%
##ORLSNAPROrlandoBlue Rooms10100.0%
##NYFB31MNYAlan11000.0%
##FLFB32FRFloridaAlan10100.0%
##ORL3CX3FOrlandoAlan11000.0%
##FL3CX3FFloridaAlan11000.0%
##CHI3CX1MRChicagoAlan10100.0%
##FLSNAPRFloridaBlue Rooms10100.0%
##HOUSNAPRHoustonBlue Rooms10100.0%
##CHI4ABRChicagoAlan10100.0%
##HOULP2RHoustonLead Pronto10100.0%
##BO3CX1MRBostonAlan10100.0%
##BO3CX3MRBostonAlan10100.0%
##FL3CX1MRFloridaAlan1011100.0%
##NYFB32MNYAlan11000.0%
##NY3CX2FRNYAlan10100.0%
##ORL3CX1MROrlandoAlan10100.0%
##NA3CX2MNashvilleAlan11000.0%
##HOUGXRHoustonAlan10100.0%
##BO3CX2MBostonAlan11000.0%
##NY3CX3MNYAlan11000.0%
##CHIFB33MChicagoAlan11000.0%
##NA3CX1MRNashvilleAlan10100.0%
##NYLP2RNYLead Pronto10100.0%
##NASSNAPRNashvilleBlue Rooms10100.0%
##FL3CX2MRFloridaAlan10100.0%
##CHI3CX2FChicagoAlan11000.0%
##ORLFB31FROrlandoAlan10100.0%
##FL3CX2FFloridaAlan11000.0%
##CHI3CX3FRChicagoAlan10100.0%
##CHI3CX3FChicagoAlan11000.0%
##NY3CX3FNYAlan11000.0%
TOTAL15,89413,8702,0245263.3%