How to Quickly Clean Up Generated SmartUp Reports

1. Download the generated report from the Analytics function.
2. Open a new excel file > click on Data ribbon > click Get Data from Text or csv > select downloaded report file.
3. Ensure that Delimited is selected, click Next.
4. Ensure that Tab is checked, click Finish.
5. You can refer to Current generated report header on the download panel to understand how the data is organised.
6. Delete any unwanted columns within the imported data e.g. system generated IDs.
7. In case you need to share the raw data file, do remove links to external files. You can so so by copying all data and 'paste special' (value only) into a new tab in excel, and then delete the old tab. 
   
   
   
   
   
   
8. Do note that all timestamps are based on Coordinated Universal Time (UTC). If you wish to analyse data in a certain timezone, for instance, in Singapore's timezone (UTC +8), you will need to convert the current timestamps. To do this, use the following formula in a new column beside the timestamp column:
   
   "='current corresponding timestamp column + 8/24"
   
   
9. Right click on the top row of the spreadsheet in order to insert an extra row for column headers at the top of the spreadsheet.
   
   
   
   
   
10. Put in corresponding titles to each column within the spreadsheet.
11. Convert Timestamps into a comprehensible format by highlighting the time columns.
    
    
12. Now, you will have a clean set of data to start your Pivot Table analysis! Here's our tip on How to Analyse Content Interaction Reports.