<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	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/"
	>

<channel>
	<title>Flint Analytics</title>
	<atom:link href="http://flintanalytics.com/feed/" rel="self" type="application/rss+xml" />
	<link>https://flintanalytics.com/</link>
	<description></description>
	<lastBuildDate>Thu, 10 Sep 2020 17:59:22 +0000</lastBuildDate>
	<language>en-US</language>
	<sy:updatePeriod>
	hourly	</sy:updatePeriod>
	<sy:updateFrequency>
	1	</sy:updateFrequency>
	<generator>https://wordpress.org/?v=6.5.5</generator>
	<item>
		<title>Why Local Websites Make Sense For The Customer &#038; For Home Services Businesses With Many Locations</title>
		<link>http://flintanalytics.com/why-local-websites-make-sense-for-the-customer-for-home-services-businesses-with-many-locations/</link>
		
		<dc:creator><![CDATA[Tim Flint]]></dc:creator>
		<pubDate>Tue, 14 Apr 2020 17:28:19 +0000</pubDate>
				<category><![CDATA[Blog]]></category>
		<guid isPermaLink="false">http://flintanalytics.com/?p=3563</guid>

					<description><![CDATA[<p>National brands such as Vivint, TruGreen, Davey Tree, Terminix etc. are more than just national brands. With their network of local stores and representatives, they are a network of local businesses. While a national brand, these types of home services businesses are also your neighbor. National brands create jobs in the local area. And because [&#8230;]</p>
<p>The post <a href="http://flintanalytics.com/why-local-websites-make-sense-for-the-customer-for-home-services-businesses-with-many-locations/">Why Local Websites Make Sense For The Customer &#038; For Home Services Businesses With Many Locations</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p>National brands such as Vivint, TruGreen, Davey Tree, Terminix etc. are more than just national brands. With their network of local stores and representatives, they are a network of local businesses. While a national brand, these types of home services businesses are also your neighbor. National brands create jobs in the local area. And because customers look more than ever to buy local and have a local experience, national home services companies must give them that buying experience. Customers want the local buying experience because it feels personal, they know you understand them, and they know the local store can better answer their questions.<br></p>



<p>In fact, according to a recent study <a href="http://www.yodle.com/downloads/what-consumers-want-from-local-businesses.pdf">by Yodle of 6,000 consumers</a>, “The majority of consumers find that local businesses outperform national chains on service and quality. For example, 96% think that local businesses offer more personalized service.”<br></p>



<blockquote class="wp-block-quote is-layout-flow wp-block-quote-is-layout-flow"><p>Multi-location businesses should put as much care and focus at presenting themselves as a local business online as they do offline. Because you wouldn&#8217;t try and service the whole US out of one location. So why should you service the whole internet out of one domain, that isn&#8217;t customized to the local market.</p></blockquote>



<p>While we know and understand that local home service company locations operate much like a local business and are truly their neighbors, customers aren’t going to often see it that way. Because for all that national businesses do to be local in their market in the physical sense, they often don’t take the same care to make a truly local online buying experience.<br></p>



<h2 class="wp-block-heading">What Customers Look for in a Local Online Buying Experience</h2>



<p>So, what is a local buying experience in an online context for the customer like? Currently when a customer goes to a well run local-only business website:<br></p>



<ul><li>They go to a domain that is all about that product or service in that local market</li><li>It has a local phone number all over the site. It doesn’t feel like if they call the number they are calling a call center</li><li>It has the local address all over the site</li><li>It might have a picture or information about the local manager</li><li>It might talk about local charities that they sponsor</li><li>It’s going to use local terminology when talking about the areas that they cover. This could include copy that uses things such as demonyms that reference people in their area.</li><li>Its product images on the site might look like homes in their area or even have pictures of famous local places</li><li>The copy is going to mention throughout the website the area that they serve and make references to it so that customers know you are in their area, even if they don’t come into the site from the homepage or a “local store page”</li><li>They know if there is pricing or bundle information that the listed prices and bundles will be available in their area</li><li>The social profiles on the site will link to local social profiles and not a corporate profile, and the content on the social account will have locally relevant content.</li><li>The copy won’t talk about having to deal with snow if there is never any snow there, and won’t talk about ocean views if there are no oceans there. All copy and product feature benefits will only speak to needs that are relevant locally.</li></ul>



<p>So, if you truly want the customer to feel you are local, then these are the kinds of things a customer is going to expect. The problem has traditionally been how do we deliver this level of experience that a local-only business can provide, but do it at scale for every local office or store? National businesses have been able to do this kind of localization and personalization with their physical stores and local salespeople. So why can’t they do it with their website and create digital-personalization?&nbsp;<br></p>



<p>We know that if we create a local online buying experience that this kind of personalization pays dividends for local stores, as local businesses often see higher conversion rates than a national brand online when all things are equal. This is because their site only talks about their local market, and generally only gets traffic from their local market.&nbsp;<br></p>



<h2 class="wp-block-heading">How to Create a Local Online Experience as a National Brand</h2>



<p>So is it possible to provide this level of customer service online at scale for a national brand? Historically no, or at least not without an incredible amount of investment. The reason it isn’t possible is because of the amount of manpower it would take for a national brand to have hundreds of local websites that are consistent in brand feel, while maintaining a local experience. And this manpower effort has made it be too prohibitive for businesses to do.&nbsp;<br></p>



<p>But with the right technology platform, such as Campfire by Flint Analytics, it is possible. That’s because you can easily create unique local content across hundreds of websites and manage them as if they are one. And this can be done while still letting truly unique local customization or digital personalization that customers want. So instead of having to repeat the process of managing a site 100 times for 100 stores, we can do it with the effort of managing 2 websites for 100 stores or the effort of managing 3 websites for 1,000 stores.</p>



<p>This platform truly lets your national brand be as local online as it is in its physical stores. All the effort to locally hire a knowledgeable sales team and customer service reps or to find good retail locations can be hindered if you present your local store as just another cog in the corporate wheel online.</p>



<p>And when you have locally personalized sites customers love it. Our clients generally have a corporate site with a local directory structure that you might find on almost any <a href="https://flintanalytics.com/multilocation-business-marketing/">multi-location business site</a>. And they can perform very well. But, our clients also have a local website or domain for every store as well. The local store’s websites organic visitors generally convert at more than 2.5 times as well as the corporate website.&nbsp;</p>



<figure class="wp-block-image"><img decoding="async" src="https://lh5.googleusercontent.com/2Sdrgfou2p7ujNbYTexqeVsue4aQyBYjX8Uuefd2og95M2ok2VuqmtP7w72zEXcaZO_fDovZivhmcCAIQj7E8QY72wTvmrUlkEfqL8uZfk5WcBkkjyg8wqrF1wMbeq9CSfxQpu2y" alt=""/></figure>



<p>*Does not include phone calls that increase the conversion rate by 50%</p>



<p>And if you are thinking that’s just because local pages convert higher already than the main corporate pages, so that is to be expected. It’s true corporate local pages convert better than the rest of the site, but local websites convert even better than the local corporate pages. Because when comparing a local directory page on corporate to local sites we generally see a bump of between 20% to 50% increase in conversion rate.&nbsp;<br></p>



<h2 class="wp-block-heading">Common Concerns About How Search Engines Work with Local Sites</h2>



<p>So customers like the experience better, but we are often asked about what Google and the search engines think. When doing anything online, we need to pay attention to how it affects the search engines and how they view your site or in this case “sites.” Does Google also like local websites? And will it hurt traffic to the primary domain? Or am I just cannibalizing my current efforts? What about duplicate content?</p>



<p>These are all important questions to ask. And issues we have studied and experimented with for years. So let’s start with these questions one by one.</p>



<h3 class="wp-block-heading">Does Google Like Local Websites?&nbsp;</h3>



<p>We have researched over and over and have found that Google loves local-only websites. Google loves local websites for many of the same reasons that customers do. The CTA’s are normally clear as to who to reach out to. The content is about one specific location. The sites generally aren’t trying to do too much. Local sites are simple for Google to understand. Google also likes that they are only trying to rank in one specific area. They know they aren’t trying to rank outside that area.&nbsp;</p>



<h4 class="wp-block-heading">Google Often Ranks Well-Managed Local Websites Above their National Competitors</h4>



<p>There are several things that help us understand this. First and foremost, Google often ranks well-managed local websites above their national competitors. This is true not only in the local pack but in the regular organic results. <a href="https://drive.google.com/file/d/1yvbLIjGgtVVlvv8xfyVzOgSMeHEW8Cpl/view?usp=sharing">At the link </a><a href="https://www.google.com/search?ei=79aUXuP7G8W4tQbjt434AQ&amp;q=pittsburgh+blinds&amp;oq=pittsburgh+blinds&amp;gs_lcp=CgZwc3ktYWIQAzICCAAyAggAMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB4yBggAEBYQHjoECAAQRzoFCAAQkQI6BAgAEANKDAgXEggxMC05N2czM0oKCBgSBjEwLTNnOFD5uytYur8rYPLAK2gAcAV4AIABpQGIAcwDkgEDNS4xmAEAoAEBqgEHZ3dzLXdpeg&amp;sclient=psy-ab&amp;ved=0ahUKEwijr53lqeboAhVFXM0KHeNbAx8Q4dUDCAw&amp;uact=5">here</a> you can find just one of many examples where local sites are outranking much bigger websites with much greater authority for local terms.&nbsp;</p>



<p><a href="https://www.google.com/search?ei=4daUXvvvLsaUtAbMmoOICA&amp;q=pittsburgh+windows&amp;oq=pittsburgh+windows&amp;gs_lcp=CgZwc3ktYWIQAzIGCAAQBxAeMgYIABAHEB4yBggAEAcQHjICCAAyBggAEAcQHjIGCAAQBxAeMgYIABAHEB4yBggAEAcQHjIGCAAQBxAeMgYIABAHEB46BAgAEEc6BAgAEA1KDAgXEggxMC04MGc1MkoKCBgSBjEwLTVnN1CKT1iwXmC2X2gAcAN4AIABbIgB-AWSAQM5LjGYAQCgAQGqAQdnd3Mtd2l6&amp;sclient=psy-ab&amp;ved=0ahUKEwi75NneqeboAhVGCs0KHUzNAIEQ4dUDCAw&amp;uact=5">In this example</a>, the search phrase we used was “pittsburgh windows”. In the local pack, you will notice that the top spot was held by Pittsburgh Window &amp; Door co. Also, notice another local company held the top organic spot. Notice using the Moz extension the top 3 organic listings have the lowest domain authority of any site in the regular organic listings, yet they rank first. This listing not only beats out Renewal By Anderson, but Anderson Windows, &amp; Pella windows which are much larger nation window companies. And not only did they outrank the big companies in the space but they outrank aggregators such as Yelp, HomeAdvisor, Angie&#8217;s List and others. This is very common as it isn’t even the only local only site that is ranking above much more difficult competitors.&nbsp;</p>



<figure class="wp-block-image size-large"><img fetchpriority="high" decoding="async" width="609" height="780" src="https://flintanalytics.com/wp-content/uploads/2020/04/Screen-Shot-2020-04-13-at-5.18.37-PM.png" alt="" class="wp-image-3565" srcset="http://flintanalytics.com/wp-content/uploads/2020/04/Screen-Shot-2020-04-13-at-5.18.37-PM.png 609w, http://flintanalytics.com/wp-content/uploads/2020/04/Screen-Shot-2020-04-13-at-5.18.37-PM-234x300.png 234w, http://flintanalytics.com/wp-content/uploads/2020/04/Screen-Shot-2020-04-13-at-5.18.37-PM-550x705.png 550w, http://flintanalytics.com/wp-content/uploads/2020/04/Screen-Shot-2020-04-13-at-5.18.37-PM-450x576.png 450w" sizes="(max-width: 609px) 100vw, 609px" /><figcaption>Notice how using the Moz toolbar you can see small domain authority sites competing well against national competitors.</figcaption></figure>



<p>This type of result is repeated over and over again for local searches in the <a href="https://www.s24security.com/">home security</a> <a href="https://www.google.com/search?ei=MNiUXqDAIIz5tAbFvIqIBQ&amp;q=raleigh+home+security+systems&amp;oq=raleigh+home+security+systems&amp;gs_lcp=CgZwc3ktYWIQAzIGCAAQCBAeMgYIABAIEB4yBggAEAgQHjIFCAAQzQI6BAgAEEc6BAgAEA06BggAEAcQHjoICAAQCBAHEB46CAgAEAgQDRAeSgkIFxIFMTItODdKCAgYEgQxMi05UN4yWPBIYLhQaAFwAXgAgAFsiAGyBpIBAzguMZgBAKABAaoBB2d3cy13aXo&amp;sclient=psy-ab&amp;ved=0ahUKEwigmKr-quboAhWMPM0KHUWeAlEQ4dUDCAw&amp;uact=5">space</a>, in the <a href="https://www.google.com/search?ei=PdiUXveZDtG0tAaNt6eADg&amp;q=shutters+indianapolis&amp;oq=shutters+indianapolis&amp;gs_lcp=CgZwc3ktYWIQAzICCAAyBggAEBYQHjIGCAAQFhAeMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB46BAgAEEc6BAgAEEM6BQgAEJECOgUIABCDAToHCAAQgwEQQzoICAAQFhAKEB5KKQgXEiUwZzk2Zzc2Zzc1Zzk0Zzc1ZzY5ZzYzZzY0ZzY3Zzc0Zzk0ZzMxSh0IGBIZMGcxZzFnMWcxZzFnMWcxZzFnMWc1ZzVnNlD4uwNYjd0DYJ7eA2gAcAR4AIABZYgBpguSAQQyMC4xmAEAoAEBqgEHZ3dzLXdpeg&amp;sclient=psy-ab&amp;ved=0ahUKEwi3rLGEq-boAhVRGs0KHY3bCeAQ4dUDCAw&amp;uact=5">window treatments space</a>, and in the <a href="https://www.google.com/search?ei=59iUXrqLN4_StQa6rYKAAg&amp;q=garage+door+miami&amp;oq=garage+door+miami&amp;gs_lcp=CgZwc3ktYWIQAzICCAAyAggAMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB4yBggAEBYQHjoECAAQRzoFCAAQkQI6BAgAEAo6BQgAEIMBSg8IFxILMTAtNjZnNjdnNzNKDQgYEgkxMC03ZzEzZzFQijVYoWNg_mVoC3ADeACAAZkBiAHtCZIBBDE2LjKYAQCgAQGqAQdnd3Mtd2l6&amp;sclient=psy-ab&amp;ved=0ahUKEwj6muLVq-boAhUPac0KHbqWACAQ4dUDCAw&amp;uact=5">garage door space</a>. Pick any industry and do test searches for things like Window Shutters Indianapolis, Roofers Louisville, Kitchen Remodel Miami, Lawncare Phoenix, etc. and you will find local businesses outranking their large national competitors.  So what would happen if you could scale local sites? </p>



<p>We have worked with many home services businesses and have seen how effective creating local sites for each store can be. For example, one of <a href="https://flintanalytics.com/work/">our clients</a> in home services who we have been working with for 5 years is using this strategy. When we started with them they had a series of local pages and had all local listings such as Google My Business pointing to their corporate site.&nbsp;</p>



<p>When we set up these local sites and pointed their local listings to the local site, we quickly began to see these sites start to rank. And the corporate site has not just maintained organic traffic but has continued to gain organic traffic. 5 years later corporate site organic traffic is up 105%. This is great news, but it is nothing compared to what has happened with the local sites. When you combine the new local traffic with corporate traffic compared to the same time period in 2015, traffic in 2019 was up 17x.&nbsp;<br></p>



<figure class="wp-block-image"><img decoding="async" src="https://lh6.googleusercontent.com/ZT8QoVaOJstlE7kupigg53pQo9xaYNxxohHhFGkZ9ik0xq6ugYzMWYW_5guZvok0v3jnkYb0R1kgHRRXbJjPtWd29rvje5cIGQIJY6kLktbsg_jDK6NXDM8fsqVNlESgayUVrWBg" alt=""/></figure>



<p>And these are highly converting keywords we are getting because remember the traffic on the local sites converts better than the traffic on corporate ever did as we see conversion rates for the local sites when combining calls and forms of close to 10%. And the traffic growth continues as in January 2020 YOY growth of the local programs was up more than 20%.&nbsp;<br></p>



<h4 class="wp-block-heading">There Are More Spaces to Rank for Locally-Based Searches</h4>



<p>The reason local traffic continues to grow is that there is so much space in locally-based searches. In fact, it is bigger than most marketers realize because when you only have a single page or even a series of pages targeting localized search you miss out on all the other terms people might be using to find your products in your service area. Also, most on-site directories are only able to effectively rank for the terms in their store’s main market.</p>



<p>For example, if you had one store in Fort Lauderdale, you might have a page about Fort Lauderdale, but you might not have pages for Pompano Beach, Oakland Park, etc. that are areas you service. Our sites target both the primary market, in this case, “Fort Lauderdale,” and the secondary markets such as Pompano Beach and Oakland Park. This gives companies a lot more coverage to rank in searches. And when you rank for all this local content, you have a much greater opportunity to get into more local packs as well.&nbsp;</p>



<p>So this not only improves representation in the local results but improves representation in the local pack as well. Most of our clients see 30% of their organic SEO traffic coming from the local pack or maps listings and the rest coming from a regular search. However, the local pack is more valuable as it makes up 50% of local leads.&nbsp;</p>



<p>We track about 5000 keywords for the stores in our Sunburst program. These are both secondary market keywords and primary market keywords. Across all stores, we rank on the first page for 98% of the keywords and in the top three for 77% of them.<br></p>



<h3 class="wp-block-heading">Will It Hurt My GMB Rankings?</h3>



<p>We often hear that people think this will hurt their GMB rankings. It is quite the opposite. In fact, it often increases the number of times you are able to show up. When your GMB page only points to a local page and there is no other content for that store in that region, your site will only show up for so many search terms. But with a whole site dedicated to that market, the amount of times you can be shown in Google My Business grows, which increases your local traffic and GMB impressions.</p>



<h3 class="wp-block-heading">Will Local Sites Cannibalize My Traffic?</h3>



<p>This is a common question we get, and we like to talk about how big the local keyword universe is. And we can’t expect a single page about a service in a given city to be effective at capturing all the search share for the various ways people will type in information about that business. The keyword universe is huge with local search. And if your business offers: blinds, shades, curtains, shutters, roller shades, etc. it is going to have a hard time ranking for the following keywords with a single webpage:</p>



<ul><li>Roller Shades Indianapolis&nbsp;</li><li>Shutters Indianapolis</li><li>Curtains Indianapolis</li><li>Blinds Indianapolis</li><li>Shades Indianapolis</li></ul>



<p>But this is what most multi-location businesses are trying to do, and it isn’t working. They might be able to rank for a couple of those, but they won’t rank for the rest.<br></p>



<p>Our data backs up that our local website strategy doesn’t cannibalize corporate site traffic. For example, with Sunburst we saw interesting things happen. We saw the amount of local search traffic the corporate site captures remains the same even 5 years later. So all their organic growth came from head terms or terms that weren’t local in nature. This is a great opportunity for the SEO and content team to spend less time on local search and more time on high funnel traffic to build the authority of the corporate domain, which will only help the local sites.<br></p>



<p>Also, not only does this strategy not cannibalize traffic, but it takes away spots in the search results of your competitors. If you rank the corporate site and the local site for the same term, that is one less spot on the front page for your competitors to get. In fact, we get many of our clients for highly competitive terms to rank 1 and 2 for terms. Most often with the local site outranking the corporate site. And if you are running paid ads, you are making up a significant portion of the search results page.<br></p>



<h3 class="wp-block-heading">Will Multiple Domains Hurt My Corporate Domain Authority?</h3>



<p>We also get asked about what having multiple sites effects are on the domain authority on the corporate website. This is a vital question as people are concerned that it will harm rankings for other parts of the site. As mentioned in the Sunburst Shutters example, there was no negative effect on corporate website traffic or domain authority. GMB and other listings sites generally aren’t passing much authority or not enough to make a difference to the corporate site and the kind of links they get don’t really help for the broad terms the corporate site is focused on. While there might be short term cannibalization, Sunburst’s corporate traffic very quickly had increased to well beyond what was there before.</p>



<p>Also, while you no longer have these local listings links pointing to you, you gain an entire network of locally and topically relevant sites linking back to corporate, which is often even more powerful for corporate.</p>



<p>And perhaps most importantly, since the only links that are changing are the links from local listings and GMB, these are the easiest links to change back. So if for some reason it wouldn’t work it could always be changed back and there wouldn’t be any long term effects on your business if you were to try it.</p>



<h3 class="wp-block-heading">Won’t This Create A Lot Of Duplicate Content?</h3>



<p>Our system creates a lot of content and a lot of content at scale, but none of it is duplicate for several reasons:</p>



<ul><li>We create extensive variable lists about each location and use that information in our copy to make it unique.</li><li>Our writers and system rewrite the content where we know every variation, but the software picks the variations our writers put in for key phrases, synonyms, and variables. This creates unique content that is drastically more unique than most corporate directories that are out there. Because, most corporate directory pages on the internet have the exact same copy on every local page, with only the name of the city changed.</li><li>These sites are only meant to rank in their local area and Google recognizes that. Very rarely will you see more than one local site rank for the same search term and this only ever happens if someone uses a search term without a geo-modifier where we wrote a better piece of content then everyone else out there. In cases like these, we can take up the first several pages for that term.</li></ul>



<h2 class="wp-block-heading">Don’t you just recommend this to everyone?</h2>



<p>While we think our system is great, it isn’t right for every client. There are businesses with many stores we don’t recommend it to because they are either too small or they’re too big or their product isn’t sold this way. i.e. This specific approach isn’t good for a Starbucks or even a good user experience for their customers. But for businesses with considered purchases where research is involved and where there are many stores that each serve a large area, this can be a powerful tool.<br></p>



<h2 class="wp-block-heading">Is A Multi-website Solution Right For You?</h2>



<p>Your customers want to buy locally and have a local experience. They also are going to not see you as much of a local organization by default. You have to work harder to help them realize how local you are. A local site strategy gives the customers that feel of being a local business in an authentic way that doesn’t trick them. It also increases your conversion rates and gives you access to the much larger local organic search universe.</p>



<p>And with a system like Campfire you can also run a local website strategy that gives corporate strong brand controls. To find out if it’s right for you give us a call at 317.658.0831 or fill out the <a href="https://flintanalytics.com/contact/">form here</a>.<br></p>



<blockquote class="wp-block-quote is-layout-flow wp-block-quote-is-layout-flow"><p></p></blockquote>
<p>The post <a href="http://flintanalytics.com/why-local-websites-make-sense-for-the-customer-for-home-services-businesses-with-many-locations/">Why Local Websites Make Sense For The Customer &#038; For Home Services Businesses With Many Locations</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></content:encoded>
					
		
		
			</item>
		<item>
		<title>The Only Two Metrics That Actually Matter In Advertising</title>
		<link>http://flintanalytics.com/only-two-metrics-that-matter-advertising/</link>
		
		<dc:creator><![CDATA[Amanda Lane]]></dc:creator>
		<pubDate>Wed, 04 Sep 2019 19:06:54 +0000</pubDate>
				<category><![CDATA[Analytics]]></category>
		<category><![CDATA[Blog]]></category>
		<guid isPermaLink="false">http://flintanalytics.com/?p=3488</guid>

					<description><![CDATA[<p>There are only two metrics that actually matter in advertising: cost and revenue. Cost is readily available in all ad platforms, but revenue can be difficult and costly to obtain. Because of this, many agencies and marketing departments fail to track this crucial metric, leaving them to spend client dollars blindly. Advertising’s Sole Purpose Is [&#8230;]</p>
<p>The post <a href="http://flintanalytics.com/only-two-metrics-that-matter-advertising/">The Only Two Metrics That Actually Matter In Advertising</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p>There are only two metrics that actually matter in advertising: cost and revenue. Cost is readily available in all ad platforms, but revenue can be difficult and costly to obtain. Because of this, many agencies and marketing departments fail to track this crucial metric, leaving them to spend client dollars blindly.</p>



<h2 class="wp-block-heading">Advertising’s Sole Purpose Is to Drive Sales </h2>



<p>It’s easy to lose focus on the ultimate goal of sales with the staggering amount of data relating to bounces, traffic, impressions, view counts, likes, comments, shares, and heart reactions. But, bounce rates become irrelevant when your content doesn’t sell. Traffic doesn’t matter when your website doesn’t convert. Facebook page likes are completely meaningless when people don’t click your posts.</p>



<p>It’s not that marketing VPs, account executives, and creative directors don’t agree with the sentiment that advertising should drive sales, it’s that they fall into the trap of trying to derive value from sources where there is none.&nbsp;</p>



<p>This phenomenon goes back a lot further than just the digital age, as made evident by this <a href="https://www.youtube.com/watch?v=Br2KSsaTzUc">David Ogilvy clip</a> from several decades ago:</p>



<p>Ogilvy praises direct advertisers for their ability to measure results “to a dollar.” While the entire 7-minute speech is worth a listen, the relevant sentiment is best summed up here:</p>



<p><em>You direct response people know what kind of advertising works and what doesn&#8217;t work, you know to a dollar&#8230;The general advertisers and their agencies know almost nothing for sure because they cannot measure the results of their advertising.</em></p>



<p>We recently worked with a client who had been sold (and burned) by another agency that Ogilvy might call <em>general</em>. The client had entrusted the agency with a 6-figure ad buy promoting a single event, and they were rightfully furious that the agency was unable to tell them how much revenue had been generated after the campaign was done (though, I’m sure the agency’s accountant had no problem telling the client how much money they’d spent). That client contracted Flint Analytics to fix and automate their revenue attribution, making tracking a non-issue for future campaigns.</p>



<p><em><a href="https://flintanalytics.com/services/analytics/">Learn how Flint Analytics may be able to help you solve your company’s revenue attribution problems.</a></em></p>



<p>We believe there is a certain amount of negligence and irresponsibility in spending client dollars without having the slightest idea how much value that client received in return. For ecommerce, you can and should know, down to the dollar, your earnings from each individual advertising source. For clients with longer sales cycles involving multiple consultations and touchpoints, you can and should know, at a minimum, the source of every single lead generated. If you cannot report on the true business impact of your spend, <strong>you are doing your client a disservice</strong>.</p>



<p>If you’re the type who can <em><a href="https://www.youtube.com/watch?v=o1GBvlxyI58">sell a ketchup popsicle to a woman in white gloves</a></em>, and you use that ability to convince clients to spend money on the idea that weak metrics like social follows or heart emojis on posts are absolutely good for business, you’re sitting somewhere between misguided and dishonest.</p>



<h2 class="wp-block-heading">The Narrative Fallacy</h2>



<p>To be fair, a lot of marketing professionals seem to honestly and wholeheartedly believe that increased pageviews, lower bounce rates, higher domain authority, and more social engagement <em>definitively</em> (key word) lead to more sales. This is innocent enough. When agencies and marketing departments are technically incapable of tracking actual sales results, they tend to justify their strategies, actions, and budgets by taking any stats they can &#8212; no matter their relevance &#8212; and creating causal links where they might not actually exist. In his book <em><a href="https://www.amazon.com/Black-Swan-Improbable-Robustness-Fragility/dp/081297381X/ref=sr_1_1?keywords=black+swan+book&amp;qid=1567193950&amp;s=gateway&amp;sr=8-1">The Black Swan</a></em>, Nassim Taleb writes extensively on this practice, referring to it as the <em>narrative fallacy</em>. He writes:</p>



<p><em>The narrative fallacy addresses our limited ability to look at sequences of facts without weaving an explanation into them, or, equivalently, forcing a logical link, an arrow of relationship, upon them. Explanations bind facts together. They make them all the more easily remembered; they help them make more sense. </em><strong><em>Where this propensity can go wrong is when it increases our impression of understanding.</em></strong></p>



<p>Think about that in the context of digital marketing: sometimes all we have are sequences of facts in the form of sessions, bounce rates, engagement, view counts, impressions, and more. It’s information overload, and our job security is partially dependent on convincing clients and superiors that we can make sense of it all.</p>



<p>Any marketer with a basic Google Analytics setup &#8212; but no way to tie revenue back to its source &#8212; is probably guilty of committing a narrative fallacy. If quarterly sales increased, they might tell their CEO that increased web traffic from clicks on a Facebook campaign were the root cause of the increase in sales. If this marketer was an agency pitching a potential client whose sales had been dropping, they may point to a lack of advertising budget as the root cause. The same goes for anyone pitching or justifying SEO work, a creative strategy, or social media management: these are all things that <em>can </em>help business, but they do not <em>definitively</em> do so.</p>



<p>This is why revenue tracking is so important: it eliminates the human tendency to rely on biases and allows you to focus on identifying marketing practices that have real, valuable business impact. It is only through knowing how much money your efforts made that you can accurately analyze if the money you spent was worth it.</p>



<h3 class="wp-block-heading">Need Help with Revenue Tracking?</h3>



<p>The technical process of tracking revenue is extensive and worthy of volumes, which is why we’ve limited this article mostly to the importance of this data point. If your company or your client is struggling with revenue attribution, contact us to schedule a free consultation.<br></p>
<p>The post <a href="http://flintanalytics.com/only-two-metrics-that-matter-advertising/">The Only Two Metrics That Actually Matter In Advertising</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></content:encoded>
					
		
		
			</item>
		<item>
		<title>3 Little-Known Features to Improve Your Google My Business Page</title>
		<link>http://flintanalytics.com/3-ways-improve-google-my-business-page/</link>
		
		<dc:creator><![CDATA[Chelsea Flint]]></dc:creator>
		<pubDate>Tue, 14 May 2019 15:48:16 +0000</pubDate>
				<category><![CDATA[Content Marketing]]></category>
		<category><![CDATA[Local Marketing]]></category>
		<guid isPermaLink="false">http://flintanalytics.com/?p=3434</guid>

					<description><![CDATA[<p>Google My Business (GMB) is becoming more and more important to small businesses and franchises that want to market to local customers. That’s because your local listing can be one of the first things that show up when customers look for you. It can even help improve your company’s local SEO. You’re probably familiar with [&#8230;]</p>
<p>The post <a href="http://flintanalytics.com/3-ways-improve-google-my-business-page/">3 Little-Known Features to Improve Your Google My Business Page</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p>Google My Business (GMB) is becoming more and more important to small businesses and franchises that want to market to local customers. That’s because your local listing can be one of the first things that show up when customers look for you. It can even help <a href="https://flintanalytics.com/5-ways-to-increase-local-seo-for-franchisees/">improve your company’s local SEO</a>.<br></p>



<p>You’re probably familiar with GMB’s main features. You list your business on it with your address, contact information, website, maybe a few photos, and your hours of operation. However, you may not be familiar with some features they’ve released within the past year and how these features can improve your Google My Business page.<br></p>



<p>By using these 3 features, your customers will have more opportunities to interact with your business so you can <a href="https://flintanalytics.com/services/seo-and-search-engine-marketing/">stand out from your local competition with your listing</a>.<br></p>



<h2 class="wp-block-heading">#1 Products Catalog &#8211; A Great Way to Showcase Your Merchandise</h2>



<p>The products catalog lets you showcase all of your products and group them by collections. To add a product and/or collection, go to the Products tab on the left of your Google My Business’s profile.</p>



<figure class="wp-block-image is-resized"><img decoding="async" src="https://lh3.googleusercontent.com/dZQvj3_fZSLqASwLxEtkeldj08OYAwvMPqWjbJNR4T3tkZobkV4EzixCeyqV4tz-strG4OTgrsO4D6KqoBKUHH9LQh1jSqzPhoOtWKKqOiZhZp_hrTuRJFbfGtJmf4iFATN3Zwg1" alt="" width="234" height="270"/></figure>



<p>Once you’re in the products section, you can start building products and collections.<br></p>



<figure class="wp-block-image"><img decoding="async" src="https://lh3.googleusercontent.com/Tc6_2qeUjDApsrlQplOcM53vXHzUjwMq49D-nkrcTYod6Zk_tWUl3EeRkHkLtGeKddYtFwHCN-DRgmgFupfH3RAt2pudk4JroXBGfZ2Ft-Bb25NPJ-FJGGxii-S7gGzXE20Ey2zA" alt=""/></figure>



<p>A product is a single item you sell, while a collection is a group of products that are tied together. So if you sell pet supplies, you might have a pet food collection and a separate pet accessories collection, each with products in those categories.<br></p>



<p>For each product that you list you can add:</p>



<ul><li>Product image</li><li>Collection </li><li>Product name &nbsp;(optional)</li><li>Additional details &nbsp;(optional)</li><li>Price (optional)</li></ul>



<p>If you sell dozens of products, start small. Choose to highlight only your most popular products first, and once those are built out you can add more.<br></p>



<p>While product posts work for most industries, there are restrictions on products for alcohol, gambling, financial services, etc.</p>



<h2 class="wp-block-heading">#2 Google My Business Questions &amp; Answer to Answer Customer Questions</h2>



<figure class="wp-block-image"><img decoding="async" src="https://lh6.googleusercontent.com/jpqwaeDJyp01OB10G_jkST9ZYm-bhJWYiC1AvT_hicWI6kRffwBOf2mZrqr20_VTh3Z4Vk8jCj283fFqL4aiOrcLTuorx0kf4HDhZ5tupbJeEp6xcyu8De6nID48luogQk9RuF95" alt=""/></figure>



<p>The Q&amp;A feature is another GMB feature that not many business owners are aware of. In this section of GMB anyone can ask or answer questions about your business. You may have a customer ask about your hours or about your return policy. Their question can be answered by either you or other customers. <br></p>



<p>A good practice is to set up notifications so you can quickly answer any questions that a customer might have. You can try experimenting with the Q&amp;A by putting in a few of your most common questions from customers using your business profile. Then go back and answer those questions so customers can have more information about your store. <br></p>



<p>There are some restrictions on the Q&amp;A section. You can’t put links to websites, email addresses or phone numbers. However, you can also report comments if you feel like someone is abusing the system.<br></p>



<h2 class="wp-block-heading">#3 Google My Business Posts to Increase Engagement</h2>



<p>Another Google My Business newer feature is posts. A GMB Post is a short snippet that will show up on your profile for 7 days before being retired to the posts page. Here’s an example of a product post for a shutters company.<br></p>



<figure class="wp-block-image"><img decoding="async" src="https://lh4.googleusercontent.com/HHPd0rUR7VQGLPqMjh8PcFpSVox5ctmJeZ-mXv5n5trARgS70ZAyLvp8hUFQvcI3K-2GKr3JhZrBaJOfbZc_hACSqiyVoin41K1g7MsEO_9GS-EqL1w2g8K3H6r43mhCmkbNHeCz" alt=""/></figure>



<p>There are four types of posts:</p>



<ul><li>What’s new</li><li>Events</li><li>Products</li><li>Offers</li></ul>



<p>What’s New posts talk about new things happening with your business. Events are to highlight upcoming events your business has like a Mother’s Day brunch or a yoga class. Products posts lets you showcase a featured product or up to 10 products outside of your catalog for 7 days. And Offers are where you can share promotional information like sales. &nbsp;<br></p>



<p>Posts can include a photo or video, short description, and button/link with a call to action. All of the posts will show on your Google My Business listing main page for 7 days before they’re retired to the posts section.<br></p>



<p>So there are your three little known features of Google My Business. Hopefully, by experimenting with some of these features, you can improve your Google My Business page and draw more local customers to your store.</p>



<h2 class="wp-block-heading">Do You Need Help Managing Multiple Google My Business Listings?</h2>



<p>If you’re a franchise or multilocation company that needs <a href="https://flintanalytics.com/services/seo-and-search-engine-marketing/">help with your GMB listings</a>, give us a call 317-576-2855 or fill out the form below. We can help you create your listings, get added to other local directories, and manage the listings for all of your locations to you improve your listings and save time on managing them.<br></p>
<p>The post <a href="http://flintanalytics.com/3-ways-improve-google-my-business-page/">3 Little-Known Features to Improve Your Google My Business Page</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></content:encoded>
					
		
		
			</item>
		<item>
		<title>Integrating Google Enhanced Ecommerce and the Facebook Pixel</title>
		<link>http://flintanalytics.com/integrating-google-enhanced-ecommerce-and-the-facebook-pixel/</link>
		
		<dc:creator><![CDATA[Amanda Lane]]></dc:creator>
		<pubDate>Thu, 09 May 2019 20:17:57 +0000</pubDate>
				<category><![CDATA[Analytics]]></category>
		<category><![CDATA[Blog]]></category>
		<guid isPermaLink="false">http://flintanalytics.com/?p=3424</guid>

					<description><![CDATA[<p>This article is for those who: use Google Tag Manager and the data layer to implement enhanced ecommerce (see our handy guide), use Google Tag Manager to manage their Facebook Pixel, and are interested in running dynamic retargeting ads for a Facebook Catalog.h In order to send existing enhanced ecommerce data into Facebook, you will [&#8230;]</p>
<p>The post <a href="http://flintanalytics.com/integrating-google-enhanced-ecommerce-and-the-facebook-pixel/">Integrating Google Enhanced Ecommerce and the Facebook Pixel</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p>This article is for those who:<br></p>



<ul><li>use Google Tag Manager and the data layer to implement <a href="https://flintanalytics.com/services/analytics/">enhanced ecommerce</a> (see <a href="https://flintanalytics.com/installing-enhanced-ecommerce-using-google-tag-manager-and-the-data-layer/">our handy guide</a>),</li><li>use Google Tag Manager to manage their Facebook Pixel, and</li><li>are interested in running dynamic retargeting ads for a Facebook Catalog.h</li></ul>



<p>In order to send existing enhanced ecommerce data into Facebook, you will have to fulfill the requirements needed to run your dynamic retargeting ads. At a minimum, you need to send the associated parameters for the <strong>ViewContent</strong>, <strong>AddToCart</strong>, and <strong>Purchase</strong> Facebook events. Each variable can be extracted from an existing enhanced ecommerce setup.</p>



<h2 class="wp-block-heading">Let&#8217;s Begin With Some User Defined Variables</h2>



<p>For starters, you’ll need to create a few user-defined variables in Google Tag Manager that will extract data from the enhanced ecommerce code and translate it into a format readable by Facebook. </p>



<h4 class="wp-block-heading">Variable 1: FB &#8211; Product Detail ID</h4>



<p>This first variable will pull the Product ID from a product detail impression. This will be used in both your <strong>ViewContent</strong> and <strong>AddToCart</strong> tags. The configuration for this is fairly simple, just create a data layer variable type named <strong>FB &#8211; Product Detail ID</strong> with the following settings:<br></p>



<figure class="wp-block-image"><img decoding="async" src="https://lh3.googleusercontent.com/ln86zx-hU58uikWM4uZY6zxAia-mlJm1Wrfwc61TxnjD6LZA1BN1PWztq3yN00snZBxkXKNdDSw_E0p53i93r6RqibtbDg8cUjTgtSFeFBfhKUhu68M1n5YHdDVsHBfLAsApcexi" alt=""/></figure>



<h4 class="wp-block-heading">Variable 2: FB &#8211; Revenue</h4>



<p>Then, you will need to send a value along with the <strong>Purchase </strong>event so you can properly track and optimize for revenue within Facebook. This can be extracted directly from the enhanced ecommerce purchase array that you should get every time a transaction occurs. <br></p>



<p>To do this, create a data layer variable type with the name <strong>FB &#8211; Revenue</strong> using the following settings:<br></p>



<figure class="wp-block-image"><img decoding="async" src="https://lh5.googleusercontent.com/lZTSijwrHYBENPLtdhWkkQXwsNoqacsLCkkOEh-qdVUTVyQr4HRIyGoQ4LkYgKKs5d8mLOcu1-HfJW8hlgtbnWoSqnImoczqoIWF9GZ0wum9BKmacESHtiD8nvqwZdVOd_KFIYOn" alt=""/></figure>



<h4 class="wp-block-heading">Variable 3: FB &#8211; ecommerce.purchase.products / FB &#8211; Purchase ID Array</h4>



<p>Additionally, you will need to send an array of product IDs to track which products were purchased by Facebook users. But to get to the end variable, we will actually need to create another variable first.<br></p>



<p>Therefore, create a data layer variable called <strong>FB &#8211; ecommerce.purchase.products</strong> with the following configuration:</p>



<figure class="wp-block-image"><img decoding="async" src="https://lh3.googleusercontent.com/kibaMVkQEjQ3nmwCZShvvJrEirdQI7uAbOgON5a7GZ7PVNvzugy3cEwU_DmDVVAGEbXkQ7o6Sycv0-dfyku8RwFzwPI-5TA1RbfszdUdO-Rw-JG2ZRmoqokCxNZS2aHvQuv0g-bH" alt=""/></figure>



<p>This will pull the individual product IDs from your purchase array. <br></p>



<p>Next, create a custom JavaScript variable in Google Tag Manager called <strong>FB &#8211; Purchase ID Array</strong> using the following script:<br></p>



<table class="wp-block-table"><tbody><tr><td>function() {<br> &nbsp;var products = {{FB &#8211; ecommerce.purchase.products}};<br> &nbsp;return products.reduce(function(arr, prod) { return arr.concat(prod.id); }, []);<br>}</td></tr></tbody></table>



<p>This will create an array of product IDs for all products that are purchased that can be passed into Facebook.<br></p>



<h2 class="wp-block-heading">Now You Can Configure Some Tags</h2>



<p>Using these variables, you can now configure tags for the Facebook events <strong>ViewContent</strong>, <strong>AddToCart</strong>, and <strong>Purchase</strong>. <br></p>



<p><strong>REMEMBER</strong>: Use advanced settings to make sure that your base Facebook Pixel fires before any of these tags, otherwise you risk losing data.</p>



<h3 class="wp-block-heading">Tag 1: ViewContent</h3>



<p>You can now create a custom HTML tag for sending a <strong>ViewContent </strong>event into Facebook. Use the following code:</p>



<table class="wp-block-table"><tbody><tr><td>&lt;script&gt;<br> &nbsp;fbq(&#8216;track&#8217;, &#8216;ViewContent&#8217;, {<br> &nbsp;content_ids: {{FB &#8211; Product Detail ID}},<br> &nbsp;content_type: &#8216;product&#8217;<br>});<br>&lt;/script&gt;<br><br>&lt;noscript&gt;<br>&lt;img height=&#8221;1&#8243; width=&#8221;1&#8243; alt=&#8221;&#8221; style=&#8221;display:none&#8221;<br>src=&#8221;https://www.facebook.com/tr?id=&lt;INSERT_FB_ID&gt;&amp;ev=ViewContent&amp;cd[content_ids]={{FB &#8211; Product Detail ID}}&amp;cd[content_type]=product/&gt;<br>&lt;/noscript&gt;</td></tr></tbody></table>



<p>As far as triggering goes, that is up to you. We typically set this as a pageview to a product page only so that we can limit tracking to meaningful content views only.<br></p>



<h3 class="wp-block-heading">Tag 2: AddToCart</h3>



<p>Your AddToCart tag should be triggered by your existing enhanced ecommerce <strong>addToCart</strong> trigger. Use the following code for this tag:</p>



<table class="wp-block-table"><tbody><tr><td>&lt;script&gt;<br> &nbsp;fbq(&#8216;track&#8217;, &#8216;AddToCart&#8217;, {<br> &nbsp;content_ids: {{FB &#8211; Product Detail ID}},<br> &nbsp;content_type: &#8216;product&#8217;<br>});<br>&lt;/script&gt;<br><br>&lt;noscript&gt;<br>&lt;img height=&#8221;1&#8243; width=&#8221;1&#8243; alt=&#8221;&#8221; style=&#8221;display:none&#8221;<br>src=&#8221;https://www.facebook.com/tr?id=&lt;INSERT_FB_ID&gt;&amp;ev=AddToCart&amp;cd[content_ids]={{FB &#8211; Product Detail ID}}&amp;cd[content_type]=product/&gt;<br>&lt;/noscript&gt;</td></tr></tbody></table>



<h3 class="wp-block-heading">Tag 3: Purchase</h3>



<p>Your <strong>Purchase</strong> tag will use the following code:<br></p>



<table class="wp-block-table"><tbody><tr><td>&lt;script&gt;<br> &nbsp;fbq(&#8216;track&#8217;, &#8216;Purchase&#8217;, {<br> &nbsp;content_ids: [{{FB &#8211; Purchase ID Array}}],<br> &nbsp;content_type: &#8216;product&#8217;,<br> &nbsp;value: {{FB &#8211; Revenue}},<br> &nbsp;currency: &#8216;USD&#8217;<br>});<br>&lt;/script&gt;<br><br>&lt;noscript&gt;<br>&lt;img height=&#8221;1&#8243; width=&#8221;1&#8243; alt=&#8221;&#8221; style=&#8221;display:none&#8221;<br>src=&#8221;https://www.facebook.com/tr?id=&lt;INSERT_FB_ID&gt;&amp;ev=Purchase&amp;cd[content_ids]=[{{FB &#8211; Purchase ID Array}}]&amp;cd[content_type]=product&amp;cd[value]={{FB &#8211; Revenue}}&amp;cd[currency]=USD/&gt;<br>&lt;/noscript&gt;</td></tr></tbody></table>



<p>In enhanced ecommerce, transactions are not events. Instead, they are actions defined in an array (as <a href="https://developers.google.com/tag-manager/enhanced-ecommerce#purchases">explained here</a>). For triggering, just use whatever identifier that confirms a transaction has occurred (ex. Confirmation Page viewed, button click event, etc).<br></p>



<h2 class="wp-block-heading">Summary</h2>



<p>These methods will not only save you time in setting up your Facebook Pixel for dynamic retargeting, they will also allow you to more easily integrate your Google and Facebook advertising strategies (which is also the subject of our next analytics article!). <br></p>



<h2 class="wp-block-heading">Need Help with Your Analytics Integration? </h2>



<p>Flint Analytics can help your company execute tough <a href="https://flintanalytics.com/services/analytics/">analytics setups</a> like this. If you want help, contact us for a free consultation today!<br></p>



<hr class="wp-block-separator"/>


[contact-form-7]



<hr class="wp-block-separator"/>
<p>The post <a href="http://flintanalytics.com/integrating-google-enhanced-ecommerce-and-the-facebook-pixel/">Integrating Google Enhanced Ecommerce and the Facebook Pixel</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></content:encoded>
					
		
		
			</item>
		<item>
		<title>Content is Hard, Time Consuming, And Invaluable</title>
		<link>http://flintanalytics.com/content-is-hard-time-consuming-and-invaluable/</link>
		
		<dc:creator><![CDATA[Amanda Lane]]></dc:creator>
		<pubDate>Thu, 25 Apr 2019 14:32:52 +0000</pubDate>
				<category><![CDATA[Blog]]></category>
		<guid isPermaLink="false">http://flintanalytics.com/?p=3426</guid>

					<description><![CDATA[<p>With the rise of social media influencers, some companies have decided to get out of the content game. Sure, they have a website, and perhaps a Facebook, Twitter, or Instagram account, but they’re rarely updated. They may even have a corporate blog section, even though it hasn’t been touched since Obama’s first term. It just [&#8230;]</p>
<p>The post <a href="http://flintanalytics.com/content-is-hard-time-consuming-and-invaluable/">Content is Hard, Time Consuming, And Invaluable</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p>With the rise of social media influencers, some companies have decided to get out of the content game. Sure, they have a website, and perhaps a Facebook, Twitter, or Instagram account, but they’re rarely updated. They may even have a corporate blog section, even though it hasn’t been touched since Obama’s first term. It just seems easier to pay an outside blogger to write articles on their own site, especially since some writers will push out articles simply for free samples. Isn’t that enough?<br></p>



<p>Using an outside voice can be a meaningful part of your marketing portfolio, but don’t expect their articles to help you generate a lot of web traffic. Bloggers have one, primary goal &#8212; increase readers for their blog. They may have an affiliate link or two that can help you make sales, but it’s kind of a crap shoot if those links convert. And those backlinks won’t necessarily help you, especially if the writing is poor or their domain authority is low.<br></p>



<p>What will help get you ahead of your competition, however, is for you to generate original blogs, white papers, or e-books for your own site. But why is <a href="https://flintanalytics.com/services/content-marketing/">content creation so important</a>?<br></p>



<h2 class="wp-block-heading"><strong>Content Plays Into The Science Of Searching</strong></h2>



<p>While it may not seem like it, SEO has a great deal of humanity in it. That’s because search engines like Google and Bing try to be as intuitive as possible. They need to ensure that you get exactly what you want every time you search. In response, our search queries have evolved from disjointed words to full sentences.<br></p>



<p>In the Olden Days, if you wanted to search for dairy-free ice cream, then you would be instructed to type in something like, <strong><em>“Dairy Free” + “Ice cream”. </em></strong>As searching became more intuitive, you could just type in <strong><em>dairy-free ice cream</em></strong><strong> </strong>without any extraneous punctuation marks and still get the same results. Basically, Google wants us to search like we talk, and let them do all the heavy lifting.<br></p>



<p>We’ve now taken this directive to the next level. We may still search for <strong><em>Dairy-Free Ice Cream, </em></strong>and get a slew of product homepages, but we also will type in <strong><em>the best dairy-free desserts</em></strong><em> </em>or <strong><em>What dairy-free ice cream can I serve at a kids birthday party?</em></strong><em>  </em>In these cases, the search engine pulls up pages that attempt to answer these questions, and a lot of times that isn’t a product’s homepage. <br></p>



<p>If you rely on contributors to answer these search queries, then you have little control over how these questions are answered. Some may represent your product well, many won’t. They may not even rank in search results. And even if they do, it’s the blogger’s site that will rank, not yours. Every click will go to their playground. To get to your site, the user will have to perform additional actions. <br></p>



<p>However, if you write your own articles on your own site, then searches will go directly to you. Having a blog that addresses different topics allow you to possibly rank in numerous search queries. By ranking for many different queries, your web traffic will start to climb exponentially. Of course, your content has to be pertinent, well-written, and <a href="https://flintanalytics.com/services/seo-and-search-engine-marketing/">properly formatted for SEO</a> &#8212; and that’s not always easy to do. <br></p>



<h2 class="wp-block-heading"><strong>Content Reinforces Your Brand</strong></h2>



<p>While it’s great to rank high in a Google search, that’s not the only reason to produce content. After all, you can be found in other ways, <a href="https://flintanalytics.com/services/pay-per-click-marketing/">like Pay Per Click</a>, Facebook remarketing, and traditional advertising. With the right targeting, these avenues may actually be more effective at driving people to your site. Although, they are usually limited-time campaigns that cost money.<br></p>



<p>Content is eternal and can be one of the best ways to establish your brand. With the glut of online and offline marketing, consumers have become inundated with noise. The old Mad-Men salesy shtick with a slick slogan and attractive logo doesn’t work much anymore, as most people will just filter that junk out. This is especially true in more niche markets, where customers are more discerning in what they buy or who they get services from. <br></p>



<p>A static website can establish a brand, but it won’t develop it. Even your heartwarming story about how your dairy-free desserts were developed from recipes handed down from your lactose-intolerant Nana-Booboo doesn’t mean much when it’s parked on your <em>About Us</em> page. These sections are important, but they may not mean very much to a consumer who can see hundreds of <em>About Us </em>pages talking about their own Nana-Booboo recipes.<br></p>



<p>When you develop content through a blog, white paper, or e-book, you give people a look at your company beyond the gimmick. Instead of yelling “LOOK AT ME” with the rest of the crowd, you develop your brand by talking about what’s most important to the customer. So while your website can talk about how much kids love your dairy-free ice cream, you show how much your product fits a child’s dairy-free lifestyle through blog articles on dairy-free birthday parties. This strategy goes beyond “becoming an expert in your field,” and connects you to your audience on topics that they actually care about.<br></p>



<h2 class="wp-block-heading"><strong>The Caveat &#8212; Your Content Has To Be Good</strong></h2>



<p>There&#8217;s a big catch on creating content &#8212; it needs to be good. Google and other search engines try to filter out junk that is poorly written, spammy, and/or unhelpful. A search engine’s reputation is based on good experiences and quality results, and that means it needs to lead people to pages that help fulfill their query. If your content is vague and meaningless, or repeats content that’s already is out there, Google will pass you over and all that hard work and time would be for naught.<br></p>



<p>If you have the time and talent to write engrossing web pages and blog articles, great. Just make sure you post new content consistently (more than one blog post a quarter). One article can help one query. A hundred articles can cast a much larger fishing net. And while content should be brand-building and customer-focused, is also needs to be structurally sound SEO-wise. Each article should use interlinks, keywords, and a strong call to action.<br></p>



<h2 class="wp-block-heading"><strong>Flint Analytics Can Help With Engaging Content Creation</strong></h2>



<p>Let Flint Analytics help you make content an integral part of your marketing portfolio. With strategic planning, SEO audits, and creative service, we can create engaging content that connects you to potential customers. Just contact us at 317-576-2855 and we can help you fulfill your goals.<br></p>
<p>The post <a href="http://flintanalytics.com/content-is-hard-time-consuming-and-invaluable/">Content is Hard, Time Consuming, And Invaluable</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></content:encoded>
					
		
		
			</item>
		<item>
		<title>5 Ways To Increase Local SEO For Franchisees</title>
		<link>http://flintanalytics.com/5-ways-to-increase-local-seo-for-franchisees/</link>
		
		<dc:creator><![CDATA[Chelsea Flint]]></dc:creator>
		<pubDate>Tue, 16 Apr 2019 17:09:11 +0000</pubDate>
				<category><![CDATA[Blog]]></category>
		<category><![CDATA[Local Marketing]]></category>
		<category><![CDATA[SEO]]></category>
		<guid isPermaLink="false">http://flintanalytics.com/?p=3416</guid>

					<description><![CDATA[<p>If you&#8217;re a local franchisee with a small budget, it can seem overwhelming to know how to increase your local SEO and compete against national companies. Luckily for you, it’s possible for your local website to rank higher than national brands online when you take a local strategy. Taking a local strategy is key because [&#8230;]</p>
<p>The post <a href="http://flintanalytics.com/5-ways-to-increase-local-seo-for-franchisees/">5 Ways To Increase Local SEO For Franchisees</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></description>
										<content:encoded><![CDATA[<p><span style="font-weight: 400;">If you&#8217;re a local franchisee with a small budget, it can seem overwhelming to know how to increase your local SEO and compete against national companies. Luckily for you, it’s possible for your local website to rank higher than national brands online when you take a local strategy. </span></p>
<p><span style="font-weight: 400;">Taking a local strategy is key because it’s easier to rank for local terms like “bike shop in Pittsburg” instead of “bike shop.” Google and other search engines want to give customers what they’re searching for. So if customers are looking for local businesses, that’s what Google shows them. </span></p>
<p><span style="font-weight: 400;">So how do you start building a local marketing and web strategy as a franchisee? It depends on how you’re set up as a franchisee.</span></p>
<p><span style="font-weight: 400;">If your franchise shows up as a page under your national franchise brand’s website, then you may not have as much control over your local SEO. So you should focus on the first two methods that aren’t on your website: local listings and reviews. Then you can try to persuade your corporate office to put more resources into local SEO by using the suggestions in the rest of the article. </span></p>
<h2><span style="font-weight: 400;">Get listed on Google My Business and other listing services</span></h2>
<p><span style="font-weight: 400;">When you search for a business category on Google &#8212; either by mobile or desktop &#8212; a map with some local listings is what first appears. These listings show the essential stats for a local business including their website, reviews, address, and phone. These stats come from Google My Business (GMB). It’s one of the main ways your local customers find you online.</span></p>
<p><span style="font-weight: 400;">For example, when you search for a local service like “Pet grooming Dayton Ohio” in Google, chances are one of the first results may be a map.</span></p>
<p><a href="http://flintanalytics.com/wp-content/uploads/2019/03/Pet-Grooming-Dayton.jpg"><img decoding="async" class="aligncenter size-full wp-image-3418" src="http://flintanalytics.com/wp-content/uploads/2019/03/Pet-Grooming-Dayton.jpg" alt="Google My Business map of pet grooming studio" width="813" height="754" srcset="http://flintanalytics.com/wp-content/uploads/2019/03/Pet-Grooming-Dayton.jpg 813w, http://flintanalytics.com/wp-content/uploads/2019/03/Pet-Grooming-Dayton-300x278.jpg 300w, http://flintanalytics.com/wp-content/uploads/2019/03/Pet-Grooming-Dayton-768x712.jpg 768w, http://flintanalytics.com/wp-content/uploads/2019/03/Pet-Grooming-Dayton-705x654.jpg 705w, http://flintanalytics.com/wp-content/uploads/2019/03/Pet-Grooming-Dayton-450x417.jpg 450w" sizes="(max-width: 813px) 100vw, 813px" /></a></p>
<p><span style="font-weight: 400;">Your potential customer can then click on one of these listings or go directly to a provider’s website or reviews. If the customer clicks on a listing, they’ll see this screen which shows them the business’ contact information, a link to the company’s website, reviews, photos, and questions and answers.</span></p>
<p><a href="http://flintanalytics.com/wp-content/uploads/2019/03/Oregon-Pet-Grooming.jpg"><img loading="lazy" decoding="async" class="aligncenter wp-image-3417 size-large" src="http://flintanalytics.com/wp-content/uploads/2019/03/Oregon-Pet-Grooming-1030x421.jpg" alt="" width="1030" height="421" srcset="http://flintanalytics.com/wp-content/uploads/2019/03/Oregon-Pet-Grooming-1030x421.jpg 1030w, http://flintanalytics.com/wp-content/uploads/2019/03/Oregon-Pet-Grooming-300x123.jpg 300w, http://flintanalytics.com/wp-content/uploads/2019/03/Oregon-Pet-Grooming-768x314.jpg 768w, http://flintanalytics.com/wp-content/uploads/2019/03/Oregon-Pet-Grooming-1500x613.jpg 1500w, http://flintanalytics.com/wp-content/uploads/2019/03/Oregon-Pet-Grooming-705x288.jpg 705w, http://flintanalytics.com/wp-content/uploads/2019/03/Oregon-Pet-Grooming-450x184.jpg 450w, http://flintanalytics.com/wp-content/uploads/2019/03/Oregon-Pet-Grooming.jpg 1735w" sizes="(max-width: 1030px) 100vw, 1030px" /></a></p>
<p><a href="https://flintanalytics.com/the-5-ws-of-local-directory-listing-for-franchises-and-multi-location-businesses/"><span style="font-weight: 400;">By building out your GMB listing</span></a><span style="font-weight: 400;"> you can increase your chances of being seen by your local customers and also give them relevant information like your hours, website link, reviews, etc.</span></p>
<p><span style="font-weight: 400;">Google My Business isn’t the only listing you should create. We recommend adding your business to other listings that your customers search for. These might include Yelp, TripAdvisor, Bing, Manta, etc. Find out which ones your customers search on and then add your business to those listings. You can also use local listing services to manage all of your listings.</span></p>
<h2><span style="font-weight: 400;">Solicit reviews from customers</span></h2>
<p><span style="font-weight: 400;">What’s one of the first steps customers take when researching local companies? Finding reviews of them online. </span></p>
<p><span style="font-weight: 400;">So if reviews are so important, how do you build up positive customer reviews from your customers?</span></p>
<h3><span style="font-weight: 400;">Decide which avenue(s) is most important and send customers there</span></h3>
<p><span style="font-weight: 400;">Some businesses may have customers looking them up on Facebook, while other franchisees’ customers look them up on Google or TripAdvisor. Find out which venue most of your customers look for and post reviews on and then focus your energy on those one or two platforms.</span></p>
<h3><span style="font-weight: 400;">Build a strategy for how you’ll get reviews</span></h3>
<p><span style="font-weight: 400;">If you want to build up your reviews, you need to be proactive and ask your customers for reviews. First, decide when you’ll ask your customer for a review. Is it in person? Through a follow-up text or email? The best time to ask for a review is when your customer has had some time using your product or service, but the experience is still fresh. Make it easy for them by including a link that sends them directly to where you want them to review.</span></p>
<h2><span style="font-weight: 400;">Optimize Your Site for SEO</span></h2>
<p><span style="font-weight: 400;">If, for example, you’re a franchisee of a pet boarding studio in Dayton, Ohio, you want to show up when people search for “pet boarding Dayton.” You can pay for Facebook ads or Google ads which cost money, or you can optimize your site for local SEO. Here are some basic steps to take to increase your local SEO by optimizing your site.</span></p>
<h3><span style="font-weight: 400;">Decide which local keywords you want to rank for</span></h3>
<p><span style="font-weight: 400;">Local keywords like “pet boarding Dayton” instead of just “pet boarding” are at the heart of your SEO strategy. By targeting local keywords, you have a higher chance of ranking higher in the search results, even against larger brands. Google knows that when a customer is searching for a local service like pet boarding, they want local results to show up.</span></p>
<p><span style="font-weight: 400;">So think of the product or services you offer and build a keyword list around them. If you want to get more advanced, you can do keyword research using tools like </span><a href="https://ads.google.com/home/tools/keyword-planner/"><span style="font-weight: 400;">Google Keyword Planner</span></a><span style="font-weight: 400;">, </span><a href="https://moz.com/explorer"><span style="font-weight: 400;">Moz Keyword Explorer</span></a><span style="font-weight: 400;">, or </span><a href="https://neilpatel.com/ubersuggest/"><span style="font-weight: 400;">Ubersuggest</span></a><span style="font-weight: 400;">.</span></p>
<p><span style="font-weight: 400;">For example, if you offer pet boarding for both cats and dogs as well as additional services like grooming you could try to rank for the terms:</span></p>
<ul>
 	<li style="font-weight: 400;"><span style="font-weight: 400;">Pet boarding studio Dayton</span></li>
<p> 	</p><li style="font-weight: 400;"><span style="font-weight: 400;">Dog boarding Dayton</span></li>
<p> 	</p><li style="font-weight: 400;"><span style="font-weight: 400;">Cat boarding Dayton</span></li>
<p> 	</p><li style="font-weight: 400;"><span style="font-weight: 400;">Pet grooming Dayton</span></li>
<p> 	</p><li style="font-weight: 400;"><span style="font-weight: 400;">Overnight pet boarding Dayton</span></li>
<p> 	</p><li style="font-weight: 400;"><span style="font-weight: 400;">Doggie daycare Dayton</span></li>
</ul>
<h3><span style="font-weight: 400;">Match those keywords to pages on your site</span></h3>
<p><span style="font-weight: 400;">Once you have your list of core local keywords, match them to pages on your site. If you have a page that currently has information on both overnight boarding and daytime boarding, consider splitting it into two pages so that you can rank for both terms.</span></p>
<p><span style="font-weight: 400;">You may need to build new pages or add new content to existing pages so that each of your core pages has a keyword that you want to rank for.</span></p>
<h3><span style="font-weight: 400;">Add those keywords to key parts of your pages</span></h3>
<p><span style="font-weight: 400;">You want to tell Google and other search engines exactly what each page is about, using your keyword strategy. So add your keyword phrase to your page’s title, headline, and 3-5 times in the text. Try to make your keywords as natural as possible, because it’s important that your customer has a good reading experience with your page. &nbsp;Also, avoid keyword stuffing where you’re putting a lot of keywords in your page so that you rank better because Google will penalize you for keyword stuffing.</span></p>
<h3><span style="font-weight: 400;">Explore more advanced SEO techniques</span></h3>
<p><span style="font-weight: 400;">Once you’ve built your keyword strategy, explore other ways to improve your site’s ranking. This can include your site’s organization and schema, increasing your site speed, etc. &nbsp;</span></p>
<h2><span style="font-weight: 400;">Create local content</span></h2>
<p><span style="font-weight: 400;">Local content such as articles or blog posts that focus on helping your local customers is a great local SEO strategy. That’s because:</span></p>
<ol>
 	<li style="font-weight: 400;"><span style="font-weight: 400;">Your customers search for local content</span></li>
<p> 	</p><li style="font-weight: 400;"><span style="font-weight: 400;">Writing content establishes you as a local authority for your customers </span></li>
<p> 	</p><li style="font-weight: 400;"><span style="font-weight: 400;">Google gives priority to local content and local content can rank higher than national content</span></li>
</ol>
<p><span style="font-weight: 400;">So maybe you write a blog post about how Dayton residents can prepare their pets for an overnight stay at your local boarding studio. You could focus on how Dayton’s weather and seasons might affect their pet, or benefits of your particular studio.</span></p>
<p><a href="https://flintanalytics.com/local-content-marketing-franchises/"><span style="font-weight: 400;">By taking a local focus</span></a><span style="font-weight: 400;">, you’re more likely to rank when your customers search for “preparing my pet for overnight stay Dayton” compared to a broader article where you’re competing with other boarding studios all over the nation. &nbsp;</span></p>
<h2><span style="font-weight: 400;">Get relevant backlinks</span></h2>
<p><span style="font-weight: 400;">Another way to increase your SEO rankings is by getting relevant backlinks. What are backlinks and why are they important? </span></p>
<p><span style="font-weight: 400;">Backlinks are when other websites link to your website. These websites could include publications like your local newspaper, industry listings such as Yelp, etc. When your site has backlinks from reputable websites that have a strong domain authority, then Google considers your site to be more trustworthy since these sites linked to you.</span></p>
<p><span style="font-weight: 400;">So think about ways to get backlinks to your site. Maybe you can be featured in a local newspaper story that’s posted online and linked to your site. Or you could join an industry publication or directory that includes a link to your site. </span></p>
<h2><span style="font-weight: 400;">Take the First Step to Increase Your SEO</span></h2>
<p><span style="font-weight: 400;">Now you know a few ways to increase your SEO on your website. Choose one strategy to start with and build from there. If you want some more help with local listings, writing localized content, or building a franchise listing contact us at 317-576-2855. &nbsp;</span></p>


<hr class="wp-block-separator"/>



<h2 class="wp-block-heading">Let us solve your SEO problem.</h2>


[contact-form-7]



<hr class="wp-block-separator"/>
<p>The post <a href="http://flintanalytics.com/5-ways-to-increase-local-seo-for-franchisees/">5 Ways To Increase Local SEO For Franchisees</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></content:encoded>
					
		
		
			</item>
		<item>
		<title>Property Management Company Gets 20 Localized Websites</title>
		<link>http://flintanalytics.com/case-study-j-c-hart-websites/</link>
		
		<dc:creator><![CDATA[Chelsea Flint]]></dc:creator>
		<pubDate>Thu, 22 Jun 2017 14:36:50 +0000</pubDate>
				<category><![CDATA[Blog]]></category>
		<category><![CDATA[Portfolio]]></category>
		<guid isPermaLink="false">http://flintanalytics.com/?p=2643</guid>

					<description><![CDATA[<p>J.C. Hart&#8217;s Website Challenge The J.C. Hart Company, an Indiana property management company with over 20 multi-family apartment communities, was spending too much time managing their websites and needed a better website solution so they could focus on other, more lucrative marketing initiatives. Their solution criteria included: A central interface so they could make changes [&#8230;]</p>
<p>The post <a href="http://flintanalytics.com/case-study-j-c-hart-websites/">Property Management Company Gets 20 Localized Websites</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></description>
										<content:encoded><![CDATA[<h2>J.C. Hart&#8217;s Website Challenge</h2>
<p>The J.C. Hart Company, an Indiana property management company with over 20 multi-family apartment communities, was spending too much time managing their websites and needed a better website solution so they could focus on other, more lucrative marketing initiatives. Their solution criteria included:</p>
<p><span class="list4">A central interface so they could make changes across 20 websites at once and reduce time spent on maintenance.</span></p>
<p><span class="list4">Unique, individualized content for each community’s website.</span></p>
<p><span class="list4">Fresh design that was fast and mobile responsive.</span></p>
<p><span class="list4">Tight integration with their current scheduling software, LeaseHawk, as well as their resident management software, ResMan.</span></p>
<h2>The Integrated Website Solution</h2>
<p class="normal">Having worked with Flint Analytics before on analytics projects, and knowing they had a multi-location website capability, J.C. Hart turned to them for help on their website redesign and relaunch.</p>
<blockquote><p>“There are plenty of companies that know what they’re talking about. The big differentiator with Flint Analytics is that they know what they’re talking about and execute in a timely manner.” -Mark Juleen, J.C. Hart V.P. of Marketing</p></blockquote>
<p>Together they worked on a website solution and design that would give J.C. Hart the ability to manage websites through a central interface and still have the flexibility to make changes at the property level. They could create a new page once and have it populated across all sites with each property’s unique information, name, and copy instead of having to do each page one at a time.</p>
<p>Branding was important, and J.C. Hart retained brand control over the sites while still having unique logos, photos, and copy for each property. Ryan Cox, J.C. Hart Digital Marketing Manager said, “One of the challenges was that a job this big (20 individual websites) is really 20 different brands, while carrying through one brand identity.”</p>
<p>Other website features included:</p>
<p>●&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The ability to quickly add new websites for properties that J.C. Hart had built or acquired</p>
<p>●&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prospects could schedule tours directly on the website with custom LeaseHawk API integration</p>
<p>●&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Resman custom API integrations including floor plans, pricing, and resident services</p>
<p>●&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Strong call to actions on mobile and desktop</p>
<p>●&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Photo galleries, floor plan, amenities, testimonials, and more</p>
<p>●&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Automated social media integration with Instagram</p>
<h2>Website Results</h2>
<h3>More Scheduled Tours and Better User Experience</h3>
<p><a href="http://flintanalytics.com/wp-content/uploads/2017/06/ScheduleTour.jpg"><img loading="lazy" decoding="async" class="aligncenter wp-image-2646 size-full" src="http://flintanalytics.com/wp-content/uploads/2017/06/ScheduleTour.jpg" alt="" width="1233" height="467" srcset="http://flintanalytics.com/wp-content/uploads/2017/06/ScheduleTour.jpg 1233w, http://flintanalytics.com/wp-content/uploads/2017/06/ScheduleTour-300x114.jpg 300w, http://flintanalytics.com/wp-content/uploads/2017/06/ScheduleTour-768x291.jpg 768w, http://flintanalytics.com/wp-content/uploads/2017/06/ScheduleTour-1024x388.jpg 1024w" sizes="(max-width: 1233px) 100vw, 1233px" /></a></p>
<p>The ability to easily schedule tours on their website was important, as J.C. Hart has learned that prospects who schedule tours are more likely to lease. Within the first couple of months they’ve had an uptick in scheduled tours, due to the strong CTAs on&nbsp;the website as well as the LeaseHawk integration. This was especially true for their apartments that cater to students and young professionals who are more likely to schedule online rather than call.</p>
<p>The J.C. Hart team has been pleased with the user experience on their sites.</p>
<blockquote><p>“I think on mobile they are ten times better than previous mobile sites. The way that they render on mobile is just so much better, and the way that people can navigate and calls to action on mobile are better.”</p>
<p>-Mark Juleen</p></blockquote>
<h3></h3>
<h3>Reduced Maintenance</h3>
<p>J.C. Hart reported reduced maintenance on their sites.</p>
<blockquote><p>“A centralized hub for mass-changes, and a decentralized exact-hub for individual properties is an excellent feature. Additionally, better websites (speed, content, layout, usability, UX, functionality) mean I’m having to make changes less, and the maintenance is definitely, significantly reduced.”</p>
<p>&#8211; Ryan Cox</p></blockquote>
<p>With their new websites, J.C. Hart has been able to begin focusing on other marketing initiatives while increasing their scheduled tours, reducing their time spent maintaining websites, and creating a better user experience, especially on mobile.</p>


<hr class="wp-block-separator"/>



<h2 class="wp-block-heading">Let us solve your apartment marketing problem. </h2>


[contact-form-7]



<hr class="wp-block-separator"/>
<p>The post <a href="http://flintanalytics.com/case-study-j-c-hart-websites/">Property Management Company Gets 20 Localized Websites</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></content:encoded>
					
		
		
			</item>
		<item>
		<title>Math for Marketers: Quadratic Trendlines</title>
		<link>http://flintanalytics.com/math-for-marketers-quadratic-trendlines/</link>
		
		<dc:creator><![CDATA[Amanda Lane]]></dc:creator>
		<pubDate>Wed, 22 Feb 2017 15:56:32 +0000</pubDate>
				<category><![CDATA[Analytics]]></category>
		<category><![CDATA[Blog]]></category>
		<guid isPermaLink="false">http://flintanalytics.com/?p=2607</guid>

					<description><![CDATA[<p>Disclaimer: We’re going to be using some calculus and linear regression here. The math can be a bit boring, so bear with me. We’ll get to the fun applied part after getting through some of the need-to-knows. If you&#8217;d like to skip the theory and go straight to the application, click here. Introduction At Flint [&#8230;]</p>
<p>The post <a href="http://flintanalytics.com/math-for-marketers-quadratic-trendlines/">Math for Marketers: Quadratic Trendlines</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></description>
										<content:encoded><![CDATA[<p style="text-align: center;"><em><strong>Disclaimer</strong><span style="font-weight: 400;">: We’re going to be using some calculus and linear regression here. The math can be a bit boring, so bear with me. We’ll get to the fun applied part after getting through some of the </span><span style="font-weight: 400;">need-to-knows</span><span style="font-weight: 400;">. If you&#8217;d like to skip the theory and go straight to the application, click <a href="#application">here</a>.</span></em></p>
<h3><span style="font-weight: 400;">Introduction</span></h3>
<p><span style="font-weight: 400;">At Flint Analytics, we specialize in hyper-local marketing strategies for multi-location businesses. What that means is that we utilize geographic siloing to a large degree: every city we’re marketing to kind of exists in its own little strategy bubble.</span></p>
<p><span style="font-weight: 400;">While this detailed level of attention yields fantastic results for our clients, it can make my job as an analyst very difficult. Things may look great for the client as a whole, but how do we sift through the data quickly and efficiently to know when things might be going wrong in, say, &nbsp;just the Oklahoma City market?</span></p>
<p><span style="font-weight: 400;">There are several different methods for accomplishing this goal. Today we’re going to discuss how to use quadratic trendlines and their mathematical properties to quickly and efficiently identify potential problems in your multi-location data.</span></p>
<p>&nbsp;</p>
<h3><span style="font-weight: 400;">What is a Quadratic Trendline?</span></h3>
<p><span style="font-weight: 400;">Generally, a quadratic trendline is a second-order polynomial which attempts to best fit a set of data. The equation will look something like this:</span>
</p><p style="text-align: center;"><em><span style="font-weight: 400;">[math]y=ax^2+bx+c[/math]</span></em></p>
<p><span style="font-weight: 400;">In our application, the x-value will be a measure of time like {1, 2, …, n}, and the y-value will be our KPI (sessions, leads, organic traffic, etc). The most important part of this equation is [math]ax^2[/math],&nbsp;</span><span style="font-weight: 400;">or the quadratic term within the equation, as it allows us to do some interesting analysis with regards to current trends and changes over time.</span></p>
<p><span style="font-weight: 400;">Let’s say you’re analysing traffic trends over a period of 60 days and your best fit quadratic trendline is:</span>
</p><p style="text-align: center;"><em><span style="font-weight: 400;">[math]y=.00297x^2-.179x+58.637[/math]</span></em></p>
<p><span style="font-weight: 400;">In your data, the x-values are days {1, 2, …, n}, and your y-values are the actual session counts for each day. Graphing this equation alongside the actual data looks like this:</span></p>
<p><img loading="lazy" decoding="async" class="aligncenter wp-image-2608 size-full" src="http://flintanalytics.com/wp-content/uploads/2017/02/image-3.png" alt="image-3" width="600" height="371" srcset="http://flintanalytics.com/wp-content/uploads/2017/02/image-3.png 600w, http://flintanalytics.com/wp-content/uploads/2017/02/image-3-300x186.png 300w" sizes="(max-width: 600px) 100vw, 600px" /></p>
<p><span style="font-weight: 400;">The blue line is the actual day-to-day data, and the red line is the quadratic trendline. You can easily notice two things:</span></p>
<ol>
 	<li style="padding-left: 30px;"><span style="font-weight: 400;">The day-to-day data fluctuates periodically every 7 or so days, suggesting some weekly trends.</span></li>
<p> 	</p><li style="padding-left: 30px;"><span style="font-weight: 400;">The trend line hits a low point somewhere in the late 20s or early 30s.</span></li>
</ol>
<p><span style="font-weight: 400;">With the periodicity of the day-to-day data, it’s very difficult to visualize whether things are trending in a good direction over time. One thing we could do is find the slope of the best fit line without a quadratic term. In this case, our equation would be:</span>
</p><p style="text-align: center;"><em><span style="font-weight: 400;">[math]y=.00286x+56.673[/math]</span></em></p>
<p><span style="font-weight: 400;">The slope tells us that things are technically trending positively over 60 days, but the coefficient .00286 is practically 0, which doesn’t really give us a lot to work with. This basically says “things are going up&#8230;barely.” The reason the quadratic equation gives us so much more to work with is that it has a critical point.</span></p>
<p><strong>Warning: Calculus Ahead</strong> <span style="font-weight: 400;">Let’s bring back the quadratic equation and take its first and second derivatives:</span>
</p><p style="text-align: center;"><em><span style="font-weight: 400;">[math]y=.00297x^2-.179x+58.673[/math]</span></em></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">[math]y&#8217;=.00594x-.179[/math]</span></em></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">[math]y&#8221;=.00594[/math]</span></em></p>
<p><span style="font-weight: 400;">From the first derivative, we can find that there is a critical point somewhere around day 30:</span>
</p><p style="text-align: center;"><em><span style="font-weight: 400;">[math]0=.00594x-.179[/math]</span></em></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">[math].179=.00594x[/math]</span></em></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">[math]x=30.13[/math]</span></em></p>
<p><span style="font-weight: 400;">From the second derivative, we know that the equation is convex. Recall these basic rules:</span>
</p><p style="text-align: center;"><em>If y’’ &gt; 0, y is convex</em></p>
<p style="text-align: center;"><em>If y’’ &lt; 0, y is concave</em></p>
<p><span style="font-weight: 400;">A concave function looks like a sweet Peyton Manning touchdown pass (it goes up then comes down), while a convex function is like a skater dropping into a halfpipe (you get it). Or, more precisely:</span></p>
<p><img loading="lazy" decoding="async" class="aligncenter size-full wp-image-2609" src="http://flintanalytics.com/wp-content/uploads/2017/02/utoronto.png" alt="utoronto" width="688" height="340" srcset="http://flintanalytics.com/wp-content/uploads/2017/02/utoronto.png 688w, http://flintanalytics.com/wp-content/uploads/2017/02/utoronto-300x148.png 300w" sizes="(max-width: 688px) 100vw, 688px" />
</p><p style="text-align: center;"><em><span style="font-weight: 400;">http://mjo.osborne.economics.utoronto.ca/index.php/tutorial/index/1/cv1/t</span></em></p>
<p><span style="font-weight: 400;">So we know that our trendline is convex and that it has a critical point around day 30. What that means from an analytics standpoint is that during the 60 day period of analysis, things had started off trending in a negative direction before they began trending positively around day 30. Maybe we started a new ad campaign on day 30? Maybe our luck turned around? The answer is irrelevant to the issue at hand: what’s important is that we now have a mathematical way of breaking out trends into two date ranges separated by a critical point.</span></p>
<p>&nbsp;</p>
<h3><span style="font-weight: 400;">Interpreting Trends with Convex and Concave Curves</span></h3>
<p><span style="font-weight: 400;">At any specific point in time, a quadratic trend can exist in 1 of 6 states, visualized below.</span></p>
<p><img loading="lazy" decoding="async" class="aligncenter size-full wp-image-2611" src="http://flintanalytics.com/wp-content/uploads/2017/02/Math-for-Marketers-Quadratic-Trendlines-1.png" alt="math-for-marketers-quadratic-trendlines" width="680" height="386" srcset="http://flintanalytics.com/wp-content/uploads/2017/02/Math-for-Marketers-Quadratic-Trendlines-1.png 680w, http://flintanalytics.com/wp-content/uploads/2017/02/Math-for-Marketers-Quadratic-Trendlines-1-300x170.png 300w" sizes="(max-width: 680px) 100vw, 680px" /></p>
<p>&nbsp;</p>
<p><span style="font-weight: 400;">If a trend is in the </span><strong>Negative, Decreasing</strong><span style="font-weight: 400;"> state, it is losing value over time but at a decreasing rate. This is important, because it tells us that each successive day is losing less value than it lost the day before and the trend is approaching a critical point. When the trend passes the critical point, it will generally move into the </span><strong>Positive, Increasing</strong><span style="font-weight: 400;"> state, which is commonly referred to as </span><em>hockey stick growth</em><span style="font-weight: 400;">.</span></p>
<p><span style="font-weight: 400;">If a trend is in the </span><strong>Positive, Decreasing</strong><span style="font-weight: 400;"> state, it is experiencing diminishing returns. A value in this state should be monitored for future changes, as passing the critical point will take it into the </span><strong>Negative, Increasing</strong><span style="font-weight: 400;"> state. In the latter state, value is diminishing at an increasing rate overtime, resembling a nosedive. </span></p>
<p><span style="font-weight: 400;">If your trend is in the </span><strong>Minima</strong><span style="font-weight: 400;"> state of a convex curve, it is expected to begin hockey stick growth the next day. If your trend is in the </span><strong>Maxima</strong><span style="font-weight: 400;"> state of a concave curve, it will begin its nosedive the next day.</span><span style="font-weight: 400;"></span></p>
<h3><span style="font-weight: 400;">&nbsp;</span></h3>
<h3><span style="font-weight: 400;">Translating the Math to Google Sheets or Excel</span></h3>
<p><span style="font-weight: 400;">Let’s take our data and create a report like this in Excel or Google Sheets:</span></p>
<p><img loading="lazy" decoding="async" class="aligncenter size-full wp-image-2612" src="http://flintanalytics.com/wp-content/uploads/2017/02/Report_Example.png" alt="report_example" width="346" height="168" srcset="http://flintanalytics.com/wp-content/uploads/2017/02/Report_Example.png 346w, http://flintanalytics.com/wp-content/uploads/2017/02/Report_Example-300x146.png 300w" sizes="(max-width: 346px) 100vw, 346px" /></p>
<p>This report allows us to quickly visualize the trends of our target cities. Each individual location will require the same analysis that I outline below, so as you’re reading, keep in mind that you will have to replicate this process multiple times.</p>
<p><span style="font-weight: 400;">Recall that we will need the actual day-to-day data, a set of days relative to 1, and the squared days. So, our data may look like this, where the grey-shaded cells correspond to the cell column and row references:</span>
</p><p style="text-align: center;"><i><span style="font-weight: 400;"><img loading="lazy" decoding="async" class="aligncenter size-full wp-image-2613" src="http://flintanalytics.com/wp-content/uploads/2017/02/Data_Table.png" alt="data_table" width="407" height="100" srcset="http://flintanalytics.com/wp-content/uploads/2017/02/Data_Table.png 407w, http://flintanalytics.com/wp-content/uploads/2017/02/Data_Table-300x74.png 300w" sizes="(max-width: 407px) 100vw, 407px" /></span></i><em><span style="font-weight: 400;">Data Table</span></em></p>
<p><span style="font-weight: 400;">In another table, we will estimate the quadratic trendline using the </span><i><span style="font-weight: 400;">linest()</span></i><span style="font-weight: 400;"> function, as well as perform the calculations necessary to find the critical point and the trend. Let’s say that we’re placing our data manipulations on the same sheet as the data table, starting at row 5. Our output for, say Oklahoma City, will look like this:</span>
</p><p style="text-align: center;"><img loading="lazy" decoding="async" class="aligncenter size-full wp-image-2614" src="http://flintanalytics.com/wp-content/uploads/2017/02/Data_Manipulations.png" alt="data_manipulations" width="509" height="72" srcset="http://flintanalytics.com/wp-content/uploads/2017/02/Data_Manipulations.png 509w, http://flintanalytics.com/wp-content/uploads/2017/02/Data_Manipulations-300x42.png 300w" sizes="(max-width: 509px) 100vw, 509px" /><em><span style="font-weight: 400;">Data Manipulations</span></em></p>
<p><span style="font-weight: 400;">Before getting into the calculations, let me explain the data contained in each column.</span></p>
<ul>
 	<li style="padding-left: 30px;"><span style="font-weight: 400;"><strong>x2</strong> &#8211; the coefficient on the quadratic term in the linear regression</span></li>
<p> 	</p><li style="padding-left: 30px;"><span style="font-weight: 400;"><strong>x</strong> &#8211; the coefficient on the x term in the linear regression</span></li>
<p> 	</p><li style="padding-left: 30px;"><span style="font-weight: 400;"><strong>CP</strong> &#8211; the critical point calculated from the linear regression</span></li>
<p> 	</p><li style="padding-left: 30px;"><span style="font-weight: 400;"><strong>Shape</strong> &#8211; whether the curve created by the linear regression is convex or concave</span></li>
<p> 	</p><li style="padding-left: 30px;"><span style="font-weight: 400;"><strong>Trend State</strong> &#8211; whether we are currently seeing the metric of interest increase or decrease and the acceleration of the change</span></li>
</ul>
<p><span style="font-weight: 400;">Now, let’s look at how to generate these calculations.</span></p>
<h4><span style="font-weight: 400;">The Linear Regression (Columns B and C)</span></h4>
<p><span style="font-weight: 400;">Here we use the </span><i><span style="font-weight: 400;">linest() </span></i><span style="font-weight: 400;">function to generate a regression equation in which </span><i><span style="font-weight: 400;">Total Traffic</span></i><span style="font-weight: 400;"> is the dependent variable and </span><i><span style="font-weight: 400;">Day</span></i><span style="font-weight: 400;"> and </span><i><span style="font-weight: 400;">Day</span></i><i><span style="font-weight: 400;">2</span></i> <span style="font-weight: 400;">are the independent variables. The </span><i><span style="font-weight: 400;">linest()</span></i><span style="font-weight: 400;"> function spreads each coefficient across several cells, so in order to contain our output to the first two coefficients, we use the </span><i><span style="font-weight: 400;">index()</span></i><span style="font-weight: 400;"> function as such:</span>
</p><p style="text-align: center;"><strong>Cell B6</strong></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">=index(linest(</span><span style="color: #ff6600;"><span style="font-weight: 400;">B1:BH1</span></span><span style="font-weight: 400;">,</span><span style="color: #333399;"><span style="font-weight: 400;">B2:BH3</span></span><span style="font-weight: 400;">),</span><span style="color: #0000ff;"><span style="font-weight: 400;">1</span></span><span style="font-weight: 400;">)</span></em></p>
<p style="text-align: center;"><strong>Cell C6</strong></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">=index(linest(</span><span style="color: #ff6600;"><span style="font-weight: 400;">B1:BH1</span></span><span style="font-weight: 400;">,</span><span style="color: #333399;"><span style="font-weight: 400;">B2:BH3</span></span><span style="font-weight: 400;">),</span><span style="color: #0000ff;"><span style="font-weight: 400;">2</span></span><span style="font-weight: 400;">)</span></em></p>
<h4><span style="font-weight: 400;">The Critical Point (Column D)</span></h4>
<p><span style="font-weight: 400;">Return to the general form of our quadratic equation:</span>
</p><p style="text-align: center;"><em><span style="font-weight: 400;">[math]y=ax^2+bx+c[/math]</span></em></p>
<p><span style="font-weight: 400;">In order to find the critical point for this equation, you need to take the derivative, set the derivative equal to 0, and solve for </span><i><span style="font-weight: 400;">x</span></i><span style="font-weight: 400;">. Generally, this will always look like this with any second order polynomial:</span>
</p><p style="text-align: center;"><em><span style="font-weight: 400;">[math]x=-b/2a[/math]</span></em></p>
<p><span style="font-weight: 400;">In our application, this general form translates to:</span>
</p><p style="text-align: center;"><em><span style="font-weight: 400;">=(<span style="color: #0000ff;">&#8211;</span></span><span style="color: #0000ff;"><span style="font-weight: 400;">1</span></span><span style="font-weight: 400;">*</span><span style="color: #ff6600;"><span style="font-weight: 400;">C6</span></span><span style="font-weight: 400;">)/(</span><span style="color: #0000ff;"><span style="font-weight: 400;">2</span></span><span style="font-weight: 400;">*</span><span style="color: #333399;"><span style="font-weight: 400;">B6</span></span><span style="font-weight: 400;">)</span></em></p>
<p><span style="font-weight: 400;">In order to simplify analysis down the line, I like to add the </span><i><span style="font-weight: 400;">round()</span></i><span style="font-weight: 400;"> function to this equation:</span>
</p><p style="text-align: center;"><strong>Cell D6</strong></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">=round((<span style="color: #0000ff;">&#8211;</span></span><span style="color: #0000ff;"><span style="font-weight: 400;">1</span></span><span style="font-weight: 400;">*</span><span style="color: #ff6600;"><span style="font-weight: 400;">C6</span></span><span style="font-weight: 400;">)/(</span><span style="color: #0000ff;"><span style="font-weight: 400;">2</span></span><span style="font-weight: 400;">*</span><span style="color: #333399;"><span style="font-weight: 400;">B6</span></span><span style="font-weight: 400;">))</span></em></p>
<h4><span style="font-weight: 400;">Curve Shape (Column E)</span></h4>
<p><span style="font-weight: 400;">Curve shape is determined entirely by the sign of the quadratic term, and can be calculated very simply with a nested IF statement:</span>
</p><p style="text-align: center;"><strong>Cell E6</strong></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">=if(</span><span style="color: #ff6600;"><span style="font-weight: 400;">B6</span></span><span style="font-weight: 400;">&gt;</span><span style="font-weight: 400;">0</span><span style="font-weight: 400;">,</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Convex&#8221;</span></span><span style="font-weight: 400;">,if(</span><span style="color: #ff6600;"><span style="font-weight: 400;">B6</span></span><span style="font-weight: 400;">&lt;</span><span style="font-weight: 400;">0</span><span style="font-weight: 400;">,</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Concave&#8221;</span><span style="font-weight: 400;">,</span><span style="font-weight: 400;">&#8220;Linear&#8221;</span></span><span style="font-weight: 400;">))</span></em></p>
<p><span style="font-weight: 400;">Note that we have added the condition </span><i><span style="font-weight: 400;">Linear</span></i><span style="font-weight: 400;"> as well. It’s very rare that trend data will be absolutely flat, but this would occur if the coefficient on the quadratic term was 0. This is a catchall for that extremely rare case only, and in practice, you will most likely never see any truly linear trends with this method.</span></p>
<h4><span style="font-weight: 400;">Trend State (Column F)</span></h4>
<p><span style="font-weight: 400;">Finally, we get to the point of this entire debacle: estimating the trend state of our data. Recall the 6 states we can be in, depending on the shape of the curve:</span></p>
<ol>
 	<li style="padding-left: 30px;"><span style="font-weight: 400;">Negative, Decreasing</span></li>
<p> 	</p><li style="padding-left: 30px;"><span style="font-weight: 400;">Positive, Increasing</span></li>
<p> 	</p><li style="padding-left: 30px;"><span style="font-weight: 400;">Minima</span></li>
<p> 	</p><li style="padding-left: 30px;"><span style="font-weight: 400;">Positive, Decreasing</span></li>
<p> 	</p><li style="padding-left: 30px;"><span style="font-weight: 400;">Negative, Increasing</span></li>
<p> 	</p><li style="padding-left: 30px;"><span style="font-weight: 400;">Maxima</span></li>
</ol>
<p><span style="font-weight: 400;">These states are based entirely on the current time relative to the critical point and the sign of the coefficient on the quadratic term. We have calculated all of this data, so now we can simply use a sequence of </span><i><span style="font-weight: 400;">if</span></i><span style="font-weight: 400;"> statements to determine the state.</span>
</p><p style="text-align: center;"><strong>Cell F6</strong> <em><span style="font-weight: 400;">=if(and(</span><span style="color: #ff6600;"><span style="font-weight: 400;">E6</span></span><span style="font-weight: 400;">=</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Convex&#8221;</span></span><span style="font-weight: 400;">,</span><span style="color: #0000ff;"><span style="font-weight: 400;">60</span></span><span style="font-weight: 400;">&lt;</span><span style="color: #333399;"><span style="font-weight: 400;">D6</span></span><span style="font-weight: 400;">),</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Negative, Decreasing&#8221;</span></span><span style="font-weight: 400;">,</span></em></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">if(and(</span><span style="color: #ff6600;"><span style="font-weight: 400;">E6</span></span><span style="font-weight: 400;">=</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Convex&#8221;</span></span><span style="font-weight: 400;">,</span><span style="color: #0000ff;"><span style="font-weight: 400;">60</span></span><span style="font-weight: 400;">&gt;</span><span style="color: #333399;"><span style="font-weight: 400;">D6</span></span><span style="font-weight: 400;">),</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Positive, Increasing&#8221;</span></span><span style="font-weight: 400;">,</span></em></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">if(and(</span><span style="color: #ff6600;"><span style="font-weight: 400;">E6</span></span><span style="font-weight: 400;">=</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Convex&#8221;</span></span><span style="font-weight: 400;">,</span><span style="color: #0000ff;"><span style="font-weight: 400;">60</span></span><span style="font-weight: 400;">=</span><span style="color: #333399;"><span style="font-weight: 400;">D6</span></span><span style="font-weight: 400;">),</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Minima&#8221;</span></span><span style="font-weight: 400;">,</span></em></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">if(and(</span><span style="color: #ff6600;"><span style="font-weight: 400;">E6</span></span><span style="font-weight: 400;">=</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Concave&#8221;</span></span><span style="font-weight: 400;">,</span><span style="color: #0000ff;"><span style="font-weight: 400;">60</span></span><span style="font-weight: 400;">&lt;</span><span style="color: #333399;"><span style="font-weight: 400;">D6</span></span><span style="font-weight: 400;">),</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Positive, Decreasing&#8221;</span></span><span style="font-weight: 400;">,</span></em></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">if(and(</span><span style="color: #ff6600;"><span style="font-weight: 400;">E6</span></span><span style="font-weight: 400;">=</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Concave&#8221;</span></span><span style="font-weight: 400;">,</span><span style="color: #0000ff;"><span style="font-weight: 400;">60</span></span><span style="font-weight: 400;">&gt;</span><span style="color: #333399;"><span style="font-weight: 400;">D6</span></span><span style="font-weight: 400;">),</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Negative, Increasing&#8221;</span></span><span style="font-weight: 400;">,</span></em></p>
<p style="text-align: center;"><em><span style="font-weight: 400;">if(and(</span><span style="color: #ff6600;"><span style="font-weight: 400;">E6</span></span><span style="font-weight: 400;">=</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Concave&#8221;</span></span><span style="font-weight: 400;">,</span><span style="color: #0000ff;"><span style="font-weight: 400;">60</span></span><span style="font-weight: 400;">=</span><span style="color: #333399;"><span style="font-weight: 400;">D6</span></span><span style="font-weight: 400;">),</span><span style="color: #339966;"><span style="font-weight: 400;">&#8220;Maxima&#8221;</span></span><span style="font-weight: 400;">,))))))</span></em></p>
<p><span style="font-weight: 400;">Note that I’m using the number 60 as a placeholder for the current date, since we are using rolling 60-day data for this example. This can be replaced with any variable that suits your analysis.</span></p>
<p><span style="font-weight: 400;">I spend the majority of my days staring at spreadsheets trying to figure out better ways of organizing and visualizing complex marketing data. If you have an analysis problem you’d like more help on, feel free to email me at </span><a href="mailto:patrick@flintanalytics.com"><span style="font-weight: 400;">patrick@flintanalytics.com</span></a><span style="font-weight: 400;"> or call (317) 993-3411.</span></p>


<hr class="wp-block-separator"/>



<h2 class="wp-block-heading">Let us solve your analytics problem.</h2>


[contact-form-7]



<hr class="wp-block-separator"/>
<p>The post <a href="http://flintanalytics.com/math-for-marketers-quadratic-trendlines/">Math for Marketers: Quadratic Trendlines</a> appeared first on <a href="http://flintanalytics.com">Flint Analytics</a>.</p>
]]></content:encoded>
					
		
		
			</item>
	</channel>
</rss>
