---
title: "Build Reports for Custom Analytics"
slug: "build-reports-for-custom-analytics-1"
tags: ["Ops Manager", "On Demand", "Own Fleet", "Click and Collect", "Bringg Platform", "Dispatcher", "Delivery Hub", "Analytics", "Planned"]
updated: 2024-04-08T08:23:22Z
published: 2024-04-08T08:23:22Z
canonical: "help.bringg.com/build-reports-for-custom-analytics-1"
stale: true
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.bringg.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Build Reports for Custom Analytics

Improve the performance of your fulfillment operations by creating actionable insights from your Bringg data. Prepare a report with all the data that you need to perform your own analysis and make strategic decisions.

You can use out of the box system reports, or build new reports by either adjusting a template report or creating a custom data table tailored to the theory you are testing. When you generate a report, Bringg populates the table with live data from the database. You can use the table to juxtapose different data points and pinpoint patterns of behavior.

![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/analytics_report_add_custom_dgm.png)***Select database fields to assemble your own data table***

	

For example, you can compare estimated versus actual time on site (ETOS versus TOS), to pinpoint issues with driver efficiency or route planning. Or you can check if there is a correlation between a driver's workload and their performance by comparing the number of orders that they complete in a shift with their customer satisfaction rating. .

You can also:

- Duplicate existing reports to add or adjust certain columns without needing to build reports from scratch.
- Incorporate custom attributes specific to your business into your reports.  For example, include your custom order statuses to get a comprehensive view of your orders' progress.
- Share your reports with stakeholders on a regular basis, for example as weekly reports to management. [Learn more](/v1/docs/dispatcher-guide-share-a-bringg-report).
- Merge the data with other sources to reach further insights. [Learn more](/v1/docs/merge-bringg-report-data-with-other-sources).

### Before You Begin

- Confirm you have a Bringg user of type Admin.
- (Optional) Create a theory that you would like to prove or disprove by checking the data. For example, you may want to prove that a change in your assignment method creates a more equal distribution of orders between your drivers.
- Consider the fields you need to compare, side by side in a table.
  - Determine what each row should represent. This is usually identifying information, such as the driver's name, an order ID, or a specific fleet.
  - Determine the aggregate measurements you want to see for each row. For example, if you want to see how many orders each driver on a team delivered in a specific week, you would select the **Completed Orders Count** measurement as one of the columns in your table.

### Procedure

**Step 1**: Open the Bringg Platform and navigate to **Analytics > Reports**.

![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678703368989.png)***Access the report pages in Bringg***

	

**Step 2**: Open a data table for your report, either by using out of the box reports, or by creating your own.

| To... | Do this.. |
| --- | --- |
| Use a system report | Select **System Reports** and choose the report you would like to view from the list. The columns in system reports are preset and not editable, but you can filter according to any of the preset columns included. ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678703391068.png)***Choose from a menu of out of the box reports*** |
| Customize a template report | 1. Select **My reports > New report**. 2. Choose a template report that includes at least some of the data fields you need. For example, select the **Carrier Performance Metrics** template to compare different carriers on time rates. ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/analytics_report_template_create.png)***Edit a pre-configured report*** |
| Create a report from scratch | 1. Select **My reports > New report**. 2. Choose the category of reports you wish to create from the left menu. 3. Select **Blank Report** to open the report builder. ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/analytics_report_create_blank.png)***Open a blank report*** |
| Revise an existing report | Select **My Reports** > report name > **Edit**. Any saved changes apply to the report itself. ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/analytics_report_edit.png)***Edit a report*** |
| Duplicate an existing report | 1. In **My Reports**, choose a report from the list. 2. Select the context menu ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678703639117.png) > **Duplicate**. The duplicate copy appears below the original in your reports list. Alternatively, you can also select **Duplicate** from inside an opened report. ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678703661057.png)***Create a copy of a report in order to edit*** |

**Step 3**: Define the table columns that help prove or disprove your theory by selecting corresponding fields from the list of database fields.

You can find fields using the search bar, or by opening collapsed tables to view the full list of fields they contain.

![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/analytics_report_add_field.png)***Build your report by choosing a field and adding it as a table column***

	

The leftmost column determines the kind of information you want to see in each row, like choosing **Order** **ID** in the left column means each row represents an order, whereas **Carrier ID** means each row represents a carrier.

