Category Archives: CRM

The WIMS Guide Ep. 3 – For Entrepreneurs and Professionals Focused on the Journey

It’s Friday! Already got day 7 of my gym streak knocked out, got it in early today as opposed to the 10pm sessions I’ve been pulling off lately.

Today’s client work was mostly related to government/military contracting as well as the legal industry. Fascinating stuff. I try to bunch project work together by themes/industries as much as I can in order to maintain a consistent and appropriate mindset. It doesn’t always work out that way, but when it does I find it helps create more efficiency as you don’t have to transition from say a law firm to a restaurant instantaneously.

Also, I’m rocking the Charlotte Business Group pullover on this rainy Charlotte Friday to give the organization a little extra love as we have big plans for 2020 as well. We also have an event with the Charlotte Hornets coming up on Wednesday the 8th. Make sure you stay tuned!

Most important however, I wanted to use today’s post as more of a call to action to all of you. If you’ve got the goal of creating more written and video content surrounding your business I’d love to do some guest posts/collaborations moving forward. I just have a few small stipulations that I list on here. So please reach out to me so we can make this happen!

PS, yes I’m a pacer, rocker, fidget-er even (again media training on the way), it comes out especially when running on pure adrenaline after a wild week too haha. (Man watching these playbacks is awkward…)

Enjoy the weekend everyone!

-Mike

The WIMS Guide Video Edition will focus on business topics such as Entrepreneurship, CRM, Marketing, Sales, B2B, Business Development, Web Design, Augmented Reality, Virtual Reality, Artificial Intelligence, Data Analytics, Machine Learning, and much much more. To learn more about Mike Simmons and his company WIMS Consulting, click here.

The WIMS Guide Ep. 2 – For Entrepreneurs and Professionals Focused on the Journey

First of all, thank you for the feedback from Day 1, it means a lot and I appreciate it! There were a lot of you savages still grinding long into the night of January 1^st checking LinkedIn/YouTube and I love to see it. Secondly, my wife has agreed to give me that media training refresher after all. So, when that happens, I’ll record it for you all as she’s a legit pro – and talk about META AF content am I right?!

For today’s message I went in a bit of a different direction as I wanted to highlight some of the other content I launched. I wrote a blog post specifically about Charlotte and offered some tips for how to grow your business here in 2020. Then I also wanted to highlight the newsletter we launched today that goes out to the company list and includes a ton of content. It’s the original The WIMS Guide that typically pairs with the blog and includes some additional content such as event calendar and travel advisory. Check the blog site (wimsguide.com) if you’d like to subscribe and get it, or you can email/text me or comment and I can add you to the list.

On here I give a rundown of some of the content from the newsletter, and rather than be redundant here I’ll just throw some links and let you listen to the rest. If there’s anything I can elaborate on or something you’d like me to talk about in the future, please let me know. Onward!

-Mike Simmons

The WIMS Guide Video Edition Ep. 1

Happy New Year and welcome to the new decade! After about 50 takes I figured what the heck, let’s just launch this thing. It’s raw and vulnerable, warts and all. Clearly I need a media training refresher from my wife who is a former TV reporter. But that’s ok, the polish will come later with practice and reps.

Without further ado, coming to you from the WIMS, Inc. War Room it’s The WIMS Guide video edition! I’ve procrastinated for years now on doing video content as surprisingly, it may be the one area I’m a little self-conscious. But that’s also why I needed to just put myself out there and DO it already. So here we are.

I definitely cringed a little (ok a lot) watching the play back, but I will absolutely get better. I’ll begin conveying my thoughts my clearly and concisely. But if you could give your boy a little grace here in the beginning, I’d appreciate it. Or don’t, feel free to roast me too I can take it.

As the blog this is meant to be about the never ending/ongoing journey of business, entrepreneurship, professional development and much more. I’m going to try to provide you with as much value as I can through the insights gained from running my companies, WIMS Consulting, EolianVR, and ARRE (along with perspective and experience gleaned from dozens of clients across a variety of industries and sizes). But I also want to learn more from you too, and even build a community around our shared insights and experiences.

My goal isn’t to build a Gary V or Grant Cardone or Ed Mylett style vlog. It’s to just force myself to get better, get out of my comfort zone, and try to serve my community in any way I can. That’s really all I can hope for. It could last a week, or a decade, we’ll see…

Here goes nothing!

Leveling-Up the Loyalty Game – Welcome to LDR BRD By: Tom Schaefer, Jr.

What are those letters? We’ll get to that later, I promise it’s worth the wait. In my previous post, I went on and on about how Loyalty systems don’t work. At the end of that piece, I explained that loyalty does work, it just seems the retail application was broken. They’re rewarding existing loyalty (which reduces the Lifetime Value, or LTV, of a customer that wasn’t going anywhere) but failing to convert new customers to loyal ones. If there’s something we’ve learned from Star Trek/Wars, Marvel, and even the gaming community, its that consumers crave something they can connect with. The obstacle here is translating what other mediums do well, into a retail or B2C environment.

