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


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?


Analytics Data Feeds

Microsoft Excel


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.


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