Overview

Etlworks collects and aggregates usage statistics which can be viewed in the Account dashboard.

Only Admin and SuperAdmin users can see the Account dashboard.

Account dashboard

To view daily and monthly statistics, as well as the total number of Flows, Connections, Formats, Schedules, and Listeners in the account, open the Statistics window. 

View stats for the previous months 

To view the stats for the previous month, select the month from the dropdown:

Overage

We display the following overage information to help customers stay within limits set for the specific subscription plan:

• Exceeding the daily maximum
• Potential monthly overage
• Exceeding the monthly maximum

Account usage notifications

We also send the following overage notifications:

• Etlworks daily overage notice (day of the month): sent to the account owner when the number of records processed during the previous day exceeded the maximum number allowed for the subscription plan.
• Etlworks monthly overage notice (month): sent to the account owner when the number of records processed during the previous month exceeded the maximum number allowed for the subscription plan.

Flows executions dashboard

To view stats for the Flow executed today or on any given day in the past, select the day from the Executions drop-down. Today's dashboard is updated in real-time so that you can monitor currently running Flows.

Filter by Flow Status, Name and more

To filter executions by Status and/or Name toggle the Filter icon next to Executions dropdown, select one or multiple statuses, optionally enter name of the flow (partial matching works). Then click Apply button.

Available filter parameters

The flow execution filter allows users to narrow down the results of executed flows based on specific criteria. Below is an explanation of each parameter visible in the provided interface:

Name

• Description: Filter executions by the flow name.

• Input: Enter part or all of the flow name to match executions.

Status

• Description: Filter executions based on their status (e.g., success, failure, running).

• Input: Select a status from the dropdown menu.

Records

• Description: Filter executions based on the number of records processed.

• Input: Specify a minimum value (> operator) for the number of records processed in the execution.

Duration

• Description: Filter executions by their runtime duration in seconds.

• Input: Specify a minimum duration (> operator) to include executions that exceed the provided time.

Started

• Description: Filter executions based on the time they started.

• Input: Enter a time (e.g., HH:mm:ss AM/PM) to include executions that started on or after the specified time (>= operator).

Ended

• Description: Filter executions based on the time they ended.

• Input: Enter a time (e.g., HH:mm:ss AM/PM) to include executions that ended on or before the specified time (<= operator).

Usage Notes

• Use the filter parameters individually or in combination to refine the list of flow executions.

• Fields like Duration, Records, Started, and Ended support relational operators (e.g., >, >=, <=) for precise filtering.

• If no filters are applied, all executions will be displayed by default.

Download flows executions report in CSV format

The Download CSV button, allows users to export a report of flow executions in CSV format. This feature is particularly useful for further analysis or sharing execution data with team members. Below are details on how to use this functionality:

Apply Filters (Optional):

• Use the available filters (e.g., Name, Status, Duration, Records) to narrow down the flow executions displayed on the screen. Only the filtered executions will be included in the report.

Click the Download Button:

• Locate the Download icon (indicated by a downward arrow) in the toolbar above the execution list.

• Click the button to generate and download the report.

Save the File:

• The report will be downloaded in CSV format, which can be opened with tools like Microsoft Excel, Google Sheets, or any text editor.

Example Report Details for Flow Executions

When downloading a flow executions report, the system generates a CSV file with a descriptive name and structured content. Below is an explanation of the file naming convention and the report structure:

Example File Name:

executions_2025-01-26T17_01_59-0500.csv

• executions: Indicates that the file contains flow execution data.

• 2025-01-26: The date when the report was generated (in YYYY-MM-DD format).

• T17_01_59-0500: The timestamp when the report was generated, including the time zone offset (in HH_MM_SS±hhmm format).

Content of the CSV File:

Column	Description
auditId	Unique identifier for the execution event.
flowId	Unique identifier for the flow that was executed.
flowName	The name of the flow that was executed.
status	The execution status (e.g., Success, Failure, Running).
agentId	Unique identifier for the agent (if applicable) that executed the flow.
agentName	The name of the agent (if applicable).
eventId	Unique identifier for the triggering event (if applicable).
eventName	The name of the event that triggered the flow execution.
description	Additional details or description of the execution.
started	The timestamp when the execution started
ended	The timestamp when the execution ended
duration	The total duration of the execution in milliseconds
records	The number of records processed during the execution
user	The username of the user who triggered the flow execution (if applicable).

Check Flow Status, Metrics, and Logs

To check the status of any Flow in a dashboard, as well as see the errors, logs, etc., click the Status link:

This will open a popup with detailed information about the Flow, such as start and end time, status, error, logs, and more:

Account dashboard for multiple tenants

Super Admin user under main account can select multiple or all tenants. In this mode, the Account dashboard switches to the multi-tenant view, displaying information across multiple selected tenants.

In this view, each metric includes a dropdown:

which when toggled, displays information for multiple tenants:

Flows executions dashboard in multi-tenant mode

In this mode, The Flows Executions dashboard also switches to a multi-tenant view: