Social Media Marketing Tips: Manage Your Blog Post Links in Excel

Social media marketing tips using Excel

Social Media Marketing Tips: Manage Your Blog Post Links in Excel

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?

Sort of.

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.

Social Media Marketing Tips with Excel

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.

Social Media Marketing Tips with Excel

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!

Facebooktwittergoogle_plusredditpinterestlinkedinmail
Alexandria Ingham is a professional writer. She predominately ghost-writes in various niches, including fitness, finance and technology Everything is fully researched and well-written. Under her own name, she writes in the technology, business, history and weight loss niches

11 thoughts on “Social Media Marketing Tips: Manage Your Blog Post Links in Excel

    1. I wish I could answer that question easily. Each social media is different, so it would take me individual blog posts. I’ll do them but it will take some time 🙂 Twitter is one that needs to be done daily and sometimes multiple times a day. The rest not so often.

  1. Love this idea. I created a links sheet to all my online presence but never itemised it to the blog posts. I can see this being extremely useful. Thanks for the tip!

    1. I thought it could be uploaded. I’ve tried but it’s never quite worked properly. I’ll have to figure it out.

    1. The best thing about this is that once it’s set up, it takes just seconds when you publish a post to maintain. It’s just one extra step while you’re promoting your piece for the first time.

  2. Wow, this is great, I really need to do this, but have been a bit unsure of how to start. There are times when I want to re-post a blog and I try to remember the month and search through all my blogs. This would be so much simpler. Do you suggest to save by the date or by the topic? Thanks for all your expertise.

    1. Hi Martha! Great to hear this could help. As I said, I prefer doing it by topic or blog. But it really depends on what you want. The topic works better for me.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top