Share:

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

WTD 17 Jul–23 Jul · last week 10 Jul–16 Jul

📅 Showing data as of 23/07/2026, 07:15:45 CT. Auto-updates 7am daily · click 🔄 Refresh for a live update (~4 min) — that becomes the new latest for everyone.
Received (week-to-date)
11,151
8,574 fresh · 2,577 recycled
Received (last full week)
11,785
8,792 fresh · 2,993 recycled
Left to distribute
4,982
2,420 fresh · 2,562 recycled

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

In pipe = arrived today, not yet cleaned/released (shown at 85% to allow for cleaning removals). Effective fresh = released + in pipe = what the city actually has behind it.
CityKIDSXADULTLPALANRecycledLeft
fresh
Left
recyc
In pipe
uncleaned
Effective
fresh
ReceivedTarget%
Florida8145221301954024721,010445162,1311,300164%
Orlando43416234141219538095471,0531,30081%
Dallas271386149316303276636403161,4251,400102%
Houston271332164308298195321402351,3731,40098%
NY4676186343408351195383891,5991,400114%
Chicago35934085329387356154464021,5001,400107%
Boston27520916120224013034221521,087900121%
Nashville25117011920224110221225127983900109%
TOTAL2,7512,9931,1051,7362,4982,4202,5622642,68411,15110,000112%

