View reporting activity

The Reporting Activity Manager enables administrators to quickly diagnose and fix reporting capacity issues during peak reporting times.

For more information about Reporting Activity manager, including key benefits and permission requirements, see Reporting Activity Manager overview.

For all connections

1. In Customer Journey Analytics, go to Tools > Reporting Activity Manager.

   A list of your enabled base connections is displayed.

   

2. To view the total number of report requests for all connections in your organization, expand Show more to view the Monthly report requests graph.

   You can view the number of report requests within your organization for the current month and the previous month.

   

3. (Optional) You can search or filter the list of connections:

   • Use the search field to search for a specific connection. Begin typing the connection name or ID and the list of connections updates as you type.

   • Select to expand the list of filter options. You can filter by Favorites or Status.

     To mark a connection as a favorite, select the star icon to the left of the connection name.

4. View utilization information about each connection. The data shown in the table represents the reporting activity for the connection at the time the page was last loaded.

   The following columns are available:

   UI Element	Description
   Connection	The connection whose reporting activity you are monitoring.
   Data Views	Shows all data views that use the connection. Data view configuration can add complexity to reporting requests.
   Capacity utilization	The percentage of the connection’s reporting capacity that is being used, in real time. Note A usage capacity that is at 100% doesn’t necessarily suggest that you should immediately start cancelling reporting requests. 100% usage capacity can be healthy if the average wait time is reasonable. On the other hand, 100% usage capacity could suggest a problem if the number of queued requests is also growing.
   Queued requests	The number of requests waiting to be processed.
   Queue wait time	The average wait time before requests begin to process.
   Status	The possible statuses are: Active (blue): Reports have been run on the connection in the last 2 hours. The data shown in the table represents the reporting capacity for the connection at the time the page was last loaded. Inactive (gray): No reports have ever been run on the connection in the last 2 hours, so no data is displayed for the connection.

For a single connection

1. In Customer Journey Analytics, select Tools > Reporting Activity Manager.

2. Select the linked title of the connection for which you want to view details.

   Reporting activity data is displayed for the connection that you selected.

3. (Optional) When a connection first loads in the Reporting Activity Manager, the data displayed represent the current utilization metrics. To see updated metrics after the initial load, select the Refresh button to manually refresh the page.

4. Use the available graphs and table to understand reporting activity in the connection.

   • View graphs

   • View table

View graphs

The following graphs are available to help you better understand the activity happening in the connection.

If graphs are not visible, select the Show graphs button.

Utilization graph

The Utilization graph shows reporting utilization for the selected connection over the last 2 hours.

Hover over the chart to view points in time where the usage capacity percentage was highest for that minute.

• X-axis: The reporting usage capacity over the last 2 hours.

• Y-axis: The reporting usage capacity percentage, by minute.

  

Distinct Users graph

The Distinct Users graph shows the reporting activity for the selected connection over the last 2 hours.

Hover over the chart to view points in time where the maximum number of users was highest for that minute.

• X-axis: The reporting activity over the last 2-hour time frame.

• Y-axis: The number of users who have made reporting requests, by minute.

  

Requests graph

The Requests graph shows the number of processed and queued requests for the selected connection over the last 2 hours.

Hover over the chart to view points in time where the maximum number of requests was highest for that minute.

• X-axis: The number of processed and queued requests over the last 2-hour time frame.

• Y-axis: The number of processed requests (in green) and queued requests (in purple), by minute.

  

Queueing graph

The Queueing graph shows the average queue wait time (in seconds) for reporting requests for the selected connection over the last 2 hours.

Hover over the chart to view points in time where the maximum average wait time was highest for that minute.

• X-axis: The average queue wait time for reporting requests over the last a 2-hour time frame.

• Y-axis: The average wait time (in seconds).

  

View table

When viewing the table, consider the following:

• You can choose to view data by choosing any of the following tabs at the top of the data table: Request, User, Project, or Application.

• You can search or filter the list of connections:

  • Use the search field to search for a specific connection. Begin typing the connection name or ID and the list of connections updates as you type.

  • Select the Filter icon to expand the list of filter options. You can filter by Status, Complexity, Application, User, or Project.

  • You can select Hide graphs to show only the table.

View data by request

When you select the Request tab, the following columns are available in the table:

View data by user

When you select the User tab, the following columns are available in the table:

View data by project

When you select the Project tab, the following columns are available in the table:

View data by application

When you select the Application tab, the following columns are available in the table: