Dan Zarrella’s talk on the science of blogging (#blogsci; my sketchnotes) was an interesting data-backed analysis of what kinds of behaviour were correlated with views, comments, Facebook shares, and Twitter retweets. It inspired me to take a look at my Google Analytics. Here are some highlights, what I think about them, and what you might look at when you’re reviewing your own statistics.
|Browser||Visits||Percentage||Worldwide usage share (Nov 2010)|
|4. Internet Explorer||1,414||11%||58%|
49% of visits came from people on Microsoft Windows, 24% from Linux, and 19% from Macs. Hi to the iPhone, iPad, Android, iPod, SunOS (really? cool!), Blackberry, *BSD, UNIX, and Symbian, and Playstation users, too!
Take a look at your visitor statistics to see what people are using. Then you can decide if the average screen resolution will let you play with a wider layout, if you can take advantage of Flash, and so on.
Looking at your most popular pages can tell you what people want to read about. The most popular pages in November were my blog homepage, a blog post from 2008 on outlining your notes with Org, my Emacs-related posts, and a post on recording ledger entries with org-capture. Orgmode.org is the top referring site, beating Twitter, Facebook, EmacsWiki, and Drupal.org. Emacs rules. ;)
Use your popular pages list to learn more about what you’re currently doing well, and do even better at it. If you’re surprised by the results because your favourite pages aren’t on it, look for ways to make it easier for people to find and link to your content.
Your traffic sources tell you if you should focus on links, searches, or direct traffic. On my blog people come in fairly evenly from referring sites, search engines, and direct traffic (28-31% each). Aside from my name, other keyword searches tend to be fairly technical: error messages I’ve written about, and Emacs and Drupal-related questions. Some people come looking for visual notes, though, so that’s fun. =) Other people might get different results.
If you see more searches, you might consider writing more about that topic and working on being easier to link to. If you don’t see a lot of direct traffic to your blog homepage, think about whether your domain is easy to spell. I registered LivingAnAwesomeLife.com and sashachua.com to make it easier for people to get to me, as my name is hard to spell. Domain names are not free, but I think of it as an investment in potential conversations.
Do people return regularly? 40% of visitors in the last month have been to this site before, and they spend twice as long on the site than new visitors do (3 minutes instead of 1.5 minutes). I think that’s encouraging. 112 people have been to this site more than 200 times. (Hi mom!) 20% of visits were after another visit on the same day, so I might look into increasing my posting frequency from once a day to twice a day.
Do you have regular readers, or do people leave and never come back? Think about whether you meet the promise your site makes. All the search engine optimization tricks in the world don’t matter if people come, get disappointed, and leave. Do people come more often than you post? Consider posting more often, so there’s something fresh for people when they come.
Even if you’re writing a personal blog and not doing it as a business, you can learn interesting things from your statistics. Don’t let the numbers stop you from writing about whatever you’re interested in, though. Get that knowledge out of your head and into a form you can work with. And if you’re just starting out and your numbers are small, don’t worry. Everyone starts somewhere. =) Being boring, making missteps, and experimenting with doing better are all part of the process. Add analytics to your blog, and then start using the data to help you experiment!
|Goal 1: Learn||Goal 2: Explore||Goal 3: Improve||Goal 4: Save time||Goal 5: Build||Goal 6: Learn from others||Total|
|T1: Draw original stuff||5||5||5||5||5||3||28|
|T2: Draw book reviews and events||5||2||5||5||5||5||27|
|T3: Think out loud||5||5||5||1||5||3||24|
|T4: Share tech tips, troubleshooting notes, or code||5||5||3||4||2||4||23|
|T5: Review longer spans of time (yearly, decisions)||5||4||5||1||5||3||23|
|T6: Write tips that few other people can cover||4||2||3||3||4||3||19|
|T7: Write tips that other people can also cover||3||1||2||2||2||2||12|
|T8: Review recent posts (weekly, monthly)||1||1||4||1||4||1||12|
|Post type||Number of pages||Number of views||Average page views per page||Average minutes per page view||Average bounce rate|
|T1: draw original||23||2875||125||3.4||67%|
|T4: share tech||149||12468||84||5.8||74%|
|T2: draw book / event||41||2346||57||2.3||64%|
|T3: think out loud||62||2452||40||3.4||72%|
|T5: review long / decision||14||504||36||2.7||73%|
|T6: write tip (few)||41||1392||34||3.1||72%|
|T7: write tip (many)||24||461||19||4.7||73%|
SELECT year, month, COUNT(*) AS num_days FROM (SELECT date_part('year', day_ts) AS year, date_part('month', day_ts) AS month, day_ts FROM (SELECT DISTINCT day_ts FROM table_with_data) AS temp) AS temp2 ORDER BY year, month
generate_sequencecommand, so you can do something like this:
SELECT missing_date FROM generate_series('2015-01-01'::date, CURRENT_DATE - INTERVAL '1 day') missing_date WHERE missing_date NOT IN (SELECT DISTINCT day_ts FROM table_with_data) ORDER BY missing_date