Bulk Upload and Schedule Content via CSV

In this article, you will learn how to automate posts for your social channels in bulk. ContentStudio 2.0 brings you the functionality of Bulk Upload which lets you schedule multiple messages in multiple languages to your social media channels via CSV data import.

This feature is useful for when you want to perform a similar action multiple times, in a single go.

The bulk uploader provides a template CSV file in which you can:

  1. Populate multilingual data for your posts.
  2. Choose your social channels.
  3. Schedule your posts.

Follow the guidelines and see how you can create a campaign using the Bulk Uploader.

First of all, sign in to your ContentStudio Account and go to Publish. Find Automation on the top left corner of your screen. 

Bulk Uploader is the sixth Automation recipe. Click on the New Upload button to create a campaign.


Step 1: Upload your CSV

In this step, you have to upload a CSV file. You can download the template CSV file and edit it, but your file must contain the following information.

  • Date and Time
  • Message
  • Image URL
  • Link 
Date and Time

In this column, you have to enter the date and time (in the format dd/mm/yyyy hh:mm or mm/dd/yyyy hh:mm) for the posts that you want to schedule. You have to strictly follow the date and time format in order for it to get executed successfully. 

Message

This column lets you add the messages to your posts (better known as the captions for your posts; be it an image or a link post). You can customize messages for four different kinds of posts.

Note: You can schedule up to 500 posts for your social channels via the bulk upload recipe. 

Text only post If you want to create a post in which you just want to add some text, you can do that by adding that text in this column. 
Text with image post If you want to create a post in which you want to add an image and some text along with it. You can do that by adding your custom text in this column and then the image URL in the next column.
Text with link preview If your post has a link and you want to add some message with it, enter your message here and the link in the fourth column.
Text with Custom Image on Link preview If you want to create a post in which you want to add a link, a custom image, and a message, enter your message/ caption in this post and image URL and link in the next two fields, respectively. 
Image URL

You can add images to your posts by adding the image URLs in this field. Use the URLs of any public image.

Link

Add links for articles, blogs, or any kind of public content to your posts by entering the link URL in this column. 

Note: ContentStudio 2.0 provides multi-lingual support, allowing you to broaden the spectrum of your social media posts. The language support in the new version will be diversified by allowing you to choose any language in your bulk posts.

In the end, your CSV file should look something like this

Note: The first section is strictly for Date and Time. Please follow the pattern exactly, otherwise the Bulk Uploader may not go through.

Step 2: Select Channels


In this step, you have to select your social channels for which you want to create your Bulk Upload campaign. 

Note: We now also have added a Content Category option.


Step 3:  Scheduling Options


In this step, you have to schedule your posts for your selected social channels. You have three scheduling options for your bulk posts which are explained below.

  1. Recurring
  2. Custom
  3. Queue
Recurring

If you choose this option, the date and time entered by you in the CSV file will be ignored and the posts in your file will be scheduled according to the recurring time that you select. You can choose to schedule your posts according to hours, days, or weeks. 

For example, you could choose to post after every 3 hours by selecting this routine. As shown in the image below. 

Custom

Here, you can allow the bulk uploader to make use of the date and time that you entered in the first column of your CSV file. It is very necessary for you to choose the same format as you chose in your CSV file. Your selected time format and how the system interprets can be shown in the image below.

Queue

The third and last option for you is to choose the queue scheduler. Upon choosing this option, the date and time entered by you in the CSV file will be ignored and the posts in your file will be scheduled according to the queue that you have created for social posting.


Step 4: Finalizing your posts


After clicking on the Next button of step 3, your CSV file is thoroughly read and processed by the system. 

Once the processing is finished, a list of all your scheduled posts appears in the tabular form. You can perform the following actions on your posts. 

Edit an individual post

You can edit a post in this step by clicking on the pencil icon in front of the post under the Actions heading.

Your post will appear in the editor where you can change the text, add any link or image, change the time and date, change social channels; add labels, images, or tasks, etc.

Approve/ Delete posts in bulk or Individually

You can select an individual post and approve or delete it by clicking the two buttons under the heading Actions.

Or, you could also select all the files and perform a bulk operation (approving or deleting in bulk). For that, you have to select multiple files and Select Operation (the drop-down menu is located just above the table). For reference, see the image below. 

Troubleshooting: Invalid Date Error 

When your posts are processed by the system, it verifies the posts by showing you the status of each post. If you see a green tick in front of your posts, it means that your post is fine and it has no errors. 

If you see a red cross in front of your posts, the most probable reason for this is if the date and time format in your CSV file and that you selected in your third step, don't resonate. Make sure that both the formats are the same to avoid this error. 

Note: Please ensure you have only added Date and Time in the correct format in the first row. 

Troubleshooting: Special Character Error

If you are facing problem with special characters, or UTF-8 characters in the CSV file, please convert the file first on the following website: https://www.convertcsv.com/csv-viewer-editor.htm

Change the encoding from Default to: "ISO-8859-1 (Latin No. 1)" 

This type is compatible with CSV files to upload in ContentStudio. 

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us