New Digital Marketing Analytics Report shows social media is not the best source of acquiring customers:


It’s great to see Insights that data can uncover. I saw a nice insight in a report I read about Analyzing customer acquisition channels for e-commerce sites and in this blog post, I am sharing it with you. So what are the top customer acquisition channels for Commerce sites? The Top channels are Organic Search, Emails & Paid Search.Here’s the report: E-Commerce Customer Acquisition Snapshot

It was not surprising to me to see Organic Search and Emails being among the Top customer acquisition channels but what surprised me was  relatively poor performance of social media in acquiring customers. Here’s the chart showing performance of various online channels for acquiring customers:

ecommerce analytics percentage of customer acquired vs. channel

Data Source:

Note #1: The post is NOT about devaluing the benefits of social media and it comes to down to understanding the goals of having a social media presence in the first place. While computing the ROI of social media, there are other factors like increased brand awareness, customer loyalty to be considered. But I posted this data because it’s a great way to show how data can uncover insights and sometimes it may surprise you

Note #2: The percentage of customers acquired does not add up to 100% for a year because the data does not include things like direct traffic. The author of the report confirmed it over an email w/ me.

That’s about it for this post. Your comments are very welcome!

Three Data Collection Tips for Social Media Analytics


Data integrity is important especially if critical business decisions are based off on data. To that extent, in this post, I’ll write about five data collection tips to help you have accurate data for “social media analytics”. So here are the tips that are applicable to social media analytics irrespective of the tool you are using:

1. Social Media Platform


Select the right social media platform for capturing data. You do not want to select few such that you miss data.And you do want to select irrelevant social media platforms because if you do, then you’ll introduce noise in the data. Let me take an example. If your project needs to be based on USA only then you do not need to add “sina weibo” (Chinese social network) in your social media sources.

Now, Based on your business need for “social media analytics” campaign, you should test all possible social media platforms – you never know who might be talking about things that you are interested in. After you have selected the right social media platforms for your project, let’s go the next step:

2. “Search Keyword” Selection

Some of the social media platforms let’s you collect data via “search keywords”. Like twitter allows you to collect data via “hashtags” and/or keywords. So if you want to collect data about all social media posts having “american airlines” then you should not collect data using:


If you select the above rule, then it will introduce a LOT of noise because we’ll collect data people talking about just “American” PLUS data about people talking about just “airlines”. That’s bad!  What you want is rules like these:

1. American AND airlines

2. “American Airlines” (as a phrase)

american airlines social mediaNow, I can’t stress the importance of selecting the right search keywords enough. Choosing wrong keywords will add noise that would be bad for analytics. So choose keywords such that you are not adding noise as well as not missing on conversations. There’s no secret formula here, continuous improvement is the way to go!

3. Language & country Filtering


Social networks are GLOBAL in nature and so it’s important to filter (or include) based on the project that you’re working on. Not doing so would add noise in your data. And also remember to include country and language because you do not want to miss out on conversations either.


Three Data Collection Tips for Social media analytics that I shared in this post are:

1. Select Right Social Media Platform

2. Select Right search keywords

3. Select Right Country and Language.

Guest Blog: How to measure ROI of Social Media Marketing?



This is Guest Blog by Jugal Shah. Jugal is pursuing MBA w/ focus on Marketing from a premier university in India. He shares his views on marketing, sales and strategy via his Blog & Facebook.In this post, He briefly comments on “How to measure Social Media Marketing ROI”.

Jugal Shah’s Short post on Measuring Social Media Marketing ROI:

In social media marketing, ROI is not in just monitory terms. So, for social media ROI, my focus would be on
1) to how many people I have reached
2) How many people I have engaged through online activities
3) Becoming a conversation enabler and perception driver

Then focus on

1) how much increased revenue is due to social media reach (you can do this by tracking referred link)
2) How many leads you generated through social media
3) How social media efforts helped to resolve customer query/problems and led to more customer satisfaction (remember customer acquisition cost 10 times more than customer retention cost).

