Social Media Analytics & Content Creation Tips

My Top-Secret Social Media Content Creator Hack Using Google Sheets

It can be a chore to create social media status updates from your content. I get it. Who wants to copy and paste text into your social media scheduling tool whenever you run out of updates? I’d much rather spend my time doing other things, wouldn’t you? So let’s take back some of your time by eliminating the need to waste hours each week creating status updates. Sound good? Cool. And today, I’ll show you how you can not only easily generate social media updates from your blog posts, but how you’ll be able to use them again and again. This post will cover: Why you need a library of social media updates for each blog post The reason you should share your blog posts again and again How to come up with multiple status updates for a blog post Why you are about to LOVE Google Sheets – even if you hate spreadsheets Ways to find your evergreen blog content Build your own social media content creator using Google Sheets The sneaky way to 10X your social media updates How to recycle your evergreen social media updates again and again In the end, you’ll be able to paste in any blog URL and generate multiple social media updates in less than 2 seconds. Check it out: Excited? Let’s take a look and see how it’s done. Why you need to generate a variety of social media updates Look, it’s no secret that the majority of social media updates are usually just the title of the blog post. And that’s OK if you aren’t into recycling your social media updates. But you’re a smart marketer and you know the importance of stretching out your content as much as you can. So it makes sense to create a bank of evergreen social media updates that you can use over again and again. This way, when you reuse your status updates you have more of a variety of what gets posted. In fact, using the hack outlined in this post I’ll show you how to create social media content with ease which will all be for a single blog post. Bonus points to sharing the variations to your different social media accounts. Here’s a small example: Define Your Own Social Sharing Rule https://t.co/HryfAHOERc pic.twitter.com/MmAC81j91O — Chris Makara ???? (@ChrisMakara) August 23, 2017 Using the 5-3-2 Rule for Social Sharing https://t.co/mlZcy0NGlB pic.twitter.com/LmEYjqUOJL — bulk.ly (@Bulkly) August 23, 2017 The reason you should share your blog posts on social media again and again Depending on the social media channel you are posting on, there’s a good chance that the majority of your audience won’t see what you just shared. In fact, according to Moz the average life of a tweet is 18 minutes. Some other studies have listed it lower than that. The bottom line is that on social media (especially on Twitter), your status updates drift off pretty quick. This means that for the most part, your audience is not going to see your tweet. Whether it is too much going on their feed, or the fact they were not online when you posted – your status updates tend to disappear in the blink of an eye. So it makes sense to share your links again. In fact here’s what Guy Kawasaki has to say about sharing the same thing again on social media: [perfectpullquote align=”full” cite=”” link=”” color=”” class=”” size=””]”But on social media, if you’re not pissing people off, you’re probably not using it hard enough.”[/perfectpullquote] He goes on to say: [perfectpullquote align=”full” cite=”” link=”” color=”” class=”” size=””]And he has a response to people who complain about repeats: “If you saw my tweet twice, you don’t have a life.” Explaining that he’s simply reaching people who missed the tweet earlier usually mollifies people.[/perfectpullquote] But don’t just take Guy’s word for it. Even Hootsuite has posted the same thing multiple times. Of course depending on your frequency and audience size, you’ll need to find a nice balance of how often to share the same thing. Ideally, you’ll want to know the best time to tweet or ideal times for the channel you are posting to. But, the best way to reduce the likelihood of upsetting your followers is not only a balance of frequency, but using a social media queue that recycles multiple variations for your status updates. How to come up with multiple status updates for a blog post There are a number of ways you can create a variety of social media updates for your profiles. Among them are: Using the blog post titles you didn’t use – chances are that you created multiple titles before you published. These work great as status updates! Pulling stats from your post – If your blog post cites any stats or numbers, these are perfect to use as a social media post. Creating a “pull quote” from your blog post. Paraphrasing key points found within the post These are good ideas…but I’m more interested in automating as much of this process as I can. So, I’m going to reveal the easiest way to create social media content at scale. And to do this, we’re going to use Google Sheets. [optin-monster-shortcode id=”okk7iuuzzirwsbnwbook”] Why you are about to LOVE Google Sheets – even if you hate spreadsheets Look, I know spreadsheets aren’t for everyone. But don’t let Google Sheets scare you if you aren’t a spreadsheet ninja – because I’ll even give you a ready to go spreadsheet with all the formulas set up. And if you want to skip the options I gave above on manually creating multiple status updates, I’ll show you how to use Google Sheets to automatically create the social media content for you. You’re about to find a new love for Google Sheets. So here’s how to do it step-by-step. Create Your Google Sheet Go to Google Sheets and create a new “Blank” spreadsheet. Then inside your spreadsheet, you’ll create the following columns: Group Status Update URL Image URL The next thing […]

