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

Această lucrare este oferită sub licență Atribuire-Necomercial-FărăModificări 3.0 Ne-adaptată Creative Commons  Postările pe Twitter™ şi Facebook nu sunt acoperite de condiţiile de licenţiere Creative Commons.

Prevederi legale   |   Politică de confidențialitate online