Bulk Scheduling Posts for the Social Planner Using a CSV

Bulk Scheduling in the Social Planner allows you to prepare, organize, and set up posts for your social media channels ahead of time. You can create content calendars using CSV files (‘comma-separated values’ files) with post details and upload them into the Social Planner. The Social Planner will make each post based on the information given. Bulk Scheduling posts using CSV files will simplify the effort needed to build your social media presence. 

Part 1: Setting up your CSV file

Step 1: Create a CSV file (This can be done in Microsoft Office Excel, Google Sheets, or Apple’s Numbers, to name a few applications)

• If you already have a content calendar created, you’ll want to make sure your columns and cells are labeled correctly

Step 2: Label the columns as follows in order: 

• postAtSpecificTime (yyyy-MM-dd HH:mm:ss)

This is where you’ll specify the date and time you want the post scheduled. You MUST follow the format specified in the header: year-month-date (in numerical fashion) hour:minute:second. Notice there is a space between the date and time; this is crucial. You need to write the time in 24-hr format instead of 12-hr format (so, 13:00:00, instead of 1:00PM).

NOTE: Most sheet/CSV applications automatically format dates as you normally expect — MM/dd/yyyy. Be sure to check this and edit to follow the Social Planner’s settings.

• content

This is where you’ll write the caption for each post. You must abide by the character limits for each platform in order for your post to successfully upload: 

• Facebook: 62000 characters
• Instagram Business Account: 2200 characters
• LinkedIn: 3000 characters
• Twitter: 280 characters
• GMB: 1500 characters

You can include hashtags.

• link (OGmetaURL)

If your post includes a link (to a blog post, for example), you’ll include it here. 

NOTE: If your post also includes images, a GIF, or videos, the Social Planner will consider these elements as the post’s main elements and will move the link into the caption.

• imageUrls

Image URLs will go here as pngs, jpeg/jpgs, and other supported formats. You can add up to 10 images per post, separating each by a comma and a space. 

NOTE: You will need to check with the social platform for proper image dimension and sizing specifications. 

• GIFUrl

Paste GIF URLs for your posts

• videoUrls 

Add video URLs in the accepted formats (MP4 and MOV) for each post. Like images, you can add up to 10 videos in a post, separating each by a comma and a space. 

NOTE: GMB does not accept videos

NOTE: Each post can only have one media format when using a CSV file: images, a GIF, or videos. Mixed media posts will not upload. Only Facebook, LinkedIn, and Twitter accept GIFs. 

NOTE: You can only include 90 posts in each CSV file.

Part 2: Uploading and Scheduling Posts

Step 1: Navigate to the Social Planner: Marketing> Social Planner

Step 2: Click on New Post in the right-hand corner then “Upload from CSV” 

• Choose the right CSV file from your computer and hit Next.

NOTE: Make sure to upload your file with at least 10 minutes to spare from the time of the earliest scheduled post. You’ll want a time cushion in case the system takes longer to process the data. 

Step 3: Select Socials 

• Specify the channels relevant to the scheduled posts on your CSV file. Search for them using the search bar or scroll through. 

Step 4: Review uploaded posts

• As the CSV finishes uploading (“In Progress” → “Review & Schedule”), you’ll be able to review, edit, and fix any errors in your posts.

• Your posts will display in list view, but you can click on the expand icon to see full posts.
• The Social Planner will flag errors which you’ll be able to go in and resolve.

Step 5: Once you resolve any errors and are satisfied with how each post looks and its scheduled date/time, you will ‘Import Post(s).’  

Bulk Delete Posts from the Planner and Public API

The bulk delete feature allows users to easily remove multiple posts from the planner at once, streamlining content management and reducing the effort required to correct scheduling errors or update content. This functionality is especially beneficial when managing large volumes of posts, enabling users to quickly clear unwanted posts for a more organized view. Additionally, users can perform the bulk delete operation through public APIs, enhancing flexibility and automation in managing posts across various platforms.

How to Use:

1. Navigate to the planner’s list view.
2. Select the posts you want to delete (all, some, or individually).
3. Click on the "Actions" button at the top of the table, then select "Delete selected posts."

1. Confirm the deletion.

Important Notes:

• The deletion only affects the planner; the posts remain on the social platforms.
• The public API supports a maximum of 50 posts in a single request.
• Posts in the "Published" status cannot be deleted through this feature.

FAQ

1. Can I schedule posts for multiple platforms using one CSV file?
Yes, you can schedule posts for multiple platforms within the same CSV file. Just ensure that the content follows the character limits and media requirements for each platform.

2. What happens if my CSV file has more than 90 posts?
The system only supports up to 90 posts per CSV file. If you have more than 90 posts, you’ll need to split them into multiple CSV files.

3. Can I schedule posts at different times for different platforms within one CSV file?
Yes, each row in the CSV can have its date and time, allowing you to schedule posts at different times for different platforms.

4. What should I do if my CSV file isn’t uploading correctly?
First, check that the date and time format is correct and that your columns are labeled accurately. Also, ensure that you are not using mixed media (images, GIFs, and videos) within the same post, as this is not supported.

5. Can I include hashtags and links within the content column?
Yes, you can include hashtags and links directly within the content column, and they will be published along with your post.

6. Are there specific image dimension requirements for each platform?
Yes, each platform has specific image size and dimension requirements. You’ll need to check with each platform to ensure your images meet their specifications.

7. Can I preview my posts before finalizing the bulk upload?
Yes, after the CSV is uploaded and processed, you’ll have the chance to review and edit each post before scheduling them.