DigiThoughts

The End of Facebook?

August 17, 2010 by Warren Raisch

Let me start with the unthinkable – What if Facebook were to go away?  What would people do with those hours a day spent posting, updating and sharing of vacation pictures?  Would they all shift to a new platform? If so what platform would it be?  YouTube, MySpace, Plaxo?  Where would they all go?

Read full article

True Blood is STILL Killing It!

August 09, 2010 by Reena Leone

Exactly one year ago today, I took an in depth look at different pieces of HBO’s integrated marketing campaign for True Blood. The show is now in its third season and HBO is still continuing to make the vampire world of Bon Temps a reality. Just when I thought I couldn’t possibly love their marketing any more, they bring in baby vamp Jessica and her blog.

Read full article

"Please tweet to speak with a customer service representative…"

August 06, 2010 by Reena Leone

Tuesday was quite a day for me in terms of customer service help via Twitter. I have read the case studies on companies like Comcast and Zappos using Twitter to provide better customer service, but I wanted to shed some light on other companies using Twitter to help customers.

Read full article

Excel Tricks Part 3: Excel 2003 Compatibility

August 05, 2010 by Logan Gordon

While most of the analytics team has the 2007 version of Microsoft Office, it is not uncommon for client organizations, or individuals within those organizations, to have the outdated 2003 version of Excel. Because of this, it is important that Excel client deliverables are 2003-compatible so that users with old version of the software can still open and view their reports. What follows is a series of tips for making sure that documents written in Excel 2007 can be opened and viewed in Excel 2003 without any problems.

Read full article

The George H. Hill Building

August 03, 2010 by Brian Cordova

As Digitaria’s newest (and slightly intimidated) intern, I was soon to discover that on the first day of the job I was given probably the most unexpected assignment: write a blog for the website.

Here I am equipped with a notepad for taking multiple Starbucks orders, and instead they decide to blindside me with an actual cool and meaningful task. What more can an intern ask for on his first day? I am officially spoiled. The subject: Digitaria’s office space and historical structure in the heart of the Gaslamp District – The George H. Hill Building.

Read full article

Excel Tricks Part 2: Calculating Averages of Calculated KPI

August 02, 2010 by Christine Wu

Analytics reports often contain calculated data such as 4 week or quarterly averages to provide bases for comparison. When calculating  values such as 4 week averages for calculated metrics and/or KPI (e.g. bounce rate, page views per visit), it is important to calculate the averages from the individually calculated KPI per the date range's granularity (i.e. day, week, month). Averages calculated from the averages of the individual numerator and denominator values may often give you different results. Why might this be important? Consider the examples above.

Read full article

Excel Tricks Part 1: Auto-sorting Data

August 02, 2010 by Logan Gordon

The purpose of this post is to teach how to create auto-sorting for data within Excel, without having to manually click Sort. This how-to is especially targeted for those who need to sort Omniture's ExcelClient data blocks.

Read full article