Community Management, Social Media Strategy, Social Media Tools, Social Media Marketing, Social Media Monitoring

How to Create a Share of Voice Report

Youtility Cover transparent1 e1365439705647 How to Create a Share of Voice Report

Do you have your copy of Youtility: Why Smart Marketing is About Help not Hype? Visit Amazon or Barnes & Noble to get your copy now!

Social Mention is a free Web site that monitors and organizes social media chatter on Twitter, blogs, discussion forums, and elsewhere. Social Mention is not nearly as powerful or customizable as paid social media monitoring software like Radian6, Scoutlabs, or Spiral16, but it’s free and easy to use.

Once you launch your social media program, you may want to investigate paid social monitoring software to alert you to opportunities, keep closer tabs on the competition, find influencers in your industry, etc. Nearly all companies in the social software business offer free trials. While I recommend the three above, a good list of all the social listening software providers is at http://wiki.kenburbary.com

Online, are people talking more about your company, or your competitors? Let’s find out.

social mention share of voice 300x169 How to Create a Share of Voice Report
1. Search for Yourself
Go to www.socialmention.com. Click “all” on the row of tabs. Then, enter your organization’s name in quotes (“organization name”) and click search. The quotes will ensure that results include only exact, relevant matches.

It may take a few seconds for Social Mention to produce results, as it has to scan a lot of data.

On the results page, you’ll see at the top the number of total mentions of your organization in social media over the past 30 days. (You can change the date range with the pull-down that says “anytime”. The default is 30 days, and Social Mention only stores 30 days worth of data).

Look through the search results to find areas where your organization is being mentioned, by whom, and in what context. It may be easier to scan results by sorting them by Source. Use the “Sort by” pull-down to make that change.

2. Search for Competitors
Go back to Social Mention. Search for your competitors the same way you searched for your own name.

3. All Mentions are NOT Good Mentions
On the left hand side of Social Mention search results, you’ll see a chart labeled “Sentiment”. This tracks whether social commentary about your organization was positive, neutral, or negative. Enter those values into the
Convince and Convert Share of Voice Worksheet.

social media share of voice worksheet1 247x300 How to Create a Share of Voice Report
The Share of Voice Worksheet automatically calculates average sentiment of all mentions, on a five point scale, where 1 is a negative mention, 3 is a neutral mention, and 5 is a positive mention.

Presto! Now you know who’s dominating the social media conversation within your category.

DOWNLOAD THE SPREADSHEET HERE (.xls) or (.xlsx)

