• Home
/
• Working in m3ter - User Guides
/
• Data Exports (Preview)
/
• Running Ad-Hoc Usage Data Exports

Running Ad-Hoc Legacy Usage Data Exports

You can quickly set up and run a one-off, ad-hoc data export containing usage data collected for your Organization. Usage data exports contain the usage data measurements ingested into m3ter for the selected Meters and Accounts covering the specified time period, and you can select to aggregate the data for an export.

To set up and run an ad-hoc Legacy Usage Data Export:

1. Select Data exports:

The Data export page opens.

2. On the Export schedules panel, select Run ad-hoc export:

The Run ad-hoc export page opens.

3. Enter the Ad-hoc export details:

• Destinations. Use the drop-down to select the Export destinations to be used for the ad-hoc data export. Notes:

  • Select a destination.

  • If No options shows in the drop-down, you must first create at least one destination before you can set up an ad-hoc data export - see Creating and Managing Export Destinations.

  • Alternatively, if you simply want to download the data export file locally, do not select a Destination. See Downloading Data Export Files Locally for more details.

• Export file format. Select the format you require for the usage data export files:

  • CSV. (Default).

  • JSON.

• Source type. For a usage data ad-hoc export, select Usage data (legacy format). The Ad-hoc export details panel adjusts.

• Time period. Define a time period you want the ad-hoc data export to cover. This setting controls the range of usage data the export will contain:

  • Custom. Enter start and end date/times to define the time period.

  • Today. Data collected for the current day up until the time the export is run. (Default setting)

  • Yesterday. Data collected for the day before the export runs - that is, the 24 hour period from midnight to midnight of the day before.

  • Week, Month, Year to date. Data collected for the period covering the current week, month, or year period. For example, for Week to date setting weeks run Monday to Monday - if the export is run at 10 a.m. UTC on October 16th 2024, which is a Wednesday, it will contain all usage data collected starting Monday October 14th 2024 through to the Wednesday at 10 a.m. UTC of the current week.

  • Previous week, month, quarter, year. Data collected for the previous full week, month, quarter, or year period. For example, weeks run Monday to Monday - if the export is run on June 12th 2024, which is a Wednesday, the export will contain data for the period running from Monday, June 3rd to midnight on Sunday, June 9th 2024.

  • Last 12 hours. Data collected for the twelve hour period up to the start of the hour in which the export is run.

  • Last 7 days, 30 days, 35 days, 90 days, 120 days, year. Data collected for the selected period prior to the date the export is run. For example, if Last 30 days and the export is run for any time on June 15th 2024, it will contain usage data collected for the previous 30 days - starting May 16th 2024 through to midnight on June 14th 2024.

• Aggregation frequency and Aggregation. If you want to aggregate ingested values for your usage data export, then use these options in combination:

  • Aggregation frequency. Select the frequency for aggregation - five options:

    • Original. No aggregation performed. (Default)

    • Hourly.

    • Daily.

    • Weekly.

    • Monthly.

  • Aggregation. Select the type of Aggregation you want to apply to the data values for the selected frequency - six options:

    • Sum. Adds the values.

    • Minimum. Uses the minimum value.

    • Maximum. Uses the maximum value.

    • Count. Counts the number of values.

    • Latest. Uses the most recent value, based on the timestamp - ts - values of ingested usage data measurements.

    • Mean. Uses the arithmetic mean of the values.

• Meters. Add Meters for the data export:

  • Select the plus icon. A popup will show listing all Meters in your Organization and you can search the list.

  • Check the Meters whose usage data you want to include in the export and select Add.

  • The export will contain the usage data collected by the Meters you add for the specified Time period. (Default is All meters)

  • Note that you can search the Meters list by name or enter an ID.

• Accounts. Add Accounts for the data export:

  • Select the plus icon. A popup will show listing all Accounts in your Organization and you can search the list.

  • Check the Accounts whose usage data you want to include in the export and select Add.

  • The export will contain the usage data collected by the Meters you've added and for the Accounts you add for the specified Time period. (Default is All Accounts)

  • Note that you can search the Accounts list be name or enter an ID.

4. When you have entered all details for the ad-hoc data export, select Run ad-hoc export:

• In this example, we've selected a single Meter and two Accounts for which non-aggregated usage data will be included in the ad-hoc usage data export.

An Export job is scheduled for the ad-hoc usage data export you can check if the job succeeded on the Export jobs page - see Reviewing Export Jobs.

Next: Running Ad-Hoc Operational Data Exports

Additional Support