Expand my Community achievements bar.

Data Warehouse: Additional Preset 'last hour complete' to prevent up to 20% data loss in total_seconds_spent

Avatar

Level 2

4/21/20

With the current preset of 'last hour' to automate data warehouse exports for loading into our own corporate data warehouse we are currently loosing up to 20% of 'total seconds spent' on each exported hour.

Therefore we suggest to develop an additional preset of 'last hour - complete' which creates the export after all relevant measures, especially 'total_seconds_spent', are complete, approximately 30 min after the hour is finished.

Alternatively a preset of 'last 2 hours' would also help by enabling us to overwrite/correct the first of the two exported hours on our side. 

1 Comment