Build the new vs. returning customer reports
1
Report all customer purchases in the last 30 days
- Click Report Builder in the sidebar.
- Under Report Name, enter “All Customer Purchases | Last 30 Days”.
- Under Date Range, select Last 30 days.
- Under Metrics, add Purchase.
- Check the data in the preview.
- Click Add To Dashboard, pick a dashboard, then click Add to dashboard.
2
Report new customer purchases in the last 30 days
- On the dashboard, open the menu on the “All Customer Purchases | Last 30 Days” report and click Edit Report.
- Change the name to “New Customer Purchases | Last 30 Days”.
- Under Filters, add the First Purchase Date filter, choose less than and enter 31 days ago.
- Check the filtered data, then click Add To Dashboard to save it as a new report.
3
Report returning customer purchases in the last 30 days
- On the dashboard, open the menu on the “New Customer Purchases | Last 30 Days” report and click Edit Report.
- Edit the First Purchase Date filter: instead of less than, choose more than and enter 30 days ago.
- Change the name to “Returning Customer Purchases | Last 30 Days”.
- Check the data, then click Add To Dashboard to save it as a new report.
When you edit a report, Add To Dashboard saves your changes as a new report and leaves the original as it was. Update Existing Report overwrites the report you opened.
Cautionary notes
- Make sure each report uses the same date range, so all three reflect the last 30 days.
- Double-check the filter on each report before you save it.
Tips for efficiency
- Start each new report from the previous one (with Edit Report) to save setup time.
- Update the date range and the filter together when you analyze a different time period.
Check it worked
Your dashboard now shows three reports: “All Customer Purchases | Last 30 Days”, “New Customer Purchases | Last 30 Days” and “Returning Customer Purchases | Last 30 Days”. Open the new and returning reports with Edit Report: each one lists the First Purchase Date filter under Filters, and the all-purchases report has no such filter.Frequently asked questions
What does First Purchase Date mean in Cometly?
First Purchase Date is the date a contact first purchased. Filtering a report on it lets you keep only the contacts whose first purchase falls inside, or outside, the period you are looking at.Can I compare new vs. returning leads instead of purchases?
Yes. Every event in your space has its own first-date filter, named after the event, such as First Lead Date. Add that event under Metrics and use its filter in place of First Purchase Date.Can I filter by a specific date instead of a number of days ago?
Yes. Besides more than, exactly and less than a number of days ago, the date filters offer is between, after, on and before, which take calendar dates.Next steps
- Build a report in the Report Builder
- Analyze metrics month over month
- Customize a dashboard
- How events work