📝 Social_media Prompt
Why E-commerce Freelance Social Media Managers Struggle With Inconsistent Posting — Gemini Fixes It
Beginner-level strategies for E-commerce professionals — solve inconsistent posting schedule by building a content calendar that reduces production time
The Prompt
You are a senior e-commerce social media strategist with 9 years of experience building content calendars, batch production systems, and posting schedules for freelance social media managers who are managing 3 to 8 e-commerce clients simultaneously and losing clients because inconsistent posting is eroding organic reach just when accounts are building momentum. Help me build a content calendar so I can reduce content production time and create a calendar system that one freelancer uses to maintain a consistent posting schedule across multiple e-commerce clients without spending every Sunday night catching up on the week's missed posts.
My situation:
- Number of e-commerce clients and platforms: [e.g., "managing 5 e-commerce clients — all on Instagram and Facebook, two also on TikTok — combined posting target is 35 posts per week across all clients"]
- Current inconsistency problem: [e.g., "posting gaps of 4 to 7 days occur for at least two clients every month — gaps happen during product launch weeks when campaign content takes longer to produce than planned"]
- Content production time per post: [e.g., "currently spending 45 to 90 minutes per post including caption writing, image sourcing, and scheduling — target is under 25 minutes per post"]
- Content types required across clients: [e.g., "product highlights, user-generated content shares, promotional posts, educational content about the product category, and behind-the-scenes content — ratio varies by client"]
- Client approval process: [e.g., "two clients approve every post before scheduling, three clients have given blanket approval for content within agreed guidelines — the two approval clients add 2 to 3 days of turnaround time per post"]
- Scheduling tool in use: [e.g., "Buffer — can schedule up to 60 days in advance, supports all platforms, but the freelancer is not using the bulk scheduling feature"]
- Target: [e.g., "want to complete the full month's content for all 5 clients in one 8-hour weekly session rather than producing content reactively throughout the week"]
Deliver:
1. A monthly content calendar template for one e-commerce client — a 30-day grid with post type, platform, caption angle, visual direction, and posting time for each of the 20 planned posts, structured so the freelancer fills in client-specific product details in under 10 minutes per post rather than starting from a blank page
2. A batch production system for an 8-hour weekly session — a timed workflow covering hour one for caption template selection and client-specific variable insertion, hours two through four for visual sourcing and basic editing, hours five and six for scheduling all approved content in Buffer, and hours seven and eight for drafting the content requiring client approval in the following week
3. A caption template library for five e-commerce content types — product highlight (hook plus three benefit lines plus CTA), UGC share (attribution plus specific detail about what makes this customer's content notable plus engagement question), promotional (urgency opener plus offer specifics plus deadline CTA), educational (surprising fact about the product category plus three supporting details plus internal link), and behind-the-scenes (human moment opener plus what it reveals about the brand plus community invitation)
4. A client approval streamlining brief — a batch approval email format that presents the following week's posts as a single document rather than individual approvals, covering the post preview format (image thumbnail, platform, posting date, and caption draft in one row per post), the one-click approval option for posts within guidelines, and the redline process for posts requiring changes
5. A visual content sourcing system — a weekly sourcing protocol covering the three free image sources and two paid sources appropriate for e-commerce content, the file naming convention that links each image to the correct post in the calendar, and the five visual format templates (square product shot, lifestyle image, text overlay, UGC repost, and carousel cover) that work across Instagram, Facebook, and TikTok without resizing
6. A posting gap prevention protocol — a Monday morning 15-minute review that identifies any posts scheduled to go live in the next 7 days that are missing a visual, caption, or approval, with the specific escalation step for each gap type and the fallback post type (repurposed UGC or brand asset) that can be scheduled in under 10 minutes when a gap is identified with less than 24 hours notice
7. A client onboarding calendar brief — a one-page document the freelancer sends to each new client during onboarding that establishes the content ratio, the posting frequency, the approval turnaround required, and the batch content delivery schedule, creating the client expectations that make the 8-hour weekly session possible for all 5 accounts simultaneously
8. A 30-day production efficiency tracker — a Google Sheets template tracking actual time per post per client per week, identifying the post types taking longer than 25 minutes, the client whose approval process is creating the most calendar disruption, and the production step (caption writing, image sourcing, or scheduling) consuming the most time relative to the target
**Write every calendar template and batch production system component assuming the freelancer is working alone without a virtual assistant or design support — every system must be executable with Buffer, Canva, and a Google Sheet, and every caption template must produce a usable draft that requires only client-specific variable insertion rather than original writing for every post.**
💡 How to use this prompt
- Build the caption template library from output item 3 before setting up the monthly calendar template. A calendar with 20 post slots but no caption templates still requires 45 to 90 minutes per post because the caption is written from scratch for each entry. The template library is what makes the 10-minute-per-post target achievable — and it only needs to be built once to serve all 5 clients with minor variable adjustments.
- The most common mistake is building separate content calendars for each of the 5 clients using different formats and different tools. Freelancers who manage each client's calendar in a separate document spend 20 to 30 minutes per week switching between formats and lose the batch production efficiency that comes from treating all 5 clients as a single production queue. One master calendar template that works for all 5 clients with client-specific variable columns is the structure that makes the 8-hour weekly session possible.
- Gemini's real-time web access gives it an edge when you need current Buffer feature updates, recent e-commerce social media benchmark data, or platform posting frequency recommendations before building your content calendar system. For final calendar template structure and caption library language, paste Gemini's research into Claude for cleaner professional output.
Best Tools for This Prompt
🤖 Best AI Tools for This Prompt
Tested & reviewed — run this prompt with the best AI tools
Related Topics
About This Social_media AI Prompt
This free Social_media prompt is designed for Gemini and works with any modern AI assistant including ChatGPT, Claude, Gemini, and more. Simply copy the prompt above, paste it into your preferred AI tool, and customize the bracketed sections to fit your specific needs.
Social_media prompts like this one help you get better, more consistent results from AI tools. Instead of starting from scratch every time, you can use this tested prompt as a foundation and adapt it to your workflow. Browse more Social_media prompts →