Hello @Harveer_SinghGi1,Firstly, Really appretiate your quick reply with a really close logic.I have use the below logic for 1july2024 adobe data : But there is a slight difference still. SELECT date, COUNT(*) as bounces FROM  (    SELECT date(date_time) AS date,           COUNT(*) AS bounce    FROM...

Have used the below query:  SELECT date, COUNT(*) as bounces FROM  (    SELECT date(date_time) AS date,           COUNT(*) AS bounce    FROM `datafeedtable`    WHERE    exclude_hit = '0'    AND hit_source NOT IN ('5','7','8','9')    AND date_time BETWEEN ('2024-07-01 00:00:00') AND ('2024-07-01 23:5...

Hi everyone.I´m trying to calculate the Bounces in Data Feed, But the count are not matching from the adobe dashboard counts for bounces. For Example: I have done the calculation for 1july2024 only one day data.below is the count for Adobe Dashboard and the my logics count :My logic count: 5864Adobe...

Hello @RodrigoPan/ @PratheepArunRaj,Hope you guys are doing well, Are you guys able to find the exact logic forthe bounce field as i am also facing issues while calculating the exact logic. Can you assist here.ThanksAkshay Shrivastava