Summary
Introduce a native relative date filter called "Last Full Week (Mon-Sun)" for Analytics reports and automated report subscriptions. This filter would automatically generate reports covering the most recently completed calendar week, eliminating manual date range maintenance and preventing data inconsistencies caused by configuration timestamps.
Problem Statement
Current reporting options do not provide a reliable method for automatically delivering complete weekly performance reports.
Current Limitations
1. Static Custom Date Ranges
When users configure a report using a custom date range, the selected dates remain fixed indefinitely. Automated subscriptions continue to send data for the same historical period and do not advance as new weeks pass.
2. Timestamp-Dependent Relative Filters
Existing relative date options such as "Last 7 Days to Date" calculate report boundaries based on the exact date and time the subscription was created or modified. As a result:

Reports may end at a specific hour rather than at the end of the day.
Weekly reports can contain partial-day data.
Users may receive less than a full seven days of reporting data.

1. Data Truncation Issues Reports frequently exclude valid data due to boundary calculations tied to the configuration timestamp. This can result in:

Missing hours from the final reporting day.
Incomplete weekly reporting periods.
Inconsistent metrics between reporting cycles.

1. Inefficient Administrative Workarounds To obtain a complete Monday-through-Sunday report, administrators must often create or update subscriptions immediately after midnight. This workaround:

Is operationally impractical.
Creates dependency on manual intervention.
Introduces risk from time zone differences between users and backend processing systems.

roposed Enhancement
New Relative Date Filter
Add a predefined date filter option:
Last Full Week (Mon-Sun)
This option should be available anywhere Analytics report date ranges are configured, including automated report subscriptions.

Functional Requirements
1. Dynamic Weekly Boundary Calculation
The filter should automatically calculate the most recently completed calendar week based on the account's configured time zone.
Start Boundary

Previous Monday
Time: 12:00:00 AM

End Boundary

Previous Sunday
Time: 11:59:59 PM

Example
If a report is generated on Monday, July 6, the reporting period should automatically be:

Start: Monday, June 29, 12:00:00 AM
End: Sunday, July 5, 11:59:59 PM

1. True Rolling Automation The reporting period should automatically advance by one week on each execution without requiring users to:

Edit the subscription
Re-save report settings
Reconfigure date filters

Each scheduled run should dynamically evaluate the most recently completed full week.

1. Decouple Configuration Time from Data Selection Report boundaries must be determined exclusively by calendar-week logic and the account time zone. The following must have no impact on the selected reporting period:

Report creation time
Report modification time
Subscription save time
Scheduled delivery time

For example, a report scheduled for Monday at 8:00 AM should still return data for the complete prior Monday-Sunday period.

Expected Business Benefits
True Report Automation
Eliminates recurring manual date adjustments and enables reliable week-over-week reporting.
Improved User Experience
Removes the requirement for administrators to perform configurations at specific times, such as shortly after midnight.
Accurate Performance Metrics
Ensures reports consistently contain complete weekly datasets without truncated or partial-day data.
Reduced Support Volume
Addresses a common source of reporting confusion, minimizing support cases related to incomplete reporting periods, time-based filtering behavior, and time zone discrepancies.

Success Criteria

A user can select "Last Full Week (Mon-Sun)" when creating an Analytics report subscription.
Reports always return data from the most recently completed Monday-Sunday period.
Date boundaries are based on the account's configured time zone.
Reporting periods automatically advance each week without user intervention.
Scheduling or editing a report does not alter the underlying reporting window.
Weekly reports contain complete, non-truncated datasets.

Priority: High
Category: Analytics / Reporting Automation
Business Impact: High – Improves reporting accuracy, user experience, and subscription reliability while reducing ongoing administrative overhead and support escalations.