Janet Robinson, former CEO of the New York Times Company, said it best –

“Repeat business or behavior can be bribed, Loyalty has to be earned”

But what inspires loyalty with your customers? First, we need to separate Customer Loyalty from Brand Loyalty. Customer loyalty comes from the buyer’s power on their own personal spending. They’re likely motivated by lower prices and competitive deals. The loyalty Ms. Robinson is talking about is Brand Loyalty, which is based on perception of the Brand and its value. Brands that focus on excellent quality in product, service, and a cohesive message, are much more likely to inspire loyalty in their customer base.

After all of this research into loyalty/reward programs, I went and did something about it. I created a loyalty platform that ties into the basic fundamentals of building strong brand loyalty. I could tell you all about Aristotle’s 7 causes of human action, defining the 7 ways we make decisions and take actions, or go through some other psychological triggers, but the answer is much simpler than that. Create a quality product or service, provide excellent customer experience, and unify under a strong message. Once that is in place, the rest is as easy as paint by numbers.

My system plays into 4 areas that help grow customer loyalty: Trust, Character, Excitement, and Community. First, we extend the excellent customer experience outside of the standard financial transactions. Using a common platform like a CRM program, helps us stay in touch with our customers, understand their actions, and allows them to provide us with feedback to make their next visit that much better!

Enter LDR BRD (but where’d the vowels go?)

I’ve been so excited to share this with everyone! I’ve spent most of my professional life in Sales and Marketing, and leaned on quantitative data for most of my decision making. We use tools like Lead Scoring to determine which people are more likely to buy, and which are just window shopping. Then it hit me…what if we could do the same with loyalty? It’s a messy, qualitative, emotional category that isn’t easy to track. So how do we do it? I took a sample group of people who self-identify as “Brand Loyal” and interviewed them over a couple weeks. Turns out their actions oftentimes spoke louder than their words. They were more likely to make large purchases from their preferred brand, share with friends and family through word of mouth/social media/online reviews, and fall into the habit of making regular purchases. Loyal customers should make up at least 20% of your base, but will account for 80% of future profits. It’s time to find out who they are (and what they care deeply about)!

Ready Player

We took the traditional lead scoring model, and made is public facing. This effectively turns loyalty into a game that adds a competition component to a system that doesn’t separate the loyal customers from passive return business. We have a system in place to track activity both inside and outside the traditional financial transaction. Did someone share a post on social media and tag your business? Get Points! Did someone invite their coworkers or friends to your bar for happy hour? Reward them! Did someone make a large purchase? Don’t let it go unnoticed! Our system also incorporates Feedback Loops (similar to popular games like Fortnite, with each new season giving players a reason to re-engage), so everyone gets a chance to shine, regardless of the previous activity. This allows new customers to feel like they have a chance to benefit in the system, while longer tenured customers continue to benefit from past activities. The purpose of this system is to identify and reward loyal business, all while turning your customer base into your own personal marketing army!

What about the name? I was inspired by the classic video game displays that list the current high scores. The leader board gives new players a number to beat, driving competitive behavior. At the end, you can only use three initials to describe what you are.

Leader Board became LDR BRD.

Are you ready to play?

If you have any questions about LDR BRD or would like to discuss how this platform can transform your business and drive revenues, fill out the form here or email me and let’s talk: [email protected].

STILL PLENTY OF TIME IN Q4: FINISH LIKE A SAVAGE & PREPARE FOR 2020 DOMINATION!

There’s something about Q4 that is always exhilarating to me. Knowing that “the game” is coming to an end, each and every play is more significant, there’s less margin for error. Perform well during this time and you can make up for a lot of previous mistakes and setbacks along the way. Let up or fumble the ball, and you can destroy all the momentum you made thus far. No pressure, right?

All of this is going on while simultaneously a new game is going to begin soon thereafter. Endings are always thrilling, but so are new beginnings after all. The new year coming up is especially enticing. Not only is it a new year, but it’s a whole new DECADE. The freaking Roaring 2020’s are upon us.

