Bulk Scheduling in the Social Planner allows you to prepare, organize, and set up posts for your social media channels beforehand. 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 create 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, among others.)
- 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 a space between the date and time; this is crucial. You must 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. 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 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.
- images
Image URLs will go here as png, jpeg/jpg, and other supported formats. You can add up to 10 images per post, separating each by a comma and a space.
NOTE: You must check with the social platform for proper image dimensions and sizing specifications.
- girl
Paste GIF URLs for your posts
- videos
Add video URLs for each post in the accepted formats (MP4 and MOV). 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 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 small time cushion if 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 can 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).’
You can view the whole schedule under ‘Open Planner’ and admire the work you did in advance to build your social presence.
