About Services Tools Blog Contact us

Affiliate Feed Suitability

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
ProgrammeFeedProductsAccess
Hearth & HemF18424,218Open
Mill Lane FootwearF09021,640Open
North Quay KnitwearF0441986Open
Pebble SoleF22102,104Locked
Vale TailoringF1188612Locked
Coast Thread MarketF33048,440Locked
Pike Tackle CoF07713,902Lookalike
Helm SpokeF0614740Lookalike
Atelier WatchesF08881,120Lookalike
Four Sku ClothF01044Lookalike
Run
Ready to analyse this page of the list

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
TitlePriceRead as
Linen shift dress, 12 / Ecru£86Day dress, size 12
Wool crew neck, M / Navy£64Knitwear, size M
Cotton mac, 14 / Stone£140Outerwear, size 14

Exclude list

Names that look like clothing or footwear and are not. They never reach the ready table.

ProgrammeFeedProductsWhy it is out
Pike Tackle CoF07713,902Fishing tackle. The name reads like outdoor footwear.
Helm SpokeF0614740Cycle helmets. No garment sizes.
Atelier WatchesF08881,120Watches only.
Four Sku ClothF01044Test feed. Too small to sample.

How it works

  1. Load the list of available product lists.
  2. Keep clothing and footwear programmes and drop the exclusion list.
  3. Download and open the lists that are already available.
  4. Check the product category and currency in each.
  5. Split the report into ready now and locked pending approval.
  6. Save a report and a spreadsheet.

Pipeline

flowchart LR
  List["Feed list"] --> Filter["Clothing filter"]
  Filter --> Sample["Sample open feeds"]
  Sample --> Score["Score"]
  Score --> Ready["Ready now"]
  Score --> Locked["Pending approval"]