Recognize that this is a very rough report. You will almost definitely get some search results from Social Mention that do not actually apply to you or your competitors. You can sort those in Excel by exporting the report, but please remember that this is a very basic version of share of voice for quick comparison purposes only.

  • Pingback: DrSocialMedia (SocialMediaMarketing)

  • Pingback: web20_marketing (web 2.0 marketing)

  • Pingback: greggvm (Gregg Morris)

  • http://beyondfreelancing.com/ Jeffrey Tang

    Thanks for the tip. I’ll be trying Social Mention out later today :)
    .-= Jeffrey Tang´s last blog ..4 Effective Personal Branding Strategies You Forgot =-.

  • http://beyondfreelancing.com/ Jeffrey Tang

    Thanks for the tip. I’ll be trying Social Mention out later today :)
    .-= Jeffrey Tang´s last blog ..4 Effective Personal Branding Strategies You Forgot =-.

  • http://beyondfreelancing.com Jeffrey Tang

    Thanks for the tip. I’ll be trying Social Mention out later today :)
    .-= Jeffrey Tang´s last blog ..4 Effective Personal Branding Strategies You Forgot =-.

  • Pingback: CBWhittemore (CB Whittemore)

  • Pingback: standingpr (Standing Partnership)

  • Pingback: spiral16 (spiral16)

  • Pingback: SceneStealrEric (Eric Melin)

  • http://www.radian6.com/ Amber Naslund

    Jason,

    There you go again being useful. This is a GREAT resource for getting folks started. Bravo to you for putting together practical, helpful things that really make a difference for business. You impress the hell out of me regularly.

    Amber
    .-= Amber Naslund´s last blog ..March of Dimes® Selects Radian6 for Social Media Monitoring =-.

  • http://www.radian6.com/ Amber Naslund

    Jason,

    There you go again being useful. This is a GREAT resource for getting folks started. Bravo to you for putting together practical, helpful things that really make a difference for business. You impress the hell out of me regularly.

    Amber
    .-= Amber Naslund´s last blog ..March of Dimes® Selects Radian6 for Social Media Monitoring =-.

    • http://www.convinceandconvert.com/ Jason Baer

      Thanks so much. I’m just trying to keep up with you. Invoked you at least four times in my training workshop today, and demonstrated your soft touch with Twitter. Hugs to you, and thanks for the comment.

    • http://www.convinceandconvert.com/ Jason Baer

      Thanks so much. I’m just trying to keep up with you. Invoked you at least four times in my training workshop today, and demonstrated your soft touch with Twitter. Hugs to you, and thanks for the comment.

  • http://www.radian6.com Amber Naslund

    Jason,

    There you go again being useful. This is a GREAT resource for getting folks started. Bravo to you for putting together practical, helpful things that really make a difference for business. You impress the hell out of me regularly.

    Amber
    .-= Amber Naslund´s last blog ..March of Dimes® Selects Radian6 for Social Media Monitoring =-.

    • http://www.convinceandconvert.com Jason Baer

      Thanks so much. I’m just trying to keep up with you. Invoked you at least four times in my training workshop today, and demonstrated your soft touch with Twitter. Hugs to you, and thanks for the comment.

  • Pingback: chriskovac (chriskovac)

  • Pingback: cclaypoole (Cheryl Claypoole)

  • Pingback: InnovationTrend (Social Media)

  • http://www.kenburbary.com/ Ken Burbary

    Excellent topic Jason. I’ve been thinking about how a series of posts on the “nuts and bolts” of social media monitoring could be very beneficial to everyone out there getting involved with SMM. You beat me to the punch with a simple and effective guide.

    Thanks for mentioning the wiki of SMM tools. It has grown considerably since the launch and contains almost 100 specific tools (free and commercial) as of this morning. I intend to expand to include how-to’s and guides (much like this one) on to make it easier to get SMM implemented.

    Nicely done sir!
    .-= Ken Burbary´s last blog ..Five Reasons Companies Should be Integrating Social Media with Facebook Connect =-.

    • http://www.convinceandconvert.com/ Jason Baer

      Thanks Ken. I appreciate the comment. Terrific job on the wiki. Such a much-needed resource. Nearly 100 tools? Wow. Greg (from a couple comments ago) needs to tap into your treasure trove of options.

    • http://www.convinceandconvert.com/ Jason Baer

      Thanks Ken. I appreciate the comment. Terrific job on the wiki. Such a much-needed resource. Nearly 100 tools? Wow. Greg (from a couple comments ago) needs to tap into your treasure trove of options.

  • http://www.kenburbary.com/ Ken Burbary

    Excellent topic Jason. I’ve been thinking about how a series of posts on the “nuts and bolts” of social media monitoring could be very beneficial to everyone out there getting involved with SMM. You beat me to the punch with a simple and effective guide.

    Thanks for mentioning the wiki of SMM tools. It has grown considerably since the launch and contains almost 100 specific tools (free and commercial) as of this morning. I intend to expand to include how-to’s and guides (much like this one) on to make it easier to get SMM implemented.

    Nicely done sir!
    .-= Ken Burbary´s last blog ..Five Reasons Companies Should be Integrating Social Media with Facebook Connect =-.

  • http://www.kenburbary.com Ken Burbary

    Excellent topic Jason. I’ve been thinking about how a series of posts on the “nuts and bolts” of social media monitoring could be very beneficial to everyone out there getting involved with SMM. You beat me to the punch with a simple and effective guide.

    Thanks for mentioning the wiki of SMM tools. It has grown considerably since the launch and contains almost 100 specific tools (free and commercial) as of this morning. I intend to expand to include how-to’s and guides (much like this one) on to make it easier to get SMM implemented.

    Nicely done sir!
    .-= Ken Burbary´s last blog ..Five Reasons Companies Should be Integrating Social Media with Facebook Connect =-.

    • http://www.convinceandconvert.com Jason Baer

      Thanks Ken. I appreciate the comment. Terrific job on the wiki. Such a much-needed resource. Nearly 100 tools? Wow. Greg (from a couple comments ago) needs to tap into your treasure trove of options.

  • http://www.webdancers.com/ Greg Falken

    I had rather spotty results from Social Mention. Quoted searches returned many results that didn’t contain the phrase. I’d like to find some other free services to use in addition Google Alerts and Google Blog Search.

    Thanks for all your good advice.

  • http://www.webdancers.com/ Greg Falken

    I had rather spotty results from Social Mention. Quoted searches returned many results that didn’t contain the phrase. I’d like to find some other free services to use in addition Google Alerts and Google Blog Search.

    Thanks for all your good advice.

    • http://www.convinceandconvert.com/ Jason Baer

      Greg. Thanks very much for the comment. Sorry to hear you had some issues with Social Mention. Indeed, the paid tools offer a far superior overall experience. Check out Ken Burbary’s wiki of other free/paid tools. Perhaps look at icerocket.com

    • http://www.convinceandconvert.com/ Jason Baer

      Greg. Thanks very much for the comment. Sorry to hear you had some issues with Social Mention. Indeed, the paid tools offer a far superior overall experience. Check out Ken Burbary’s wiki of other free/paid tools. Perhaps look at icerocket.com

  • http://www.webdancers.com Greg Falken

    I had rather spotty results from Social Mention. Quoted searches returned many results that didn’t contain the phrase. I’d like to find some other free services to use in addition Google Alerts and Google Blog Search.

    Thanks for all your good advice.

    • http://www.convinceandconvert.com Jason Baer

      Greg. Thanks very much for the comment. Sorry to hear you had some issues with Social Mention. Indeed, the paid tools offer a far superior overall experience. Check out Ken Burbary’s wiki of other free/paid tools. Perhaps look at icerocket.com

  • Pingback: AmberCadabra (Amber Naslund)

  • Pingback: ellynnszoke (Ellynn Szoke)

  • Pingback: bkmacdaddy (bkmacdaddy designs)

  • Pingback: PlugYourBook (Steve Weber)

  • Pingback: syedbalkhi (Syed Balkhi)

  • Pingback: TheYaffeGroup (The Yaffe Group)

  • Pingback: nfiliatrault (Nicole Filiatrault)

  • Pingback: jlysne (Josh Lysne)

  • Pingback: kenburbary (Ken Burbary)

  • Pingback: adrianpittman (Adrian Pittman)

  • Pingback: alyce (alyce lindquist)

  • Pingback: hkotadia (Dr. Harish Kotadia)

  • Pingback: kellyroy (kelly roy)

  • Pingback: LorenMcDonald (Loren McDonald)

  • Pingback: scoutlabs (Scout Labs)

  • Pingback: TAANnews (TAAN)

  • Pingback: denmeister (Denny Erickson)

  • Pingback: markwschaefer (Mark Schaefer)

  • Pingback: Kinchie (Charlene Kingston)

  • Pingback: msullivan (Michelle Sullivan)

  • Pingback: BethHarte (Beth Harte)

  • Pingback: Kiki113 (Qiana)

  • http://jamiefavreau.wordpress.com/ Jamie Favreau

    I have used social mention to look seek out new information regarding a company I want to work for. I think this is a great tool and very useful.
    .-= Jamie Favreau´s last blog ..Better Late then Never! =-.

  • http://jamiefavreau.wordpress.com/ Jamie Favreau

    I have used social mention to look seek out new information regarding a company I want to work for. I think this is a great tool and very useful.
    .-= Jamie Favreau´s last blog ..Better Late then Never! =-.

  • http://jamiefavreau.wordpress.com Jamie Favreau

    I have used social mention to look seek out new information regarding a company I want to work for. I think this is a great tool and very useful.
    .-= Jamie Favreau´s last blog ..Better Late then Never! =-.

  • Pingback: infogatherer (Kathy Watcke)

  • Pingback: DR. WHAW? – August 27, 2009 « One true sentence.

  • Pingback: MatthewBotos (Matthew Botos)

  • Pingback: Sue_Anne (Sue Anne Reed)

  • Pingback: gregelwell (Greg Elwell)

  • Pingback: barbchamberlain (Barb Chamberlain)

  • Pingback: MOGISEO (MOGI)

  • Pingback: Bookmarks week 35 | Bijgespijkerd

  • Pingback: rachidt (Rachid)

  • Pingback: SAB_Riga (SAB)

  • Pingback: JohnFMoore (John Moore)

  • Pingback: KatrinaKibben (Katrina Kibben)

  • Pingback: shellykramer (Shelly Kramer)

  • Pingback: jessekanclerz (Jesse Kanclerz)

  • Pingback: mobilefriend (Alice)

  • Pingback: OliTab (Oliver Tabino)

  • Pingback: schoolmarketer (Dan Levine)

  • Pingback: gypsealeah (Leah Kaiz)

  • Pingback: pixelsebi (Sebastian Küpers)

  • Pingback: ImpactWatch (ImpactWatch)

  • Pingback: Monthly Mother Lode of MacDaddy Links: August 2009 | bkmacdaddy designs

  • Pingback: franswaa (frank barry)

  • Pingback: Findandconvert (Find and Convert)

  • Pingback: oneicity (Hoots and Thomas)

  • http://www.netwitsthinktank.com/ frank

    Jay, this rocks, but finding the right search words seems to be tricky. Any tips there?

    http://twitter.com/franswaa

  • http://www.netwitsthinktank.com frank

    Jay, this rocks, but finding the right search words seems to be tricky. Any tips there?

    http://twitter.com/franswaa

  • http://twitter.com/oneicity/status/3812747743 Hoots and Thomas

    RT @franswaa RT @jaybaer How to Create a Share of Voice Report — http://bit.ly/GlaGh [Great SM tool!]

  • madura

    Thanks for the great article. But i have a question what is average sentiment?

  • madura

    Thanks for the great article. But i have a question what is average sentiment?

  • http://YourWebsite madura

    Thanks for the great article. But i have a question what is average sentiment?

  • Pingback: RSSirteubal (Ignacio)

  • Pingback: RebeccaDenison (Rebecca Denison)

  • http://twitter.com/rebeccadenison/status/4372297932 Rebecca Denison

    Measurement is key, here’s an easy how-to for share of voice report http://bit.ly/13ldx0 Can apply to many other metrics

  • Pingback: RobertCollins (Bob Collins)

  • http://twitter.com/robertcollins/status/4467457865 Bob Collins

    social media monitoring software options http://bit.ly/mLkhM from @jaybaer

  • http://theonlyconstant.wordpress.com/ Hampus Landelius

    Thank you for an awsome review, its great when people give their knowledge without prestiege!

    Im testing different types of similar programs on my site and Im always open for news of this kind.
    My blogg is in Swedish but google translate is your friend ;)
    .-= Hampus Landelius´s last blog ..Sparks – Ett smart verktyg för analys av marknader! =-.

  • http://theonlyconstant.wordpress.com Hampus Landelius

    Thank you for an awsome review, its great when people give their knowledge without prestiege!

    Im testing different types of similar programs on my site and Im always open for news of this kind.
    My blogg is in Swedish but google translate is your friend ;)
    .-= Hampus Landelius´s last blog ..Sparks – Ett smart verktyg för analys av marknader! =-.

  • http://twitter.com/phuongvy_76/status/6560863143 Vy Nguyen

    RT @jaybaer How to Create a Share of Voice Report | Social Media Marketing | Social Media Consulting – Convince & Con… http://bit.ly/GlaGh

  • http://twitter.com/rssirteubal/status/7595293440 Ignacio

    How to Create a Share of Voice Report | | Social Media Consulting – Convince & Convert http://ow.ly/16j5aX

  • http://twitter.com/nblas/status/7671923435 Nicolas BLAS

    RT @Amalbel: Construire en quelques clics un TdB de veille sur XLS http://ow.ly/VCpW (Via @AmineDigirep )

  • http://twitter.com/seoadsenseman/status/7672047766 seoman

    RT @nblas: RT @Amalbel: Construire en quelques clics un TdB de veille sur XLS http://ow.ly/VCpW (Via @AmineDigirep )

  • http://twitter.com/dorotheecreteur/status/7675287973 Dorothee Creteur

    How to Create a Share of Voice Report with Social Mention http://bit.ly/5Yx454 via @aminedigirep

  • http://twitter.com/xdurand/status/7678942302 Xavier Durand

    RT @nblas: RT @Amalbel: Construire en quelques clics un TdB de veille sur XLS http://ow.ly/VCpW (Via @AmineDigirep )

  • http://twitter.com/clemcoool/status/7680313747 Clément Cochinard

    RT @nblas: RT @Amalbel: Construire en quelques clics un TdB de veille sur XLS http://ow.ly/VCpW (Via @AmineDigirep ) (via @seoadsenseman)

  • http://www.lorirtaylor.com/ lori taylor

    wow this is great…we are using Radian 6 but not exactly like this…I've shared with my team! keep them coming

  • http://www.jasonfpeck.com JasonPeck

    GREAT post and resource here. Very helpful! People might want to double check their sentiment ratings, since it's not always accurate. For example, “This post is wicked bad” would probably get labeled as negative by most monitoring solutions, even though the person's intent may have been for the statement to be positive.

  • http://www.me.com/sandivina sandivina

    Great blog!!!, I find you accasionally but I will follow you from now on. Thanks for your tips and advice.

  • http://twitter.com/godeck/status/9335750361 Hanny Godeck

    How to Create a Share of Voice Report | Social Media Marketing | Social Media Consulting – Convince & Con.. http://bit.ly/cYQTkE
    @myen

  • http://twitter.com/rssirteubal/status/9336523758 Ignacio

    How to Create a Share of Voice Report | Social Media Marketing | Social Media Consulting – Convince & Convert http://ow.ly/16CfYB

  • http://twitter.com/natecheeley/status/9351216300 NateCheeley

  • http://twitter.com/amvandenhurk/status/9351416194 amvandenhurk

    @NateCheeley Oh this looks promising. Thanks! Check it out, @jchernov: –>http://bit.ly/8g7iz

  • Ivy Smith

    I love this excel report. I've used Social mention before, but I love the analytics this puts into place.

  • http://twitter.com/tunderwood/status/9685779424 Tim Underwood

    How to Create a Free Share of Voice Report http://is.gd/92ZML Social Media Tool

  • http://twitter.com/tedspalding/status/9723885794 Ted Spalding

    How to Create a Share of Voice Report | Social Media Marketing | Social Media Consulting – Convince & Convert… http://is.gd/9j2WI

  • http://twitter.com/_senf_/status/9943165607 Jan-Hendrik Senf

    Wie man mit d. Tool @SocialMention u. einem (hier bereitgestellten) Excel-Template einen "Share of Voice" Report erstellt http://ow.ly/1dTLo

  • http://twitter.com/so_white/status/10481307392 so_white

    http://tinyurl.com/nj7gvb
    How to Create a Share of Voice Report | Social Media Marketing | Social Media Consulting – Convince & Convert

  • http://www.easyrecovery.ie/ Hard drive recovery

    This tips are really helpful in many ways.

  • http://twitter.com/rssirteubal/status/10996755148 Ignacio

    How to Create a Share of Voice Report | Social Media Marketing | Social Media Consulting – Convince & Convert http://ow.ly/16Sz9u

  • http://twitter.com/mikefiorillo/status/11444735734 Mike Fiorillo

    How to Create a Share of Voice Report | | Social Media Consulting – Convince & Convert http://bit.ly/xvsSw

  • http://twitter.com/hendersonbas/status/11444946168 henderson bas

    RT @mikefiorillo: How to Create a Share of Voice Report | | Social Media Consulting – Convince & Convert http://bit.ly/xvsSw

  • mikefiorillo

    I wish this weren't true, but I've found social mention to be disappointingly innacurate. Just do a search for “starbucks” and see how many results you will get for micromedia. Is this meant to be a sample or is something wrong here?

  • http://twitter.com/dballabio/status/13598750735 Daniela Ballabio

    RT @jaybaer: How to Create a Share of Voice Report http://bit.ly/xvsSw

  • http://twitter.com/rssirteubal/status/13643608864 Ignacio

    How to Create a Share of Voice Report: A must-read with free reports for SM http://bit.ly/30sIS1

  • http://twitter.com/adamvincenzini/status/15697816170 Adam Vincenzini

    Great post from @jaybaer about how to create a social media share of voice report http://bit.ly/8g7iz // using it now, ace!

  • http://twitter.com/fulbeck/status/15699656348 Sally Keith

    RT @AdamVincenzini: Great post from @jaybaer about how to create a social media share of voice report http://bit.ly/8g7iz // worth a look!

  • http://twitter.com/shaunrudy/status/15729124751 Shaun Rudy

    How to create a social media SOV report thru @socialmention – http://bit.ly/8g7iz RT @AdamVincenzini via @jaybaer #sm

  • http://twitter.com/shaunrudy/status/15729124751 Shaun Rudy

    How to create a social media SOV report thru @socialmention – http://bit.ly/8g7iz RT @AdamVincenzini via @jaybaer #sm

  • http://twitter.com/larrytolpin/status/20886915367 LarryTolpin

    How to Create a Share of Voice Report – via @jaybaer – http://ow.ly/16Sz9u

  • http://twitter.com/mickeylonchar/status/20900126727 Mickey Lonchar

    Creating a 'Share of Voice' report. via @JayBaer | http://ht.ly/2od1p

  • http://twitter.com/richardglynn/status/21390121990 Richard Glynn

    How to Create a Share of Voice Report http://bit.ly/cx80Wk

  • Pingback: Marketing or Management :: Greg de Lima

  • Rjohns37

    Hi – this is a GREAT post, but I cannot download the xml sheet.

  • letstalkandchat

    I just found a great company that builds websites for info products. To keep your costs low, they’ll mentor you on how to create your site, design a marketing funnel (one of the guys works in Hollywood and makes really slick videos), and the other guy programmed Myspace. If you’re looking to have professional web design for your small business and not waste any time or money then check their site out. Check them out: http://www.mikelmurphy.com/easy-info-product-site-system/

  • juandecop
  • http://www.clickscr.co.uk/ clickSCR SEO

    Many thanks for sharing the spreadsheet, a handy resource.

  • samrex

    This is just so awesome #thankyou