In a nutshell, It’s of utmost important to use Social Media as:

  • conversation enabler
  • perception driver
  • customer retention


Paras: Jugal, Thanks for this post. I am sure, this short post would be a great food for thought for readers who are interested in Digital Marketing Analytics or analytics in general. Readers, Feel free to reach out to him on his blog and/or Facebook page.

Things I shared on Social Media Networks during Noc 12 – Dec 31 (2012)


Big Data: The Coming Sensor Data Driven Productivity Revolution

Check out some nice getting started tutorials at beyondrelational site:

Complexity is your enemy. Any fool can make something complicated. It is hard to make something simple – Richard Branson

— via Paras Doshi – Blog

The success of companies like Google, Facebook, Amazon, and Netflix, not to mention Wall Street firms and industries from manufacturing to retail and healthcare, is increasingly driven by better tools for extracting meaning from very large quantities of data,” says Tim O’Reilly

— via Paras Doshi – Blog

Nice collection of about 20+ videos around the topic of “Data Science”:

Nice collection of videos by Berkeley school of information: #Information #Data

Just found Facebook’s data team’s page:

via V Talk Tech – A Parth Acharya Blog – Nice HeatMap of stocks!

what’s the biggest fear about cloud computing? via Windows Azure

Resource: Presentations from the Sentiment Analysis Symposium

If I switched to the newest “holiday” theme on WordPress, this is how it would look:

Nice! Code School now has R programming language! I have been playing with R for a while now and definitely want to learn more – here’s the link to learn R:

Interesting tool from Google to optimize and analyze web page speeds:

Performed #sentiment #Analysis on #starbucks twitter data using #R ! It was fun!

In 2002: The Data Warehousing Institute estimates that data quality problems cost U.S. businesses more than $600 billion a year. And of course, over the past 10 years, this number would be bigger.

Reading: Business Analytics vs Business Intelligence?

Big data is a nickname for the recent increase in largely external and unstructured business and consumer information. How are businesses across industries harnessing traditional enterprise information management functions and systems to translate big data into useful business intelligence?

For business analytics professionals: 12 webcasts on Jan 30th 2013 #sqlpass #analytics #24hop

Some nice insights about how to build an Internet platform, from the founder of Zipcar:

Let’s connect and converse on any of these people networks!

paras doshi blog on facebookparas doshi twitter paras doshi google plus paras doshi linkedin

Two ideas to make your social network activities “Searchable”:


Some time back, I wanted to search one of my own social network post. It was a resource I had shared and somehow I was not able to “google” it (again). I eventually found it – but it took me 15 odd minutes to scroll down to my twitter feed. It was NOT fun! And I thought to myself – there’s got to be a better way! And I thought – It’ll be great if I solve it for not just Twitter but all my social network activities that includes LinkedIn, Facebook Pages, Google+. So here’s couple of things thats working for me, I hope it helps someone out there too:

Now, before we begin when I say “Searchable” – I mean searchable by YOU (or a human being) and not necessarily search engines. But it turns out, both my ideas increase your chances of getting your social media activities Indexed! With that, Here are the ideas:

1) Syndicate your Social Network Activities (Posts/Images/Updates) to Tumblr/Blogger

I use IFTTT to syndicate my Twitter, Facebook and LinkedIn activities to Blogger

2) Create a post about your social network activities on your blog:

Here’s an Example: Things I shared on Social Media Networks during Oct 19 – Nov 11

Though Idea #2’s main goal is to keep my blog readers updated about my social network activities – But it also acts as a good way to make my social media posts “searchable”.

And remember I said earlier that the chances of your social network posts getting indexed by search engines increases? That’s because WordPress, Tumblr & Blogger’s posts are accessible by Google (unless you choose to block it). So that’s about it for this post. If you like the idea(s), please let me know! And if you have other ideas – also let me know, I am always looking for ways to make my social media activities easily searchable to me as well as for anyone else.

Let’s connect and converse on any of these people networks!

paras doshi blog on facebookparas doshi twitter paras doshi google plus paras doshi linkedin

