1. Resolve the URLs once
Start from whatever you have — a spreadsheet of storefront links.shp_… IDs, which survive the
competitor renaming their storefront — a URL does not.
2. Put them in a list
3. Read the set over any window
period for a different window against the same set — which is how you get
week-over-week without storing history yourself:
The field that tells you the most
revenue_by_source is the one to read first on a competitor.
4. Get told when something moves
creators_count means a competitor started
recruiting affiliates hard — and it shows up a week or two before the revenue it produces.
Going one level deeper
When a tracker fires, the follow-up is usually “what are they actually selling?”Keeping the set honest
1
Re-resolve the misses
Route
not_found rows to a person. A competitor’s storefront URL changing is itself news.2
Let a search tracker add members
A search tracker on your category above a revenue
floor surfaces competitors you have not heard of. Add them to the list when they appear.
3
Set a floor on the conditions
Percentage swings on a small competitor are noise. Filter the list to shops above a revenue
threshold, or you will be paged about nothing.