Why is there a difference between the data I'm now seeing in Data Query and the data in a DQ export scheduled in real-time?

When we export the data for a period going from H-1 to H, we look for information pertaining to visits that started in that time frame (the template contains the Date-time (visit start) dimension) and extract the events.

Let's take a visit that started between 00:00 and 01:00 as an example. The visit may have lasted longer than an hour, and as such certain visit events would have occurred outside of the specified timeframe. Those events do not appear in the scheduled 00:00 to 01:00 export. They will not appear on the scheduled 01:00 to 02:00 export either, however, as the visit they depend on started during the previous hour. As far as real-time exports are concerned, the actions will not appear.

If you're attempting to get the same information as on Data Query by the hour, the best solution would be to use the Data Flow API.

Have more questions? Submit a request