Boost Your Social Media Presence By Saving Time With Automation

Seems like every business is on social media these days. Which is the whole reason you’ve established a social media presence as well, right? If you answered that with a quick ‘yes’ and nothing more, you’re not giving your social strategy enough thought. Granted, you definitely need to have what your competitors have in order to keep up in your industry. But business success isn’t about keeping up. It’s about finding better, faster, smarter ways to do what others do – so you can carve a niche for yourself and create a unique competitive advantage. You need your social media presence to be working for you. That could mean a multitude of different things to different companies and people. Do you want to further your brand awareness? Create a stronger dialogue with your customer? Promote helpful content and webinars to establish yourself as a thought leader within your industry? Social media can help you do all of that. But you have to build a strong enough social presence first. In this post, I’ll show you how leveraging social media automation can save you time to increase your visibility even if you have no social media presence. You’ll build an increased social media presence by understanding: Why it’s important to understand your “why” when it comes to social media The ripple effect of responding (or not) on social media and how it can help or hurt your brand The need to refresh your status updates by considering these 5 things Why having a blog is important for your social media presence And more Ready to find out how to increase social media presence? Social media automation = more time to achieve your social media goals When I tell people they need to spend more time building out their company’s social media channels, they look at me like I’m nuts. They say, “I’m always posting stuff”, “Yeah, I hired an intern for that”, “I started a Facebook page a while ago”, but mostly: “I barely have time to post updates, let alone do anything beyond that.” I get it. I used to make the same excuses. But that was before I created Bulkly. Imagine uploading all of your social updates at once and then setting them on autopilot vs. creating list after list of daily updates, then scheduling each one by hand. Bulkly is a social media automation tool that does just that, eliminating those daily social media to-dos that are taking up so much of your time. Already a Bulkly user? You rock! Interested? Learn more here. And social media automation isn’t just limited to scheduling posts. Depending on the social network it might make sense to automate some following and unfollowing of users or even automate reporting. There’s really no limit to the things you can automate if it makes sense. In fact, many Zapier experts have developed complex workflows to streamline various aspects of social media management. Best of all, it’s not complicated. And it costs a whole lot less time and money than hiring another employee to do the exact same things. How to increase your presence on social media By using Bulkly or another social media management tool to automate your daily social to-dos, you can stop making excuses and start spending the time needed to work on things that can help you build a better social media presence. Ready to learn what those things are? Let’s get started. 1. Revisit your social media strategy. I can see the eye rolls already. But I’m serious. When was the last time you sat down and really gave thought to your “big picture” social strategy? Be honest. Probably a few months ago at least, right? Then maybe it’s time to review it to make sure that you’re doing the right things for the right reasons. My favorite way to conduct a thorough and productive strategy review? Work backwards by first finding my ‘why’. What’s the ‘why’ behind your social media strategy? Why are you trying to establish a social presence? And why do you want to improve your social media presence? Your ‘why’ is your end goal, your purpose, the main driver behind everything you do on social, from writing update copy to engaging with followers. Some businesses are trying to further brand awareness. Others are looking to learn more about their customers for market research. Still others are solely focused on driving traffic to their website. Only you know your answer. Got it? Great. Once you’ve pinpointed your ‘why’ (hopefully you knew it right away), it’s time to walk through your campaigns, posting schedules, content shared, etc. to make sure they’re all working toward furthering that purpose. For example, let’s say your ‘why’ is to improve brand awareness. As you’re looking through your recent campaigns, you’re seeing that their execution has missed the mark a little. Most of the efforts supporting these campaigns have been heavily focused on driving traffic to your website. While more website traffic can definitely help further your brand image and persona, traffic should be secondary to your main goal, your ‘why’ = establishing brand awareness. Or maybe not. Maybe there’s a reason your efforts have strayed from your originally planned direction. Maybe it’s time to revisit your ‘why’ itself. Maybe it needs to change based on changes to your business. Or maybe your team just needs you to point them back in the right direction. Either way, taking the time to work backward from your goals to your day-to-day execution gives you a better perspective on your overall social strategy so you can make necessary changes and avoid missing the mark before it’s too late. 2. Increase your level of engagement. People really underestimate the power of conversation. The things you say and how you say them help develop others’ impressions of who you are as a person. If you’re friendly, funny and helpful, people are probably going to associate your personality with those traits. Likewise, if you’re grumpy, rude or dismissive, […]

5 Processes To Supercharge Your Scheduled Tweets

In any form of social media scheduling you have to question whether the output is worth the return. Not too long ago it was easy to gain fast traction on scheduled tweets, updates and statuses. That was before algorithms and pay to play platforms, as well as the channels being far less saturated than they are today.