Thanks for reminding me @Sukrity_Wadhwa  and for the help @Harveer_SinghGi1 & @Jennifer_Dungan !

But the count of those transactions with 2 dates is not more than 140, so although it can be part of the issue, there could be something else adding to it.

Building a report showing transaction IDs and selecting one, looks like the same ID is being used from dates 6 months apart.

Hello,We are seeing transactions in AA that aren't in the back end system, about 60% aren't registered in the tool that actually charges for the orders.Can you think of reasons why?The transaction IDs that are captured in both the back end system and AA have a match of 96%.Thanks,Rafael 

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.