Author: Franz Malten Buemann

 

 

Acquiring a customer is not an easy task. Convincing them to buy your product is a long, long journey consisting of several steps that need to be completed at the top-notch level to reach the longed-for success. To make your work a little more pleasurable, we have prepared an appropriate song, one for each stage of customer acquisition. Rest assured, the songs we’ve chosen are safe for work, so feel free to sing along under your breath!

 

1. Research in the beat of “Eye of the Tiger” by Survivor

 

Welcome to the first step of customer acquisition. You still have a long way to go before the final, most exciting stage – closing the deal – full of phone calls, conversations, emails, and probably stress. But the perfect beat for this, really the initial part of the journey, would be the song “Eye of the Tiger”. 

 

Be the eye of the tigerrising up to the challenge of our rival and find your prey in the night, faster than the competition!

 

2. Contact them, while softly swinging in the rhythm of Adele’s “Hello”

 

Hello, it’s me! 

 

You, contacting a potential client is one thing, but them responding to you is a whole different story.  What to do when they aren’t replying? Do not overthink and simply ping them! Hello, can you hear me? Still nothing? If you try to contact them a third time, don’t worry, you won’t come off as a total Creep.

 

3. Convince them that your product is “A Kind of Magic” like Queen once sang!

 

If you are already at this stage, it means that your pitch to the customer has been successful! Congratulations! But if you think that you’re done, you’re wrong! Now, let the fun begin.

 

Show how your product is different, that it is one dream, one soul, one prize! Make them want to possess it, make them go mad for it! Show your customers the magic behind your product because it is the ultimate, one and only thing that a mortal man can win this day.

 

4. Following Linkin Park, it’s “One step closer” to the deal

 

Perturbations are a real pain in the ass. You think to yourself: 

I cannot take this anymore, I’m saying everything I’ve said before. 

 

But the prospective customer goes on and on: 

Everything you say to me takes me one step closer to the edge. And I’m about to break but I need a little room to breathe. 

 

Just hold a little longer and the next song you can sing is…

 

5. Queen’s “We are the Champions”

 

Yes, yes, and yes! You’ve got it! It’s been no bed of roses, no pleasure cruise. But you got your deal. You are happy, your now, freshly minted client is happy and most importantly, your boss is happy too. 

 

Despite the fact that you had to go through so many conversations, and frankly that you had this agreement in your head even while you were asleep, you can now sing without interruption We are the champions, my friends!

 

Cherish it, enjoy it, think about what you would spend your commission on. …well actually, hold your horses, with another rising sun you have to make a new deal, and it’s like a Never ending story…

At the beginning of 2021, I was tasked with an assignment: Create a pie chart showcasing which types of content performed best on the Marketing Blog in 2020.
The question was an undeniably important one, as it would influence what types of content we wrote in 2021, along with identifying new opportunities for growth.
But once I’d compiled all relevant data, I was stuck — How could I easily create a pie chart to showcase my results?
Fortunately, I’ve since figured it out. Here, let’s dive into how you can create your own excel pie chart for impressive marketing reports and presentations. Plus, how to rotate a pie chart in excel, explode a pie chart, and even how to create a 3-dimensional version.
Let’s dive in.

How to Make a Pie Chart in Excel
1. Create your columns and/or rows of data. Feel free to label each column of data — excel will use those labels as titles for your pie chart. Then, highlight the data you want to display in pie chart form.

2. Now, click “Insert” and then click on the “Pie” logo at the top of excel.

3. You’ll see a few pie options here, including 2-dimensional and 3-dimensional. For our purposes, let’s click on the first image of a 2-dimensional pie chart.

4. And there you have it! A pie chart will appear with the data and labels you’ve highlighted.

If you’re not happy with the pie chart colors or design, however, you also have plenty of editing options.
Let’s dive into those, next.
How to Edit a Pie Chart in Excel
Background Color
1. You can change the background color by clicking on the paint bucket icon under the “Format Chart Area” sidebar.
Then, choose the fill type (whether you want a solid color as your pie chart background, or whether you want the fill to be gradient or patterned), and the background color.

