Count of deals created over time with status custom report


Also available as an add-on for the following plans:

Sales Plus and Professional

You can create custom reports with charts in your ActiveCampaign account. These reports can help you analyze information and answer specific questions you and your team may have around data or certain activities. When you create a custom report, you can save it to your account so you can access it at any time.

In this article, we'll show you how to create a custom report that shows you the number of deals created over a time range you set, along their current status. 


Before we get started, here are some terms you'll need to become familiar with as you create your own custom reports:

  • Dimensions
    Dimensions describe data in your account. For example, contact name, contact ID, or city.
  • Measures
    Measures are aggregate numbers.
  • View
    A collection of data elements.
  • Look
    Each report you create and save is called a Look.

Access the custom reporting tool

The custom reporting tool is located on the Reports section of your account. This is listed in addition to your standard reports.

To access the reporting tool, click "Reports" in the left menu. Then click "Custom Reports."

Create the Count of Deals Over Time with Status custom report

1. Click the "Deals" view located under Explore. This will expand the "Deals" view.

2. Next, you'll need to add a time dimension to the report. To do so, click "Created Date" then click "Created Month."

3. Click the "Dimensions" tab then scroll down to locate the "Status" option. Click "Status."

4. Now you'll need to pivot the report by status. To do so, click the "Pivot" button that appears next to "Status."

5. Next, you'll need to add report measures. To do so, click the "Measures" tab then click the "Count" option. 

6. You'll now need to add a Time Filter to the report. Click the "Dimensions" tab then click the "Filter" button located next to "Created Month."

Note that the filter will appear under the "Filters" Header in the center of your screen.

7. Now you'll need to add a Time Filter. Navigate to the "Deal Created Month" filter located in the center of your screen and type "12" into the second box.

8. Click the "Run" button located at the top of the report.

The data will render in a table format.

Add a chart to the report

Once you run the report, you can add a chart to it to provide a visual representation of the data. To do so, click the "Visualization" header to expand it then click the "Column" option.

Your data will be rendered as a column chart:

Save and access the report

Once you create your custom report and add your chart, you can save the report in your account so you can pull it up later. To do so, you'll need to save this report as a "Look."

1. Click the gear icon located next to the "Run" button.

2. Click "Save as a Look..."

3. In the "Title" field, type a descriptive title. For example, you can type "Count of Deals Created Over Time with Status."

4. Click "Save."

The report will be located in the Custom Report menu under "Looks." To access it, click the menu icon located next to the gear icon in the report, then select the Look you wish to view. 

Was this article helpful?
1 out of 3 found this helpful

Have more questions? Submit a request

Start free trial