print this page save to favorites

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.

Learn more about the Army Faces of Strength Campaign.

Learn more about the Army Faces of Strength Campaign.

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: , , ,

32 Responses to “Aggregating Social Media Results and Google Analytics”

  1. Molly Tsang Says:

    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!

  2. admin Says:

    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.

  3. RANDY Says:


    CheapTabletsOnline.com. Canadian Health&Care.Best quality drugs.Special Internet Prices.No prescription online pharmacy. Low price drugs. Order pills online

    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….

  4. MATT Says:


    CheapTabletsOnline.com. Canadian Health&Care.No prescription online pharmacy.Special Internet Prices.Best quality drugs. No prescription pills. Buy pills online

    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….

  5. FERNANDO Says:


    CheapTabletsOnline.Com. Canadian Health&Care.No prescription online pharmacy.Special Internet Prices.Best quality drugs. Low price pills. Order pills online

    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….

  6. JEFFERY Says:


    NEW FASHION store. Original designers collection at low prices!!! 20 % TO 70 % OFF. END OF SEASON SALE!!!

    BUY FASHION. TOP BRANDS: GUCCI, DOLCE&GABBANA, BURBERRY, DIESEL, ICEBERG, ROBERTO CAVALLI, EMPORIO ARMANI, VERSACE…

  7. LONNIE Says:

    abilify side effects in children

    Buydrugs without prescription…

  8. EUGENE Says:

    Advair@official.site” rel=”nofollow”>.

    Buynow it…

  9. KELLY Says:

    Ampicillin@official.site” rel=”nofollow”>.

    Buynow it…

  10. LARRY Says:

    ..

    Buygeneric drugs…

  11. ALBERTO Says:

    Augmentin@official.site” rel=”nofollow”>.

    Buywithout prescription…

  12. RICK Says:

    Clonidine@official.site” rel=”nofollow”>…

    Buynow…

  13. RICK Says:

    celexa@canada.now” rel=”nofollow”>.

    Buynow…

  14. DOUGLAS Says:

    Abilify@official.site” rel=”nofollow”>…

    Buynow…

  15. HUBERT Says:

    Abilify@official.site” rel=”nofollow”>…

    Buynow it…

  16. CLINTON Says:

    Zocor

    Buygeneric meds…

  17. REGINALD Says:

    dog zyrtec

    Buygeneric drugs…

  18. STUART Says:

    Vytorin

    Buynow…

  19. ALFONSO Says:

    Zyvox

    Buydrugs without prescription…

  20. KELLY Says:

    Retin A

    Buygeneric drugs…

  21. TERRANCE Says:

    howard county purim carnival 2010

    Buyno prescription…

  22. AARON Says:

    Risperdal

    Buygeneric pills…

  23. ROBERTO Says:

    low dose haldol and paxil

    Buygeneric drugs…

  24. CLAUDE Says:

    Tri@Cyclen.now” rel=”nofollow”>…

    Buyno prescription…

  25. GEORGE Says:

    Soma@Soma.Soma” rel=”nofollow”>.

    Buyno prescription…

  26. SAM Says:

    Purim@Purim.Purim” rel=”nofollow”>…

    Buygeneric drugs…

  27. EDGAR Says:

    Singulair@Singulair.Singulair” rel=”nofollow”>…

    Buygeneric pills…

  28. TYRONE Says:

    Prozac@Prozac.Prozac” rel=”nofollow”>.

    Buygeneric pills…

  29. SEAN Says:

    Singulair@Singulair.Singulair” rel=”nofollow”>.

    Buygeneric drugs…

  30. MANUEL Says:

    allegra@print.colorado.springs” rel=”nofollow”>…

    Buygeneric drugs…

  31. KIRK Says:

    alternatives@to.premarin” rel=”nofollow”>…

    Buygeneric pills…

  32. ADRIAN Says:

    altace@generic.name” rel=”nofollow”>.

    Buynow it…

Leave a Reply

  • cell 301.240.9494
  • land 703.337.5149
  • fax 703.991.1105
  • Alexandria, Virginia
  • © 2010 Back Pocket Media
  • Back Pocket Media : Your ebusiness experts
  • Providing interactive strategy, design and development to the DC-metro area for over 15 years
  • Valid XHTML 1.1
  • Jess Ferko is a member of the National Association of Professional Women
  • We support honesty in business communication; join us.