Pie Chart Text
2. Next, click on the text within the pie chart itself if you want to rewrite anything, expand the text, or move the text to a new area of your pie chart.

Pie Chart Border
3. Within the Format Chart Area, you can edit the border of your pie chart as well — including the border transparency, width, and color.

Pie Chart Shadows
4. To change the pie chart box itself (including the box’s shadow, edges, and glow), click on the pentagon shape in the Format Chart Area sidebar.
Then, toggle the bar across “Transparency”, “Size”, “Blur”, and “Angle” until you’re happy with the shadow of your pie chart box.

Pie Chart Colors
5. Click the color paint palette, at the top left of excel, to change the colors of your pie chart.
Excel offers a range of complementary colors — including a few presets under “Colorful”, and a few presets under “Monochromatic”. You can click between the options until you find a color palette you’re happy with.
(Alternatively, if you want to change the colors of your pie chart pieces individually, simply double click on the pie chart piece, toggle onto the paint section of the Format Chart Area, and choose a new color.)

Chart Title
6. Change the chart title by clicking on the three bars graph icon in the top left of excel, and then toggling to “Chart Title > None”, “Chart Title > Above Chart”, or “Chart Title > Centered Overlay”.

Change Location of Data Labels
7. On the same three bar graph icon, click “Data Labels” to modify where your labels appear on the pie chart. (For instance, do you want the pie chart pieces labelled in the middle of each pie chart portion, or on the outside?)

Switch Row/Column
8. If you’d prefer to switch which data appears in the pie chart, click “Switch Row/Column” to see alternate information aligned from your original data set.

How to Explode a Pie Chart in Excel
1. To explode a piece of your pie chart (which can help you emphasize or draw attention to a specific section of your pie chart), simply double-click on the piece you want to pull away.
Then, drag your cursor until it’s the distance you want it, and you’re all set!

How to Create a 3D Pie Chart in Excel
1. To create a 3-dimensional pie chart in excel, simply highlight your data and then click the “Pie” logo.

2. Then, choose the “3-D Pie” option.

3. Finally, choose the design option you like at the top of your screen.

How to Rotate a Pie Chart in Excel
Finally, to rotate your pie chart, double-click on the chart and then click on the three-bar icon under “Format Data Point”.
Then, toggle the “Angle of first slice” until you’ve rotated the pie chart to the degree you want.

And there you have it! You’re well on your way to creating clean, impressive pie charts for your marketing materials to highlight important data and move stakeholders to take action.
Ultimately, you’ll want to experiment with all of excel’s unique formatting features until you figure out the pie chart that works best for your needs. Good luck!

To keep working from home from feeling like living at work, you have to adapt and create a great work-life balance, and give employees support.

The goal of this article is to help nonprofit organizations start using email marketing to its fullest potential. Email marketing campaigns can support all key goals of a nonprofit: from spreading awareness, building relationships with subscribers to turning supporters into donors.

Intent-based customer segmentation is a technique of targeting in marketing to predict the outcome of customer segments. For instance, if a customer browses through an eCommerce store, with intent-based customer segmentation, retailers can predict whether they would make a purchase or if they are merely browsing. Imagine that you have a loyalty marketing mobile app for your eCommerce store. Let’s say that your app has 50M+ downloads and has over 100M subscribers to date globally. Now, let’s say you want to launch a viral campaign using targeting in marketing. And maybe your goal is to maximize the signups in the next 30 days. So, let’s imagine that you need to get another 50K signups. First step in achieving this goal? You’d probably bank on intent-based segmentation for eCommerce to identify the audience most likely to meet the goal.
Frequency of user visits Clicks on a specific campaign A user’s most recent visit No. of user transactions in past

So, as you explore various data points and analyze them using targeting in marketing, you can come up with three potential outcomes for this intent-based segmentation:
Most likely segment Moderately likely segment Least likely segment
Investing in the most likely segment would help you to achieve your goal. Here’s an eCommerce Customer Segmentation Guide our team put up, cheers!
submitted by /u/bnk3r_ [link] [comments]