Recycled Lead Codes

Refresh re-pulls the last 7 days only — everything older is settled and read from cache (this build: 1 window pulled, 0 cached). Full rebuild re-pulls the whole range.

A lead that later becomes CMN is removed from the recycled code it arrived on — 0 rows dropped in this range, so nobody is counted under two families. Only visible within the dates shown: someone who came in on 6AB before this range and CMN inside it is not caught.

Recycled counts every lead once — the families and the R codes together. It is not the sum of the columns: a code like #DAL4ABR is both 4AB and R, so it appears in two columns but is one person. The Recycled figure always equals the row count of that day's CSV. The newest day is provisional — it fills in through the day, and the CRM rewrites codes onto past hours after the fact. The CSV column downloads just that day's leads — marketing code, name, age, sex, phone, email, address.

Date	6AB	N1N	CMN	5AB	R codes	Recycled	All leads	% of day	CSV
Wed 16 Sep	201	63	38	50	49	401	1,483	27.0%	⬇ CSV
TOTAL	201	63	38	50	49	401	1,483	27.0%	⬇ all 1 days

Every recycled code, per day (61 codes)

Code	Family	City	16/09	Total
#NY6AB	6AB	New York	41	41
#HOU6AB	6AB	Houston	39	39
#DAL6AB	6AB	Dallas	24	24
#CHI6AB	6AB	Chicago	23	23
#BOS6AB	6AB	Boston	22	22
#FL6AB	6AB	Florida	21	21
#NA6AB	6AB	Nashville	21	21
#NYN1N	N1N	New York	13	13
#NYCMN	CMN	New York	12	12
#ORLN1N	N1N	Orlando	11	11
#ORL6AB	6AB	Orlando	10	10
#NA5AB	5AB	Nashville	9	9
#HOUCMN	CMN	Houston	9	9
#FL5AB	5AB	Florida	9	9
#NY5AB	5AB	New York	9	9
#FLN1N	N1N	Florida	8	8
#NAN1N	N1N	Nashville	7	7
#HOU5AB	5AB	Houston	7	7
#BOSN1N	N1N	Boston	7	7
#CHIN1N	N1N	Chicago	7	7
#DALN1N	N1N	Dallas	6	6
#BOS5AB	5AB	Boston	6	6
#CHI5AB	5AB	Chicago	6	6
#CHI1FXR	R	Chicago	5	5
#HOUN1N	N1N	Houston	4	4
#CHICMN	CMN	Chicago	4	4
#ORL1FXR	R	Orlando	4	4
#NACMN	CMN	Nashville	4	4
#FLFB31MR	R	Florida	3	3
#ORLP2R	R	Orlando	3	3
#FL1FXR	R	Florida	3	3
#ORL5AB	5AB	Orlando	3	3
#FLCMN	CMN	Florida	3	3
#DALCMN	CMN	Dallas	3	3
#HOULP2R	R	Houston	2	2
#NA1FXR	R	Nashville	2	2
#ORLGXR	R	Orlando	2	2
#NALP2R	R	Nashville	2	2
#CHISNAPR	R	Chicago	2	2
#HOU1FXR	R	Houston	2	2
#BOSCMN	CMN	Boston	2	2
#NY1FXR	R	New York	2	2
#CHIGXR	R	Chicago	1	1
#BOS1FXR	R	Boston	1	1
#BOSLP2R	R	Boston	1	1
#DAL5AB	5AB	Dallas	1	1
#DALSNAPR	R	Dallas	1	1
#ORLCMN	CMN	Orlando	1	1
#NA3CX1MR	R	Nashville	1	1
#HOU3CX2MR	R	Houston	1	1
#FLFB31FR	R	Florida	1	1
#HOUFB32MR	R	Houston	1	1
#DAL1FXR	R	Dallas	1	1
#CHI3CX1FR	R	Chicago	1	1
#ORLFB31FR	R	Orlando	1	1
#NYSNAPR	R	New York	1	1
#HOU3CX1FR	R	Houston	1	1
#HOUGXR	R	Houston	1	1
#CHIKIDSXR	R	Chicago	1	1
#DAL3CX1FR	R	Dallas	1	1
#NASGXR	R	Nashville	1	1

Recycled leads by city (Total counts each lead once; the columns overlap)

