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

nicolejaenchen 21-04-2020

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. 

data issue data warehouse last hour total seconds spent
1 Comment (1 New)
1 Comment
DavidLippert 21-04-2020

For our Editorial Teams it is really important to deal with consistent data. Fixing the 20% gap would help a lot!