video1.0<iframe src="https://www.loom.com/embed/6b214b70ec0a4c009fe4a9108c134e74" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/6b214b70ec0a4c009fe4a9108c134e74-00001.gif620.8666666666667Use ChatGPT to Create a Social Media Content CalendarThe three prompts I used in the examples are:
Prompt 1:
User
Please create a spreadsheet that is a social media content calendar. The dates for the calendar should range between October 1 and October 30. The calendar will comprise of five total posts, which will be shown in rows. The columns should be: date and day of the week, post text, hashtags. Please suggest hashtags for each post.
Please place posts that include a day of the week in in the text in the appropriate day of the week. Please put all posts including TBT on Thursdays. News alerts should be on Mondays or Wednesdays.
The post text is below for the five posts. Only show rows for dates in the calendar where posts are being made. Each post text should only be used once.
Post Text 1: "Spotlight Sunday π Meet Emily, a Super Senior in our program who turned her passion for social media into a thriving career! From leading impactful campaigns to interning with a renowned PR agency, Emily is a true inspiration. Swipe left to discover her journey, tips for success, and the exciting projects she's currently working on. #SuperSeniorSpotlight #ShepherdSuccess"
Post Text 2: βTBT - Journey Through the Decades π°οΈπ Explore the evolution of our Communication and New Media Program over the last 10 years! From vintage radio stations to cutting-edge social media labs, swipe through the images to see how far we've come. Plus, catch up with some of our alumni in 'Where Are They Now' stories. #TBT #DecadeofSuccess"
Post Text 3: "π£ Exciting News Alert! π We're thrilled to announce an exclusive panel discussion featuring industry leaders in PR, social media, TV, radio, and advertising. Save the date for an insightful evening of networking and career advice. Stay tuned for updates on panelists and how to reserve your spot! #IndustryInsights #NetworkingEvent"
Post Text 4: "Internship Alert! π Are you ready to dive into the world of media? We've got exciting internship opportunities lined up with top-notch companies! Swipe to see the roles available, and tag a friend who's perfect for the job. Don't miss out on this chance to kickstart your career! π #InternshipOpportunity #CareerLaunchpad"
Post Text 5: "Flashback Friday! π Revisit the iconic moments that shaped our program over the years. Swipe to witness the laughter, the hard work, and the camaraderie that defines us. πΈ Share your favorite memories from your time here in the comments below! Let's celebrate the legacy of our incredible Communication and New Media family. #FlashbackFriday #LegacyMoments"
Prompt 2:
Please create a spreadsheet that is a social media content calendar. The dates for the calendar should range between October 1 and October 30. The calendar will include five columns. There will be five total posts, which will be shown in rows.
The columns will be:
1. Date
2. Social media text
3. Suggested image or photo
4. Campaign objective
5. Key messages
6. Content categories
I will provide you the campaign objectives, key messages, and content categories below.
Your job is to generate social media text. For each social media text that you generate, it needs to aligns with 1 of the campaign objectives, 1 or more of the key messages, and 1 or more of the content categories.
Select 1 campaign objective from the list below that best fits each item in column 1. If a campaign objective does not fit the post text from column 1, leave this column blank.
Campaign Objective 1: Gain 5 new applicants to the university
Campaign Objective 2: Increase comments on our Instagram account by 25%
Column 3 consists of my categories. Select a category from the list below that best fits each item in column 1. If a category does not fit the post text, leave this column blank.
Category 1: Word To The Wise
Category 2: Motivation
Category 3: News and Insights
Column 4 consists of key messages. Select at least 1 key message from the list below that best fits each item in column 1. If a key message does not fit the post text, leave this column blank.
Key Message 1: We are Shepherd Universityβs Best Kept Secret
Key Message 2: The Communication Program offers a dynamic learning environment
Key Message 3: Create Your Future, Enroll Now
Prompt 3:
Please create a spreadsheet that is a social media content calendar. The dates for the calendar should range between October 1 and October 30. The calendar will include five columns. There will be five total posts, which will be shown in rows.
Column 1 is the post text. Below is the text for each post, numbered 1 through 5.
Post Text 1: "Spotlight Sunday π Meet Emily, a Super Senior in our program who turned her passion for social media into a thriving career! From leading impactful campaigns to interning with a renowned PR agency, Emily is a true inspiration. Swipe left to discover her journey, tips for success, and the exciting projects she's currently working on. #SuperSeniorSpotlight #ShepherdSuccess"
Post Text 2: βTBT - Journey Through the Decades π°οΈπ Explore the evolution of our Communication and New Media Program over the last 10 years! From vintage radio stations to cutting-edge social media labs, swipe through the images to see how far we've come. Plus, catch up with some of our alumni in 'Where Are They Now' stories. #TBT #DecadeofSuccess"
Post Text 3: "π£ Exciting News Alert! π We're thrilled to announce an exclusive panel discussion featuring industry leaders in PR, social media, TV, radio, and advertising. Save the date for an insightful evening of networking and career advice. Stay tuned for updates on panelists and how to reserve your spot! #IndustryInsights #NetworkingEvent"
Post Text 4: "Internship Alert! π Are you ready to dive into the world of media? We've got exciting internship opportunities lined up with top-notch companies! Swipe to see the roles available, and tag a friend who's perfect for the job. Don't miss out on this chance to kickstart your career! π #InternshipOpportunity #CareerLaunchpad"
Post Text 5: "Flashback Friday! π Revisit the iconic moments that shaped our program over the years. Swipe to witness the laughter, the hard work, and the camaraderie that defines us. πΈ Share your favorite memories from your time here in the comments below! Let's celebrate the legacy of our incredible Communication and New Media family. #FlashbackFriday #LegacyMoments"
Column 2 consists of campaign objectives. Select 1 campaign objective from the list below that best fits each item in column 1. If a campaign objective does not fit the post text from column 1, leave this column blank.
Campaign Objective 1: Gain 5 new applicants to the university
Campaign Objective 2: Increase comments on our Instagram account by 25%
Column 3 consists of my categories. Select a category from the list below that best fits each item in column 1. If a category does not fit the post text, leave this column blank.
Category 1: Word To The Wise
Category 2: Motivation
Category 3: News and Insights
Column 4 consists of key messages. Select at least 1 key message from the list below that best fits each item in column 1. If a key message does not fit the post text, leave this column blank.
Key Message 1: We are Shepherd Universityβs Best Kept Secret
Key Message 2: The Communication Program offers a dynamic learning environment
Key Message 3: Create Your Future, Enroll Now
Column 5 is the image name. For each post above, generate an image name in the following format: [imagename].jpg