7-Day Rolling Average Exports | Dataford Interview Questions

Adobe Acrobat product analytics wants to smooth daily export volume so the team can spot trends without day-to-day noise. Write a SQL query to calculate the 7-day rolling average of document exports per user.

Requirements

Aggregate exports to one row per user per export date.
Compute a 7-day rolling average of daily exports for each user using a window function.
Include only dates where the rolling average can be calculated from the available history in the table.
Return the result ordered by user and date.

Schema

acrobat_document_exports

Column	Type	Description
export_idPK	INT	Primary key for each export event
user_id	INT	Adobe Acrobat user identifier
export_date	DATE	Date the document was exported
document_id	INT	Identifier of the exported document
export_format	VARCHAR(20)	Export format such as PDF or DOCX

Your question is 7-Day Rolling Average Exports. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Requirements

Aggregate exports to one row per user per export date.
Compute a 7-day rolling average of daily exports for each user using a window function.
Include only dates where the rolling average can be calculated from the available history in the table.
Return the result ordered by user and date.

Schema

acrobat_document_exports

Column	Type	Description
export_idPK	INT	Primary key for each export event
user_id	INT	Adobe Acrobat user identifier
export_date	DATE	Date the document was exported
document_id	INT	Identifier of the exported document
export_format	VARCHAR(20)	Export format such as PDF or DOCX

Your question is 7-Day Rolling Average Exports. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.