_id	retail_area	month	sales	transactions	customers	ATV	ARPC
1	retail_area	month	sales	transactions	customers	ATV	ARPC
2	Bishopthorpe	2022-01-01 00:00:00	921405.76	74243	18949	12.4106752151718	48.6255612433374
3	Bishopthorpe	2022-02-01 00:00:00	1059856.82	78807	20931	13.4487649574276	50.6357469781664
4	Bishopthorpe	2022-03-01 00:00:00	1431980.17	91841	23553	15.5919488028223	60.79820702246
5	Bishopthorpe	2022-04-01 00:00:00	1280184.07	91777	26129	13.9488550508297	48.994759462666
6	Bishopthorpe	2022-05-01 00:00:00	1278403.7	93111	25327	13.7298890571468	50.4759229281004
7	Bishopthorpe	2022-06-01 00:00:00	1308622.29	97804	25997	13.3800487710114	50.3374347040043
8	Bishopthorpe	2022-07-01 00:00:00	1529888.04	97644	27147	15.6680189258941	56.3556945518842
9	Bishopthorpe	2022-08-01 00:00:00	1316979.38	93724	28703	14.051677051769	45.882987144201
10	Bishopthorpe	2022-09-01 00:00:00	1213709.43	86456	24787	14.0384638428796	48.9655638036067
11	Bishopthorpe	2022-10-01 00:00:00	1243399.86	90708	24621	13.7077199364995	50.5015986353113
12	Bishopthorpe	2022-11-01 00:00:00	1269027.43	91191	26628	13.9161477558092	47.6576321916779
13	Bishopthorpe	2022-12-01 00:00:00	1426148.67	96699	30183	14.7483290416654	47.250063611967
14	Bishopthorpe	2023-01-01 00:00:00	1036214.45	72573	18523	14.278236396456	55.9420423257572
15	Bishopthorpe	2023-02-01 00:00:00	1108313.75	79962	22624	13.8605056151672	48.9884083274399
16	Bishopthorpe	2023-03-01 00:00:00	1145985.31	86206	22981	13.2935678491056	49.8666424437579
17	Bishopthorpe	2023-04-01 00:00:00	1260420.35	86672	25342	14.5424168128115	49.7364197774446
18	Bishopthorpe	2023-05-01 00:00:00	1194909.78	87945	24313	13.5870121098414	49.1469493686505
19	Bishopthorpe	2023-06-01 00:00:00	1394931.19	93766	25923	14.8767270652475	53.8105616633877
20	Bishopthorpe	2023-07-01 00:00:00	1319615.02	97807	27462	13.49203042727	48.0524004078363
21	Bishopthorpe	2023-08-01 00:00:00	1227357.74	90592	26050	13.5481912310138	47.115460268714
22	Bishopthorpe	2023-09-01 00:00:00	1300824.21	93613	24607	13.8957645839787	52.8639903279555
23	Bishopthorpe	2023-10-01 00:00:00	1171226.83	87341	23280	13.4098170389622	50.3104308419244
24	Bishopthorpe	2023-11-01 00:00:00	1333780.19	96391	27859	13.8371859405961	47.8760971319861
25	Bishopthorpe	2023-12-01 00:00:00	1504467.48	100281	33740	15.0025177251922	44.590026081802
26	Bishopthorpe	2024-01-01 00:00:00	1020670.14	76437	19233	13.3530899956827	53.0686913118078
27	Bishopthorpe	2024-02-01 00:00:00	1086446.11	81555	21818	13.3216370547483	49.7958616738473
28	Bishopthorpe	2024-03-01 00:00:00	1263799.12	92171	22982	13.7114615226047	54.9908241232269
29	Bishopthorpe	2024-04-01 00:00:00	1218359.45	90227	22874	13.5032689771354	53.263943778963
30	Bishopthorpe	2024-05-01 00:00:00	1458060.09	101796	27448	14.3233534716492	53.120813538327
31	Bishopthorpe	2024-06-01 00:00:00	1375962.14	97511	25511	14.1108402128991	53.9360330837678
32	Bishopthorpe	2024-07-01 00:00:00	1363898.58	94668	25023	14.407176448219	54.5057978659633
33	Bishopthorpe	2024-08-01 00:00:00	1476264.7	92799	27986	15.9081962090109	52.7501143428857
34	Bishopthorpe	2024-09-01 00:00:00	1261966.58	86382	23320	14.6091382463939	54.115204974271
35	Bishopthorpe	2024-10-01 00:00:00	1243462.77	91887	24219	13.532521140096	51.3424489037533
36	Bishopthorpe	2024-11-01 00:00:00	1353150.76	91458	23271	14.7953241925255	58.1475123544326
37	Bishopthorpe	2024-12-01 00:00:00	1472655.28	88981	24222	16.5502217327295	60.7982528280076
38	Bishopthorpe	2025-01-01 00:00:00	1102802.3	79306	19176	13.9056603535672	57.5095066750104
39	Bishopthorpe	2025-02-01 00:00:00	1160223.03	79712	19772	14.5551865465676	58.680104693506
40	Bishopthorpe	2025-03-01 00:00:00	1439300.77	95404	24365	15.0863776151943	59.0724715780833
41	Bishopthorpe	2025-04-01 00:00:00	1286701.63	92545	24452	13.9035240153439	52.6215291182725
42	Heworth	2022-01-01 00:00:00	418567.6	35074	9567	11.9338427325084	43.7511863698129
43	Heworth	2022-02-01 00:00:00	316343.39	30612	8466	10.3339667450673	37.3663347507678
44	Heworth	2022-03-01 00:00:00	445167.59	39422	11021	11.2923644158084	40.3926676345159
45	Heworth	2022-04-01 00:00:00	399207.3	36001	10915	11.0887836448988	36.5741914796152
46	Heworth	2022-05-01 00:00:00	364340.33	33142	11084	10.9933115080562	32.8708345362685
47	Heworth	2022-06-01 00:00:00	411265.66	38062	11357	10.805151069308	36.2125261952981
48	Heworth	2022-07-01 00:00:00	432376.44	40265	12148	10.738269961505	35.5923971024037
49	Heworth	2022-08-01 00:00:00	418621.16	36714	11533	11.4022214958871	36.2976814358796
50	Heworth	2022-09-01 00:00:00	367707.45	32842	10878	11.1962563181292	33.8028543849972
51	Heworth	2022-10-01 00:00:00	426193.29	32310	10404	13.1907548746518	40.9643685121107
52	Heworth	2022-11-01 00:00:00	369402.17	33876	10209	10.9045392017948	36.183971985503
53	Heworth	2022-12-01 00:00:00	429144.71	35068	10815	12.2375017109616	39.6805094775774
54	Heworth	2023-01-01 00:00:00	375541.63	30689	9324	12.2370109811333	40.2768800943801
55	Heworth	2023-02-01 00:00:00	355732.51	32151	11065	11.0644306553451	32.1493456845911
56	Heworth	2023-03-01 00:00:00	433795.78	35346	11688	12.2728393594749	37.114628678987
57	Heworth	2023-04-01 00:00:00	528232.66	35049	11535	15.0712619475591	45.7939020372779
58	Heworth	2023-05-01 00:00:00	478331.28	37775	12916	12.6626414295169	37.0340105295757
59	Heworth	2023-06-01 00:00:00	445808.02	34767	12168	12.8227347772313	36.6377399737015
60	Heworth	2023-07-01 00:00:00	396742.46	33556	11627	11.8232941947789	34.1225131160231
61	Heworth	2023-08-01 00:00:00	424833.99	35368	11470	12.011818310337	37.0387088055798
62	Heworth	2023-09-01 00:00:00	451760.76	34431	11230	13.1207562951991	40.2280284951024
63	Heworth	2023-10-01 00:00:00	452222.97	31452	10318	14.3781943914536	43.8285491374297
64	Heworth	2023-11-01 00:00:00	442243.42	32673	10415	13.5354396596578	42.4621622659626
65	Heworth	2023-12-01 00:00:00	402326.66	32059	10480	12.5495698555788	38.3899484732824
66	Heworth	2024-01-01 00:00:00	383041.91	29113	10026	13.1570745027994	38.2048583682426
67	Heworth	2024-02-01 00:00:00	392169.22	30261	10080	12.9595591685668	38.9056765873016
68	Heworth	2024-03-01 00:00:00	412390.03	31203	10216	13.2163583629779	40.3670741973375
69	Heworth	2024-04-01 00:00:00	356187.56	29323	9629	12.1470367970535	36.9911268044449
70	Heworth	2024-05-01 00:00:00	417939.67	32315	10960	12.9333024911032	38.1331815693431
71	Heworth	2024-06-01 00:00:00	398005.78	32460	10995	12.2614226740604	36.1987976352888
72	Heworth	2024-07-01 00:00:00	435531	29950	12079	14.5419365609349	36.0568755691696
73	Heworth	2024-08-01 00:00:00	424250.99	29640	10068	14.3134612010796	42.1385568136671
74	Heworth	2024-09-01 00:00:00	387259.31	29406	10674	13.1693977419574	36.2806173880457
75	Heworth	2024-10-01 00:00:00	418460.15	29385	10726	14.2406040496852	39.0136257691591
76	Heworth	2024-11-01 00:00:00	442961.02	28345	10236	15.6274835067913	43.2748163345057
77	Heworth	2024-12-01 00:00:00	432733.17	28473	10102	15.1980181224318	42.8363858641853
78	Heworth	2025-01-01 00:00:00	347174.24	27120	10090	12.8014100294985	34.4077542120912
79	Heworth	2025-02-01 00:00:00	473344.51	29824	11391	15.871261735515	41.5542542358002
80	Heworth	2025-03-01 00:00:00	427450.98	33532	11202	12.7475539782894	38.1584520621318
81	Heworth	2025-04-01 00:00:00	481637.78	34201	12025	14.0825642525072	40.0530378378378
82	Micklegate	2022-01-01 00:00:00	1282909.87	117976	51111	10.8743292703601	25.1004650662284
83	Micklegate	2022-02-01 00:00:00	1794912.42	148482	69654	12.08841758597	25.768978378844
84	Micklegate	2022-03-01 00:00:00	1696356.98	171989	73561	9.86317136561059	23.0605481165291
85	Micklegate	2022-04-01 00:00:00	1998565.35	175662	84956	11.377334597124	23.5247110268845
86	Micklegate	2022-05-01 00:00:00	1802609.59	174380	80229	10.3372496272508	22.4683043537873
87	Micklegate	2022-06-01 00:00:00	1620932.76	162836	72585	9.95438821882139	22.3315114693118
88	Micklegate	2022-07-01 00:00:00	1840413.07	174402	79571	10.5527062189654	23.129193676088
89	Micklegate	2022-08-01 00:00:00	2043679.2	192624	91155	10.6096810366309	22.4198255718282
90	Micklegate	2022-09-01 00:00:00	1629451.1	162340	73474	10.037274239251	22.1772477338923
91	Micklegate	2022-10-01 00:00:00	2075081.38	193661	88281	10.7150194411885	23.5054131693116
92	Micklegate	2022-11-01 00:00:00	1930423.85	189003	83634	10.2137206816823	23.081807040199
93	Micklegate	2022-12-01 00:00:00	2512528.79	222150	112165	11.31005532298	22.4002923371818
94	Micklegate	2023-01-01 00:00:00	1445472.46	156504	61923	9.23600968665338	23.3430625131211
95	Micklegate	2023-02-01 00:00:00	1879530.5	186102	82316	10.0994642722808	22.8331126390981
96	Micklegate	2023-03-01 00:00:00	1763652.5	187808	75890	9.39072084256262	23.2395901963368
97	Micklegate	2023-04-01 00:00:00	2089709.34	198149	90111	10.5461513305644	23.1903911842061
98	Micklegate	2023-05-01 00:00:00	1942440.79	195477	82822	9.93692756692603	23.4531983047982
99	Micklegate	2023-06-01 00:00:00	1655714.45	180379	77642	9.17908653446355	21.3249845444476
100	Micklegate	2023-07-01 00:00:00	2175373.13	214756	92529	10.1295103745646	23.5101765932843
101	Micklegate	2023-08-01 00:00:00	2018954.98	210738	97410	9.58040305972345	20.7263625911097
102	Micklegate	2023-09-01 00:00:00	1870110.85	194332	79395	9.6232779470185	23.5545166572202
103	Micklegate	2023-10-01 00:00:00	2091887.94	209154	85292	10.0016635589087	24.5261916709656
104	Micklegate	2023-11-01 00:00:00	2059372.58	226188	97183	9.1046942366527	21.1906668861838
105	Micklegate	2023-12-01 00:00:00	2488110.09	244190	114498	10.1892382570949	21.730598700414
106	Micklegate	2024-01-01 00:00:00	1474954	181117	63979	8.14365299778596	23.0537207521218
107	Micklegate	2024-02-01 00:00:00	2240249.4	214087	87303	10.4642010023962	25.6606233462768
108	Micklegate	2024-03-01 00:00:00	2061584.75	220545	86517	9.34768301253712	23.828666620433
109	Micklegate	2024-04-01 00:00:00	2102475.26	216254	84595	9.72224911446725	24.8534223062829
110	Micklegate	2024-05-01 00:00:00	2248085.72	224466	85556	10.0152616431887	26.2761900977138
111	Micklegate	2024-06-01 00:00:00	1945700.42	208317	82091	9.3400942793915	23.7017507400324
112	Micklegate	2024-07-01 00:00:00	2069673.27	220790	89835	9.37394478916618	23.0386071130406
113	Micklegate	2024-08-01 00:00:00	2359187.43	226661	100258	10.4084400492365	23.5311638971454
114	Micklegate	2024-09-01 00:00:00	2011588.93	208640	82528	9.64143467216258	24.3746235217138
115	Micklegate	2024-10-01 00:00:00	2246213.61	220932	91591	10.1669907935473	24.5243922437794
116	Micklegate	2024-11-01 00:00:00	2440940.41	223806	106689	10.9065012108701	22.8790260476713
117	Micklegate	2024-12-01 00:00:00	2971182.77	237363	117761	12.5174638423006	25.2306176917655
118	Micklegate	2025-01-01 00:00:00	1694563.44	164466	68050	10.3034270913137	24.9017404849375
119	Micklegate	2025-02-01 00:00:00	2221416.06	192588	86725	11.5345507508256	25.6144832516575
120	Micklegate	2025-03-01 00:00:00	2097093.78	197736	84334	10.605523425173	24.866528090687
121	Micklegate	2025-04-01 00:00:00	2028251.53	186084	87449	10.8996556931278	23.1935360038422