Example of generating a clickstream report in CSV format.
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