Execution Progress
Execution progress shows the current stage of report processing and the estimated time to completion. Available for runs with status Running.
Execution stages and how they're indicated
Fetch (Data extraction) — 0-30%
The system sends a request to the data source's API. Progress depends on the volume of requested data (date range, number of metrics), the source API's response speed, and whether pagination is involved (several sequential requests). The progress bar fills as pages of data are received.
Transform (Processing) — 30-60%
The retrieved data is processed: filters are applied, sorting, aggregation by dimensions, calculation of derived metrics, value formatting. Duration depends on the data volume and filter complexity.
Load (Writing) — 60-95%
Data is written to the Google Sheets output sheet. Speed depends on the write mode (Replace is faster, SoftRefresh is slower), the current data volume in the sheet, and the speed of the Google Sheets API.
Finalize (Finalization) — 95-100%
Updating the report's metadata: saving the last run time, updating statistics (row count, duration), writing logs, updating markers for RewriteFromLast.
How to track progress
In the interface
While a report is running, its page shows: a progress bar with percentages, the name of the current stage, the estimated time to completion (ETA), and the number of rows processed out of the total.
In real time
Progress updates automatically every 5-10 seconds. There's no need to refresh the page.
For long-running reports
If a report runs for longer than 5 minutes, a notification appears: "This report is taking longer than usual. You can close the page — execution will continue in the background."
Estimated time to completion (ETA)
ETA is calculated based on: the average duration of previous runs of this report, the current percentage of completion, and the elapsed time. For the first run (no history), the ETA may be inaccurate.
How to verify
- Run the report and watch the progress bar
- Make sure the stages progress: Fetch > Transform > Load > Finalize
- Check the ETA — it should decrease over time
- If it's stuck on one stage for more than 10 minutes, check the logs
Related articles
- Statuses — execution statuses
- Cancelling a Run — stopping at any stage
- Run History — analyzing duration
- Large Reports — specifics of long-running reports