Kindly try the below code: SELECT COUNT(DISTINCT CONCAT(post_visid_high, post_visid_low, visit_num, visit_start_time_gmt)) AS Bounces, DATE(date_time) AS Day FROM table WHERE exclude_hit = '0' AND visit_page_num = '1' AND visit_num = '1' AND page_event NOT IN ('10', '11',...

Hi @SanyaTh1, the solution could be achieved in three ways: 1. By Implementing Cross-Domain Tracking: Share the ECID across both subdomains. Ensure the ECID is same across domains. - Configure cookies to be set at parent domain level. For Eg: instead of using domain as "abc.domain.com" or "xyz.domai...