Generating a web page made of clickable squares proportional to the views
Code is not my specialty, but I believe this would be the right place to ask for help. I'll admit that I'm just discovering this forum, but now that I'm in, I hope I'll be able to contribute as well, even if my english might not be perfect.
I'm in a new workplace working on the website. The stats shows that out of more than 3000+ pages, the first 8 pages have 40% of the total views and only the first fifteen pages have more than 1% of the views.
Not the first time I see such a high concentration, but I had the idea to illustrate that on a web page made of clickable squares proportional to the views, with something like 100 or 1000 views = 1 pixel. I could do that with unique visitors as well, I don't know yet.
Secondary goals would be to customize that page with colors representing sections. We spend a lot of time maintaining pretty much useless pages and I want to show that correlation.
I'm using google analytics and the data is easy to export, but any of you can think of a way to generate at least the basic page showing "squares" proportional to the views or unique visitors out of a spreadsheet? A little script could be useful, I suppose, but I'm not finding anything searching Google for an already made solution.
Don't know yet if this experiment would be useful or useless, but it's stuck in my head now! I want te see it! :-) Any ideas?