Expand my Community achievements bar.

Join us for our next community Coffee Break on February 28th! Four of our Analytics Champions will be joining us to discuss Summit tips, best practices, and any of your Analytics questions!

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