The Inventory Blind Spot in Advertising

Your warehouse management system knows exactly how long every product has been sitting on the shelf. Your ERP tracks receipt dates. Your inventory team watches aging reports weekly.

But none of this information reaches your advertising. Google Shopping doesn't know that SKU-3001 arrived yesterday and SKU-3002 has been gathering dust for 4 months. So both get the same ad treatment — same bids, same budget, same priority.

This is a missed opportunity on both ends:

New arrivals deserve premium visibility to build early momentum
Aged inventory needs promotional push before it requires deep markdowns

Step 1: Export Stock Age to a Sheet

Most ERP and WMS systems can export an inventory aging report. Convert it into a Google Sheet with a simple structure:

SKU	receipt_date	days_in_stock	stock_tier
SKU-3001	2026-02-20	7	New In
SKU-3002	2025-12-01	88	Clearance
SKU-3003	2026-01-15	43	Core
SKU-3004	2026-02-25	2	New In

Tier logic:

New In — received in the last 14 days
Core — 14 to 60 days in stock
Clearance — over 60 days in stock

You can calculate stock_tier directly in Google Sheets with a simple formula, or pre-calculate it in your export.

Step 2: Merge into Your Feed

Connect the sheet via FeedOn's Supplemental Data Mapping. Map the SKU and merge the stock_tier column. Then use a feed rule to assign it to a custom label (e.g., custom_label_2).

Step 3: Build Lifecycle Campaigns

New In Campaign

Filter: custom_label_2 = "New In"
Strategy: Higher bids, broader targeting, maximize impressions in the first two weeks
Goal: Build click history and conversion data early so Google's algorithms learn faster
Meta: Feature in Collection Ads with "Just Arrived" creative

Core Campaign

Filter: custom_label_2 = "Core"
Strategy: Standard bidding, let Smart Bidding optimize based on accumulated data
Goal: Maintain steady sales velocity

Clearance Campaign

Filter: custom_label_2 = "Clearance"
Strategy: Pair with a price reduction or free shipping offer. Lower ROAS target to prioritize volume.
Goal: Move aged inventory before it needs a deep discount
Meta: Create urgency-driven ads — "Limited Stock" or "Last Chance"

Why This Matters for Your Bottom Line

Aged inventory is expensive. It ties up capital, takes up warehouse space, and eventually gets marked down to a loss. By pushing aged stock through ads before it hits critical age, you:

Sell at higher prices (20% off now vs. 50% off later)
Free up warehouse space and working capital
Reduce end-of-season write-offs

Meanwhile, new arrivals get the visibility they need to build early sales momentum — which feeds into Google's and Meta's algorithms, improving their long-term performance.

Keep the Sheet Updated

Stock age changes daily. Set up a weekly (or even daily) export from your ERP to the Google Sheet, then schedule a refresh in FeedOn. The tiers update automatically, and products move between campaigns as they age — no manual intervention.

Use Stock Age Data to Clear Aged Inventory and Spotlight New Arrivals