Despite the hectic grind I’ve been on lately (pretty perpetual at this point, but even crazier with baby #2 arriving very soon), I wanted to take a little time to revisit and write up a quick/updated “Q4 Manifesto” which is mostly for myself, but then I decided to add a few extra tips for you too, primarily applicable to both your business and professional life.

Don’t wait for January 1^st to start your New Year’s Resolutions, now’s as good a time as any. It’s a misguided practice that usually doesn’t end well anyway. You don’t need an arbitrary start date to work on self-improvement, that should be a daily practice as it is. Why not start right now?
Get AGGRESSIVE – Close out ALL of those pending dream deals that have been lingering. Do much more outreach and lead generation. Don’t dwell on whether you’re annoying people or assume that they already have an expert helping them that does what you do. Push harder!
Try not to eat and drink everything in sight just because it’s the holidays. Maintain (or in some cases start) your workout routine consistently and only indulge occasionally. It’s especially tough given all the parties and networking events, but some balance now will spare you later.
Enjoy time with my family and friends and BE PRESENT. Don’t spend that precious time distracted with your head in the clouds and worrying about things that are out of your control.
Debrief/Reflect on the past year. What worked, what didn’t, what do you need to improve upon? Lay it all out objectively and identify opportunities to get better. While this may seem obvious, it’s crucial.
Strategize for 2020 (and beyond) now. Spend an appropriate amount of time writing out specific goals, sketching out project plans, and dreaming big. It’s rare that a whole new decade is about to start so let your imagination run a little wild to kick things off. From there be mindful, thoughtful, deliberate, and thorough enough to also make your plan realistic while still stretching yourself. Once this exercise is completed, start working on implementing that strategy ASAP to carry some momentum with you.
Add appointments to your 2020 calendar (monthly/quarterly, etc.) now to make sure you schedule the time to reflect on your progress and measure where you’re at along the way to ensure you continuously improve.

A few specifically for you:

Get and implement a CRM already! Seriously, how many times do I have to say it? If you need to spend some time asking a few questions on how to get started, reach out to me, that part is, and always will be, on the house.
Start a blog, a podcast, video/webinar series, whatever. Leverage content marketing to develop and enhance your brand and get your business’ name out there.
Finally start that business you’ve been day dreaming about for years now.
Or at least start working on that side hustle you’ve been planning.
Identify an organization you’re interested in and get involved in the community. This could be philanthropic or civic, doesn’t matter as much as simply taking action and giving back.

I’m sure there are plenty others I’m forgetting. And I will likely revisit this some more over the next few months to continue tweaking it.

What are some of your Q4 goals? What about your 2020 goals? How can I help you achieve them? Please let me know, would love to hear from you!

Your Annual CRM Call to Action for 2020

I’ve been harping on the importance of CRM programs for about a decade now (here’s the last time), yet it still hasn’t caught on the way it should. This is the year that changes. Like with most technology, competition, economies of scale, and innovation have driven costs down significantly. Not only are they cheaper, but the functionality and value has simultaneously increased dramatically. Now, you can even get basic versions of a CRM program for free. It’s why acquiring and implementing a CRM program is my #1 recommendation for every business, regardless of industry or target market, if you’re looking to increase revenue.

Whether you work for a large and complex company, or if you’re an independent freelancer, or if you’re a sales mercenary who is compensated by getting to “eat what you kill,” there is a CRM program out there for you. Regardless of your budget (or lack thereof), you can customize the level of sophistication of your CRM program, as they all have various subscription levels. Further, there was recently an absolutely game changing announcement from one of my CRM platform preferences (and the one I personally use for my business).

Zoho One – An Operating System for Business

“Zoho One is a broad and cohesive set of applications that work collectively to run an entire business on the cloud. It includes more than 40 web applications and an equal number of mobile apps—under a single sign-on, with centralized administration and provisioning—making it a true operating system for any business. While each application punches above its weight against the competition, collectively they deliver a knockout punch.

With Zoho One, we’ve put together all the applications a company needs to acquire and serve its customers (marketing, sales, automation, and support apps); run its operations (finance, recruiting, and HR apps); and provide all the tools for its employees to work collaboratively and get their work done (office suite, mail, personal productivity, and collaboration apps). Almost any company has these same needs. With Creator, our drag-and-drop app builder, customers can even build custom apps for unique business needs—like logistics scheduling—and put them under the same umbrella that forms the single operating system for their business.

Zoho One is available at $30 a month—or just about a dollar a day, per employee. ($35 if you pay on a month-to-month basis).”

While WIMS, Inc. is platform agnostic (we work with all of them, including Salesforce, HubSpot, Microsoft Dynamics, and Insightly among others) it’s getting more difficult not to refer my clients and prospects straight to Zoho right now. There are of course exceptions, but they’ve built something special, particularly for entrepreneurs and small businesses.

Now, back to the more general CRM theme.

They all integrate with your email provider of choice, along with most social media channels, so tracking communications is easy (and automated). There are an incredible number of third-party add-ons you can incorporate depending on how robust your operations processes are to add additional functionality too.

Most importantly however, is that the ROI (return on investment) will more than make up for the expense.

CRMs help you automate your sales process. The more automated your sales cycle and follow up efforts can be, the greater volume of deals your business will be able to close. Further, the more accurate data you have about your sales cycle, the more deeply you can analyze it to gain insight that will not only help increase revenue, but ultimately help you improve:

Close rates,
Customer service and retention,
Length of sales cycle, and
Forecasting efforts and projections.

While implementing a CRM program can be a significant commitment initially, if you do it right, the benefit to your business is invaluable. With just under two months left in 2019, now is the perfect time to start planning and conduct your due diligence to start 2020 with yet another New Year’s resolution.

We’re here to help if you need it!

Why Loyalty Programs Don’t Work…

As Marketers, one of the key metrics we follow is brand engagement, also known as Loyalty. We often talk about the size of a market, or how much market penetration a particular business or campaign has achieved. Loyalty is the measurement of how much of our captured market repeats business with us.

It’s said keeping a customer is cheaper than gaining a new one. Considering the retail industry as a whole spent over $1.9 Billion in 2016 running Loyalty programs, I’d say it’s still pretty costly. Businesses use “Loyalty Programs” or “VIP Clubs” as a way to grow customer loyalty. Unfortunately, these programs are often costly to operate and rarely translate to any kind of loyalty to the brand using them.

The average house is participating in over a dozen loyalty programs, and less than half the users are active or engaged with the brands. While the program is designed to increase loyalty, the business ends up spending money on the customer base that’s least likely to leave. These programs effectively cut into the profit margins from customers that were likely going to return, regardless of any additional perks. That last part is especially true considering most of the participants either don’t know how to redeem the rewards, or don’t care enough to find out.

You can find all of this information and research with a simple Google search. However, there is one market segment adding these types of programs at a faster rate than previous years. The beverage industry, specifically Breweries, Brewpubs, Tap houses, Wineries and Vineyards, Distilleries, and Hard Cider Mills. The most common model is by far the Mug Club, or Mug Membership. While some are a one-time payment, most are annual or monthly payments to a business, providing the member with added perks. Now, as a former member of these clubs, I LOVED them. I probably doubled my money with the perks I received. An example of the perks is as follows:

-Personalized mug, typically 2-4 ounces larger than the standard pint but priced the same

-Brewery/Tap house Merchandise (T-shirts, Hats, Koozie, bottle openers, stickers, etc.)

-Discounts on Beer/merchandise

-Special Events (no cost to members)

-First in line for special events/product releases

-Free Growlers and discounted fills

The average cost of these programs to the members can range anywhere from $40 to a couple hundred, depending on the Brewery or Bar. I spent $150 to join one, and $85 a year to keep it renewed, with additional shirts and events with each renewal. The Breweries justify this by saying it creates a group of loyal customers that will promote the business outside the walls and gives the members a unique sense of community. When most of the Brewery clubs have 100 members or more, that’s a big cut into a profit margin from a group of people that would likely be loyal customers with or without the club. Can the breweries prove these members are promoting them in the community? What’s the return on the brewery’s investment? If you can’t prove something works, how do you justify the expense?

Alternatives to the Club

Now you don’t think I’d sit here and rip apart an old system that’s been in place for years without offering alternatives, do you? I love a good beer, and want to see these Breweries grow. They stay in the same system, or don’t participate, because there aren’t many people out there talking about alternatives. The end goal is to increase their market share, and promote loyalty within their current customer base.

Special Release Clubs

These kinds of membership clubs seem to work for those chasing the elusive “Whales”, or special limited run bottles. Breweries can forecast what kinds of beer they want to make, based on cost of production, and divide that total into the membership count to give them the cost per member. Tag on whatever margin they need to make it worth their time, and the membership group can turn a profit before the first batch ever goes into production. This gives the members a sense of loyalty, status, and keeps them engaged with the brand as they look forward to the next release. There’s a value add, and breweries can measure the benefit. Club members typically have to travel to the brewery to pick up the bottles, and will often spend a bit more on beer during the visit. POS systems can track the members and allow breweries to measure the additional revenue per member at the time of the visit.

Active Point Systems

This is a new take on the long-standing loyalty system, but with a twist. Breweries, Distilleries, Cider Mills, and Vineyards/Wineries can easily turn their typical social and marketing engagements into a point system. By continually engaging with their markets, breweries can put out a series of tasks that equal points. Create a clear, public facing list of “award tiers” that customers can follow, and the point totals needed to reach each one. World of Beer did something along these lines with their “1 point per beer purchased” programs, with prizes ranging from a free t-shirt to a private party with a free keg of your choice. Not a bad start, but they could have gone further.

The one beer = one point model only works when people are in the building, and it isn’t typically something most of their market thinks about unless they’re already patronizing a location. The prizes also need to be collected from the location they signed up for the program. This negates the benefits if someone moves or a location goes out of business. You can switch your “home” location, but that’s unnecessary friction for the customer.

Award Tiers need to not only benefit those already in the building, but also incentivize the market as a whole to either patronize a brewery, or promote the brewery. Our team at WIMS put together a system that rewards your market for not only coming in to buy your product, but also promote your product to their own network. You keep them engaged with your brand with regular bonus point activity, creating a sense of community. We put a system in place that allows you to track and quantify the return on investment from the dollars spent on a marketing campaign. The best kind of loyalty is from customers that not only frequent the brewery, but also promote the brewery when they’re not there. Expand the market and increase loyalty within the new segments as it grows.

Whatever system you put in place for your Brewery, Distillery, Cider Mill or Winery, make sure you can measure the results.

If you have any questions or comments about this article, I’d love to hear from you. Reach out in the comments below or sign up for our monthly newsletter.

Cheers!

-Tom Schaefer, Jr.

Part 1 of aseries…

How Anyone can Build a Custom Data Analytics Dashboard

If you could carve out an hour a month for analysis in order to save a dozen hours of work, the one-hour investment would be worth it, right?

How about if that same hour led to crucial details about your sales trends and customers insights?

On top of all that, what if that same one-hour investment came at no additional cost to you?

Seems like a pretty great deal.

Welcome to the benefits of an Excel-based analytical dashboard.

Benefits of an Analytical Dashboard

You’ve most likely heard of the powers and benefits of data analytics. You’ve probably seen examples from things like POS systems, Tableau, cloud-based software, and many others.

Some of these benefits include the following:

Saving you time and money through efficiency and more impactful insights

Spending time looking over your dashboard saves hours of debating anecdotal or piecemeal results and helps guide you towards the best path forward

Giving you better insights into your customer to improve marketing campaigns

Campaigns based on hard data are more successful as you can target your intended customer more effectively

Taking the guesswork out and make great, data supported, decisions in less time

The high end services all have their merits, but in a small business where you might not have the budget for those services (which are also potentially far beyond the capabilities you actually need), plus a large learning curve, those services don’t always make the most sense.

By learning (on a much faster learning curve) to make a dashboard in Excel, you can get the benefits you want in a completely customized dashboard at no cost (since you already have Excel on your computer).

Why use Excel for this

Let’s start with some common business questions.

How did your sales do last month? How does that compare to the same month of the prior year? How about compared to the pace you’ve been running at this year?

Now how about separating those numbers by project, item, or client? How about by distribution channel? Sales rep? What about the specific days you had promotions?

The first set of questions is somewhat easy to have a gut feeling for, if nothing else. You might even have some quick analysis created for you in QuickBooks (or similar software).

However, the second set of questions represents another level deeper. You might feel a bit less confident about your gut feeling. They require you to dive into the data each time you want to look, and maybe even anecdotally piece it together from a few different sources. It’s kind of a hassle, but they’re important insights, so it’s worth the time.

Here’s the good news from Excel – you can answer all of those questions, from top line revenue down to whatever level of detail you need, and have them at your fingertips in one place!

With a simple export of data from whatever source you need, you can populate dozens of custom views that you’ve templated and turn it into your very own analytical dashboard!

The only time intensive piece is building the template and framework for all your custom views.

After you create that, you’re essentially just updating with data each week/month/etc. and looking it over for trends. Making changes to it? Duplicating views with variations? Actually, all pretty easy.

The Excel Dashboard

Here is a very quick sample dashboard that shows that topline sales numbers (black chart) followed by a few, slightly deeper, analytical pieces that help evaluate performance (gray charts).

When I say “very quick” … this dashboard took less than an hour to fully create. Real life dashboards of this level of depth take a similar amount of time. Getting significantly deeper into the data does not necessarily mean significantly more time to create though.

Only a few “next level” type questions are displayed (although these may only be half a level deeper), but they are meant to be representative, and the great feature about the “behind the scenes” of the dashboard is that the building blocks for all levels of analysis can be VERY easily duplicated to get at any question you need.

Take a quick look at the dashboard, follow it along the yellow markers, 1 to 5. Any trends jump out at you?

You can likely see the following in a quick pass:

Sales are up in 2019! (Callout #1) – by 22.1% if we want to be specific
There seemed to be a change in performance starting in February (Callout #2). Perhaps a new item was released? Or a new marketing campaign?
All Sales Reps are selling more this year (Callout #3). Shawn leading the pack with a 28.7% increase over 2018
In Store sales have grown by over 60%! (Callout #4). However, Online sales have shrunk a tiny bit.
Further diagnosing, it looks like Jennifer and Oliver have really improved their In Store sales, while Shawn has faltered there (Callout #5). Perhaps there was a training that stuck with Jennifer and Oliver? Maybe Shawn has just focused all of his attention on Online sales?

Those types of insights are crucial to running your business and can be seen quickly from the dashboard. On top of that, there are still tons of different ways to cut the data… by product, by product and distribution channel, by sales rep by month, etc. All of these examples are (almost) as easy as copying and pasting.

Creating the Backend of the Dashboard – a General Guide

We start with one of the building blocks of an Excel-based analytical dashboard. Simply, the Pivot Table.

Depending on your level of familiarity with Excel, Pivot Tables might seem like “that complicated next level” or “that tool we use every day”.

The truth is, everyone can easily be at the latter, and if you’re already there, you could probably be using them more even more effectively. Investing just a bit of time can have a very outsized benefit to your business.

Pivot Tables are fantastic, for all levels of users, because of a few main pieces of functionality:

Very easy to build, use, and manipulate

Drag and drop methods, no complex formulas, no macros or coding

Ability to create charts and dashboards from the Table(s) easily
Build automatically updating formulas off the Table to create new data elements

It deserves mentioning that the quality of your data is very important. If the data is wrong to start, then there is no point is doing any analysis.

First… a few tips on how to create a Pivot Table

Feel free to skip this section if you’re already familiar.

For a detailed “how to” build a Pivot Table, I recommend watching from ~2:30 to ~5:30 in this video. The rest of the video has some good explanations as well, but for a quick guide, the 3 minutes is really all you need.

One piece I would highly recommend changing though, is in the data selection piece.

Important – select the entire column in the data, making sure the headers are in row 1. This allows you to add data in the future and have it included in the pivot table without having to change the data range.

The boxed-in range is okay as “ Sample Data!$A$1:$E$13 ”, but would need to be changed if you add more data to the end of it. The better version’s range “ Sample Data!$A:$E” highlights the entire columns.

Onto Creating the Dashboard

Start with creating a Pivot Table, and from there it is really just about dragging and dropping fields, copying and pasting, and picking a layout!

Let’s say you begin by creating a simple Pivot Table with sales by month:

From there, go up to the ribbon and find the “Pivot Table Analyze” or “Analyze” tab, depending on which version of Excel you’re working with.

Select the “Pivot Chart” option, and out pops a variety of options. Select your favorite chart option (bar chart, line graph, multiple types, etc.) and boom! You’ve got a working chart to help you analyze!
Any time you change what’s in the Pivot Table that created the Pivot Chart, the Pivot Chart will change accordingly.

Example, if you limited the data to just “Jennifer” (Sales Rep filter), you’ll see only her sales in both the Table and Chart.

Tip for the aesthetics of the Chart

To get rid of the “buttons” or ugly looking gray bubbles polluting your chart, you can right click on any of them and select “Hide All Field Buttons on Chart” and they’ll go away (as shown below).

If you don’t mind their appearance, each button acts as a filter for the Pivot Table. So instead of scrolling over to the Table, you can filter right from the Chart.

From there it is just preferences:

You can add a chart title, hide the legend, and a lot of other customization by clicking on the Chart, and then selecting the green “+” button that appears to the right of the Chart (shown below).

Once you’ve got your first chart, you can then start the duplication process!

To make another Pivot Table and Chart combo, you can just select the entirety of the Table, then copy and paste it elsewhere on the sheet

Copying the Pivot Table to be replicated

Drag and drop the fields (from the Field List on the right) you want to look at in the new Table (ex. Sales Rep in place of Month), and then go through the same quick process to create a Chart

The premise here is that each Table you create is referencing the same data. Each variation is just how you want to cut the data for that particular view.

Note – the formatting you select for one chart will not transfer to a new chart. The easiest method is to pick from Excel’s preset templates, which are normally visually appealing enough – both the black and the gray Charts above are in Excel’s preset templates. You can always customize the look of every chart individually to how you want though.

Best practice is probably to settle on a color scheme and layout after you’ve created all the charts you want, that way you can quickly go through each and select the same layout all at once.

After creating however many variations that get to your necessary level of depth, you’ve now just created yourself a dashboard! Congrats!

Best Way to Create Formulas Based on the Tables to get Additional Metrics in your Dashboard

You may notice that some pieces in the above dashboard (the tables with headers that have blue background and white text) are not Pivot Tables or Pivot Charts. These are created using the same information though.

Enter the GETPIVOTDATA formula. It is one of the most complicated looking formulas, but one of the most effective to use.

Note that it is simply complicated “looking”, but not actually that complicated to use.

Here’s an example. We’re going to walk through the Sales By Month table in the dashboard above (and referenced below).

Let’s say you wanted to get that 41.1% “Growth vs Prior Yr” for Feb from the information in the Pivot Table.

Naturally, you would do the following (referencing picture below) U10 / T10 – 1 = 41.1%

When you go to do that though, this scary looking formula comes out:

Let’s break it down and look at the first piece, before the “/”:

=GETPIVOTDATA(“Sale Amount”,$S$7,”Year”,2019,”Month”,”Feb”)

Translating, it is saying the following:

From the Pivot Table

=GETPIVOTDATA(“Sale Amount”,$S$7,”Year”,2019,”Month”,”Feb”)

Grab the metric “Sale Amount”

=GETPIVOTDATA(“Sale Amount”,$S$7,”Year”,2019,”Month”,”Feb”)

In the Pivot Table located in cell S7

=GETPIVOTDATA(“Sale Amount”,$S$7,”Year”,2019,”Month”,”Feb”)

Given the following criteria, Year = 2019

=GETPIVOTDATA(“Sale Amount”,$S$7,“Year”,2019,”Month”,”Feb”)

And the second criteria Month = Feb

=GETPIVOTDATA(“Sale Amount”,$S$7,”Year”,2019,“Month”,”Feb”)

You’ll notice the second GETPIVOTDATA (after the “/”) is the same formula, just referencing Year = 2018 instead of 2019.

It is the same formula as the nice and easy U10 / T10 – 1 above, just bringing in the functionality of the Pivot Table.

So why on earth would you actually use the complicated version?

Reason #1: Let’s say you add in another filter and the bulk of the Pivot Table shifts down by one row. The U10 / T10 – 1 will remain but will now be looking at a different month.

Reason #2: What if you changed the Pivot Table to include each Sales Rep’s details in each month (like below)?

Now that “U10 / T10 – 1” formula would be referencing Jennifer’s sales in Jan… not even close to total Feb sales.

If you used the GETPIVOTDATA formula, you would still get the result you want (Total Feb Sales Amount, 2019 over 2018) because you’re telling it what criteria to look at, regardless of what cells the intended data ended up in. It would still do $26,070 / $18,470 – 1, or 41.1%.

Note – in a scenario like the above picture, make sure Subtotals are enabled in the “Design” tab that appears when you click in the Pivot Table

Reason #3: You can completely customize the look of your created table, whereas you have limited aesthetic flexibility in the Pivot Table itself. I choose a blue header with white text.

Reason #4: You retain the copy and paste functionality of the “U10 / T10 – 1” formula but increase the accuracy of the formula.

Notice in our summary chart with each month’s “Growth vs Prior Yr”, we have the month abbreviation in the left column, then the % growth in the right column.

To utilize the copy and paste functionality of formulas in Excel, we just have to reference the month in the formula.

It is the same formula as above in every way except for the P9 in place of “Feb”. This just tells the formula to take the value in cell P9 as the criteria needed to be found in the “Month” section.

You can then copy and paste this formula to each of the months, and the “Growth vs Prior Yr” will fill out for each month, regardless of how many other variables are in the Pivot Table, or where the numbers you want are located (cell-wise).

Summary

So now you’ve learned…

The benefits of a dashboard, specifically one in Excel
How to make a Pivot Table
How to make a Pivot Chart based off it
How to duplicate those efforts (for efficiency)
How to reference the information in it to get analytical metrics that aren’t directly called out in the Pivot Table
(Most importantly) How to build your own fully functional, completely customizable analytical dashboard!

Updating the dashboard is an exercise that takes mere minutes to download the data and add it into your data sheet.

Reasonable time investment to make the dashboard, small time investment to update it, big business benefits.

3 Marketing Tips for Breweries, Wineries, Cideries, & Distilleries

The brewery and winery industries have been fortunate to have experienced a major boom in public interest along with media attention over the past few years. Just opening a new location has been a major event that has typically generated a lot of buzz and received coverage by every Business Journal and local social media influencer alike. That’s not to say that marketing breweries and wineries has been easy of course, far from it.

Once the grand opening has passed, and the novelty subsides, the business must continue to attract a loyal and recurring customer base, in addition to the one-off tourists and large groups as well. While all businesses have their tried-and-true marketing methods that work, we wanted to offer up some that may appear obvious, but they truly work. And when done effectively in conjunction with a robust marketing and sales strategy, they’ll keep your brewery or winery full of customers for a long time to come.

Tastings and tours are a “must” for any brewery, winery, cidery, or distillery. However, even if you diligently open your brewery daily for happy hour, there’s much more you can do to raise product awareness. In order to broadcast your brand’s name, it helps to bridge the gap between physical and digital. While locals and tourists might stop in for some beer, wine, or cider, incorporating digital marketing into your outreach campaign will multiply your success. These digital marketing strategies help breweries and wineries attract interest and show off their new craft beer and wine releases, as well as just consistently get people through the door.

Blog Posts

Creating a new beer, wine, or cider is still big news. Your fans (and prospects) want to hear about it! However, people also want to know what they’re getting into before purchasing beer from a brewery. For many, that means doing some research beforehand. Introducing a new beer, wine, or cider through blogging is a fun, creative, and informal way to get word out of your newest product. Along with sharing information about the new release and the story behind your winery or brewery online, you can link to your social media pages as well. With these additional steps, you’ll effectively reach your social media followers and those who have signed up for email alerts or announcements (not to mention jack up your SEO rankings). This makes it easier for followers to share the news about your brewery or distillery on their social networks too.

Email Campaigns

While it often takes a back seat to social media, email marketing is still a significant part of a successful marketing strategy. Surprisingly, many breweries, wineries, and cideries use social media exclusively as their digital marketing strategy. Considering that 3.2 billion people use social media worldwide, tapping into a social network is a good start. Yet, email is even more effective in reaching a target brewery or winery audience than Facebook or the others. Studies show that 900 out of 1,000 people see a company’s message via email compared to just 20 out of 1,000 people on Facebook. Ultimately, it’s worth your time and effort to create a message that 90% of users will see. Email also has the power and convenience of automation. With social media, on the other hand, you’ll need to personally post a message every day or at least several times each week (which you should be doing ALSO).

Social Media Ads

Even though email campaigns are the fastest way to reach a broad audience, don’t underestimate the power of social media for your brewery or winery. About 67% of the US population uses Facebook, which translates to many potential views. Facebook advertising is simple and easy for breweries and wineries to use, and you can even try A/B testing to see which campaigns and strategies are most effective.

From tried-and-true email to web content and social media, there are many creative and effective avenues that breweries, wineries, distilleries, or a cideries, can use to increase brand awareness and spread news of a new wine, cider, or beer. If you’re interested in discussing how you can build upon your existing marketing and sales strategy reach out to us at WIMS Consulting and we’d be happy to help!

Salesforce Heads North

In June 2019 Salesforce announced that it would be purchasing Tableau in a deal worth over $15.7 billion. This deal will allow San Francisco based Salesforce to expand its presence in Seattle creating a second headquarters in Seattle, home of Tableau, like what Seattle-based Amazon did with its HQ2 competition last year. I was in the Seattle area on vacation as the news broke and was able to read local newspapers on this deal from the local perspective which went beyond the financial terms of the agreement.

This deal represents the second largest acquisition in the history of the state of Washington and shows the power of the technology sector in the Pacific Northwest and willingness of companies to expand beyond Silicon Valley (Romano, Seattle Times). With a presence of 1,000 employees already in Seattle, Salesforce is familiar with the business climate in Washington. Moving forward this acquisition is not an outlier and additional companies in the cloud computing space will look to expand their operations and establish additional offices beyond their initial headquarters.

This trend poses the opportunity for companies to benefit from the strengths of different metropolitan areas while also increasing the expectations the residents of these cities have of these companies to become stewards of the community and provide jobs to locals. This deal will change the entire landscape and power dynamics in the CRM and Business Intelligence world. This deal seems to represent a move by Salesforce to invest in research and development through the purchase of Tableau which may signal slowing internal innovation (Moorehead, Forbes). This deal comes after Salesforce paid $300 million to integrate the companies non-profit arm, Salesforce.org, into the companies for-profit side (Salesforce Press Release). This deal will have a substantial impact to the overall company and could create anywhere from $150 to $200 million this Fiscal Year depending on when the deal closes. These strategic changes show how Salesforce is moving beyond CRM and taking the potentially risky decision of incorporating its non-profit wing into its for-profit business. Although Salesforce has been on the leading edge of philanthropic causes with rising housing prices and inequality in the San Francisco Bay area and Seattle areas Salesforce will be held accountable and pushed to create more equitable growth as their operations expand.

Seattle is a city that has long struggled with homelessness and affordable housing. While the city is the thirteenth largest city it has the third largest homeless population. Driving through Seattle and talking with locals on my recent trip to the city I heard and saw homeless camps and the stories of how homelessness and affordability is an issue impacting suburbs across the Seattle area with camps in view of I-5.

While Salesforce CEO Marc Benioff has led his company to be a leader of philanthropic efforts and combating homelessness, he is entering a new arena in Seattle (Romano, Seattle Times). Long a leader in giving back Salesforce pledges 1% of profits, products, and employee time to philanthropic efforts. Marc and Lynne Benioff have signed the Giving Pledge and are leading advocates in the San Francisco area working to combat homelessness. Lynne Benioff cofounded a program in 2011 to provide shelters for families around San Francisco. Tableau also has taken on a philanthropic approach as well and pledged $100 million in grants and technology to global health and equality organizations (Romano, Seattle Times).

This merger has just occurred, but challenges persist moving forward. Benioff says that Tableau will operate independent of Salesforce and affirmed that this is a merger of two equals. This is rarely the case in mergers as power dynamics and even the slightest of differences can cause division between leaders in the merged companies. Time will tell how this deal will be remembered but one thing is certain which is that this will not be the last big software deal of the year.

Links

Image from: Romano, Benjamin. “Why Salesforce is shelling out $15.7 billion in stock for Seattle’s Tableau, in one of the NW’s largest acquisitions?” Seattle Times. https://www.seattletimes.com/business/technology/salesforce-buying-seattle-based-tableau-for-15-7-billion-in-stock-one-of-the-northwests-largest-acquisitions/.

Moorehead, Patrick. “Salesforce.com’s Tableau Acquisition: Admitting Organic Innovation Failure?” Forbes. https://www.forbes.com/sites/patrickmoorhead/2019/06/18/salesforces-tableau-acquisition-admitting-organic-innovation-failure/.

Salesforce Press Releases. “Salesforce and Salesforce.org Combine to Drive Greater Philanthropic Impact and Success for Social Good Organizations.” https://investor.salesforce.com/press-releases/press-release-details/2019/Salesforce-and-Salesforceorg-Combine-to-Drive-Greater-Philanthropic-Impact-and-Success-for-Social-Good-Organizations/default.aspx.