Analytics
2.5K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
 
Guide Me
star_border
Reply

GA Data Import - Issue with Matching Keys

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

 Hi,

 
I have imported a data set into GA Standard with encrypted value as key. The data is uploaded as 2 csv files of size 950 MB.The issue I am facing is - GA matched only ~50% of the keys that actually match. Rest of the ~50% are not matched although the keys are present in imported file and in also recorded n GA.
 
I looked through for special characters - but there is no pattern in the records that do not match. Both matched and unmatched keys have common special characters.
 
Example:
 
Matched Keys:
  • 8K8W/FuU0gCfz508XjkIgA==
  • 99yx8Al2/jwZTOYYMs8Grg==
  • kR3+1EMu2auOkD0GdyOhbA==
  • R2I48FAfOr9myhjJcxghQg==
  • vIdP5lwmv2nMkynHnLxH0w==
Unmatched Keys(Present in GA hits and imported data - But not Matched by GA):
  • qZMF5sInnI65MRGGbQgz/w==
  • D9BV0vr7or4NXMKN1fVorQ==
  • xwX65yevb8wcY7Zw3Ehkjw==
  • jcP8asx1Ym8QKIR36573fg==
  • hBT6Vh0H5qjzdnvP5v6U7Q==
Wondering if any one has faced this issue and keen to know the solution used if any.
1 Expert replyverified_user

Re: GA Data Import - Issue with Matching Keys

Rising Star
# 2
Rising Star
Hari if you are still having this issue look for things like a space at the begining or end of the keys that do not match the match must be exact so case is important and so are hidden characters such as white spaces most likely they are at the end of the key.