Do you create written content? Wondering how to drive more traffic to your articles, eBooks, or white papers with less effort?

In this article, you’ll discover a system for easily promoting each piece of content you produce.

How to Promote Your Content via Social Media by Nathan Binford on Social Media Examiner.

#1: Start With an Optimized Title

You’ve written an article, eBook, or white paper so you’ve done the hard part, right? Not so fast. The “hard part” of content marketing isn’t the content creation—that’s the fun part—but rather getting the word out about it.

If you’ve taken the time to create high-quality content, you deserve to reap the benefits and this is only possible if you have the time to devote to promoting it. A solid repurposing strategy will help you be more efficient with your time while increasing the visibility of your written content.

Before we get ahead of ourselves though, I recommend spending some time crafting your headline. Headlines drive clicks. You don’t want to spend hours writing a great article that no one reads because of a weak headline.

CoSchedule’s free Headline Analyzer tool makes it quick and easy to optimize your headlines. Spend 10–15 minutes trying to get the headline to score over 70 and you can be more confident it will perform well on social media.

example headline of 'how to create 10 social posts for every article you write' which received a score of 71 from the coschedule headline analysis tool

Once you have a killer headline for your content, publish it, and then you can move on to promoting it.

#2: Create Your Social Media Post Spreadsheet

The next step is to generate 10 posts from your content to share on social media. Saving this data in a Google sheet or Excel spreadsheet will make it a snap to bulk upload your posts into a social media scheduling tool.

example of google sheet with four tabs of 'in blog', 'out twitter', 'out linkedin', and 'out facebook'

For this example, we’re creating 10 posts to promote a blog post on Twitter, LinkedIn, and Facebook, but you can easily adapt this approach for other written content and social channels.

Here are the columns to add to your spreadsheet:

  • Title: Title of the blog post (repeat 10x)
  • Excerpt: Excerpt/meta description (repeat 10x)
  • URL: URL of the blog post (repeat 10x)
  • Twitter Image, LinkedIn Image, and Facebook Image: Filenames for the images you’ll share in your social media posts
  • Twitter Text, LinkedIn Text, and Facebook Text: Draft copy for your social media posts

example of google sheet with headers labeled title, excerpt, url, twitter image, linkedin image, facebook image, twitter text, linkedin text, and facebook text

  • Length: Length of the tweet to verify the copy is within the 280-characters limit
  • Twitter Approved, LinkedIn Approved, and Facebook Approved: To trigger the final output once social media posts are approved
  • Twitter Final, LinkedIn Final, and Facebook Final: Formatted output for your social media posts (tied to OUT Twitter tab, OUT LinkedIn tab, and OUT Facebook tab)

continued example of google sheet headers labeled length, twitter approval, linkedin approval, facebook approval, twitter final, linkedin final, and facebook final

Now let’s talk about how to use this spreadsheet.

Start by filling in 10 rows with the title and excerpt/description of the content you’re promoting. These first two columns will help you identify which post you’re working on as you scroll from left to right filling in other details in the sheet.

example of google sheet with partial data filled out in the title and excerpt cells for the first 10 rows

In the URL column, enter the URL for the blog post. Use UTMs to track incoming traffic in Google Analytics.

In the Image columns (Twitter Image, LinkedIn Image, and Facebook Image), add the filenames of the images you’ll use for each social post. The post copy goes in the Text columns (Twitter Text, Facebook Text, and LinkedIn Text).

When the copy and images are approved, select the checkboxes in the Approved columns (Twitter Approved, LinkedIn Approved, and Facebook Approved) and copy the approved text to the Final columns (Twitter Final, LinkedIn Final, and Facebook Final).

example of google sheet with partial data filled out in the twitter final cells and the platform check box checked

The last step is to copy each Final column to the relevant social media tab (OUT Twitter, OUT LinkedIn, or OUT Facebook), download it as a CSV file, and upload it to your social media management platform as discussed later in this article.

WP Rocket - WordPress Caching Plugin

#3: Identify 10 Key Quotes or Statistics

Now that you’ve set up your spreadsheet and understand how to use it, you’re ready to start filling it in.

First, grab 10 quotes, statistics, or other snackable (easily consumable) bits of text from your article. Scan your article for sentences that are particularly meaningful and self-explanatory. Pull quotes, actual quotes from interviewees, statistics, and other data points are all good options.

Paste the first snippet you want to share into the Twitter Text, LinkedIn Text, and Facebook Text columns in the first row. Tweak the text to fit the best practices for each social platform and add relevant hashtags to the copy.

example of google sheet with partial data filled out in the twitter text, linkedin text, facebook text cells

Pro Tip: Reuse your blog post excerpt as the first of your 10 social posts since it’s already been edited for brevity.

Once you’ve finished the text for your first social post, repeat this process with other quotable bits from your blog post. When you’re done, you’ll have 10 rows filled with text for Twitter, LinkedIn, and Facebook posts.

continued example of google sheet with partial data filled out in the twitter, linkedin, and facebook text cells with the length field being calculated

