Build a month-over-month report in the Report Builder
1
Choose the report type, date range and metric
- Click Report Builder in the sidebar.
- Select the report type. Table is recommended for this analysis.
- Set the Date Range to the period you want to analyze. For example, select Last year to get a full 12 months of data.
- 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
- Scroll down to Group By. A new report is grouped by Time and shows one row per day.
- Under the Time selection, choose Month (the options are Day, Week, Month, Quarter and Year).
3
Add a previous period comparison
- Click the Options tab at the top of the left panel.
- Turn on Compare to previous period.
4
Refine and save the report
- 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).
- Give the report a descriptive Report Name (for example “Leads month over month”).
- 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
- Build a report step by step
- Break a metric down with Group By
- Build a totals report for leads or purchases
- Customize your dashboards
- Use Quick Filters on dashboards