Weekly Impression Drop Monitor

A weekly impression drop monitor for Amazon Sponsored Ads. Set your marketplace, drop threshold, and notification email — the skill automatically tracks every advertisement week-over-week and flags any that lose significant impression share.

It covers the full monitoring and alerting workflow:

Week-over-week comparison — splits the last 14 days into two 7-day windows and computes impression change % for every active advertisement

Configurable drop threshold — flag ads at any drop level you choose (default: 30% or greater)

Ranked flagged ads list — all flagged advertisements sorted worst-first with impression counts for both periods, plus spend and sales context

5-week trend view — a rolling historical chart showing how many ads flagged each week and the cumulative spend/sales impact of those drops

Automated email alerts — instant notification to any recipient when impression drops are detected, delivered every time the skill runs

📊 Load Recent Week Performance

Load ad data from the last 7 days to establish current impression levels

Produces One row per advertisement summarizing total impressions, cost, and ad sales for the recent 7-day period

📋 Load Prior Week Performance

Filter tagged timeseries to prior week rows and aggregate by advertisement for WoW comparison

Produces One row per advertisement with total impressions, ad_spend, and ad_sales for the prior 7-day window

🚩 Compare and Flag Drops

Merge both periods, calculate impression change percentage, and flag ads with 30%+ drops

Produces analysis_period, impression_change_pct_display

📤 Alert Stakeholders

Send summary email alert to stakeholders when ads with ≥30% impression drop are detected

Produces Email notification sent to [email protected] with a summary of flagged impression drops

📈 Analyze Weekly Trend

Build a 5-week historical view of impression drop patterns to provide context for the weekly comparison

Produces One row per week showing the count of flagged ads and total financial impact of impression drops for that week

• Weekly ad health check to catch underperforming campaigns before they waste budget
• Early warning system for bid or budget changes that accidentally starved impressions
• Client reporting — show week-over-week impression trends with financial impact attached
• Cross-account monitoring — run the same skill on multiple connectors to surface problems across a portfolio

• Investigate root causes — use the flagged ad list to check budget caps, bid changes, or competing campaigns that may be suppressing impressions
• Take action — pair with a bid adjustment or budget action block to automatically respond to flagged ads
• Build a presentation — generate a slide deck from the dashboard to share impression trend data with stakeholders
• Track patterns over time — schedule weekly runs to monitor whether impression drops are isolated events or a recurring structural problem
• Tune the sensitivity — adjust the drop threshold variable to broaden or tighten the flag criteria without changing any other part of the skill