<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:media="http://search.yahoo.com/mrss/" xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>Community Cultivator</title>
	
	<link>http://www.o2p.org</link>
	<description>Exploring how local organizations connect to their real world patrons</description>
	<lastBuildDate>Sat, 10 Dec 2011 18:48:26 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.1.2</generator>
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/CommunityCultivator" /><feedburner:info uri="communitycultivator" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><media:thumbnail url="http://www.o2p.org/wp-content/images/custom/CC logo.jpg" /><media:category scheme="http://www.itunes.com/dtds/podcast-1.0.dtd">Business</media:category><itunes:author>Marcel Crudele</itunes:author><itunes:explicit>no</itunes:explicit><itunes:image href="http://www.o2p.org/wp-content/images/custom/CC logo.jpg" /><itunes:subtitle>Exploring how local organizations connect to their real world patrons</itunes:subtitle><itunes:summary>All organizations have the same pain - how do you connect with existing and potential patrons to get butts in seats? Patrons want to find the organizations that help fulfill their real-world interests and organizations want to reach and better serve their target audience… Community Cultivator explores this struggle and highlights successes between Organizations and their Patrons - hence o2p.org.</itunes:summary><itunes:category text="Business" /><geo:lat>33.745739</geo:lat><geo:long>-84.376408</geo:long><item>
		<title>American Express and Foursquare on the path to justifying location based marketing</title>
		<link>http://feedproxy.google.com/~r/CommunityCultivator/~3/2FgdoiHaqhw/</link>
		<comments>http://www.o2p.org/2011/12/american-express-and-foursquare-on-the-path-to-justifying-location-based-marketing/#comments</comments>
		<pubDate>Sat, 10 Dec 2011 18:48:26 +0000</pubDate>
		<dc:creator>Marcel Crudele</dc:creator>
				<category><![CDATA[Local Search]]></category>
		<category><![CDATA[Location Based Services]]></category>
		<category><![CDATA[American Express]]></category>
		<category><![CDATA[AMEX]]></category>
		<category><![CDATA[Atlanta]]></category>
		<category><![CDATA[Foursquare]]></category>
		<category><![CDATA[GroupOn]]></category>
		<category><![CDATA[Living Social]]></category>
		<category><![CDATA[Mastercard]]></category>
		<category><![CDATA[Pure Inman Park]]></category>
		<category><![CDATA[Savi]]></category>
		<category><![CDATA[Visa]]></category>

		<guid isPermaLink="false">http://www.o2p.org/?p=1342</guid>
		<description><![CDATA[In June, AMEX announced it was going to partner with Foursquare nationwide to do some cool discount deals tied to check-ins at some national chains. Then they decided to help out small businesses with a Black Saturday deal. Consumers could: Link their Foursquare account to their AMEX card Go to a small business with the [...]]]></description>
			<content:encoded><![CDATA[<p><a rel="attachment wp-att-1345" href="http://www.o2p.org/2011/12/american-express-and-foursquare-on-the-path-to-justifying-location-based-marketing/amex-foursquare/"><img class="alignleft size-medium wp-image-1345" style="border: 15px none; margin-left: 25px; margin-right: 25px;" title="AMEX Foursquare" src="http://www.o2p.org/wp-content/uploads/2011/12/AMEX-Foursquare-300x216.png" alt="" width="293" height="209" /></a>In June, <a title="American Express" href="http://americanexpress.com" target="_blank">AMEX</a> announced it was going to <a title="American Express partners with Foursquare" href="http://blog.foursquare.com/2011/06/23/american-express-specials-now-for-everyone-nationwide/" target="_blank">partner</a> with <a title="Foursquare" href="http://www.foursquare.com" target="_blank">Foursquare</a> nationwide to do some cool discount deals tied to check-ins at some national chains. Then they decided to help out small businesses with a Black Saturday <a title="American Express Small Business Saturday" href="http://techcrunch.com/2011/11/18/amex-users-on-foursquare-get-free-money-25-on-small-biz-saturday/" target="_blank">deal</a>. Consumers could:</p>
<ul>
<li>Link their Foursquare account to their AMEX card</li>
<li>Go to a small business with the AMEX deal ($25 off if you purchase $25 or more with your linked card)</li>
<li>Checkin on Forsquare</li>
<li>Pay with their AMEX</li>
<li>Get a $25 credit on their AMEX bill</li>
</ul>
<p>This was pretty clever and I used the deal at a local pub, <a title="Edgewood Tavern - Atlanta" href="http://www.thecornertavern.com/edgewood/" target="_blank">Edgewood Tavern</a>. I didn&#8217;t have to show my phone to the server or anything, it  just happened behind the scenes at AMEX.</p>
<p>However, last night I was at <a title="Pure Taqueria Inman Park" href="http://puretaqueria.com/inman-park" target="_blank">Pure Taqueria in Inman Park</a> (Atlanta) and saw there was a $10 off deal from AMEX if I checked in on Foursquare. I&#8217;m in pretty tight with the folks over there, so I asked the GM how he set up the deal with AMEX &#8211; were they splitting the discount cost a la <a title="Groupon" href="http://www.groupon.com" target="_blank">Groupon</a> or what.</p>
<p>Here&#8217;s the thing. He had no idea the AMEX deal existed. Apparently, it was all on AMEX. What? (inflection should go from low note to high note)</p>
<p>I opened up Foursquare again and started scrolling through all of the local businesses around me. It was like an <a title="Oprah Everybody gets a car" href="http://www.oprah.com/oprahshow/Oprahs-Entire-Audience-Are-Surprised-with-New-Cars-Video" target="_blank">Oprah moment</a> &#8211; everybody had an AMEX deal! After leaving Pure, I went to <a title="Savi Urban Market" href="http://www.saviurbanmarket.com/" target="_blank">Savi Urban Market</a> and got a $10 discount on a bottle of wine to celebrate (they had no idea the deal existed either).</p>
<h2>What&#8217;s going on and why?</h2>
<p>So, in it&#8217;s simplest form, I&#8217;m buying $10 worth of stuff, the business is getting $10 (minus AMEX transaction fees), and I get $10 back. Who&#8217;s paying for this and why?</p>
<p>Word on the street is that the program doesn&#8217;t drive any revenue to Foursquare, but it represents an initial foray into going &#8220;<a title="Foursquare Location Based Service" href="http://gigaom.com/2011/07/12/has-foursquare-finally-found-the-location-based-revenue-button/" target="_blank">beyond checkins</a>,&#8221; an effort that might soon roll in deals from <a title="Living Social" href="http://www.livingsocial.com" target="_blank">Living Social</a> and <a title="Groupon" href="http://www.groupon.com" target="_blank">Groupon</a>. That will be interesting, but who is paying for the AMEX deal? It seems like AMEX.</p>
<p>I found some insights <a title="AMEX and Foursquare deal" href="http://http://blog.mediaideas.net/2011/06/29/bosacks-speaks-out-on-amex-deal-and-foursquare-for-magazines/" target="_blank">here</a> and <a title="Leveraging Social Media for Banking" href="http://www.businessinsider.com/leveraging-social-media-for-banking-2011-8" target="_blank">there</a>, but I thought I would add my own.</p>
<p>The arrangement in its current form doesn&#8217;t make sense. Foursquare doesn&#8217;t generate revenue and AMEX is having to cover the cost of all the discounts. Currently, it only would work for AMEX if the effort increased the number of AMEX users (driving revenue from annual membership fees), increased the frequency users chose their AMEX card over their Visa card (driving revenue from increased transaction fees), and/or dramatically increased the average transaction size for an AMEX user (again, increased transaction fees). Even if the deal included Foursquare sharing user check-in information with AMEX, what would it tell them that they couldn&#8217;t already get by tracking other card charges&#8230; except maybe if the user checked in at non-businesses like parks and transit stations.</p>
<p>Foursquare gets closer to being able to claim that its online marketing drives consumer behavior and leads to local business revenue. If they gain access to transaction amount data, they get some awesome insights on the value of this marketing. Of course, in my case, I was at two of the businesses uninfluenced by Foursquare&#8230; but my new bottle of wine was effective marketing. Also, Foursquare needs to generate some revenue from all of this.</p>
<h2>The Future of Foursquare</h2>
<p>Here is my prediction about where all of this is going. Foursquare is striving to be the clearinghouse of location based deals. It will remain focused on doing everything it can to gain adoption by users and then aggregate local business deals from whomever can make them &#8211; AMEX, Groupon, Living Social, local news papers, etc. Foursquare gets to focus on technology and lets all of these other guys field the sales force.</p>
<p>AMEX (and potentially other credit cards) will move away from eating the cost for their local deals and begin generating revenue from local businesses paying for these promotions &#8211; similar to the daily deals sites. This will be a marketing cost for the local business, but with Foursquare in the loop, they will gain more insight to user behavior, such as:</p>
<ul>
<li>Was the deal redeemed by a new visitor or returning visitor (in Foursquare terms, a Newbie checkin) &#8211; works regardless of who sold the deal to the business</li>
<li>Did new customers redeeming the deal ever return (tracked through subsequent checkins) &#8211; works regardless of who sold the deal to the local business</li>
<li>Automated tracking of average customer spend, lifetime value, etc tied to the credit card (in AMEX&#8217;s case), regardless of what POS they use &#8211; <strong>only works if a credit card company sold the deal to the local business</strong></li>
</ul>
<p>That is pretty Rock and Roll!</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2FgdoiHaqhw:vZOwLGAYfBc:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2FgdoiHaqhw:vZOwLGAYfBc:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=2FgdoiHaqhw:vZOwLGAYfBc:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2FgdoiHaqhw:vZOwLGAYfBc:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2FgdoiHaqhw:vZOwLGAYfBc:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=2FgdoiHaqhw:vZOwLGAYfBc:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2FgdoiHaqhw:vZOwLGAYfBc:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2FgdoiHaqhw:vZOwLGAYfBc:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=2FgdoiHaqhw:vZOwLGAYfBc:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2FgdoiHaqhw:vZOwLGAYfBc:TzevzKxY174"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=TzevzKxY174" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2FgdoiHaqhw:vZOwLGAYfBc:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=l6gmwiTKsz0" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/CommunityCultivator/~4/2FgdoiHaqhw" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.o2p.org/2011/12/american-express-and-foursquare-on-the-path-to-justifying-location-based-marketing/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.o2p.org/2011/12/american-express-and-foursquare-on-the-path-to-justifying-location-based-marketing/</feedburner:origLink></item>
		<item>
		<title>The Hype of Location Based Services (LBS)</title>
		<link>http://feedproxy.google.com/~r/CommunityCultivator/~3/O5zNqHLrNqA/</link>
		<comments>http://www.o2p.org/2010/11/the-hype-of-location-based-services-lbs/#comments</comments>
		<pubDate>Fri, 19 Nov 2010 14:24:36 +0000</pubDate>
		<dc:creator>Marcel Crudele</dc:creator>
				<category><![CDATA[Local Search]]></category>
		<category><![CDATA[Location Based Services]]></category>
		<category><![CDATA[Foursquare]]></category>
		<category><![CDATA[Gowalla]]></category>
		<category><![CDATA[LBS]]></category>
		<category><![CDATA[Ruud Hein]]></category>
		<category><![CDATA[ScoutMob]]></category>
		<category><![CDATA[Yelp]]></category>

		<guid isPermaLink="false">http://www.o2p.org/?p=1295</guid>
		<description><![CDATA[A great article was posted by Ruud Hein about the second coming of LBS (Foursquare, Gowalla, Yelp, ScoutMob, etc.). The underlying message is: don&#8217;t get too carried away with the hype, we&#8217;ve seen this before. You should read the article for yourself, but one of the striking metrics provided was that 96% of people in [...]]]></description>
			<content:encoded><![CDATA[<p><a href="http://www.o2p.org/wp-content/uploads/2010/11/Ruud-Hein.jpeg"><img class="alignleft size-full wp-image-1297" style="border: 0pt none; margin-left: 3px; margin-right: 3px;" title="Ruud Hein" src="http://www.o2p.org/wp-content/uploads/2010/11/Ruud-Hein.jpeg" alt="Ruud Hein" width="76" height="76" /></a>A great <a title="The Second Coming of Location Based Services" href="http://www.searchenginepeople.com/blog/location-based-services-stats.html" target="_blank">article</a> was posted by Ruud Hein about the second coming of LBS (<a title="Foursquare" href="http://www.foursquare.com" target="_blank">Foursquare</a>, <a title="Gowalla" href="http://www.gowalla.com" target="_blank">Gowalla</a>, <a title="Yelp" href="http://www.yelp.com" target="_blank">Yelp</a>, <a title="ScoutMob" href="http://www.scoutmob.com" target="_blank">ScoutMob</a>, etc.). The underlying message is: don&#8217;t get too carried away with the hype, we&#8217;ve seen this before. You should read the article for yourself, but one of the striking metrics provided was that 96% of people in the US <strong>do not use</strong> location based services. This is not to say that there won&#8217;t be more adoption, possibly even rapid adoption, but businesses should not get swept away with overly exuberant enthusiasm. They should make sure to closely scrutinize any initiatives they plan on taking and especially consider their own patron-base.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=O5zNqHLrNqA:2NoKHpYMlNY:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=O5zNqHLrNqA:2NoKHpYMlNY:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=O5zNqHLrNqA:2NoKHpYMlNY:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=O5zNqHLrNqA:2NoKHpYMlNY:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=O5zNqHLrNqA:2NoKHpYMlNY:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=O5zNqHLrNqA:2NoKHpYMlNY:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=O5zNqHLrNqA:2NoKHpYMlNY:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=O5zNqHLrNqA:2NoKHpYMlNY:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=O5zNqHLrNqA:2NoKHpYMlNY:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=O5zNqHLrNqA:2NoKHpYMlNY:TzevzKxY174"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=TzevzKxY174" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=O5zNqHLrNqA:2NoKHpYMlNY:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=l6gmwiTKsz0" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/CommunityCultivator/~4/O5zNqHLrNqA" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.o2p.org/2010/11/the-hype-of-location-based-services-lbs/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.o2p.org/2010/11/the-hype-of-location-based-services-lbs/</feedburner:origLink></item>
		<item>
		<title>Scoutmob ROI</title>
		<link>http://feedproxy.google.com/~r/CommunityCultivator/~3/TnQxX9kf5kI/</link>
		<comments>http://www.o2p.org/2010/10/scoutmob-roi/#comments</comments>
		<pubDate>Mon, 25 Oct 2010 14:49:28 +0000</pubDate>
		<dc:creator>Marcel Crudele</dc:creator>
				<category><![CDATA[Location Based Services]]></category>
		<category><![CDATA[Promotions]]></category>
		<category><![CDATA[Calculator]]></category>
		<category><![CDATA[campaign]]></category>
		<category><![CDATA[GroupOn]]></category>
		<category><![CDATA[profit]]></category>
		<category><![CDATA[ScoutMob ROI]]></category>

		<guid isPermaLink="false">http://www.o2p.org/?p=1281</guid>
		<description><![CDATA[Calculate the ROI for a Scoutmob Promotion.]]></description>
			<content:encoded><![CDATA[<p><a href="http://www.o2p.org/wp-content/uploads/2010/10/Scoutmob-logo.png"><img class="alignleft size-full wp-image-1288" title="Scoutmob logo" src="http://www.o2p.org/wp-content/uploads/2010/10/Scoutmob-logo.png" alt="" width="152" height="175" /></a>I finally got around to it&#8230; the ScoutMob ROI calculator! For the purposes of this post, I&#8217;m going to stick to the numbers and post-pone analysis for another time.</p>
<h2>ScoutMob ROI Calculator</h2>
<p>I&#8217;ve provided a link to the Excel <a title="ScoutMob ROI Calculator" href="http://www.o2p.org/wp-content/uploads/2010/10/Groupon-ScoutMob-Calculator.xls" target="_blank">ScoutMob Calculator</a> which also includes a tab for the GroupOn calculator for comparison. Because they have different business models, it&#8217;s not a one-to-one comparison, but it should give you an idea of how things shake out &#8211; one of the biggest conceptually changes is how I represent COGS, so pay special attention to that. Unlike my first post regarding GroupOn, I won&#8217;t bore everyone with the details, but just provide an explanation of what the parameters mean.</p>
<p>The calculator is divided into 4 sections. The top left section is where you put in your numbers &#8211; everything else is automated. The section at the bottom left cuts to the chase and summarizes what kind of profits &#8211; if any &#8211; you can expect based on your assumptions. The two sections on the right are scratch work related to the Cost of Goods Sold and the income (not profit) from the whole endeavor.</p>
<h3>Calculation Variables</h3>
<ul>
<li><strong>Discount (D)</strong> &#8211; What is the percent discount you are offering. Typically, this seems to be 50%.</li>
<li><strong>Maximum Discount (X)</strong> &#8211; What is the maximum discount anyone can get when redeeming the offer.</li>
<li><strong>Average Discount Ticket (A)</strong> &#8211; What is the face value of the average ticket before the discount is applied. Any amount above X/D is the happy place where you will make your normal margin.</li>
<li><strong>Cost Of Goods Percentage (G)</strong> &#8211; What percent of the sell price represents your costs. If you are a restaurant and your costs represent 33.33% of your sell price (it costs $10 to sell something for $30), that is the number you use. Ideally, this includes overhead and labor costs as well, but use it as you see fit.</li>
<li><strong>Number of Actions (T)</strong> &#8211; How many people take action on your offer. This is a combination of offers redeemed through smart phones, text messages and emails.</li>
<li><strong>Printed/Texted Action (P)</strong> &#8211; What percent of people will request a printed/texted version of the offer instead of using a smart phone application? I have no idea what this is, but all the cool kids use smart phones, so I set it low at 10%.</li>
<li><strong>Redeemed printed/texted certificates percentage (R) </strong>- What percent of the printed/texted certificates will actually be redeemed? I set this to 68% because that is the number from the one real-world case study I have from GroupOn. I actually think it is lower for ScoutMob because the consumer doesn&#8217;t pay for the offer so is less likely to use it, but there ya go.</li>
<li><strong>Cost for Smart Phone Use (S)</strong> &#8211; How much does ScoutMob charge for each redemption through their smart phone app. The word on the street is that it is &#8220;a couple of dollars&#8221; so I used $2.</li>
<li><strong>Cost for printed/texted coupon redemption (C) </strong>- the amount ScoutMob charges for each emailed or texted offer. Again, I&#8217;m not sure what this is, but $.50 seems in line with the word on the street.</li>
<li><strong>New Patron % (N)</strong> &#8211; When it&#8217;s all said and done, what percent of the people that took advantage of a ScoutMob offer (through smart phone, text or email) will actually return to your business without a discount. This is one of the weakest parts of this model so be wary &#8211; I assumed 75%, although I completely made that number up and honestly think it is high, but it&#8217;s in line with the number I assumed for Groupon (which I also think is high).</li>
<li><strong>New Patron Long Time income (L)</strong> &#8211; How much will the average returning customer calculated above spend over their &#8220;lifetime.&#8221; Lifetime is up for interpretation, but I think of it as being over the next year so the ROI has a nice, set length of time.</li>
<li><strong>Brand Value (V)</strong> &#8211; Business owners have indicated a concern over how deep discounts might affect their brand because it could be seen as a sign of desperation. Others have said that there is a lot of value in the gained brand recognition. I have no idea how to determine this so I shifted the burden to the business&#8230; enter how you think the promotion will affect your business&#8217; <strong>profits</strong> in real dollars &#8211; positively or negatively.</li>
</ul>
<h3><strong>Results Section<br />
</strong></h3>
<p>This section is super easy to interpret, but keep in mind that it is based on all of the numbers you entered above and that Garbage In = Garbage Out.</p>
<ul>
<li><strong>Campaign Profits</strong> &#8211; What profit will you make from all of the people that use a ScoutMob offer</li>
<li><strong>Total Long Term Profit </strong>- What profit will you make due to revenue generated because of the campaign beyond the special offer. Again, I think of this as over the course of a year.</li>
<li><strong>ROI</strong> &#8211; a very simple ROI calculation that compares the profits you made to how much the promotion cost you.</li>
</ul>
<h3>Cost of Investment</h3>
<p>What does all of this cost you?</p>
<ul>
<li><strong>Total number of redeemed offers </strong>- this is kind of important. It assumes that <em><strong>100% of people that redeem through a Smart Phone are actually at your business and complete the transaction</strong></em>. Added to this are the people that had the offer either emailed or texted to them and applies the redemption rate parameter (R).</li>
<li><strong>Discounted COGS</strong> &#8211; the cost to provide the goods or services within the discounted amount. For example, if you offer 50% off with a maximum discount of $10, this is the cost for the first $20 of the average ticket ($20*50%=$10 maximum discount).</li>
<li><strong>GOGS for ticket beyond certificate amount </strong>- this is your cost in the case that the average ticket value exceeds the maximum discount limit (i.e. the $20 mentioned above). Building on the previous example, if the average ticket value is $35, the first $20 is within the discount window and the next $15 benefits from your normal margin &#8230; your costs for that $10 is shown here.</li>
<li><strong>Amount Paid to Scoutmob</strong> &#8211; this is the amount you pay to Scoutmob for all of the redemptions</li>
<li><strong>GOGS lifelong purchase costs</strong> &#8211; This is your costs for all of the people you hope will return without the discount incentive.</li>
<li><strong>Brand Damage Cost</strong> &#8211; if you specified that you think the promotion will damage your brand (by entering a negative number for V), that number is represented here.</li>
</ul>
<h3>Income from Investment</h3>
<p>This section is the scratch work for the other side of the equation &#8211; how much coin will flow into your bank account based on the promotion.</p>
<ul>
<li><strong>Initial Discount Offer Income</strong> &#8211; This is the amount of income that will be generated from offer redemption within the maximum discount range</li>
<li><strong>Income from sells beyond Certificate Amount </strong>- If the average ticket exceeds the maximum discount range, that income is reflected here</li>
<li><strong>New Patron Long Time income -</strong> The amount of income that will be generated from all of those returning customers you are counting on.</li>
<li><strong>Brand Benefit Income </strong>- If you specified that you think there will be a brand benefit from the promotion (by entering a positive number for V), it is reflected here.</li>
</ul>
<h2>Summary</h2>
<p>There is no clear-cut way to evaluate if you should do one of these promotions or not, but at least you now have some tools to assist in the decision. If you have any real world numbers from your promotion, I&#8217;d love to have them. Let me know what you think!</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=TnQxX9kf5kI:saVOBQGJmEE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=TnQxX9kf5kI:saVOBQGJmEE:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=TnQxX9kf5kI:saVOBQGJmEE:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=TnQxX9kf5kI:saVOBQGJmEE:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=TnQxX9kf5kI:saVOBQGJmEE:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=TnQxX9kf5kI:saVOBQGJmEE:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=TnQxX9kf5kI:saVOBQGJmEE:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=TnQxX9kf5kI:saVOBQGJmEE:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=TnQxX9kf5kI:saVOBQGJmEE:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=TnQxX9kf5kI:saVOBQGJmEE:TzevzKxY174"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=TzevzKxY174" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=TnQxX9kf5kI:saVOBQGJmEE:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=l6gmwiTKsz0" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/CommunityCultivator/~4/TnQxX9kf5kI" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.o2p.org/2010/10/scoutmob-roi/feed/</wfw:commentRss>
		<slash:comments>6</slash:comments>
		<enclosure url="http://www.o2p.org/wp-content/uploads/2010/10/Groupon-ScoutMob-Calculator.xls" length="39424" type="application/vnd.ms-excel" /><media:content url="http://www.o2p.org/wp-content/uploads/2010/10/Groupon-ScoutMob-Calculator.xls" fileSize="39424" type="application/vnd.ms-excel" /><itunes:explicit>no</itunes:explicit><itunes:subtitle>Calculate the ROI for a Scoutmob Promotion.</itunes:subtitle><itunes:author>Marcel Crudele</itunes:author><itunes:summary>Calculate the ROI for a Scoutmob Promotion.</itunes:summary><itunes:keywords>Location Based Services, Promotions, Calculator, campaign, GroupOn, profit, ScoutMob ROI</itunes:keywords><feedburner:origLink>http://www.o2p.org/2010/10/scoutmob-roi/</feedburner:origLink></item>
		<item>
		<title>Getting noticed in the Facebook NewsFeed</title>
		<link>http://feedproxy.google.com/~r/CommunityCultivator/~3/AvVZI5S6CNo/</link>
		<comments>http://www.o2p.org/2010/10/getting-noticed-in-the-facebook-newsfeed/#comments</comments>
		<pubDate>Tue, 19 Oct 2010 13:53:30 +0000</pubDate>
		<dc:creator>Marcel Crudele</dc:creator>
				<category><![CDATA[Social Networks]]></category>
		<category><![CDATA[Daily Beast]]></category>
		<category><![CDATA[Facebook]]></category>
		<category><![CDATA[News Feed]]></category>

		<guid isPermaLink="false">http://www.o2p.org/?p=1276</guid>
		<description><![CDATA[Tips from the Daily beast on showing up in your friends' news feed.]]></description>
			<content:encoded><![CDATA[<p><a href="http://www.o2p.org/wp-content/uploads/2010/10/The-Daily-Beast.png"><img class="alignleft size-full wp-image-1277" style="border: 0pt none; margin-left: 5px; margin-right: 5px;" title="The Daily Beast" src="http://www.o2p.org/wp-content/uploads/2010/10/The-Daily-Beast.png" alt="" width="120" height="119" /></a>The Daily Beast recently posted an interesting <a title="How Facebook News Feed Works" href="http://www.thedailybeast.com/blogs-and-stories/2010-10-18/the-facebook-news-feed-how-it-works-the-10-biggest-secrets/" target="_blank">article</a> about how they think the Facebook algorithm works to decide what information people see in their news feed. The article goes into a lot more detail, but there are a couple of guidelines that resonate with commone sense. The gist is:</p>
<ul>
<li>Get lots of people to interact with your profile &#8211; view images and videos, post on your wall, and especially comment on your posts. How you do this is a science in itself.</li>
<li>Posting links is better than just posting text status updates</li>
<li>Posting photos and videos is better than posting links</li>
</ul>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=AvVZI5S6CNo:7qS5TAQkZRs:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=AvVZI5S6CNo:7qS5TAQkZRs:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=AvVZI5S6CNo:7qS5TAQkZRs:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=AvVZI5S6CNo:7qS5TAQkZRs:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=AvVZI5S6CNo:7qS5TAQkZRs:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=AvVZI5S6CNo:7qS5TAQkZRs:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=AvVZI5S6CNo:7qS5TAQkZRs:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=AvVZI5S6CNo:7qS5TAQkZRs:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=AvVZI5S6CNo:7qS5TAQkZRs:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=AvVZI5S6CNo:7qS5TAQkZRs:TzevzKxY174"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=TzevzKxY174" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=AvVZI5S6CNo:7qS5TAQkZRs:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=l6gmwiTKsz0" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/CommunityCultivator/~4/AvVZI5S6CNo" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.o2p.org/2010/10/getting-noticed-in-the-facebook-newsfeed/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.o2p.org/2010/10/getting-noticed-in-the-facebook-newsfeed/</feedburner:origLink></item>
		<item>
		<title>Yelp and Open Table will offer Groupon type service</title>
		<link>http://feedproxy.google.com/~r/CommunityCultivator/~3/12hPihM8Heg/</link>
		<comments>http://www.o2p.org/2010/09/yelp-and-open-table-will-offer-groupon-type-service/#comments</comments>
		<pubDate>Wed, 01 Sep 2010 17:44:54 +0000</pubDate>
		<dc:creator>Marcel Crudele</dc:creator>
				<category><![CDATA[Promotions]]></category>
		<category><![CDATA[Facebook]]></category>
		<category><![CDATA[Group buying]]></category>
		<category><![CDATA[GroupOn]]></category>
		<category><![CDATA[Open Table]]></category>
		<category><![CDATA[Yelp]]></category>

		<guid isPermaLink="false">http://www.o2p.org/?p=1271</guid>
		<description><![CDATA[Everyone is beginning to copy Groupon's business model. Who will win the battle royale?]]></description>
			<content:encoded><![CDATA[<p>By any measure, <a title="Group On" href="http://www.groupon.com" target="_blank">Groupon</a> has been a phenomenal success as a company. So much so that others are following suite &#8211; including <a title="Yelp" href="http://www.yelp.com" target="_blank">Yelp</a> and <a title="Open Table" href="http://www.opentable.com" target="_blank">Open Table</a>. This video discusses this as well as the question of the impact of Group Buying on small businesses&#8230; specifically, restaurants.</p>
<p><object id="ep" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="416" height="374" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0"><param name="allowfullscreen" value="true" /><param name="allowscriptaccess" value="always" /><param name="wmode" value="transparent" /><param name="bgcolor" value="#000000" /><param name="src" value="http://i.cdn.turner.com/cnn/.element/apps/cvp/3.0/swf/cnn_416x234_embed.swf?context=embed&amp;videoId=business/2010/08/31/ca.restaurant.coupon.biz.ktvu" /><embed id="ep" type="application/x-shockwave-flash" width="416" height="374" src="http://i.cdn.turner.com/cnn/.element/apps/cvp/3.0/swf/cnn_416x234_embed.swf?context=embed&amp;videoId=business/2010/08/31/ca.restaurant.coupon.biz.ktvu" bgcolor="#000000" wmode="transparent" allowscriptaccess="always" allowfullscreen="true"></embed></object></p>
<p>Is group buying going to be the new tech trend like &#8220;checking in?&#8221; As successful as Groupon is with their extensive email list, what happens if/when <a title="Facebook" href="http://www.facebook.com" target="_blank">Facebook</a> enters the fray?</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=12hPihM8Heg:f_qKjQdX8Fo:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=12hPihM8Heg:f_qKjQdX8Fo:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=12hPihM8Heg:f_qKjQdX8Fo:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=12hPihM8Heg:f_qKjQdX8Fo:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=12hPihM8Heg:f_qKjQdX8Fo:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=12hPihM8Heg:f_qKjQdX8Fo:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=12hPihM8Heg:f_qKjQdX8Fo:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=12hPihM8Heg:f_qKjQdX8Fo:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=12hPihM8Heg:f_qKjQdX8Fo:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=12hPihM8Heg:f_qKjQdX8Fo:TzevzKxY174"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=TzevzKxY174" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=12hPihM8Heg:f_qKjQdX8Fo:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=l6gmwiTKsz0" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/CommunityCultivator/~4/12hPihM8Heg" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.o2p.org/2010/09/yelp-and-open-table-will-offer-groupon-type-service/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<enclosure url="http://i.cdn.turner.com/cnn/.element/apps/cvp/3.0/swf/cnn_416x234_embed.swf?context=embed&amp;amp;videoId=business/2010/08/31/ca.restaurant.coupon.biz.ktvu" length="43223" type="application/x-shockwave-flash" /><media:content url="http://i.cdn.turner.com/cnn/.element/apps/cvp/3.0/swf/cnn_416x234_embed.swf?context=embed&amp;amp;videoId=business/2010/08/31/ca.restaurant.coupon.biz.ktvu" fileSize="43223" type="application/x-shockwave-flash" /><itunes:explicit>no</itunes:explicit><itunes:subtitle>Everyone is beginning to copy Groupon's business model. Who will win the battle royale?</itunes:subtitle><itunes:author>Marcel Crudele</itunes:author><itunes:summary>Everyone is beginning to copy Groupon's business model. Who will win the battle royale?</itunes:summary><itunes:keywords>Promotions, Facebook, Group buying, GroupOn, Open Table, Yelp</itunes:keywords><feedburner:origLink>http://www.o2p.org/2010/09/yelp-and-open-table-will-offer-groupon-type-service/</feedburner:origLink></item>
		<item>
		<title>Groupon – Angel or Devil?</title>
		<link>http://feedproxy.google.com/~r/CommunityCultivator/~3/ilQOJQJeKgw/</link>
		<comments>http://www.o2p.org/2010/08/groupon-angel-or-devil/#comments</comments>
		<pubDate>Thu, 12 Aug 2010 19:47:12 +0000</pubDate>
		<dc:creator>Marcel Crudele</dc:creator>
				<category><![CDATA[Promotions]]></category>

		<guid isPermaLink="false">http://www.o2p.org/?p=1267</guid>
		<description><![CDATA[What is the dark side of using a Groupon campaign?]]></description>
			<content:encoded><![CDATA[<p>Someone responded to one of my previous posts about GroupOn ROI to share a story of bad experiences with participating in a campaign. To that point, I had never heard anyone complain about their experience so I want to share the link to balance the story out. Hope this helps!</p>
<p><a title="Is Gropon evil?" href="http://www.spaboomblog.com/2010/dont-sell-your-soul-to-the-discount-devil" target="_blank">http://www.spaboomblog.com/2010/dont-sell-your-soul-to-the-discount-devil</a></p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=ilQOJQJeKgw:wCn5Dp0AfJY:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=ilQOJQJeKgw:wCn5Dp0AfJY:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=ilQOJQJeKgw:wCn5Dp0AfJY:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=ilQOJQJeKgw:wCn5Dp0AfJY:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=ilQOJQJeKgw:wCn5Dp0AfJY:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=ilQOJQJeKgw:wCn5Dp0AfJY:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=ilQOJQJeKgw:wCn5Dp0AfJY:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=ilQOJQJeKgw:wCn5Dp0AfJY:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=ilQOJQJeKgw:wCn5Dp0AfJY:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=ilQOJQJeKgw:wCn5Dp0AfJY:TzevzKxY174"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=TzevzKxY174" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=ilQOJQJeKgw:wCn5Dp0AfJY:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=l6gmwiTKsz0" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/CommunityCultivator/~4/ilQOJQJeKgw" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.o2p.org/2010/08/groupon-angel-or-devil/feed/</wfw:commentRss>
		<slash:comments>5</slash:comments>
		<feedburner:origLink>http://www.o2p.org/2010/08/groupon-angel-or-devil/</feedburner:origLink></item>
		<item>
		<title>Groupon Case Study</title>
		<link>http://feedproxy.google.com/~r/CommunityCultivator/~3/2PfX4D6BeWc/</link>
		<comments>http://www.o2p.org/2010/07/groupon-case-study/#comments</comments>
		<pubDate>Fri, 16 Jul 2010 22:46:28 +0000</pubDate>
		<dc:creator>Marcel Crudele</dc:creator>
				<category><![CDATA[Promotions]]></category>
		<category><![CDATA[Technologies]]></category>
		<category><![CDATA[Calculator]]></category>
		<category><![CDATA[GroupOn]]></category>
		<category><![CDATA[ROI]]></category>

		<guid isPermaLink="false">http://www.o2p.org/?p=1250</guid>
		<description><![CDATA[I have real world numbers from a GroupOn campaign to share with the world! This in combination with my very sexy equation from a previous post and my newly added, downloadable GroupOn Excel calculator allows us to get all kinds of insight. The businesses I know that have participated in these campaigns have seemed pretty [...]]]></description>
			<content:encoded><![CDATA[<p>I have real world numbers from a <a title="GroupOn" href="http://www.groupon.com" target="_blank">GroupOn</a> campaign to share with the world! This in combination with my very sexy equation from a<a title="Groupon ROI" href="http://www.o2p.org/group-on-roi-the-math" target="_blank"> previous post </a>and my newly added, downloadable <a title="GroupOn Calculator" href="http://www.o2p.org/wp-content/uploads/2010/07/GroupOn-Calculator.xls" target="_blank">GroupOn Excel calculator</a> allows us to get all kinds of insight.</p>
<p>The businesses I know that have participated in these campaigns have seemed pretty happy with the results, but none of them tracked their numbers. That meant I had to make some assumptions, but no longer.</p>
<h2>Case Study</h2>
<p>Here are the metrics from a real GroupOn campaign. I would expect that results will vary from business to businesss and especially between different industries. If you need to better understand these numbers, read the previous post.</p>
<ul>
<li><strong>Business Type:</strong> Very Casual Dining</li>
<li><strong>Business Age:</strong> Fairly new business</li>
<li><strong>GroupOn offer: </strong>$20 certificate for $10</li>
<li><strong>GroupOn&#8217;s commission:</strong> 50%</li>
<li><strong>Total Sold:</strong> 1,225</li>
<li><strong>Redemption Rate: </strong>68% (32% were never cashed in)</li>
<li><strong>Average Ticket Amount (with certificate use):</strong> $20 (people spent pretty close to the face value amount)</li>
<li><strong>Estimated number of new, recurring customers: </strong>75%. This is expressed as a % of the total number of certificates sold. These are people that will come back even without a certificate.</li>
<li><strong>Estimated Long term, recurring customer income:</strong> $20. Without a certificate, the average ticket is about $10. This means that it is assumed the new, recurring customers mentioned are expected to come in about 4 times over the &#8220;long term&#8221;</li>
<li><strong>Normal Margin on sales:</strong> I did a loose calculation because I knew the net result&#8230; 230% margin or COGS is about 30% ticket price.</li>
<li><strong>Brand Value:</strong> $0. This is such a fuzzy number, that I left it as zero.</li>
</ul>
<p>The real world result is that this business owner was paid $6,000 with costs around $5,000. According to the super-awesome <a title="GroupOn Calculator" href="http://www.o2p.org/wp-content/uploads/2010/07/GroupOn-Calculator.xls" target="_blank">spreadsheet</a> &#8211; using the numbers above &#8211; the analysis shows:</p>
<ul>
<li><strong>Campaign Profit:</strong> $1,076.52</li>
<li><strong>Total Long Term Profit:</strong> $13,883.33</li>
<li><strong>ROI over the &#8220;Long Term&#8221;:</strong> 130.77%</li>
</ul>
<p>Not too shabby.</p>
<h2>Footnotes</h2>
<p>There are some notes worth mentioning:</p>
<ul>
<li>The business was paid by GroupOn in three, equal payments over 1-2 months. They were happy with this.</li>
<li>Purchases with certificates with Tickets less than $20 don&#8217;t get change. Typically, they would order something else to get over the $20 level.</li>
<li>Redemption volume was heavy in the first and last month, the numbers were:
<ul>
<li>Month 1 &#8211; 225</li>
<li>Month 2 &#8211; 150</li>
<li>Month 3 &#8211; 100</li>
<li>Month 4 &#8211; 50</li>
<li>Month 5 &#8211; 50</li>
<li>Month 6 &#8211; 250</li>
</ul>
</li>
<li>The number of new, recurring customers is very difficult to determine  and is basically a gut-check. Unfortunately, it is largely responsible  for the determination of the Long Term Profit&#8230; so be careful how you  use it.</li>
<li>I assumed &#8220;Long Term&#8221; meant over the course of a year when determining some of the more &#8220;magical&#8221; numbers. You can assume whatever you want, but make sure you understand what it all means.</li>
<li>The calculator is intended to be functional, not fancy. It&#8217;s pretty basic, but still very, very sexy.</li>
</ul>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2PfX4D6BeWc:fZVlccYsiDA:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2PfX4D6BeWc:fZVlccYsiDA:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=2PfX4D6BeWc:fZVlccYsiDA:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2PfX4D6BeWc:fZVlccYsiDA:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2PfX4D6BeWc:fZVlccYsiDA:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=2PfX4D6BeWc:fZVlccYsiDA:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2PfX4D6BeWc:fZVlccYsiDA:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2PfX4D6BeWc:fZVlccYsiDA:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=2PfX4D6BeWc:fZVlccYsiDA:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2PfX4D6BeWc:fZVlccYsiDA:TzevzKxY174"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=TzevzKxY174" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=2PfX4D6BeWc:fZVlccYsiDA:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=l6gmwiTKsz0" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/CommunityCultivator/~4/2PfX4D6BeWc" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.o2p.org/2010/07/groupon-case-study/feed/</wfw:commentRss>
		<slash:comments>18</slash:comments>
		<enclosure url="http://www.o2p.org/wp-content/uploads/2010/07/GroupOn-Calculator.xls" length="20480" type="application/vnd.ms-excel" /><media:content url="http://www.o2p.org/wp-content/uploads/2010/07/GroupOn-Calculator.xls" fileSize="20480" type="application/vnd.ms-excel" /><itunes:explicit>no</itunes:explicit><itunes:subtitle>I have real world numbers from a GroupOn campaign to share with the world! This in combination with my very sexy equation from a previous post and my newly added, downloadable GroupOn Excel calculator allows us to get all kinds of insight. The businesses </itunes:subtitle><itunes:author>Marcel Crudele</itunes:author><itunes:summary>I have real world numbers from a GroupOn campaign to share with the world! This in combination with my very sexy equation from a previous post and my newly added, downloadable GroupOn Excel calculator allows us to get all kinds of insight. The businesses I know that have participated in these campaigns have seemed pretty [...]</itunes:summary><itunes:keywords>Promotions, Technologies, Calculator, GroupOn, ROI</itunes:keywords><feedburner:origLink>http://www.o2p.org/2010/07/groupon-case-study/</feedburner:origLink></item>
		<item>
		<title>Is Your Audience Listening?</title>
		<link>http://feedproxy.google.com/~r/CommunityCultivator/~3/Zoi7nLV0pEs/</link>
		<comments>http://www.o2p.org/2010/07/is-your-audience-listening/#comments</comments>
		<pubDate>Mon, 12 Jul 2010 13:27:09 +0000</pubDate>
		<dc:creator>Marcel Crudele</dc:creator>
				<category><![CDATA[Reviews & Commentary]]></category>
		<category><![CDATA[Facebook]]></category>
		<category><![CDATA[Fans]]></category>
		<category><![CDATA[Followers]]></category>
		<category><![CDATA[social media]]></category>
		<category><![CDATA[target audience]]></category>
		<category><![CDATA[twitter]]></category>

		<guid isPermaLink="false">http://www.o2p.org/?p=1243</guid>
		<description><![CDATA[This is a topic I&#8217;ve struggled with over the past few years. There are so many people that measure success based on the number of followers/fans they have, but I question how valuable these numbers are. Those companies that do email blasts to a billion people see success as a 2% click through rate&#8230;. they&#8217;re [...]]]></description>
			<content:encoded><![CDATA[<p>This is a topic I&#8217;ve struggled with over the past few years. There are so many people that measure success based on the number of followers/fans they have, but I question how valuable these numbers are. Those companies that do email blasts to a billion people see success as a <a title="Fans, Participants and Spectators" href="http://sethgodin.typepad.com/seths_blog/2010/07/fans-participants-and-spectators.html" target="_blank">2% click through</a> rate&#8230;. they&#8217;re playing the numbers.</p>
<p>I&#8217;m currently in the camp that believes quality is better than quantity. I actually <strong>read</strong> the profiles and posts of people I follow on Twitter and I don&#8217;t automatically follow people that follow me. If I get a friend request on Facebook, I check to see if I know the person and, if not, I check to see what friends we have in common. The justification I have for both myself and the organizations I work with is, having an engaged audience is more valuable than the raw numbers. I equate people that blindly follow others on social media to someone grabbing one of those business card fishbowls you see in restaurants &#8211; you can add all of these people to your contact list, but will most likely never do business with any of them. What&#8217;s the point?</p>
<p>The counter argument is that the more people you can reach, the more likely it is that your message will fall on friendly ears. If 2% of those fishbowl contacts is actually interested in what you are doing, then that is one successful connection for every 50 cards you filch.</p>
<p>I like analytics quite a bit, but I think that the real measurements that have value are in absolute numbers, not ratios. How many people are actually interacting with you through retweets, mentions, direct messages, comments, likes and wall posts? If you can push these numbers up that show engagement (without annoying people) by following every single person, then your ratio is shot, but so what? If you can do it by exerting more energy to vet your audience &#8211; fantastic.</p>
<p>Here are what I believe are the secrets:</p>
<ol>
<li>Add value to the conversation instead of just acting as a shill for your interests. So many organizations create accounts and turn on the traditional broadcast tower &#8230; &#8220;buy my product, visit my business, enroll in my self help program, etc.&#8221; What information are you providing that help people pursue their interests versus just another advertisement?</li>
<li>Go deep on the conversations your audience wants to have. Social Media is a two way street and your opportunity to have an ongoing conversation, build relationships, and turn bystanders into passionate patrons.</li>
<li>Focus on the real metrics that measure if people are interested in what you have to say versus how many people are within earshot.</li>
</ol>
<p>I&#8217;d love to know what strategies others are using. Let me know what you think.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=Zoi7nLV0pEs:08VSi5NYXnE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=Zoi7nLV0pEs:08VSi5NYXnE:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=Zoi7nLV0pEs:08VSi5NYXnE:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=Zoi7nLV0pEs:08VSi5NYXnE:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=Zoi7nLV0pEs:08VSi5NYXnE:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=Zoi7nLV0pEs:08VSi5NYXnE:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=Zoi7nLV0pEs:08VSi5NYXnE:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=Zoi7nLV0pEs:08VSi5NYXnE:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=Zoi7nLV0pEs:08VSi5NYXnE:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=Zoi7nLV0pEs:08VSi5NYXnE:TzevzKxY174"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=TzevzKxY174" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=Zoi7nLV0pEs:08VSi5NYXnE:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=l6gmwiTKsz0" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/CommunityCultivator/~4/Zoi7nLV0pEs" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.o2p.org/2010/07/is-your-audience-listening/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.o2p.org/2010/07/is-your-audience-listening/</feedburner:origLink></item>
		<item>
		<title>GroupOn ROI – the Math</title>
		<link>http://feedproxy.google.com/~r/CommunityCultivator/~3/qFcmC0PYf7U/</link>
		<comments>http://www.o2p.org/2010/05/group-on-roi-the-math/#comments</comments>
		<pubDate>Tue, 04 May 2010 17:47:05 +0000</pubDate>
		<dc:creator>Marcel Crudele</dc:creator>
				<category><![CDATA[Promotions]]></category>
		<category><![CDATA[Technologies]]></category>
		<category><![CDATA[GroupOn]]></category>
		<category><![CDATA[online promotions]]></category>
		<category><![CDATA[real value]]></category>
		<category><![CDATA[ROI]]></category>

		<guid isPermaLink="false">http://www.o2p.org/?p=1172</guid>
		<description><![CDATA[Will GroupOn make your organization money? Calculate the ROI for GroupOn and find out.]]></description>
			<content:encoded><![CDATA[<p><em><strong>UPDATE 7/16/10</strong></em>: I&#8217;ve added an Excel <a title="GroupOn ROI Calculator" href="http://www.o2p.org/wp-content/uploads/2010/07/GroupOn-Calculator.xls" target="_blank">calculator</a> to make it easier to determine how GroupOn might work for you. It&#8217;s very simple, but uses all the logic described in this post.</p>
<p><strong>UPDATE 7/16/2010</strong> &#8211; I&#8217;ve also added a new post with real world numbers with a <a title="Groupon Case Study" href="http://www.o2p.org/groupon-case-study" target="_blank">Groupon Case Study</a>.</p>
<p>How do you know if <a title="Group On" href="http://www.groupon.com" target="_blank">GroupOn</a> is right for you? I like numbers quite a bit and became obsessed with this, so I&#8217;ve put together an ROI calculation to try to answer this question. This post includes the calculation I came up with towards the beginning and the detailed breakdown of what everything means for any masochists that like that sort of thing.</p>
<p>At a very high level, the GroupOn pitch seems questionable. They want you to sell a certificate through GroupOn (say $30) for a deep discount (say $15) and they are going to take a percent of the income (say 50% or $7.50). In this example, you are getting 25% of what you would normally. Why would anyone do this?</p>
<ul>
<li><strong>New Patrons &#8211; </strong>This is the biggest reason. If you can get new patrons into your organization  with a deep discount and they keep coming back and spending big bucks,  there is a lifelong value.</li>
<li><strong>Cash flow </strong>- You get paid the day  after the promotion which  can help out if you need to buy that new  oven or make payroll. Since the  certificate is valid until the  expiration date, you can expect the loss  to be spread out over a period  of time &#8211; although most of it will  probably be pretty soon.</li>
<li><strong>Unredeemed  certificates </strong>- there will be some people that  pay for the deal,  but never actually use the certificate. That&#8217;s just  free money.</li>
<li><strong>Average  ticket value exceeds offer </strong>-If you limit the  offer to one  certificate per table (for example),  what if they bring friends and  buy a boat  load of food &#8211; only getting a deal on the first $30? Nice.</li>
</ul>
<p>There is one additional cost to also consider, though.</p>
<ul>
<li><strong>Brand value.</strong> How do you  think offering this type of  outrageous deal will affect your image? You  might decide this is positive, negative or not a  concern.</li>
</ul>
<h2>Define your numbers</h2>
<p>So should you do it?  Let&#8217;s ignore the immediate Cash Flow benefit and make some assumptions.</p>
<ul>
<li><strong>Offer  Amount (O)</strong> &#8211;  you are going to offer a <strong>$30</strong> certificate and only allow one  to be redeemed per table</li>
<li><strong>Sell  Amount (S)</strong> &#8211; the  purchase price for these certificates will be <strong>$15</strong></li>
<li><strong>GroupOn&#8217;s Cut (G)</strong> &#8211;  GroupOn&#8217;s cut will be <strong>50%</strong> of the sell price&#8230; for every $15 certificate, they get $7.50 and you get $7.50</li>
<li><strong>Margin (M)</strong> &#8211; your margin is <strong>50%</strong>, i.e., if it costs you $20 to make something, you are going to sell it for $30.</li>
<li><strong>Average Ticket (A)</strong> &#8211;  the average ticket of people using the  offer will   be <strong>$50</strong></li>
<li><strong>Redeemed  Certificates (R)</strong> &#8211; only <strong>80% </strong>of certificates will be redeemed</li>
<li><strong>Total sold (T) </strong>-  you expect to sell <strong>500</strong> of  these</li>
<li><strong>New patron percentage (N)</strong> &#8211; you expect <strong>40%</strong> of the people taking advantage of the offer to be new patrons (the remainder are people that are already patrons). This is a number that you pretty much have to make up, but 40% seems pretty good.</li>
<li><strong>New Patron Lifetime Value (L)</strong> &#8211; We&#8217;ll say the average patron will spend <strong>$150 </strong>with you (beyond the offer) over a period of 1 year (if you choose 2 years, 3 years, etc, your ROI will be spread over that period). Determining this value is a science on its own so good luck coming up with the right number.  Taken in conjunction with your Margin, this can be used to determine profit from your average patron.</li>
<li><strong>Brand Value (V)</strong> &#8211; Some organizations worry that offering such deep discounts will damage their brand and make them look &#8220;desperate.&#8221; Others might think there is an overall brand benefit that is not captured in the lifetime patron value. This variable is intended to capture this &#8220;fuzzy&#8221; influence and represents how the promotion will affect revenue over a period of 1 year (if you choose 2 years, 3 years, etc, your ROI  will be spread over that period) SEPARATE FROM INCOME RELATED TO NEW PATRONS. If you think it will increase revenue over time, choose a positive number, but since I have heard concerns about the negative effects, I will choose a negative number and that I am making up &#8211; <strong>-$4,500</strong>.</li>
</ul>
<h2>GroupOn ROI Calculation</h2>
<p>Here it is&#8230; the total <strong>long term profit</strong> you can expect from this promotion is:</p>
<p><em>Total initial income &#8230; + &#8230; Loss from certificate redemption &#8230; + &#8230; New patron Benefit &#8230; + &#8230; Brand Damage</em></p>
<p><em><strong>T*(S-G*S) &#8230;. + &#8230;. </strong><strong>R*T*</strong>[<strong>(A-O)-(A-O)/(1+M) - O/(1+M)] &#8230; + &#8230; </strong><strong>T*N*(L-L/(1+M) &#8230; </strong></em><strong><em>+ &#8230; (V-V/(1+M)) = PROFIT</em><br />
</strong></p>
<p>or &#8230;.</p>
<p>500 * ($15 &#8211; .5*$15) &#8230; + &#8230; .8*500*[($50-$30)-($50-$30)/(1+.5)] &#8230; + &#8230; 500*.4*($150-$150/(1+.5) &#8230; + &#8230; (-$4,500-(-$4,500)/(1+.5)) = $3,750 &#8230; &#8211; &#8230; $5,332 &#8230; + &#8230; $10,000 &#8230; &#8211; &#8230; $1,500 <strong> = $6,918</strong></p>
<p>For the purists out there, this is not technically ROI, which is defined as (gain from investment &#8211; cost of investment) / (cost of investment). Fine.</p>
<h3>Cost of Investment</h3>
<p>The cost of investment is:</p>
<p><em>What it costs you to redeem certificates &#8230; + &#8230; what it costs you to fulfill purchases beyond the limits of the offering &#8230; + &#8230; your cost of fulfilling lifelong purchases &#8230; + &#8230; brand value</em></p>
<p><em><strong>R*T*(O/1+M) &#8230; + &#8230; R*T*(A-O)/(1+M) &#8230; + &#8230; T*N*(L/(1+M) &#8230; + &#8230; V<br />
</strong></em></p>
<p>or &#8230;</p>
<p>.8*500*($30/(1+.5) &#8230; + &#8230; .8*500*($50-$30)/(1+.5) &#8230; + &#8230; 500*.4*($150/(1+.5)) &#8230; + &#8230; $4,500 =<strong> $37,833</strong></p>
<p><strong>NOTE: </strong>You should move the brand value to Gain calculation if you think it will be positive.<strong><br />
</strong></p>
<h3>Gain from Investment</h3>
<p>The gain can be determined as:</p>
<p><em>Initial revenue from offer &#8230; + &#8230;. income from sells beyond the limits of the offering &#8230; + &#8230; income from life long purchases</em></p>
<p><em><strong>T*(S-G*S) &#8230; + &#8230; R*T*(A-O) &#8230; + &#8230; T*N*L </strong></em></p>
<p>or &#8230;</p>
<p>500*($15-.5*$15) &#8230; + &#8230; + .8*500*($50-$30) &#8230; + &#8230; 500*.4*$150 = <strong>$41,750</strong></p>
<h3>Official ROI</h3>
<p><strong>ROI =</strong> ($41,750 &#8211; $37,833)/($37,833) =<strong> 10.35%</strong></p>
<p>KEEP IN MIND THAT THIS ROI IS FOR THE PERIOD YOUR CONSIDERING FOR BRAND VALUE AND PATRON LIFETIME (if you&#8217;ve entered a value assuming 1 year, 2 years, 3 years, etc, this is the ROI for that period).</p>
<p>Also keep in mind that these are hypothetical numbers. Your numbers will most likely be different.</p>
<h2><strong>Calculation details for Masochists<br />
</strong></h2>
<h3>TOTAL INITIAL INCOME</h3>
<p>How much money do you receive from GroupOn the day after the sell? This is the total number of certificates sold minus GroupOn&#8217;s cut, or:</p>
<p><em><strong>T*(S-G*S)</strong></em> = 500 * ($15 &#8211; $15*.5) = $3,750</p>
<h3>AMOUNT OF LOSS BASED ON REDEMPTION OF CERTIFICATES</h3>
<p>For every certificate redeemed, you are going to have to give away a certain amount of inventory, service, etc (O=$30), but the cost to you will be less than the certificate amount because of your margin:</p>
<p><em>O/(1+M) =&gt; $30/(1.5)=&gt; $20</em> (what it costs you to redeem a certificate)</p>
<p>You also will be able to make a profit on the average ticket amount above the offer amount, or the total income above this amount minus the cost:</p>
<p><em>(A-O) &#8211; (A-O)/(1+M) =&gt; ($50-$30) &#8211; ($50-$30)/(1.5) =&gt; $20-$13.33 = $6.67</em> (additional profit per redeemed certificate based on assumed Average Ticket)</p>
<p>So for each certificate redeemed, your profit is most likely negative:</p>
<p><em>(A-O)-(A-O)/(1+M) &#8211; O/(1+M) = $6.67 &#8211; $20 =  &#8211; $13.33</em></p>
<p>But some people will not redeem their certificates, which means free money for you! Taking into account the total number of certificates sold (T=500) and the redemption rate (R=.8) leads to an updated equation of:</p>
<p><em><strong>R*T*</strong>[<strong>(A-O)-(A-O)/(1+M) - O/(1+M)] </strong></em>=&gt; .8*500*[($50-$30) - ($50-$30)/(1+.5) - $30/(1+.5)] <strong>=</strong> -$5,332.</p>
<p>So at this point, you have gained initial income of $3,750 and, over the course of several months, it is forecasted to cost you $5,332 leading to a net loss of $1,582&#8230; but there are some additional potential benefits.</p>
<h3>NEW PATRON BENEFIT</h3>
<p>We&#8217;ve talked about the obvious income and costs, but there are other benefits. The idea of paying for a print ad seems pretty reasonable because it might attract new patrons and you&#8217;re willing to pay money for it, so why not GroupOn? It is advertising and seems pretty effective at getting people to show up.</p>
<p>You&#8217;ve made an assumption about how much the average new patron will spend at your organization over their lifetime (L=$100). So the amount of profit you expect to make from the average new patron, after you take into account the costs associated with the transactions is:</p>
<p><em>L-L/(1+M) =&gt; $150 &#8211; $150/(1+.5) = $50</em></p>
<p>When taking into account the promotion by GroupOn, people sharing the information with friends, buyers bringing friends with them to redeem certificates, etc., you expect a certain number of new patrons tied to the number of certificates sold (T=500) and a New Patron Percentage (N=.4). This results in an expected increase of profit of:</p>
<p><em><strong>T*N*(L-L/(1+M)</strong> =&gt; 500*.4*($150-$150/(1+.5)) = $10,000</em></p>
<p>There are 3 major things that should be noted:</p>
<ol>
<li>The lifelong value of a customer is hard to determine and we kind of made up the actual number. We also made up how we calculated the number of new patrons your promotions will generate.</li>
<li>It might or might not take into account the viral nature of new patrons bringing along friends and introducing them to your organization. This is potentially a chain reaction that can greatly amplify this number.</li>
<li>Lifelong value is something that can build up over a very long time. This is not a quick income event and will likely be spread over a period of years.</li>
</ol>
<p>With that being said, the running tally of the GroupOn benefit is now at a Net Profit (over time) of $10,000 &#8211; $1,582 = $8,418 in profits.</p>
<h3>BRAND DAMAGE</h3>
<p>Do these deep discounts damage a brand&#8217;s image and lead to reduced sales? I don&#8217;t know, but we&#8217;ve assumed it does and have pulled out of thin air a number to represent the decreased regular income from running this promotion (V=$4,500). Since this is &#8220;top line revenue,&#8221; to understand the impact on the bottom line, we need to consider your Margin.</p>
<p><em><strong>(V-V/(1+M))</strong>=&gt; (-$4,500 &#8211; (-$4,500)/(1.5))=-$1,500</em></p>
<h2>Additional Comments</h2>
<p>This was a lot of work so please let me know if I made any mistakes. Also, if anyone wants to build a calculator to run these numbers, let me know!</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=qFcmC0PYf7U:0dWHgTYw4FM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=qFcmC0PYf7U:0dWHgTYw4FM:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=qFcmC0PYf7U:0dWHgTYw4FM:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=qFcmC0PYf7U:0dWHgTYw4FM:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=qFcmC0PYf7U:0dWHgTYw4FM:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=qFcmC0PYf7U:0dWHgTYw4FM:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=qFcmC0PYf7U:0dWHgTYw4FM:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=qFcmC0PYf7U:0dWHgTYw4FM:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=qFcmC0PYf7U:0dWHgTYw4FM:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=qFcmC0PYf7U:0dWHgTYw4FM:TzevzKxY174"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=TzevzKxY174" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=qFcmC0PYf7U:0dWHgTYw4FM:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=l6gmwiTKsz0" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/CommunityCultivator/~4/qFcmC0PYf7U" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.o2p.org/2010/05/group-on-roi-the-math/feed/</wfw:commentRss>
		<slash:comments>16</slash:comments>
		<enclosure url="http://www.o2p.org/wp-content/uploads/2010/07/GroupOn-Calculator.xls" length="20480" type="application/vnd.ms-excel" /><media:content url="http://www.o2p.org/wp-content/uploads/2010/07/GroupOn-Calculator.xls" fileSize="20480" type="application/vnd.ms-excel" /><itunes:explicit>no</itunes:explicit><itunes:subtitle>Will GroupOn make your organization money? Calculate the ROI for GroupOn and find out.</itunes:subtitle><itunes:author>Marcel Crudele</itunes:author><itunes:summary>Will GroupOn make your organization money? Calculate the ROI for GroupOn and find out.</itunes:summary><itunes:keywords>Promotions, Technologies, GroupOn, online promotions, real value, ROI</itunes:keywords><feedburner:origLink>http://www.o2p.org/2010/05/group-on-roi-the-math/</feedburner:origLink></item>
		<item>
		<title>Scoutmob, GroupOn and other Flash Mob Promotions</title>
		<link>http://feedproxy.google.com/~r/CommunityCultivator/~3/KY8sv-Qu8EM/</link>
		<comments>http://www.o2p.org/2010/04/scoutmob-groupon-and-other-flash-mob-promotions/#comments</comments>
		<pubDate>Tue, 27 Apr 2010 17:08:46 +0000</pubDate>
		<dc:creator>Marcel Crudele</dc:creator>
				<category><![CDATA[Local Search]]></category>
		<category><![CDATA[Promotions]]></category>
		<category><![CDATA[David Payne]]></category>
		<category><![CDATA[Flash Mob]]></category>
		<category><![CDATA[gift certificate]]></category>
		<category><![CDATA[GPS]]></category>
		<category><![CDATA[GroupOn]]></category>
		<category><![CDATA[LBS]]></category>
		<category><![CDATA[Living Social]]></category>
		<category><![CDATA[mobile promotions]]></category>
		<category><![CDATA[restaurant.com]]></category>
		<category><![CDATA[ScoutMob]]></category>

		<guid isPermaLink="false">http://www.o2p.org/?p=1166</guid>
		<description><![CDATA[First, I want to make sure to emphasis that the term Flash Mob is not negative. My very loose definition for this post is &#8220;getting a large number of people to act in a certain way, usually through social media.&#8221; There are a number of emerging (or emerged) solutions that follow a basic recipe for [...]]]></description>
			<content:encoded><![CDATA[<p>First, I want to make sure to emphasis that the term <a title="Flash Mob" href="http://en.wikipedia.org/wiki/Flash_Mob" target="_blank">Flash Mob</a> is not negative. My very loose definition for this post is &#8220;getting a large number of people to act in a certain way, usually through social media.&#8221;</p>
<p>There are a number of emerging (or emerged) solutions that follow a basic recipe for what I call Flash Mob Promotions:</p>
<ol>
<li>Offer a ridiculously amazing special offer for a local business</li>
<li>Promote the crap out of it to people that love these deals</li>
<li>(Optional) Require that a certain number of people take advantage of the offer before it becomes &#8220;active&#8221;</li>
</ol>
<p>The motivation for local organizations is to get a boat load of people to visit them in the hopes of turning them into patrons and possibly spend money beyond the terms of the offer. To help you better understand what these solutions are all about, below is a description of a few companies active in this area. The hope is that it helps explain what they are offering so you&#8217;re better informed when they come a&#8217;knocking.</p>
<h2><a title="Restaurant.com" href="http://www.restaurant.com" target="_blank">Restaurant.com</a></h2>
<p>Restaurant.com is what I consider the predecessor of this movement and I don&#8217;t technically consider them to be Flash Mob Promotions, but they are worth understanding. From what I&#8217;ve heard, patrons love the deals, but restaurants aren&#8217;t the biggest fans.</p>
<ul>
<li><strong>Offer</strong> <strong>and Restrictions</strong> &#8211; Local restaurants sign up with Restaurant.com and configure their offer. This typically is in the form of a $25 gift certificate for $10, $50 gift certificate for $20, etc. They post the offer on their website and promote in various ways to get people to buy these certificates. Typical restrictions on these certificates are conditions like minimum purchase amounts, valid for dinner only, 18% gratuity automatically added to bill, excludes alcohol, expiration date, etc.</li>
<li><strong>Taking Advantage of Offer </strong>- The process for patrons is pretty straightforward
<ul>
<li>Go to restaurant.com</li>
<li>Search for a restaurant</li>
<li>Buy a certificate</li>
<li>It gets emailed to you</li>
</ul>
</li>
<li><strong>Promotion Channels</strong> &#8211; mostly through their website and email promotions. They don&#8217;t seem to take much advantage of social media.
<ul>
<li><a title="Restaurant.com on Facebook" href="http://www.facebook.com/pages/Restaurantcom/102950680273?ref=ts" target="_blank">Facebook</a> &#8211; 23,400 fans</li>
<li><a title="Restaurant.com on Twitter" href="http://twitter.com/Restaurant_com" target="_blank">Twitter</a> &#8211; 2,300 followers</li>
</ul>
</li>
<li><strong>Revenue model </strong>- They keep all of the money paid for the certificates.</li>
</ul>
<p>What they are selling is marketing. You give away $25 worth of food in exchange for new (hopefully) patrons and restaurant.com gets paid $10.</p>
<h2><a title="GroupOn" href="http://www.groupon.com" target="_blank">GroupOn</a><a title="GroupOn" href="http://www.groupon.com" target="_blank"><img class="alignright size-thumbnail wp-image-1182" style="border: 0pt none;" title="Group On Logo" src="http://www.o2p.org/wp-content/uploads/2010/04/groupon-logo-150x76.png" alt="Group On Logo" width="150" height="76" /></a></h2>
<p>Groupon has great buzz from both patrons and businesses. They have a <a title="Group On Explained" href="http://www.grouponworks.com/" target="_blank">video</a> to explain it, too.</p>
<ul>
<li><strong>Offer and Restrictions </strong>- You create a &#8220;Deal of the Day&#8221; with GroupOn (they only have one per market). Typically, these are offers similar to the ones described in the Restaurants.com model, but they seem much more savvy at getting the word out. Also, the ability to buy the certificates only lasts for one day (although they can be redeemed anytime before the expiration date), which creates a sense of urgency. As a final condition, a minimum number of people have to take advantage of the deal before &#8220;The deal is on&#8221; &#8211; if you are offering a $25 gift certificate for $10, you can specify that 200 people must take advantage of it before any can be officially sold.</li>
<li><strong>Taking advantage of Offer </strong>- The steps a patron follows to take advantage of an <a title="GroupOn patron process" href="http://www.vimeo.com/moogaloop.swf?clip_id=2112924" target="_blank">offer</a> are:
<ul>
<li>They find out about the deal of the day through email, Facebook, twitter, mobile app,  etc.</li>
<li>They indicate how many they are interested in buying and provide credit card information</li>
<li>As soon as the minimum number of participants is reached, &#8220;the deal is on&#8221; and everyone&#8217;s credit cards are charged</li>
<li>Users can log in to their GroupOn account and print the offer.</li>
<li>At anytime before the expiration date, they can use the certificate &#8211; subject to the terms of use</li>
</ul>
</li>
<li><strong>Promotion Channels</strong> &#8211; GroupOn is much more savvy about using social media than Restaurant.com&#8230; they actually have a separate Twitter account and Facebook page for each city. They also use email alerts as well as their website and a mobile app.
<ul>
<li><a title="GroupOn Atlanta on Facebook" href="http://www.facebook.com/grouponatl" target="_blank">Facebook</a> &#8211; 7,600 for Atlanta (23,000 fans for Chicago)</li>
<li><a title="GroupOn Atlanta on Twitter" href="http://twitter.com/grouponatlanta" target="_blank">Twitter</a> &#8211; 3,000 for Atlanta (10,000 followers for Chicago)</li>
</ul>
</li>
<li><strong>Revenue model</strong> &#8211; Groupon keeps a portion of the purchase price and gives the rest to the business. I&#8217;ve heard this is typically 50%. Business receives their cut immediately after the Deal of the Day expires.</li>
</ul>
<p>The big benefit I see for businesses is cash flow &#8211; you get paid up front for all of the purchased certificates. You also hope the deal will drive traffic, gain  new patrons that have a significant life-long value, and that the  average ticket price will exceed any offer&#8217;s limit.</p>
<p>The concerns I have are related to cost. How many new patrons will you get, what do your margins look like, what will be your average ticket amount? In short, does this make business sense? Unfortunately, you have to decide that. Also, some business have expressed concern about how offering such deep discounts may affect their brand image.</p>
<p>NOTE: There are a few other sites, like <a title="How Living  Social works" href="http://livingsocial.com/deals/how_it_works" target="_blank">LivingSocial</a> that use a similar model.</p>
<h2><a title="Scoutmob" href="http://www.scoutmob.com" target="_blank">ScoutMob</a><a title="ScoutMob" href="http://www.scoutmob.com" target="_blank"><img class="alignright size-thumbnail wp-image-1184" style="border: 0pt none;" title="ScoutMob Logo" src="http://www.o2p.org/wp-content/uploads/2010/04/scoutmob-logo-150x150.png" alt="ScoutMob Logo" width="150" height="150" /></a></h2>
<p>Scoutmob is a newer entrant into the market and is based in Atlanta (yeah!).</p>
<ul>
<li><strong>Offer and Restrictions </strong>- ScoutMob doesn&#8217;t sell gift certificates/coupons, they market promotions of ridiculously great offers. You make a deal with ScoutMob to be their deal of the day (generally 40% to 60% discount) and tell them how many people have to subscribe to the offer before the &#8220;deal is on&#8221; (similar to GroupOn). They then promote the crap out of you and hope the minimum number of people sign up. Another difference compared to GroupOn is that GroupOn only makes the deal available for one day, but purchased certificates have an expiration date. ScoutMob makes their offers available over a period of time (seems like about 3 months), but promote you heavily on the day the deal is announced. On the day your deal launches, people can have the coupon texted or emailed to them, after that they can only redeem the offer through the mobile app and have to be at your location (determined through GPS) to access the coupon.</li>
<li><strong>Taking Advantage of Offer</strong> &#8211; Scoutmob uses a slightly different <a title="How ScoutMob works" href="http://www.scoutmob.com/howitworks" target="_blank">model</a> than GroupOn for deals. This is divided into how they handle Deals of the Day versus how they handle the offer through their mobile App.
<ul>
<li>Mobile App
<ul>
<li>A person launches the app and can browse all of the deals that are still active &#8211; including the deals close to them (determined by their GPS location)</li>
<li>If they find a deal they want, they go to the business and &#8220;Redeem&#8221; the offer.</li>
<li>ScoutMob checks their GPS location to see if they are actually at the business and, if so, displays the offer.</li>
<li>The offer is shown to the business and marked as &#8220;used&#8221;</li>
<li>Patron gets the discount</li>
</ul>
</li>
<li>Deal of the Day &#8211; from the ScoutMob website. This only works for the deal of the day, <strong>not</strong> for deals that launched on previous days.
<ul>
<li>People find out about the deal of the day through email, Facebook, Twitter, etc.</li>
<li>They specify they want the deal and receive a text message to their cell phone (you can have it emailed if you want a physical coupon)</li>
<li>The patron shows the offer at the business and gets the deal. Both the text message and email have an expiration date associated with them.</li>
</ul>
</li>
</ul>
</li>
<li><strong>Promotion Channels</strong> &#8211; ScoutMob uses similar promotion methods to GroupOn, however, because patrons can opt into offers over a longer time, ScoutMob has added functionality on their mobile apps that allow people to redeem on the go&#8230;  based on where they are (this is called Location Based Service or LBS).
<ul>
<li><a title="ScoutMob on Facebook" href="http://www.facebook.com/scoutmob" target="_blank">Facebook</a> &#8211; 2,000 followers</li>
<li><a title="ScoutMob on Twitter" href="http://twitter.com/scoutmob" target="_blank">Twitter</a> &#8211; 5,100 for Atlanta</li>
</ul>
</li>
<li><strong>Revenue model</strong> &#8211; ScoutMob&#8217;s pricing model has 2 parts:
<ul>
<li>Deal of the Day texts and emails &#8211; they charge a small fee for each message sent</li>
<li>Mobile App Redemption &#8211; they charge a few dollars for each offer redeemed through their app. This is more because the business knows that the patron was actually at their location (GPS confirmed in order for the patron to gain access to the offer).</li>
</ul>
</li>
</ul>
<p>One of the benefits that I really like about ScoutMob is the mobile app redemption&#8230; you actually know the number of people that were in your business (or really close by). Similar to GroupOn, the big goal is trying to drive traffic and, since ScoutMob doesn&#8217;t require people to pay anything up front, there is an argument to be made that more patrons will take advantage of their offers.</p>
<p>The concern is still cost. Does ScoutMob actually drive traffic, gain new patrons, and lead to ticket amounts that exceed offer limits? Maybe. They might even do it better than GroupOn, but with GroupOn you get the up front cash benefit, although with ScoutMob it seems like you get to keep more of each transaction.</p>
<p>* Special thanks to David Payne from ScoutMob for giving me the 411!</p>
<h2>Conclusion</h2>
<p>All of this is really, really cool stuff and is only going to get cooler. The biggest problem I see is tying the business decision to ROI&#8230; I smell a future blog post!</p>
<p>I would love to hear about people&#8217;s experiences using these or similar offerings as well as from the providers themselves!</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=KY8sv-Qu8EM:rMDRdoPfQ38:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=KY8sv-Qu8EM:rMDRdoPfQ38:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=KY8sv-Qu8EM:rMDRdoPfQ38:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=KY8sv-Qu8EM:rMDRdoPfQ38:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=KY8sv-Qu8EM:rMDRdoPfQ38:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=KY8sv-Qu8EM:rMDRdoPfQ38:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=KY8sv-Qu8EM:rMDRdoPfQ38:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=KY8sv-Qu8EM:rMDRdoPfQ38:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?i=KY8sv-Qu8EM:rMDRdoPfQ38:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=KY8sv-Qu8EM:rMDRdoPfQ38:TzevzKxY174"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=TzevzKxY174" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/CommunityCultivator?a=KY8sv-Qu8EM:rMDRdoPfQ38:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/CommunityCultivator?d=l6gmwiTKsz0" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/CommunityCultivator/~4/KY8sv-Qu8EM" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.o2p.org/2010/04/scoutmob-groupon-and-other-flash-mob-promotions/feed/</wfw:commentRss>
		<slash:comments>4</slash:comments>
		<enclosure url="http://www.vimeo.com/moogaloop.swf?clip_id=2112924" length="-1" type="application/x-shockwave-flash" /><media:content url="http://www.vimeo.com/moogaloop.swf?clip_id=2112924" type="application/x-shockwave-flash" /><itunes:explicit>no</itunes:explicit><itunes:subtitle>First, I want to make sure to emphasis that the term Flash Mob is not negative. My very loose definition for this post is &amp;#8220;getting a large number of people to act in a certain way, usually through social media.&amp;#8221; There are a number of emerging </itunes:subtitle><itunes:author>Marcel Crudele</itunes:author><itunes:summary>First, I want to make sure to emphasis that the term Flash Mob is not negative. My very loose definition for this post is &amp;#8220;getting a large number of people to act in a certain way, usually through social media.&amp;#8221; There are a number of emerging (or emerged) solutions that follow a basic recipe for [...]</itunes:summary><itunes:keywords>Local Search, Promotions, David Payne, Flash Mob, gift certificate, GPS, GroupOn, LBS, Living Social, mobile promotions, restaurant.com, ScoutMob</itunes:keywords><feedburner:origLink>http://www.o2p.org/2010/04/scoutmob-groupon-and-other-flash-mob-promotions/</feedburner:origLink></item>
	<media:credit role="author">Marcel Crudele</media:credit><media:rating>nonadult</media:rating><media:description type="plain">Exploring how local organizations connect to their real world patrons</media:description></channel>
</rss>

