Looker Studio Automated Delivery: Date Ranges & Comparison Setup

Overview

Automated Looker Studio report delivery is a powerful client communication tool, but it requires careful configuration to avoid sending stale or misleading data. Two failure modes are common: fixed date ranges that never update, and reports that reach the client before the account manager has reviewed them. This article documents the correct setup and a pre-delivery review workflow.

Problem: Fixed Date Ranges in Scheduled Delivery

When configuring scheduled email delivery in Looker Studio, the date range filter in the delivery settings defaults to whatever is currently applied to the report — which may be a fixed historical range (e.g., "January 2020 to present"). If left unchanged, every automated email will show the same stale window of data indefinitely.

Discovered via: A client (Exterior) received automated weekly reports filtered from January 2020, rendering the data useless for current performance review.

Correct Configuration

1. Set a Dynamic Default Date Range

In the report itself (not just the delivery settings), set the default date range to a rolling window:

• Open the date range control on the report
• Select Last 30 Days (or Last 7 Days, Last 90 Days, etc. as appropriate)
• Apply and save — Looker Studio saves this as the report default automatically

Avoid Fixed date ranges for any report intended for recurring delivery.

2. Configure Comparison Periods

Clients frequently want to see current performance relative to a prior period. Looker Studio supports this natively on Time Series charts and Tables:

• With the date range set to Last 30 Days, the report will automatically surface period-over-period delta values (e.g., "−43.8% impressions") representing change vs. the preceding 30 days
• For charts that support it, a Compare Date Range option is available in the Properties panel under the Setup tab
• Communicate to the client that the delta figures shown represent comparison to the prior equivalent period — this addresses requests like "show me this month vs. last month"

Note: Year-over-year comparison (same month, prior year) is a separate configuration. If a client requests this specifically, verify whether the report's chart type supports it before committing to the format.

3. Manage Delivery Recipients

In the scheduled delivery settings:

• Add yourself as a recipient on a schedule that arrives before the client's delivery (e.g., you receive it Monday, client receives it Thursday or monthly)
• Remove internal team aliases (e.g., a generic team inbox) that no one actively monitors
• Re-add the client only after confirming the report looks correct

Pre-Delivery Review Workflow

Receiving the report before the client is not optional — it is the standard practice.

1. Schedule your delivery 3–7 days before the client's delivery
2. When the report arrives in your inbox, open it and scan for red/negative numbers
3. For any significant declines, research the cause before the client sees it:
   - Check Google Ads for bid changes, new competitors, or campaign pauses
   - Check Google Search Console for ranking drops
   - Consider seasonal or calendar factors (holidays, weather events) that affect comparability
4. If problems exist, proactively contact the client before their report arrives — explain what the data shows, why it happened, and what action is being taken

"It's always embarrassing if the client sees data before you do. Because then they're like, 'what's this?' and you go, 'I don't know.'" — Mark Hope

Proactive communication converts a potentially alarming data point into a demonstration of attentiveness. Reactive communication — responding after the client flags it — puts the account manager on defense.

Interpreting Performance Deltas

When reviewing report data, context matters before drawing conclusions:

• Clicks down, conversions down — investigate bid strategy, competitor activity, or budget changes; do not assume the campaign is failing without checking
• Impressions down — less critical than clicks; impressions alone don't drive revenue
• CTR up while clicks are down — possible audience narrowing or budget reduction; the ad itself may be performing better even if volume is lower
• Period-over-period comparisons — verify that both periods are comparable (e.g., one period including a major holiday vs. one that doesn't skews results)

When in doubt, schedule a review with the paid search specialist (e.g., Gilbert) before presenting conclusions to the client.

Related

• ^[1]
• ^[2]
• ^[3]