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