Skip to main content
A month-over-month report totals a metric (a number Cometly measures, such as leads, purchases or ad spend) for each month and compares it to the previous period. You build it in the Report Builder, the part of Cometly where you create your own reports. Daily numbers jump around, which makes a slow rise or decline hard to see. Monthly totals with a percentage change beside them show whether your leads, sales or spend are growing or slipping, and in which month the change started.

Build a month-over-month report in the Report Builder

1

Choose the report type, date range and metric

  1. Click Report Builder in the sidebar.
  2. Select the report type. Table is recommended for this analysis.
  3. Set the Date Range to the period you want to analyze. For example, select Last year to get a full 12 months of data.
  4. Under Metrics, add the metric you want to analyze. This example uses Lead, but you can choose any metric in your account.
2

Group the data by month

  1. Scroll down to Group By. A new report is grouped by Time and shows one row per day.
  2. Under the Time selection, choose Month (the options are Day, Week, Month, Quarter and Year).
Your metric is now totaled per month, which makes monthly trends easier to read.
3

Add a previous period comparison

  1. Click the Options tab at the top of the left panel.
  2. Turn on Compare to previous period.
The report now compares your metric to the equivalent previous period and shows the change as a red or green percentage.Look for increases and decreases, and for patterns or anomalies.
4

Refine and save the report

  1. Back on the Report tab, narrow the report if you need to:
    • Use Filters such as Campaign Name or Ad Set / Ad Group Name.
    • Use Sources to limit it to specific traffic sources (for example Facebook Ads or Google Ads).
  2. Give the report a descriptive Report Name (for example “Leads month over month”).
  3. Click Add To Dashboard and pick a dashboard.

Tips

  • Use the monthly grouping and the previous period comparison together to get the full picture of your trends.
  • Combine this with other metrics to find opportunities to act on.
  • Review the report on your dashboard regularly to keep an eye on performance.

Check it worked

The report preview shows one row per month for your metric, with a red or green percentage beside each value. After you add it to a dashboard, the report appears as a card on that dashboard.

Frequently asked questions

What does “previous period” mean in a Cometly report?

It is the period of the same length immediately before your Date Range. With Last year selected, the previous period is the year before it, and each month is compared with the month in the same position of that earlier year. With a custom range, it is the same number of days directly before your start date.

Why is there no comparison when the date range is All data?

All data has no earlier period to compare against, so there is nothing to calculate a change from. Choose a range with a start and an end, such as Last year or This year, to see the percentage change.

Where do I find my report after I save it?

A report is saved by adding it to a dashboard, so you find it on the dashboard you picked. To change it later, open the menu on its dashboard card and click Edit Report.

Next steps

Still have questions or need a hand? We’re happy to help. Reach our team at support@cometly.com.