Reporting Manager’s Smart Interval feature allows you to optimize data pulls where historical data is necessary to add context to your reporting. In cases where you want to keep a trail of historical data (say, to report year-over-year comparisons), smart interval makes it easy to keep the historical data in place, and not worry about missing days in reporting.
Pull only the data you need
With some other Excel add-ins, making historical comparisons or viewing trends means you need to re-pull historical data on every refresh of your report. With Reporting Manager, historical data is kept in place and only the new data is pulled when you run an update to your report. With the Smart Interval feature, data for intervals that have passed since the last time you updated your report will be pulled.
Fill in reporting gaps
A daily report may not get refreshed over a long weekend, or a weekly export may miss a pull over the holidays. With Smart Interval in Reporting Manager, the intervals you missed will be automatically populated the next time your update your reports. Further, you can re-pull historical data just by removing it from your spreadsheet — on the next refresh, Reporting Manager will detect the missing data, acquire it and drop it into place.
Update variable-sized tables
Smart Interval also allows you to put tables into your spreadsheet where you may not know how many rows the exported data will contain. For example, a channels report may contain five channels one week, and six the next — Smart Interval keeps track of the size of the table to ensure that all of its data is replaced on every refresh.