How do I set a date and time range for the bulk metrics export?

Use the "yesterday" parameter or the "start_time" and "end_time" parameters to set time and date ranges for your bulk metrics export.

Last updated on 28 Oct, 2025

There are three parameters for setting date ranges in the bulk metrics export.

start_time sets the start time for the query in ISO8601 format (UTC)
end_time sets the end time for the query in ISO8601 format (UTC)
yesterday retrieves only the previous day's data

The format for the start_time and end_time parameters, based on RFC3339, is as follows:
YYYY-MM-DDTHH:MM:SS.FFFZ

A start_time parameter is required for the bulk metrics query to run. If no end_time parameter is specified, the query will return all data logged up to the time the query was run.

The yesterday parameter is a convenience parameter for setting the bulk metrics query to retrieve only the previous day’s data. It automatically sets the end_time parameter to the last occurence of 12:00 AM UTC, and sets the start_time parameter to exactly 24 hours earlier.

Example URLs:

Sample Data:

The first row of data returned is a header label, followed by data records.

How do I retrieve bulk metrics data for my organization?

Access and customize your organization’s metrics information.

Where do I find the base URL for my organization’s bulk metrics?

Metrics Export access for your organization is provided under "Settings" on the iDetail Web Service.

How do I set the bulk metrics to retrieve all the historical data for my organization?

Retrieve all of the historical data for your organization by using a special case of the "start_time" parameter.

How do I set the bulk metrics export to retrieve data for different apps in my organization?

Use the bulk metrics export "apps" parameter to build queries for the different apps in your organization.

How do I set the bulk metrics export for my time zone?

You can retrieve bulk metrics data corrected for your organization’s time zone.

How do I retrieve selected fields of the metrics data?

Use the "columns" parameter to specify which data are included in the bulk metrics export and what order they will appear in.

What data does the bulk metrics export retrieve (data columns)?

See the list of data fields captured by the iDetail app.

How do I set up the bulk metrics export to retrieve only the previous day’s data?

The bulk metrics export has a parameter for retrieving the last 24 hours of use data.

Did you find this article helpful?

How do I set the bulk metrics to retrieve all the historical data for my organization?