Thanks @Harveer_SinghGi1 I'll look into that!Wondering if the issue would have been avoided by checking the box when setting data feeds up?  

Could it be that the data frame doesn't show the correct order once in R because 650MB is too much data for R Studio to handle? thanks again for the help!

Hi @Harveer_SinghGi1 ,So is that '\' character unusual to see in AA data feeds exports, as the one in the screenshot I shared?Regardless if set escape_backslash = TRUE or FALSE I see values that seem to belong to other columns not sure yet of the %, wondering if that is a red flag, also if it is a p...

Thanks both @Harveer_SinghGi1 & @Jennifer_Dungan ! If I change  escape_backslash = TRUE to FALSE then it doesn't get removed and results in a 96% match with AAUI page views vs row count of post_pagename (the smaller value is in DataFeeds).Looking at distinct post_pagename the values make sense and d...

But great point I'll double confirm.

Thanks @Jennifer_Dungan The tsv is from Feb 13th and occurrences match a little above 99% so that's partial good news, suggesting the data is settled by now. The issue is getting into other metrics.

Thanks @Harveer_SinghGi1 ! As confirmed to Jenn, this data is almost 2 weeks old. I applied what you just shared and got:Error in hit_data_df$exclude_hit == 0 && !(hit_data_df$hit_source %in% c(5, 7, 8, :'length = 253048' in coercion to 'logical(1)'Wondering why. Lets see if I understood what you sh...

Hi @Jennifer_Dungan the 1 hour feed file is from mid February, so more than a week has gone by. thanks! 

Thanks so much!

Hello @Harveer_SinghGi1 !! I wasn't able to get this to work:hit_data_df <- merge(hit_data_df, browser_df, by.x = "browser", by.y = "browserID", all.x = true)I received "Error: object 'true' not found"It seemed to have worked with this but wanted to show because it was trial and error, so not sure i...