Hi @PratheepArunRaj  I already did this when I concatenated the columns “post_visid_high || post_visid_low || visit_num || visit_start_time_gmt”, right? There is no visitor_id field in the feed.

Hello @PratheepArunRaj   ! Thanks for another reply! I tried with this another condition, but the number only decreased 21 records (6.355):I selected all the records from the day “2021-01-01” (28.129), I concatenated the columns “post_visid_high || post_visid_low || visit_num || visit_start_time_gmt...

Hi everyone!I am using the Data Feed and I can´t calculate the "Time Spent Per Visit" and "Time Spent Per Visitor" metrics. I've tried to use the follow tips but I can't obtain the values: Time spentHits must first be grouped by visit, then ordered according to the hit number within the visit.Concat...

This time, I chose one day (“2021-01-01”):Workspace/Report Builder: 5.166Data Feed: I selected all the records from the day “2021-01-01” (28.129), I concatenated the columns “post_visid_high || post_visid_low || visit_num || visit_start_time_gmt” and, after the concatenated, I identified how many di...

I did a case condition for both columns (column Bounces: case when visit_page_num = '1' then 1 else 0 end and column Bounces2: case when visit_page_num = '1' and post_page_event = '0' then 1 else 0 end) and in the end I sum each columns values. But I have to keep the distinct record based in what co...

Hm, understand!I included a preview of my data, comparing the data from Workspace Analytics or Report Builder and the script from Data Feed:Workspace Analytics or Report Builder: Data Feed:  The visits, unique visitors, page views and page views / visits are ok (I followed the rules of the calculate...

Hi @PratheepArunRaj , thanks for your answer. So, if i need to breakdown for days or months (for example), I can´t reach the real number of bounces?In Workspace Analytics and Report Builder I got the same number of Bounces, but I can´t get this number in Data Feed.

Hi everyone! I´m trying to calculate the Bounces and Bounce Rate in Data Feed, but I´m not finding the right way.I´ve tried to combine the visit_num, visit_page_num, page_event and post_page_event fields, but I can´t find the same number of the Workspace Analytics. @Ishan_Sinha_ had a post with this...