Things I shared on Social Media Networks during Oct 3 – Oct 10


I am fairly active on social network channels. I engage with people on Social networks and I thought It would be great if my blog readers also get a recap of conversations I am having on different social networks and so I’ve thought of compiling a “Things I shared on Social Media networks during the week” . Here is the recap for the week of OCT 3 – OCT 10:

1. Gaurang Patel commented about the Blog: “Five things I like about RescueTime” on FB page: i am using this one it is really fantastic . 

The blog is here: Five things I like about RescueTime:

Gaurang Patel on Five Things I like about RescueTime

2. Photo with a caption that I added:  That’s the CLOUD.

Originally shared by Windows Azure account

That's the cloud windows azure servers data centers

3. Quote my APJ Abdul Kalam (Ex-President of India) . Did you knew that in 2011, I got a chance to meet him! Read here: Met revered APJ Abdul Kalam (Ex President, India) at an event organized by Times Foundation

Quote by APJ Abdul Kalam

4. Nice Data Visualization: Originally shared by and link to the source of the data Visualization:

Nice Data visualization paras doshi

5. “I was working on Business Intelligence project requirement analysis. One requirement that I saw across all department: Need a data mart (single version of truth)”

This post was shared by SolidQ on Google+

Enterprises need data mart and data warehouses

6. On G+, SolidQ shared my post that I wrote a while Back. Here’s the post: Step by Step guide to Export a SQL Azure Database to Azure storage via Import and Export CTP

SolidQ shared paras doshi blog on Google plus

BTW, did you knew the same blog post was Re-Tweeted by Scott Gu on 31st Dec 2011! Yup!

Scott Gu RT'ed Paras Doshi's Tweet

7. RescueTime tweeted:

Check the end of this post to see how RescueTime user @Paras_Doshi was able to cut his social networking time in half!

8. SolidQ shared this post: “Earlier Today: delivered a two-hour session on PowerPivot and Power View to a client. they had some very Interesting questions for their scenario!”

paras doshi delivered a power pivot and power view session solidq

9. SolidQ shared this post on G+:

Data Visualization: Created HeatMap/TreeMap like the one shown below for a client. Looking forward to receiving their feedback. btw, I used the Black, Grey and white for the shades. image courtesy:

paras doshi created a heat map for a client at SolidQ

Let’s connect and converse on any of these people networks!

paras doshi blog on facebookparas doshi twitter paras doshi google plus paras doshi linkedin

How to add External Links to Facebook Page Tabs?


I figured a way to add External Links to my Facebook Page – In this blog-post I’ll share how I did that. It’s not a native feature and I have resorted to a third-party app to get this functionality. Here’s the Blog-Post:

This is how my Facebook page Tabs looks after I completed the process.

paras doshi faecbook page google plus twitter

You can see it is linked to my Blog, Twitter and Google+ from my Facebook page tab.

Before we start. you should have the proper admin permissions to install app to a Facebook page as we are going to use a third-party app for this blog-post. Here are the steps involved:

1) > click on Go to App that’s right besides like button > click on “install page tab”

2) select the Facebook Page and click on add page tab

3) Authorize Tab application (review the permission requests before agreeing)

4) Can you see the Tab Settings Page?

add external link facebook pages tab settings

*NGO XYZ is just a page that I created to show this. Ignore the phrase when you see that.

5) I want to redirect it to say

So following are the settings that I chose:

Tab Name: Twitter

Page Source: redirect

And I entered the URL that It will get redirected to:

twitter paras doshi social media

6) I am going to leave other choice as default for now. You could explore it for advanced options like “this tab will only be visible to your fans and invisible to your non-fans” among other things.

click on Save Settings.

7) Can you see the new tab?

new tab twitter external link via facebook page

8) Test it!

9) Come back on your page. Now – Don’t you want to change the Image? Yes? Go to Edit settings for this Tab:

how to edit settings of facebook page tab

10) click on “change” for custom tab image. And Now, upload the custom image.

When done – come back to your page. Can you see it? yes? Great!

external link to twitter on facebook page

