Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Avatar
Shape 1
Level 2
nicolejaenchen
Level 2

Likes

12 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Shape 1
Level 2
nicolejaenchen
Level 2

Likes

12 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
nicolejaenchen
Level 2

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. 

1 Comment

Avatar

Avatar
Level 1
DavidLippert
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
DavidLippert
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile
DavidLippert
Level 1

21-04-2020

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