What is the difference between a cumulative scheduled report and a comparative scheduled report?
When you create a scheduled report, you can choose whether you want that report to be cumulative or comparative in the “Decide How You Want The Data To Be Calculated” field.
- Cumulative reports include data from previous scheduled reports.
- Comparative reports include data since the last scheduled report was emailed to you.
Note: Even if report data is comparative, it is not static. Manually running the same report in the future may produce different results, since readers can backlog and delete entries.
We recommend scheduling comparative reports to run early in the morning. Comparative scheduled reports run from the start of the day (midnight) of the last day the report was run. It would be the day before if the reports are run every single day, to the end of the day of the current date (the day the report is running).
If the report is run at 9:00 a.m., for example, the end of the day is 9:00 a.m., but it would include any data from midnight to 9:00 a.m. of the current date and all 24 hours (midnight to 11:59 p.m.) of the previous day. Due to that time frame, sometimes there is duplicate information in the comparative scheduled reports. On the next day, you will again have that information from 12:00 a.m. to 9:00 a.m. of the day the last report was run, but then you will also have all of the information from 9:00 a.m. of the day the last report was run until 9:00 a.m. of the day of the current report.
This is the optimal way for us to run reports at this time given differences in our client timezones, in order to ensure that we do not omit any information.
To avoid duplicate information, we recommend scheduling the report earlier in the day, before readers would be likely to take any actions recorded in reports.