000 listed as a value in event_list/post_event_list column in Clickstream Data Feeds

Issue

Multiple 000 are listed as values in the event_list/post_event_list columns in Clickstream Data Feed. However, there are no such values in the event lookup file. What is the best way to interpret or read those values?

Environment

Analytics Data Feeds

Microsoft Excel

Cause

It is due to formatting issue in Excel. This issue is seen when a CSV file is being opened in Excel. Ideally, event_list column contains events listed as 200, 202, 204, 206, 208, 210, 222 (for example). Excel considers it as a number with comma as a thousand separator. So, it rounds off the number by converting the last digits to 000. So, event_list would appear as 200, 202, 204, 206, 000, 000, 000.

Resolution

Use some other tool for analyzing the file. For example, use a CSV editor or a tool like R to format the data to get the correct values in event_list.

Additional resources

Dette arbejde har licens under en Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Opslag på Twitter™ og Facebook er ikke omfattet af vilkårene for Creative Commons.

Juridiske meddelelser   |   Politik for beskyttelse af personlige oplysninger online