🎯 This week — buying tracker (week 10th July · 100% 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 KIDS3,8502,7513,58577%2,751$16.85$351
Blue Rooms ADULT2,5502,9932,191137%2,993$20.99$305
Lead Pronto1,5501,1051,43677%1,105$13.79$248
Alan1,9501,7362,29676%1,736$15.58$306
TOTAL9,9008,5859,50890%8,585Blue Rooms CPL = wk of 07-10 · Alan = 2026-06 · LP GBP→USD
Cost / booking = that supplier's spend ÷ its bookings, week of 07-10. 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
07-17 Fri3904061632165211,696
07-18 Sat4044231782223521,579
07-19 Sun3734352202451361,409
07-20 Mon4845381542614681,905
07-21 Tue4955491693575402,110
07-22 Wed4945391853754672,060
07-23 Thu111103366014324

Usage vs stock

Rolling usage out to bookers1,927/dayMon–Thu · Fri ~1,357
Fresh released (on distribute page)2,420+ 2,562 recycled
In pipe — arrived today, uncleaned264310 in × 85%
Effective fresh available2,684released + in pipe
Est. usage rest of week00 days left
Projected fresh stock end of week2,684effective − 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 10th July (10-day rolling; Fri counted separately)
Today's distribution
⏳ Not yet
usually ~11am ET / ~4pm UK
Received vs target
112%
11,151 of 10,000 · ▏= week 100%
Week elapsed
100%
day 7 of 7 (Fri–Thu)
Distribution used
79%
7,136 of ~9,065 expected
Likely to distribute (rest of week)
1,944
1 days left × ~54 bookers × ~36/booker (Fri 26)
Days to go
1
1 distribution days · week ends 23 Jul (Thu)
Bookers on (CRM)
54
Mon–Thu avg · Fri ~52
Leads / booker
36
Mon–Thu · Fri ~26 · run-rate 1,927/day

📅 This stage last week (by day 7 of the week · last week 10 Jul–16 Jul) — behind last week

This week (so far)Last week (same point)vs last week
Received (leads in)11,15111,785-634 (-5%)
— of which fresh8,5748,792-218 (-2%)
Distributed7,1369,133-1,997 (-22%)

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

Live snapshot. SECOND group = fresh (2nd-tier). Recycled = 5AB/6AB + Refreshers.
CityFreshRecycledTotal
Florida4721,0101,482
Orlando5380538
Dallas276636912
Houston195321516
NY351195546
Chicago356154510
Boston13034164
Nashville102212314
TOTAL2,4202,5624,982

2 · Received vs Target — leads in this week vs sheet target (10th July)

▏marker = week elapsed (100%). Bars past it are ahead of pace, short of it behind. "vs pace" = % received − % week.
CityReceivedTarget%vs week pacevs pace
Florida2,1311,300164%
+64
Orlando1,0531,30081%
-19
Dallas1,4251,400102%
+2
Houston1,3731,40098%
-2
NY1,5991,400114%
+14
Chicago1,5001,400107%
+7
Boston1,087900121%
+21
Nashville983900109%
+9
TOTAL11,15110,000112%+12

2b · ORDERED vs RECEIVED — by supplier (this week 10th July · ▏= week 100% 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)3,8502,75171%
ADULT (Blue Rooms adult)2,5502,993117%
Lead Pronto1,5501,10571%
Alan1,9501,73689%
TOTAL (paid)9,9008,58587%

📅 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-07-232,4202,562003,850 / 2,7512,550 / 2,9931,550 / 1,1051,950 / 1,73611,15110,000
2026-07-221,1162,3201,5333713,850 / 2,5422,550 / 1,9201,550 / 1,3801,950 / 1,56010,37110,000
2026-07-211,5662,3411,4813473,850 / 1,7972,550 / 1,4561,550 / 1,0071,950 / 1,0237,34010,000
2026-07-202,1982,4051,5873663,850 / 1,4352,550 / 1,1481,550 / 8331,950 / 7965,89110,000
2026-07-191,0752,107003,850 / 8362,550 / 6611,550 / 4601,950 / 4643,45810,000
2026-07-181,0992,156003,850 / 4252,550 / 3541,550 / 2301,950 / 2351,84510,000
2026-07-171,0992,159003,850 / 2192,550 / 1921,550 / 911,950 / 1161,09710,000

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

This week-to-date (17 Jul–23 Jul)
CityFreshRecycledTotal
Florida1,6594722,131
Orlando8322211,053
Dallas1,1223031,425
Houston1,0742991,373
NY1,1894101,599
Chicago1,1103901,500
Boston8472401,087
Nashville741242983
TOTAL8,5742,57711,151
Last full week (10 Jul–16 Jul)
CityFreshRecycledTotal
Florida1,7235062,229
Orlando8882891,177
Dallas9123531,265
Houston1,0483731,421
NY1,1444911,635
Chicago1,3654531,818
Boston8202481,068
Nashville8922801,172
TOTAL8,7922,99311,785

4 · DELIVERED BY — suppliers (last full week)

SupplierFreshRecycledTotal
Blue Rooms5,99615,997
Neil02,8872,887
Alan1,417161,433
Lead Pronto1,37951,384
Organic08484
TOTAL8,7922,99311,785

5 · WHO GETS THEM — bookers (58 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
Mark L02030248120 / 37
Andrew L1175614279120 / 37
Eduardo G1294215749120 / 37
Victoria M15441798120 / 37
Alecia H1213312869120 / 37
Aryanna S1213311720120 / 37
Kimberly S1094512345120 / 37
Bari M1213215151120 / 37
Hanna L1193315249120 / 37
Michelle M1203114948120 / 37
Stephen R1084213938120 / 37
Miguel S1074114736120 / 37
Lacole R1093813952120 / 37
Paola G895810486120 / 37
Edmond M1054014255120 / 37
Brian P1133212835120 / 37
Martha M1083012845120 / 37
Sherri B1023614061120 / 37
Evan C914512639120 / 37
Celeste N1211514627120 / 37
Kristie G934110834120 / 37
Cheryl S99349730120 / 37
Summer A13031696120 / 37
Jeffrey S993013435120 / 37
Francois J1111313828120 / 37
Debbi H12031545120 / 37
Debra S77467019120 / 37
Kieran R952812524120 / 37
Charles B1091413428120 / 37
Rob A1111213528120 / 37
Erica S1121013417120 / 37
Scott T1002212030120 / 37
Kevin W1091313928120 / 37
Bobbie M942713418120 / 37
Selina M1071413527120 / 37
Zebbie R11010527120 / 37
Cindy D1041511426120 / 37
Lisa M972212731120 / 37
Brianna K1021511726120 / 37
Nicolas P103149631120 / 37
Steven M1071013220120 / 37
Joselyn P843214745120 / 37
Andrew B952111835120 / 37
David P1001410032120 / 37
Carly L813114160120 / 37
Dennis F971411531120 / 37
Helen H912012035120 / 37
Monica E971113921120 / 37
Sarah S961117118120 / 37
Jessica W891310129120 / 37
Jennifer D88811317120 / 37
Dalis F821014129120 / 37
Rosario A82712733120 / 37
Jorge B5214196120 / 37
Perry K46121466120 / 37
Damien H31800120 / 37
Lauren W25125313120 / 37
Courteney M19510924120 / 37
TOTAL5,6081,5287,0612,072

📇 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%
##FLKIDSXFloridaBlue Rooms7717710486.2%
##NYKXNYBlue Rooms4774770122.5%
##CHIKXChicagoBlue Rooms318318010.3%
##NY6ABNYNeil3060306134.2%
##FLKXFloridaBlue Rooms304304041.3%
##ORLP2OrlandoLead Pronto2952950206.8%
##NASKXNashvilleBlue Rooms247247020.8%
##CHI6ABChicagoNeil246024672.8%
##FL6ABFloridaNeil244024441.6%
##HOUKXHoustonBlue Rooms210210021.0%
##HOU6ABHoustonNeil210021083.8%
##CHIKIDSXChicagoBlue Rooms20720702411.6%
##HOUKIDSXHoustonBlue Rooms1941940105.2%
##BOSKIDSXBostonBlue Rooms1921920189.4%
##DAL6ABDallasNeil184018410.5%
##ORL1FXOrlandoBlue Rooms1831830158.2%
##BOSLP2BostonLead Pronto1811810126.6%
##FLP2FloridaLead Pronto180180073.9%
##HOULP2HoustonLead Pronto177177052.8%
##NYGXNYBlue Rooms1751750179.7%
##ORL6ABOrlandoNeil174017400.0%
##NAKIDSXNashvilleBlue Rooms16616601911.4%
##NALP2NashvilleLead Pronto1631630169.8%
##DALKXDallasBlue Rooms158158042.5%
##NYKIDSXNYBlue Rooms15315301811.8%
##NA6ABNashvilleNeil150015042.7%
##CHILP2ChicagoLead Pronto143143053.5%
##CHIN1NChicagoNeil136013621.5%
##CHISNAPChicagoBlue Rooms135135064.4%
##CHI1FXChicagoBlue Rooms134134075.2%
##DALP2DallasLead Pronto133133053.8%
##BOS6ABBostonNeil129012975.4%
##CHIGXChicagoBlue Rooms127127053.9%
##ORLKXOrlandoBlue Rooms127127064.7%
##DAL1FXDallasBlue Rooms11211201614.3%
##NYLP2NYLead Pronto107107054.7%
##DAL3CX1FDallasAlan106106065.7%
##DALKIDSXDallasBlue Rooms105105098.6%
##HOUGXHoustonBlue Rooms102102022.0%
##NYSNAPNYBlue Rooms102102065.9%
##DALSNAPDallasBlue Rooms10110101413.9%
##FL3CX1FFloridaAlan999901010.1%
##FLN1NFloridaNeil9609633.1%
##ORLGXOrlandoBlue Rooms8888011.1%
##HOUN1NHoustonNeil8708700.0%
##FL01FloridaOrganic8408456.0%
##DALGXDallasBlue Rooms8383056.0%
##HOUSNAPHoustonBlue Rooms8181022.5%
##NYCMNNYNeil76076911.8%
##BOSGXBostonBlue Rooms7676056.6%
##NYN1NNYNeil7407422.7%
##DALN1NDallasNeil7407400.0%
##FL1FXFloridaBlue Rooms7373045.5%
##FLGXFloridaBlue Rooms7272000.0%
##NAN1NNashvilleNeil7207222.8%
##BOSSNAPBostonBlue Rooms7171068.5%
##CHICMNChicagoNeil6906945.8%
##BOSKXBostonBlue Rooms6868034.4%
##ORLN1NOrlandoNeil6306346.3%
##NASSNAPNashvilleBlue Rooms6363023.2%
##ORLSNAPOrlandoBlue Rooms6161023.3%
##BOSN1NBostonNeil6106111.6%
##NY1FXNYBlue Rooms6161011.6%
##FLSNAPFloridaBlue Rooms60600711.7%
##NASGXNashvilleBlue Rooms5959046.8%
##CHIIG23FChicagoAlan5858023.4%
##BO3CX1FBostonAlan5858011.7%
##CHIFB33FChicagoAlan5454000.0%
##HOU1FXHoustonBlue Rooms5454035.6%
##HOU3CX1FHoustonAlan5252047.7%
##HOUFB31MHoustonAlan5050012.0%
##HOUFB31FHoustonAlan4949012.0%
##DAL5ABDallasNeil49049714.3%
##FL5ABFloridaNeil4704700.0%
##DALCMNDallasNeil4604624.3%
##ORLCMNOrlandoNeil46046510.9%
##FLPXFloridaBlue Rooms4646000.0%
##CHIIG22FChicagoAlan4545012.2%
##BOS1FXBostonBlue Rooms44440715.9%
##DAL3CX1MDallasAlan4242049.5%
##NYPXNYBlue Rooms3939000.0%
##HOUCMNHoustonNeil3803812.6%
##NA1FXNashvilleBlue Rooms36360411.1%
##HOU5ABHoustonNeil3503500.0%
##CHI3CX1FChicagoAlan3535012.9%
##FL3CX1MFloridaAlan3333000.0%
##FLCMNFloridaNeil33033412.1%
##FL4IG32FFloridaAlan3131000.0%
##BOS5ABBostonNeil3103100.0%
##NACMNNashvilleNeil30030413.3%
##NY5ABNYNeil30030516.7%
##ORLFB32FOrlandoAlan2828000.0%
##BO3CX1MBostonAlan28280310.7%
##CHIIG21FChicagoAlan2626013.8%
##NA5ABNashvilleNeil2602600.0%
##BOSCMNBostonNeil2402414.2%
##CHIIG21MChicagoAlan2323000.0%
##NAIG21FNashvilleAlan2323000.0%
##NAIG23FNashvilleAlan2323014.3%
##ORL4IG32FOrlandoAlan2222000.0%
##NA3CX1FNashvilleAlan2222014.5%
##DALFB33FDallasAlan2222000.0%
##ORL4IG31FOrlandoAlan2121014.8%
##NAIG22FNashvilleAlan2020015.0%
##ORL4IG33FOrlandoAlan1818000.0%
##HOUFB33FHoustonAlan1818015.6%
##CHI3CX1MChicagoAlan1616016.3%
##BOIG23FBostonAlan1616000.0%
##BOSA1KBostonAlan1616000.0%
##HOU3CX1MHoustonAlan1515016.7%
##ORLFB31MOrlandoAlan15150213.3%
##DALFB31FDallasAlan15150533.3%
##ORLPXOrlandoBlue Rooms1515000.0%
##NASPXNashvilleBlue Rooms1414000.0%
##ORLFB31FOrlandoAlan1313017.7%
##NAIG23MNashvilleAlan1313000.0%
##HOUFB32FHoustonAlan1212018.3%
##FLFB32FFloridaAlan1111019.1%
##NAIG21MNashvilleAlan11110218.2%
##NAIG22MNashvilleAlan1111019.1%
##HOUPXHoustonBlue Rooms1111000.0%
##FL4IG31MFloridaAlan10100110.0%
##BOIG21MBostonAlan1010000.0%
##BOIG21FBostonAlan1010000.0%
##BO3CXBostonAlan1010000.0%
##CHIFB33MChicagoAlan10100110.0%
##FL4IG31FFloridaAlan1010000.0%
##BOIG22FBostonAlan1010000.0%
##DALFB31MDallasAlan99000.0%
##CHIFB31FChicagoAlan99000.0%
##BOIG23MBostonAlan99000.0%
##CHIPXChicagoBlue Rooms99000.0%
##BOSPXBostonBlue Rooms88000.0%
##NY3CX1FNYAlan77000.0%
##DALFB32FDallasAlan770228.6%
##FLFB31FFloridaAlan77000.0%
##NYFB31FNYAlan77000.0%
##DALFB33MDallasAlan66000.0%
##NYFB31MNYAlan660233.3%
##NA3CX1MNashvilleAlan66000.0%
##NAFB31FNashvilleAlan55000.0%
##HOU3CX2FHoustonAlan550240.0%
##FL3CX3FFloridaAlan55000.0%
##DAL3CX3FDallasAlan55000.0%
##HOUFB32MHoustonAlan55000.0%
##NAFB31MNashvilleAlan55000.0%
##BOIG22MBostonAlan44000.0%
##CHIA1MChicagoAlan44000.0%
##ORLP2ROrlandoLead Pronto404125.0%
##DALFB32MDallasAlan44000.0%
##CHIFB32FChicagoAlan44000.0%
##HOUFB33MHoustonAlan44000.0%
##CHIFB32MChicagoAlan44000.0%
##FLFB31MFloridaAlan44000.0%
##CHIFB31MChicagoAlan440125.0%
##DALPXDallasBlue Rooms44000.0%
##NYFB32FNYAlan33000.0%
##FL3CX2FFloridaAlan33000.0%
##BO3CX2MBostonAlan33000.0%
##BO3CX2FBostonAlan33000.0%
##HOU3CX2MHoustonAlan33000.0%
##FL3CX3MFloridaAlan330133.3%
##NY1FXRNYAlan20200.0%
##HOU3CX3MHoustonAlan22000.0%
##ORL4IG31MOrlandoAlan22000.0%
##NYFB33FNYAlan22000.0%
##HOU3DE3FHoustonAlan22000.0%
##HOUFB33FRHoustonAlan10100.0%
##HOU3DE1MRHoustonAlan10100.0%
##FLKIDSXRFloridaBlue Rooms10100.0%
##CHIIG21FRChicagoAlan10100.0%
##BOFB32FBostonAlan11000.0%
##BO3CX1FRBostonAlan10100.0%
##ORL1FXROrlandoAlan1011100.0%
##NY11FRNYAlan10100.0%
##CHI1FXRChicagoAlan10100.0%
##HOU3CX3FHoustonAlan1101100.0%
##NA4ABNashvilleAlan10100.0%
##HOU11FRHoustonAlan10100.0%
##NAFB33FNashvilleAlan11000.0%
##NA3CX1FRNashvilleAlan10100.0%
##FL3CX2MFloridaAlan11000.0%
##NYIG23FNYAlan11000.0%
##FL3CX1FRFloridaAlan10100.0%
##NYIG21FNYAlan11000.0%
##NYIG22FNYAlan11000.0%
##NYKXRNYAlan10100.0%
##BO3CX3MBostonAlan11000.0%
##BOSLP2RBostonLead Pronto10100.0%
##ORL5ABOrlandoNeil10100.0%
##NYIG21MNYAlan11000.0%
##BOS4ABBostonAlan10100.0%
##BOIG2BostonAlan11000.0%
##NA3CX3MNashvilleAlan11000.0%
##HOU3DE2FHoustonAlan11000.0%
##NYIG23MNYAlan11000.0%
##NAFB32MNashvilleAlan11000.0%
##NAFB32FNashvilleAlan11000.0%
##NY4ABNYAlan1011100.0%
##NA3CX3FNashvilleAlan11000.0%
TOTAL11,7858,7922,9935704.8%