<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>Gilligan on Data by Tim Wilson</title>
	
	<link>http://www.gilliganondata.com</link>
	<description>Thoughts, musings, and, hopefully, not too many redundancies on the world of business data. If you missed the irony in the previous sentence, you may struggle with my writing style.</description>
	<lastBuildDate>Tue, 08 May 2012 11:00:33 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.3.2</generator>
<image>
  <link>http://www.gilliganondata.com</link>
  <url>http://www.gilliganondata.com/favicon.ico</url>
  <title>Gilligan on Data by Tim Wilson</title>
</image>
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/GilliganOnData" /><feedburner:info uri="gilliganondata" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><feedburner:emailServiceId>GilliganOnData</feedburner:emailServiceId><feedburner:feedburnerHostname>http://feedburner.google.com</feedburner:feedburnerHostname><item>
		<title>Four Dimensions of Value from Measurement and Analytics</title>
		<link>http://feedproxy.google.com/~r/GilliganOnData/~3/9a36Nf26GHs/</link>
		<comments>http://www.gilliganondata.com/index.php/2012/05/08/four-dimensions-of-value-from-measurement-and-analytics/#comments</comments>
		<pubDate>Tue, 08 May 2012 11:00:33 +0000</pubDate>
		<dc:creator>Tim Wilson</dc:creator>
				<category><![CDATA[Analysis]]></category>
		<category><![CDATA[Metrics]]></category>
		<category><![CDATA[Social Media]]></category>
		<category><![CDATA[Web Analytics]]></category>

		<guid isPermaLink="false">http://www.gilliganondata.com/?p=1834</guid>
		<description><![CDATA[When I describe to someone how and where analytics delivers value, I break it down into four different areas. They&#8217;re each distinct, but they are also interrelated. A Venn diagram isn&#8217;t the perfect representation, but it&#8217;s as close as I can get: Earlier this year, I wrote about the three-legged stool of …]]></description>
			<content:encoded><![CDATA[<p>When I describe to someone how and where analytics delivers value, I break it down into four different areas. They&#8217;re each distinct, but they are also interrelated. A Venn diagram isn&#8217;t the perfect representation, but it&#8217;s as close as I can get: <img class="aligncenter size-full wp-image-1844" title="4 Ways Measurement and Analytics Add Value" src="http://www.gilliganondata.com/wp-content/uploads/2012/05/4Ways.png" alt="" width="341" height="317" /> Earlier this year, I wrote about <a title="The Three-Legged Stool of Effective Analytics: Plan, Measure, Analyze" href="http://www.gilliganondata.com/index.php/2012/02/22/the-three-legged-stool-of-effective-analytics-plan-measure-analyze/">the three-legged stool of effective analytics: Plan, Measure, Analyze</a>. The value areas covered in this post can be linked to that process, but this post is about the <em>why</em>, while that post was about the <em>how</em>.</p>
<h3>Alignment</h3>
<p>Properly conducted measurement adds value long before a single data point is captured. The process of identifying KPIs and targets is a fantastic tool for identifying when the appearance of alignment among the stakeholders hides an actual misalignment beneath the surface. &#8220;We are all in agreement that we should be investing in social media,&#8221; may be a true statement, but it lacks the specificity and clarity to ensure that the &#8220;all&#8221; who are in agreement are <em>truly</em> on the same page as to the goals and objectives for that investment. Collaboratively establishing KPIs and targets may require some uncomfortable and difficult discussions, but it&#8217;s a worthwhile exercise, because it forces the stakeholders to articulate and agree on <em>quantifiable measures of success</em>. For any of our client engagements, we spend time up front really nailing down what success looks like from a hard data perspective for this very reason. As a team begins to execute an initiative, being able to hold up a concise set of measures and targets helps everyone, regardless of their role, focus their efforts. And, of course, <strong>Alignment</strong> is a foundation for <strong>Performance Measurement</strong>.</p>
<h3>Performance Measurement</h3>
<p>The value of performance measurement is twofold:</p>
<ul>
<li>During the execution of an initiative, it clearly identifies whether the initiative is delivering the intended results or not. It separates the metrics <em>that matter</em> from the metrics that do not (or the metrics that may be needed for deeper analysis, but which are not direct measures of performance). It signifies both when changes <em>must</em> be made to fix a problem, and it complements <strong>Optimization </strong>efforts by being the judge as to whether a change is delivering improved results.</li>
<li><strong>Performance Measurement</strong> also quantifies the results and the degree to which an initiative added value to the business. It is a key tool in driving <strong>Internal Learning </strong>by answering the questions: &#8220;Did this work? Should we do something like this again? How well were we able to project the final results before we started the work?&#8221;</li>
</ul>
<p><strong>Performance Measurement</strong> is a foundational component of a solid analytics process, but it&#8217;s <strong>Optimization</strong> and <strong>Learning</strong> that really start to deliver incremental business value.</p>
<h3>Optimization</h3>
<p><strong>Optimization </strong>is all about continuous improvement (when things are going well) and addressing identified issues (when KPIs are not hitting their targets). Obviously, it is linked to <strong>Performance Measurement</strong>, as described above, but it&#8217;s an analytics value area unto itself. Optimization includes A/B and multivariate testing, certainly, but it also includes straight-up analysis of historical data. In the case of social media, where A/B testing is often not possible and historical data may not be sufficiently available, optimization can be driven by focused experimentation. This is a broad area indeed! But, while reporting squirrels can operate with at least some success when it comes to <strong>Performance Measurement</strong>, they will fail miserably when it comes to delivering <strong>Optimization</strong> value, as this is an area that requires curiousity, creativity, and rigor rather than rote report repetition. <strong>Optimization</strong> is a &#8220;during the on-going execution of the initiative&#8221; value area, which is quite different (but, again, related) to <strong>Internal Learning</strong>.</p>
<h3>Learning</h3>
<p>While <strong>Optimization</strong> is focused on tuning the<em> current </em>process, <strong>Internal Learning</strong> is about identifying truths (which may change over time), best practices, and, &#8220;For the love of Pete, let&#8217;s not make the mistake of doing <em>that</em> again!&#8221; tactics. It pulls together the value from all three of the other analytics value areas in a more deliberative, forward-looking fashion. This is why it sits at the nexxus of the other three areas in the diagram at the beginning of this post. While, on the one hand, <strong>Learning</strong> seems like a, &#8220;No, duh!&#8221; thing to do, it actually can be challenging to do effectively:</p>
<ul>
<li>Every initiative is different, so it can be tricky to tease out information that can be applied going forward from information that would only be useful if Doc Brown appeared with his Delorean</li>
<li>Capturing this sort of information is, ideally, managed through some sort of formal knowledge management process or program, and such programs are quite rare (consultancies excluded)</li>
<li>Even with a beautifully executed <strong>Performance Management</strong> process that demonstrates that an initiative had suboptimal results, it is still very tempting to start a subsequent initiative based on the skeleton of a previous one. Meaning, it can be very difficult to break the, &#8220;that&#8217;s how we&#8217;ve always done it&#8221; barrier to change (remember how long it took to get us to stop putting insanely long registration forms on our sites?)</li>
</ul>
<p>Despite these challenges, it is absolutely worth finding ways to ensure that ongoing learning is part of the analytics program:</p>
<ul>
<li>As part of the <strong>Performance Measurement</strong> post mortem for a project, formally ask (and document), what aspects, specifically, of the initiative&#8217;s results contain broader truths that can be carried forward.</li>
<li>As part of the <strong>Alignment</strong> exercise for any new initiative, consciously ask, &#8220;What have we done in the past that is relevant, and what did we learn that should be applied here?&#8221; (Ideally, this occurs simply by tapping into an exquisite knowledge management platform, but, in the real world, it requires reviewing the results of past projects and even reaching out and talking to people who were involved with those projects)</li>
<li>When <strong>Optimization</strong> work is successfully performed, do more than simply make the appropriate change for the current initiative &#8212; capture what change was made and why in a format that can be easily referenced in the future</li>
</ul>
<p>This is a tough area that is often assumed to be something that just automatically occurs. To a certain extent, it does, but only at an individual level: <em>I&#8217;m</em> going to learn from every project <em>I</em> work on, and <em>I</em> will apply that learning to subsequent projects that <em>I</em> work on. But, the experience of &#8220;I&#8221; has no value to the guy who sits 10&#8242; away if he is currently working on a project where my past experiences could be of use if he doesn&#8217;t: 1) know I&#8217;ve had those experiences, or 2) have a centralized mechanism or process for leveraging that knowledge.</p>
<h3>What Else?</h3>
<p>What do you say when someone asks you, &#8220;How does analytics add value?&#8221; Do you focus on one or more of the areas above, or do you approach the question from an entirely different perspective? I&#8217;d love to hear!</p>
<hr />
<p><small>&copy; Tim for <a href="http://www.gilliganondata.com">Gilligan on Data by Tim Wilson</a>, 2012. |
<a href="http://www.gilliganondata.com/index.php/2012/05/08/four-dimensions-of-value-from-measurement-and-analytics/">Permalink</a> |
<a href="http://www.gilliganondata.com/index.php/2012/05/08/four-dimensions-of-value-from-measurement-and-analytics/#comments">No comment</a> |
Add to
<a href="http://del.icio.us/post?url=http://www.gilliganondata.com/index.php/2012/05/08/four-dimensions-of-value-from-measurement-and-analytics/&amp;title=Four Dimensions of Value from Measurement and Analytics">del.icio.us</a>
<br/>
Post tags: <br/>
</small></p>
<p><small>Feed enhanced by <a href='http://planetozh.com/blog/my-projects/wordpress-plugin-better-feed-rss/'>Better Feed</a> from  <a href='http://planetozh.com/blog/'>Ozh</a></small></p>
<img src="http://feeds.feedburner.com/~r/GilliganOnData/~4/9a36Nf26GHs" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.gilliganondata.com/index.php/2012/05/08/four-dimensions-of-value-from-measurement-and-analytics/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.gilliganondata.com/index.php/2012/05/08/four-dimensions-of-value-from-measurement-and-analytics/</feedburner:origLink></item>
		<item>
		<title>10 Tips for Web Analytics Wednesday Awesomeness (and a Downloadable Checklist)</title>
		<link>http://feedproxy.google.com/~r/GilliganOnData/~3/0MiJhuQz5XQ/</link>
		<comments>http://www.gilliganondata.com/index.php/2012/05/01/10-tips-for-web-analytics-wednesday-awesomeness-and-a-downloadable-checklist/#comments</comments>
		<pubDate>Tue, 01 May 2012 11:00:53 +0000</pubDate>
		<dc:creator>Tim Wilson</dc:creator>
				<category><![CDATA[Web Analytics]]></category>
		<category><![CDATA[WAW Columbus]]></category>
		<category><![CDATA[web analytics wednesday]]></category>

		<guid isPermaLink="false">http://www.gilliganondata.com/?p=1830</guid>
		<description><![CDATA[I’ve become enamored with the “10 tips” format for organizing information (thank you, ACCELERATE), and I’ve had a couple of recent situations where people I know have asked for my advice on getting rolling with or successfully sustaining Web Analytics Wednesdays. A couple of years ago, someone actually tried to get …]]></description>
			<content:encoded><![CDATA[<p>I’ve become enamored with the “10 tips” format for organizing information (thank you, <a title="ACCELERATE" href="http://www.webanalyticsdemystified.com/accelerate/index.asp" target="_blank">ACCELERATE</a>), and I’ve had a couple of recent situations where people I know have asked for my advice on getting rolling with or successfully sustaining <a title="Web Analytics Wednesday" href="http://webanalyticsdemystified.com/wednesday" target="_blank">Web Analytics Wednesdays</a>. A couple of years ago, someone actually tried to get a group of WAW organizers around the world together to come up with a handy guide for WAW organizers, but, due to scheduling issues, that never came together. After a successful Columbus WAW last week (shown below), it seemed worthwhile to write up what I&#8217;ve learned about planning and running WAWs over the last four years.</p>
<p><a title="Columbus Web Analytics Wednesday - April 2012 by secondtree, on Flickr" href="http://www.flickr.com/photos/secondtree/6975454012/"><img class="aligncenter" src="http://farm9.staticflickr.com/8018/6975454012_0cb0bb7a2a.jpg" alt="Columbus Web Analytics Wednesday - April 2012" width="500" height="333" /></a></p>
<p>Some of these tips overlap with the <a title="Web Analytics Wednesday Frequently Asked Questions" href="http://www.webanalyticsdemystified.com/wednesday/waw_faq.asp" target="_blank">FAQ posted on the WAW site</a>, and I&#8217;ve also created a <a title="WAW Checklist" href="http://www.gilliganondata.com/files/WAW_checklist.xlsx">one-page Excel checklist</a> that covers the various details that go into our events to supplement this post.</p>
<p>And now, onto the tips!</p>
<h3>Tip No. 1: Start Small</h3>
<p>In Columbus, we now have a WAW almost every month, and we have between 40 and 60 attendees at each on . It took us several years to get to that level of consistent turnout, and that, in my mind, was a good thing. The core group that met over the first year or so got to know each other really well, as there were only 8-15 us at each event, and we could actually have group discussions in which everyone participated. Those early participants are still regularly attendees. People came consistently because they enjoyed the people, and they were patient with logistical hiccups and not-so-great venues. They provided feedback and made suggestions that helped us refine the what, the how, and the where of future events.</p>
<p>The other benefit of starting small is that you don’t have to worry about paying for the event – the <a title="Web Analytics Wednesday Global Sponsors" href="http://www.webanalyticsdemystified.com/wednesday/sponsors.asp" target="_blank">Web Analytics Wednesday Global Sponsors</a> are insanely easy to tap into to cover the cost (more on that in Tip No. 9).</p>
<h3>Tip No. 2: Location, Location, Location</h3>
<p>Location matters. In Columbus, this was something that took us over a year to really nail down, and I wasn’t much help, as I had only recently moved to the area. Some things to look for in a venue:</p>
<ul>
<li><strong>Centrally located</strong> – most cities have some degree of sprawl, so there is no location that is perfect for everyone; but, what we’ve found is that, the closer we can get the venue to the main business district, the better</li>
<li><strong>Separate meeting room</strong> – lots of restaurants have rooms that can be reserved for private parties; sometimes, they require a separate fee, but sometimes they just require a minimum total spend. All things are negotiable – you’re bringing business to them on a Wednesday night, so they are generally flexible.</li>
<li><strong>Low-to-moderate noise level</strong> – if the venue has a separate room, this is less of an issue; if it doesn’t, the noise level is key. WAWs are, first and foremost, about people meeting and talking to other people, and no one wants to be hoarse on Thursday morning. Live music and happenin&#8217; bar scenes are cool…but they don’t make for great WAWs</li>
<li><strong>Presentation-friendly</strong> – at a minimum, having a room that has a layout that is conducive to a projector and screen is important if there will be any presenting (see Tip No. 7); some venues have screens, and some actually have projectors. But, if the room layout isn’t such that it will support a projector and screen, then make sure you’ve thought through how visual information will be shared in the absence (tip: large companies typically have projectors that employees can check out for meetings – we regularly tap into attendees who work at such companies to actually provide the projectors). Handouts work, too.</li>
</ul>
<p>Nailing down a single good location is hard enough, but we actually now have 2-3 good locations. This allows us to mix things up so that the event doesn’t start to seem like it has fallen into a rut. And, it gives us options – if one venue is booked for the preferred WAW date, another one is likely to be open.</p>
<h3>Tip No. 3: Be Consistent</h3>
<p>The cadence of WAWs seems to matter. We aim for an event once per month and know that, occasionally, we won&#8217;t manage to have one. Having the events on a regular schedule adds credibility to the event overall (which helps with sponsors and attendees alike), and it really helps convert &#8220;networking acquaintances&#8221; into &#8220;professional friends.&#8221;</p>
<p>There is definitely a commitment required in order to follow this tip. From the get-go in Columbus, we had multiple co-organizers, and that group of organizers has grown. We split up the effort &#8212; one secured a venue each month, one person handled the emails to past attendees, another person handled finding new ways to promote the event &#8212; and have built a pretty solid and repeatable process.</p>
<p>It&#8217;s difficult to build momentum without a consistent and recurring schedule, so getting organized and making it a group effort is key (see Tip No. 10).</p>
<h3>Tip No. 4: Build a WAW Database</h3>
<p>From our first event onward, I started entering the name and email address of each person who registered for a Columbus WAW into a Google Spreadsheet (I now use <a title="ExactTarget" href="http://www.exacttarget.com" target="_blank">ExactTarget</a> for this). This requires a little bit of sleuthing, as the WAW registration form only collects an email address. But, 9 times out of 10, it&#8217;s pretty easy to figure out the person&#8217;s name (the internet being scary that way and all&#8230;) and company. This is a bit tedious, but it’s worth it, as it gives us an ever-growing “house list” to whom we can promote upcoming events.</p>
<p>We now have a sign-in sheet at every event to collect the name and email address of each attendee. To reduce the level of data entry and handwriting-deciphering required, I pre-print a list of all registrants for the sign-in sheet and just ask people to check a box next to their name to indicate they&#8217;ve arrived. That sheet has blank rows for people who registered late or didn&#8217;t register to write in their information.</p>
<h3>Tip No. 5: Invite and Remind</h3>
<p>Obviously, it’s not enough to just build and maintain a house list if it doesn’t get used. For every WAW, each person on that list gets sent at least two emails (but no more than three):</p>
<ul>
<li><strong>Notification / invitation</strong> – a couple of weeks out, we send an email to the entire list letting them know of the upcoming event</li>
<li><strong>Second invitation</strong> – for anyone who has not registered a week out, we send a second invitation; the content is very similar to the first one, but we generally mix up the subject line and the body copy a bit</li>
<li><strong>Reminder</strong> – for anyone who has registered, we send a reminder email 2-3 days before the event</li>
</ul>
<p>We try to consistently hit some key information with each email:</p>
<ul>
<li>The date and location for the event</li>
<li>Information as to the topic that will be presented (if we have a presentation)</li>
<li>A reminder that the event is free</li>
<li>A link to the event registration page on the WAW site</li>
</ul>
<p>We&#8217;ve even done some A/B testing on the subject lines, but, with a list that is only several hundred people, that’s more because it’s a good way to experiment with the process for A/B testing in ExactTarget than because we’ve been able to learn anything of note about effective subject lines for WAW emails.</p>
<p>And, while we haven&#8217;t always been 100% CAN-SPAM compliant, we&#8217;ve always been clear in all communications as to how the recipient could opt out of future emails, and we honor any opt out requests we receive.</p>
<h3>Tip No. 6: Multi-Channel Promotion</h3>
<p>In addition to email, we consistently push out notifications through as many channels as possible:</p>
<ul>
<li>Through the <a title="Columbus Web Analytics Wednesday on Facebook" href="https://www.facebook.com/groups/15680024669/" target="_blank">Facebook group we created for our WAW</a></li>
<li>Through the <a title="Columbus Web Analytics Wednesday on Linkedin" href="http://www.linkedin.com/groups/Columbus-Web-Analytics-Wednesday-1920388?gid=1920388&amp;mostPopular=&amp;trk=tyah" target="_blank">LinkedIn group we created for our WAW</a></li>
<li>Through Twitter (using the <a title="#measure" href="https://twitter.com/#!/search/%23measure" target="_blank">#measure</a> hashtag)</li>
<li>Through other local channels (in our case, there is a very active <a title="TechLife Columbus" href="http://www.meetup.com/techlifecolumbus/" target="_blank">tech-oriented community on meetup.com</a>)</li>
</ul>
<p>We don’t actively maintain any of these channels for any purpose other than notifications of upcoming events. That may not be a social media best practice, but it works, in that participants can opt in to non-email communication through whatever channel they prefer.</p>
<p>One thing we did learn was that we shouldn’t just sit down on one night and send out the email and simultaneously update every social media channel. This just meant that users who were connected through multiple means got spammed with the same information all at one point in time, which reduced its effectiveness (and was a little annoying). We now spread out the updates over the course of several days.</p>
<h3>Tip No. 7: Limited Formal Presentations / Plenty of Time for Networking</h3>
<p>We tell our presenters to aim for 15-20 minutes and to avoid presentations that are simply sales pitches for their companies. With brief presentations on relevant topics (sometimes the sponsor presents, sometimes it&#8217;s simply one of the organizers or an attendee who has volunteered a topic), we tend to spend another 15-30 minutes in Q&amp;A and discussion. The feedback we&#8217;ve consistently gotten is that attendees enjoy both the networking <em>and</em> having some formally presented content. So, we strive to keep a balance between the two. Two keys to that:</p>
<ul>
<li>Very clear (polite, but firm) communication to the presenters ahead of time as to expectations regarding presentation length</li>
<li>Having one of the organizers prepared to manage the clock &#8212; be it signaling the presenter to wrap up or announcing &#8220;let&#8217;s do one more question&#8221; if things run long and the crowd starts to squirm (some day, I&#8217;ll live down cutting off Chris Grant after she traveled all the way down from Michigan for our WAW&#8230;)</li>
</ul>
<p>The schedule we&#8217;ve followed for the past few years is:</p>
<ul>
<li>6:30 &#8211; 7:00 &#8212; sign-in and networking</li>
<li>7:00 &#8211; 7:10-ish &#8212; find seats, welcome and announcements</li>
<li>7:10 &#8211; 7:45-ish &#8212; presentation and Q&amp;A</li>
<li>7:45-ish &#8211; 8:30/9:00 &#8212; more networking</li>
</ul>
<p>I&#8217;ve got the word &#8220;networking&#8221; in the title of this tip and a couple of times in the listed schedule above, but, honestly, &#8220;hanging out&#8221; is probably a better description. Like-minded people with food and beer&#8230; it&#8217;s fun!</p>
<h3>Tip No. 8: Encourage Tweeting</h3>
<p>We encourage tweeting at our WAWs for all of the same reasons tweeting is encouraged at conferences:</p>
<ul>
<li>It publicizes the event and content out to the followers of the attendees</li>
<li>It fosters networking as people engage with each other during the presentation</li>
<li>It provides a nice way to have crowdsourced &#8220;notes&#8221; from the presentation</li>
</ul>
<p>To promote tweeting, we have started printing out little cards that we put at all of the tables that include:</p>
<ul>
<li>The Twitter usernames of the presenter(s)</li>
<li>The hashtag for the event (we use #cbuswaw)</li>
<li>The logos of our sponsors (<em>nothing</em> should get printed or emailed that doesn&#8217;t include a thank you to the sponsors)</li>
</ul>
<p>Even if there are only a small number of attendees, and even if there is no formal presentation, tweets can help spread the word.</p>
<h3>Tip No. 9: Free Drinks (and Food, if Possible)</h3>
<p>We&#8217;re reaching the end of this list, but that doesn&#8217;t mean these tips are any less important! Free drinks are a must! While no one attends a WAW simply because they are burdened with an empty bank account <em>and</em> a drinking problem, by offering booze, the overall vibe and purpose gets communicated as a &#8220;fun event&#8221; more than a &#8220;professional obligation.&#8221;</p>
<p>Providing free drinks can get expensive&#8230;but it&#8217;s worth the effort to make sure it happens. Sub-tips on that front:</p>
<ul>
<li>If you&#8217;re just getting started, and it&#8217;s a small event, tap into the <a title="Web Analytics Wednesday Global Sponsors" href="http://www.webanalyticsdemystified.com/wednesday/sponsors.asp" target="_blank">Web Analytics Wednesday Global Sponsors</a>. That&#8217;s what their sponsorship is there for!</li>
<li>Use drink tickets to manage the total outlay. I have yet to host an event at a bar or restaurant that doesn&#8217;t have drink tickets on hand for our use, and, by handing out 1-2 tickets (we usually do 2), you can ensure that your sponsors aren&#8217;t inadvertently funding a fraternity party</li>
<li>Seek out sponsors &#8212; the smaller the event, the smaller the ask; the larger the event, the more worthwhile it is for the sponsor. Use your and other attendees connections to the analytics vendors and services they use. Many of them have marketing funds available, and it&#8217;s a great way for them to make connections with prospective customers in their territory.</li>
</ul>
<p>We almost always provide food at our events as well. To manage costs on that front, we typically go with a &#8220;heavy appetizer buffet&#8221; rather than a full-on meal. We typically order food to cover 15-20% fewer people than we actually expect to attend. Otherwise, we wind up with crazy amounts of leftovers</p>
<h3>Tip No. 10: Ask for Help</h3>
<p>As I put together the <a title="WAW Checklist" href="http://www.gilliganondata.com/files/WAW_checklist.xlsx">checklist </a>to accompany this post, and as I wrote the post itself, I realized how many moving parts there are in our process. No single event will ever be perfect, and it doesn&#8217;t have to be. But, the more details that get consistently covered, the more likely the WAWs are to flourish and grow. The best way to cover those details is through organization and teamwork: ask for volunteers to help with future events at each of your events; pay attention to who seems to be most engaged and has useful ideas and suggestions for future events. Recruit!</p>
<h3>What&#8217;s Missing?</h3>
<p>The <a title="WAW Checklist" href="http://www.gilliganondata.com/files/WAW_checklist.xlsx">downloadable checklist </a>is intended as a companion to these tips, and it&#8217;s organized based on the different aspects of managing a WAW. I hope you find it useful.</p>
<p>What else have you seen &#8212; either when organizing or attending a WAW &#8212; that works particularly well? I&#8217;d love to get some comments that give us some ideas for continuing to improve our events!<strong>Similar Posts:</strong>
<ul class="similar-posts">
<li><a href="http://www.gilliganondata.com/index.php/2010/02/23/columbus-web-analytics-wednesday-feedback-analysis/" rel="bookmark" title="February 23, 2010">Columbus Web Analytics Wednesday &#8212; Feedback Analysis</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2008/03/14/old-school-online-community-leads-to-a-dozen-data-geeks-and-drinks/" rel="bookmark" title="March 14, 2008">Old School Online Community Leads to a Dozen Data Geeks and Drinks</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2009/04/25/columbus-web-analytics-wednesday-a-speedy-april/" rel="bookmark" title="April 25, 2009">Columbus Web Analytics Wednesday: A Speedy April</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2009/03/19/a-record-setting-web-analytics-wednesday-in-columbus/" rel="bookmark" title="March 19, 2009">A Record-Setting Web Analytics Wednesday in Columbus</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2010/03/29/columbus-web-analytics-wednesday-recap-dont-antisappoint-visitors/" rel="bookmark" title="March 29, 2010">Columbus Web Analytics Wednesday Recap: Don&#8217;t &#8220;Antisappoint&#8221; Visitors</a></li>
</ul>
<p><!-- Similar Posts took 34.715 ms --></p>
<hr />
<p><small>&copy; Tim for <a href="http://www.gilliganondata.com">Gilligan on Data by Tim Wilson</a>, 2012. |
<a href="http://www.gilliganondata.com/index.php/2012/05/01/10-tips-for-web-analytics-wednesday-awesomeness-and-a-downloadable-checklist/">Permalink</a> |
<a href="http://www.gilliganondata.com/index.php/2012/05/01/10-tips-for-web-analytics-wednesday-awesomeness-and-a-downloadable-checklist/#comments">3 comments</a> |
Add to
<a href="http://del.icio.us/post?url=http://www.gilliganondata.com/index.php/2012/05/01/10-tips-for-web-analytics-wednesday-awesomeness-and-a-downloadable-checklist/&amp;title=10 Tips for Web Analytics Wednesday Awesomeness (and a Downloadable Checklist)">del.icio.us</a>
<br/>
Post tags: <a href="http://www.gilliganondata.com/index.php/tag/waw-columbus/" rel="tag">WAW Columbus</a>, <a href="http://www.gilliganondata.com/index.php/tag/web-analytics-wednesday/" rel="tag">web analytics wednesday</a><br/>
</small></p>
<p><small>Feed enhanced by <a href='http://planetozh.com/blog/my-projects/wordpress-plugin-better-feed-rss/'>Better Feed</a> from  <a href='http://planetozh.com/blog/'>Ozh</a></small></p>
<img src="http://feeds.feedburner.com/~r/GilliganOnData/~4/0MiJhuQz5XQ" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.gilliganondata.com/index.php/2012/05/01/10-tips-for-web-analytics-wednesday-awesomeness-and-a-downloadable-checklist/feed/</wfw:commentRss>
		<slash:comments>3</slash:comments>
		<feedburner:origLink>http://www.gilliganondata.com/index.php/2012/05/01/10-tips-for-web-analytics-wednesday-awesomeness-and-a-downloadable-checklist/</feedburner:origLink></item>
		<item>
		<title>Digital Analytics: From Data to Stories and Communication</title>
		<link>http://feedproxy.google.com/~r/GilliganOnData/~3/lEIxeQiiKH8/</link>
		<comments>http://www.gilliganondata.com/index.php/2012/04/10/digital-analytics-from-data-to-stories-and-communication/#comments</comments>
		<pubDate>Tue, 10 Apr 2012 17:46:56 +0000</pubDate>
		<dc:creator>Tim Wilson</dc:creator>
				<category><![CDATA[Analysis]]></category>
		<category><![CDATA[Metrics]]></category>
		<category><![CDATA[Web Analytics]]></category>

		<guid isPermaLink="false">http://www.gilliganondata.com/?p=1821</guid>
		<description><![CDATA[This will be a quick little post as I try to pull together what seems to be an emerging theme in the digital analytics space. In a post late last year, I wrote: I haven’t attended a single conference in the last 18 months where one of the sub-themes of …]]></description>
			<content:encoded><![CDATA[<p>This will be a quick little post as I try to pull together what seems to be an emerging theme in the digital analytics space. In a <a title="Reflections on the Inaugural #ACCELERATE Conference" href="http://www.gilliganondata.com/index.php/2011/11/26/reflections-on-the-inaugural-accelerate-event/">post late last year</a>, I wrote:</p>
<blockquote><p>I haven’t attended a single conference in the last 18 months where one of the sub-themes of the conference wasn’t, “As analysts, we’ve got to get better at <em>telling stories</em> rather than simply <em>presenting data.</em>”</p></blockquote>
<p>Lately, though, it seems that the emphasis on &#8220;stories&#8221; has shifted to a more fundamental focus on &#8220;communication.&#8221; As evidence, I present the following:</p>
<h3>A 4-Part Blog Series</h3>
<p>Michele Kiss published a 4-part blog series over the course of last week titled &#8220;The Most Undervalued Analytics Tool: Communication.&#8221; The series covered <a title="The Most Undervalued Analytics Tool: Communication" href="http://www.michelekiss.com/2012/04/02/the-most-undervalued-analytics-tool-communication/?utm_source=gilliganondata&amp;utm_medium=external_blog&amp;utm_campaign=gilligan_be_so_awesome" target="_blank">communication within your analytics team</a>, <a title="The Most Undervalued Analytics Tool: Communication [Across Departments]" href="http://www.michelekiss.com/2012/04/03/the-most-undervalued-communication-tool-communication-across-depts/?utm_source=gilliganondata&amp;utm_medium=external_blog&amp;utm_campaign=gilligan_be_so_awesome" target="_blank">communication across departments</a>, <a title="The Most Undervalued Analytics Tool: Communication [with Executives &amp; Stakeholders]" href="http://www.michelekiss.com/2012/04/05/the-most-undervalued-analytics-tool-communication-w-exec-stakeholders/?utm_source=gilliganondata&amp;utm_medium=external_blog&amp;utm_campaign=gilligan_be_so_awesome" target="_blank">communication with executives and stakeholders</a>, and <a title="The Most Undervalued Analytics Tool: Communication [with Partners]" href="http://www.michelekiss.com/2012/04/06/the-most-undervalued-analytics-tool-communication-with-partners/?utm_source=gilliganondata&amp;utm_medium=external_blog&amp;utm_campaign=gilligan_be_so_awesome" target="_blank">communication with partners</a>. Whether intentionally or not, the series highlighted how varied and intricate the many facets of &#8220;communication&#8221; really are (and she makes some excellent tips for addressing those different facets!).</p>
<h3>A Data Scientist&#8217;s &#8220;Day to Day&#8221; Advice</h3>
<p><a title="Christopher Berry on Twitter" href="http://twitter.com/cjpberry" target="_blank">Christopher Berry</a>, VP of Marketing Science at <a title="Syncapse" href="http://syncapse.com/" target="_blank">Syncapse</a>, <em>also</em> <a title="Advice for those building out their own analytics team" href="http://christopher-berry.blogspot.com/2012/04/advice-for-those-building-out-their-own.html" target="_blank">published a post last week</a> that touched on the importance of communication. Paraphrasing (a bit), he advised:</p>
<ul>
<li>Recognize that you&#8217;re going to have to repeat yourself &#8212; not because the people your communicating with are stupid, but because they&#8217;re not as wired to the world of data as you are</li>
<li>Communicate to both the visual and auditory senses &#8212; different people learn better through different channels (and neuroscience has shown that ideas stick better when they&#8217;re received through multiple sensory registers)</li>
<li>Use bullet points (be concise)</li>
</ul>
<p>Christopher is one of those guys who could talk about the intricacies of shoe leather and have an audience spellbound&#8230;so his credibility on the communication front comes more from the fact that he&#8217;s a great communicator than from his position as a top brain in the world of data scientistry.</p>
<h3>Repetition at ACCELERATE</h3>
<p>During last Wednesday&#8217;s <a title="ACCELERATE" href="http://www.webanalyticsdemystified.com/accelerate/" target="_blank">ACCELERATE conference</a> in Chicago, I tweeted the following:</p>
<p><a title="Relationships and communication. A recurring theme here at #ACCELERATE (as it should be!)" href="https://twitter.com/#!/tgwilson/status/187621488474603520" target="_blank"><img class="aligncenter size-full wp-image-1823" title="ACCELERATE - Relationships and Communication" src="http://www.gilliganondata.com/wp-content/uploads/2012/04/accelerate_relationships.png" alt="" width="509" height="213" /></a></p>
<p>The tweet was mid-afternoon, and it was after a run of sessions &#8212; all very good &#8212; where the presenters directly spoke to the importance of communication when it come to a range of analytics responsibilities and challenges.</p>
<h3>A Chat with Jim Sterne</h3>
<p>At the Web Analytics Wednesday that followed the conference, I got my first chance (ever!) to have more than a 2-sentence conversation with <a title="Jim Sterne on Twitter" href="http://twitter.com/jimsterne" target="_blank">Jim Sterne</a> (I&#8217;m pretty sure the smile on his face all day was the smile of a man who was attending a conference as a mere attendee than as a <em>host and organizer</em>, and the plethora of attendant stresses of that role!).</p>
<p>During that discussion, Jim asked me the question, &#8220;What is it that you are doing now that is moving towards [where you want to be with your career].&#8221; We&#8217;ll leave the details of the bracketed part of my quote aside and focus on my answer, which I&#8217;d never really thought of in such explicit terms. My answer was that, being a digital analyst at an agency that was built over the course of 3 decades on a foundation of great design work and outstanding consumer research (as in: NOT on measurement and analytics), I <em>have</em> to keep honing my communication skills. In many, many ways I have a conversation <em>every day</em> where I am trying to communicate the same basics about digital analytics that I&#8217;ve been communicating for the past decade in different environments. But, I&#8217;m not just repeating myself. If I look back over my 2.5 years at the agency, I&#8217;ve added a new &#8220;tool&#8221; to my analytics communication toolbox every 2-3 months, be it a new diagram, a new analogy, a new picture, or a new anecdote. I&#8217;ve been working really hard (albeit not explicitly or even consciously) to become the most effective communicator I can be on the subject of digital analytics. Not every new tool sticks, and I try to discard them readily when I realize they&#8217;re not resonating.</p>
<p>It&#8217;s a work in progress. Are you consciously working on how you communicate as an analyst? What&#8217;s your best tip?</p>
<hr />
<p><small>&copy; Tim for <a href="http://www.gilliganondata.com">Gilligan on Data by Tim Wilson</a>, 2012. |
<a href="http://www.gilliganondata.com/index.php/2012/04/10/digital-analytics-from-data-to-stories-and-communication/">Permalink</a> |
<a href="http://www.gilliganondata.com/index.php/2012/04/10/digital-analytics-from-data-to-stories-and-communication/#comments">6 comments</a> |
Add to
<a href="http://del.icio.us/post?url=http://www.gilliganondata.com/index.php/2012/04/10/digital-analytics-from-data-to-stories-and-communication/&amp;title=Digital Analytics: From Data to Stories and Communication">del.icio.us</a>
<br/>
Post tags: <br/>
</small></p>
<p><small>Feed enhanced by <a href='http://planetozh.com/blog/my-projects/wordpress-plugin-better-feed-rss/'>Better Feed</a> from  <a href='http://planetozh.com/blog/'>Ozh</a></small></p>
<img src="http://feeds.feedburner.com/~r/GilliganOnData/~4/lEIxeQiiKH8" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.gilliganondata.com/index.php/2012/04/10/digital-analytics-from-data-to-stories-and-communication/feed/</wfw:commentRss>
		<slash:comments>6</slash:comments>
		<feedburner:origLink>http://www.gilliganondata.com/index.php/2012/04/10/digital-analytics-from-data-to-stories-and-communication/</feedburner:origLink></item>
		<item>
		<title>The Many Dimensions of Social Media Data</title>
		<link>http://feedproxy.google.com/~r/GilliganOnData/~3/C-h24mGT8Q0/</link>
		<comments>http://www.gilliganondata.com/index.php/2012/03/28/the-many-dimensions-of-social-media-data/#comments</comments>
		<pubDate>Wed, 28 Mar 2012 11:00:09 +0000</pubDate>
		<dc:creator>Tim Wilson</dc:creator>
				<category><![CDATA[Analysis]]></category>
		<category><![CDATA[Data Management]]></category>
		<category><![CDATA[Social Media]]></category>
		<category><![CDATA[Big Data]]></category>
		<category><![CDATA[Causata]]></category>
		<category><![CDATA[iJento]]></category>
		<category><![CDATA[Quantivo]]></category>
		<category><![CDATA[Watson]]></category>

		<guid isPermaLink="false">http://www.gilliganondata.com/?p=1808</guid>
		<description><![CDATA[I&#8217;ve been thinking a bit of late about the different aspects of social media data. This was triggered by a few different things: Paul Phillips of Causata spoke at eMetrics in San Francisco, and his talk was about leveraging data from customer touchpoints across multiple channels to provide better customer …]]></description>
			<content:encoded><![CDATA[<p>I&#8217;ve been thinking a bit of late about the different aspects of social media data. This was triggered by a few different things:</p>
<ul>
<li>Paul Phillips of <a title="Causata" href="http://www.causata.com" target="_blank">Causata</a> spoke at eMetrics in San Francisco, and his talk was about leveraging data from customer touchpoints across multiple channels to provide better customer relationship management</li>
<li>I&#8217;ve been re-reading John Lovett&#8217;s <a title="Social Media Metrics Secrets" href="http://www.amazon.com/gp/product/0470936274/ref=as_li_ss_tl?ie=UTF8&amp;tag=gillondata-20&amp;linkCode=as2&amp;camp=217145&amp;creative=399373&amp;creativeASIN=0470936274" target="_blank">Social Media Metrics Secrets</a> book as part of an internal book group at Resource Interactive</li>
<li>We&#8217;ve had clients approaching us with some new and unique questions related to their social media efforts</li>
</ul>
<p>What&#8217;s become clear is that &#8220;social media analytics&#8221; is a broad and deep topic, and discussions quickly run amok when there isn&#8217;t some clarity as to which <em>aspect</em> of social media analytics is being explored.</p>
<p>As I see it, there are four broad buckets of ways that social media data can be put to use by companies:</p>
<p><img class="aligncenter size-full wp-image-1815" title="Social Media Data Uses" src="http://www.gilliganondata.com/wp-content/uploads/2012/03/socialmediadatauses.png" alt="" width="483" height="493" /></p>
<p>No company that is remotely serious about social media in 2012 can afford to ignore the top two boxes. The bottom two are much more complex and, therefore, require a substantial investment, both in people and technology.</p>
<p>Now, I could stop here and actually have a succinct post. But, why break a near-perfect (or consistently imperfect) streak? Let&#8217;s take a slightly deeper look at each bucket.</p>
<h3>Operational Execution</h3>
<p>(I <em>almost</em> labeled this bucket &#8220;Community Management,&#8221; but the variety of viewpoints in the industry on the scope of that role convinced me to leave that can of worms happily sealed for the purposes of this post.)</p>
<p>Social media requires a <em>much</em> more constant intake and rapid response/action based on data than web sites typically do. Having the appropriate tools, processes, and people in place to respond to conversations with appropriate (minimal) latency is key.</p>
<p>Key challenges to effectively managing this aspect of social media data include: determining a reasonable scope, being realistic about the available on-going <em>people</em> who will manage the process, and, to a lesser extent, selecting the appropriate set of tools. Tool selection is challenging because this is the area where the majority of social media platforms are choosing to play &#8212; from online listening platforms like <a title="Radian6" href="http://www.radian6.com" target="_blank">Radian6</a>, <a title="Sysomos" href="http://www.sysomos.com" target="_blank">Sysomos</a>, <a href="http://www.alterian.com/socialmedia" target="_blank">Alterian</a>, and <a title="Syncapse" href="http://www.syncapse.com" target="_blank">Syncapse</a>; to &#8220;social relationship management&#8221; platforms like <a title="Vitrue" href="http://www.vitrue.com" target="_blank">Vitrue</a>, <a title="Buddy Media" href="http://www.buddymedia.com" target="_blank">Buddy Media</a>, <a title="Wildfire" href="http://www.wildfireapp.com/" target="_blank">Wildfire</a>, <a title="Adobe Context Optional" href="http://www.contextoptional.com/" target="_blank">(Adobe) Context Optional</a>, and <a title="Shoutlet" href="http://www.shoutlet.com" target="_blank">Shoutlet</a>; and even to the low-cost platforms such as <a title="Hootsuite" href="http://www.hootsuite.com" target="_blank">Hootsuite</a> and <a title="TweetDeck" href="http://www.tweetdeck.com" target="_blank">TweetDeck</a>. These platforms have a range of capabilities, and their pricing models vary dramatically.</p>
<h3>Performance Measurement</h3>
<p>Ahhh, performance measurement. When it comes to social media, it definitely falls in the &#8220;simple, but not easy&#8221; bucket. And, it&#8217;s an area where marketers are perpetually dissatisfied when they discover that there is no &#8220;value of a fan&#8221; formula, nor is there &#8220;the ROI of a tweet.&#8221; But, any marketer who has the patience to step back and consider where social media plays in his/her business can <em>absolutely</em> do effect performance measurement and report on meaningful business results!</p>
<p>Chapters 4 and 5 of John Lovett&#8217;s book, <a title="Social Media Metrics Secrets" href="http://www.amazon.com/gp/product/0470936274/ref=as_li_ss_tl?ie=UTF8&amp;tag=gillondata-20&amp;linkCode=as2&amp;camp=217145&amp;creative=399373&amp;creativeASIN=0470936274" target="_blank">Social Media Metrics Secrets</a>, get to the heart of social media performance measurement by laying out possible social media objectives and appropriate KPIs therein. High on my list is to make it through Olivier Blanchard&#8217;s <a href="http://www.amazon.com/gp/product/0789747413/ref=as_li_ss_tl?ie=UTF8&amp;tag=gillondata-20&amp;linkCode=as2&amp;camp=1789&amp;creative=390957&amp;creativeASIN=0789747413">Social Media ROI: Managing and Measuring Social Media Efforts in Your Organization</a>, as I&#8217;m confident that his book is equally full of usable gems when it comes to quantifying the business value delivered from social media initiatives.</p>
<p>When it comes to technologies for social media performance measurement, we generally find ourselves stuck trying to make use of the Operational Execution platforms. They all tout their &#8220;powerful analytics,&#8221; but their product roadmaps have typically been driven more by &#8220;listenting&#8221; and &#8220;publishing&#8221; features than they have been driven by &#8220;metrics&#8221; capabilities. With Google&#8217;s recent announcement of<a title="Google Analytics Social Value" href="http://analytics.blogspot.com/2012/03/capturing-value-of-social-media-using.html" target="_blank">Google Analytics Social Reports</a>, and with Adobe&#8217;s recent announcement of <a title="Adobe Social Press Release" href="http://www.adobe.com/aboutadobe/pressroom/pressreleases/201203/032112AdobeSimplifiesSocialMarketing.html" target="_blank">Adobe Social</a>, this may be starting to change.</p>
<h3>(Social-Enhanced) CRM</h3>
<p>Leveraging social media data to improve customer relationship management is something that there has been lots of talk about&#8230;but that very few companies have successfully implemented. At its most intriguing, this means companies identifying &#8212; through explicit user permission or through mining the social web &#8212; which Twitter users, Facebook fans, Pinterest users, Google+ users, and so on can be linked to their internal systems. Then, by listening to the public conversations of those users and combining that information with internally-captured transactional data (online purchases, in-store purchases, loyalty program membership, email clickthroughs, etc.), getting a much more comprehensive view of their customers and prospects. That &#8220;more comprehensive view,&#8221; in theory, can be used to build much more robust predictive models that can let the brand know how, when, and with what content to engage individual customers to maximize the value of that relationship for the brand.</p>
<p>The challenges are twofold:</p>
<ul>
<li><strong>Consumer privacy concerns</strong> &#8212; even if a brand doesn&#8217;t do anything illegal, consumers and the press have a tendency to get alarmed when they realize how non-anonymous their relationship with the brand is (as <a title="How Target Figured Out A Teen Girl Was Pregnant Before Her Father Did" href="http://www.forbes.com/sites/kashmirhill/2012/02/16/how-target-figured-out-a-teen-girl-was-pregnant-before-her-father-did/" target="_blank">Target learned</a>&#8230;and they weren&#8217;t even using social media data!)</li>
<li><strong>Complexity and cost</strong> &#8212; there is a grave tendency for marketers to confuse &#8220;freely available data&#8221; with &#8220;data that costs very little to gather and put to good use.&#8221; Companies&#8217; customer data is data they have collected through controllable interactions with consumers &#8212; through a form they filled out on the web, through a credit card being run as part of a purchase, through a call into the service center, etc. Data that is pulled from social media platforms is at the whim of the platforms and the whim of the consumer who set up the account. No company (except Twitter) can go out to a Twitter account and, in an automated fashion, bring back the user&#8217;s email address, real name, gender, or even country of residence. It takes much more sophisticated data crawling, combined with probabilistic matching engines, to get this data.</li>
</ul>
<p>Despite these challenges, this is an exciting opportunity for brands. And, the technology platforms are starting to emerge, with the three that spring the most quickly to my mind being <a title="Causata" href="http://www.causata.com" target="_blank">Causata</a>, <a title="iJento" href="http://www.ijento.com" target="_blank">iJento</a>, and <a title="Quantivo" href="http://www.quantivo.com" target="_blank">Quantivo</a>.</p>
<h3>Trend / Opportunity Prediction</h3>
<p>This is another area that is really tough to pull off, but it&#8217;s an area that, admittedly, has great potential. It&#8217;s a &#8220;Big Data&#8221; play if ever there was one &#8212; along the lines of how the Department of Homeland Security supposedly harnesses the data in millions of communications streams to identify terrorist hot spots. It&#8217;s sifting through a haystack and not knowing whether your&#8217;re looking for a needle, a twig, a small piece of wire, or a paperclip, but knowing that, if you find any of them, you&#8217;ll be able to put it to good use.</p>
<p>The wistfully optimistic marketing strategist describes this area something like this: &#8220;I want to pick up on patterns and trends in the psychographic and attitudinal profile of my target consumers that emerge in a way that I can reasonably shift my activities. I want an &#8216;alert&#8217; that tells me, &#8216;There&#8217;s something of interest here!&#8217;&#8221;</p>
<p>It&#8217;s a damn vague dream&#8230;but that doesn&#8217;t mean it&#8217;s unrealistic. It&#8217;s a multi-faceted challenge, though, because it requires the convergence of some rather sticky wickets:</p>
<ul>
<li>Identifying conversations that are occurring <em>amongst people who meet the profile of a brand&#8217;s target consumers</em> (demographic, psychographic, or otherwise) &#8212; yet, social media profiles don&#8217;t come with a publicly available list of the user&#8217;s attitudes, beliefs, purchasing behavior, age, family income, educational level, etc.</li>
<li>Identifying topics within those conversations that <em>might be relevant</em> for the brand &#8212; we&#8217;re talking well beyond &#8220;they&#8217;re talking about what the brand sells&#8221; and are looking for content with a much, much fuzzier topical definition</li>
<li>Identifying a <em>change</em> in these topics &#8212; generally, what marketers want most is to pick up on an <em>emerging trend</em> rather than simply a long-held truism</li>
</ul>
<p>To pull this off will require a significant investment in technology and infrastructure, a significant investment in a team of people with specialized skills, and a <em>significant amount of patience</em>. I chuckle every time I hear an anecdote about how a brand managed to pick up on some unexpected opportunity in real time and then quickly respond&#8230;without a recognition that the brand was spending an awful lot of time listening in real-time and picking up nothing of note!</p>
<p>This area, I think, is what a lot of the current buzz around Big Data is focused on. I&#8217;m hoping there are enough companies investing in trying to pull it off that we get there in the next few years, because it will be pretty damn cool. Maybe IBM can set <a title="IBM's Watson" href="http://www-03.ibm.com/innovation/us/watson/index.html" target="_blank">Watson</a> up with a <a title="Digital Marketing Optimization from IBM" href="http://www-142.ibm.com/software/products/us/en/category/SWX40" target="_blank">Digital Marketing Optimization Suite</a> login and see what he can do!</p>
<hr />
<p><small>&copy; Tim for <a href="http://www.gilliganondata.com">Gilligan on Data by Tim Wilson</a>, 2012. |
<a href="http://www.gilliganondata.com/index.php/2012/03/28/the-many-dimensions-of-social-media-data/">Permalink</a> |
<a href="http://www.gilliganondata.com/index.php/2012/03/28/the-many-dimensions-of-social-media-data/#comments">No comment</a> |
Add to
<a href="http://del.icio.us/post?url=http://www.gilliganondata.com/index.php/2012/03/28/the-many-dimensions-of-social-media-data/&amp;title=The Many Dimensions of Social Media Data">del.icio.us</a>
<br/>
Post tags: <a href="http://www.gilliganondata.com/index.php/tag/big-data/" rel="tag">Big Data</a>, <a href="http://www.gilliganondata.com/index.php/tag/causata/" rel="tag">Causata</a>, <a href="http://www.gilliganondata.com/index.php/tag/ijento/" rel="tag">iJento</a>, <a href="http://www.gilliganondata.com/index.php/tag/quantivo/" rel="tag">Quantivo</a>, <a href="http://www.gilliganondata.com/index.php/tag/watson/" rel="tag">Watson</a><br/>
</small></p>
<p><small>Feed enhanced by <a href='http://planetozh.com/blog/my-projects/wordpress-plugin-better-feed-rss/'>Better Feed</a> from  <a href='http://planetozh.com/blog/'>Ozh</a></small></p>
<img src="http://feeds.feedburner.com/~r/GilliganOnData/~4/C-h24mGT8Q0" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.gilliganondata.com/index.php/2012/03/28/the-many-dimensions-of-social-media-data/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.gilliganondata.com/index.php/2012/03/28/the-many-dimensions-of-social-media-data/</feedburner:origLink></item>
		<item>
		<title>The Three-Legged Stool of Effective Analytics: Plan, Measure, Analyze</title>
		<link>http://feedproxy.google.com/~r/GilliganOnData/~3/OvfMfjskY-g/</link>
		<comments>http://www.gilliganondata.com/index.php/2012/02/22/the-three-legged-stool-of-effective-analytics-plan-measure-analyze/#comments</comments>
		<pubDate>Wed, 22 Feb 2012 11:00:16 +0000</pubDate>
		<dc:creator>Tim Wilson</dc:creator>
				<category><![CDATA[Analysis]]></category>
		<category><![CDATA[Metrics]]></category>

		<guid isPermaLink="false">http://www.gilliganondata.com/?p=1790</guid>
		<description><![CDATA[Several weeks ago, Stéphane Hamel wrote a post that got me all re-smitten with his thought process. In the post, he postulated that there are three heads of online analytics. He covered three different skillsets needed to effectively conduct online analytics: business acumen, technical (tools) knowledge, and analysis. And, he made …]]></description>
			<content:encoded><![CDATA[<p>Several weeks ago, Stéphane Hamel wrote a post that got me all re-smitten with his thought process. In the post, he postulated that there are<a title="The Three Heads of Online Analytics" href="http://online-behavior.com/analytics/business-technology-analysis" target="_blank"> three heads of online analytics</a>. He covered three different skillsets needed to effectively conduct online analytics: business acumen, technical (tools) knowledge, and analysis. And, he made the claim that no one person will ever excel at all three, which led to his case for building out teams of &#8220;analysts&#8221; who have complementary strengths.</p>
<p>I&#8217;ve had several unrelated experiences with different clients and internal teams of late that have led me to try to capture, in a similar fashion, the three-legged <em><strong>stool</strong></em> of an online analytics <em><strong>program</strong></em>. Just as others have started tacking on additional components to Stéphane&#8217;s three skillsets, I&#8217;m sure my three-legged stool will quickly become a traditional chair&#8230;then some sort of <a title="Six-legged chair" href="http://freshbump.com/attitude-chair-by-deger-cengiz/" target="_blank">six-legged oddity</a>. But, I&#8217;d be thrilled if I could consistently communicate the basics to my non-analyst co-workers and clients:</p>
<p><img class="aligncenter size-full wp-image-1792" title="Plan, Measure/Report, and Test/Analyze" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/planmeasureanalyze1.png" alt="" width="499" height="468" /></p>
<p>I hold to a pretty strict distinction between &#8220;measurement and reporting&#8221; and &#8220;analysis,&#8221; and I firmly believe there <em>is</em> value in &#8220;reporting,&#8221; as long as that reporting is appropriately set up and applied.</p>
<p>Just as I believe that reporting <em>should</em> generally occur either as a one-time event (campaign wrap-up, for instance) or at regular intervals, I firmly believe that testing and analysis should <em>not</em> be forced into a recurring schedule. It&#8217;s fine (desirable) to be <em>always</em> conducting analysis, but the world of &#8220;present the results of your analysis &#8212; and your insights and recommendations therein &#8212; once/month on the first Wednesday of the month&#8221; is utterly asinine. Yet&#8230;it&#8217;s a mindset with which a depressing majority of companies operate.</p>
<h3>Reporting Done Poorly&#8230;Which Is an Unfortunately Ubiquitous Habit</h3>
<p>I&#8217;ve been client side. I&#8217;ve been agency side. I&#8217;ve done a decent amount of reading on human nature as it relates to organizational change. My sad conclusion:</p>
<p style="text-align: center;"><strong>The business world has conditioned itself to confuse &#8220;cumbersome decks of data&#8221; with &#8220;reporting done well.&#8221;</strong></p>
<p>It happens again and again. And again. And&#8230;again! It goes like this:</p>
<ol>
<li>Someone asks for some data in a report</li>
<li>Someone else pulls the data</li>
<li>The data raises some additional questions, so the first person asks for more data.</li>
<li>The analyst pulls more data</li>
<li>The initial requestor finds this data useful, so he/she requests that the same data be pulled on a recurring schedule</li>
<li>The analyst starts pulling and compiling the data on a regular schedule</li>
<li>The requestor starts sharing the report with colleagues. The colleagues see that the report certainly <em>should</em> be useful, but they&#8217;re not quite sure that it&#8217;s telling them anything they can act on. They assume that it&#8217;s because there is not enough data, so they ask the analyst to add in yet <em>more</em> data to the report</li>
<li>The report begins to grow.</li>
<li>The recipients now have a very large report to flip through, and, frankly, they don&#8217;t have time month in and month out to go through it. They assume their colleagues are, though, so they keep their mouths shut so as to not advertise that the report isn&#8217;t actually helping them make decisions. Occasionally, they leaf through it until they see <em>something</em> that spikes or dips, and they casually comment on it. It shows that they&#8217;re reading the report!</li>
<li>No one tells the analyst that the report has grown too cumbersome, because they all assume that the report <em>must</em> be driving action somewhere. After all, it takes two weeks of every month to produce, and no one else is speaking up that it is too much to manage or act on!</li>
<li>The analyst (now a team of analysts) and the recipients gradually move on to other jobs at other companies. At this point, they&#8217;re conditioned that part of their job is to produce or receive cumbersome piles of data on a regular basis. Over time, it actually seems odd to <em>not</em> be receiving a large report. So, if someone steps up and asks the naked emperor question: &#8220;How are you using this report to actually make decisions and drive the business?&#8221;&#8230;well&#8230;that&#8217;s a threatening question indeed!</li>
</ol>
<p>In the services industry, there is the concept of a &#8220;facilitated good.&#8221; If you&#8217;re selling brainpower and thought, the theory goes, and you&#8217;re billing out smart people at a hefty rate, then you damn well better leave behind a thick binder of <em>something</em> to demonstrate that all of that knowledge and consultation was more than mere ephemera!</p>
<p>And, on the client side, if the last 6 consultancies and agencies that you worked with all diligently delivered 40-slide PowerPoint decks or 80-page reports, then, by golly, you&#8217;re going to look askance at the consultant who shows up and aims for actionable concision!</p>
<p>Nonetheless, I will continue my quixotic quest to bring sanity to the world. So, onto the three legs of my analytics stool&#8230;</p>
<h3>First, Plan (Dammit!!!)</h3>
<p>Get a room full of experienced analysts together and ask them where any good analytics program or initiative starts, and you&#8217;ll get a unanimous response that it starts: 1) at the beginning of the initiative, and 2) with some form of rigorous planning.</p>
<p>The most critical question to answer during analytics planning is: &#8220;How are we going to know if we&#8217;re successful?&#8221; Of course, you can&#8217;t answer that question if you haven&#8217;t also answered the question: &#8220;What are we trying to accomplish?&#8221; Those are the two questions that I wrote about in this <a title="Pocket Guide to Identifying Great KPIs" href="http://www.gilliganondata.com/index.php/2011/02/09/pocket-guide-to-identifying-great-kpis/" target="_blank">Getting to Great KPIs</a> post.</p>
<p><img class="aligncenter size-full wp-image-1797" title="Step 1: Plan" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/report_analysis_step1.png" alt="" width="494" height="196" /></p>
<p>Of course, there are other components of analytics planning:</p>
<ul>
<li>Where will the data come from that we&#8217;ll use?</li>
<li>What other metrics &#8212; beyond the KPIs &#8212; will we need to capture?</li>
<li>What additional data considerations need to be factored into the effort to ensure that we are positioned for effective analysis and optimization down the road?</li>
<li>What (if any) special tagging, tracking, or monitoring do we need to put into place (and who/how will that happen)?</li>
<li>What are the known limitations of the data?</li>
<li>What are our assumptions about the effort?</li>
<li>&#8230;and more</li>
</ul>
<p>In my experience both agency-side and client-side, this step regularly gets skipped like it&#8217;s a smooth round, rock in the hand of an adolescent male standing on the shore of a lake on a windless day.</p>
<p>An offshoot of the planning is the actual tagging/tracking/monitoring configuration&#8230;but I consider that an extension of the planning, as it may or may not be required, depending on the nature of the initiative.</p>
<h3>Next, Measure and Report</h3>
<p>Yup. Measurement&#8217;s important. That&#8217;s how you know if you&#8217;re performing at, above, or below your KPIs:</p>
<p><img class="aligncenter size-medium wp-image-1798" title="Step 2: Measure and Report" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/report_analysis_step2-500x361.png" alt="" width="500" height="361" /></p>
<p>Here&#8217;s where I start to get into debates, both inside the analytics industry and outside. I strongly believe that it is <strong>perfectly acceptable</strong> to deliver reports without accompanying insights and analysis. Ideally, reports are automated. If they&#8217;re not automated, they&#8217;re produced damn quickly and efficiently.</p>
<p>Dashboards &#8212; the most popular form of reports &#8212; have a pretty simple purpose: provide an at-a-glance view of what has happened since the last update, and ensure that, <em>at a glance</em>, any anomalies jump out. More often than not, there <em>won&#8217;t</em> be anomalies, so there is nothing that needs to be analyzed based on the report! That&#8217;s okay!</p>
<p>I was discussing this concept with a co-worker recently, and, in response to my claim that reports should simply get delivered with minimal latency and, at best, a note that says, &#8220;Hey, I noticed this apparent anomaly that might be important. I&#8217;m going to look into it, but if you (recipient) have any ideas as to what might be going on, I&#8217;d love to get your thoughts,&#8221; she responded:</p>
<blockquote><p>I think this makes sense, but wouldn&#8217;t we provide some analysis as to the &#8220;why&#8221; on the monthly reports?</p></blockquote>
<p>I immediately went to the &#8220;dashboard in your car&#8221; analogy (I know &#8212; it breaks down on a lot of fronts, but it works here) with my response:</p>
<blockquote><p>You don’t look at your fuel gauge when you get in the car every day and ask, “Why is the needle pointing where it is?” You take a quick look, make sure it’s not pegged on empty, and then go about your day.</p></blockquote>
<p>That&#8217;s measurement. It <em>may</em> spawn analysis, but, often, it does not. And that&#8217;s to be expected!</p>
<h3>Which Brings Us to Testing and Analysis</h3>
<p>Analysis requires (or, at least, is much more likely to yield value in an efficient manner) having conducted some solid planning and having KPI-centric measurement in place. But, the timing of analysis shouldn&#8217;t be forced into a fixed schedule.</p>
<p><img class="aligncenter size-medium wp-image-1799" title="Step 3: Test/Analyze, Learn, and Improve" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/report_analysis_step3-500x450.png" alt="" width="500" height="450" /></p>
<p>The bottom part of the figure above gets to the crux of the biscuit when it comes to timing: sometimes, the best way to answer a business question is through analyzing historical data. Sometimes, the best way to answer a question is through go-forward testing. Sometimes, it&#8217;s a combination of the two (develop a theory based on the historical data, but then test it by making a change in the future and monitoring the results). Sometimes the analysis can be conducted very quickly. Other times, the analysis requires a large chunk of analyst time and may take days or weeks to complete.</p>
<p>Facilitating the collaboration with the various stakeholders, managing the analysis projects (multiple analyses in flight at once &#8212; starting and concluding asynchronously based on each effort&#8217;s unique nature), can absolutely fall under the purview of the analyst (again referencing <a title="The Three Heads of Online Analytics" href="http://online-behavior.com/analytics/business-technology-analysis" target="_blank">Stéphane&#8217;s post</a>, this should be an analyst with a strong &#8220;head&#8221; for business acumen).</p>
<h3>In Conclusion&#8230;(I promise!)</h3>
<p>There is a fundamental flaw in any approach to using data that attempts to bundle scheduled reporting with analysis. It forces efforts to find &#8220;actionable insights&#8221; in a context where there may very well be none. And, it perpetuates an assumption that it&#8217;s simply a matter of pointing an analyst at data and waiting for him/her to find insights and make recommendations.</p>
<p>I&#8217;ve certainly run into business users who flee from any effort to engage directly when it comes to analytics. They hide behind their inboxes lobbing notes like, &#8220;You&#8217;re the analyst. YOU tell me what my business problem is and make recommendations from your analysis!&#8221; I&#8217;m sure some of these users had one too many (and <em>one</em> is &#8220;too many&#8221;) interactions with an analyst who wanted to explain the difference between a page view and a visit, or who wanted to collaboratively sift through a 50-page deck of charts and tables. That&#8217;s not good, and that analyst should be flogged (unless he/she is less than two years out of college and can claim to have not known any better). But, <a title="The Myth of the &quot;Data-Driven&quot; Business" href="http://blog.webanalyticsdemystified.com/weblog/2011/09/the-myth-of-the-data-driven-business.html" target="_blank">using data to effectively inform decisions</a> is a collaborative effort. It needs to start early (planning), it needs to have clear, concise performance measurement (KPI-driven dashboards), and it needs to have flexibility to drive the timing and approach of analyses that deliver meaningful results.</p>
<hr />
<p><small>&copy; Tim for <a href="http://www.gilliganondata.com">Gilligan on Data by Tim Wilson</a>, 2012. |
<a href="http://www.gilliganondata.com/index.php/2012/02/22/the-three-legged-stool-of-effective-analytics-plan-measure-analyze/">Permalink</a> |
<a href="http://www.gilliganondata.com/index.php/2012/02/22/the-three-legged-stool-of-effective-analytics-plan-measure-analyze/#comments">One comment</a> |
Add to
<a href="http://del.icio.us/post?url=http://www.gilliganondata.com/index.php/2012/02/22/the-three-legged-stool-of-effective-analytics-plan-measure-analyze/&amp;title=The Three-Legged Stool of Effective Analytics: Plan, Measure, Analyze">del.icio.us</a>
<br/>
Post tags: <br/>
</small></p>
<p><small>Feed enhanced by <a href='http://planetozh.com/blog/my-projects/wordpress-plugin-better-feed-rss/'>Better Feed</a> from  <a href='http://planetozh.com/blog/'>Ozh</a></small></p>
<img src="http://feeds.feedburner.com/~r/GilliganOnData/~4/OvfMfjskY-g" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.gilliganondata.com/index.php/2012/02/22/the-three-legged-stool-of-effective-analytics-plan-measure-analyze/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://www.gilliganondata.com/index.php/2012/02/22/the-three-legged-stool-of-effective-analytics-plan-measure-analyze/</feedburner:origLink></item>
		<item>
		<title>Facebook Status Updates: Exploring Optimal Time of Day/Day of Week</title>
		<link>http://feedproxy.google.com/~r/GilliganOnData/~3/ap55ERxRnHA/</link>
		<comments>http://www.gilliganondata.com/index.php/2012/02/14/facebook-status-updates-exploring-optimal-time-of-dayday-of-week/#comments</comments>
		<pubDate>Tue, 14 Feb 2012 11:00:36 +0000</pubDate>
		<dc:creator>Tim Wilson</dc:creator>
				<category><![CDATA[Excel]]></category>
		<category><![CDATA[Facebook Insights]]></category>

		<guid isPermaLink="false">http://www.gilliganondata.com/?p=1776</guid>
		<description><![CDATA[Although Facebook has unofficially admitted that there seems to be little rhyme or reason these days when it comes to the time of day or day of week when a brand posts content on their page, it&#8217;s still worth doing a quick analysis to see if this is, indeed, the …]]></description>
			<content:encoded><![CDATA[<p>Although Facebook has unofficially admitted that there seems to be little rhyme or reason these days when it comes to the time of day or day of week when a brand posts content on their page, it&#8217;s still worth doing a quick analysis to see if this is, indeed, the case for your page.</p>
<p>The challenge, it turns out, is that there are multiple aspects of what sounds like a pretty straightforward assessment:</p>
<ul>
<li>What metric(s) actually make for a &#8220;successful&#8221; post?</li>
<li>How do you effectively consider time of day <em>and</em> day of week?</li>
<li>Have you actually posted on a sufficient variety of dates and times to have the data to do a meaningful analysis?</li>
</ul>
<p>After scraping together some hasty cuts at this, I thought it would be worthwhile to try to knock out something that was easily shareable and reusable. The result is the downloadable spreadsheet at the end of this post.</p>
<h3>What It Looks Like</h3>
<p>The spreadsheet takes a simple export of post-level data from Facebook Insights (the .csv format) and generates three basic charts.</p>
<p>The first chart simply shows the number of posts in each time slot and each day of week &#8212; this answers the question of, &#8220;What spots have I not even really <em>tried</em> posting in?&#8221;</p>
<p><img class="aligncenter size-full wp-image-1782" title="Facebook Posts -- Post Count by Time of Day and Day of Week" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/FB_Post_PostCount.png" alt="" width="455" height="184" /></p>
<p>In this example, there have not been any posts from 9:00 PM to 6:00 AM, only one post between 6:00 AM and 9:00 AM, and only four posts on a Friday. Don&#8217;t worry if you don&#8217;t like the time windows &#8212; we&#8217;ll get to that in a bit.</p>
<p>The next two charts are crude heatmaps of a couple of metrics, but they both use the same grid as above, and they use a pretty simple green-to-red spectrum to show which spots performed best/worst relative to the other slots:</p>
<p><img class="aligncenter size-full wp-image-1781" title="Facebook Post Assessment - Legend" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/FB_Post_Legend.png" alt="" width="415" height="13" /></p>
<p>(I know, I know: red/green is not a <a title="Data Visualization that Is Colorblind-Friendly — Excel 2007?" href="http://www.gilliganondata.com/index.php/2009/06/18/data-visualization-that-is-color-blind-friendly-excel-2007/" target="_blank">colorblind-friendly palette selection</a>. I&#8217;ll keep working on the visualization technique!)</p>
<p>The first of these charts looks at the average <em>total reach</em> of the updates that were posted in each time slot &#8212; the number of unique users of Facebook who were exposed to the post:</p>
<p><img class="aligncenter size-full wp-image-1779" title="Facebook Posts -- Average Post Reach" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/FB_Post_PostReach.png" alt="" width="455" height="184" /></p>
<p>In the example above, Wednesdays looked to perform pretty well reach-wise, as did Saturday afternoon. If you have Facebook paid media running, these results may get skewed. It&#8217;s easy enough to update this chart to use Organic Reach rather than Total Reach, or, you can simply factor an awareness of what was running and when into your assessment of the results. Also, keep in mind that Facebook <a title="Facebook Engagement (aka, Facebook Rhetoric  Facebook Reality)" href="http://www.gilliganondata.com/index.php/2012/01/26/facebook-engagement-aka-facebook-rhetoric-facebook-reality/" target="_blank">continues to fiddle with the EdgeRank/GraphRank algorithm</a>, so there are aspects of a post&#8217;s reach that are beyond your control.</p>
<p>The next chart shows the average <em>engagement rate</em> of the posts, defined as the number of users who engaged with the post in some way (clicked on a link, posted a comment, liked the post, viewed a photo, etc.) divided by the total reach of the post. This is a pretty solid measure of the content quality &#8212; did the post drive the users who saw it to take some action to engage with the content? Now, arguably, the propensity for a user to engage is less impacted by the time of day and day of week, but, who knows?</p>
<p><img class="aligncenter size-full wp-image-1777" title="Facebook Posts -- Average Engagement Rate" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/FB_Post_PostEngagement.png" alt="" width="455" height="184" /></p>
<p>In this example, Sundays and Thursdays were the days when posts appeared to get more engagement (although be leery of that Sunday, 6:00 PM to 9:00 PM, block &#8212; there was only a single post in the data set).</p>
<h3>Timeframe Flexibility</h3>
<p>Picking a set of timeframes is the most subjective aspect of this whole analysis, and it may be worth iterating through a few times to get to timeframes that are likely to be meaningful for the page given the target consumer. So, I&#8217;ve set up the worksheet to make it easy to customize these timeframes. For, instance, below is the same data set used above, but with only four windows of time:</p>
<p><img class="aligncenter size-full wp-image-1778" title="Facebook Posts - Post Engagement" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/FB_Post_PostEngagement_Fewer.png" alt="" width="455" height="124" /></p>
<p>The change look less than 60 seconds to implement (it&#8217;s all about VLOOKUPS, pivot tables, and conditional formatting!).</p>
<h3>How to Use This for Your Own Page</h3>
<p>If you want to try this out for your page(s), simply <a title="Facebook Post -- Time of Day and Day of Week Analysis" href="http://gilliganondata.com/files/Facebook_Post_Analysis.xlsx" target="_blank">download the Excel file</a> (this was created using Excel 2007, so it should work fine in both 2007 and 2010) and follow the instructions embedded in the worksheet. You will need to export post-level Facebook Insights data for your page, which may require several iterations (we&#8217;ve found that Facebook Insights is prone to hanging up if you try to export more than a couple of months of data at once):</p>
<p><img class="aligncenter" title="Facebook Insights -- Exporting Post-Level Detail" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/FB_Post_ExportInsights.png" alt="" width="465" height="337" /></p>
<p>Then, just follow the instructions in the spreadsheet and drop me a note if you run into any issues!</p>
<h3>Some Notes on the Shortcomings</h3>
<p>This approach isn&#8217;t perfect, and, if you have ideas for improving it, please leave a comment and I&#8217;ll be happy to iterate on the tool. Specifically:</p>
<ul>
<li>This approach measures all updates <span style="text-decoration: underline;">against the other posts for the same page</span> &#8212; there is no external benchmarking. This doesn&#8217;t bother me, as I&#8217;m a proponent of focusing on driving continuous improvement in your performance by starting where <em>you</em> are. Certainly, this analysis should be complemented by performance measurement that tracks the actual values of these metrics over time.</li>
<li>The overall visualization could be better. It&#8217;s not ideal that you need to jump back and forth between three different visualizations to draw conclusions about what days/times are really &#8220;good&#8221; or &#8220;bad&#8221;&#8230;including factoring in the sample size. I&#8217;ve toyed with making more of a weighted score and then doing the same color grid, but, then, you&#8217;d be looking at a true abstraction of the performance, so I didn&#8217;t go that route. Suggestions?</li>
<li>A red&#8211;&gt;yellow&#8211;&gt;green scale just isn&#8217;t good when it comes to supporting: 1) black-and-white printouts, and 2) certain forms of color blindness. A more iconographic approach might make more sense.</li>
</ul>
<p>Please do weigh in with how you would change this. I&#8217;m happy to rev it based on input!</p>
<hr />
<p><small>&copy; Tim for <a href="http://www.gilliganondata.com">Gilligan on Data by Tim Wilson</a>, 2012. |
<a href="http://www.gilliganondata.com/index.php/2012/02/14/facebook-status-updates-exploring-optimal-time-of-dayday-of-week/">Permalink</a> |
<a href="http://www.gilliganondata.com/index.php/2012/02/14/facebook-status-updates-exploring-optimal-time-of-dayday-of-week/#comments">17 comments</a> |
Add to
<a href="http://del.icio.us/post?url=http://www.gilliganondata.com/index.php/2012/02/14/facebook-status-updates-exploring-optimal-time-of-dayday-of-week/&amp;title=Facebook Status Updates: Exploring Optimal Time of Day/Day of Week">del.icio.us</a>
<br/>
Post tags: <br/>
</small></p>
<p><small>Feed enhanced by <a href='http://planetozh.com/blog/my-projects/wordpress-plugin-better-feed-rss/'>Better Feed</a> from  <a href='http://planetozh.com/blog/'>Ozh</a></small></p>
<img src="http://feeds.feedburner.com/~r/GilliganOnData/~4/ap55ERxRnHA" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.gilliganondata.com/index.php/2012/02/14/facebook-status-updates-exploring-optimal-time-of-dayday-of-week/feed/</wfw:commentRss>
		<slash:comments>17</slash:comments>
		<feedburner:origLink>http://www.gilliganondata.com/index.php/2012/02/14/facebook-status-updates-exploring-optimal-time-of-dayday-of-week/</feedburner:origLink></item>
		<item>
		<title>Working Around Sampled Search Data in Google Analytics</title>
		<link>http://feedproxy.google.com/~r/GilliganOnData/~3/RtE_Ya-yHMg/</link>
		<comments>http://www.gilliganondata.com/index.php/2012/02/09/working-around-sampled-search-data-in-google-analytics/#comments</comments>
		<pubDate>Thu, 09 Feb 2012 11:00:34 +0000</pubDate>
		<dc:creator>Tim Wilson</dc:creator>
				<category><![CDATA[Web Analytics]]></category>
		<category><![CDATA[Google Analytics]]></category>
		<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://www.gilliganondata.com/?p=1767</guid>
		<description><![CDATA[I got into a discussion of sampling in Google Analytics  with SEO expert and Web PieRat Jill Kocher earlier this year, which led to some profile/filter noodling that seemed worth sharing. Specifically, Jill and I were discussing how, in the world of search engine optimization &#8212; where the long tail can be …]]></description>
			<content:encoded><![CDATA[<p>I got into a discussion of <a title="Google Analytics Sampling" href="http://support.google.com/analytics/bin/answer.py?hl=en_US&amp;answer=1042498" target="_blank">sampling in Google Analytics</a>  with SEO expert and <a title="Web PieRat" href="http://webpierat.com/#axzz1lWq8DetU" target="_blank">Web PieRat</a> Jill Kocher earlier this year, which led to some profile/filter noodling that seemed worth sharing. Specifically, Jill and I were discussing how, in the world of search engine optimization &#8212; where the long tail can be a handy thing to analyze &#8212; sampling in Google Analytics can be a real nuisance.</p>
<p><img class="aligncenter size-full wp-image-1768" title="Sampling Message in Google Analytics" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/samplingSearchGA.png" alt="" width="405" height="167" /></p>
<p>That got me thinking that a partial solution would be to have a Google Analytics profile that <em>only</em> includes organic search traffic. This isn&#8217;t a profile that you would use for cross-session analytics, but it&#8217;s one that would allow simplified segmentation, reduced cases of sampling, and, perhaps, a more complete data set.</p>
<p>As it turns out, it was pretty simple to set up, and it seems to do the trick.</p>
<h3>Step 1: Make a New Profile</h3>
<p>Create a new profile under the same web property that you&#8217;re using for your site and name it <strong>Organic Search Traffic Only</strong>:</p>
<p><img class="aligncenter size-medium wp-image-1769" title="Create New Google Analytics Profile" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/CreateNewProfile-500x342.png" alt="" width="500" height="342" /></p>
<p>There&#8217;s nothing magic about this. The key is that this is a profile that uses the same web property ID as the profile where you&#8217;re running into sampling issues with your SEO analysis. We&#8217;re just going to take that same feed of data coming in as visitors visit your site and carve out the subset of that data that is traffic from organic search referrals.</p>
<h3>Step 2: Apply an Organic Search Filter</h3>
<p>The next (and final) step is to create a filter and apply it to the profile such that only organic search traffic is included.</p>
<p>In the new profile you just created, select the <strong>Filters</strong> tab and then click <strong>New Filter</strong>:</p>
<p><img class="aligncenter size-full wp-image-1770" title="New Profile Filter - Google Analytics" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/GA_NewFilter.png" alt="" width="389" height="246" /></p>
<p>From there:</p>
<ol>
<li>Give the filter a name like &#8220;Organic Search Referrals&#8221;</li>
<li>Select <strong>Custom Filter</strong> as the <strong>Filter Type</strong></li>
<li>Set the filter as an <strong>Include </strong>filter</li>
<li>Set the <strong>Filter Field</strong> to <strong>Campaign Medium</strong></li>
<li>Set the <strong>Filter Pattern</strong> to &#8220;organic&#8221;</li>
<li>Save the filter</li>
</ol>
<p>The screen below shows the filter settings:</p>
<p><img class="aligncenter size-full wp-image-1771" title="Google Analytics Organic Search Filter" src="http://www.gilliganondata.com/wp-content/uploads/2012/02/GA_OrganicSearch_Filter.png" alt="" width="458" height="415" /></p>
<h3>Step 3: Sit Back and Let the Data Roll In</h3>
<p>The profile is only going to include data from the point you set it up going forward. But, it <em>will</em> accurately reflect (to the extent that any web analytics package can accurately reflect this) new versus returning visitors for all time (well, since you initially implemented Google Analytics), because it&#8217;s getting that data from the cookie that already exists on users&#8217; machines.</p>
<p>Initially, I saw some odd data on the unique visitors front, which I can semi-intuitively understand&#8230;but not quite explain.</p>
<p>Suffice it to say that, once you have the profile up and running for a week or so, you can select the <strong>Non-paid Search Traffic</strong> segment in your main profile and compare it to the <strong>All Visits</strong> segment in your new profile, and the numbers will be virtually identical. But, you can now do SEO analysis with a base set of data that <em>only</em> includes search traffic.</p>
<p>Is that handy?<strong>Similar Posts:</strong>
<ul class="similar-posts">
<li><a href="http://www.gilliganondata.com/index.php/2008/05/21/google-analytics-strawberry/" rel="bookmark" title="May 21, 2008">Google Analytics = Strawberry?</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2011/08/09/web-analytics-platforms-are-fundamentally-broken/" rel="bookmark" title="August 9, 2011">Web Analytics Platforms Are Fundamentally Broken</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2011/07/12/a-quick-explanation-of-sitecatalyst-events-for-the-google-analytics-power-user/" rel="bookmark" title="July 12, 2011">A Quick Explanation of Sitecatalyst Events for the Google Analytics Power User</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2009/10/18/seo-tips-and-thoughts-at-web-analytics-wednesday/" rel="bookmark" title="October 18, 2009">SEO Tips and Thoughts at Web Analytics Wednesday</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2011/03/01/web-analytics-tools-comparison-columbus-waw-recap-part-2/" rel="bookmark" title="March 1, 2011">Web Analytics Tools Comparison &#8212; Columbus WAW Recap Part 2</a></li>
</ul>
<p><!-- Similar Posts took 31.232 ms --></p>
<hr />
<p><small>&copy; Tim for <a href="http://www.gilliganondata.com">Gilligan on Data by Tim Wilson</a>, 2012. |
<a href="http://www.gilliganondata.com/index.php/2012/02/09/working-around-sampled-search-data-in-google-analytics/">Permalink</a> |
<a href="http://www.gilliganondata.com/index.php/2012/02/09/working-around-sampled-search-data-in-google-analytics/#comments">2 comments</a> |
Add to
<a href="http://del.icio.us/post?url=http://www.gilliganondata.com/index.php/2012/02/09/working-around-sampled-search-data-in-google-analytics/&amp;title=Working Around Sampled Search Data in Google Analytics">del.icio.us</a>
<br/>
Post tags: <a href="http://www.gilliganondata.com/index.php/tag/google-analytics/" rel="tag">Google Analytics</a>, <a href="http://www.gilliganondata.com/index.php/tag/seo/" rel="tag">SEO</a><br/>
</small></p>
<p><small>Feed enhanced by <a href='http://planetozh.com/blog/my-projects/wordpress-plugin-better-feed-rss/'>Better Feed</a> from  <a href='http://planetozh.com/blog/'>Ozh</a></small></p>
<img src="http://feeds.feedburner.com/~r/GilliganOnData/~4/RtE_Ya-yHMg" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.gilliganondata.com/index.php/2012/02/09/working-around-sampled-search-data-in-google-analytics/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://www.gilliganondata.com/index.php/2012/02/09/working-around-sampled-search-data-in-google-analytics/</feedburner:origLink></item>
		<item>
		<title>Facebook Engagement (aka, Facebook Rhetoric  Facebook Reality)</title>
		<link>http://feedproxy.google.com/~r/GilliganOnData/~3/SdS_jDkKtAc/</link>
		<comments>http://www.gilliganondata.com/index.php/2012/01/26/facebook-engagement-aka-facebook-rhetoric-facebook-reality/#comments</comments>
		<pubDate>Thu, 26 Jan 2012 13:44:54 +0000</pubDate>
		<dc:creator>Tim Wilson</dc:creator>
				<category><![CDATA[Facebook Insights]]></category>

		<guid isPermaLink="false">http://www.gilliganondata.com/?p=1748</guid>
		<description><![CDATA[Oh, Facebook. Facebook, Facebook, Facebook. Ours is a tumultuous relationship of unrequited frustration, is it not? I am an analyst, therefore (apparently), you scorn me. And, by &#8220;scorn,&#8221; I mean &#8220;ignore.&#8221; You never responded to my letter last year. You don&#8217;t return my calls. (Well, that&#8217;s not entirely true: you put …]]></description>
			<content:encoded><![CDATA[<p>Oh, Facebook.</p>
<p>Facebook, Facebook, Facebook.</p>
<p>Ours is a tumultuous relationship of unrequited frustration, is it not? I am an analyst, therefore (apparently), you scorn me. And, by &#8220;scorn,&#8221; I mean &#8220;ignore.&#8221;</p>
<p>You never responded to my <a title="Dear Facebook: As an Analyst, It’s Hard to Be Your Friend" href="http://www.gilliganondata.com/index.php/2011/01/19/dear-facebook-as-an-analyst-its-hard-to-be-your-friend/" target="_blank">letter last year</a>. You don&#8217;t return my calls. (Well, that&#8217;s not entirely true: you put <em>salespeople</em> on my calls whose general response to any question is, &#8220;Buy Facebook media.&#8221; I get it. That&#8217;s their job, but they act like they&#8217;ve parachuted straight out of <em>Mad Men</em> and are pushing traditional mass-blast advertising. Ironic, no?)</p>
<p>Facebook, I&#8217;ve dug into the data. <a title="Facebook Page Insights Product Guide for Facebook Page Owners" href="http://ads.ak.facebook.com/ads/creative/insights/page-insights-guide.pdf" target="_blank">Your own documentation</a> states:</p>
<blockquote><p>Posting regularly with engaging content gets more people to talk about your business with their friends. As a result, you end up reaching more people overall.</p></blockquote>
<p>Yet, the data you provide us tells a very different story. We debunked this particular claim &#8212; that <a title="Facebook Insights — What “Viral” Measures Tell Us about EdgeRank" href="http://www.gilliganondata.com/index.php/2011/12/19/facebook-insights-what-viral-measures-tell-us-about-edgerank/" target="_blank">getting people to talk about your content leads to greater reach</a> &#8211; a month ago.</p>
<h3>So, What Can We Debunk <em>This</em> Month?</h3>
<p>Lately, I&#8217;ve been digging into a more basic mystery: you claim that, the more someone engages with a page&#8217;s content, the more likely that person is to get presented with more of that page&#8217;s content in the future. That seems pretty reasonable. Of course, you <a title="Facebook Page Publishing Best Practices" href="http://ads.ak.facebook.com/ads/creative/Page-Publishing-Best-Practices-FS-2.pdf" target="_blank">hedge at the same time</a>:</p>
<blockquote><p>No matter how engaging your Page posts are, not all of your fans will see them in their News Feed. In order to make sure that more of your fans see your posts, you should create a Page Post Ad</p></blockquote>
<p>Can we quantify that &#8220;not all of your fans&#8230;&#8221; statement? <a title="allfacebook.com" href="http://allfacebook.com" target="_blank">AllFacebook.com</a> did just that when they published a <a title="UH, OH! Facebook Pages Only Reach 17% Of Fans" href="http://www.allfacebook.com/facebook-page-17-2012-01" target="_blank">pretty alarming article</a> last week based on <a title="EdgeRank Checker" href="http://edgerankchecker.com" target="_blank">Edgerank Checker</a> data. Their study showed that, on average, across 4,000 pages, <strong>only 17% of total fans were being reached per individual post by the brand</strong>. &#8220;Zoiks!&#8221; were the cries that echoed through the halls of community managers the world over!</p>
<p>To be fair, not <em>everyone</em> is on Facebook <em>all the time</em>, and, while that number matches data we&#8217;re seeing overall, it also leaves out the fact that these don&#8217;t appear to be the <em>same</em> 17% day in and day out. When it comes to looking at the <strong>28-Day Total Reach from Page Posts</strong> measure you provide, we see numbers that are more in the neighborhood of half of a page&#8217;s <strong>Lifetime Total Likes</strong> (when there is no Facebook media running &#8212; it&#8217;s much higher than that if that exposure is being purchased from Facebook).</p>
<p>Is 17% really all brands can expect, or is it all they can expect <em>if they&#8217;re doing a lousy job posting content</em>?</p>
<h3>Are Brands Simply Not Publishing Engaging Content?</h3>
<p>We&#8217;ve been working pretty hard to learn what kind of content our clients&#8217; fans like, as well as how often and when to post. That put us in a good position to dig into the data to see how we were doing, especially in light of the drop we felt we were seeing in the <strong>Reach</strong> of posts across a range of our clients&#8217; pages.</p>
<p>We looked at data from a half-dozen pages. These pages were all devoted to major consumer brands, had <strong>Lifetime Total Likes</strong> ranging from the low 100,000s to multiple millions, and cut across a range of different verticals. Is &#8220;6 pages&#8221; on the order of the &#8220;4,000 pages&#8221; from the Allfacebook.com study? Well, no, but we were working with over 600 status updates, and it quickly became apparent that we&#8217;d dug in enough to draw some pretty sound conclusions..</p>
<p>For the chart below, we removed the handful of posts that were clearly data anomalies (skewing both wildly high and wildly low) and then, for each post, took the <strong>Lifetime Engaged Users</strong> for the post (the number of unique people who clicked anywhere in the post within 28 days of it being posted, regardless of whether the click generated a story or not) and divided it by the <strong>Total Reach</strong> for the post.</p>
<p>It&#8217;s not the cleanest of graphs, but it seems pretty clear that, if anything, these pages are, overall, making some headway when it comes to producing more engaging content.</p>
<p><a href="http://www.gilliganondata.com/wp-content/uploads/2012/01/FacebookEngagement_Jan2012.png"><img class="aligncenter size-medium wp-image-1763" title="Post Engagement as a Percentage of Post Reach" src="http://www.gilliganondata.com/wp-content/uploads/2012/01/FacebookEngagement_Jan2012-500x293.png" alt="" width="500" height="293" /></a></p>
<p>The idea here is that the only people a post has a <em>chance</em> of engaging are people that it reaches. So, we have <strong>Total Reach</strong> as the denominator. This is similar to the <strong>Post Virality</strong> calculation that you, Facebook, generate for me&#8230;but we&#8217;re looking at a lower level of engagement than &#8220;generated a story&#8221; &#8212; just looking to see if fans are interacting with the post <em>in any way</em>. Because, in theory,<strong> if they are, then you will be more likely to present them with subsequent posts from the same page.</strong></p>
<h3>So, Engagement Isn&#8217;t Dropping. Presumably, Reach Isn&#8217;t, Either?</h3>
<p>In the post engagement chart, there&#8217;s nothing all that shocking. What <em>does</em> get alarming, though, is when we look at the average <strong>Organic Reach</strong> (unique users who saw the post directly as a result of the page posting it &#8212; not because a friend talked about it, and not because the brand ran paid media to extend the reach of the post). We divided that organic reach by the <strong>Lifetime Total Likes</strong> for the <em>page</em> to see what % of the total fans were reached by the post organically.</p>
<p>Again, outliers (high and low) were removed (this included locally-targeted posts, where the reach, obviously, was very low relative to the total likes for the page). Each point on the chart represents all of the status updates on that day from our sample:</p>
<p><a href="http://www.gilliganondata.com/wp-content/uploads/2012/01/FacebookOrganicReach_Jan2012.png"><img class="aligncenter size-medium wp-image-1764" title="Average Organic Reach per Post as a % of Total Page Likes" src="http://www.gilliganondata.com/wp-content/uploads/2012/01/FacebookOrganicReach_Jan2012-500x293.png" alt="" width="500" height="293" /></a></p>
<p>Wow. I&#8217;m not a data scientist, so the above doesn&#8217;t have any true statistical rigor applied to it. Rather, it is an exercise in what a stats professor once preached to me: &#8220;Start off by plotting the data! That&#8217;s going to tell you a lot!&#8221;</p>
<p>It&#8217;s pretty conclusive, I think, that a Facebook algorithm change (and related UI changes &#8212; but the algorithms drove what content appears anywhere for a user, regardless of the UI) in late September gave brands a temporary ability to reach a higher proportion of their fans. That, undoubtedly, led to any number of community managers thinking they had been listening and learning and publishing more engaging content.</p>
<p>Then, (alas!) November arrived. And, suddenly, <strong>Reach</strong> plummeted.</p>
<h3>WTF?</h3>
<p>It&#8217;s not that I&#8217;m opposed to paying you for reach, Facebook. I&#8217;m totally okay with paid media being part of my social media mix. But, if I have to pay you <em>each time</em> I want to reach someone, the numbers start to get hard to justify. If someone likes my page, and then they engage with my content, <em>why don&#8217;t they keep getting my content for some period of time</em>?</p>
<p>Here&#8217;s what I think happened (and, frankly, I&#8217;d respect you a bit more in the morning if you just came out and admitted it):</p>
<ol>
<li>You put some sharp people in a room and told them to come up with a good EdgeRank/GraphRank algorithm</li>
<li>While you have &#8220;a lot of data,&#8221; that algorithm still was largely driven by that team&#8217;s instincts around what weighting should be given to different factors</li>
<li>There was a fair amount of teeth-gnashing, and the team even tried to do some testing of the algorithm before rolling it out. But, that&#8217;s a taller order than it sounds.</li>
<li>The algorithm got rolled out.</li>
<li>You had <em>no idea</em> what was going to happen. What looked good on paper looked, well, different in practice.</li>
<li>For various reasons &#8212; none of which have been openly stated &#8212; the algorithm has been quietly tweaked a couple of times. In one case, it was related to the Timeline rollout, but, by this time, the algorithm had become the red-headed stepchild of Palo Alto. No one really wants to own it, because no one can really figure out what will make it &#8220;work.&#8221; After all&#8230;the algorithm-heads are all just down the street <a title="Where is Google headquartered?" href="https://www.google.com/search?aq=f&amp;sourceid=chrome&amp;ie=UTF-8&amp;q=where+is+google+headquartered%3F" target="_blank">in Mountain View</a>! (zing!)</li>
</ol>
<p>How close am I with the above speculation? I don&#8217;t have inside knowledge (as noted earlier, you don&#8217;t call, you don&#8217;t write), but I&#8217;m not sure what other explanation makes sense.</p>
<p>Know that you&#8217;re killing us &#8212; the analysts who are trying to drive learning and optimization! At <em>least</em> set up some sort of open dialogue. We don&#8217;t need to see the full formula. But, we need to have useful information about how to do things better. And we need to know when you&#8217;re tinkering with the algorithm and what the likely result of that tinkering will be. Otherwise, we can&#8217;t trust the data, which means we can&#8217;t learn from it. Without data we can use, it&#8217;s hard to justify investment and action.</p>
<hr />
<p><small>&copy; Tim for <a href="http://www.gilliganondata.com">Gilligan on Data by Tim Wilson</a>, 2012. |
<a href="http://www.gilliganondata.com/index.php/2012/01/26/facebook-engagement-aka-facebook-rhetoric-facebook-reality/">Permalink</a> |
<a href="http://www.gilliganondata.com/index.php/2012/01/26/facebook-engagement-aka-facebook-rhetoric-facebook-reality/#comments">2 comments</a> |
Add to
<a href="http://del.icio.us/post?url=http://www.gilliganondata.com/index.php/2012/01/26/facebook-engagement-aka-facebook-rhetoric-facebook-reality/&amp;title=Facebook Engagement (aka, Facebook Rhetoric <> Facebook Reality)">del.icio.us</a>
<br/>
Post tags: <br/>
</small></p>
<p><small>Feed enhanced by <a href='http://planetozh.com/blog/my-projects/wordpress-plugin-better-feed-rss/'>Better Feed</a> from  <a href='http://planetozh.com/blog/'>Ozh</a></small></p>
<img src="http://feeds.feedburner.com/~r/GilliganOnData/~4/SdS_jDkKtAc" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.gilliganondata.com/index.php/2012/01/26/facebook-engagement-aka-facebook-rhetoric-facebook-reality/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://www.gilliganondata.com/index.php/2012/01/26/facebook-engagement-aka-facebook-rhetoric-facebook-reality/</feedburner:origLink></item>
		<item>
		<title>New Blog Design –&gt; Responsive Design and Web Analytics Musings</title>
		<link>http://feedproxy.google.com/~r/GilliganOnData/~3/vBrM1CZTHgc/</link>
		<comments>http://www.gilliganondata.com/index.php/2012/01/24/new-blog-design-responsive-design-and-web-analytics-musings/#comments</comments>
		<pubDate>Tue, 24 Jan 2012 17:36:13 +0000</pubDate>
		<dc:creator>Tim Wilson</dc:creator>
				<category><![CDATA[Social Media]]></category>
		<category><![CDATA[Web Analytics]]></category>
		<category><![CDATA[responsive design]]></category>

		<guid isPermaLink="false">http://www.gilliganondata.com/?p=1742</guid>
		<description><![CDATA[If you&#8217;re reading this post on the site itself (as opposed to via RSS or email), and if you&#8217;ve been to the site much in the past, then you&#8217;ll notice the design of the site has been completely overhauled. This was one of my goals for my weeklong holiday break&#8230;and …]]></description>
			<content:encoded><![CDATA[<p>If you&#8217;re reading this post on the site itself (as opposed to via RSS or email), and if you&#8217;ve been to the site much in the past, then you&#8217;ll notice the design of the site has been completely overhauled. This was one of my goals for my weeklong holiday break&#8230;and it&#8217;s a goal I entirely missed! Luckily, though, I wound up with a kid-free/spouse-free weekend a week-and-a-half ago, so I got to tackle the project.</p>
<h3>So, Why a New Design?</h3>
<p>I updated the design for two reasons:</p>
<ul>
<li><strong>The old design was starting to wear on me.</strong> There were a number of little alignment/layout/wrapping issues that I had never quite managed to fix, even as I tinkered with the blog functionality (for instance, my social icons never quite lined up well). I also figured out last fall that the nested table structure pretty much precluded me from getting the mix I wanted of fixed and liquid elements. In short, a redesign just seemed in order.</li>
<li><strong>Responsive web design is here.</strong> This was more of the direct-tie-to-my-day-job reason for the overhaul. Various sharp people at <a title="Resource Interactive" href="http://www.resource.com" target="_blank">Resource Interactive</a> have started pushing <a title=" 16TH DECEMBER 2011 by COURTNEY BOYD MYERS " href="http://thenextweb.com/dd/2011/12/16/the-future-of-web-design/" target="_blank">responsive web design</a> as something that should be actively considered for our clients. As I dug into the topic, I realized that: 1) this blog is a good candidate for a responsive design, and 2) there are some analytics implications to a responsive design, and I needed somewhere to experiment with them.</li>
</ul>
<p>So, this site is now using a fully responsive WordPress theme.</p>
<h3>What Is Responsive Design, Exactly?</h3>
<p>As I understand it, responsive design is an &#8220;Aha!&#8221; that grew out of the increasing need for web sites to function across a wide range of screen sizes and experiences and platforms: laptop monitors, desktop monitors, tablets (iOS and Android), and smartphones (also iOS and Android). The idea is that, rather than having a &#8220;desktop site&#8221; and a &#8220;mobile-optimized site,&#8221; you can have &#8220;<span style="text-decoration: underline;"><strong>a</strong></span> site&#8221; that works effectively on a wide range of devices.</p>
<p>There are two keys to this:</p>
<ul>
<li><strong>The site needs to be <em>viewable</em> in different devices</strong> &#8211; 3 columns that display on a desktop monitor may need to become a single set of stacked content on a smartphone. Or, a list of links in the sidebar on the desktop may need to become a dropdown box at the top of the page on an iPhone.</li>
<li><strong>The site needs to <em>support the most likely use cases</em> in different devices &#8211;</strong> this is a stickier wicket, because it forces some strategic thought (and possibly research and testing) to think through what a visitor to your site who is using an iPhone (for instance) is likely looking to do and how that differs from a visitor to your site who is using a desktop.</li>
</ul>
<p>Both of these are questions that have always been asked when it comes to developing a &#8220;mobile-optimized version of the site,&#8221; but they&#8217;re a bit more nuanced given that responsive design isn&#8217;t a &#8220;separate site.&#8221;</p>
<h3>Wow, Tim, I&#8217;m Impressed with Your Coding Skills!</h3>
<p>Don&#8217;t be impressed with my coding skills.</p>
<p>I did a little research and then shelled out $35 to <a title="Rising WordPress Theme" href="http://themeforest.net/item/rising-fully-responsive-wordpress-theme/743440?WT.ac=portfolio_item&amp;WT.seg_1=portfolio_item&amp;WT.z_author=der" target="_blank">buy the Rising theme</a>. That doesn&#8217;t mean there wasn&#8217;t a fair amount of tinkering (and more tinkering yet to be done &#8212; <em>I</em> certainly have not fallen prey to a need to have the perfect site designed before pushing it live!), but the end result is an improved site. And, more importantly, having a site that actually works well across devices (Try it! Just resize your browser window and watch the sidebar at the right. Or, fire up the site on your smartphone and compare it to your desktop.)</p>
<p>Now, of the &#8220;two keys&#8221; above, I really focused on the first one. This is a blog, after all. Regardless of what device you&#8217;re on, presumably, you&#8217;re here to consume blog post content.</p>
<p>I&#8217;m still working with the palette (too little contrast between the hyperlink color and the plain text color), the font selection (I&#8217;m not in love with it), and the header logo (pulling what strings I can to get a professional to contribute on that front), but I&#8217;m reasonably content with the change. Let me know if you have any tips for improving the design (I&#8217;m not proud!).</p>
<h3>Where Does Analytics Come into All of This?</h3>
<p>While I have access to tons of different web analytics accounts across a range of platforms through our various clients, I don&#8217;t actually have a great sandbox for trying things out (you would think our company&#8217;s site would be a good testbed, but the reality is that there are so many competing agendas for competing resources there that it&#8217;s seldom worth the effort). Luckily, this site has built up enough content and enough of a presence to get a few hundred visits a day, which is enough to actually do some tinkering and get some real data as a result.</p>
<p>Here&#8217;s my list of what I&#8217;ll be toying with over the coming weeks:</p>
<ul>
<li><strong>Responsive design analytics &#8212; </strong>we&#8217;ve had &#8220;screen resolution&#8221; and &#8220;device&#8221; reporting for years, but responsive design introduces a whole new twist, because it&#8217;s truly <em>experience-</em>centric. I&#8217;ve done a little digging online and haven&#8217;t found much in the way of thinking on this. While I don&#8217;t think it&#8217;s possible to directly pull <a title="CSS Media Query" href="http://www.w3.org/TR/css3-mediaqueries/" target="_blank">CSS media query</a> data into the web analytics platform, it should be possible to use Javascript to detect which responsive layout is being used for any given visitor and then pass that information to the web analytics platform (as a custom variable or a non-interaction event in Google Analytics). And, it should be possible to record when an <a title="onresize" href="http://www.w3schools.com/jsref/event_onresize.asp" target="_blank">onresize event</a> occurs. In both cases, using this data to segment traffic to determine if a particular layout is performing poorly or well, as well as how visitors move through the site in these different experiences, seems like a promising thought.</li>
<li><strong>Facebook Insights for Websites</strong> &#8212; I&#8217;ve had this running for a while, but, as part of another experiment, I switched over from using my Facebook user ID in the meta data to authenticate my ownership of the site to using a Facebook app ID. That&#8217;s a better way to go when it comes to &#8220;real&#8221; sites, and I&#8217;m now actually doing some tinkering on some client sites to fully validate what happens, so look for some thoughts on that front in the future.</li>
<li><strong>Detecting the Facebook login status of visitors to the site </strong>&#8211; this is some experimentation that is actively in work. It&#8217;s the implementation of some code that <a title="How to find out if your users are on Facebook" href="http://devblog.springest.com/how-to-find-out-if-your-users-are-on-facebook" target="_blank">Dennis Paagman came up with</a> to use Facebook Connect and <a title="Google Analytics Non-Interaction Events" href="http://code.google.com/apis/analytics/docs/tracking/eventTrackerGuide.html#non-interaction" target="_blank">Google Analytics non-interaction events</a> to detect (and then &#8212; my thinking &#8212; segment) visitors based on whether they&#8217;re logged into Facebook or not at the time of their visit to the site. This seems like it has intriguing possibilities when it comes to determining what types of social  interactions should be offered and how prominently. I&#8217;ve hit a minor snag on that front and am hoping Dennis will be able to help get to the bottom of it (see the comments on his blog post). But, if I get it figured out, I&#8217;ll share in a post down the road.</li>
<li><strong>Site performance</strong> &#8211; anecdotally, it seems like this site is now loading more slowly than it did with the old design. The <a title="Google Analytics Site Speed" href="http://support.google.com/analytics/bin/answer.py?hl=en&amp;answer=1205784" target="_blank">Google Analytics Site Speed</a> report seems to indicate that is the case, but I don&#8217;t feel like I have enough data to be conclusive there just yet. I have signed up for a <a title="site24x7" href="http://www.site24x7.com" target="_blank">site24x7.com</a> account, which is a platform we use with some of our clients for a couple of reasons: 1) to see what it reports relative to Google Analytics (it&#8217;s a fundamentally different data capture method, so I&#8217;m not going to be surprised if the results are wildly divergent), and 2) to get more reliable data if I start playing with changes to reduce the site load time. In hindsight, I wish I&#8217;d signed up a month or so ago so I had good pre- and post- data. If I had a nickel for every time I wanted to have had <em>that</em>, I&#8217;d be a wealthy man!</li>
</ul>
<p>In a nutshell (a gargantuan, artificial nutshell, I&#8217;ll grant you), I&#8217;ve got a backlog of topics, some of which will require some additional experimentation. This blog post, I realize, is almost more of a &#8220;to do&#8221; list for me than it is a &#8220;how to&#8221; list for you! Oh, well. They can&#8217;t all be winners!</p>
<hr />
<p><small>&copy; Tim for <a href="http://www.gilliganondata.com">Gilligan on Data by Tim Wilson</a>, 2012. |
<a href="http://www.gilliganondata.com/index.php/2012/01/24/new-blog-design-responsive-design-and-web-analytics-musings/">Permalink</a> |
<a href="http://www.gilliganondata.com/index.php/2012/01/24/new-blog-design-responsive-design-and-web-analytics-musings/#comments">2 comments</a> |
Add to
<a href="http://del.icio.us/post?url=http://www.gilliganondata.com/index.php/2012/01/24/new-blog-design-responsive-design-and-web-analytics-musings/&amp;title=New Blog Design &#8211;> Responsive Design and Web Analytics Musings">del.icio.us</a>
<br/>
Post tags: <a href="http://www.gilliganondata.com/index.php/tag/responsive-design/" rel="tag">responsive design</a><br/>
</small></p>
<p><small>Feed enhanced by <a href='http://planetozh.com/blog/my-projects/wordpress-plugin-better-feed-rss/'>Better Feed</a> from  <a href='http://planetozh.com/blog/'>Ozh</a></small></p>
<img src="http://feeds.feedburner.com/~r/GilliganOnData/~4/vBrM1CZTHgc" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.gilliganondata.com/index.php/2012/01/24/new-blog-design-responsive-design-and-web-analytics-musings/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://www.gilliganondata.com/index.php/2012/01/24/new-blog-design-responsive-design-and-web-analytics-musings/</feedburner:origLink></item>
		<item>
		<title>10 Presentation Tips: Tip No. 10 — Respect the Audience</title>
		<link>http://feedproxy.google.com/~r/GilliganOnData/~3/5ZDGUPmvsbg/</link>
		<comments>http://www.gilliganondata.com/index.php/2012/01/16/10-presentation-tips-tip-no-10-respect-the-audience/#comments</comments>
		<pubDate>Mon, 16 Jan 2012 16:20:28 +0000</pubDate>
		<dc:creator>Tim Wilson</dc:creator>
				<category><![CDATA[Miscellaneous]]></category>
		<category><![CDATA[10 Presentation Tips]]></category>

		<guid isPermaLink="false">http://www.gilliganondata.com/?p=1584</guid>
		<description><![CDATA[This is the last post in a 10-post series on tips for effective presentations. For an explanation as to why I&#8217;m adding this series to a data-oriented blog, see the intro to the first post in the series. To view other tips in the series, click here. Tip No. 10: Respect the …]]></description>
			<content:encoded><![CDATA[<p>This is the last post in a 10-post series on tips for effective presentations. For an explanation as to why I&#8217;m adding this series to a data-oriented blog, see the intro to the <a title="10 Presentation Tips: Tip No. 1 -- Watch What Works" href="http://www.gilliganondata.com/index.php/2012/01/03/10-presentation-tips-tip-no-1-watch-what-works" target="_blank">first post in the series</a>. To view other tips in the series, click <a title="10 Tips for Effective Presentations" href="http://www.gilliganondata.com/index.php/tag/10-presentation-tips" target="_blank">here</a>.</p>
<h3>Tip No. 10: Respect the Audience</h3>
<p>This last tip is more of a perspective than a tip.</p>
<p>It&#8217;s last because it&#8217;s the tip that drives the reason for paying attention to all of the other tips.</p>
<p>It&#8217;s last because it&#8217;s a tip that is all too often flagrantly ignored.</p>
<p>It&#8217;s last because it can be a little scary.</p>
<p>The experience that prompted me to write this series was my participation in the inaugural <a title="#ACCELERATE" href="http://www.webanalyticsdemystified.com/accelerate/" target="_blank">#ACCELERATE conference</a> in San Francisco last fall. As it turned out, I was the last presenter of the day &#8212; one of the 5-minute Super #ACCELERATE presentations.</p>
<p><a href="http://campl.us/gPfs"><img class="aligncenter size-full wp-image-1634" title="#ACCELERATE Audience" src="http://www.gilliganondata.com/wp-content/uploads/2012/01/accelerateaudience.jpg" alt="" width="500" height="245" /></a></p>
<p>Here&#8217;s one way I could have viewed my presentation:</p>
<blockquote><p>It&#8217;s only 5 minutes, so I should try to do something pretty solid, but, if it falls flat, it&#8217;s only a small fraction of the overall conference.</p></blockquote>
<p>Here&#8217;s how I actually viewed the presentation:</p>
<blockquote><p> It&#8217;s 5 minutes, but it&#8217;s 5 minutes in front of of 300 people, so that&#8217;s actually 1500 minutes, or 25 hours. If I swag that the fully loaded cost of the members of the audience is, on average, $50/hour, then I need to deliver a $1,250 presentation!</p></blockquote>
<p>Okay, so it&#8217;s a little tough to really make this math work is a 5-<em>minute</em> presentation, but think about a 20-minute presentation ($5,000) or a 30-minute presentation ($7,500) or an hour-long presentation ($15,000). Change the hourly cost however you see fit, but do the mental exercise to consider the <em>opportunity cost</em> of the presentation &#8212; the total amount that is being invested by the audience members who could be doing something <em>else</em> rather than listening to you present. <em>That</em> is the amount of value you should <em>fully commit</em> to delivering with your presentation.</p>
<p>Each member of the audience is paying to watch your presentation, regardless of whether they had to pay a monetary fee to sit through it.</p>
<blockquote>
<p style="text-align: center;"><strong>They&#8217;re paying with a finite and valuable commodity: their time.</strong></p>
</blockquote>
<p>Recognize that. Respect that. Do <em>everything</em> you can to make it a worthwhile investment on their part.</p>
<p style="text-align: right;"><a title="Eric Peterson photo of the #ACCELERATE audience" href="http://campl.us/gPfs">Photo by Eric T. Peterson</a></p>
<p><strong>Similar Posts:</strong>
<ul class="similar-posts">
<li><a href="http://www.gilliganondata.com/index.php/2012/01/04/10-presentation-tips-tip-no-2-pay-attention-to-what-doesnt-work/" rel="bookmark" title="January 4, 2012">10 Presentation Tips: Tip No. 2 &#8212; Pay Attention to What Doesn’t Work</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2012/01/05/10-presentation-tips-tip-no-3-no-slideuments-a-picture-is-worth-a-1000-words/" rel="bookmark" title="January 5, 2012">10 Presentation Tips: Tip No. 3 &#8212; NO SLIDEUMENTS (a Picture IS Worth 1,000 Words!)</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2012/01/06/10-presentation-tips-tip-no-4-go-with-a-flow/" rel="bookmark" title="January 6, 2012">10 Presentation Tips: Tip No. 4 &#8212; Go with a Flow</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2012/01/10/10-presentation-tips-tip-no-6-bring-the-energy/" rel="bookmark" title="January 10, 2012">10 Presentation Tips: Tip No. 6 &#8212; Bring the Energy!</a></li>
<li><a href="http://www.gilliganondata.com/index.php/2012/01/12/10-presentation-tips-tip-no-8-we-have-five-senses-use-two/" rel="bookmark" title="January 12, 2012">10 Presentation Tips: Tip No. 8 &#8212; We Have Five Senses. Use TWO!</a></li>
</ul>
<p><!-- Similar Posts took 46.329 ms --></p>
<hr />
<p><small>&copy; Tim for <a href="http://www.gilliganondata.com">Gilligan on Data by Tim Wilson</a>, 2012. |
<a href="http://www.gilliganondata.com/index.php/2012/01/16/10-presentation-tips-tip-no-10-respect-the-audience/">Permalink</a> |
<a href="http://www.gilliganondata.com/index.php/2012/01/16/10-presentation-tips-tip-no-10-respect-the-audience/#comments">No comment</a> |
Add to
<a href="http://del.icio.us/post?url=http://www.gilliganondata.com/index.php/2012/01/16/10-presentation-tips-tip-no-10-respect-the-audience/&amp;title=10 Presentation Tips: Tip No. 10 &#8212; Respect the Audience">del.icio.us</a>
<br/>
Post tags: <a href="http://www.gilliganondata.com/index.php/tag/10-presentation-tips/" rel="tag">10 Presentation Tips</a><br/>
</small></p>
<p><small>Feed enhanced by <a href='http://planetozh.com/blog/my-projects/wordpress-plugin-better-feed-rss/'>Better Feed</a> from  <a href='http://planetozh.com/blog/'>Ozh</a></small></p>
<img src="http://feeds.feedburner.com/~r/GilliganOnData/~4/5ZDGUPmvsbg" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.gilliganondata.com/index.php/2012/01/16/10-presentation-tips-tip-no-10-respect-the-audience/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.gilliganondata.com/index.php/2012/01/16/10-presentation-tips-tip-no-10-respect-the-audience/</feedburner:origLink></item>
	</channel>
</rss>