#4: Create and Customize Branded Graphic Templates

Now turn your attention to creating branded images for the 10 social media posts you just created.

In your preferred graphic design tool, select a template that has space for a headline, tagline, and branding, and features versions for all of your social media platforms.

screenshot example of graphic design tool with a template selected and identified for a new twitter post

Edit the template to fit your brand style (fonts, colors, etc.). You can ignore the background graphic in the design because you’ll swap it out each time you use the template. Just make sure your company branding and your website address (if included) are visible. When you’re done, save this design to your account.

Canva is a free, easy-to-use tool for creating attractive graphics quickly from stock materials. Other options include RelayThat, PicMonkey, Snappa, Easil, and others.

#5: Produce 10 Quote Graphics for Each Social Platform

Armed with your new design template, you can quickly mass produce graphics by copying and pasting the text for each social media post into the graphic and tweaking it to fit. Remember—the shorter, the better.

Make sure you choose a different background each time you create a set of social posts to promote a new blog article, eBook, or white paper. Your graphic design tool is likely to offer stock images to choose from or you can find images from royalty-free sites like Pexels, Unsplash, and Pixabay.

screenshot example of canva with quote image designs created for each post on each platform to create the post series

Because you’ll sprinkle your 10 posts throughout a much larger social media calendar, it’s okay to repeat the background on these 10 images. People won’t see the posts one after the other on your social channels so it won’t be obvious you repeated the design.

Remember you’ll need to create multiple versions of each image to meet the specs of your different social platforms.

When you’re done creating your images, download them to your computer and paste the image filenames into your spreadsheet.

example of google sheet with partial data filled out for twitter, linkedin, facebook image names as just created in canva

#6: Schedule Your Social Media Posts

At this point, you’ve published a new article, copied 10 of your best quotes from it into a queue, edited your quotes into copy to post to each social network, and created graphics to go with each post. All that’s left to do is import your posts into your social media management platform and schedule them.

Most social media management tools feature a bulk import/upload feature or you can devise a workaround using IFTTT or Zapier.

For this example, I’ll demonstrate how to bulk-upload to Buffer (available in free and paid plans, starting at $15/month). You’ll export CSV files of your posts from your Google sheet and then import them into the appropriate Buffer queue with a third-party tool. The CSV file has a very simple format—one column that contains the text of the post (including the link).

Export a CSV File With Your 10 Posts

Once your 10 posts are approved and ready to be scheduled, open your Google sheet and copy the data from the Final columns (Twitter Final, LinkedIn Final, and Facebook Final) to the OUT tabs (OUT Twitter, OUT LinkedIn, and OUT Facebook).

To visualize this, here’s what the final text might look like on the OUT LinkedIn tab.

example of google sheet with partial data filled out for the out linkedin tab

To export the content from each tab as a separate CSV file, choose File > Download > Comma-Separated Values.

google sheet file menu highlighting the option to download with the comma-separated values option noted

Import Your CSV File Into Your Scheduling Tool

Once you have CSV files of the posts for each social channel, the next step is to import those posts into your scheduling tool. This process will be very similar in any social media management tool: Perform a bulk-upload using the CSV file and attach images one by one to each post.

While Buffer doesn’t directly allow bulk imports, there’s a free tool you can use as a proxy called Bulk Buffer. After you authorize your account, drag and drop a CSV file to your Bulk Buffer dashboard to load your posts, select the social profile you want them delivered to, and click Send to Buffer.

screenshot of bulk buffer with post updates confirmed as being sent to buffer

When the import process is complete, open your Buffer dashboard and add the images manually to each post. Since you’re only uploading 10 posts, it should take just a few minutes to edit each one to add the appropriate image.

screenshot of buffer post with the option to add an image to the post among other settings

Note: If you’re interested in automating this process, there’s a workaround involving a Zapier integration for Google Sheets and Buffer.

Repeat this process to schedule the posts for all of your social media platforms.

Randomize Your Queue

Buffer includes another useful feature when scheduling content in bulk—the ability to randomize your queue with the click of a button. You’ll need to upgrade to a Buffer paid plan in order to get access to this feature.

To randomize your queue, select your social profile on your Buffer dashboard, click Settings, and click the Shuffle Queue button. In the pop-up that asks “Are You Sure?”, click Shuffle Queue to confirm your choice. Now all of the posts you just imported into Buffer will be posted randomly to that particular social media account.

screenshot of buffer with the option to shuffle queue highlighted and confirming that the posts should in fact be shuffled

After the quick automated randomization, scroll through the posts and move any posts that were shuffled together too closely. Dragging and dropping a few errant posts should be all you need to do at this point.


Promoting your published article, eBook, or white paper with multiple social media posts will ensure it receives the attention it deserves. With this simple repurposing system, you can maximize the value of your written content, save time creating content for social media, and greatly increase the visibility of your content to drive traffic.

What do you think? Will you try this process to promote your written content on social media? Share your thoughts in the comments below.

More articles on social media marketing:

Eliminate Spam on all of your devices