11) To add more Tabs. click on this tab as “page administrator”

when prompted about “Do you want to be redirected?”. click on cancel

click on settings from the admin tab options.

and another tab:

add multiple external links on facebook page tabs

Limit seems to 10 tabs.

And once you click on “HTML Page Tab #n”, then you’ll have to repeat the steps about configuring the settings for this tab.

That’s about it!


If you want your Facebook page to point to your (or your organizations) presence on other social media networks – then now you know how you can add external links and point your Facebook page fans to Google+, Twitter, Website, Blog among other things.


Are there any other cool facebook page techniques that you now of, I’ll be glad to learn about it – Please do post it in the comment section (along with your facebook page url! )


Related Articles:
1. Social Media Analytics. Facebook Page Smackdown: Status updates vs Images?
2. Five things I learned about “Art of report designing” from Facebook insights.

A nice Data Visualization on User’s Twitter “Text Data”:


You know I like beautiful Data Visualizations! Here’s one about my Twitter Data via Vizify:

Data a Twitter User's tweet visualized

Are there any other service out there that let us create beautiful (and meaningful) data visualizations on our twitter data? Do leave a comment!

Related Posts:

1. Visualizing search engine terms (words) via Word cloud a.k.a word frequency visualization tool

2. TED Video: Visualizing the medical data explosion by Anders Ynnerman

3. Ted Video: The beauty of data visualization by David McCandles

4. Hans Rosling’s Ted videos

And Let’s connect! I Look forward to Interacting with you on any of these people networks:

paras doshi blog on facebookparas doshi twitterparas doshi google plusparas doshi linkedin

Social Media Analytics. Facebook Page Smackdown: Status updates vs Images?


In this post, we’ll answer the question:

For a Facebook page – which post-type* is better at getting more Likes + Shares + comments

*Currently on Facebook page – you can have following Post-Type:

1. Images

2.Status Updates (Post)

3. Videos

4. Link

5. Question

6. Shared Content (i.e. when you “share” content from other Facebook page/user-account)

Now – If you have not seen “Facebook Insight”s for your Facebook page – I’ll encourage you to do that (assuming you have suitable admin role):

view facebook page insights social media analyticsYou’ll see something like this:

facebook page insights dashboard social media analytics

Off-Topic: I like how this report design, I really do: Five things I learned about “Art of report designing” from Facebook insights.

Now, Be a Kid – explore this Dashboard – see what else you’ve got: Likes Metrics, Reach Metrics, Talking about this Metric. There’s interesting Demographic information on each of the mentioned metrics. For instance I know that 60% of my fans are from India. Any-who this post is not about delving into what is available but it is about something that is not available via this Dashboard.

So Now I had this Question: What kind of post should I post more to get more likes/shares/comments? Should I post Images? Should I share Interesting Links? Thus, I wanted to know: For a Facebook page – which post-type is better at getting more Likes + Shares + comments

So as a Data Guy – since they didn’t provide that insight – I thought of a way to get it. Here’s how you can do that too in a step by step fashion:

Tool Used: Excel 2010

Step 1.

On your Facebook Page Insights Dashboard – Do you see Export Data button? yes? Go ahead click it:

– Select a. Post Level Date b. Select Start Time & End Time.

social media analytics download facebook page insights data

Step 2. 

Open the file in excel.

If you do not have access to file that you can use mine – after all the things I share on is Public! I don’t mind sharing metrics with you. Download the file: Paras Doshi Blog Facebook Page Post Level Metrics Jan1 Aug5 2012

Step 3:

There’s lot of data, right!? Remember: If you think about it, You can extract other actionable insights too and build cool reports.

Any-who to our questions here is what we need:

a. Data in “Key Metrics” sheet

b. Column C: “Type”

c. Column N: “Lifetime Talking About This (Post)”

*People Talking about this include

– Liked, commented or shared your post

– answering a question

– responding to an event.

FYI: if you looking to see number of likes, shares & comments a post gets – check out “Lifetime Talking about this..” excel sheet.
Step 4:

