Author: Franz Malten Buemann

  • How to Sort in Google Sheets

    Google Sheets is a great tool for tracking, analyzing, and organizing data for your company or business.
    While the application is user-friendly, it can be a bit tricky if you’re new to organizing data in a digital spreadsheet. But, don’t worry! Read on for an easy introduction to sorting in Google Sheets.

    First, know that there are many ways to sort data in Google Sheets. Some of the most common features marketers like you will use when working in Google Sheets are:

    Pivot tables – Useful for gathering data from a large database
    What-If analysis – Allows you to experiment with different scenarios for values and formulas to understand possible outcomes
    Charts – A simple way to visualize data in the form of a graph, diagram, or table

    While these features can also be found in Microsoft Excel, Google Sheets may be the better option for you. Unlike Excel, Google Sheets doesn’t require a paid subscription.
    The tool is free for anyone with a Google account or Google Workspace account. Many users also find Sheets a more optimal tool for collaborative projects when compared to Excel.
    So, how do we get started sorting in Google Sheets? Let’s dive in.

    Sorting by Sheet Vs. Sorting by Range in Google Sheets
    The latter is especially helpful if your spreadsheet contains multiple tables and you want to organize one table without disrupting the others.
    For example, the spreadsheet below is sorted by sheet. The titles of the books (column A) have been sorted into alphabetical order.
    In the second example, the titles are sorted in reverse alphabetical order. In both cases, each book’s author, publishing date, and genre remain with the corresponding title.
    The example below has two separate graphs on one sheet. Notice the graph containing book titles, authors, release date, etc … is organized by alphabetical order, while the book log below it is not.
    That’s because the graph of book titles was sorted by range so it wouldn’t disrupt the book log below it.

    How to Sort Columns and Rows in Google Sheets
    Knowing how to sort rows and columns in Google Sheets is key to organizing your data. Here’s a step-by-step guide:
    Alphabetical or Numerical Order
    Step 1: Open a spreadsheet in Google Sheets and highlight the group of cells you’d like to sort. In this example, we’ll use the graph of book titles.
    If your sheet has a header row (like the green header row in the example), you’re going to want to freeze that row so it stays in place as you sort.
    To do this, select the header row, click the “View” tab, click “Freeze,” then click “1 row.” If you do not have a header row, then you can move on to the next step.
    Step 2: Click the “Data” tab then “Sort Range” then “Advanced range sorting options.”
    Step 3: If your columns have titles, click “Data has header row.”
    Step 4: Select the column you want to sort first then choose the sorting order. A-Z and Z-A will put your data in alphabetical and reverse alphabetical order respectively.
    If you’re working with numbers, A-Z will organize the data in ascending order and Z-A will organize it in descending order.

    Step 5: To add another sorting rule, click “Add another sort column.” Then click the green “Sort” button.
    Step 6: To sort an entire sheet, right-click the letter of the column you want to sort by, then click sort A-Z or Z-A.

    How to Filter Your Data
    Filtering your data is especially helpful if you want to hone in on specific information from a large data set. It’s also great if you only want certain information displayed when people first open your spreadsheet.
    Step 1: Select the range of cells you want to filter.
    Step 2: Click the “Data” tab then click “Create a filter.”
    After clicking “Create a filter,” your graph should look like the example below. Notice the filter icons next to each column header name and the new border around the graph.
    Step 3: Let’s say we only want to see book titles that are historical fiction. To do this, we’d click on the filter icon next to “Genre,” then click “Filter by values.”
    Step 4: Then, we’d uncheck everything but “Historical Fiction,” and click “OK.”
    This can also be done by clicking “Clear” and typing in “Historical Fiction.” The latter method is great if the value you want to sort by isn’t listed and you want to add your own.
    No matter which method you choose, the end result should look like this:

    How to Sort Your Data by Color
    Let’s say the book titles are all color-coded by genre with historical fiction being orange, science fiction being blue, and coming of age being purple.
    To sort these color-coded titles so that coming-of-age books are at the top, do the following:
    Step 1: Select the range of cells.
    Step 2: Click the “Data” tab then click “Create a filter.”
    Step 3: Click the filter symbol in the genre column, then sort by color, fill color, then purple.
    After doing so, all coming-of-age titles will appear at the top of the graph.
    If you’d like to turn the filter off, simply click “Data” then “Remove filter.”

    Remember that your filter will be visible to anyone with access to the spreadsheet. If someone has permission to edit your spreadsheet, that person can also change the filter.
    And that’s how you can sort and filter your data in Google Sheets. Now you’ll be able to organize your data digitally in one application.
    Remember, Google Sheets is available for free to anyone with a Google account or Google Workspace account. It’s also ideal for collaborative projects thanks to Google’s sharing and editing features. Happy sorting!

  • Formula Parse Errors: What They Are & How to Fix Them

    You’re working in a spreadsheet and you want to use a function.

    You write the formula, excited to get the results, then you see “Formula parse error” leaving you feeling confused and a little defeated.
    Let’s cover what that actually means and what probably lead to that error message.

    It’s like trying to speak a different language without taking the time to learn it first.
    The software can kind of make out what you’re saying, but not well enough to give you an accurate result.
    There are two likely causes for this error: There’s a typo in your formula, or the order of operations is unclear.
    We’ll go over some examples of each so that you can identify and fix them in your own formulas.
    Common Formula Parse Errors
    Usually, a formula parse error happens because of:
    Incorrect syntax
    – E.g.: Typing =+ instead of =, forgetting to put quotation marks around text values, putting two operators next to each other without anything in between them

    Incomplete syntax
    – E.g. Leaving out a parentheses.
    Another reason why you may be getting these errors is that you’re trying to use text values where numbers are expected.
    Let’s dive into the specific types of errors you may encounter:
    #N/A Error
    One of the most common errors is the #N/A error. It occurs when a formula can’t find what it’s looking for.
    For example, if you’re using the VLOOKUP function to find a value in a table, and the value you’re looking for isn’t in the table, you’ll get the #N/A error.
    #DIV/0 Error
    This happens when you try to divide a number by zero.
    For example, if you have a formula =A17/B17 and the value in B17 is 0, you’ll get the #DIV/0! error.
    #REF! Error
    When a formula contains an invalid cell reference, you will get this error message.
    For example, if you have a formula that references cells A17:A22 and you delete row 21, the formula will return the #REF! error because it no longer has a valid reference.
    #VALUE Error
    The #VALUE! error occurs when a formula contains an invalid value.
    For example, if you have a formula that multiplies two cells and one of the cells contains text instead of a number, you’ll get this error.
    #NAME Error
    This error occurs when a formula contains an invalid name.
    For example, if you have a named range called ” Prices” and you accidentally type “price” in your formula, you’ll get the #NAME? error.
    #NUM Error
    The #NUM! error occurs when a formula contains an invalid number.
    Say you have a formula that divides two cells and the result is too large to be displayed, you’ll get this error.
    Now that we know what can cause a formula parse error, let’s look at how we can fix them.
    How to Fix Formula Parse Errors
    The best way to avoid getting formula parse errors is to carefully check your syntax as you type it out. If you’re not sure what order the operations should go in, refer back to the order of operations suggested by the software you’re using.
    If you’re getting formula parse errors, here are some steps you can take to fix them:

    Check your formula inputs and make sure they’re correct.
    Use the IFERROR function and display a different result if an error occurs. E.g. “Not found.”
    Check your spelling and make sure all the parentheses are in the right places.
    Make sure you’re using the correct operators.
    Use cell references instead of hard coding values into your formulas.
    If you’re using text values, make sure they’re enclosed in quotation marks.

    By following these steps, you can avoid formula parse errors and get accurate results from your formulas.

  • Send Your Clients A Birthday Email That’s Sure to Get Engagement

    Birthdays can be fun to celebrate. They’re like our own personal holidays where people wish us a happy birthday, wait staff sings and brings us free desserts, and our social media feeds are filled with best wishes and adorable memes. It’s also fun to watch the birthday offers roll in

    Free dinner at our favorite restaurant? Yes, please.
    Free ice cream at the best ice cream shop in the city? Don’t mind if I do.
    25% discount on our preferred brand of makeup or beer? Where do I pay?
    Thankfully, receiving a birthday wishes email from your favorite businesses isn’t just good for the consumer. It’s also great for the business.
    Happy Birthday Emails
    A happy birthday email is an automated marketing email that is sent out on or near a customer’s birthday. While these emails celebrate the “personal holiday” and give the customer a special offer to help sweeten their day, they are actually designed to increase customer sales and retention.
    Benefits of Sending a Birthday Wishes Email
    As we mentioned earlier, birthday emails benefit the business as well as the customer. There are a variety of reasons to send a birthday email including:

    Staying top of mind with your customers
    Reminding potential customers that you exist and likely have the solution they need
    Showing loyalty to existing customers and subscribers
    Garnering goodwill that will likely lead to word-of-mouth marketing and referrals
    Increasing sales (the birthday holder may get a free meal, but they’re probably not dining alone)
    Increasing retention (80% of retail professionals indicate that email marketing is their greatest driver of customer retention)
    Improving customer engagement
    Creating a sense of community

    According to Experian, birthday emails can be a powerful play for businesses. Their survey found that birthday emails had a 481% higher transaction rate, resulted in 342% higher revenue, and had a 179% higher unique click rate when compared to other promotional emails.
    Ready to start celebrating your customer’s birthdays with them? Check out the format below to get started.
    Happy Birthday Email Template
    When it comes to designing your birthday emails, creativity counts. Your email service provider should have multiple templates to choose from that can be customized to better reflect your brand.
    A birthday email should be friendly and fun and provide something (besides well wishes) to the customer. You can offer a discount, special offer, or a free gift with purchase.
    Include your customer’s name in the email or subject line to make the email feel more personal. If you collect any information about your customers’ geographic area, hobbies, interests, or family, you can add this to the email to personalize it further.
    Keep the email brief and highlight what you’re offering them to help their celebration. You can send these emails out before or on their birthday. However, you’ll need to make sure that your copy reflects the option you choose. Include all the promotion details so customers know exactly what they’ll get if there are any requirements (like a purchase) to receive it, and the expiration date so they don’t miss out.
    Here’s a sample template you can follow when crafting a birthday email for your customers:
    Subject Line: Happy Birthday, [Customer Name]
    Happy birthday to you! We’d love to treat you for your special day. Celebrate with a [XYZ special offer] the next time you order.*
    *Offer expires on [Expiration Date].
    Need some more inspiration? Check out these birthday email examples.

    If you don’t want to send a happy birthday email from scratch, there are a number of tools you can use to send digital e-cards and gifts. Rybbon integrates directly with your CRM to send e-gift cards and offers to your contact list. 
    For more personalized gifts, Sendoso can help companies send direct mail, and physical gifts within one easy-to-use platform.
    Birthday Email Subject Lines
    A birthday email is only as powerful as its subject line. Why? Because if you don’t catch their attention the moment they see it in their inbox, they won’t bother opening the email and all of your work will be a moot point.
    There are a variety of email subject lines that will pique your customer’s interest. Here are a few to consider:

    It’s your birthday! (We want to help you celebrate)
    A special gift for your birthday
    Make a wish
    A special gift of $10 off for your birthday
    Have your birthday dinner on us
    An important birthday is coming up
    A little bird told us it’s your birthday

    Whether you choose to go with one of these options or construct your own, you’ll want to include:

    What your email is about
    What you are offering them
    A catchy or intriguing sentence to catch their attention
    An expiration date to express urgency

    Remember that the average person’s inbox is flooded with marketing emails on a daily basis. Make sure your subject line is able to capture their attention.
    Sending happy birthday emails to those on your email list (whether they’ve purchased from you in the past, or not), is a great way to help your contact celebrate their birthday, and for your company to build a stronger relationship with its audience.

  • Things to feel bad about

    You might have a list of them. In fact, many of us do, and consult it quite often. The list is defective for a number of reasons:

    It’s not accurate. There are things that aren’t right in our world that don’t appear on the list. Our personal list tends to be organized around things that are vivid, personal and apparently urgent, as opposed to useful or important.It ignores systemic problems in favor of individual annoyances.It makes a profit for the media, but doesn’t help us make things better.It’s not helpful. Memorizing the list isn’t helping us get any closer to doing anything about it.It’s actually a trap, designed to keep us from doing the important work we’re afraid to do. It’s Resistance, in the form of buzzkill.It’s distracting. All the moments we waste focusing on the feel-bad list simply serve to make us feel bad. That’s the list’s job.

    Lists like this aren’t a helpful way to avoid bad outcomes. But they do allow us to experience the bad outcomes in advance, even the ones that don’t happen. If feeling bad is keeping us from doing things that produce better outcomes, more connection or simply joy, it’s a waste.

    The best use of the list might be to write it down, make it complete, carefully put it in a drawer for later. And then forget about it.

  • Instagram Reels: What’s The True Impact They Can Have for Small Businesses?

    Nowadays it’s impossible to scroll through your Instagram feed without coming across at least one — if not several — attention-grabbing videos known as Reels. Dubbed the TikTok Clone, Instagram Reels were released in 2020 and consist of short videos up to one minute long. The feature has overtaken the app’s photos-first philosophy as 91 percent of active Instagram users say they engage with video content on a weekly basis. And can you blame them? It’s easy to quickly get immersed in a seemingly endless loop of engaging content.  Along with being wildly popular, Reels are also proving to be a good business strategy for content creators and businesses alike. A recent New York Times article detailed how Instagram’s latest algorithm favors accounts that post reels. For many, this news means pivoting their marketing strategies to include Reels as a way to ensure their engagement rate stays up. So, if you’ve been considering making the switch to video content, now’s definitely the right time!How these entrepreneurs grew their small businesses thanks to Instagram Reels Instagram Reels can help your brand stay relevant while also allowing for more creativity in how you showcase your product or services. Instead of relying on fixed images, videos allow you to talk directly to customers, do in-depth product marketing, and overlay your posts with trending music and editing techniques making them more appealing to your followers. Here is how three small businesses successfully utilize Instagram Reels:Cards by Shairy: Reels led to brand deals Shairy Aroro runs a small business creating handmade greeting cards – among other crafts like her fan-favorite explosion gift boxes – and documents the entire process via Instagram. She made her first custom order for a client in 2017 and has grown her craft, along with her follower count ever since. She currently has over 50,000 followers and has posted dozens of Reels, which she credits for her success. In a response to a user question asking her how she got so many followers, Shairy responded, “For followers, make Reels.”Shairy’s first Reel was posted in 2020 and currently has 17,000 views, a minuscule amount compared to the numbers her recent Reels are raking in. This video of Shairy putting the finishing touches on one of her products was viewed over 88,000 times. Another Reel where she crafts hot pink pompoms gained an impressive two million views. The influencer has ascribed her business’ growth to her passion for crafting along with documenting her process online, “I literally had no idea how far I would be going with this. It was just a hobby and I felt great spending time doing something that I always loved … I kept posting my work and people started noticing,” she said on her Instagram stories. View this post on Instagram A post shared by Handmade cards by Shairy ♡ (@s_handmade_cards) And this very passion has afforded her new business opportunities, not only by growing her customer base but also through brand deals. This year, Shairy partnered with the craft store Paperedge India to create a reel series on fuse tools. The series speaks to the range Instagram Reels allows content creators and small businesses. Instead of just posting fixed photos of her projects, Shairy was able to engage with more viewers when she started posting Reels that highlighted all the details and intricacies of her work, like this video where she unboxes one of her crafting projects. Shairy has said that she’s constantly working on customer orders, and has even recently hired an assistant to help with her crafts as her business is expanding and thriving.Jessica Ngyuen: a cult-favorite product developed via ReelsJessica Nguyen’s signature chili oil – Chili Oil On Everything – is a perfect example of a product born through Instagram. After getting laid off from her corporate job in early 2020, Jessica decided to invest time into her Instagram as a way to try new recipes. The influencer soon made a name for herself with her decadent food videos, while also offering viewers pointers on how to host the perfect dinner party. Her Reels stand out from other food influencers for being highly produced and stylized, like this one, where she teaches viewers how to set placemats elegantly. She started gaining followers immediately and noticed one of her recipes in particular –  her chili oil  – was by far the most popular. In August 2020, she created a small batch as a favor for a friend’s business competition and advertised it on her Instagram, marking her very first Reel. Though she explicitly said the product was not for sale, she began receiving online inquiries from dozens of followers asking if they too could purchase it. This pushed Jessica to take a chance and officially sell her chili oil. View this post on Instagram A post shared by JESSICA NGUYEN- COOK & CREATIVE (@jessica_nguyen_) After figuring out some logistics, Jessica began manufacturing the oil and dropped the first batch less than a year after getting laid off. And just like that, her small business was born. Within a month over 1,000 units had sold out. Her subsequent product drops have all been successful, and the entrepreneur’s fourth batch will be released sometime in 2022. Judging by the comments her followers have left, they can’t get enough. “Woo Hoo!!! Purchased my 6 jars,” one comment reads. Another says, “I’m running out of my batch #3 order hopefully the Feb 2022 drop isn’t too far off.” That Jessica started out as a food influencer with no clear plans to launch her own business just speaks to the power of Instagram Reels as a potentially strong advertising medium for entrepreneurs. As she says herself, “What started as a humble recipe shared on my Instagram is now a product and cult condiment that so many can’t get enough of!”RachaelsGoodEats: a fitness business built via ReelsRachael DeVaux is a longtime Instagram influencer, registered dietitian, and trainer who has been posting about healthy recipes and fitness since 2015. During 2020, however, the influencer’s Instagram page expanded thanks to the power of Instagram Reels, eventually leading to her co-founding her very own fitness business.When the pandemic first hit and individuals were no longer exercising at gyms, Rachael began doing home workouts in real-time on her Instagram Lives and noticed a huge uptick in viewers. Her IG Lives became so popular she was hosting them multiple times throughout the week and even celebrated its one-year anniversary. Once Instagram released Reels in August 2020, Rachael began dropping fitness videos as a way to supplement her live workouts. She posted her first workout Reel – banded glute warmups –  on August 18, 2020. The Reel received over 400,000 views and 10,000 likes. A similar workout Reel from December of that year has been viewed over 250,000 times. View this post on Instagram A post shared by Rachael DeVaux, RD, CPT, PES (@rachaelsgoodeats) Though Rachael had posted workout content before, this was the first time she had done so via quick and to-the-point videos, which became a hit on Instagram. Her Reels were so popular that Rachael increased her follower count from 400,000 in late 2019 to over 620,000 followers today. The influencer’s brand had expanded enough for her to launch her own fitness equipment business in mid-2021 called Sweat Recreation. In a post, Rachael credited the creation of the company to her followers, “At the start of quarantine it was my goal to provide you with all the free workouts + healthy recipes you’d need to live your happiest life at home and I’m so honored you trusted me as your trainer each and every single week we did our Live workouts.” In March 2022 Rachael released merch for Recreation Sweat and said the merchandise drop sold out quicker than she anticipated, proving her business is flourishing with the customer base she has built through Instagram Reels.  What’s the difference between TikTok and Instagram Reels?Instagram Reels are considered to be Meta’s response to TikToks, so it is no surprise these two apps are so familiar. In fact, because they’re so similar you may be wondering which platform you should invest your time in. The answer depends. If you or your team has the bandwidth to keep up with multiple social media sites, there’s no harm in posting on both platforms. After all, it’s never too late to get started on TikTok. But, if you’re someone who doesn’t have a lot of time to spare and is already on Instagram, here are a few reasons why it’s probably best to stick with Instagram Reels.AudienceInstead of starting from scratch on TikTok, it might be better to focus on growing your Instagram account. While both apps are used by millions of people daily, you should also take into account your target audience and ask yourself which app your customers spend most of their time on. Over 43 percent of Tiktok’s global audience is between 18 to 24 years old, while Instagram’s main demographic leans a bit older at 25 to 34 years old.EditingInstagram reals can only be up to one minute in length, however, users can create up to 10-minute long TikToks. This longer duration can allow for more creativity, but it also means more work for content creators and small business owners to plan out and edit these videos. On the other hand, Reels are bite-sized and won’t be a headache to produce.ShoppingThough TikTok is very popular, the platform’s interface doesn’t have any infrastructure to actually encourage viewers to buy products. With Instagram, small businesses can utilize links and the shopping tab to not only advertise their products but allow viewers to purchase items without ever leaving the app. According to Instagram, over 130 million users engage with shopping posts on a monthly basis, making it a great channel for you to increase sales. Ultimately, we’ve been happy to see that Instagram Reels has created new opportunities for brands to advertise and sell their products in creative ways. Have another question about Instagram? Send us a DM!

  • How Amanda Natividad Got Her First 1,000 Newsletter Subscribers

    Despite being VP of marketing at SparkToro, a classically trained chef, and the past host of the Growth Machine Marketing podcast, Amanda Natividad had trouble growing her newsletter following.
    When she started The Menu, she had more enthusiasm and ambition than subscribers. Her following didn’t grow as fast as she’d hoped. Six months into the endeavor, she only had 400 subscribers.
    Amanda didn’t give up. Instead, she converted her sizable marketing experience into a plan and got to work. She reached 1,000 subscribers a month and a half later. Today, she has 2,600 readers and gains around 500 more each month. Here’s the method that helped Amanda gain 600 new subscribers in six weeks — and can help you, too.
    Plan a sustainable format
    Consistency is essential to building a successful newsletter. Before you write your first email, decide what you want to send and how often. The most important thing is finding a schedule you can stick to.
    It might take some time to figure out what works. If the format you chose is causing you stress, keep iterating until you find one you can stick to. Swap out a section you never have enough content for in favor of something more flexible or send less often than you initially intended.
    [I]f you aren’t sure whether you’ve found your groove, keep testing new things.
    “And if you aren’t sure whether you’ve found your groove, keep testing new things,” Amanda advises. “Not just new ideas, but test your schedule, writing cadence, try seeing if publishing ahead of time begets new ideas for a newsletter.”
    Amanda’s newsletter has been through multiple changes since it launched. “I knew from the very beginning I wanted to have some curation element,” she said. But it took her a while to land on the name Petits Fours and the four-link format. At one point, she included screenshot interviews in each issue but dropped them because they took too much time. She can try new things without losing followers because she’s consistent in delivering high-quality, topical information.
    Get an initial audience through existing networks
    Your network can help you get your email list started, but you’ll need access to a bigger audience to continue growing. Even with word-of-mouth support from her initial subscribers, Amanda was limited in how many people she could reach. Her subscriber count started rising again when she looked to built-in social media audiences.
    Amanda promoting her newsletter on Twitter.
     
    She used her social media presence — largely on Twitter — to drum up interest for her newsletter. If you don’t have a lot of followers, reply to big accounts with fresh insights or funny observations. Follow up every attention-getting post with a plug for your newsletter. Twitter hashtag discussions can help you get traffic and earn new followers. Amanda also joined writing communities on and off Twitter to find support and subscribers.
    Use early subscribers as beta testers
    Your relationship with your audience shouldn’t be one-sided. Amanda A/B tested headlines and tracked link clicks to refine her content. The main metric she focused on was the open rate, which she got up to 60%. For reference, our latest benchmarking report found the average email open rate is 21.5%.
    Amanda also solicited feedback by asking her subscribers questions. In fact, she still does “when it feels organic.” Only a small percentage of subscribers reply, but their comments can be invaluable. Sometimes, readers will respond without prompting if they have strong feelings about something: “One time, I skipped the recipe and instead offered a food tip, and 2 people replied to say they were bummed I didn’t send a recipe,” Amanda says. She’s doubled down on including recipes since then.
    More people are rooting for you than you think.
    The one thing Amanda wishes she’d tested was sending a shorter newsletter. “Sometimes I wonder if my newsletter is too long, but it might be strange to renege on length now that I have a few thousand subscribers,” she told us. However, her top takeaway had nothing to do with her content, scheduling, or newsletter logistics. “[The] biggest thing I learned is, truly, the importance of creating a safe space for yourself to test ideas,” Amanda said. “More people are rooting for you than you think.”
    Incentivize signups (and make them easy)
    Even engaged followers are unlikely to take your word that they should sign up for your newsletter. Amanda offered value with signup magnets. She didn’t go the traditional route of giving a downloadable resource to anyone who shared their email. She told her Twitter followers they’d get her recipe for Bulgogi Shepherd’s Pie if they signed up before she sent her next email. Seventy of them joined that day. It wasn’t an offer she could use more than once, but it did provide a sense of urgency.
    For subscribers who don’t see the incentives she tweets, Amanda shows exactly what her newsletter provides. Her website, amandanat.com, has copies of every newsletter she’s sent. Offer free previews, so readers can see what they’re signing up for before committing.
    The easier your signup form is to complete, the more subscribers you’ll get. Amanda sends emails through Revue, which is owned by Twitter. As a Twitter user, she loves how anyone who finds her on Twitter can sign up for her newsletter with one click.
    Elements of a good newsletter signup page
    How can your signup page reduce risk and make it easy for new readers to subscribe? Here’s what Amanda Natividad recommends:

    Set expectations: Tell a reader exactly what they’ll get when they share their email and offer sample content for them to view before signing up.
    Prove credibility: Amanda mentions her culinary school training and tech/marketing work to show she knows what she’s talking about.
    Provide social proof: Share the size of your email list or reviews to prove your subscribers are benefitting from your newsletter.

    Create opportunities to promote yourself
    Reach beyond your audience by appearing on podcasts, writing guest posts, or contributing to other credible media within your niche. Choose promotional efforts that benefit you and another creator in your niche for the biggest effects.
    Every external marketing opportunity needs to have a double purpose or else I can’t commit.
    The size of your audience and the amount of time you have to spend on promoting yourself will shape the types of opportunities you should look for. Here are Amanda’s recommended methods:

    Co-marketing: Use your newsletter to recommend and link to other newsletters in the same subject area. You’ll likely get a shoutout in return, especially if you know the writer.
    Podcast appearances: Reach out to podcasters to see if they’re looking for guests and tell them you’ll cross-promote your episode to your email list. Then mention your newsletter during recording.
    Guest posts: Reach out to bloggers or newsletter writers and offer to contribute a guest post. Make sure your name is prominently attached, and add a link to your newsletter.
    Webinars: Partner with a friend to host a webinar. After you’ve won over attendees with your expertise, mention your newsletter and invite them to subscribe.

    Cross-promotional opportunities can also help you come up with ideas for your own newsletter. Write an entire issue about something you discussed on a podcast, or add an excerpt from your guest post to your next newsletter.
    Amanda now considers how opportunities can boost her personal brand or that of SparkToro, where she currently works. “Every external marketing opportunity (like a podcast or webinar) needs to have a double purpose (say, to promote SparkToro AND serve as inspiration for a Twitter thread for my personal account) or else I can’t commit,” she says.
    Be careful not to stretch yourself too thin. Amanda learned the hard way that taking every opportunity means losing time she’d like to spend on other pursuits. She advises writers to “block times on your calendar for serendipitous opportunities (like potential podcast appearances), and STICK TO IT.” While too many opportunities may sound like a good problem to have, you don’t want your newsletter (or other commitments) to suffer because you’re too busy.
    Anyone can start a successful newsletter
    Everything Amanda did is replicable if you’re willing to put in the work. You will see a return on investment for the effort you expend to promote yourself and your newsletter.
    The most valuable thing you can give your newsletter is time. “I spend maybe 2 hours on each newsletter edition, the day of the send. The fastest I’ve been able to do this is just over 1 hour,” Amanda shared.
    She’s also constantly thinking about how to improve her emails. “Now that you ask me, I might always be testing a new section. You might see me experimenting with new ways to promote my YouTube show in the near future,” she told us.
    You can see her new efforts for yourself by subscribing to The Menu or following her on Twitter at @amandanat.
     
    The post How Amanda Natividad Got Her First 1,000 Newsletter Subscribers appeared first on Campaign Monitor.

  • #1 LinkedIn growth hacker = live now

    Hey Reddit, want to hear from Stefan Smulders, founder of Expandi.io? He’s the #1 LinkedIn growth hacker and that’s exactly what he’s talking about today. ​ Join us LIVE now during the Cold Email Summit! https://www.youtube.com/watch?v=wUT7TwCCT2E submitted by /u/Ill_Hair_733 [link] [comments]

  • Check this out: A curated directory of 300 Growth Hacking resources 🚀

    submitted by /u/Alive-Honeydew1770 [link] [comments]

  • The Ultimate Guide to Service Level Agreements (SLAs)

    At many companies, it can feel as if there are 100 miles between sales and marketing. In a recent LinkedIn survey, 60% of global respondents believed that misalignment between sales and marketing could damage financial performance, yet there are a number of disconnects between the teams from strategy to process.
    One of the most critical steps for aligning your sales and marketing efforts is creating a service level agreement (SLA). Traditionally, an SLA serves to define exactly what a customer will receive from a service provider. But SLAs serve internal operations as well, and sales and marketing agreements are among the most crucial.
    .
    Ultimately, a service level agreement is designed to create alignment between two parties by setting clear expectations and mitigating any issues before they happen. With that in mind, there are multiple types of SLA depending on your use case.

    1. Customer Service Level Agreement
    A customer SLA is just what it sounds like: an agreement by a vendor to deliver a certain level of service to a particular customer. Here’s a fun example:
    In the TV show The Office, the company, Dunder Mifflin, supplies paper to various organizations. They might have a customer SLA stipulating that Dunder Mifflin will supply [Company X] with 50 reams of paper per month, shipped every Monday to [Address 1] and [Address 2] by Darryl Philbin — with a confirmation of delivery sent to Jim Halpert. (Sorry, we had a little too much fun with the references in that one.)
    2. Internal Service Level Agreement
    An internal SLA only concerns parties from within the company. While a business might have an SLA open with each of its clients, it can also have a separate SLA between its sales and marketing departments.
    Let’s say Company X’s sales department has to close $5,000 worth of sales per month in total, and each sale is worth $100. If the sales team’s average win rate for the leads they engage with is 50%, Company X’s marketing director, Amir, can work with the sales team on an SLA, stipulating that Marketing will deliver 100 qualified leads to sales director, Kendra, by a certain date every month. This might include four weekly status reports per month, sent back to Amir by Kendra, to ensure the leads Kendra’s team is receiving are helping them keep pace with their monthly sales goal.
    3. Multilevel Service Level Agreement
    Multilevel SLAs can support a business’s customers or the business’s various internal departments. The point of this type of SLA is to outline what is expected of each party if there’s more than just one service provider and one end user. Here’s an example of a multi-level SLA in an internal situation:
    Company X’s sales and marketing teams partner up on an internal SLA that delivers leads from Marketing to Sales every month. But what if they wanted to incorporate a customer retention strategy into this contract, making it an SLA between Sales, Marketing, and Customer Service?
    After sales closes 50 new deals for the month, it’s Customer Service’s job to keep these customers happy and successful while using the product. In a multi level SLA, Company X can have sales director, Kendra, send monthly “customer friction” reports to Joan, the VP of service, based on dialogue the sales team has regularly with its clients. This helps the customer service team build a knowledge base that better prepares them for the pain points customers call them about.
    You can learn more about customer service’s increasing role to business growth in the HubSpot Academy.

    What does an SLA include?
    The details of an SLA will differ among internal and external agreements. Nonetheless, there are common building blocks that each SLA should include, whether the recipient of the service is your customer or your sales team.
    Featured Resource: Free Marketing & Sales SLA Template
    Download this Template
    HubSpot’s Sales & Marketing SLA Template is the ideal resource for outlining your company’s goals and reaching an agreement between these two crucial teams. Download it now for free.
    1. A Summary of the Agreement
    The first item on your SLA should be an overview of the agreement. What service have you agreed to deliver to the other party? Summarize the service, to whom it’s being delivered, and how the success of that service will be measured.
    2. The Goals of Both Parties
    In external SLAs — those between a business and its customers — the goals stated in the agreement are primarily those of the customer. If this is your intention, work with your client to marry their needs with the abilities of your product, and come up with a measurable goal that your company can feasibly meet for the client on a regular basis.
    Is this an internal SLA between your sales and marketing departments? Both teams should have their goals outlined in this section of the contract, while making sure that when Marketing hits its goal, Sales can reach its own goal as a result.
    3. The Requirements of Both Parties
    SLAs should include what each party needs in order to reach their goals. In agreements that serve a customer, keep in mind their needs might go beyond simply “the product.” They might need more than that to reach their goals — such as weekly consulting, reporting, and technical maintenance from you.
    SLAs between sales and marketing teams should describe what they might need from the opposite department in order to help them hit their targets. Marketing, for example, might need weekly status reports on Sales’ pipeline so the marketers can adjust their lead-generating campaigns accordingly.
    4. The Points of Contact
    Who’s in charge of making sure each party’s goals are met? Sort out which team does what, and who talks to whom, in this section of your SLA. Is there a separate employee using the services, in relation to the employee who reports on performance every week? Make it clear who’s involved in the SLA, and how.
    5. A Plan if Goals Aren’t Met
    You might not want to think about it, but there should be formal consequences when a goal isn’t met as part of an SLA. Don’t freak out, though — these consequences aren’t always business-ending situations. Include a form of compensation to the service’s end user for when the service doesn’t meet their agreed-upon goals. In external SLAs, according to PandaDoc, this compensation can come in the form of “service credits.” Grab PandaDoc’s free SLA template here to find out more.
    For Sales and Marketing SLAs, work with your sales team to establish a plan for how any lost revenue is to be made up as a result of an unreached sales quota. You might settle on a strike system that holds certain employees — in both Sales and Marketing — accountable for diagnosing and resolving issues of low performance.
    6. The Conditions of Cancellation
    Under what circumstances will your SLA be terminated? Whether your contract serves a customer or two internal departments, you’ll typically find yourself putting the SLA on the chopping block when it’s just not working. Maybe your goals have gone unmet for the last three months, or the current agreement simply doesn’t have buy-in from everyone involved.
    Come up with formal conditions under which you’d cancel the current SLA in pursuit of, hopefully, a better SLA.
    Examples of SLAs
    While an SLA will be unique to your needs, here are some examples and templates that can give you an idea of what an SLA may look like.
    1. HubSpot’s Marketing & Sales SLA Template

    As previously mentioned, HubSpot has a template for marketing and sales service level agreements. Instead of being overly complicated, the template provides straightforward, no-nonsense sections so that any party can skim at a glance.
    What we like best: It’s laid out in a two-column style to easily denote which team is responsible for which activities and metrics. Having them side-by-side like this further underscores the goals of partnership and alignment.
    How to Implement This in Your SLA
    Simplicity is the key to recreating this SLA template. Whether you use HubSpot’s offering or create your own, effectively implementing this type of SLA means resisting the temptation to list out every possible outcome and instead focus on the big picture of goals, initiatives, and accountability.
    2. Hivehouse Digital’s Marketing & Sales SLA Template

    Image Source
    This sales and marketing SLA template focuses heavily on metrics, making it a great choice for high-performance teams. The design relies on tables for easy information input and even comes with prompts/examples to help you define the agreement.
    What we like best: The document is organized step-by-step, making it a great choice for teams without a formalized SLA process (yet).
    How to Implement This in Your SLA
    Implementing the Hivehouse model for your SLA means leaning into its step-by-step strengths. By breaking down SLAs into smaller and more manageable steps, there’s less chance of you and your team getting overwhelmed.
    3. Lucidchart’s Marketing and Sales SLA Template With Examples

    Image Source
    Instead of going through the process of creating an SLA, this template organizes sections by the marketing and sales process itself, from goals to lead qualification, handoff, and nurturing.
    What we like best: The template takes a visual approach with columns for marketing, sales, and shared goals. This makes ownership of deliverables crystal clear throughout the process.
    How to Implement This in Your SLA
    Seeing is believing in this type of SLA template. While the nitty-gritty details are there, this approach uses color and shape to highlight important categories and actions. If you’re planning to take this approach to your SLA, use color psychology and graphic design principles to create a visually appealing SLA.
    4. AT&T’s Small Business Service Agreement Example
    Here’s a real-world example in the wild. Not all SLAs are between marketing and sales teams or even other internal departments. Here’s an SLA that lays out a service agreement between AT&T and its customers, setting expectations for the engagement. They make this SLA publicly accessible for all their users.
    What we like best: The agreement is plain and simple, leveraging bullet points to make each detail clear and understandable.
    How to Implement This in Your SLA
    AT&T’s real-world example highlights the importance of calling out what matters — in this case, by using bullet points. Applying the same approach to your SLA means distilling larger and more complicated outcomes into easily-understood snippets that don’t leave room for confusion.

    Image Source
    5. Microsoft Azure SLA Example for Cloud Services
    As a service provider, Microsoft Azure also makes its SLA for customers public. The SLA uses bullet points to clearly identify its offerings and customer promises, which are unique depending on the plan and services rendered.
    What we like best: The SLA is organized with headings for quick navigation to the offerings that are most pertinent, and information is kept concise with an optional “View full details” link.
    How to Implement This in Your SLA
    In-depth SLAs are naturally complicated, making it easy to get bogged down in the details despite best efforts to keep things simple. Microsoft’s example offers a streamlined approach to implementation: Call out the key details and then provide links to the full SLA text.

    Image Source
    6. PandaDoc’s Multi-Page SLA Template
    PandaDoc provides another option for provider/client agreements and is a great choice for more formal arrangements.
    What we like best: This template makes for a clear and concise SLA with times, dates, and solid expectations.
    How to Implement This in Your SLA
    While this type of SLA leans more toward legalese with language like “whereas” and “therefore”, it has the advantage of a solid narrative structure to describe expectations. If you’re planning to implement something similar, consider using a template to speed up the process rather than starting from scratch.

    How to Make an SLA for Marketing and Sales Alignment
    While SLAs are common between businesses and new customers, they can also improve internal alignment. When one exists between sales and marketing departments in particular, this agreement details marketing goals (like number of leads or revenue pipeline) and the sales activities that’ll follow and support them (like engaging leads that were qualified by the marketing team).
    Both the sales and marketing departments use this document as a commitment to support each other based on concrete, numerical goals. And guess what? 87% of sales and marketing leaders say collaboration between sales and marketing enables critical business growth.
    Now, if you don’t have a Sales and Marketing SLA in place, fear not: We’ve outlined how to create one below so that you can easily start aligning your sales and marketing teams.
    To draft your SLA, you first need to align your Sales and Marketing teams around a shared set of goals — or, as we put it before, the harmonious “Smarketing.” This alignment can then dictate the creation of a written SLA that reflects these goals. Here’s how to create an SLA with “Smarketing” in mind:
    1. Calculate a numerical marketing goal based on the sales team’s quotas.
    As a marketing department, not only should you have a concrete goal for each campaign you run, but you also should have a high-level numerical goal that aligns with the sales team’s operations. At the end of the day, that’ll mean qualified leads and actual sales from those leads.
    Salespeople are driven almost entirely by their sales quotas — the numerical goals that correlate with their compensation and job security. If Marketing commits to a similar, related numerical goal, it shows that the team is being held accountable in a manner similar to Sales. The trick, however, is to make sure your numerical goal can effectively power the sales team’s numerical goal.
    In order to calculate the marketing side of your SLA, you’ll need the following four metrics:

    Total sales goal (in terms of revenue quota)
    % revenue that comes from marketing-generated leads (as opposed to sales-generated ones)
    Average sales deal size
    Average lead-to-customer close %

    Then, it’s time to do some calculations:

    Sales quota x % revenue from marketing-generated leads = Marketing-sourced revenue goal
    Marketing-sourced revenue goal ÷ Average sales deal size = # of customers needed
    Customers ÷ Average lead-to-customer close % = # of leads needed

    2. Segment your goals by specific intervals during the year.
    It might also be a good idea to reevaluate the marketing side of the SLA each month, as a variety of factors can change the numbers used in your calculations over time. To do so, create a document that tracks your SLA calculations by month, which should include the following metrics:

    # of marketing-generated leads
    # of those leads that became customers
    Revenue from those closed customers
    Total revenue closed that month from marketing-generated leads only
    Total revenue closed that month

    You will also need:

    The average sales cycle length

    With the figures above, you can re-calculate the metrics you started with on a monthly basis, or at whichever interval suits your business — quarter, year, etc. Just make sure the same measure of time is used for both Sales and Marketing to maintain alignment. Have a look:

    # marketing-generated leads that became customers ÷ # marketing-generated leads = lead-to-customer close %
    Revenue from closed customers ÷ # of marketing-generated leads that became customers = sales deal size
    Total revenue closed from marketing-generated leads / total revenue closed = % revenue from marketing-generated leads

    You could also take it one step further, and incorporate quantity and quality into these metrics. The above calculations provide you with a quantitative volume goal of marketing-generated leads. However, we know that not all leads are created equal, and as a result, some may be considered higher- or lower-quality than others.
    For example, a decision-making executive might be a more valuable contact than an intern. If that’s the case, you can do the above analysis for each subset of leads, and set up separate goals for each type/quality level.
    Want to take it even further? Measure in terms of value, instead of volume. For example, a CEO may be worth $100, for instance, while a director is $50, a manager is $40, and so on.
    3. Calculate sales’ figures and their goals.
    The sales side of the SLA should detail the speed and depth to which a salesperson should follow up with marketing-generated leads. When establishing this end of the SLA, consider these two sales statistics:

    Salespeople who follow up with leads within an hour are nearly seven times more likely to have meaningful conversations with a decision maker on the other end.
    However, only 7% of leads respond to a follow-up contact within five minutes after filling out a form.

    Bottom line? Not all leads may be fit to send to sales immediately. They often need to meet some minimum level of quality, like reaching a certain activity level, which can only take place after being nurtured by Marketing.
    Nonetheless, engaging a lead the short time after he/she converts is critical to maintaining a relationship with them — the question you have to answer is what that engagement should look like. Either sales or marketing should take action to start building that relationship, make nurturing easier, and set up the sales rep for success when she eventually does reach out.
    Keep in mind this advice is futile if you don’t consider the bandwidth of your sales reps. Sure, in a perfect world, they’d make six follow-up attempts for each lead — in reality, though, they may simply not have enough hours in the day to do that. For that reason, you’ll also need to factor in the number of leads each rep is getting (based on the marketing SLA), how much time they spend on marketing-generated leads versus sales-generated leads, and how much time they have to spend on each one. If you’re looking to conserve time, some of the follow-up — email, in particular — could be automated, so look into options there.
    4. Set up marketing SLA reporting.
    Now that you have your SLA goals, it’s time to track your progress against that goal — daily.
    To start, graph the goal line using this formula:
    (1÷n x g)
    Where n is the number of days in the month and g is your monthly goal.
    That should determine what portion of your monthly goal you need to achieve each day. You’ll want to graph that cumulatively throughout the month and mark your cumulative actual results on the same chart. We call that a waterfall graph, and it looks something like this:

    5. Set up sales SLA reporting.
    For the sales SLA reporting, you’ll have two graphs — one monitoring the speed of follow-up, and the other monitoring the depth of follow-up.
    To graph the speed of follow up, you’ll need the date/time the lead was presented to sales, and the date/time the lead received her first follow-up. The difference between those two times equals the time it took for sales to follow up with that particular lead.
    Take the averages of lengths of time it took for sales to follow up with all leads within a particular timeframe — day, week, month — and chart it against the SLA goal.

    To graph the depth of follow-up — e.g., the number of attempts — look specifically at leads that have not been connected with, since the goal of the follow-up is to get a connection. For leads over a certain timeframe that have not received outreach, look at the average number of follow-up attempts made, and graph that against the SLA goal.

    6. Communicate, celebrate, and address the achievement (or lack thereof).
    Maintaining strong communication regarding how each team is performing on goals boosts transparency. If either team isn’t reaching their goals, addressing that confirms their importance, while celebrating hitting those goals can aid motivation.
    If you’re not sure where to begin when it comes to setting these goals, check out our free Marketing & Sales Lead Goal Calculator, designed to help you determine and track the goals that will eventually become part of your SLA.

    To ensure you’re getting the most from SLA creation, implementation and management, it’s worth aligning your efforts with industry best practices. Some of the most common include:
    Define Realistic Goals
    While promising the moon might seem like a good idea, things can quickly go off track when SLA outcomes aren’t met. As a result, it’s worth starting SLA creation with a brainstorming session that includes relevant stakeholders. Here, the goal is to define what you want to do, what you can do, and what you can reasonably offer.
    Ensure Everyone is On Board
    Next, make sure all relevant parties feel like their needs are being met with your draft SLA. Better to find out up-front that there are potential problems — and make proactive changes — than face pressure to scrap in-place service level agreements and start over.
    Get Specific
    Specificity is what makes SLAs work. For example, if you’re an IT service company drafting an SLA about uptime, the number of “nines” — 99.999 percent, 99.9999 percent, etc. — defines exactly how much uptime you’re agreeing to provide. Using specific terminology reduces the risk of conflict around SLA expectations by removing ambiguity.
    Pinpoint Key Metrics
    While specific SLAs are a solid starting point, you also need ways to effectively measure the success of your agreement. In the uptime example above, minutes of downtime per year are often used to determine if goals are being met. When it comes to marketing or sales, meanwhile, metrics could include leads generated, deals closed, or any other measurement that makes sense under your SLA structure.
    Account for the Unexpected
    Unexpected events — such as severe weather, staffing challenges, or sudden IT failures — can make SLA goals challenging to reach. As a result, it’s worth creating clauses that account for unexpected events. While there’s no way to predict exactly what will happen, and obligations remain to meet at least minimum standards, building in some breathing room for the unexpected is well worth the effort.
    Double-Check the Details
    Even small details matter. Consider the example above: While 99.999 percent uptime works out to just over 5 minutes of downtime per year, 99.9999 percent is 31 seconds. Here, a misplaced 9 could put your company on the hook for providing service levels that are almost impossible to reach. As a result, it’s worth getting your SLA double-checked by a fresh pair of eyes before moving forward.
    Review and Revise as Needed
    Service level agreements aren’t static documents. While they cover a set period and describe a specific set of actions, both provider and partner needs can change during that time. As a result, it’s worth building in the option for review part way through the SLA agreement period and conducting a full review when the contract is up to determine if changes are required.
    One Last Step When It Comes to SLAs
    When it comes to what should be in your service level agreement, there’s one final piece: Review these metrics on a regular basis to monitor your progress, and make sure both Sales and Marketing have access to the reports for both sides of the SLA.
    This step helps to maintain accountability and transparency and allows for both teams to address issues — or congratulate each other on productive results.
    Editor’s Note: The post was originally published in January 2019, but was updated in December 2019 for comprehensiveness.