Date is referenced from the date_time field from the data feed. I was not aware that page name also had a post_ version. I have replaced it with post_pagename but the numbers are still not matching with what we're seeing in adobe analytics.

We are trying to build certain metrics from the adobe raw files that we export through the data feed. We have been successful in calculating visits and page views. But when we try to apply logic that we have in a segment (Ex: page = x OR page = y) we don't seem to get the same number of visits we se...

Hi, this is the code we used and it gave us correct numbers. I see you are missing the exclusion of hit_source 5,7,8&9.SELECT count(distinct concat(post_vis_id_high,post_vis_id_low,CAST(visit_num AS VARCHAR),CAST(visit_start_time_gmt AS VARCHAR)))Visits, batch_date FROM "adobe_data_feed"WHERE exclud...