Create a COPY of this Excel File (For Backup purpose – Just in case we manage to mess up the data in this file)

AND then, Delete ROW 2 in Excel sheet: “key Metrics”. Just do it!

delete a row in excel

Step 5:

Now that we have identified the metrics i.e “TYPE” and “Lifetime Talking About This (Post)” – let’s select ONLY this data and create a new sheet. As you can see I have a new sheet titled “Only Important data goes here!”

social media analytics new sheet in excel

You can Skip creating a NEW sheet – but make sure to select appropriate columns for PIVOT TABLE later.

Step 6

Make sure you are on our NEW sheet.

Go to Toolbar > Insert > PivotTable > Select Pivot Table

Social media analytics using excel pivot table

Step 7: No change, Just click on OK.

configure pivot table in excel 2010

Step 8:

Now comes the part where we configure Pivot Table.

– Select All three fields from the “Choose Fields to add to report”

– Drag “Count of Post ID” and “Count of LifeTime talking about this” from Row Labels -> Values

social media analytics facebook page configure pivot table

Step 9:

We do not want the TOTAL number of “People Talking about it” – BUT we want On an Average – for a single post – How many people are “talking about this”.

So let’s change the function of “Life Time Talking about this” to AVERAGE.

Just (left) click on “Count of Lifetime Talking about this (Post)” > and select “Value Field Settings”

pivot table change the function from SUM to Average

click on OK.

Step 10

Do you see this:

pivot table change the function from SUM to Average changed

Now Look at your Pivot Table:

Social Media analytcis for a facebook page

Can you see who won.

In the smack down of Status Updates vs Photo. Photos Won!*

*For my page: That may not be true for all pages! Just saying 🙂

And let me clean up the report a bit:

social media analytics custom dashbaord in excel for facebook page

That’s about it!

Remember you can do MUCH MORE with the Data that you just DOWNLOADED! If you play with this data, please share what actionable insights you were able to extract out the data!

Have fun with Data!


Facebook Page Insights Guide. From your Insights Dashboard:

facebook page insights guide pdf

This is cool: Microsoft project codename “Social Analytics”


Microsoft project codename “Social Analytics” is one nice beta project! Quoting from it’s site

“it is aimed at developers who want to integrate social web information into business applications”

But the KEY here is that it allows you to integrate FILTERED social web information into your business applications. Today, you could go ahead – grab a twitter stream data – embed it in your application but guess what? In most cases, it’s too much information. Too much information means, that it’s very difficult for business-folks to take actions by analyzing these truckloads of information. And so:

even though we are data-rich – we are information (insight) poor.

My point being, that tons of information PRODUCED by [customers, partners, critics, employees..] GATHERED from [Twitter, Facebook, Linkedin, Blogs…] is NOT useful in it’s raw form. To take actions based on all these data-points – what we need is a way to categorize data (filter data) which would help the decision maker in seeing only SMALL part of data-set he/she needs for performing that particular analysis.

Let’s take an example:

A business-decision-maker wants to see “All twitter-users who have posted positive reviews about Windows 8 Design and User Experience”

How would you solve it?



Easy? hard?

Thinking of writing your own Sentiment Analyzer? awesome, & Good Luck!

Any-who, may be you know it’s not straight-forward to answer the above question using raw twitter data.

But here’s the thing you could use Third-party tools to solve the problem. Don’t get me wrong, I am not asking you to ignore them. But here’s how Microsoft Social Analytics helped me solve the above problem:

social analysis windows 8 design and user experience

Here’s how I FILTERED the data: (It’s a thing called Social Analytic Engagement client) microsoft social analytics filter data enagagement client

And as you can see there are more than one ways you can slice/filter your data to provide a view that is best suited for a particular analysis assignment.

Please note:

1. Currently in beta: only two data-sets are available i.e. Bill Gates & Windows 8.

2. Apart from this nicely designed web based engagement tool, you can integrate the information into applications using Social Analytics API.


Check out Microsoft Codename “Social Analytics”! Today, it’s here: (you’ll need an invite to try out social analytics.