For example, to compare the number of orders completed by each driver, create a data table that includes **Driver id, Driver Name** (from the **Users** table) and **Completed Tasks Count**. Ensure the **Driver id** or **Driver Name** is the leftmost column so that each row represents a single driver.

	
	Tip
	You must include at least one field from the main table associated with the kind of report you are building. For example, if you are building an order report, you must use at least one field from the **Tasks** table.

**Step 4**: Preview your report by selecting **Run**.

![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/analytics_report_load.png)***Populate your report with data***

	

	
	Tip
	Some fields have embedded calculations that create at-a-glance visibility into your fulfillment data. For example, **Created Tasks Count** indicates the total number of orders created, and **Average Rating Score** shows the average consumer rating for a delivery or driver.

**Step 5**: (Optional) Customize your report by changing the title or adjusting the position of the columns.

Ensure the titles you choose clearly distinguish each report from the next.

![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678703978963.png)***Customize the title and columns of your data table***

	

| To... | Do this... |
| --- | --- |
| Change the title and description of your report | Select the edit icon ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678703987787.png)next to the report title or description to enter text. |
| Rearrange the report columns | Hover over a column, select the ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678703998102.png) icon and drag it to a different position. |
| Remove a column | Hover over the column title then select ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678704007215.png), or deselect the column's database field from the list. |
| Change a column heading in your data table | Hover over the column, select the edit icon ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678703987787.png) and enter the new column name. |
| Sort the report by a specific column | Hover over a column header and select the sort icon ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678704026867.png), when you've populated the data table. |
| Sort the report by multiple criteria | Select the sort icon ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678704049189.png) > **Add column to sort sorting** to select which columns you wish to sort in what order. |
| Adjust the time frame for the report query | Use the time filters to select the range you wish to see. ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/analytics_report_filter_date.png)***Choose the report's time range*** You can also create a filter based on a different time field. To do this, select **+More filters**, then select a field from the **Time filters list**. For example, to check the number of orders completed each month, remove the original time filter and create a new one using the field **Orders Ended Time**. ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/analytics_report_filter1.png)***Include a time filter in your report*** Tip To protect the privacy of your organization and consumers, Bringg stores personal identification information (PII) data related to orders for 30 or 60 days back from the current date, depending on whether you are viewing a legacy report or using the report builder. However, anonymized data remains in the system to use for the purpose of data and analytics for a period of six months. |
| View a summary of the data inputs. For example, see how many unique drivers are included in a driver report. | Select the summary icon![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/analytics_report_summary_icon.png).![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/analytics_reports_summary1.png) |
| Focus your data and reduce distraction | 1. Add filters by selecting **+ More Filters** > data field, then choose which inputs you want to view. For example, select **Team** then choose the relevant team IDs to view results for those teams only. ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678704117874.png)***Focus your data by adding filters*** 2. Select **Apply**. Tip Once you include at least one field from a certain database table, you can filter your report by any other field in that table, even if the field is not included as a column in your report. |
| Aggregate individual data points into an average over a time period | Select **Group By** For example, instead of showing each consumer rating for each order, you can show a daily average by grouping the report by **Day**. This requires at least one of the columns in the report to be a date or time field. |

**Step 6**: Select **Save** to store your report so you can rerun it at a later time.

Bringg stores all your custom reports under **My Reports**.

![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678704153369.png)***Save your report to run and view when needed.***

	

**Step 7**: Download a report to extract actionable insights by selecting the report from the **My Reports** or **System Reports** list, then selecting **Download** and choosing a file format.

For example, to calculate averages, peaks, sums, pivot tables or graphs, download a report in CSV format and process the data in Excel.

![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678704176856.png)***Download a report to view and process the data***

	

	
	Tip
	Confirm the report is populated with data for the required time frame and you applied the correct filters before downloading it.

You can also share reports with colleagues. [Learn more](/v1/docs/dispatcher-guide-share-a-bringg-report).

**Step 8**: To delete a report, select **My Reports**. Select the context menu ![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678704205704.png) of the report you want to delete, and select **Delete**.

You can also select **Delete** from within an open report.

![](https://cdn.document360.io/a18074ef-073a-4ab1-bcab-12625715280e/Images/Documentation/image-1678704217687.png)***Remove reports you don't use***