City	6AB	N1N	CMN	5AB	R codes	Total	% of all recycled
New York	41 53%	13 17%	12 15%	9 12%	3 4%	78	19.5%
Houston	39 58%	4 6%	9 13%	7 10%	8 12%	67	16.7%
Chicago	23 46%	7 14%	4 8%	6 12%	10 20%	50	12.5%
Florida	21 44%	8 17%	3 6%	9 19%	7 15%	48	12.0%
Nashville	21 45%	7 15%	4 9%	9 19%	6 13%	47	11.7%
Boston	22 56%	7 18%	2 5%	6 15%	2 5%	39	9.7%
Dallas	24 65%	6 16%	3 8%	1 3%	3 8%	37	9.2%
Orlando	10 29%	11 31%	1 3%	3 9%	10 29%	35	8.7%

Weekly totals and per-day average (weeks start Monday; part-weeks at each end)

Week beginning	Days	6AB/day	N1N/day	CMN/day	5AB/day	R/day	Recycled	Per day
Mon 14 Sep	1	201.0	63.0	38.0	50.0	49.0	401	401

New York — recycled leads by day (78 of 401 in this range, 19.5%)

"All leads" is every lead that came into New York that day, whatever the code — so the % is this city's own recycled share, not its share of the network.

Date	6AB	N1N	CMN	5AB	R codes	Recycled	All leads	% of day
Wed 16 Sep	41	13	12	9	3	78	127	61.4%
TOTAL	41	13	12	9	3	78	127	61.4%

Houston — recycled leads by day (67 of 401 in this range, 16.7%)

"All leads" is every lead that came into Houston that day, whatever the code — so the % is this city's own recycled share, not its share of the network.

Date	6AB	N1N	CMN	5AB	R codes	Recycled	All leads	% of day
Wed 16 Sep	39	4	9	7	8	67	210	31.9%
TOTAL	39	4	9	7	8	67	210	31.9%

Chicago — recycled leads by day (50 of 401 in this range, 12.5%)

"All leads" is every lead that came into Chicago that day, whatever the code — so the % is this city's own recycled share, not its share of the network.

Date	6AB	N1N	CMN	5AB	R codes	Recycled	All leads	% of day
Wed 16 Sep	23	7	4	6	10	50	196	25.5%
TOTAL	23	7	4	6	10	50	196	25.5%

Florida — recycled leads by day (48 of 401 in this range, 12.0%)

"All leads" is every lead that came into Florida that day, whatever the code — so the % is this city's own recycled share, not its share of the network.

Date	6AB	N1N	CMN	5AB	R codes	Recycled	All leads	% of day
Wed 16 Sep	21	8	3	9	7	48	264	18.2%
TOTAL	21	8	3	9	7	48	264	18.2%

Nashville — recycled leads by day (47 of 401 in this range, 11.7%)

"All leads" is every lead that came into Nashville that day, whatever the code — so the % is this city's own recycled share, not its share of the network.

Date	6AB	N1N	CMN	5AB	R codes	Recycled	All leads	% of day
Wed 16 Sep	21	7	4	9	6	47	132	35.6%
TOTAL	21	7	4	9	6	47	132	35.6%

Boston — recycled leads by day (39 of 401 in this range, 9.7%)

"All leads" is every lead that came into Boston that day, whatever the code — so the % is this city's own recycled share, not its share of the network.

Date	6AB	N1N	CMN	5AB	R codes	Recycled	All leads	% of day
Wed 16 Sep	22	7	2	6	2	39	163	23.9%
TOTAL	22	7	2	6	2	39	163	23.9%

Dallas — recycled leads by day (37 of 401 in this range, 9.2%)

"All leads" is every lead that came into Dallas that day, whatever the code — so the % is this city's own recycled share, not its share of the network.

Date	6AB	N1N	CMN	5AB	R codes	Recycled	All leads	% of day
Wed 16 Sep	24	6	3	1	3	37	207	17.9%
TOTAL	24	6	3	1	3	37	207	17.9%

Orlando — recycled leads by day (35 of 401 in this range, 8.7%)

"All leads" is every lead that came into Orlando that day, whatever the code — so the % is this city's own recycled share, not its share of the network.

Date	6AB	N1N	CMN	5AB	R codes	Recycled	All leads	% of day
Wed 16 Sep	10	11	1	3	10	35	126	27.8%
TOTAL	10	11	1	3	10	35	126	27.8%

Recycled Lead Codes by day