Do you have any tips on weekly unique visitors via querying clickstream data feed? I was able to get the daily query above to work perfectly via the where clause:WHERE date_time LIKE ('2017-11-18%'), but when I use something like BETWEEN ('2017-11-08 00:00:00') AND ('2017-11-08 23:59:59') for the we...

Do you have any tips on weekly unique visitors via querying clickstream data feed? I was able to get the daily query above to work perfectly via the where clause:WHERE date_time LIKE ('2017-11-18%'), but when I use something like BETWEEN ('2017-11-08 00:00:00') AND ('2017-11-08 23:59:59') for the we...

I am attempting to pull a unique visitors report directly from our Adobe Analytics data as opposed to using the online report generator. In doing so, I made sure to filter for the recommended values based on this page: Identifying Visitors However, the results of my queries are showing about 10% mor...