Aggregating Social Media Results and Google Analytics
At a minimum, I’m beginning to appreciate Twitter (and my new fave tool TweetDeck) as a better-than-delicious RSS feed. It is showing me what people that I personally know are smart and on-the-pulse of online activity are doing right now. Assuming they choose to share.
Case in point: Katherine Maynard (@KMaynard_SCC) tweeted about ClickZ’s article on measuring social media metrics: Social Media Sites Force Analytics Tools to Evolve. I was very excited to start reading the article because one of my main roles on the Army’s FOS project was to track and analyze all of the campaigns activity…not just log files and Google Analytics, but what we could learn from visitor activity on Facebook, YouTube, and Flickr. I was disappointed once again to learn that the samples they cited were either 1) just tracking referrers or PPC Facebook ads, or 2) built their own app to track visitor lifetime value/interaction over time. Another point that caught my attention was that Experience Project gets most of their referrals through organic search.
We found in the FOS project that our external social media destinations were covering about 50% of the first page of Google for our key phrases. We also discovered that half of our campaign activity was occurring on the social media channels we set up and that the statistics available from each varied and had to be manually aggregated with the others to create a monthly analysis report that allowed us to create completely educated recommendations. I got pretty quick at it and produced some insightful reports, but I also know that we will be doing this for every client we can. And I don’t want to do it manually each time!
So starts my quest to automate the aggregation. Awhile back, I learned of tools/companies like ComScore, Quantcast, BlogPulse, Converseon, and BuzzMonitor but have never had the time to conduct research on them that wasn’t directly tied to a paying client project. Now, I have the opportunity to look into this periodically to see what is already out there without paying an arm and a leg, and what could be built. I know that we can use APIs like Facebooks to pull their Insight Statistics and Fan/Group data, but run into issues like Facebook not indexing their FQL page_fan.page_id field which means that it isn’t easy to pull data on your fans through a custom PHP application.
So anyway, I’ll keep you updated on where this goes and what I learn.
Tags: measurement, social networking, statistics, web 2.0






May 25th, 2010 at 10:58 pm
hey,just observed your web-site when i google something and wonder what hosting do you use for your web site,the speed is more faster than my website, i really need to know it.will back to check it out,thanks!
May 26th, 2010 at 7:49 am
Hi Molly,
I use GoDaddy’s basic shared hosting package. It isn’t necessarily the hosting provider that accounts for all the speed. I make sure that the code and assets used on the site are optimized and compressed. You can easily trim 100KB off a web page by programming it properly which significantly speeds things up. The funny thing I’ve found is that clients mistakenly haven’t been too concerned about the load time of their pages, assuming all their visitors have decent connections now. But with the popularity of mobile web browsing and iPad-type devices keeping us using Wi-fi or 3G at best, speed is still an important consideration.
September 5th, 2010 at 9:07 am
Buy:Benicar.Seroquel.Aricept.Acomplia.SleepWell.Zetia.Advair.Lipitor.Zocor.Lasix.Buspar.Ventolin.Female Cialis.Amoxicillin.Prozac.Wellbutrin SR.Nymphomax.Lipothin.Female Pink Viagra.Cozaar….
September 6th, 2010 at 5:27 am
Buy:Female Pink Viagra.Benicar.Zocor.Buspar.Ventolin.Cozaar.Lasix.Acomplia.Lipothin.Amoxicillin.Female Cialis.Advair.Prozac.Aricept.Lipitor.Zetia.Nymphomax.Wellbutrin SR.SleepWell.Seroquel….
September 7th, 2010 at 12:15 am
Buy:Prednisolone.Arimidex.Zovirax.Accutane.Prevacid.Synthroid.Mega Hoodia.Nexium.Lumigan.100% Pure Okinawan Coral Calcium.Actos.Petcam (Metacam) Oral Suspension.Human Growth Hormone.Retin-A.Valtrex.Zyban….
November 11th, 2010 at 6:18 pm
…
BUY FASHION. TOP BRANDS: GUCCI, DOLCE&GABBANA, BURBERRY, DIESEL, ICEBERG, ROBERTO CAVALLI, EMPORIO ARMANI, VERSACE…
December 20th, 2010 at 12:22 pm
abilify side effects in children…
Buydrugs without prescription…
December 28th, 2010 at 4:12 pm
Advair@official.site” rel=”nofollow”>.…
Buynow it…
December 30th, 2010 at 10:22 am
Ampicillin@official.site” rel=”nofollow”>.…
Buynow it…
December 31st, 2010 at 2:10 am
..…
Buygeneric drugs…
January 1st, 2011 at 8:08 am
Augmentin@official.site” rel=”nofollow”>.…
Buywithout prescription…
January 1st, 2011 at 4:41 pm
Clonidine@official.site” rel=”nofollow”>……
Buynow…
January 2nd, 2011 at 4:49 am
celexa@canada.now” rel=”nofollow”>.…
Buynow…
January 17th, 2011 at 4:29 am
Abilify@official.site” rel=”nofollow”>……
Buynow…
January 17th, 2011 at 7:20 am
Abilify@official.site” rel=”nofollow”>……
Buynow it…
February 5th, 2011 at 3:32 am
Zocor…
Buygeneric meds…
February 6th, 2011 at 11:51 pm
dog zyrtec…
Buygeneric drugs…
February 7th, 2011 at 11:37 am
Vytorin…
Buynow…
March 2nd, 2011 at 11:54 pm
Zyvox…
Buydrugs without prescription…
March 6th, 2011 at 7:43 am
Retin A…
Buygeneric drugs…
March 9th, 2011 at 2:00 am
howard county purim carnival 2010…
Buyno prescription…
March 9th, 2011 at 1:15 pm
Risperdal…
Buygeneric pills…
March 11th, 2011 at 12:55 am
low dose haldol and paxil…
Buygeneric drugs…
March 29th, 2011 at 8:28 am
Tri@Cyclen.now” rel=”nofollow”>……
Buyno prescription…
March 29th, 2011 at 4:32 pm
Soma@Soma.Soma” rel=”nofollow”>.…
Buyno prescription…
March 30th, 2011 at 9:59 am
Purim@Purim.Purim” rel=”nofollow”>……
Buygeneric drugs…
March 30th, 2011 at 7:03 pm
Singulair@Singulair.Singulair” rel=”nofollow”>……
Buygeneric pills…
March 30th, 2011 at 8:12 pm
Prozac@Prozac.Prozac” rel=”nofollow”>.…
Buygeneric pills…
March 31st, 2011 at 11:05 am
Singulair@Singulair.Singulair” rel=”nofollow”>.…
Buygeneric drugs…
April 2nd, 2011 at 11:28 am
allegra@print.colorado.springs” rel=”nofollow”>……
Buygeneric drugs…
April 4th, 2011 at 12:30 pm
alternatives@to.premarin” rel=”nofollow”>……
Buygeneric pills…
April 4th, 2011 at 11:43 pm
altace@generic.name” rel=”nofollow”>.…
Buynow it…