Differences

This shows you the differences between two versions of the page.

--- en:dpi:dpi_options:opt_li:li_troubleshooting:li_troubleshooting_clickstream_rep_csv [2020/02/05 17:36] – ↷ Page moved from en:dpi:dpi_options:base_functionality:opt_li:li_troubleshooting:li_troubleshooting_clickstream_rep_csv to en:dpi:dpi_options:opt_li:li_troubleshooting:li_troubleshooting_clickstream_rep_csv lexx26
+++ en:dpi:dpi_options:opt_li:li_troubleshooting:li_troubleshooting_clickstream_rep_csv [2023/08/30 09:56] (current) – removed elena.krasnobryzh
@@ Line 1: / Line 1: @@
-====== Sample of Clickstream report in csv format ======
-{{indexmenu_n>1}}
-Click stream is saved in files url_*.
-Process sample to get top of sites in csv report.\\
-Top 50 sites:
-  cut -f 4 /home/clickstream/url_07*|sort|uniq -c|sort -nr|head -50|awk '{print $2";"$1}' > top_sites.csv
-Top 50 video sites:
-  cut -f 4,5 /home/clickstream/url_07*|grep "\.mp4\|\.avi"|cut -f1|sort|uniq -c|sort -nr|head -50|awk '{print $2";"$1}' > top_video.csv

Profile