Social media marketing is hard. It takes up time to do and you need to find old links to share your content regularly, especially for evergreen content. After all, sharing just the once isn’t enough. So for the first Social Media Saturday post of the year, I want to offer some social media marketing tips.
More like, I want to share one thing that I’m doing this year to make it much easier for me. It’s something that I started a long time ago, fell off the bandwagon and was just reminded of it at the end of last year: using Excel for your blog post links.
Wait, You Put All Your Links in One Excel Sheet?
I actually have all my links organized by sites. In fact, I have multiple Excel files for the different types of sites that I write at and have some organized by niche/topic. It helps me market to the right people and include the right hashtags quickly.
How you organize your Excel file is completely up to you. I just encourage you to have one. You’ll just be able to open the file and drop in the links as and when you need to.
Here’s a screenshot of one of my Excel files to help you understand what I mean by my organization.
How Does the Excel Sheet Help?
It takes time to create one of these sheets. You need to go through old links and make sure you include them all in the file. Once you have gone back over old links, you’ll need to remember to store your links later on.
I am looking for a way to improve this process. I’m even thinking about using tools like Trello to do it, but right now Excel is the best option.
Right now I’m in the process of doing some of the older posts from the last two years.
The benefit of the sheet is that all the links are in the one place. I don’t need to worry about where my old posts are or hope that I remember everywhere that I have content for sharing.
I then get to recycle old posts on social media to get views onto content that I wrote years ago. If I don’t share the links, there are chances that nobody will ever view the content! After all, some content that I wrote is four or five years old!
Really, the sheet is more of a time saver. Sure, it takes time to set up but once set up it’s easier to maintain.
Do I Update the Old Posts?
I actually have a note next to the content that needs updating. Some of my old posts on my blogs haven’t been touched and I’m in the process of updating the sites.
One thing I don’t want to do is remove the posts all together. That would lead to broke links. Instead, I want to either update or create new posts on the same topic. I can even repurpose the content through videos or infographics and link back to the old content.
My social media marketing tips with the Excel sheets have helped me see which posts are in a desperate need of updating. I can make a note to come back or to check them out when I’m struggling for content ideas—haha, not likely!
But Now What Should You Do?
Okay, so you have your Excel sheet. That’s great!
What do you do with it now?
Well, there is apparently an option to include an Excel file in some social media tools. I haven’t found a way to make that work yet. I’ll keep searching and trialing.
What I do is spend an hour a week going through the Excel files and all my social media accounts. I have some connected to the likes of Hootsuite and Buffer (I’m trialing the two to see which is worthwhile me buying) and I use Facebook’s own scheduler for some of my profiles.
I set up the plan for the week to determine what I want to share and which topics my audience will likely find more useful. Then I go through my posts to see what old and new content I have to share. I’ll drop in the links, schedule throughout the week and leave it at that.
I hope that my social media marketing tips that I share on Social Media Saturday will help you. This is one that I urge you to do right away, even if you’ve only just started writing. You’ll find it much easier to add old links into social media again to help improve your views.
Do you need help with social media marketing? It is something that I can help you with as part of my writer mentoring program. Get in touch today and let’s talk!