Count of deals created over time with status custom report

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. 

Terminology

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.

1. Click Reports > Custom Reports.
2. Click the "Deals" view located under Explore. This will expand the "Deals" view.
3. Next, you'll need to add a time dimension to the report. To do so, click "Created Date" and then click "Created Month."
4. Click the "Dimensions" tab, then scroll down to locate the "Status" option. Click "Status."
5. Now, you'll need to pivot the report by status. To do so, click the "Pivot" button next to "Status."
6. Next, you'll need to add report measures. To do so, click the "Measures" tab, then click the "Count" option.
7. 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.
8. 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.
9. Click the "Run" button located at the top of the report.

The data will be rendered in a table format.

Add a chart to the report

Once you run the report, you can add a chart 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 to 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.