Grabbing results from https://api.safelincs.co.uk/api/revenue...Done.
Entries from last 60 days deleted

INSERT INTO revenue SET day = '2024-03-04', brand_id = '3242', brand_name = 'Amazon', value = 20012.1500;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3243', brand_name = 'eBay Safelincs', value = 5359.4200;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3244', brand_name = 'Draughtex', value = 625.3800;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3247', brand_name = 'Budget Fire', value = 439.9600;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3249', brand_name = 'Church Marketplace', value = 541.5000;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3250', brand_name = 'eBay Draughtex', value = 23.2400;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3262', brand_name = 'Gapseal', value = 23.3200;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3265', brand_name = 'ManoMano', value = 263.1000;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3270', brand_name = 'Safelincs', value = 44563.8900;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3271', brand_name = 'The Defib Pad', value = 6546.8900;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3276', brand_name = 'Safelincs BDM', value = 3184.9700;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 1542.2600;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3285', brand_name = 'Spectrum', value = 205.6800;
INSERT INTO revenue SET day = '2024-03-04', brand_id = '3286', brand_name = 'B and Q', value = 4474.9500;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3242', brand_name = 'Amazon', value = 16867.0600;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1244.2600;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3244', brand_name = 'Draughtex', value = 240.9800;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3247', brand_name = 'Budget Fire', value = 585.2100;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3265', brand_name = 'ManoMano', value = 172.9100;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3270', brand_name = 'Safelincs', value = 51816.8800;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3271', brand_name = 'The Defib Pad', value = 3686.7700;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3276', brand_name = 'Safelincs BDM', value = 5334.8000;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3277', brand_name = 'Dropship', value = 443.8800;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 1412.1100;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 103.9500;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3282', brand_name = 'The Defib Pad Proforma', value = 1171.0500;
INSERT INTO revenue SET day = '2024-03-05', brand_id = '3286', brand_name = 'B and Q', value = 1212.0400;
INSERT INTO revenue SET day = '2024-03-06', brand_id = '3242', brand_name = 'Amazon', value = 26573.8200;
INSERT INTO revenue SET day = '2024-03-06', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1936.4900;
INSERT INTO revenue SET day = '2024-03-06', brand_id = '3244', brand_name = 'Draughtex', value = 248.6200;
INSERT INTO revenue SET day = '2024-03-06', brand_id = '3247', brand_name = 'Budget Fire', value = 352.8900;
INSERT INTO revenue SET day = '2024-03-06', brand_id = '3262', brand_name = 'Gapseal', value = 34.9800;
INSERT INTO revenue SET day = '2024-03-06', brand_id = '3270', brand_name = 'Safelincs', value = 23309.4000;
INSERT INTO revenue SET day = '2024-03-06', brand_id = '3271', brand_name = 'The Defib Pad', value = 6187.6600;
INSERT INTO revenue SET day = '2024-03-06', brand_id = '3276', brand_name = 'Safelincs BDM', value = 537.2200;
INSERT INTO revenue SET day = '2024-03-06', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 5770.4200;
INSERT INTO revenue SET day = '2024-03-06', brand_id = '3286', brand_name = 'B and Q', value = 1415.0700;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3242', brand_name = 'Amazon', value = 17748.7600;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1082.7100;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3244', brand_name = 'Draughtex', value = 343.9000;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3247', brand_name = 'Budget Fire', value = 241.3000;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3270', brand_name = 'Safelincs', value = 20508.6600;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3271', brand_name = 'The Defib Pad', value = 2180.7500;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3276', brand_name = 'Safelincs BDM', value = 2786.8300;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3277', brand_name = 'Dropship', value = 198.3500;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 16448.4500;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 10612.4700;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3285', brand_name = 'Spectrum', value = 78.7400;
INSERT INTO revenue SET day = '2024-03-07', brand_id = '3286', brand_name = 'B and Q', value = 894.6100;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3242', brand_name = 'Amazon', value = 17753.8000;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1587.6900;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3244', brand_name = 'Draughtex', value = 348.1600;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3247', brand_name = 'Budget Fire', value = 4430.9500;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3250', brand_name = 'eBay Draughtex', value = 26.1600;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3270', brand_name = 'Safelincs', value = 40836.0400;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3271', brand_name = 'The Defib Pad', value = 6644.4700;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3276', brand_name = 'Safelincs BDM', value = 6824.5800;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 1559.4400;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 1129.0400;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3282', brand_name = 'The Defib Pad Proforma', value = 105.0000;
INSERT INTO revenue SET day = '2024-03-08', brand_id = '3286', brand_name = 'B and Q', value = 2216.1800;
INSERT INTO revenue SET day = '2024-03-09', brand_id = '3242', brand_name = 'Amazon', value = 11025.6300;
INSERT INTO revenue SET day = '2024-03-09', brand_id = '3270', brand_name = 'Safelincs', value = -29.6100;
INSERT INTO revenue SET day = '2024-03-10', brand_id = '3242', brand_name = 'Amazon', value = 17856.6100;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3242', brand_name = 'Amazon', value = 24031.0200;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3243', brand_name = 'eBay Safelincs', value = 3227.5000;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3244', brand_name = 'Draughtex', value = 436.7400;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3262', brand_name = 'Gapseal', value = 46.6400;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3265', brand_name = 'ManoMano', value = 17.4500;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3270', brand_name = 'Safelincs', value = 36813.2200;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3271', brand_name = 'The Defib Pad', value = 5407.5000;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3276', brand_name = 'Safelincs BDM', value = 6740.0500;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 1565.1100;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 290.9600;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3282', brand_name = 'The Defib Pad Proforma', value = 1034.0000;
INSERT INTO revenue SET day = '2024-03-11', brand_id = '3286', brand_name = 'B and Q', value = 3088.2600;
INSERT INTO revenue SET day = '2024-03-12', brand_id = '3242', brand_name = 'Amazon', value = 26079.1700;
INSERT INTO revenue SET day = '2024-03-12', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1759.0300;
INSERT INTO revenue SET day = '2024-03-12', brand_id = '3244', brand_name = 'Draughtex', value = 186.4100;
INSERT INTO revenue SET day = '2024-03-12', brand_id = '3247', brand_name = 'Budget Fire', value = 1297.8700;
INSERT INTO revenue SET day = '2024-03-12', brand_id = '3265', brand_name = 'ManoMano', value = 137.4900;
INSERT INTO revenue SET day = '2024-03-12', brand_id = '3270', brand_name = 'Safelincs', value = 26310.2800;
INSERT INTO revenue SET day = '2024-03-12', brand_id = '3271', brand_name = 'The Defib Pad', value = 6505.7300;
INSERT INTO revenue SET day = '2024-03-12', brand_id = '3276', brand_name = 'Safelincs BDM', value = 1734.4400;
INSERT INTO revenue SET day = '2024-03-12', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 4986.7000;
INSERT INTO revenue SET day = '2024-03-12', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 5407.6500;
INSERT INTO revenue SET day = '2024-03-12', brand_id = '3286', brand_name = 'B and Q', value = 1231.4500;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3242', brand_name = 'Amazon', value = 23649.8300;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1726.0400;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3244', brand_name = 'Draughtex', value = 300.7300;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3248', brand_name = 'Actfire', value = 12.7400;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3265', brand_name = 'ManoMano', value = .0000;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3268', brand_name = 'Parish Buying', value = 137.5000;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3270', brand_name = 'Safelincs', value = 33599.4900;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3271', brand_name = 'The Defib Pad', value = 7009.1100;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3276', brand_name = 'Safelincs BDM', value = 2000.2800;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 2420.8400;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 22278.5800;
INSERT INTO revenue SET day = '2024-03-13', brand_id = '3286', brand_name = 'B and Q', value = 3457.9300;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3242', brand_name = 'Amazon', value = 22445.3200;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1588.2400;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3244', brand_name = 'Draughtex', value = 147.4500;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3262', brand_name = 'Gapseal', value = 23.3200;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3265', brand_name = 'ManoMano', value = 386.8000;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3268', brand_name = 'Parish Buying', value = 137.7500;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3270', brand_name = 'Safelincs', value = 39164.6700;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3271', brand_name = 'The Defib Pad', value = 5609.1600;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3276', brand_name = 'Safelincs BDM', value = 1725.4500;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 20477.0700;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 34.0100;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3285', brand_name = 'Spectrum', value = 313.2500;
INSERT INTO revenue SET day = '2024-03-14', brand_id = '3286', brand_name = 'B and Q', value = 1012.3600;
INSERT INTO revenue SET day = '2024-03-15', brand_id = '3242', brand_name = 'Amazon', value = 21908.8700;
INSERT INTO revenue SET day = '2024-03-15', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1075.9800;
INSERT INTO revenue SET day = '2024-03-15', brand_id = '3244', brand_name = 'Draughtex', value = 122.4000;
INSERT INTO revenue SET day = '2024-03-15', brand_id = '3247', brand_name = 'Budget Fire', value = 714.0000;
INSERT INTO revenue SET day = '2024-03-15', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-03-15', brand_id = '3270', brand_name = 'Safelincs', value = 34545.1600;
INSERT INTO revenue SET day = '2024-03-15', brand_id = '3271', brand_name = 'The Defib Pad', value = 2312.0700;
INSERT INTO revenue SET day = '2024-03-15', brand_id = '3276', brand_name = 'Safelincs BDM', value = 4377.4400;
INSERT INTO revenue SET day = '2024-03-15', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 15838.2000;
INSERT INTO revenue SET day = '2024-03-15', brand_id = '3286', brand_name = 'B and Q', value = 1070.1800;
INSERT INTO revenue SET day = '2024-03-16', brand_id = '3242', brand_name = 'Amazon', value = 13166.3100;
INSERT INTO revenue SET day = '2024-03-16', brand_id = '3243', brand_name = 'eBay Safelincs', value = -24.5200;
INSERT INTO revenue SET day = '2024-03-16', brand_id = '3270', brand_name = 'Safelincs', value = -28.7000;
INSERT INTO revenue SET day = '2024-03-17', brand_id = '3242', brand_name = 'Amazon', value = 14918.0500;
INSERT INTO revenue SET day = '2024-03-17', brand_id = '3270', brand_name = 'Safelincs', value = -303.9900;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3242', brand_name = 'Amazon', value = 24705.8200;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3243', brand_name = 'eBay Safelincs', value = 3737.7300;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3244', brand_name = 'Draughtex', value = 464.3300;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3247', brand_name = 'Budget Fire', value = 388.6000;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3265', brand_name = 'ManoMano', value = 34.5200;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3270', brand_name = 'Safelincs', value = 28772.0500;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3271', brand_name = 'The Defib Pad', value = 1439.4900;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3276', brand_name = 'Safelincs BDM', value = 518.1700;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 3426.4400;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 442.2200;
INSERT INTO revenue SET day = '2024-03-18', brand_id = '3286', brand_name = 'B and Q', value = 3459.7000;
INSERT INTO revenue SET day = '2024-03-19', brand_id = '3242', brand_name = 'Amazon', value = 24709.1300;
INSERT INTO revenue SET day = '2024-03-19', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1821.3600;
INSERT INTO revenue SET day = '2024-03-19', brand_id = '3244', brand_name = 'Draughtex', value = 212.8000;
INSERT INTO revenue SET day = '2024-03-19', brand_id = '3247', brand_name = 'Budget Fire', value = 171.2800;
INSERT INTO revenue SET day = '2024-03-19', brand_id = '3270', brand_name = 'Safelincs', value = 30304.8600;
INSERT INTO revenue SET day = '2024-03-19', brand_id = '3271', brand_name = 'The Defib Pad', value = 6332.6100;
INSERT INTO revenue SET day = '2024-03-19', brand_id = '3276', brand_name = 'Safelincs BDM', value = 3121.5900;
INSERT INTO revenue SET day = '2024-03-19', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 1682.3400;
INSERT INTO revenue SET day = '2024-03-19', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 310.5200;
INSERT INTO revenue SET day = '2024-03-19', brand_id = '3282', brand_name = 'The Defib Pad Proforma', value = 740.0000;
INSERT INTO revenue SET day = '2024-03-19', brand_id = '3286', brand_name = 'B and Q', value = 1653.7100;
INSERT INTO revenue SET day = '2024-03-20', brand_id = '3242', brand_name = 'Amazon', value = 25848.3900;
INSERT INTO revenue SET day = '2024-03-20', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1652.0000;
INSERT INTO revenue SET day = '2024-03-20', brand_id = '3244', brand_name = 'Draughtex', value = 74.5300;
INSERT INTO revenue SET day = '2024-03-20', brand_id = '3247', brand_name = 'Budget Fire', value = 66.9900;
INSERT INTO revenue SET day = '2024-03-20', brand_id = '3270', brand_name = 'Safelincs', value = 21899.4900;
INSERT INTO revenue SET day = '2024-03-20', brand_id = '3271', brand_name = 'The Defib Pad', value = 4756.0000;
INSERT INTO revenue SET day = '2024-03-20', brand_id = '3276', brand_name = 'Safelincs BDM', value = 945.6700;
INSERT INTO revenue SET day = '2024-03-20', brand_id = '3277', brand_name = 'Dropship', value = 238.6800;
INSERT INTO revenue SET day = '2024-03-20', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 6132.8200;
INSERT INTO revenue SET day = '2024-03-20', brand_id = '3285', brand_name = 'Spectrum', value = 424.6400;
INSERT INTO revenue SET day = '2024-03-20', brand_id = '3286', brand_name = 'B and Q', value = 977.6500;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3242', brand_name = 'Amazon', value = 27316.2300;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1445.8800;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3244', brand_name = 'Draughtex', value = 125.7700;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3247', brand_name = 'Budget Fire', value = 86.9800;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3248', brand_name = 'Actfire', value = 10.1500;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3265', brand_name = 'ManoMano', value = 17.4500;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3270', brand_name = 'Safelincs', value = 50267.9700;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3271', brand_name = 'The Defib Pad', value = 7573.9900;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3276', brand_name = 'Safelincs BDM', value = 12260.5800;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 10146.9900;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 4723.5300;
INSERT INTO revenue SET day = '2024-03-21', brand_id = '3286', brand_name = 'B and Q', value = 885.8100;
INSERT INTO revenue SET day = '2024-03-22', brand_id = '3242', brand_name = 'Amazon', value = 10108.4400;
INSERT INTO revenue SET day = '2024-03-22', brand_id = '3243', brand_name = 'eBay Safelincs', value = 833.5400;
INSERT INTO revenue SET day = '2024-03-22', brand_id = '3244', brand_name = 'Draughtex', value = 135.3500;
INSERT INTO revenue SET day = '2024-03-22', brand_id = '3270', brand_name = 'Safelincs', value = 39730.6700;
INSERT INTO revenue SET day = '2024-03-22', brand_id = '3271', brand_name = 'The Defib Pad', value = 5086.6100;
INSERT INTO revenue SET day = '2024-03-22', brand_id = '3276', brand_name = 'Safelincs BDM', value = 983.0000;
INSERT INTO revenue SET day = '2024-03-22', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 934.8700;
INSERT INTO revenue SET day = '2024-03-22', brand_id = '3286', brand_name = 'B and Q', value = 1205.6700;
INSERT INTO revenue SET day = '2024-03-23', brand_id = '3242', brand_name = 'Amazon', value = 9304.6500;
INSERT INTO revenue SET day = '2024-03-23', brand_id = '3270', brand_name = 'Safelincs', value = -29.1700;
INSERT INTO revenue SET day = '2024-03-24', brand_id = '3242', brand_name = 'Amazon', value = 26248.4800;
INSERT INTO revenue SET day = '2024-03-25', brand_id = '3242', brand_name = 'Amazon', value = 20519.7100;
INSERT INTO revenue SET day = '2024-03-25', brand_id = '3243', brand_name = 'eBay Safelincs', value = 4407.9700;
INSERT INTO revenue SET day = '2024-03-25', brand_id = '3244', brand_name = 'Draughtex', value = 409.8100;
INSERT INTO revenue SET day = '2024-03-25', brand_id = '3247', brand_name = 'Budget Fire', value = 398.5800;
INSERT INTO revenue SET day = '2024-03-25', brand_id = '3262', brand_name = 'Gapseal', value = 34.9800;
INSERT INTO revenue SET day = '2024-03-25', brand_id = '3265', brand_name = 'ManoMano', value = 37.2400;
INSERT INTO revenue SET day = '2024-03-25', brand_id = '3270', brand_name = 'Safelincs', value = 35612.0200;
INSERT INTO revenue SET day = '2024-03-25', brand_id = '3271', brand_name = 'The Defib Pad', value = 4429.7700;
INSERT INTO revenue SET day = '2024-03-25', brand_id = '3276', brand_name = 'Safelincs BDM', value = 1816.5000;
INSERT INTO revenue SET day = '2024-03-25', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 1251.2700;
INSERT INTO revenue SET day = '2024-03-25', brand_id = '3286', brand_name = 'B and Q', value = 4727.8700;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3242', brand_name = 'Amazon', value = 20898.2800;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1506.0000;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3244', brand_name = 'Draughtex', value = 415.8900;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3247', brand_name = 'Budget Fire', value = 1645.4800;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3249', brand_name = 'Church Marketplace', value = 157.4800;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3262', brand_name = 'Gapseal', value = 34.9800;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3270', brand_name = 'Safelincs', value = 28949.1000;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3271', brand_name = 'The Defib Pad', value = 4542.2200;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3276', brand_name = 'Safelincs BDM', value = 3436.4500;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 2316.0700;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 2334.6100;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3282', brand_name = 'The Defib Pad Proforma', value = 96.9900;
INSERT INTO revenue SET day = '2024-03-26', brand_id = '3286', brand_name = 'B and Q', value = 1502.3900;
INSERT INTO revenue SET day = '2024-03-27', brand_id = '3242', brand_name = 'Amazon', value = 22348.7600;
INSERT INTO revenue SET day = '2024-03-27', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1898.4000;
INSERT INTO revenue SET day = '2024-03-27', brand_id = '3244', brand_name = 'Draughtex', value = 182.4300;
INSERT INTO revenue SET day = '2024-03-27', brand_id = '3247', brand_name = 'Budget Fire', value = 830.9200;
INSERT INTO revenue SET day = '2024-03-27', brand_id = '3250', brand_name = 'eBay Draughtex', value = 6.9900;
INSERT INTO revenue SET day = '2024-03-27', brand_id = '3270', brand_name = 'Safelincs', value = 42407.2400;
INSERT INTO revenue SET day = '2024-03-27', brand_id = '3271', brand_name = 'The Defib Pad', value = 3351.9500;
INSERT INTO revenue SET day = '2024-03-27', brand_id = '3276', brand_name = 'Safelincs BDM', value = 252.4800;
INSERT INTO revenue SET day = '2024-03-27', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 13346.8200;
INSERT INTO revenue SET day = '2024-03-27', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 10738.6800;
INSERT INTO revenue SET day = '2024-03-27', brand_id = '3286', brand_name = 'B and Q', value = 1489.6300;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '0', brand_name = '', value = 97.9800;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '3242', brand_name = 'Amazon', value = 18196.5100;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1266.2900;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '3244', brand_name = 'Draughtex', value = 89.2000;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '3265', brand_name = 'ManoMano', value = 608.3300;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '3270', brand_name = 'Safelincs', value = 40864.0700;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '3271', brand_name = 'The Defib Pad', value = 1984.9300;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '3276', brand_name = 'Safelincs BDM', value = 801.6000;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 8501.6600;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 1176.0000;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '3282', brand_name = 'The Defib Pad Proforma', value = 270.1700;
INSERT INTO revenue SET day = '2024-03-28', brand_id = '3286', brand_name = 'B and Q', value = 1239.0400;
INSERT INTO revenue SET day = '2024-03-29', brand_id = '3242', brand_name = 'Amazon', value = 12884.6900;
INSERT INTO revenue SET day = '2024-03-29', brand_id = '3270', brand_name = 'Safelincs', value = 2770.0000;
INSERT INTO revenue SET day = '2024-03-30', brand_id = '3242', brand_name = 'Amazon', value = 11533.0400;
INSERT INTO revenue SET day = '2024-03-31', brand_id = '3242', brand_name = 'Amazon', value = 9751.7800;
INSERT INTO revenue SET day = '2024-04-01', brand_id = '3242', brand_name = 'Amazon', value = 12297.3100;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3242', brand_name = 'Amazon', value = 22907.8400;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3243', brand_name = 'eBay Safelincs', value = 4494.8300;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3244', brand_name = 'Draughtex', value = 737.9200;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3247', brand_name = 'Budget Fire', value = 234.1500;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3265', brand_name = 'ManoMano', value = 213.2800;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3270', brand_name = 'Safelincs', value = 45076.9500;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3271', brand_name = 'The Defib Pad', value = 6906.8100;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3276', brand_name = 'Safelincs BDM', value = 533.4900;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = .0000;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 300.0000;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3282', brand_name = 'The Defib Pad Proforma', value = 64.4900;
INSERT INTO revenue SET day = '2024-04-02', brand_id = '3286', brand_name = 'B and Q', value = 3681.4400;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3242', brand_name = 'Amazon', value = 22005.1100;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1148.0600;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3244', brand_name = 'Draughtex', value = 580.4400;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3247', brand_name = 'Budget Fire', value = 955.4000;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3265', brand_name = 'ManoMano', value = 74.1600;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3270', brand_name = 'Safelincs', value = 49000.4600;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3271', brand_name = 'The Defib Pad', value = 3409.1700;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3276', brand_name = 'Safelincs BDM', value = 1837.6400;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 22787.9000;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 6795.6100;
INSERT INTO revenue SET day = '2024-04-03', brand_id = '3286', brand_name = 'B and Q', value = 1094.5500;
INSERT INTO revenue SET day = '2024-04-04', brand_id = '3242', brand_name = 'Amazon', value = 21878.2600;
INSERT INTO revenue SET day = '2024-04-04', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1238.6000;
INSERT INTO revenue SET day = '2024-04-04', brand_id = '3244', brand_name = 'Draughtex', value = 246.9900;
INSERT INTO revenue SET day = '2024-04-04', brand_id = '3247', brand_name = 'Budget Fire', value = 213.0000;
INSERT INTO revenue SET day = '2024-04-04', brand_id = '3262', brand_name = 'Gapseal', value = -23.3200;
INSERT INTO revenue SET day = '2024-04-04', brand_id = '3270', brand_name = 'Safelincs', value = 88724.7500;
INSERT INTO revenue SET day = '2024-04-04', brand_id = '3271', brand_name = 'The Defib Pad', value = 10826.7200;
INSERT INTO revenue SET day = '2024-04-04', brand_id = '3277', brand_name = 'Dropship', value = 466.7300;
INSERT INTO revenue SET day = '2024-04-04', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 17578.5500;
INSERT INTO revenue SET day = '2024-04-04', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 897.4000;
INSERT INTO revenue SET day = '2024-04-04', brand_id = '3286', brand_name = 'B and Q', value = 1071.7400;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3242', brand_name = 'Amazon', value = 22830.6200;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3243', brand_name = 'eBay Safelincs', value = 910.4500;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3244', brand_name = 'Draughtex', value = 153.5700;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3247', brand_name = 'Budget Fire', value = 63.9900;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3265', brand_name = 'ManoMano', value = 17.4500;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3270', brand_name = 'Safelincs', value = 53142.2300;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3271', brand_name = 'The Defib Pad', value = 4870.8500;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3276', brand_name = 'Safelincs BDM', value = 5439.2600;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3277', brand_name = 'Dropship', value = 203.3900;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 5483.9100;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 14766.6300;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3285', brand_name = 'Spectrum', value = 157.1200;
INSERT INTO revenue SET day = '2024-04-05', brand_id = '3286', brand_name = 'B and Q', value = 954.7900;
INSERT INTO revenue SET day = '2024-04-06', brand_id = '3242', brand_name = 'Amazon', value = 15075.8500;
INSERT INTO revenue SET day = '2024-04-07', brand_id = '3242', brand_name = 'Amazon', value = 15323.9000;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3242', brand_name = 'Amazon', value = 24361.2000;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3243', brand_name = 'eBay Safelincs', value = 2558.4200;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3244', brand_name = 'Draughtex', value = 582.5000;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3247', brand_name = 'Budget Fire', value = 1044.0800;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3250', brand_name = 'eBay Draughtex', value = 72.9400;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3270', brand_name = 'Safelincs', value = 28641.1200;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3271', brand_name = 'The Defib Pad', value = 3586.3900;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3276', brand_name = 'Safelincs BDM', value = 646.3800;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 3136.3700;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 580.0000;
INSERT INTO revenue SET day = '2024-04-08', brand_id = '3286', brand_name = 'B and Q', value = 3264.7800;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '0', brand_name = '', value = 472.4700;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3242', brand_name = 'Amazon', value = 25009.6900;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1430.1800;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3244', brand_name = 'Draughtex', value = 477.3200;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3247', brand_name = 'Budget Fire', value = 587.0000;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3248', brand_name = 'Actfire', value = 51.9300;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3262', brand_name = 'Gapseal', value = 15.4100;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3265', brand_name = 'ManoMano', value = 17.4900;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3270', brand_name = 'Safelincs', value = 64872.1100;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3271', brand_name = 'The Defib Pad', value = 1579.8200;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3276', brand_name = 'Safelincs BDM', value = 566.5000;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3277', brand_name = 'Dropship', value = 557.8500;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 2955.2400;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 1494.3900;
INSERT INTO revenue SET day = '2024-04-09', brand_id = '3286', brand_name = 'B and Q', value = 1663.9100;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3242', brand_name = 'Amazon', value = 25473.9600;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1152.1200;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3244', brand_name = 'Draughtex', value = 424.6600;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3247', brand_name = 'Budget Fire', value = 176.4900;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3265', brand_name = 'ManoMano', value = 42.4900;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3268', brand_name = 'Parish Buying', value = 672.5100;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3270', brand_name = 'Safelincs', value = 33720.6400;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3271', brand_name = 'The Defib Pad', value = 3881.7100;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3276', brand_name = 'Safelincs BDM', value = 922.2500;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3277', brand_name = 'Dropship', value = 120.4300;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 6334.8400;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 592.5200;
INSERT INTO revenue SET day = '2024-04-10', brand_id = '3286', brand_name = 'B and Q', value = 881.5200;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3242', brand_name = 'Amazon', value = 25374.0300;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3243', brand_name = 'eBay Safelincs', value = 885.8100;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3244', brand_name = 'Draughtex', value = 269.4700;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3247', brand_name = 'Budget Fire', value = 371.3300;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3264', brand_name = 'Henry Wolfe', value = 17.4500;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3265', brand_name = 'ManoMano', value = -102.6600;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3270', brand_name = 'Safelincs', value = 69609.9500;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3271', brand_name = 'The Defib Pad', value = 7267.4600;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3276', brand_name = 'Safelincs BDM', value = 508.2300;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 20346.1600;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 1612.6100;
INSERT INTO revenue SET day = '2024-04-11', brand_id = '3286', brand_name = 'B and Q', value = 1914.9800;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3242', brand_name = 'Amazon', value = 18857.1800;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1366.8500;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3244', brand_name = 'Draughtex', value = 305.7000;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3265', brand_name = 'ManoMano', value = 164.1600;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3270', brand_name = 'Safelincs', value = 56551.8800;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3271', brand_name = 'The Defib Pad', value = 5119.4600;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3276', brand_name = 'Safelincs BDM', value = 1746.5200;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 1048.6100;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 294.0000;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3282', brand_name = 'The Defib Pad Proforma', value = 295.0000;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3285', brand_name = 'Spectrum', value = 465.9600;
INSERT INTO revenue SET day = '2024-04-12', brand_id = '3286', brand_name = 'B and Q', value = 1108.8800;
INSERT INTO revenue SET day = '2024-04-13', brand_id = '3242', brand_name = 'Amazon', value = 11154.1200;
INSERT INTO revenue SET day = '2024-04-14', brand_id = '3242', brand_name = 'Amazon', value = 14170.2600;
INSERT INTO revenue SET day = '2024-04-15', brand_id = '3242', brand_name = 'Amazon', value = 19006.5700;
INSERT INTO revenue SET day = '2024-04-15', brand_id = '3243', brand_name = 'eBay Safelincs', value = 2959.6000;
INSERT INTO revenue SET day = '2024-04-15', brand_id = '3244', brand_name = 'Draughtex', value = 364.4000;
INSERT INTO revenue SET day = '2024-04-15', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-04-15', brand_id = '3265', brand_name = 'ManoMano', value = 29.9900;
INSERT INTO revenue SET day = '2024-04-15', brand_id = '3270', brand_name = 'Safelincs', value = 56908.5400;
INSERT INTO revenue SET day = '2024-04-15', brand_id = '3271', brand_name = 'The Defib Pad', value = 6119.5000;
INSERT INTO revenue SET day = '2024-04-15', brand_id = '3276', brand_name = 'Safelincs BDM', value = 3086.3100;
INSERT INTO revenue SET day = '2024-04-15', brand_id = '3277', brand_name = 'Dropship', value = 147.7300;
INSERT INTO revenue SET day = '2024-04-15', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 1348.1000;
INSERT INTO revenue SET day = '2024-04-15', brand_id = '3286', brand_name = 'B and Q', value = 3126.2700;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '0', brand_name = '', value = 157.9900;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3242', brand_name = 'Amazon', value = 12454.0200;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1454.7800;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3244', brand_name = 'Draughtex', value = 83.9600;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3247', brand_name = 'Budget Fire', value = 665.6800;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3265', brand_name = 'ManoMano', value = 17.4900;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3270', brand_name = 'Safelincs', value = 79334.2600;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3271', brand_name = 'The Defib Pad', value = 5884.8300;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3276', brand_name = 'Safelincs BDM', value = 526.5700;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 37007.2900;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 8388.4400;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3282', brand_name = 'The Defib Pad Proforma', value = 223.0000;
INSERT INTO revenue SET day = '2024-04-16', brand_id = '3286', brand_name = 'B and Q', value = 1094.2800;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '0', brand_name = '', value = 43.9900;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '3242', brand_name = 'Amazon', value = 32184.8900;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1581.4900;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '3244', brand_name = 'Draughtex', value = 207.0200;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '3247', brand_name = 'Budget Fire', value = 100.4800;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '3265', brand_name = 'ManoMano', value = 162.5000;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '3270', brand_name = 'Safelincs', value = 54909.4100;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '3271', brand_name = 'The Defib Pad', value = 4186.3900;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '3276', brand_name = 'Safelincs BDM', value = 3063.6700;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 30248.4000;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 5243.2100;
INSERT INTO revenue SET day = '2024-04-17', brand_id = '3286', brand_name = 'B and Q', value = 2590.7300;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3242', brand_name = 'Amazon', value = 19737.0100;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1521.5200;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3244', brand_name = 'Draughtex', value = 122.6900;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3247', brand_name = 'Budget Fire', value = -102.5100;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3262', brand_name = 'Gapseal', value = 23.3200;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3265', brand_name = 'ManoMano', value = 53.3000;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3270', brand_name = 'Safelincs', value = 33786.7400;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3271', brand_name = 'The Defib Pad', value = 5446.6600;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3276', brand_name = 'Safelincs BDM', value = 7524.1100;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 28759.4300;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 3712.4500;
INSERT INTO revenue SET day = '2024-04-18', brand_id = '3286', brand_name = 'B and Q', value = 1465.0400;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3242', brand_name = 'Amazon', value = 17052.8200;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1183.8100;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3244', brand_name = 'Draughtex', value = 382.5900;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3247', brand_name = 'Budget Fire', value = 935.4700;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3250', brand_name = 'eBay Draughtex', value = 23.2400;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3265', brand_name = 'ManoMano', value = 279.1600;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3270', brand_name = 'Safelincs', value = 20316.5900;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3271', brand_name = 'The Defib Pad', value = 3292.7900;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3276', brand_name = 'Safelincs BDM', value = 1391.5100;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 633.1300;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 1794.0000;
INSERT INTO revenue SET day = '2024-04-19', brand_id = '3286', brand_name = 'B and Q', value = 820.0600;
INSERT INTO revenue SET day = '2024-04-20', brand_id = '3242', brand_name = 'Amazon', value = 10002.4600;
INSERT INTO revenue SET day = '2024-04-20', brand_id = '3243', brand_name = 'eBay Safelincs', value = -12.8200;
INSERT INTO revenue SET day = '2024-04-21', brand_id = '3242', brand_name = 'Amazon', value = 12402.8900;
INSERT INTO revenue SET day = '2024-04-21', brand_id = '3270', brand_name = 'Safelincs', value = -27.0500;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3242', brand_name = 'Amazon', value = 19877.9300;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3243', brand_name = 'eBay Safelincs', value = 2471.1100;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3244', brand_name = 'Draughtex', value = 841.2500;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3247', brand_name = 'Budget Fire', value = 779.6800;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3250', brand_name = 'eBay Draughtex', value = 126.1700;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3265', brand_name = 'ManoMano', value = 46.6600;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3270', brand_name = 'Safelincs', value = 36860.8600;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3271', brand_name = 'The Defib Pad', value = 6382.6300;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3276', brand_name = 'Safelincs BDM', value = 2716.4800;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3277', brand_name = 'Dropship', value = 1020.0000;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 7724.0100;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 549.9600;
INSERT INTO revenue SET day = '2024-04-22', brand_id = '3286', brand_name = 'B and Q', value = 3021.8200;
INSERT INTO revenue SET day = '2024-04-23', brand_id = '3242', brand_name = 'Amazon', value = 21011.1400;
INSERT INTO revenue SET day = '2024-04-23', brand_id = '3243', brand_name = 'eBay Safelincs', value = 3149.3600;
INSERT INTO revenue SET day = '2024-04-23', brand_id = '3244', brand_name = 'Draughtex', value = 153.2400;
INSERT INTO revenue SET day = '2024-04-23', brand_id = '3247', brand_name = 'Budget Fire', value = 679.3800;
INSERT INTO revenue SET day = '2024-04-23', brand_id = '3250', brand_name = 'eBay Draughtex', value = 26.1600;
INSERT INTO revenue SET day = '2024-04-23', brand_id = '3270', brand_name = 'Safelincs', value = 22361.9100;
INSERT INTO revenue SET day = '2024-04-23', brand_id = '3271', brand_name = 'The Defib Pad', value = 4862.9400;
INSERT INTO revenue SET day = '2024-04-23', brand_id = '3276', brand_name = 'Safelincs BDM', value = 5853.5100;
INSERT INTO revenue SET day = '2024-04-23', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 1395.5400;
INSERT INTO revenue SET day = '2024-04-23', brand_id = '3286', brand_name = 'B and Q', value = 936.3500;
INSERT INTO revenue SET day = '2024-04-24', brand_id = '3242', brand_name = 'Amazon', value = 20850.4300;
INSERT INTO revenue SET day = '2024-04-24', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1476.3400;
INSERT INTO revenue SET day = '2024-04-24', brand_id = '3244', brand_name = 'Draughtex', value = 131.1500;
INSERT INTO revenue SET day = '2024-04-24', brand_id = '3248', brand_name = 'Actfire', value = 23.5500;
INSERT INTO revenue SET day = '2024-04-24', brand_id = '3270', brand_name = 'Safelincs', value = 55736.1400;
INSERT INTO revenue SET day = '2024-04-24', brand_id = '3271', brand_name = 'The Defib Pad', value = 3569.4100;
INSERT INTO revenue SET day = '2024-04-24', brand_id = '3276', brand_name = 'Safelincs BDM', value = 2004.4400;
INSERT INTO revenue SET day = '2024-04-24', brand_id = '3277', brand_name = 'Dropship', value = 1221.5500;
INSERT INTO revenue SET day = '2024-04-24', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 769.9700;
INSERT INTO revenue SET day = '2024-04-24', brand_id = '3286', brand_name = 'B and Q', value = 1524.4100;
INSERT INTO revenue SET day = '2024-04-25', brand_id = '3242', brand_name = 'Amazon', value = 25897.5400;
INSERT INTO revenue SET day = '2024-04-25', brand_id = '3243', brand_name = 'eBay Safelincs', value = 936.1400;
INSERT INTO revenue SET day = '2024-04-25', brand_id = '3244', brand_name = 'Draughtex', value = 237.8100;
INSERT INTO revenue SET day = '2024-04-25', brand_id = '3247', brand_name = 'Budget Fire', value = 651.3000;
INSERT INTO revenue SET day = '2024-04-25', brand_id = '3270', brand_name = 'Safelincs', value = 19898.9100;
INSERT INTO revenue SET day = '2024-04-25', brand_id = '3271', brand_name = 'The Defib Pad', value = 5004.7400;
INSERT INTO revenue SET day = '2024-04-25', brand_id = '3276', brand_name = 'Safelincs BDM', value = 1880.1300;
INSERT INTO revenue SET day = '2024-04-25', brand_id = '3277', brand_name = 'Dropship', value = 198.3500;
INSERT INTO revenue SET day = '2024-04-25', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 16302.9100;
INSERT INTO revenue SET day = '2024-04-25', brand_id = '3285', brand_name = 'Spectrum', value = 31.0300;
INSERT INTO revenue SET day = '2024-04-25', brand_id = '3286', brand_name = 'B and Q', value = 520.8500;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '0', brand_name = '', value = 1810.9800;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3242', brand_name = 'Amazon', value = 21564.2000;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1259.7600;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3244', brand_name = 'Draughtex', value = 148.6800;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3247', brand_name = 'Budget Fire', value = 98.4700;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3250', brand_name = 'eBay Draughtex', value = 26.1600;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3265', brand_name = 'ManoMano', value = 17.0800;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3270', brand_name = 'Safelincs', value = 32113.1300;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3271', brand_name = 'The Defib Pad', value = 2944.1300;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3276', brand_name = 'Safelincs BDM', value = 10208.0400;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 23720.1100;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 1031.9100;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3282', brand_name = 'The Defib Pad Proforma', value = 1099.9900;
INSERT INTO revenue SET day = '2024-04-26', brand_id = '3286', brand_name = 'B and Q', value = 962.3900;
INSERT INTO revenue SET day = '2024-04-27', brand_id = '3242', brand_name = 'Amazon', value = 15861.0300;
INSERT INTO revenue SET day = '2024-04-27', brand_id = '3243', brand_name = 'eBay Safelincs', value = -18.6600;
INSERT INTO revenue SET day = '2024-04-28', brand_id = '3242', brand_name = 'Amazon', value = 14087.8800;
INSERT INTO revenue SET day = '2024-04-29', brand_id = '3242', brand_name = 'Amazon', value = 18453.9900;
INSERT INTO revenue SET day = '2024-04-29', brand_id = '3243', brand_name = 'eBay Safelincs', value = 3149.3200;
INSERT INTO revenue SET day = '2024-04-29', brand_id = '3244', brand_name = 'Draughtex', value = 566.5300;
INSERT INTO revenue SET day = '2024-04-29', brand_id = '3247', brand_name = 'Budget Fire', value = 264.0000;
INSERT INTO revenue SET day = '2024-04-29', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-04-29', brand_id = '3270', brand_name = 'Safelincs', value = 28434.7300;
INSERT INTO revenue SET day = '2024-04-29', brand_id = '3271', brand_name = 'The Defib Pad', value = 3428.9800;
INSERT INTO revenue SET day = '2024-04-29', brand_id = '3276', brand_name = 'Safelincs BDM', value = 1968.6900;
INSERT INTO revenue SET day = '2024-04-29', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 139.9800;
INSERT INTO revenue SET day = '2024-04-29', brand_id = '3286', brand_name = 'B and Q', value = 3774.1200;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3242', brand_name = 'Amazon', value = 21625.0600;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3243', brand_name = 'eBay Safelincs', value = 966.1100;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3244', brand_name = 'Draughtex', value = 118.5200;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3262', brand_name = 'Gapseal', value = 11.6600;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3270', brand_name = 'Safelincs', value = 34984.8000;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3271', brand_name = 'The Defib Pad', value = 4074.4900;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3276', brand_name = 'Safelincs BDM', value = 1706.7700;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3277', brand_name = 'Dropship', value = 2354.9600;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 3771.8300;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 9233.5400;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3282', brand_name = 'The Defib Pad Proforma', value = 740.0000;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3285', brand_name = 'Spectrum', value = 157.1200;
INSERT INTO revenue SET day = '2024-04-30', brand_id = '3286', brand_name = 'B and Q', value = 1522.5100;
INSERT INTO revenue SET day = '2024-05-01', brand_id = '3242', brand_name = 'Amazon', value = 24302.5700;
INSERT INTO revenue SET day = '2024-05-01', brand_id = '3243', brand_name = 'eBay Safelincs', value = 2788.8300;
INSERT INTO revenue SET day = '2024-05-01', brand_id = '3244', brand_name = 'Draughtex', value = 161.3900;
INSERT INTO revenue SET day = '2024-05-01', brand_id = '3247', brand_name = 'Budget Fire', value = 228.0000;
INSERT INTO revenue SET day = '2024-05-01', brand_id = '3270', brand_name = 'Safelincs', value = 18684.3000;
INSERT INTO revenue SET day = '2024-05-01', brand_id = '3271', brand_name = 'The Defib Pad', value = 2649.2900;
INSERT INTO revenue SET day = '2024-05-01', brand_id = '3276', brand_name = 'Safelincs BDM', value = 563.2300;
INSERT INTO revenue SET day = '2024-05-01', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 20588.5400;
INSERT INTO revenue SET day = '2024-05-01', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 1947.9700;
INSERT INTO revenue SET day = '2024-05-01', brand_id = '3286', brand_name = 'B and Q', value = 2161.6000;
INSERT INTO revenue SET day = '2024-05-02', brand_id = '3242', brand_name = 'Amazon', value = 21577.4800;
INSERT INTO revenue SET day = '2024-05-02', brand_id = '3243', brand_name = 'eBay Safelincs', value = 1007.6700;
INSERT INTO revenue SET day = '2024-05-02', brand_id = '3244', brand_name = 'Draughtex', value = 296.9700;
INSERT INTO revenue SET day = '2024-05-02', brand_id = '3247', brand_name = 'Budget Fire', value = 208.9000;
INSERT INTO revenue SET day = '2024-05-02', brand_id = '3270', brand_name = 'Safelincs', value = 21798.5100;
INSERT INTO revenue SET day = '2024-05-02', brand_id = '3271', brand_name = 'The Defib Pad', value = 7845.9300;
INSERT INTO revenue SET day = '2024-05-02', brand_id = '3276', brand_name = 'Safelincs BDM', value = 3137.8500;
INSERT INTO revenue SET day = '2024-05-02', brand_id = '3279', brand_name = 'Safelincs Firedoor', value = 9338.2100;
INSERT INTO revenue SET day = '2024-05-02', brand_id = '3281', brand_name = 'Safelincs Proforma', value = 223.4100;
INSERT INTO revenue SET day = '2024-05-02', brand_id = '3286', brand_name = 'B and Q', value = 570.8100;
INSERT INTO revenue SET day = '2024-05-03', brand_id = '3270', brand_name = 'Safelincs', value = 115.0000;
INSERT INTO revenue SET day = '2025-01-01', brand_id = '3270', brand_name = 'Safelincs', value = 648.1800;


527 records inserted into the revenue table from the intranet figures endpoint.