Sorts Awin product lists down to clothing and footwear, checks what is in them, and reports which can be used now.
Reporting Dashboards
Clothing and footwear retail
Single job
Productised
Local/private
2026
The problem
A size-guide site wants relevant product listings, but the Awin list mixes every kind of retailer. Many lists stay locked until the programme is joined. Downloading everything wastes a day and still does not show which lists are usable.
What it does
A person supplies the Awin feed list, the clothing and footwear programme names and an exclude list for lookalikes. It filters the list by name, downloads the feeds it can open, unpacks them and samples each for category and currency. A second pass splits feeds that download today from feeds that need an application, and it saves a report and a spreadsheet.
Outcomes
Open feeds are listed with product counts.
Locked programmes are listed separately and are not counted as empty.
Lookalike names are left out.
The report is a file someone can act on.
Simplified mockup
Interactive preview with sample data. Nothing is sent to a server.
Affiliate feed suitability
Network list 10 programmes
Programme
Feed
Products
Access
Hearth & Hem
F1842
4,218
Open
Mill Lane Footwear
F0902
1,640
Open
North Quay Knitwear
F0441
986
Open
Pebble Sole
F2210
2,104
Locked
Vale Tailoring
F1188
612
Locked
Coast Thread Market
F3304
8,440
Locked
Pike Tackle Co
F0771
3,902
Lookalike
Helm Spoke
F0614
740
Lookalike
Atelier Watches
F0888
1,120
Lookalike
Four Sku Cloth
F0104
4
Lookalike
Run
Ready to analyse this page of the list
Ready now
0
Pending approval
0
Products ready
0
Lookalikes dropped
0
Ready to download
Programme
Feed
Products
Currency
Category sample
Hearth & Hem
F1842
4,218
£
Day dresses 62%
Mill Lane Footwear
F0902
1,640
£
Sizes in title
North Quay Knitwear
F0441
986
£
Jumpers 71%
Locked, pending approval
Programme
Feed
Products
Blocker
Pebble Sole
F2210
2,104
Application open
Vale Tailoring
F1188
612
Application open
Coast Thread Market
F3304
8,440
Application open
Locked rows stay on the report. An empty download is not the same as a programme you have not joined. Markdown and CSV use these two tables.
Open-feed sample
Hearth & Hem · F1842
Lines read
0
Currency
£
40 of 40 lines
Size in the title
0
Category mix in the sample
Day dresses62%
Knitwear24%
Outerwear14%
Title lines from the sample
Title
Price
Read as
Linen shift dress, 12 / Ecru
£86
Day dress, size 12
Wool crew neck, M / Navy
£64
Knitwear, size M
Cotton mac, 14 / Stone
£140
Outerwear, size 14
Exclude list
Names that look like clothing or footwear and are not. They never reach the ready table.
Programme
Feed
Products
Why it is out
Pike Tackle Co
F0771
3,902
Fishing tackle. The name reads like outdoor footwear.
Helm Spoke
F0614
740
Cycle helmets. No garment sizes.
Atelier Watches
F0888
1,120
Watches only.
Four Sku Cloth
F0104
4
Test feed. Too small to sample.
How it works
Load the list of available product lists.
Keep clothing and footwear programmes and drop the exclusion list.
Download and open the lists that are already available.
Check the product category and currency in each.
Split the report into ready now and locked pending approval.