Rolling 7-Day Impressions and Clicks

Write a SQL query using window functions to compute a rolling 7-day average of impressions and clicks by publisher.

Use the publisher_daily_metrics table, which contains one row per publisher per calendar date. Calculate averages over the current date and up to the six preceding dates.

Output

1. One row per publisher and metric date.
2. Columns: publisher_name, metric_date, rolling_7_day_avg_impressions, and rolling_7_day_avg_clicks.
3. Include only dates with metric records, ordered by publisher_name and metric_date ascending.

The window covers the current metric date and the 6 calendar days before it; dates with no rows are simply absent from the window, and all rows for the same publisher and date share one window.