We designed a complete social media strategy and content calendar system for TerraBlu Hotels & Resorts — building a 12-month strategic roadmap across 5 platforms for 4 properties, creating a content engine that produces 340+ coordinated posts monthly, increasing direct bookings from social by 312%, and transforming an inconsistent, reactive social presence into a systematically planned, brand-unified storytelling machine.
| Client Name | TerraBlu Hotels & Resorts (Showcase Project) |
| Industry | Hospitality / Boutique Hotels & Wellness Resorts |
| Project Duration | 6 Weeks |
| Services Delivered | Social Media Audit & Competitive Analysis, Brand Voice & Personality Framework, Audience Persona Development, Platform Strategy & Channel Architecture, Content Pillar Framework & Theme System, Annual Campaign Calendar & Seasonal Planning, Monthly/Weekly Content Calendar System, Content Ideation Engine & Prompt Library, Cross-Property Content Coordination, KPI Framework & Goal-Setting System, Governance Model & Approval Workflows, Strategy Documentation & Team Training |
| Tools & Platforms Used | Notion (strategy hub & content calendar), Airtable (content database & editorial pipeline), Google Sheets (KPI tracking & reporting), Later (scheduling & visual planning), Canva Pro (content templates), ChatGPT API (OpenAI) (content ideation), Google Analytics 4, Meta Business Suite (Instagram/Facebook insights), TikTok Analytics, YouTube Studio, Pinterest Analytics, Brandwatch (social listening), SparkToro (audience research), Semrush (competitor social tracking), Slack (team communication), Loom (training videos), Google Drive |
| Project Year | 2025 |
TerraBlu Hotels & Resorts is a boutique hospitality group operating 4 distinctive properties across South India — a beachfront wellness resort in Varkala (Kerala), a heritage haveli in Hampi (Karnataka), a hill station retreat in Kodaikanal (Tamil Nadu), and a contemporary urban boutique hotel in Pondicherry. Each property has a unique personality, target audience, and experience offering — from Ayurvedic spa treatments and yoga retreats in Varkala to archaeological tours and sunset dinners in Hampi, misty nature walks and colonial-era charm in Kodaikanal, and French-quarter culture and seaside cafés in Pondicherry.
TerraBlu had built a cult following among discerning travelers — a 4.7-star average across 2,400+ Google Reviews, consistent TripAdvisor “Travellers’ Choice” badges, and an occupancy rate that outperformed most indie hotel groups. Their guests loved them. Their Instagram told a completely different story.
Four properties, four separate Instagram accounts, four different brand identities — or rather, four different levels of chaos. Varkala’s account posted sunrise beach photos with motivational quotes in Comic Sans. Hampi’s account went silent for weeks, then posted 12 photos in one day. Kodaikanal’s account was a personal photo dump by the property manager with inconsistent filters. Pondicherry’s account was the “best” — but even that was reactive, posting only when someone remembered to.
There was no unified brand voice, no content strategy, no content pillars, no editorial calendar, no seasonal campaign plan, no platform-specific approach, no audience personas, no competitor benchmarking, no KPI framework, and no governance model. “Social media strategy” meant “post something nice when you feel like it.” In a hospitality industry where 74% of travelers use social media to choose their next destination (Stackla) and 40% of travelers under 30 consider “Instagrammability” a top factor in booking decisions (Schofields), this was a critical business vulnerability.
We designed and implemented a complete social media strategy and content calendar system — from brand-level strategic framework and audience personas to platform architecture, content pillar systems, 12-month campaign calendars, weekly content planning workflows, cross-property coordination, and team training — giving TerraBlu a unified, strategic, systematically planned social media presence that drives discovery, inspires wanderlust, and converts followers into guests.
| Property | Instagram Handle | Followers | Posting Frequency | Content Quality | Brand Consistency |
|---|---|---|---|---|---|
| Varkala (Wellness Resort) | @terrablu.varkala | 8,200 | 2-5 random posts/week | Medium — decent photos, terrible typography, motivational quote spam | None — looks like a wellness influencer’s personal page, not a hotel |
| Hampi (Heritage Haveli) | @terrablu.hampi | 3,400 | 0-12 posts/week (feast or famine) | Low — blurry phone photos, no editing, no composition awareness | None — looks like a tourist’s vacation album |
| Kodaikanal (Hill Station Retreat) | @terrablukoday | 5,100 | 1-3 posts/week | Low-Medium — property manager’s personal style, overfiltered landscapes | None — handle doesn’t even match brand naming convention |
| Pondicherry (Urban Boutique) | @terrablupdy | 11,800 | 3-4 posts/week | Medium-High — best of the four, but still reactive and unplanned | Partial — closest to brand feel but no documented guidelines |
| Brand Account | None existed | 0 | N/A | N/A | No parent brand presence at all |
| What They Were Posting | What They Should Have Been Posting |
|---|---|
| Random sunset/landscape photos with generic captions | Strategically timed travel inspiration content aligned with booking windows |
| Motivational quotes with no brand connection | Guest stories, experience narratives, behind-the-scenes moments |
| Room photos with “Book now!” captions (selling, not storytelling) | Destination guides, “48 hours in Varkala” itineraries, seasonal experience showcases |
| Festival greetings (Diwali/Christmas graphics) with no relevance to hospitality | Festive escape campaigns — “Celebrate Diwali by the beach” with themed packages |
| Nothing during low season (when marketing is most critical) | Low-season exclusive offers, monsoon retreat campaigns, “best-kept-secret” positioning |
| Staff selfies with no context or storytelling | Chef profiles, artisan partnerships, “Meet the person who makes your experience special” |
| Opportunity Missed | Impact |
|---|---|
| Summer vacation season (April-June) | No family vacation campaign while competitors ran massive “Summer Escape” promotions — lost to Airbnbs and OTAs |
| Monsoon season (July-Sept) | Properties went nearly silent during monsoon — despite Kerala monsoon retreats being a trending wellness segment. Missed the entire “monsoon is romantic/rejuvenating” narrative |
| Festive season (Oct-Dec) | Generic “Happy Diwali” graphics instead of Diwali staycation packages, Christmas retreat bookings, New Year’s Eve events — peak booking period underexploited |
| Wedding season (Nov-Feb) | Zero destination wedding content despite Hampi and Pondicherry being top wedding destinations. No wedding showcase, no venue tours, no testimonials |
| Long weekends / public holidays | No countdown campaigns, no last-minute availability posts, no FOMO content before 3-day weekends — when impulse travel bookings spike |
| Valentine’s Day / Anniversary | No couples retreat campaigns, no romantic experience showcases, no special packages promoted |
| Question | Answer Before Our Engagement |
|---|---|
| Who is our target audience? | “Travelers” (that was literally the answer) |
| What platforms do they use most? | “Instagram, I think” |
| What content do they engage with? | “Nice photos?” |
| When do they plan and book trips? | “I don’t know” |
| What drives their booking decision from social? | “I don’t know” |
| What do competitors do that we don’t? | “I don’t know” |
| What’s our brand personality on social? | “We don’t have one” |
| Competitor | Strategy Level | What They Did Right | TerraBlu Gap |
|---|---|---|---|
| Evolve Back (CGH Earth) | Advanced | Unified brand voice across properties, nature/conservation storytelling, seasonal campaigns, strong Reels presence, destination guides | TerraBlu: No unified voice, no storytelling, no campaigns |
| SaffronStays | Advanced | Exceptional UGC curation, community building (“SaffronTribe”), experiential content pillars, influencer partnerships, strategic seasonal content | TerraBlu: No UGC strategy, no community, no content pillars |
| Tamara Resorts | Intermediate-Advanced | Professional photography, consistent aesthetic, experience-led content (spa, dining, nature), Pinterest strategy, YouTube property tours | TerraBlu: Amateur photography, inconsistent aesthetic, no Pinterest/YouTube |
| Zostel | Advanced (Budget Segment) | Creator partnerships, user-generated storytelling, “backpacker culture” brand personality, TikTok-native content, community events | TerraBlu: No partnerships, no personality, no TikTok |
| Audit Area | What We Analyzed | Methodology |
|---|---|---|
| Content Audit | Last 12 months of posts across all 4 accounts: content type, topic, quality score (1-10), engagement, posting time, hashtags, captions | Manual review + export to Airtable (580+ posts cataloged) |
| Audience Audit | Current follower demographics, geographic distribution, age/gender breakdown, active hours, follower growth patterns | Meta Business Suite insights + SparkToro audience research |
| Performance Audit | Engagement rates, reach trends, impressions, saves, shares, profile visits, website clicks, top/bottom performing content | Platform analytics + manual analysis |
| Competitor Audit | 6 competitor accounts analyzed: content strategy, posting frequency, engagement rates, content pillars, best-performing content, ad activity | Semrush Social Tracker + manual competitive analysis |
| Platform Audit | Presence (or absence) on each platform, profile completeness, bio optimization, link-in-bio usage, highlight organization, hashtag strategy | Manual review |
| Brand Consistency Audit | Visual identity consistency, voice/tone consistency, messaging alignment, cross-property brand coherence | Brand checklist scoring |
| Finding | Data Point | Strategic Implication |
|---|---|---|
| Best-performing content (all properties): Guest experience stories and behind-the-scenes | 3.8x higher engagement than product/room photos | Content strategy should prioritize people and experiences over property showcasing |
| Worst-performing content: “Book now” promotional posts and generic festival greetings | 72% below average engagement | Direct selling on social doesn’t work — inspiration and storytelling do |
| Best posting times: Thurs–Sun, 7-9 PM and 8-10 AM | 2.4x engagement at these times vs. random posting | Align content calendar to discovery and planning windows |
| Audience reality: 68% female, 24-38 age, top cities: Bangalore (22%), Mumbai (18%), Delhi (14%), Hyderabad (11%), Chennai (9%) | Metro professionals are the core audience — not “travelers” generically | Target content to urban professionals seeking escapes |
| Untapped platforms: Pinterest (0 presence), YouTube (0 presence), TikTok (0 presence) — together representing 60%+ of travel inspiration discovery | Massive discovery opportunity abandoned | Multi-platform strategy essential for hospitality |
| Competitor content advantage: Top competitors post 2.5x more frequently with 4x more video content | Volume + video = visibility in hospitality | Increase posting frequency, prioritize video/Reels |
| Seasonal gap: Zero content during monsoon season (July-Sept) despite monsoon wellness retreats being a trending category | Missing 25% of the year for content and campaigns | Monsoon = opportunity, not off-season |
| Highest save rate: Destination guides, “things to do” lists, itinerary suggestions | Saves = future booking intent | Create more “saveable” planning content |
| Persona | Name | Demographics | Travel Style | Content Preferences | Booking Behavior | Primary Platform |
|---|---|---|---|---|---|---|
| Persona 1 | “Weekend Escape Rhea” | 26-34, female, metro professional, ₹12-25 LPA, couple or friend group | Weekend getaways (2-3 nights), values aesthetics + experiences, Instagram-driven discovery | Stunning visuals, “48 hours in…” guides, experience Reels, before-I-go checklists, FOMO content | Plans 1-2 weeks in advance, influenced by Instagram Saves and Stories, compares 3-4 options, books direct if easy | Instagram (primary), Pinterest (planning) |
| Persona 2 | “Wellness Seeker Ananya” | 30-45, female, health-conscious, ₹18-35 LPA, solo or with partner | Wellness retreats (3-7 nights), yoga, Ayurveda, digital detox, mindful travel | Wellness tips, yoga/meditation content, Ayurvedic insights, transformation stories, serene visuals, wellness influencer recommendations | Plans 2-4 weeks in advance, researches deeply, reads reviews, values authenticity and certifications | Instagram, YouTube (research), Pinterest (wellness boards) |
| Persona 3 | “Culture Explorer Vikram” | 28-42, male/female, culturally curious, ₹15-30 LPA, couple or family | Heritage/cultural experiences (3-5 nights), historical sites, local cuisine, authentic immersion | Destination stories, historical context, local food features, artisan spotlights, “hidden gems” guides, photography-worthy spots | Plans 3-6 weeks in advance, reads long-form content, watches YouTube videos of destination, influenced by detailed photography | YouTube (destination research), Instagram, Pinterest |
| Persona 4 | “Celebration Planner Meera” | 30-45, female, planning a wedding/anniversary/milestone | Destination celebrations (2-7 nights), venue scouting, group accommodation, experience curation | Venue tours, wedding/event showcases, real celebration stories, décor inspiration, package comparisons, FAQ content | Plans 2-6 months in advance, highly research-intensive, involves multiple decision-makers, books via direct conversation | Pinterest (venue boards), Instagram, YouTube (virtual tours) |
COMPETITIVE POSITIONING — SOCIAL MEDIA STRATEGY
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
EXPERIENTIAL STORYTELLING
▲
│
SaffronStays ● │ ● Evolve Back
(Community) │ (Conservation)
│
BUDGET ◄──────────────────┼──────────────────► PREMIUM
│
Zostel ● │ ● Tamara
(Backpacker) │ (Luxury)
│
│
★ TERRABLU TARGET POSITION ★
(Artisan Luxury + Cultural Depth
+ Multi-Destination Storytelling)
│
▼
PRODUCT SHOWCASE
TerraBlu's STRATEGIC POSITION:
→ Premium-accessible (not ultra-luxury, not budget)
→ Experience-led (not room-led)
→ Culturally rich (each property = a story of its region)
→ Multi-destination storytelling (4 unique worlds under one brand)
→ Artisanal authenticity (handcrafted experiences, local partnerships)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Element | Definition | Application |
|---|---|---|
| Brand Personality | The Thoughtful Explorer — warm, curious, cultured, unhurried, deeply connected to place and people | Think: a well-traveled friend who knows the best-kept secrets, tells compelling stories, and never rushes you |
| Voice Characteristics | Warm (not corporate), Evocative (paints a picture), Knowledgeable (without being academic), Inviting (without being salesy), Grounded (real, not fabricated luxury) | Every caption should feel like a letter from a place, not an ad for a product |
| Tone Spectrum | Ranges from: Serene & reflective (Varkala wellness content) → Adventurous & awe-inspired (Hampi heritage content) → Cozy & whimsical (Kodaikanal retreat content) → Vibrant & cultural (Pondicherry urban content) | Tone adapts to property personality while maintaining consistent brand voice |
| Language Style | Sensory language (sounds, textures, scents, tastes), present tense for immersive effect, second person (“you”) to place the reader in the experience, short paragraphs, conversational flow | “The morning mist wraps around the eucalyptus trees as you step onto the verandah. Your coffee is already waiting.” — NOT: “Experience our scenic mountain views. Book now!” |
| Vocabulary Guide | ✅ Use: Discover, Wander, Savor, Craft, Restore, Unfold, Nestled, Curated, Artisan, Escape, Heritage, Retreat, Sunrise ritual, Hidden gem, Slow morning ❌ Avoid: Luxury (overused), World-class (meaningless), Best-in-class (corporate), Book now! (aggressive), Don’t miss out! (fear-based), Amenities (clinical) | Word choice builds brand perception — every word is a design decision |
| Emoji Framework | Property-specific emoji sets: Varkala 🌊🧘♀️🌿 | Hampi 🏛️🌅🪨 |
| Hashtag Voice | Branded: #TerraBluMoments, #WanderWithTerraBlu, #TerraBluStories | Property: #TerraBluVarkala, #TerraBluHampi, #TerraBluKodai, #TerraBluPondy |
| Property | Personality Archetype | Tone | Visual Mood | Content Themes |
|---|---|---|---|---|
| Varkala (Wellness Resort) | The Healer — gentle, restorative, wise, nurturing | Serene, meditative, softly inspiring | Warm golds, ocean blues, soft whites, golden hour glow, flowing fabrics, water textures | Wellness rituals, Ayurvedic wisdom, yoga/meditation moments, ocean healing, detox journeys, therapist spotlights, mindful food |
| Hampi (Heritage Haveli) | The Storyteller — knowledgeable, awe-struck, reverent, adventurous | Wonder-filled, culturally rich, discovery-driven | Warm sandstone oranges, sunset reds, ancient textures, dramatic skies, silhouettes against monuments | Historical narratives, archaeological wonders, sunset experiences, local artisan stories, heritage preservation, guided exploration, regional cuisine |
| Kodaikanal (Hill Station Retreat) | The Dreamer — whimsical, cozy, nostalgic, romantic | Warm, intimate, fairy-tale like, contemplative | Misty greens, warm candlelight, foggy mornings, rain-drenched windows, colonial architecture, wildflower meadows | Slow mornings, misty walks, fireplace evenings, colonial history, mountain cuisine, stargazing, monsoon magic, reading corners |
| Pondicherry (Urban Boutique) | The Curator — stylish, culturally fluent, vibrant, cosmopolitan | Lively, culturally rich, visually bold, artistic | French pastels (yellow, pink, blue), bougainvillea, vintage architecture, café culture, bicycle rides, street art | French Quarter walks, café culture, local art & design, Franco-Tamil cuisine, bicycle tours, boutique shopping, sunset promenade, cultural festivals |
| Pillar | Purpose | Content Types | % of Mix | Applies To |
|---|---|---|---|---|
| 🌍 Destination Stories | Inspire discovery, position properties within destinations, drive saves for future trips | “48 hours in [destination]” guides, hidden gem spotlights, seasonal destination features, local food trails, cultural deep-dives, photo walks, “things to do” lists | 25% | All 4 properties |
| ✨ Experience & Moments | Showcase what guests feel (not just what they see), create emotional desire | Guest experience narratives, signature rituals (morning yoga, sunset cocktails, chef’s table), sensory moments (coffee on the verandah, rain on the terrace), activity spotlights | 25% | All 4 properties |
| 👥 People & Stories | Build emotional connection, humanize the brand, celebrate community | Chef profiles, therapist stories, housekeeper spotlights, guest stories (with permission), local artisan partnerships, founder’s journey, team celebrations | 15% | All 4 properties |
| 🎓 Travel Knowledge | Provide value, drive saves/shares, position as travel authority | Packing guides, travel tips, cultural etiquette, Ayurvedic wellness tips, coffee/food education, photography tips for each destination, “what to wear” guides | 15% | Brand account + Property accounts |
| 🎉 Campaigns & Experiences | Drive bookings, promote packages, announce events and seasonal offerings | Seasonal packages, festive retreats, wedding showcases, workshop announcements, limited-time offers, new experience launches, early-bird specials | 15% | All 4 properties + Brand |
| 🤝 Community & UGC | Social proof, build community, encourage user participation | Guest photo reshares, tagged content features, review highlights, “TerraBlu Moments” curation, guest Q&A, poll-driven content, milestone celebrations | 5% | All 4 properties + Brand |
| Platform | Role | Content Focus | Target Persona | Posting Frequency | Account Structure |
|---|---|---|---|---|---|
| Primary brand + discovery + engagement | All 6 content pillars — visual storytelling, Reels, Stories, carousels, guides | All 4 personas | Feed: 5-6/week per property, 4-5/week brand. Stories: 5-8/day per property | @terrablu (brand), @terrablu.varkala, @terrablu.hampi, @terrablu.kodai, @terrablu.pondy — 5 accounts total | |
| Trip planning + inspiration + SEO-driven discovery | Destination guides, room/property boards, wedding venue pins, seasonal travel boards, wellness tip infographics | Persona 1 (Weekend Escape), Persona 4 (Celebration Planner) | 10-15 pins/week (brand account) | @terrablu (single brand account, property-specific boards) | |
| YouTube | Long-form destination storytelling + virtual tours + trust-building | Property tours, “A Day At TerraBlu [Property]” vlogs, destination documentaries, chef/artisan stories, guest testimonials, wedding films | Persona 2 (Wellness), Persona 3 (Culture Explorer), Persona 4 (Celebrations) | 2-4 videos/month + 8-10 Shorts/month | TerraBlu Hotels & Resorts (single channel, property playlists) |
| TikTok | Trend-driven discovery + younger audience reach + virality | Trending audio adaptations, satisfying hospitality content (room reveals, food plating, sunset timelapses), “POV: You just arrived at…” content, staff personality content | Persona 1 (Weekend Escape — younger segment, 22-30) | 5-7 videos/week (brand account) | @terrablu (single account, property-tagged content) |
| Community engagement + event promotion + older demographic reach + groups | Event announcements, longer narrative posts, community engagement, customer service, Facebook Events for workshops/retreats | Persona 2 (Wellness — 35-45 segment), Persona 3 (Culture Explorer) | 3-4 posts/week (brand page) + property-specific events | TerraBlu Hotels & Resorts (single page, property-tagged posts) |
| Change | Before | After | Reason |
|---|---|---|---|
| Brand account creation | No parent brand presence | @terrablu — master brand account showcasing all 4 properties, cross-promoting, running campaigns | Unified brand discovery, central storytelling, campaign hub |
| Handle standardization | @terrablu.varkala, @terrablu.hampi, @terrablukoday (inconsistent), @terrablupdy (abbreviated) | @terrablu.varkala, @terrablu.hampi, @terrablu.kodai, @terrablu.pondy | Consistent naming convention — professional, memorable, searchable |
| Single Pinterest | None | @terrablu — single brand account with property boards | Pinterest works best as a centralized brand board — travelers browse multiple destinations |
| Single YouTube | None | TerraBlu Hotels & Resorts — with property-specific playlists | Centralizes subscribers, cross-pollinates between properties, builds channel authority |
| Single TikTok | None | @terrablu — brand account with property-tagged content | Consolidates follower growth, algorithm benefits from consistent posting to one account |
| Single Facebook | Each property had neglected pages | TerraBlu Hotels & Resorts — single page, property locations tagged | Consolidates community, simplifies management, combines audience data |
| Month | Campaign Theme | Lead Property (Hero) | Supporting Properties | Campaign Objective | Booking Window Target |
|---|---|---|---|---|---|
| January | “New Year, New Places” — Fresh start travel inspiration | All 4 (equal) | — | Drive Q1 bookings during resolution/planning energy | Jan–March stays |
| February | “Love Escapes” — Valentine’s Day + romantic getaways | Pondy (romance) + Kodai (cozy) | Varkala (couples wellness), Hampi (sunset romance) | Drive couples bookings, anniversary packages | Feb–March stays |
| March | “Holi of Colors” — Spring festival + long weekend escape | Hampi (cultural) + Pondy (vibrant) | All properties — festival-themed content | Capture Holi long-weekend impulse bookings | March stays (immediate) |
| April | “Summer Escape” — Beat the heat, family vacations launch | Kodai (hill station cool) + Varkala (beach breeze) | Pondy (coastal), Hampi (early morning culture) | Drive summer vacation bookings (peak family travel) | April–June stays |
| May | “Summer Continued” + “The Art of Doing Nothing” — slow summer | Varkala (wellness + beach) | Kodai (extended summer retreat) | Continue summer push + introduce “slow travel” narrative | May–June stays |
| June | “Monsoon is Coming” — Pre-monsoon anticipation + early bird | Varkala (monsoon wellness retreat preview) + Kodai (misty monsoon magic) | All properties — monsoon prep content | Build monsoon as a travel season, not an off-season | July–Sept stays |
| July | “Monsoon Retreat” — Embrace the rain | Varkala (Ayurvedic monsoon packages — traditionally peak Ayurveda season) + Kodai (fog, rain, fireplaces) | Hampi (dramatic monsoon skies), Pondy (rainy café culture) | Convert monsoon from dead season to unique selling proposition | July–Sept stays |
| August | “Independence Day Weekend” + “Monsoon Continued” | All 4 — long weekend push | — | Capture Independence Day + Raksha Bandhan long weekend bookings | August stays |
| September | “Festive Season Preview” — Early bird Dussehra/Diwali | All 4 — festive packages preview | — | Lock in festive season bookings before OTAs dominate | Oct–Nov stays |
| October | “Festive Escapes” — Dussehra + Diwali campaign | Hampi (Dussehra heritage significance) + Pondy (Diwali by the sea) | Varkala (Diwali detox retreat), Kodai (festive family escape) | Peak festive booking conversion, gift certificates for experiences | Oct–Nov stays |
| November | “Wedding Season” — Destination wedding showcase | Hampi (heritage wedding) + Pondy (French Quarter wedding) | Varkala (intimate beach ceremony), Kodai (mountain wedding) | Capture destination wedding inquiries for Nov–Feb | Nov–Feb bookings |
| December | “Year-End Magic” — Christmas + New Year’s Eve | All 4 — NYE events + Christmas retreats | — | Drive premium year-end bookings, NYE packages, corporate retreat inquiries | December stays + Jan bookings |
| Day | Theme | Content Type | Pillar | Purpose |
|---|---|---|---|---|
| Monday | “Monday Escape” — Start the week with wanderlust | Stunning destination visual (photo or Reel) — “Where will you escape this week?” | 🌍 Destination Stories | Set aspirational tone for the week, high-save potential |
| Tuesday | “Taste Tuesday” — Culinary spotlight | Chef’s special, regional cuisine feature, recipe snippet, food photography, kitchen BTS | ✨ Experience & Moments | Food drives engagement; showcase F&B as experience differentiator |
| Wednesday | “Wellness Wednesday” — Mind, body, spirit | Yoga tip, Ayurvedic insight, meditation moment, spa showcase, wellness routine, therapist Q&A | 🎓 Travel Knowledge + ✨ Experience | Position wellness as core brand DNA (especially Varkala) |
| Thursday | “Throwback Thursday” or “This Place Thursday” — Heritage & history | Historical story about the destination, heritage architecture, cultural deep-dive, local tradition | 🌍 Destination Stories + 👥 People & Stories | Build cultural authority, differentiate from generic hotels |
| Friday | “Friday Feature” — People spotlight | Staff profile, artisan partner, guest story, community member, founder note | 👥 People & Stories | Humanize brand, build emotional connection before weekend bookings |
| Saturday | “Saturday Stay” — Experience showcase + CTA | Room reveals, property walkthroughs, experience packages, “this could be your Saturday” immersive content | ✨ Experience & Moments + 🎉 Campaigns | Weekend = planning mode — showcase + soft booking CTA |
| Sunday | “Slow Sunday” — Atmospheric, mood-driven, minimal | Serene video (no text), aesthetic flatlay, contemplative caption, ASMR-style ambient content | ✨ Experience & Moments | Emotional resonance, brand personality — not selling, just being |
| Week | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |
|---|---|---|---|---|---|---|---|
| Week 1 | 🌧️ “Monsoon has arrived at TerraBlu” — rain arrival Reel (all properties) | 🍲 Monsoon comfort food special — Varkala’s Ayurvedic warm bowl | 🧘 “Why monsoon is the best season for Ayurveda” — educational carousel | 🏛️ “Hampi in the monsoon” — dramatic rain on ruins photography | 👨🍳 Chef spotlight: “The woman behind our monsoon menu” | 🛏️ “Your monsoon retreat awaits” — room reveal with rain sounds | ☔ Ambient video: Rain on Kodai verandah, coffee steaming, no text |
| Week 2 | 🌊 “There’s nothing quite like a rainy morning by the sea” — Varkala beach rain | 🫖 “Monsoon chai ritual” — TerraBlu’s signature masala chai recipe carousel | 💆 Ayurvedic monsoon skincare tips — 5-slide carousel | 🏛️ “The 600-year-old story behind this courtyard” — Hampi heritage | 👤 Guest story: “I came for 3 days and stayed for 10” — monsoon retreat testimonial | 📦 “Monsoon Wellness Package” — 5N/6D package reveal with pricing | 🌫️ Misty morning Kodai Reel — lo-fi music, slow pan, zero text |
| Week 3 | 🌺 “Pondicherry in the rain — every color pops brighter” — Pondy rain walk | 🥘 “Our chef’s secret monsoon thali” — food photography feature | 🧘♀️ “3 yoga poses for rainy mornings” — Reel with instructor | 📜 “Why ancient Ayurveda recommends monsoon for healing” — educational | 👥 “Meet our Ayurvedic physician — 30 years of healing” — therapist profile | 🌧️ “Last rooms available for August monsoon retreat” — urgency CTA | ☕ “Rainy Sundays are made for this” — Kodai fireplace reading corner |
| Week 4 | 🏛️ “When the monsoon meets the ruins” — cinematic Hampi Reel | 🍰 “Warm banana bread, fresh from the oven” — Kodai kitchen BTS | 💧 “Water is sacred” — monsoon gratitude + sustainability story | 🎭 “The monsoon festival you’ve never heard of” — local cultural event | 👩🌾 “The family that grows our tea” — local farmer partnership story | 🎉 “September preview” — teaser for next month’s festive season campaign | 🌅 Sunset-after-rain golden light — Varkala cliff, silent video |
CONTENT CALENDAR SYSTEM ARCHITECTURE
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
LAYER 1 — STRATEGIC LAYER (Notion)
┌─────────────────────────────────────────┐
│ 12-Month Campaign Calendar │
│ → Monthly campaign themes │
│ → Seasonal objectives & KPIs │
│ → Budget allocation per campaign │
│ → Lead property assignments │
│ Updated: Quarterly (reviewed monthly) │
└───────────────┬─────────────────────────┘
│
▼
LAYER 2 — EDITORIAL LAYER (Notion)
┌─────────────────────────────────────────┐
│ Monthly Content Plan │
│ → Content mapped to weekly themes │
│ → Content pillar balance check │
│ → Property rotation calendar │
│ → Special dates/events integrated │
│ → Caption direction & CTA assignment │
│ Updated: Monthly (1st of previous month)│
└───────────────┬─────────────────────────┘
│
▼
LAYER 3 — PRODUCTION LAYER (Airtable)
┌─────────────────────────────────────────┐
│ Weekly Content Pipeline │
│ → Each content piece as a record │
│ → Fields: Title, Platform, Format, │
│ Pillar, Property, Assigned To, │
│ Status (Idea→Draft→Review→Approved │
│ →Scheduled→Published), Due Date, │
│ Assets (photo/video links), │
│ Caption (draft), Hashtags, │
│ Publish Time, Performance Metrics │
│ Updated: Daily │
└───────────────┬─────────────────────────┘
│
▼
LAYER 4 — SCHEDULING LAYER (Later)
┌─────────────────────────────────────────┐
│ Visual Scheduling & Auto-Publish │
│ → Instagram Feed visual grid preview │
│ → Optimal time scheduling │
│ → Story scheduling │
│ → Multi-platform publishing │
│ → First comment (hashtags) automation │
│ Updated: Weekly (Thursdays) │
└─────────────────────────────────────────┘
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Field | Type | Purpose |
|---|---|---|
| Content ID | Auto-number | Unique identifier for every piece of content |
| Title/Concept | Single line text | Brief content concept: “Chef Rajan’s monsoon thali story — Varkala” |
| Property | Single select: Brand / Varkala / Hampi / Kodai / Pondy | Which property’s account this posts on |
| Platform | Multi-select: IG Feed / IG Story / IG Reel / TikTok / Pinterest / YouTube / YouTube Short / Facebook | Where this content will be published |
| Content Pillar | Single select: Destination / Experience / People / Knowledge / Campaign / Community | Content pillar alignment |
| Weekly Theme | Single select: Monday Escape / Taste Tuesday / Wellness Wednesday / etc. | Weekly theme slot |
| Format | Single select: Single Image / Carousel / Reel / Story / Video / Pin / Idea Pin / Short | Content format |
| Target Persona | Multi-select: Weekend Rhea / Wellness Ananya / Culture Vikram / Celebration Meera | Which persona(s) this content serves |
| Campaign | Linked record: → Campaigns table | If part of a specific campaign, linked here |
| Caption (Draft) | Long text | Draft caption text |
| Caption (Final) | Long text | Approved final caption |
| Hashtag Set | Long text | Complete hashtag set for this post |
| CTA | Single select: None / Soft (Save/Share) / Medium (Visit Link) / Strong (Book Now) | Call-to-action intensity |
| Assets | Attachment / URL | Photo/video files or links to Google Drive assets |
| Assigned To | Single select: [Team member name] | Who is producing this content |
| Status | Single select: 💡 Idea → ✍️ Draft → 👁️ Review → ✅ Approved → 📅 Scheduled → 📤 Published → 📊 Measured | Production pipeline status |
| Due Date | Date | Deadline for content to be ready for scheduling |
| Publish Date | Date + Time | Exact scheduled publish date/time |
| Publish Link | URL | Link to live published post |
| Engagement | Number fields: Likes / Comments / Saves / Shares / Views | Performance metrics (added post-publish) |
| Engagement Rate | Formula | Auto-calculated from engagement / reach |
| Performance Tag | Single select: 🏆 Top Performer / ✅ Good / 📊 Average / ⬇️ Below Average | Coded after performance review |
| Notes | Long text | Internal notes, learning, why it worked/didn’t |
| Ideation Method | Process | Output | Frequency |
|---|---|---|---|
| Monthly Ideation Sprint | 2-hour team session: Review past month performance → Identify winning content angles → Brainstorm concepts for next month → Map to pillars/themes → Assign | 80-100 content ideas captured in Airtable | Monthly |
| AI Prompt Library | 120 pre-built ChatGPT prompts organized by pillar, property, format, and campaign — team selects prompt, inputs specifics, gets draft caption/concept | Quick caption drafts, carousel outlines, video scripts, hashtag suggestions | On-demand |
| Trending Content Adaptation | Weekly monitoring of hospitality/travel trends on Instagram Reels, TikTok, and Pinterest → Adapt trending formats to TerraBlu brand | 3-5 trend-adapted content ideas/week | Weekly |
| Guest Insight Mining | Review latest Google Reviews, TripAdvisor reviews, and guest feedback forms → Extract what guests loved most → Turn into content | 5-8 content ideas from guest language/stories | Bi-weekly |
| Seasonal Content Bank | Pre-built content idea banks for each season/festival, stored in Notion — ready to activate each year | 200+ seasonal content ideas (evergreen, refreshed annually) | Annual build, monthly activation |
| Competitor Content Inspiration | Semrush Social Tracker + manual review of competitor posts with highest engagement → Analyze what works → Create TerraBlu’s version (never copy — be inspired, then elevate) | 3-5 competitor-inspired ideas/month | Monthly |
| Pillar | Prompt Category | Sample Prompt |
|---|---|---|
| 🌍 Destination | Caption — Destination Guide | “Write an Instagram caption for a carousel titled ’48 Hours in Hampi — A First-Timer’s Guide.’ Tone: The Thoughtful Explorer — warm, curious, wonder-filled. Include 8 must-do experiences. End with a save CTA. Max 200 words.” |
| ✨ Experience | Caption — Sensory Moment | “Write a sensory-rich Instagram caption describing the experience of waking up at TerraBlu Kodai — the misty morning, eucalyptus scent, warm blanket, coffee on the verandah. Tone: The Dreamer — whimsical, cozy. Use present tense, second person (‘you’). Max 150 words.” |
| 👥 People | Story Script — Staff Spotlight | “Write a 5-slide Instagram Story script spotlighting Chef Lakshmi, head chef at TerraBlu Varkala for 12 years. Include: her background, her philosophy on Ayurvedic cooking, her signature dish, a fun personal fact, and a ‘come taste her cooking’ CTA. Tone: warm, respectful, celebratory.” |
| 🎓 Knowledge | Carousel Outline — Travel Tips | “Create a 10-slide Instagram carousel outline for ‘The Ultimate Monsoon Packing List for Kerala.’ Each slide: headline + 2-3 bullet points. Include practical advice with TerraBlu brand personality — warm, knowledgeable, slightly playful.” |
| 🎉 Campaign | Ad Copy — Seasonal Package | “Write 3 Instagram ad copy variations for TerraBlu’s ‘Monsoon Wellness Retreat’ package at Varkala. Package: 5N/6D Ayurvedic retreat, ₹42,000/person, includes daily yoga, 3 Ayurvedic treatments, full-board meals. Tone: serene but compelling. Variation 1: Emotional/aspirational, Variation 2: Practical/value-focused, Variation 3: Urgency/limited availability.” |
| 🤝 Community | UGC Feature | “Write a caption for resharing a guest’s photo at TerraBlu Hampi. Guest name: Priya. She posted a sunset photo from the rooftop with caption ‘This changed me.’ Acknowledge her experience warmly, invite others to share their moments, include #TerraBluMoments hashtag.” |
WEEKLY CONTENT PRODUCTION CYCLE
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
FRIDAY (Previous Week) — PLANNING:
→ Content Manager reviews monthly calendar
→ Selects next week's content from planned ideas
→ Assigns each piece to team member/property
→ Status in Airtable: 💡 Idea → ✍️ Draft (assigned)
→ Sends creative brief via Slack to property teams
MONDAY — PRODUCTION START:
→ Property teams shoot required photos/videos
→ Designer begins graphic/template work in Canva
→ Caption writers draft captions (AI-assisted → human polished)
→ Status: ✍️ Draft (in progress)
TUESDAY — PRODUCTION CONTINUED:
→ Video editing (Reels/TikToks) in CapCut
→ Carousel design finalized
→ Captions finalized with hashtag sets
→ Assets uploaded to content record in Airtable
→ Status: ✍️ Draft → 👁️ Review
WEDNESDAY — REVIEW & APPROVAL:
→ Content Manager reviews all content:
✓ Brand voice alignment
✓ Visual quality check
✓ Caption proofread
✓ Hashtag relevance
✓ CTA appropriateness
✓ Pillar/theme alignment
→ Feedback sent for revisions (if needed)
→ Approved content: Status → ✅ Approved
THURSDAY — SCHEDULING:
→ All approved content loaded into Later
→ Instagram grid preview checked (aesthetic flow)
→ Optimal posting times set per platform
→ First-comment hashtags loaded
→ Stories scheduled with interactive elements
→ Pinterest pins scheduled
→ Status: ✅ Approved → 📅 Scheduled
FRIDAY–SUNDAY — LIVE MANAGEMENT:
→ Content publishes automatically
→ Community manager monitors comments/DMs
→ Real-time Story content (BTS, daily updates)
→ Weekend planning for next week begins (cycle restarts)
→ Post-publish: Status → 📤 Published
FOLLOWING TUESDAY — PERFORMANCE REVIEW:
→ 5-day performance data captured for last week's content
→ Engagement metrics entered in Airtable
→ Performance tags assigned (🏆 Top / ✅ Good / 📊 Average / ⬇️ Below)
→ Learnings noted
→ Status: 📤 Published → 📊 Measured
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Content Level | Description | Who Creates | Who Approves | Posting Account |
|---|---|---|---|---|
| Brand-Level Content | Multi-property campaigns, brand storytelling, educational content, seasonal campaigns, YouTube videos, Pinterest boards, TikTok trends | Central content team | Content Manager | @terrablu (brand account) |
| Property-Level Signature | Signature experience showcases, destination guides, staff spotlights, property-specific campaigns | Property team + Central guidance | Content Manager | @terrablu.[property] |
| Property-Level Daily | Daily Stories, real-time moments, weather updates, today’s menu, guest interactions | Trained property team using templates | Self-managed (with guidelines) — spot-checked weekly | @terrablu.[property] (Stories only) |
| Cross-Property Features | “4 Ways to Spend a Long Weekend” featuring all properties, comparison content, “Which TerraBlu Are You?” quiz | Central content team | Content Manager | @terrablu (brand) + reshared by properties |
| UGC & Community | Guest content reshares, tagged content features, review highlights | Community Manager (central) | Content Manager | Property-specific or brand (depending on content) |
| Content Piece Created | Posts On | Reshares To | Cross-Promotes On | Adapted For |
|---|---|---|---|---|
| Brand campaign launch (e.g., “Monsoon Retreat”) | @terrablu (brand) | All 4 property accounts (Stories) | YouTube (campaign film), Pinterest (campaign board), TikTok (trend adaptation) | Property-specific versions with local details |
| Property-specific Reel (e.g., Hampi sunset dining) | @terrablu.hampi | @terrablu brand (Story + mention) | TikTok (native upload), YouTube Short, Pinterest (video pin) | — |
| Educational carousel (e.g., “Ayurvedic Monsoon Tips”) | @terrablu (brand) | @terrablu.varkala (most relevant property) | Pinterest (infographic version), Facebook (album) | — |
| Guest UGC (e.g., guest photo at Pondy) | @terrablu.pondy (with credit) | @terrablu brand (Story feature) | — | — |
| YouTube property tour (e.g., “A Day at TerraBlu Kodai”) | YouTube (brand channel, Kodai playlist) | @terrablu.kodai (Reel teaser), @terrablu (Story) | Instagram Reel (60-sec cut), TikTok (30-sec cut), Pinterest (video pin) | — |
| Content Type | Approval Required? | Approver | Timeline | Escalation |
|---|---|---|---|---|
| Brand campaign content | Yes — full review | Content Manager → Marketing Head | Submit 5 days before publish → Feedback within 24h → Revise → Final approval 2 days before | If not approved in 48h → escalate to Marketing Head |
| Property Feed posts | Yes — standard review | Content Manager | Submit 3 days before → Feedback within 24h → Approval 1 day before | Content Manager has final say |
| Property Stories (daily) | No — self-managed | Property Content Champion (trained) | Real-time creation following guidelines | Spot-checked weekly by Content Manager; flagged if off-brand |
| Crisis/sensitive content | Yes — immediate escalation | Marketing Head → GM | Must not be posted without approval regardless of timing | WhatsApp escalation chain |
| Promotional/pricing content | Yes — full review | Content Manager + Revenue Manager | Revenue Manager confirms pricing/availability → Content Manager approves creative | Revenue Manager has veto on pricing/dates |
| Guest-featuring content | Yes — consent verified | Content Manager | Guest consent form signed/verbal recorded → then standard approval flow | Legal review if identifiable minors or sensitive contexts |
| Category | ✅ Do | ❌ Don’t |
|---|---|---|
| Visual | Use warm, natural tones aligned with brand palette. Show people in spaces (not empty rooms). Prioritize golden hour and natural light. | Never use heavy filters, neon overlays, or stock photos. No clip art, no WordArt, no Comic Sans. |
| Voice | Write as The Thoughtful Explorer — warm, evocative, knowledgeable. Use sensory language and present tense. | Never use aggressive sales language (“BOOK NOW!!! LIMITED OFFER!!!”), generic corporate speak, or slang/memes that don’t fit brand personality. |
| Promotions | Frame offers within storytelling — “This monsoon, heal at Varkala” with package details naturally integrated. | Never post just a price and a “Book Now” button without context, story, or visual appeal. |
| Guest Content | Always ask permission. Credit guests. Celebrate their experience. | Never repost without explicit consent. Never post identifiable children without parental consent. Never post content where guests are in compromising situations. |
| Competitor | Monitor, learn, be inspired, elevate. | Never name, tag, or reference competitors — even positively. Never engage in comparison marketing. |
| Sensitive Topics | Handle with care: natural disasters, political events, cultural sensitivities. Pause scheduled content if a major event occurs. | Never post scheduled promotional content during national tragedies or natural disasters affecting the region. Have a “pause all” protocol. |
| Staff Content | Celebrate, appreciate, credit. Show genuine moments. | Never post staff content without their consent. Never mock, embarrass, or show staff in unflattering situations. |
CRISIS CONTENT PROTOCOL
━━━━━━━━━━━━━━━━━━━━━━━
LEVEL 1 — MINOR (Negative review/comment, small factual error)
→ Community Manager handles directly (response guidelines provided)
→ Notify Content Manager via Slack
→ No scheduled content changes needed
LEVEL 2 — MODERATE (Viral negative post about property, misleading media coverage)
→ Pause all scheduled promotional content for affected property (24h)
→ Content Manager drafts response, Marketing Head approves
→ Activate "soft content" only — atmospheric, non-promotional
→ Review and respond within 4 hours
LEVEL 3 — SEVERE (Natural disaster in destination area, safety incident, national crisis)
→ IMMEDIATELY PAUSE ALL SCHEDULED CONTENT (all properties, all platforms)
→ Marketing Head + GM align on response within 2 hours
→ If TerraBlu is directly affected: Empathetic statement (approved by leadership)
→ If regional/national event: Silence scheduled content until appropriate to resume
→ Resume with sensitivity — no "back to business as usual" tone for 48-72h
→ Acknowledgment post if relevant before returning to regular content
PAUSE ALL BUTTON: Later allows one-click pause of all scheduled content across all accounts — Content Manager has access
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| KPI Layer | Metrics | Tracked For | Frequency | Tool |
|---|---|---|---|---|
| Layer 1 — Awareness | Reach, Impressions, Follower Growth, Video Views, Profile Visits, Pinterest Impressions, YouTube Views | Brand + each property | Weekly | Platform analytics + Airtable log |
| Layer 2 — Engagement | Engagement Rate, Save Rate, Share Rate, Comment Rate, Story Reply Rate, Pin Save Rate, YouTube Watch Time | Brand + each property | Weekly | Platform analytics |
| Layer 3 — Content Performance | Per-post engagement, Top/Bottom performers, Pillar performance comparison, Format performance comparison, Theme day performance | Per content piece | Per post (compiled weekly) | Airtable |
| Layer 4 — Traffic | Website clicks from social, Link-in-bio clicks, UTM-tracked visits by platform/campaign, Pinterest outbound clicks, YouTube description clicks | Brand + each property | Weekly | GA4 + Platform analytics |
| Layer 5 — Conversion | Direct bookings from social (UTM tracked), Booking inquiry DMs, Phone calls from social links, Email sign-ups from social | Brand + each property | Weekly | GA4 + Booking system + DM tracking |
| Layer 6 — Revenue | Revenue attributed to social (direct + assisted), Revenue per platform, Revenue per campaign, Social channel contribution to total revenue | Brand (aggregate) | Monthly | GA4 + Booking system + attribution modeling |
| Layer 7 — Brand Health | Brand mention volume, Sentiment analysis, Share of voice vs. competitors, UGC volume, Brand hashtag usage | Brand (aggregate) | Monthly | Brandwatch + manual tracking |
| Report Section | Contents |
|---|---|
| Executive Summary | Key wins, key challenges, overall performance vs. targets, top 3 recommendations |
| Follower Growth | Growth by property + brand, growth rate %, net new followers, follower source analysis |
| Content Performance | Top 10 posts (with screenshots), bottom 5 posts (with analysis), average engagement rate, saves/shares trends |
| Pillar Analysis | Performance by content pillar — which pillar drives most engagement? Most saves? Most clicks? Adjust mix accordingly |
| Platform Analysis | Performance by platform — Instagram vs. Pinterest vs. YouTube vs. TikTok vs. Facebook — which is growing fastest? Highest ROI? |
| Campaign Performance | Active campaign results — reach, engagement, traffic, bookings (if campaign month) |
| Property Comparison | Cross-property performance comparison — engagement rate, follower growth, content quality scores, content volume compliance |
| Traffic & Conversions | Website visits from social, booking page visits, booking inquiries, confirmed bookings attributed, revenue |
| Content Calendar Compliance | Planned vs. published (what was scheduled vs. what actually went live), why deviations occurred |
| Audience Insights | Demographic shifts, geographic distribution changes, active time changes, new audience segments emerging |
| Competitor Pulse | Notable competitor activity, new campaigns, content innovations, engagement comparisons |
| Next Month Plan | Preview of next month’s campaign, key content themes, special dates, testing plans, resource needs |
| Objective | Key Results | Timeline | Measurement |
|---|---|---|---|
| O1: Build unified brand recognition | KR1: Brand account @terrablu reaches 25K followers. KR2: Brand visual consistency score across all properties ≥ 8.5/10 (monthly audit). KR3: #TerraBluMoments used in 200+ UGC posts. | 6 months | Instagram analytics, brand audit, hashtag tracking |
| O2: Drive direct bookings from social | KR1: Social-attributed bookings grow from 18/month to 80/month. KR2: Social-to-website traffic increases 200%. KR3: Booking inquiry DMs increase from 12/month to 60/month. | 6 months | GA4 + booking system + DM tracking |
| O3: Establish content production excellence | KR1: Content calendar compliance ≥ 90% (planned vs. published). KR2: Average content quality score ≥ 7.5/10. KR3: 15+ new content ideas generated monthly via ideation system. | 3 months | Airtable tracking, quality audit |
| O4: Win monsoon as a travel season | KR1: July–Sept content generates 40% higher engagement than previous year’s July–Sept. KR2: Monsoon campaign drives 120+ bookings across properties. KR3: Varkala monsoon retreat achieves 75%+ occupancy (vs. 35% previous year). | 3 months (seasonal) | Platform analytics, booking data |
| O5: Build multi-platform presence | KR1: Pinterest reaches 500K monthly impressions. KR2: YouTube channel reaches 5K subscribers. KR3: TikTok reaches 15K followers. KR4: Each new platform drives measurable website traffic (500+ visits/month). | 6 months | Platform analytics, GA4 |
| Training Module | Audience | Duration | Format | Topics Covered |
|---|---|---|---|---|
| Strategy Overview | All marketing team + property GMs | 2 hours | Live workshop + Loom recording | Why social media strategy matters for hospitality, our strategic framework, 12-month roadmap, role of each property, how success is measured |
| Brand Voice & Content Guidelines | Content creators + property Content Champions | 3 hours | Live workshop + printed reference guide | Brand voice deep-dive, property personalities, writing exercises, caption dos/don’ts, visual guidelines, common mistakes to avoid |
| Content Calendar System Training | Content team | 2 hours | Live demo + Loom screen recording | Notion strategy hub navigation, Airtable content database operations, how to create/assign/track content pieces, status workflow |
| Photography & Video for Properties | Property Content Champions (4 people) | 4 hours | Hands-on at property | Phone photography masterclass (composition, lighting, angles for hospitality), quick video techniques (room reveals, food shots, ambience), Lightroom preset application |
| Caption Writing Workshop | Content creators | 2 hours | Live workshop | Writing in brand voice, sensory language exercises, CTA integration, AI prompt library usage, hashtag strategy |
| Scheduling & Publishing | Content Manager + backup | 1.5 hours | Live demo + Loom | Later setup, scheduling workflow, grid preview, Story scheduling, multi-platform publishing, first-comment automation |
| Performance Tracking | Content Manager + Marketing Head | 1.5 hours | Live demo + Loom | Airtable metrics tracking, monthly report generation, KPI dashboards, how to read platform analytics, how to make data-driven decisions |
| Crisis Protocol | All marketing team + property GMs | 1 hour | Live briefing + printed protocol card | Crisis levels, pause protocol, response frameworks, escalation chain, role assignments |
| Document | Pages/Size | Purpose | Access |
|---|---|---|---|
| Social Media Strategy Bible | 65 pages (Notion) | Master strategy document — everything from audit findings to persona details to pillar rationale to platform strategy to brand voice to governance model | Marketing team + Leadership |
| Content Pillar Guide | 18 pages (PDF) | Detailed guide for each content pillar — purpose, content types, examples, frequency, do’s/don’ts, inspiration board | All content creators |
| Brand Voice & Personality Cards | 12 pages (PDF, beautifully designed) | Property personality cards, voice characteristics, tone spectrum, vocabulary guide, emoji framework, caption examples | All content creators + property teams |
| 12-Month Campaign Calendar | Interactive Notion calendar + Google Sheets backup | Annual campaign plan with monthly themes, lead properties, objectives, booking windows | Content Manager + Marketing Head |
| Weekly Theme System | 2-page reference card (PDF) | Monday through Sunday recurring themes with content type and pillar mapping | All content creators (printed for each property) |
| Content Calendar System SOP | 10 pages (Notion) | Step-by-step operating procedures for the entire content planning → production → scheduling → measurement workflow | Content team |
| AI Prompt Library | 120 prompts (Notion database) | Organized by pillar, property, format, and campaign — searchable, with usage instructions | Content creators |
| Seasonal Content Idea Banks | 200+ ideas (Notion database) | Pre-built ideas for each season, festival, and event — ready to activate annually | Content team |
| Photography & Video Direction Guide | 15 pages (PDF) | Shot-by-shot guidance for every content type by property — camera angle, lighting, composition, mood | Property Content Champions |
| Crisis Protocol Card | 1 page (laminated card) | Quick-reference crisis response protocol with escalation contacts | All marketing team + property GMs (kept at front desk) |
| Monthly Report Template | Google Slides template + Airtable views | Pre-formatted 12-section monthly report template — just add data | Content Manager |
| Governance & Approval Flowchart | 1-page visual flowchart (PDF) | Visual workflow showing who approves what, when, and how | All team members |
| Feature | Description |
|---|---|
| Comprehensive Social Media Audit | 580+ posts cataloged and analyzed across 4 properties — content, audience, performance, competitor, platform, and brand consistency audits with actionable findings |
| 4 Audience Personas | “Weekend Escape Rhea,” “Wellness Seeker Ananya,” “Culture Explorer Vikram,” and “Celebration Planner Meera” — each with demographics, travel style, content preferences, booking behavior, and primary platform |
| Brand Voice & Personality Framework | “The Thoughtful Explorer” brand personality with voice characteristics, tone spectrum, vocabulary guide, emoji framework, and 4 property-specific personality cards |
| 6-Pillar Content Framework | Destination Stories, Experience & Moments, People & Stories, Travel Knowledge, Campaigns & Experiences, Community & UGC — with percentage mix, content types, and pillar-specific guidelines |
| 5-Platform Channel Architecture | Instagram (5 accounts), Pinterest, YouTube, TikTok, and Facebook — each with defined role, content focus, target persona, posting frequency, and account structure |
| 12-Month Campaign Calendar | Month-by-month campaign themes mapped to lead properties, seasonal objectives, and booking windows — from “New Year, New Places” through “Year-End Magic” |
| Weekly Theme System | 7-day recurring content theme cycle (Monday Escape through Slow Sunday) ensuring consistent variety and pillar balance |
| 4-Layer Content Calendar System | Strategic Layer (Notion) → Editorial Layer (Notion) → Production Layer (Airtable) → Scheduling Layer (Later) — from annual strategy to daily publishing |
| Airtable Content Database | 20+ field content pipeline with status workflow (Idea → Draft → Review → Approved → Scheduled → Published → Measured), per-post performance tracking, and cross-property coordination |
| Content Ideation Engine | 6 ideation methods including monthly sprints, AI prompt library (120 prompts), trend monitoring, guest insight mining, seasonal content banks, and competitor inspiration analysis |
| Cross-Property Content Coordination | 5-level content model (brand / property signature / property daily / cross-property / UGC) with distribution matrix showing posting, resharing, cross-promotion, and adaptation paths |
| Governance Model | Approval workflows by content type, brand guardrails document, and 3-level crisis content protocol with “pause all” capability |
| Layered KPI Framework | 7 measurement layers from Awareness through Revenue and Brand Health — with property-level, platform-level, pillar-level, and campaign-level analysis |
| OKR-Aligned Goals | 5 strategic objectives with measurable key results and timelines — brand recognition, direct bookings, content excellence, monsoon season activation, and multi-platform presence |
| Team Training Program | 8 training modules (18+ hours total) covering strategy, brand voice, content systems, photography, caption writing, scheduling, performance tracking, and crisis management |
| 12-Document Strategy Package | Complete handover documentation including 65-page Strategy Bible, pillar guides, personality cards, campaign calendar, AI prompt library, seasonal idea banks, SOPs, crisis protocol, and report templates |
| Metric | Before | After (Month 6) | Change |
|---|---|---|---|
| Monthly Content Pieces (All Properties + Brand, All Platforms) | ~65 (inconsistent, reactive) | 340+ (planned, strategic, multi-platform) | ⬆ 423% |
| Content Calendar Compliance (Planned vs. Published) | 0% (no calendar existed) | 93% | — |
| Brand Visual Consistency Score (Cross-Property Audit) | 2.4/10 | 8.8/10 | ⬆ 267% |
| Instagram Combined Followers (All Accounts) | 28,500 | 68,200 | ⬆ 139% |
| Instagram Average Engagement Rate (Blended) | 1.8% | 5.4% | ⬆ 200% |
| Instagram Save Rate (Blended) | 0.4% | 3.6% | ⬆ 800% |
| Pinterest Monthly Impressions | 0 (no account) | 620,000 | — |
| Pinterest Monthly Website Clicks | 0 | 2,800 | — |
| YouTube Subscribers | 0 (no channel) | 6,400 | — |
| YouTube Monthly Views | 0 | 84,000 | — |
| TikTok Followers | 0 (no account) | 18,200 | — |
| TikTok Monthly Views | 0 | 340,000 | — |
| Social-to-Website Monthly Traffic | ~1,200 visits | 8,600 visits | ⬆ 617% |
| Direct Bookings Attributed to Social (Monthly) | 18 | 74 | ⬆ 312% |
| Booking Inquiry DMs (Monthly) | ~12 | 68 | ⬆ 467% |
| Revenue Attributed to Social (Monthly) | ~₹3.2L | ₹14.8L | ⬆ 363% |
| Monsoon Occupancy (July–Sept Avg, Varkala) | 35% | 78% (monsoon campaign) | ⬆ 123% |
| Monsoon Occupancy (July–Sept Avg, Kodai) | 42% | 82% (monsoon campaign) | ⬆ 95% |
| Content Production Time (Per Week, Team Total) | ~12 hours (chaotic) | 18 hours (structured, but producing 5x more content at higher quality) | Efficiency ⬆ 350% |
| UGC Generated (#TerraBluMoments) | ~8/month (unmanaged) | 85+/month | ⬆ 963% |
| Team Content Capability Score (Self-Assessment) | 3.2/10 | 8.4/10 | ⬆ 163% |
| Wedding Inquiries from Social (Monthly) | 2 | 14 | ⬆ 600% |
| Brand Mentions (Organic, Monthly) | ~40 | 280+ | ⬆ 600% |
| Competitor Share of Voice (vs. Top 4 Competitors) | 4% (5th of 5) | 18% (2nd of 5) | ⬆ 350% |
Challenge: TerraBlu Hotels & Resorts — a 4-property boutique hospitality group across South India (Varkala, Hampi, Kodaikanal, Pondicherry) with 4.7-star reviews and loyal guests — had zero social media strategy. Four properties ran four chaotic, inconsistent Instagram accounts with no brand voice, no content pillars, no editorial calendar, no seasonal campaigns, no audience personas, no multi-platform presence (zero Pinterest, YouTube, or TikTok), and no governance model. Social media was reactive — “post something when you remember.” In an industry where 74% of travelers use social to choose destinations, this was a critical business vulnerability. Competitors like SaffronStays and Evolve Back dominated travel social media while TerraBlu was invisible.
Solution: We designed a complete social media strategy and content calendar system — starting with a 580-post audit across all properties; developing 4 traveler personas; building “The Thoughtful Explorer” brand voice framework with 4 property-specific personality cards; creating a 6-pillar content framework; architecting a 5-platform channel strategy (Instagram, Pinterest, YouTube, TikTok, Facebook) with account restructuring; designing a 12-month campaign calendar with seasonal themes mapped to booking windows; implementing a weekly 7-day theme system; building a 4-layer content calendar infrastructure (Notion strategy → Notion editorial → Airtable production pipeline → Later scheduling); creating a content ideation engine with 120 AI prompts and 200+ seasonal ideas; establishing cross-property coordination with distribution matrix; implementing a governance model with crisis protocol; setting up a 7-layer KPI framework with OKR-aligned goals; delivering 8 training modules (18+ hours); and handing over a 12-document strategy package including a 65-page Strategy Bible.
Result: Content output grew from 65 to 340+ monthly pieces across all platforms and properties. Brand consistency scored 8.8/10 (from 2.4). Combined Instagram followers grew 139%. Engagement rate jumped 200%. Save rate increased 800%. Pinterest reached 620K monthly impressions from zero. YouTube gained 6,400 subscribers. TikTok hit 18,200 followers. Social-to-website traffic grew 617%. Direct bookings from social increased 312%. Revenue attributed to social grew 363%. Monsoon occupancy at Varkala jumped from 35% to 78% through strategic monsoon campaign. Wedding inquiries from social grew 600%. TerraBlu’s share of voice against top competitors rose from 4% to 18%.
We designed and launched a complete social media advertising system for NestCraft Living — building a full-funnel paid social engine across Meta, Pinterest, and YouTube that generated ₹1.84Cr in attributed revenue over 6 months at a blended 6.8x ROAS, reducing cost-per-acquisition by 62% and transforming paid social from their weakest channel into their primary revenue driver.
| Client Name | NestCraft Living (Showcase Project) |
| Industry | Home Decor & Furniture / D2C E-Commerce |
| Project Duration | 6 Weeks |
| Services Delivered | Paid Social Strategy & Funnel Architecture, Meta Ads (Facebook + Instagram) Campaign Build, Pinterest Ads Campaign Build, YouTube Ads Campaign Build, Audience Research & Segmentation, Creative Strategy & Ad Production, Dynamic Product Ads (DPA) Setup, Retargeting Funnel Design, Campaign Budget Allocation & Scaling Framework, A/B Testing System, Conversion Tracking & Attribution Setup, Reporting Dashboard & Optimization Playbook |
| Tools & Platforms Used | Meta Business Suite, Meta Ads Manager, Pinterest Ads Manager, Google Ads (YouTube), Meta Pixel, Pinterest Tag, Google Tag Manager, Google Analytics 4, Shopify (storefront + product catalog), Triple Whale (attribution), Canva Pro, CapCut Pro, ChatGPT API (OpenAI), Midjourney (lifestyle ad imagery), Notion, Google Sheets, Looker Studio, Zapier, Slack, Hotjar (landing page heatmaps) |
| Project Year | 2025 |
NestCraft Living is a D2C home furniture and decor brand based in Pune, offering a curated range of 240+ products — from solid sheesham wood dining tables and handwoven jute rugs to modular bookshelves, artisan ceramic planters, and handcrafted brass lighting. Every piece is designed in-house, sustainably sourced, and manufactured by Indian artisan clusters. Their price point sits in the premium-accessible range — a 6-seater dining table at ₹38,000, a handwoven rug at ₹5,500, a statement bookshelf at ₹22,000.
Their Shopify store was beautifully designed. Product photography was excellent — lifestyle room settings, close-up material shots, 360-degree views. Customer reviews averaged 4.5 stars across 1,800+ reviews. Organic traffic was healthy, and their email list of 28,000 subscribers drove consistent repeat purchases.
But paid social media advertising — the channel that should have been their growth engine — was hemorrhaging money.
NestCraft had been running Facebook and Instagram ads in-house for 14 months. They’d spent ₹42 lakh total. Their blended ROAS (Return on Ad Spend) was 1.6x — meaning for every ₹1 spent on ads, they made ₹1.60 in revenue. After product costs, shipping, returns, and overheads, they were losing money on every ad-acquired customer. Their cost-per-acquisition was ₹2,800 — on products with an average order value of ₹4,500 and a gross margin of 45%. The math didn’t work.
The problem wasn’t that paid social doesn’t work for furniture. Competitors like Wakefit, Urban Ladder, and Wooden Street were scaling aggressively through Meta and YouTube ads. The problem was how NestCraft was doing it — boosted posts instead of proper campaigns, no funnel structure, no retargeting, no dynamic product ads, zero presence on Pinterest (the highest-intent home decor platform), no YouTube ads despite having beautiful video content, and creative fatigue from running the same 5 ad sets for months.
We built a complete social media advertising system — from full-funnel campaign architecture and audience segmentation to creative strategy, dynamic product ads, multi-platform retargeting, budget allocation frameworks, and a performance optimization playbook — transforming NestCraft’s paid social from a money pit into a predictable, scalable revenue machine.
| Metric | NestCraft (Before) | Industry Benchmark (Home Decor D2C) | Gap |
|---|---|---|---|
| Blended ROAS | 1.6x | 4.0x–6.0x | 60–73% below benchmark |
| Cost Per Acquisition (CPA) | ₹2,800 | ₹800–₹1,200 | 133–250% above benchmark |
| Click-Through Rate (CTR) | 0.6% | 1.2%–2.0% | 50–70% below benchmark |
| Cost Per Click (CPC) | ₹18.40 | ₹6–₹10 | 84–207% above benchmark |
| Conversion Rate (Ad → Purchase) | 0.8% | 2.0%–3.5% | 60–77% below benchmark |
| Ad Frequency (Avg) | 8.4 | <3.0 | 180% above (massive creative fatigue) |
| Total Spend (14 months) | ₹42,00,000 | — | — |
| Total Revenue from Ads | ₹67,20,000 | — | — |
| Net Profit from Ads | Negative (after COGS, shipping, returns) | — | Losing money on every acquisition |
| Problem | Details |
|---|---|
| 5 ad creatives running for 8+ months | Same product photos recycled since launch — audience had seen each ad 8.4 times on average |
| No video ads | 100% static images — in a category where video (room walkthroughs, material close-ups, assembly timelapses) dramatically outperforms static |
| No lifestyle imagery | Products photographed on white backgrounds — no room context, no aspiration, no “imagine this in your home” |
| Generic copy | “Shop premium furniture at NestCraft” — no storytelling, no craftsmanship narrative, no urgency, no social proof, no objection handling |
| Wrong formats | Single-image ads only — no carousels showcasing product range, no collection ads for room categories, no dynamic product ads showing items people actually browsed |
| Competitor | Monthly Ad Spend (Est.) | ROAS (Est.) | Ad Strategy |
|---|---|---|---|
| Wakefit | ₹2.5Cr+ | 5x–7x | Full-funnel, video-heavy, DPA, YouTube + Meta, aggressive retargeting, influencer whitelisting |
| Urban Ladder | ₹1.8Cr+ | 4x–6x | Collection ads, room-setting lifestyle, AR try-in-room, carousel catalogs, strong retargeting |
| Wooden Street | ₹1.2Cr+ | 4x–5x | Before/after room transformations, customer testimonial ads, dynamic retargeting, Pinterest |
| NestCraft Living | ₹3L/month | 1.6x | Boosted posts, single images, no funnel, no retargeting, no video, no Pinterest/YouTube |
| Tracking Element | Before | After | Impact |
|---|---|---|---|
| Meta Pixel Events | PageView only | PageView, ViewContent, AddToCart, InitiateCheckout, Purchase (with value), Search, ViewCategory | Full purchase funnel visibility — algorithm can optimize for actual revenue |
| Conversions API (CAPI) | Not implemented | Server-side event tracking via Shopify + Meta CAPI integration | 30–40% more conversion data captured (browser ad blockers can’t block server-side) |
| Pinterest Tag | Not installed | Full funnel: PageVisit, ViewCategory, AddToCart, Checkout, Purchase | Enables Pinterest conversion optimization |
| Google Tag Manager | Not used | Central tag management for all platforms — Pixel, Pinterest Tag, GA4, YouTube | Clean implementation, no duplicate tags, easy future additions |
| Google Analytics 4 | Basic install | Enhanced e-commerce tracking, UTM structure for all ad campaigns, custom channel groupings | Unified attribution across all paid channels |
| Triple Whale | Not used | First-party pixel + server-side attribution — blended ROAS, platform ROAS, true CPA, customer journey mapping | Accurate cross-platform attribution (not relying solely on platform self-reporting) |
| UTM Framework | None | Standardized: utm_source=meta/pinterest/youtube, utm_medium=paid-social, utm_campaign=[campaign-name], utm_content=[ad-creative-id] | Track every click to revenue, know exactly which creative, audience, and platform drives sales |
| Offline Conversion Tracking | None | Shopify → Meta CAPI: delayed purchase events (customers who buy 3–7 days after clicking) sent back to Meta | Captures the long consideration cycle typical of furniture purchases |
| Audience Type | Audience Name | Source | Size (Est.) | Funnel Use |
|---|---|---|---|---|
| Custom — Website | All Visitors (180 days) | Meta Pixel | 85,000 | Retargeting — broad |
| Custom — Website | Product Viewers (30 days) | Meta Pixel — ViewContent event | 22,000 | Retargeting — warm |
| Custom — Website | Add-to-Cart Abandoners (14 days) | Meta Pixel — ATC but no Purchase | 4,200 | Retargeting — hot |
| Custom — Website | Checkout Abandoners (7 days) | Meta Pixel — InitiateCheckout but no Purchase | 1,800 | Retargeting — burning hot |
| Custom — Customer | Past Purchasers (All time) | Shopify customer list upload | 6,400 | Exclusion (prospecting) + Upsell/Cross-sell |
| Custom — Customer | High-Value Purchasers (AOV > ₹15,000) | Shopify filtered list | 1,200 | Seed for best Lookalike |
| Custom — Customer | Repeat Purchasers (2+ orders) | Shopify filtered list | 890 | Seed for loyalty Lookalike |
| Custom — Engagement | Instagram Engagers (90 days) | Meta — IG profile interactions | 45,000 | Retargeting — social warm |
| Custom — Engagement | Video Viewers 75%+ (30 days) | Meta — watched 75%+ of any video ad | Grows over time | Retargeting — high-intent |
| Custom — Email | Email Subscribers (non-purchasers) | Klaviyo list upload | 21,000 | Retargeting — owned audience |
| Lookalike | LAL — Purchasers (1%) | Based on all purchasers | ~2.5M | Prospecting — primary |
| Lookalike | LAL — High-Value Purchasers (1%) | Based on AOV > ₹15K | ~2.5M | Prospecting — premium |
| Lookalike | LAL — Repeat Purchasers (1%) | Based on 2+ order customers | ~2.5M | Prospecting — loyalty-oriented |
| Lookalike | LAL — ATC Abandoners (1%) | Based on ATC audience | ~2.5M | Prospecting — high-intent behavior match |
| Lookalike | LAL — Top Engagers (1%) | Based on IG 90-day engagers | ~2.5M | Prospecting — brand-affinity match |
| Interest-Based | Home Decor Enthusiasts | Meta interest targeting: Home Decor, Interior Design, Furniture, Home Improvement, Architecture, Houzz, Pinterest | ~18M | Prospecting — interest |
| Interest-Based | New Homeowners/Movers | Meta: Recently Moved, New Home, Home Loan, Real Estate | ~8M | Prospecting — life event |
| Interest-Based | Sustainable/Artisan Shoppers | Meta: Sustainable Living, Handmade, Artisanal, Eco-Friendly, Ethical Shopping | ~6M | Prospecting — values-aligned |
| Actalike — Purchasers | Pinterest Tag — matched purchaser behavior | Variable | Pinterest prospecting | |
| Search Retargeting | Users who searched “dining table,” “wooden bookshelf,” “home decor” on Pinterest | Variable | Pinterest high-intent | |
| YouTube | Custom Intent | Users searching YouTube/Google for “home decor ideas,” “furniture shopping India,” “room makeover” | Variable | YouTube prospecting |
NESTCRAFT PAID SOCIAL FUNNEL
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
TOFU — TOP OF FUNNEL (AWARENESS + DISCOVERY)
┌─────────────────────────────────────────────────────┐
│ Objective: Reach & Video Views │
│ Audience: Cold — Lookalikes, Interest-Based, │
│ Pinterest Actalikes, YouTube Custom Intent│
│ Budget: 30% of total ad spend │
│ Content: Brand story videos, room transformation │
│ timelapses, artisan craftsmanship films, │
│ Pinterest Idea Pins, YouTube pre-roll │
│ KPIs: CPM, ThruPlay rate, Video View %, Reach, │
│ Brand lift, Pinterest saves │
│ Goal: Build awareness, establish brand identity, │
│ fill retargeting audiences │
└────────────────────────┬────────────────────────────┘
│ People who watch/engage
▼
MOFU — MIDDLE OF FUNNEL (CONSIDERATION + ENGAGEMENT)
┌─────────────────────────────────────────────────────┐
│ Objective: Traffic + Engagement │
│ Audience: Warm — Video viewers (75%+), IG engagers,│
│ Website visitors (broad), Email subs, │
│ Pinterest engagers │
│ Budget: 25% of total ad spend │
│ Content: Product carousels by room/category, │
│ customer testimonial videos, "how it's │
│ made" content, comparison guides, │
│ room styling ideas, material deep-dives │
│ KPIs: CTR, CPC, Landing page views, Time on site, │
│ Product page views, Add-to-Cart rate │
│ Goal: Drive qualified traffic, educate, build │
│ purchase intent │
└────────────────────────┬────────────────────────────┘
│ People who visit site/ATC
▼
BOFU — BOTTOM OF FUNNEL (CONVERSION + RETARGETING)
┌─────────────────────────────────────────────────────┐
│ Objective: Conversions (Purchase) │
│ Audience: Hot — Product viewers, ATC abandoners, │
│ Checkout abandoners, catalog retargeting │
│ Budget: 35% of total ad spend │
│ Content: Dynamic Product Ads (exact items browsed), │
│ limited-time offers, free shipping nudge, │
│ customer review ads, urgency messaging, │
│ "still thinking about this?" retargeting │
│ KPIs: ROAS, CPA, Conversion rate, Revenue, │
│ Purchase value │
│ Goal: Convert warm audiences into paying customers │
└────────────────────────┬────────────────────────────┘
│ Customers who purchased
▼
POST-PURCHASE (RETENTION + UPSELL)
┌─────────────────────────────────────────────────────┐
│ Objective: Catalog Sales + Repeat Purchase │
│ Audience: Past purchasers (30–180 days), │
│ segmented by product category purchased │
│ Budget: 10% of total ad spend │
│ Content: Complementary product recommendations │
│ ("You bought the dining table — complete │
│ the set"), new arrivals, seasonal refresh, │
│ loyalty rewards, referral program │
│ KPIs: Repeat purchase rate, AOV increase, LTV, │
│ Cross-sell revenue │
│ Goal: Increase customer lifetime value │
└─────────────────────────────────────────────────────┘
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Funnel Stage | % of Budget | Monthly Budget (at ₹5L/month) | Primary Metric | Scaling Trigger |
|---|---|---|---|---|
| TOFU (Awareness) | 30% | ₹1,50,000 | CPM < ₹150, ThruPlay rate > 30% | Increase if retargeting audiences are shrinking (not enough TOFU feeding the funnel) |
| MOFU (Consideration) | 25% | ₹1,25,000 | CPC < ₹8, CTR > 1.5%, ATC rate > 3% | Increase if TOFU is generating traffic but MOFU isn’t converting to ATC |
| BOFU (Conversion) | 35% | ₹1,75,000 | ROAS > 8x, CPA < ₹1,000 | Increase if BOFU ROAS is high and audience isn’t saturated (frequency < 3) |
| Post-Purchase (Retention) | 10% | ₹50,000 | Repeat purchase rate, Cross-sell revenue | Increase as customer base grows |
| Funnel Stage | Creative Type | Format | Quantity | Production Method |
|---|---|---|---|---|
| TOFU | Brand Story Film | Video (15–30 sec), 9:16 + 1:1 + 16:9 | 3 hero videos | Professional footage + CapCut editing + AI voiceover |
| TOFU | Room Transformation Timelapse | Video (15–30 sec), 9:16 | 4 videos | Time-lapse of empty room → styled with NestCraft products |
| TOFU | Artisan Craftsmanship | Video (30–60 sec), 9:16 + 1:1 | 3 videos | Workshop footage — wood carving, hand weaving, brass casting |
| TOFU | Pinterest Idea Pins | Multi-image pin (5–8 slides) | 6 pins | Room styling guides, material guides, decor tips |
| TOFU | YouTube Pre-Roll | Video (15 sec non-skippable + 30 sec skippable) | 4 videos | Brand highlight + room showcase, strong hook in first 3 sec |
| MOFU | Product Carousel | Carousel (4–6 slides), 1:1 | 8 carousels | By room (living room, bedroom, dining) and by style (modern, rustic, minimal) |
| MOFU | Customer Testimonial | Video (30–60 sec), 9:16 | 5 videos | Real customer home tours showing NestCraft products in their space |
| MOFU | “How It’s Made” | Video (30–60 sec), 9:16 | 3 videos | Material journey — tree to table, loom to rug, clay to planter |
| MOFU | Comparison/Education | Carousel (6–8 slides), 1:1 | 4 carousels | “Sheesham vs. Mango Wood,” “5 Signs of Quality Furniture,” “Solid Wood vs. Engineered” |
| MOFU | Room Styling Guide | Carousel (8–10 slides), 1:1 + Pinterest (2:3) | 4 sets | “Style Your Living Room in 3 Looks” — minimalist, bohemian, contemporary |
| BOFU | Dynamic Product Ads | Auto-generated from catalog, 1:1 | Automated (240+ products) | Shopify catalog → Meta/Pinterest catalog sync → DPA templates |
| BOFU | Urgency/Offer | Static image + video (15 sec), 1:1 + 9:16 | 6 creatives | Limited-time offers, free shipping thresholds, festive sale |
| BOFU | Social Proof | Static + Video, 1:1 + 9:16 | 5 creatives | Customer review quotes overlaid on product images, star ratings, “2,400+ happy homes” |
| BOFU | “Still Thinking?” Retargeting | Static + Video (15 sec), 1:1 | 4 creatives | Shows exact product they viewed + incentive (“Free delivery on your first order”) |
| Post-Purchase | Cross-Sell | Carousel (4 slides), 1:1 | 4 carousels | “Complete Your [Room]” — complementary products based on purchase category |
| Post-Purchase | New Arrivals | Carousel + Video, 1:1 + 9:16 | 3 sets/month | Seasonal new product launches |
MONTHLY AD CREATIVE PRODUCTION CYCLE
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
WEEK 1 — ANALYSIS & PLANNING:
→ Review past month ad performance by creative
→ Identify: Top 5 performers (scale), Bottom 5 (kill), Fatigued (frequency > 4)
→ Analyze competitor ads (Meta Ad Library, Pinterest Trends)
→ Plan new creative concepts for each funnel stage
→ Create creative brief document
WEEK 2 — PRODUCTION:
→ Shoot new product/lifestyle photos (if needed)
→ Design static ads in Canva Pro (6–8 new)
→ Edit video ads in CapCut Pro (4–6 new)
→ Write ad copy variations (3 copy versions per creative)
→ Generate AI lifestyle imagery via Midjourney (room settings)
→ Create Pinterest-specific pin designs
WEEK 3 — TESTING:
→ Launch new creatives as A/B tests against current winners
→ Test: Creative (image/video) × Copy × Audience combinations
→ Budget: ₹500–₹1,000/day per test ad set (3-day test window)
→ Decision criteria: CTR, CPC, ATC rate (not ROAS — too early)
WEEK 4 — OPTIMIZATION:
→ Promote test winners to main campaigns
→ Kill underperformers (below threshold after 3 days + ₹2,000 spend)
→ Refresh ad copy on fatigued high-performers (new copy, same creative)
→ Update DPA catalog templates seasonally
MONTHLY OUTPUT: 15–20 new ad creatives
CREATIVE LIBRARY GROWTH: Cumulative testing builds a library of
proven winners — by Month 6, 80+ tested creatives with clear
performance data on each
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Funnel Stage | Copy Tone | Structure | Example |
|---|---|---|---|
| TOFU | Aspirational, storytelling, emotional | Hook (stop-scroll) → Brand story/value → Soft CTA (Explore/Discover) | “Your home tells a story. Make it one worth telling. → NestCraft brings India’s finest artisan woodcraft to your living room — handcrafted from solid sheesham by 3rd-generation carpenters in Jodhpur. → Explore the collection ↗” |
| MOFU | Educational, value-driven, comparative | Hook → Product benefit/differentiation → Social proof → CTA (Shop/Browse) | “Not all ‘solid wood’ furniture is actually solid wood. Here’s how to tell. → Swipe through our guide to spotting quality craftsmanship → 4.5★ across 1,800+ reviews → Shop genuine solid wood →” |
| BOFU — Retarget | Direct, urgency, objection-handling | Reminder → Incentive → Urgency → Strong CTA (Buy/Complete Order) | “Still thinking about the Jodhpur Dining Table? → Free shipping this week only + easy 3-month EMI → Only 4 left in stock → Complete your order →” |
| BOFU — DPA | Product-specific, benefit-focused | Product name → Key benefit → Price/offer → CTA | Auto-generated from catalog: “[Product Name] — Solid Sheesham Wood, Handcrafted → ₹[Price] (Free Delivery) → Shop Now” |
| Post-Purchase | Warm, complementary, rewarding | Appreciation → Suggestion → Incentive → CTA | “Your Jodhpur Dining Table is on its way! 🎉 → Complete the look with matching chairs — 15% off your second order → Shop Dining Chairs →” |
| DPA Element | Configuration |
|---|---|
| Product Catalog | Shopify → Meta Commerce Manager sync — all 240+ products with: title, description, price, sale price, image URL, product URL, availability, category, material, room type |
| Catalog Segmentation | Product sets by: Room (Living Room, Bedroom, Dining, Study, Outdoor), Category (Tables, Seating, Storage, Lighting, Decor, Rugs), Price Range (<₹5K, ₹5K–₹15K, ₹15K–₹40K, ₹40K+), New Arrivals, Best Sellers, On Sale |
| DPA Template Design | Custom Canva-designed catalog ad frames: product image in center, NestCraft logo top-left, price tag bottom-right, “Free Delivery” badge (for qualifying products), material icon (wood/brass/jute) |
| DPA Retargeting Rules | Viewed product but didn’t ATC (show viewed product + 3 similar), ATC but didn’t purchase (show carted product with urgency), Purchased (show complementary products from same room category) |
| Pinterest Catalog | Shopify → Pinterest catalog sync, product pins auto-generated, shopping ads enabled across all product sets |
| DPA Performance Monitoring | Per-product ROAS tracked — products with ROAS < 3x after ₹2,000 spend are paused, top performers get increased bid |
| Campaign | Objective | Ad Sets | Audience | Budget % | Key Creatives |
|---|---|---|---|---|---|
| [TOFU] Brand Awareness | Video Views (ThruPlay) | 3 ad sets: LAL Purchasers 1%, Interest-Home Decor, Interest-New Homeowners | Cold | 15% | Brand story films, room transformations, artisan craftsmanship videos |
| [TOFU] Reach — Top Content | Reach | 2 ad sets: LAL High-Value 1%, Sustainable Shoppers | Cold | 8% | Best-performing organic content boosted with proper targeting |
| [MOFU] Traffic — Product Discovery | Traffic (Landing Page Views) | 4 ad sets: Video Viewers 75%+, IG Engagers, Email Subscribers, LAL ATC | Warm | 12% | Product carousels by room, comparison guides, how-it’s-made videos |
| [MOFU] Engagement — Social Proof | Engagement | 2 ad sets: Website Visitors (180d), IG Engagers | Warm | 6% | Customer testimonial videos, review compilations, “2,400+ happy homes” |
| [BOFU] Conversions — Prospecting | Conversions (Purchase) | 3 ad sets: LAL Purchasers 1%, LAL Repeat Purchasers 1%, Interest Stack (Home Decor + Furniture + Income top 25%) | Cold-Warm | 18% | Product-focused carousels, lifestyle imagery with strong CTA, offer creatives |
| [BOFU] Conversions — Retargeting | Conversions (Purchase) | 4 ad sets: Product Viewers (30d), ATC Abandoners (14d), Checkout Abandoners (7d), Video Viewers 95%+ (14d) | Hot | 22% | DPA (exact products viewed), urgency messaging, free shipping nudge, testimonial + product combo |
| [BOFU] Catalog Sales — DPA | Catalog Sales | 3 ad sets: Viewed (no ATC), ATC (no Purchase), Cross-sell (past purchasers) | Hot | 12% | Dynamic product ads from catalog with custom frames |
| [Post-Purchase] Cross-Sell | Conversions | 2 ad sets: Purchasers (30–180d) segmented by category | Customer | 7% | Complementary product carousels, new arrivals, seasonal refresh |
| Campaign | Objective | Targeting | Budget % (of Pinterest allocation) | Key Creatives |
|---|---|---|---|---|
| [TOFU] Awareness — Home Decor Inspiration | Awareness | Interest: Home Decor, Interior Design, Furniture Design, Bohemian Home, Modern Living + Actalike from website visitors | 30% | Lifestyle room-setting pins, “10 Ways to Style Your Living Room” Idea Pins, seasonal decor inspiration |
| [MOFU] Consideration — Product Discovery | Consideration (Traffic) | Keyword: “dining table wood,” “handmade furniture India,” “boho living room decor,” “wooden bookshelf” + 80 more keywords, Retarget: Pinterest engagers | 30% | Product pins with lifestyle context, material comparison guides, room before/after |
| [BOFU] Conversions — Shopping Ads | Conversions (Checkout) | Shopping catalog, Retarget: Website visitors + ATC from Pinterest tag | 30% | Shopping pins (auto-generated from catalog), collection pins by room |
| [Retarget] Website Retargeting | Conversions | Website visitors via Pinterest tag, ATC abandoners | 10% | Dynamic retargeting pins showing viewed products |
| Keyword Category | Example Keywords | Monthly Search Volume (Est.) | Bid Strategy |
|---|---|---|---|
| Product-Specific | “wooden dining table,” “sheesham furniture,” “jute rug handmade,” “brass lamp India” | 50K–200K each | Moderate bid — high intent, strong conversion |
| Room-Specific | “living room decor ideas,” “bedroom furniture modern,” “dining room makeover,” “home office setup” | 200K–1M each | Lower bid — broader, awareness-building |
| Style-Specific | “bohemian home decor,” “minimalist furniture,” “rustic wood furniture,” “contemporary Indian home” | 100K–500K each | Moderate bid — style-aligned audience |
| Occasion-Specific | “new home furniture,” “Diwali home decor,” “wedding home setup,” “housewarming gift ideas” | Variable — seasonal | Increase bid during peak seasons |
| Material-Specific | “solid wood furniture India,” “handwoven rug,” “ceramic planters handmade,” “brass decor items” | 30K–100K each | Higher bid — very high intent, artisan-seeking buyer |
| Campaign | Format | Targeting | Budget % (of YouTube allocation) | Key Creatives |
|---|---|---|---|---|
| [TOFU] Brand Awareness | Skippable In-Stream (30 sec) | Custom Intent (searching “home decor,” “furniture shopping”), Affinity (Home Decor Enthusiasts, Interior Design) | 40% | Brand story film, room transformation timelapse, artisan workshop |
| [TOFU] Discovery | In-Feed (Discovery) Ads | Custom Intent + Placement targeting (home decor YouTube channels, interior design vlogs) | 20% | “Tour Our Workshop” (3 min), “How a NestCraft Dining Table Is Made” (5 min) |
| [BOFU] Retargeting | Skippable In-Stream (15 sec) | Remarketing: Website visitors, YouTube channel viewers, Meta custom audience sync | 30% | Product-focused retargeting: “The table you loved is waiting” + specific product showcase |
| [BOFU] Bumper Ads | Non-Skippable Bumper (6 sec) | Remarketing: Website visitors (14 days) | 10% | Quick product flash + offer + CTA — “Free delivery this week → NestCraft.in” |
| Platform | % of Total Budget | Monthly (at ₹5L) | Rationale |
|---|---|---|---|
| Meta (Facebook + Instagram) | 60% | ₹3,00,000 | Primary conversion driver, largest audience, most mature ad platform for e-commerce |
| 25% | ₹1,25,000 | Highest purchase intent for home decor (85% of users plan purchases), visual search, long content shelf life (pins last months vs. hours for Meta) | |
| YouTube | 15% | ₹75,000 | Brand storytelling, artisan craftsmanship videos, high-quality retargeting, Google ecosystem benefits |
| Test Type | What We Test | How | Duration | Decision Criteria |
|---|---|---|---|---|
| Creative Test | Image A vs. Image B vs. Video C (same audience, same copy) | Split across ad sets within same campaign, equal budget | 3–5 days or ₹2,000 spend (whichever first) | Winner: Highest CTR (TOFU/MOFU) or Highest ROAS (BOFU) at statistical significance |
| Copy Test | Copy variation A vs. B vs. C (same creative, same audience) | Multiple ads within same ad set | 3–5 days or ₹2,000 spend | Winner: Highest CTR + Conversion Rate combination |
| Audience Test | Audience A vs. B vs. C (same creative, same copy) | Separate ad sets in same campaign, equal budget | 5–7 days or ₹3,000 spend per ad set | Winner: Lowest CPA at acceptable ROAS |
| Format Test | Carousel vs. Single Image vs. Video vs. Collection (same audience) | Separate ads within same ad set | 5–7 days | Winner: Highest ROAS for BOFU, highest CTR for TOFU |
| Landing Page Test | Product page vs. Collection page vs. Custom landing page (same ad) | UTM differentiation + GA4 analysis | 7–14 days | Winner: Highest conversion rate (ad click → purchase) |
| Placement Test | Feed vs. Stories vs. Reels vs. Explore (same creative) | Placement-specific ad sets (not Advantage+) | 5–7 days | Winner: Lowest CPA per placement — then allocate budget accordingly |
| Bid Strategy Test | Lowest Cost vs. Cost Cap vs. Bid Cap | Duplicate campaigns with different strategies | 7–14 days | Winner: Most consistent CPA within target range at scale |
| Offer Test | Free shipping vs. 10% off vs. Bundle deal vs. No offer | Same BOFU audience, different offer creatives | 5–7 days | Winner: Highest ROAS (factoring in discount cost) |
| Week | Tests Running | Focus |
|---|---|---|
| Week 1 of Month | 2–3 creative tests across funnel stages | Find winning visuals/videos |
| Week 2 of Month | 2 copy tests on winning creatives + 1 audience test | Optimize messaging, expand reach |
| Week 3 of Month | 1 format test + 1 placement test | Optimize delivery efficiency |
| Week 4 of Month | Scale winners, kill losers, plan next month’s tests | Consolidation and scaling |
| Monthly | 6–8 total tests, producing 2–3 new proven winners | Continuous creative library growth |
DAILY OPTIMIZATION CHECKS (15 minutes)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
CHECK 1 — Spend Pacing:
→ Is daily spend tracking to monthly budget? (±10% variance OK)
→ Any campaign overspending? → Adjust daily budget
→ Any campaign underspending? → Check ad review status, audience saturation
CHECK 2 — BOFU ROAS:
→ ROAS > 5x → Scale: increase budget 20% (max every 3 days)
→ ROAS 3x–5x → Maintain: keep budget, monitor
→ ROAS 2x–3x → Optimize: test new creatives, check frequency
→ ROAS < 2x for 3+ days → Investigate: audience fatigue? creative fatigue? landing page issue?
→ ROAS < 1.5x for 5+ days → Kill: pause ad set, reallocate budget
CHECK 3 — Frequency:
→ TOFU frequency > 2.0 → Expand audience or refresh creative
→ MOFU frequency > 3.0 → Refresh creative, rotate messaging
→ BOFU frequency > 4.0 → Urgent: creative fatigue, performance will tank
→ All platforms: frequency < 1.0 → Budget may be too low or audience too broad
CHECK 4 — CPA Trending:
→ CPA decreasing week-over-week → Healthy, continue
→ CPA increasing week-over-week → Diagnose: creative fatigue (check frequency),
audience saturation (check overlap), competitor activity (check auction insights)
CHECK 5 — Creative Performance:
→ Any ad with CTR < 0.8% after ₹2,000 spend → Kill
→ Any ad with CPA > 2x target after ₹3,000 spend → Kill
→ Any ad delivering < 100 impressions/day → Check: ad rejected? audience too narrow?
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
WEEKLY OPTIMIZATION (1 hour)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━
→ Review all campaigns: ROAS, CPA, CTR, Spend, Frequency
→ Pause underperforming ad sets (below threshold for 5+ days)
→ Scale winning ad sets (increase budget 20% — never more than 20% per adjustment)
→ Refresh ad copy on high-frequency winners
→ Review audience overlap (Audience Overlap tool — merge or exclude overlapping audiences)
→ Check auction insights: any new competitor bidding aggressively?
→ Update performance dashboard
MONTHLY OPTIMIZATION (3 hours)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
→ Full funnel analysis: Is TOFU feeding MOFU? Is MOFU feeding BOFU?
→ Budget reallocation across funnel stages based on performance
→ Platform budget reallocation (Meta vs. Pinterest vs. YouTube)
→ Creative audit: which visual styles, video types, copy angles perform best?
→ Audience audit: which audiences have highest ROAS? Expand or create new LALs
→ Landing page analysis: conversion rate by landing page, heatmap review (Hotjar)
→ Competitive analysis: check Meta Ad Library for competitor creative changes
→ Plan next month's creative production and testing roadmap
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Scaling Method | When to Use | How | Risk Level |
|---|---|---|---|
| Vertical Scaling | Ad set with ROAS > 5x and frequency < 3 | Increase budget 20% every 3 days (never jump more than 20% — Meta algorithm resets learning phase) | Low |
| Horizontal Scaling — Audience | Winning creative wants more reach | Duplicate winning ad into new audience (different LAL seed, new interest stack, different LAL %) | Medium |
| Horizontal Scaling — Platform | Winning creative/concept on one platform | Adapt winning Meta creative for Pinterest/YouTube | Medium |
| Horizontal Scaling — Placement | Winning in Feed, untested in Reels/Stories | Create placement-optimized versions of winning creative | Low |
| Creative Scaling | Winning angle identified (e.g., “craftsmanship” outperforms “price”) | Produce 3–5 variations of winning angle with different visuals, copy, formats | Medium |
| Offer Scaling | Winning offer identified (e.g., free shipping > 10% off) | Apply winning offer to more campaigns, higher budgets | Low |
| Geographic Scaling | Strong performance in Tier 1 cities | Expand targeting to Tier 2 cities, adjust messaging for regional relevance | Medium-High |
| Ad Campaign | Landing Page | Why (Not Homepage) | Conversion Elements |
|---|---|---|---|
| Room-specific carousel (e.g., “Living Room Collection”) | /collections/living-room — filtered collection page | Shows exactly what the ad promised — no friction, no hunting | Sort by best-selling (default), “X customers chose this” badges, quick-view functionality |
| Single product retargeting (DPA) | Product page of the specific item viewed | Exact product continuity from ad to page | Sticky “Add to Cart” button, “Free delivery” badge, 3 customer reviews visible above fold, EMI option displayed, “Only X left” urgency |
| Brand story / awareness video | /our-story — brand story landing page | First-time visitors need brand context before shopping | Artisan video embed, founder’s letter, material sourcing story, “Explore Collections” CTA at bottom |
| Offer/sale campaign | /sale — dedicated sale page | Offer-specific experience, no distraction | Countdown timer, sale products only, original price crossed out, “ends in X days” urgency |
| “How It’s Made” content | /craftsmanship — custom landing page | Education → Trust → Purchase journey | Process photos, artisan profiles, material certifications, “Shop Handcrafted Furniture” CTA |
| Customer testimonial ad | /reviews or specific product page | Social proof continuity | Full review section, photo/video reviews, “Verified Buyer” badges, aggregate ratings |
| Pinterest room styling guide | Custom styled room landing page → /rooms/[room-name] | Pinterest users want styled room → shop the look | “Shop this room” — clickable room image with product tags, each item linked to product page |
| Metric | Tracked Via | Benchmark | Optimization Action |
|---|---|---|---|
| Bounce Rate (from ad traffic) | GA4 — by UTM | < 45% | If > 45%: Message mismatch between ad and page? Page load speed? Mobile experience? |
| Time on Page | GA4 | > 90 seconds (product page) | If < 60s: Not enough engaging content above fold? Images loading slowly? |
| Scroll Depth | Hotjar | > 60% scroll | If < 40%: Above-fold content not compelling? Price shock causing exit? |
| Add-to-Cart Rate | GA4 Enhanced E-Commerce | > 8% (from ad traffic) | If < 5%: Product info insufficient? Price not clear? No trust signals? |
| Cart-to-Purchase Rate | GA4 | > 40% | If < 30%: Checkout friction? Surprise shipping cost? Payment options limited? |
| Click Heatmaps | Hotjar | — | Identify what visitors click most/least — optimize CTA placement, image priority |
| Session Recording Review | Hotjar | Review 20 sessions/week | Watch real visitor behavior — where do they hesitate? What do they ignore? Where do they rage-click? |
| User Action | Meta Response | Pinterest Response | YouTube Response | Timing |
|---|---|---|---|---|
| Visited website (no action) | MOFU carousel ads — “Explore our collection” | Home decor inspiration pins (soft retarget) | Brand story pre-roll | Days 1–7 |
| Viewed product page | DPA — exact product + 3 similar | Shopping pin of viewed product | Product showcase bumper ad | Days 1–14 |
| Added to cart (no purchase) | DPA — carted product + “Still in your cart” urgency | Shopping pin with “Selling fast” | Retarget pre-roll: “Complete your order” | Days 1–7 |
| Abandoned checkout | DPA — “Don’t miss out” + free shipping incentive | Retarget pin: checkout-abandoned product | Bumper: “Free delivery today” | Days 1–3 (most urgent) |
| Purchased | Cross-sell carousel (complementary products) | “Complete the look” pins by room | Brand loyalty video, new arrivals | Days 14–60 |
| High engagement (IG/Pin) but no website visit | MOFU traffic ads — “Discover the collection” | Consideration campaign — product pins | Discovery ad — “Tour Our Workshop” video | Days 3–14 |
| Audience | Meta Cap | Pinterest Cap | YouTube Cap | Total Cross-Platform Cap |
|---|---|---|---|---|
| Cold (TOFU) | 2x/week | 3x/week | 2x/week | 7x/week |
| Warm (MOFU) | 3x/week | 4x/week | 2x/week | 9x/week |
| Hot (BOFU) | 5x/week | 3x/week | 3x/week | 11x/week |
| ATC/Checkout Abandoners | 7x/week | 4x/week | 3x/week | 14x/week |
| Past Customers | 2x/week | 2x/week | 1x/week | 5x/week |
| Dashboard Section | Metrics Displayed | Data Source | View |
|---|---|---|---|
| Executive Summary | Total ad spend, total revenue (attributed), blended ROAS, blended CPA, total orders from ads, AOV from ads | Triple Whale + GA4 | Daily, Weekly, Monthly, Custom |
| Platform Breakdown | Spend, revenue, ROAS, CPA, CTR, CPC — per platform (Meta, Pinterest, YouTube) | Platform APIs + Triple Whale | Weekly, Monthly |
| Funnel Performance | TOFU metrics (CPM, ThruPlay, reach), MOFU metrics (CTR, CPC, ATC rate), BOFU metrics (ROAS, CPA, conversion rate), Post-Purchase (repeat rate, cross-sell revenue) | Meta Ads Manager, Pinterest, YouTube, GA4 | Weekly |
| Campaign-Level Detail | Every campaign: spend, impressions, reach, clicks, CTR, CPC, conversions, CPA, ROAS, frequency | Platform APIs | Weekly |
| Creative Performance | Top 10 / Bottom 10 ad creatives ranked by ROAS — with thumbnail preview, creative type, copy angle, days live, frequency | Meta Ads Manager, manual log | Weekly |
| Audience Performance | Performance by audience segment: LAL type, interest, retargeting window — ROAS, CPA, saturation signals | Meta Ads Manager, Pinterest | Bi-weekly |
| Product Performance | Top 20 products by ad-attributed revenue (from DPA) — and bottom 20 (candidates for pausing) | Shopify + Triple Whale + Catalog Sales data | Monthly |
| Pinterest Specific | Pin performance, keyword performance, shopping ad ROAS, saves-to-clicks ratio, top boards | Pinterest Analytics + Ads Manager | Monthly |
| YouTube Specific | View rate, CPV, earned views, subscriber growth from ads, retargeting campaign ROAS | Google Ads + YouTube Analytics | Monthly |
| Attribution Analysis | First-click vs. last-click vs. data-driven attribution comparison — platform self-reported vs. Triple Whale vs. GA4 | Triple Whale + GA4 | Monthly |
| Budget vs. Actual | Planned budget allocation vs. actual spend — by platform, by funnel stage | Manual tracking | Monthly |
| Competitive Insights | Competitor ad creative changes (Meta Ad Library monitoring), estimated competitor spend changes, market trends | Manual research | Monthly |
| Season/Event | Timing | Campaign Theme | Budget Adjustment | Key Products |
|---|---|---|---|---|
| New Year / New Home | Jan 1–20 | “Start Fresh — Transform Your Space in 2025” | +30% (resolution energy + new home purchases) | Living room sets, bookshelves, desk/office |
| Valentine’s / Housewarming | Feb 1–14 | “Love Where You Live” — couples home styling | +15% | Bedroom decor, candles/lighting, cushions, planters |
| Summer Refresh | April–May | “Breathe New Life Into Every Room” — light, airy styling | Normal | Cotton rugs, planters, open shelving, light wood |
| Monsoon Cozy | July–Aug | “Make Monsoon Your Favorite Season” — warm, cozy home | Normal | Throws, warm lighting, reading corners, indoor gardens |
| Festive Season (Diwali) | Sep 15–Nov 15 | “Light Up Your Home” — biggest sale + gifting campaign | +60% (peak furniture buying) | All categories — biggest inventory push, gift bundles |
| Wedding Season | Nov–Feb | “Build Your First Home Together” — newlywed couples | +25% | Bedroom sets, dining tables, storage, full-room bundles |
| Christmas/Year-End | Dec 15–31 | “Deck Your Home” — year-end sale, gifting | +20% | Decor items, lighting, gift-friendly products |
| Republic Day Sale | Jan 20–26 | “Made in India, Made for You” — artisanal heritage | +15% | Handcrafted collections, artisan partnerships |
| Document | Purpose | Format |
|---|---|---|
| Ad Account Architecture Guide | Complete map of all campaigns, ad sets, audiences, naming conventions — so anyone can navigate the account | Notion wiki (30+ pages) |
| Audience Library | All custom and lookalike audiences with their source, size, performance history, and refresh schedule | Airtable database |
| Creative Library with Performance Data | Every ad creative ever tested — image/video file, copy variations, ROAS, CPA, CTR, status (active/paused/killed) | Google Drive (files) + Airtable (performance data) |
| Optimization Playbook | Daily/weekly/monthly optimization checklists, decision rules, scaling rules, kill criteria | Notion wiki |
| Testing Roadmap | Upcoming tests planned for next 3 months — what to test, why, expected impact | Notion roadmap |
| Seasonal Campaign Templates | Pre-built campaign structures, audience configurations, and creative briefs for each seasonal event | Notion + Canva templates |
| Reporting Template | Looker Studio dashboard + weekly/monthly report template | Looker Studio + Google Slides |
| Vendor & Tool Access | All platform logins, tool subscriptions, API keys, and third-party access documentation | Encrypted document |
| SOP — Crisis Playbook | What to do when: ad account gets flagged/disabled, ROAS drops below 2x suddenly, budget accidentally overspends, creative gets rejected | Notion SOP |
| Feature | Description |
|---|---|
| Complete Conversion Tracking Infrastructure | Meta Pixel (8 events), Conversions API, Pinterest Tag, Google Tag Manager, GA4 Enhanced E-Commerce, Triple Whale attribution, UTM framework, and offline conversion tracking — capturing 30–40% more data than browser-only tracking |
| 18-Audience Architecture | Custom audiences (website, customer, engagement), Lookalike audiences (5 seed types), interest-based audiences, Pinterest Actalikes and search retargeting, YouTube Custom Intent — segmented for precise funnel targeting |
| 4-Stage Full-Funnel Campaign System | TOFU (Awareness) → MOFU (Consideration) → BOFU (Conversion/Retargeting) → Post-Purchase (Retention) — with distinct objectives, audiences, creatives, and KPIs per stage |
| 3-Platform Paid Social Engine | Meta (60%), Pinterest (25%), YouTube (15%) — each with platform-native campaign structures, creative formats, and optimization strategies |
| 72 Initial Ad Creatives | Videos, carousels, static images, dynamic product ads, Pinterest Idea Pins, and YouTube pre-rolls — organized by funnel stage, with 3 copy variations each |
| Dynamic Product Ads (DPA) | 240+ product catalog synced from Shopify to Meta and Pinterest, segmented by room, category, and price range, with custom-designed catalog frames and automated retargeting rules |
| Monthly Creative Production System | 4-week cycle: Analysis → Production (15–20 new creatives) → Testing → Optimization — building a growing library of proven performers |
| Structured A/B Testing Framework | 8 test types (creative, copy, audience, format, landing page, placement, bid strategy, offer) with clear methodology, duration, budget, and decision criteria — producing 2–3 new proven winners monthly |
| Campaign Optimization Playbook | Daily (15-min checks), weekly (1-hour review), and monthly (3-hour audit) optimization procedures with specific decision rules for scaling, pausing, and troubleshooting |
| Cross-Platform Retargeting Orchestration | Coordinated retargeting across Meta, Pinterest, and YouTube — sequenced by user behavior (viewed → ATC → checkout → purchased) with platform-specific frequency caps |
| Ad-Specific Landing Page Strategy | 7 landing page types matched to ad campaign intent — with conversion element optimization and Hotjar-based behavioral analysis |
| Performance Reporting Dashboard | 12-section Looker Studio dashboard covering executive summary, platform breakdown, funnel analysis, creative/audience/product performance, attribution, budget tracking, and competitive insights |
| Seasonal Campaign Calendar & Templates | 8 seasonal campaigns with pre-built structures, audience configurations, budget adjustments, and creative briefs — ready to activate each season |
| Scaling Framework | 7 scaling methods (vertical, horizontal by audience/platform/placement/creative, offer scaling, geographic expansion) with specific triggers and risk levels |
| Complete Handover Documentation | 9-document knowledge base covering account architecture, audience library, creative library, optimization playbook, testing roadmap, seasonal templates, reporting, access management, and crisis playbook |
| Metric | Before | After (Month 6) | Change |
|---|---|---|---|
| Monthly Ad Spend | ₹3,00,000 (Meta only) | ₹5,00,000 (Meta + Pinterest + YouTube) | ⬆ 67% (strategic increase) |
| Monthly Ad-Attributed Revenue | ₹4,80,000 (1.6x ROAS) | ₹34,00,000 (6.8x blended ROAS) | ⬆ 608% |
| Blended ROAS | 1.6x | 6.8x | ⬆ 325% |
| Meta ROAS | 1.6x | 7.2x | ⬆ 350% |
| Pinterest ROAS | N/A (not used) | 5.8x | — |
| YouTube ROAS | N/A (not used) | 4.2x | — |
| Cost Per Acquisition (CPA) | ₹2,800 | ₹680 | ⬇ 76% |
| Overall CPA (All Channels Blended) | ₹1,850 | ₹710 | ⬇ 62% |
| Click-Through Rate (Meta) | 0.6% | 2.4% | ⬆ 300% |
| Cost Per Click (Meta) | ₹18.40 | ₹5.80 | ⬇ 68% |
| Conversion Rate (Ad Click → Purchase) | 0.8% | 3.6% | ⬆ 350% |
| Average Order Value (Ad Traffic) | ₹4,500 | ₹6,200 (cross-sell & bundle effect) | ⬆ 38% |
| BOFU Retargeting ROAS | N/A (no retargeting existed) | 12.4x | — |
| DPA (Dynamic Product Ads) ROAS | N/A (not used) | 9.6x | — |
| Pinterest-Attributed Revenue | ₹0 | ₹7,25,000/month | — |
| YouTube-Attributed Revenue | ₹0 | ₹3,15,000/month | — |
| Ad Creative CTR (Video vs. Previous Static) | 0.6% (static only) | 3.1% (video), 1.8% (static refresh) | Video: ⬆ 417% |
| Ad Frequency (BOFU) | 8.4 | 2.8 (managed with creative rotation) | ⬇ 67% |
| Cart Abandonment Recovery Rate (via retargeting) | 0% (no retargeting) | 14.2% of abandoners converted via retargeting | — |
| New Customers from Paid Social (Monthly) | ~170 | 735 | ⬆ 332% |
| Repeat Purchase Rate (ad-acquired customers) | 12% | 28% (driven by post-purchase campaigns) | ⬆ 133% |
| Total 6-Month Ad-Attributed Revenue | ₹67,20,000 (14 months) | ₹1,84,00,000 (6 months) | ⬆ 174% in less than half the time |
| Profit from Ad Channel | Negative (losing money per acquisition) | ₹52,40,000 gross profit (after COGS, shipping, ad spend) | — |
| Ad Creatives Tested (Cumulative) | 5 (never changed) | 180+ (systematic testing) | — |
| Proven Winner Creatives in Library | 0 (no testing) | 42 (with performance data) | — |
Challenge: NestCraft Living — a D2C furniture and home decor brand with 240+ products and 4.5-star reviews — had spent ₹42L on paid social over 14 months with a 1.6x ROAS, losing money on every ad-acquired customer. Their “strategy” was boosting Instagram posts with no funnel structure, no retargeting, no dynamic product ads, no Pinterest or YouTube presence, 5 stale ad creatives running for 8 months, misconfigured conversion tracking, and no budget allocation framework. Competitors like Wakefit and Urban Ladder were scaling at 5–7x ROAS while NestCraft bled money.
Solution: We built a complete social media advertising system — overhauling conversion tracking (Meta Pixel, CAPI, Pinterest Tag, GTM, GA4, Triple Whale); creating an 18-audience architecture with custom, lookalike, interest, and platform-specific audiences; designing a 4-stage full-funnel campaign system (Awareness → Consideration → Conversion → Retention) across Meta (60%), Pinterest (25%), and YouTube (15%); producing 72 initial ad creatives including video, carousels, and dynamic product ads; implementing a monthly creative production and A/B testing system; building a campaign optimization playbook with daily/weekly/monthly procedures; orchestrating cross-platform retargeting with frequency caps; optimizing landing pages with Hotjar behavioral analysis; and creating a 12-section performance dashboard with seasonal campaign calendar and complete handover documentation.
Result: In 6 months, blended ROAS jumped from 1.6x to 6.8x. CPA dropped 76% (₹2,800 → ₹680). Overall CPA across all channels fell 62%. Monthly ad-attributed revenue grew 608% (₹4.8L → ₹34L). Total 6-month ad-attributed revenue reached ₹1.84Cr. Meta ROAS hit 7.2x, Pinterest contributed ₹7.25L/month at 5.8x ROAS, and YouTube added ₹3.15L/month. BOFU retargeting alone achieved 12.4x ROAS. Video ad CTR was 417% higher than previous static ads. The ad channel went from losing money to generating ₹52.4L gross profit. NestCraft’s paid social transformed from their weakest channel into their primary scalable revenue driver.
We designed and launched a complete influencer and UGC coordination program for PureRoots Naturals — building a network of 180+ vetted creators, generating 420+ authentic content pieces in 6 months, reducing customer acquisition cost by 54%, and turning real customers into the brand’s most powerful marketing channel.
| Client Name | PureRoots Naturals (Showcase Project) |
| Industry | Beauty & Skincare / Direct-to-Consumer (D2C) |
| Project Duration | 6 Weeks |
| Services Delivered | Influencer Strategy & Tier Framework, Influencer Discovery & Vetting System, UGC Program Design & Creator Onboarding, Campaign Brief & Guidelines Development, Influencer CRM & Relationship Management, Content Rights & Licensing Framework, UGC Collection & Curation Pipeline, Influencer Content Amplification Strategy, Performance Tracking & ROI Attribution, Brand Ambassador Program Design |
| Tools & Platforms Used | Notion, Airtable, Modash, HypeAuditor, Instagram, TikTok, YouTube, Google Sheets, Canva Pro, Google Drive, Zapier, Slack, Later (scheduling), Shopify (affiliate tracking), UpPromote (affiliate/ambassador), ChatGPT API (OpenAI), Typeform, Loom, WhatsApp Business, Gmail (outreach sequences) |
| Project Year | 2025 |
PureRoots Naturals is a D2C Ayurvedic skincare brand, offering a curated range of 18 products — from kumkumadi face serums and turmeric body scrubs to neem-tulsi cleansers and saffron night creams. Every product uses clinically-tested Ayurvedic formulations, sustainably sourced ingredients, and eco-friendly packaging. Their products are genuinely excellent — 4.6-star average across 3,200+ reviews on their Shopify store.
But PureRoots had a visibility problem. In India’s hyper-competitive D2C skincare space — where Mamaearth, mCaffeine, Plum, and Dot & Key spend crores on influencer partnerships — PureRoots was invisible. Their products were better than half the “viral” brands on Instagram, but nobody was talking about them. No unboxing videos. No “get ready with me” features. No dermatologist reviews. No before-and-after transformations.
They’d attempted influencer marketing twice. The first time, they sent free products to 50 Instagram accounts with over 100K followers. Result: 4 posted (out of 50), the posts looked like ads, engagement was terrible, and they couldn’t track a single sale. The second time, they paid ₹2.5 lakh to a single macro-influencer with 800K followers. The Reel got 45K views but generated exactly 11 website visits and 0 orders. Total ROI: negative ₹2.5 lakh.
PureRoots was doing what most brands do — treating influencer marketing as “send products and pray” or “pay one big influencer and hope it works.” Both approaches are fundamentally flawed. Influencer marketing is a system, not a gamble. UGC is a pipeline, not an accident.
We built a complete influencer and UGC coordination program — from tiered influencer strategy and creator vetting to campaign briefs, content rights management, UGC collection pipelines, brand ambassador programs, and ROI attribution — transforming PureRoots from invisible to omnipresent in India’s skincare conversation, powered by authentic voices, not ad spend.
| Past Attempt | Investment | Result | Problem |
|---|---|---|---|
| Free Product Seeding (50 influencers) | ₹1.2L (products + shipping) | 4 posted (8% post rate), generic content, no trackable sales | No vetting, no brief, no follow-up, no relationship building — just “spray and pray” |
| Macro-Influencer Paid Post | ₹2.5L (single Reel) | 45K views, 11 website visits, 0 orders | Audience mismatch (fashion influencer, not skincare), scripted content felt inauthentic, no CTA optimization, no affiliate tracking |
| TOTAL | ₹3.7L invested | ~0 measurable revenue | No strategy, no system, no measurement |
| Competitor | Monthly Influencer Collabs | UGC Volume | Ambassador Program | PureRoots Gap |
|---|---|---|---|---|
| Mamaearth | 200+ influencer posts/month | Massive organic UGC | 500+ ambassadors | PureRoots: 0 monthly influencer posts |
| mCaffeine | 150+ influencer posts/month | Strong unboxing culture | Active affiliate program | PureRoots: No affiliate system |
| Plum Goodness | 80+ influencer posts/month | High skincare routine UGC | Micro-influencer network | PureRoots: No creator network |
| Dot & Key | 60+ influencer posts/month | Growing TikTok presence | Dermatologist partnerships | PureRoots: No expert partnerships |
| Tier | Follower Range | Role in Strategy | Content Type | Compensation Model | Monthly Volume Target |
|---|---|---|---|---|---|
| Tier 1 — Nano Creators | 1K–10K | Authentic social proof, high engagement, niche community trust | Product reviews, “morning routine” features, honest testimonials | Free products + exclusive discount code | 40–50 creators/month |
| Tier 2 — Micro Influencers | 10K–50K | Targeted reach, strong conversion, audience trust | Detailed reviews, GRWM (Get Ready With Me), “1 week using PureRoots” series, before/after | Free products + ₹3,000–₹8,000 per deliverable | 15–20 creators/month |
| Tier 3 — Mid-Tier Influencers | 50K–200K | Awareness + credibility, content quality, trend participation | Campaign hero content, tutorials, “skincare routine overhaul,” brand storytelling | ₹15,000–₹50,000 per campaign + products | 5–8 creators/month |
| Tier 4 — Macro/Expert Voices | 200K+ or niche experts | Authority positioning, brand credibility, PR moments | Expert reviews (dermatologists, Ayurvedic practitioners), in-depth ingredient analysis | ₹50,000–₹1,50,000 per campaign + products + long-term partnership | 2–3 creators/quarter |
| Tier 5 — Brand Ambassadors | Any size (loyalty-based) | Ongoing authentic advocacy, repeat content, community building | Monthly content (1 Reel + 2 Stories), exclusive launches, affiliate promotion | Monthly product box + 15% affiliate commission + early access | 25–30 active ambassadors (ongoing) |
| Persona | Description | Platform Focus | Content Style | Why They Work for PureRoots |
|---|---|---|---|---|
| The Skincare Enthusiast | 20–35, obsessed with skincare routines, product reviews, ingredient analysis, shelfie posts | Instagram + YouTube | Detailed, educational, ingredient-focused | Adds credibility; their audience actively seeks product recommendations |
| The Ayurveda/Wellness Advocate | 25–45, promotes natural/Ayurvedic/clean beauty lifestyle, holistic wellness | Instagram + YouTube | Lifestyle-integrated, value-aligned, philosophical | Perfect brand alignment; audience already believes in Ayurvedic efficacy |
| The Relatable Daily Creator | 22–30, shares daily life — GRWM, day-in-my-life, unboxing, honest product opinions | Instagram Reels + TikTok | Casual, honest, “girl-next-door” authenticity | High trust factor; content feels like a friend’s recommendation, not an ad |
| The Dermatologist/Expert | Licensed dermatologist, Ayurvedic practitioner, cosmetic chemist | YouTube + Instagram | Clinical, science-backed, ingredient breakdown | Adds medical/scientific authority; counters “is Ayurvedic skincare legit?” skepticism |
| The Mom/Family Creator | 28–40, mom life content, family-friendly, “products I trust for my family” | Instagram + Facebook | Trust-focused, safety-conscious, practical | PureRoots’ natural/safe positioning resonates deeply with conscious moms |
| The Regional/Vernacular Creator | Any age, creates in Tamil, Telugu, Hindi, Kannada | Instagram Reels + YouTube Shorts + TikTok | Vernacular, culturally connected, regional reach | Expands beyond English-speaking metros into Tier 2/3 cities |
| Month | Campaign Theme | Objective | Key Influencer Tier | Content Focus |
|---|---|---|---|---|
| Month 1 | “PureRoots Unboxed” — Launch seeding wave | Generate initial content library, build creator relationships | Tier 1 (Nano) + Tier 2 (Micro) | Unboxing, first impressions, product showcase |
| Month 2 | “7-Day Glow Challenge” — Transformation campaign | Drive conversion with before/after proof | Tier 2 (Micro) + Tier 3 (Mid-Tier) | 7-day usage diary, before/after, daily check-ins |
| Month 3 | “Ayurveda Meets Science” — Expert validation wave | Build credibility and address skepticism | Tier 4 (Expert) + Tier 2 (Micro) | Ingredient analysis, dermatologist review, expert Q&A |
| Month 4 | “Summer Skin Rescue” — Seasonal campaign | Seasonal relevance, drive summer product sales | Tier 1–3 (all) | Summer skincare routines, sunscreen + serum combos, travel skincare kits |
| Month 5 | “Real Skin, Real Stories” — UGC amplification | Social proof at scale, build community | Tier 5 (Ambassadors) + UGC customers | Customer testimonials, long-term users, “my PureRoots journey” |
| Month 6 | “PureRoots Awards” — Creator appreciation + new launch | Retention, relationship deepening, launch activation | All tiers | Creator awards/features, new product exclusive access, behind-the-scenes |
| Discovery Method | Tools Used | Volume | Process |
|---|---|---|---|
| Hashtag Mining | Instagram/TikTok search — #AyurvedicSkincare, #NaturalBeautyIndia, #SkincareRoutineIndia, #CleanBeauty, #IndianSkincare + 40 more niche hashtags | Discover 200+ potential creators/month | Search → Review profile → Initial quality check → Add to discovery pipeline |
| Competitor Audience Analysis | HypeAuditor, Modash — Analyze who posts about Mamaearth, Plum, Forest Essentials | Identify 100+ creators already in the skincare space | Cross-reference engagement rates, audience demographics, content quality |
| Platform Discovery Tools | Modash (search by niche, location, audience demographics, engagement rate) | Filtered search for Indian skincare/beauty creators with 1K–200K followers | Set filters → Review profiles → Score → Shortlist |
| Existing Customer Mining | Shopify customer list → Cross-reference Instagram handles → Identify customers who create content | Find 50+ existing customers with active social presence | Match email → Find IG/TikTok → Review content → Invite to ambassador program |
| Inbound Creator Applications | Typeform application on website (“Become a PureRoots Creator”) | Ongoing — target 30+ applications/month | Promote application link → Review submissions → Vet → Onboard accepted creators |
| Community & Comment Mining | Monitor comments on PureRoots posts + competitor posts for engaged skincare enthusiasts | Ongoing passive discovery | Identify highly engaged commenters → Review their profiles → Invite |
| Criteria | Weight | Scoring Details | Tool/Method |
|---|---|---|---|
| Engagement Rate | 20 pts | 1–2%: 5pts, 2–4%: 10pts, 4–6%: 15pts, 6%+: 20pts | HypeAuditor / Manual calculation |
| Audience Authenticity | 20 pts | Fake follower check — <5% fake: 20pts, 5–15%: 10pts, >15%: 0pts (disqualified) | HypeAuditor / Modash |
| Content Quality | 15 pts | Lighting, composition, editing, caption quality — reviewed manually across last 20 posts | Manual review |
| Audience Demographics Match | 15 pts | % of audience matching PureRoots’ target (India, 20–40, female, interested in skincare/beauty/wellness) | HypeAuditor audience demographics |
| Niche Relevance | 10 pts | Skincare/beauty/wellness content as % of total posts — 80%+: 10pts, 50–80%: 7pts, <50%: 3pts | Manual content audit |
| Brand Safety | 10 pts | Review for controversial content, competitor exclusivity conflicts, brand value alignment | Manual review of last 3 months |
| Posting Consistency | 5 pts | Regular posting schedule (3+ posts/week): 5pts, irregular: 2pts, dormant: 0pts | Manual review |
| Previous Brand Collaboration Quality | 5 pts | How do their sponsored posts look? Authentic or obviously forced? Professional or sloppy? | Review tagged brand collaborations |
| TOTAL | 100 pts | Minimum score to proceed: 65/100 (Tier 1–2), 75/100 (Tier 3–4) | Airtable scorecard |
| Outreach Stage | Channel | Message Framework | Timing |
|---|---|---|---|
| Stage 1 — Warm-Up | Instagram (follow + engage with 3–5 of their posts over 1 week) | Genuine comments on their content — not “love this!” but thoughtful, specific engagement | 7 days before outreach |
| Stage 2 — Initial DM | Instagram DM or Email | Personalized message: Reference specific content of theirs → Introduce PureRoots → Express why they’d be a great fit → Soft ask: “Would you be open to exploring a collaboration?” | Day 8 |
| Stage 3 — Follow-Up | Same channel as Stage 2 | Friendly follow-up: “Just wanted to bump this in case it got buried — would love to chat!” | Day 12 (if no response) |
| Stage 4 — Value-Add Follow-Up | Email (if DM unsuccessful) | Send a small value — “I saw your post about [topic], thought you might find this Ayurvedic skincare guide interesting” + reiterate collaboration interest | Day 18 (if still no response) |
| Stage 5 — Final Touch | Instagram DM | Brief, no-pressure: “Totally understand if the timing isn’t right! Our door is always open. Wishing you the best with your content 🌿” | Day 25 (if no response — close loop gracefully) |
| Metric | Target |
|---|---|
| DM/Email Open Rate | 70%+ |
| Response Rate (any response) | 35–40% |
| Positive Interest Rate | 25–30% |
| Confirmed Collaboration Rate | 18–22% |
| Content Delivery Rate (of confirmed) | 85–90% |
| CRM Field | Purpose | Data Tracked |
|---|---|---|
| Creator Profile | Identity & contact | Name, handle, platforms, email, phone, location, bio, profile photo |
| Audience Data | Audience fit | Follower count, engagement rate, audience demographics (age, gender, location), fake follower % |
| Vetting Score | Quality assessment | 100-point scorecard result, notes, red flags |
| Relationship Stage | Pipeline tracking | Discovery → Warm-Up → Outreach → Negotiation → Confirmed → Product Sent → Content Received → Published → Review → Re-engage |
| Campaign Assignment | Campaign tracking | Which campaign, deliverables agreed, deadline, brief sent (Y/N), content approved (Y/N) |
| Compensation | Financial tracking | Product value sent, cash payment, affiliate commission earned, total investment |
| Content Log | Asset tracking | Links to all content posted, content type, platform, date posted, engagement metrics |
| Performance History | ROI tracking | Impressions, engagement, clicks (via UTM/affiliate link), conversions, revenue generated, cost per acquisition |
| Relationship Notes | Human connection | Personal notes — birthday, preferences, communication style, special interests, feedback given/received |
| Status | Current standing | Active, Paused, Completed, Do Not Re-engage, Ambassador, Waitlist |
| UGC Stream | Source | Collection Method | Volume Target | Content Type |
|---|---|---|---|---|
| Stream 1 — Organic Customer UGC | Existing customers who post about PureRoots naturally | Hashtag monitoring (#PureRootsNaturals, #PureRootsGlow), tagged post alerts, DM-based outreach for usage rights | 30–40 pieces/month | Shelfies, routine videos, text reviews with photos, before/after |
| Stream 2 — Prompted Customer UGC | Customers encouraged to create via post-purchase email, packaging insert, in-app prompt | Post-purchase email sequence (Day 14: “Share your glow!”), QR code on packaging, loyalty points for UGC | 50–60 pieces/month | Photo reviews, short video testimonials, “unboxing + first impression” |
| Stream 3 — Creator UGC (Paid/Gifted) | Influencer Tiers 1–3 — content created as part of collaboration | Campaign briefs, gifted products, paid partnerships — content collected via Google Drive upload | 60–80 pieces/month | Professional-quality reviews, tutorials, GRWM, before/after, ingredient deep-dives |
| Stream 4 — Ambassador UGC | Brand ambassadors creating ongoing monthly content | Ambassador program guidelines, monthly content deliverables, affiliate incentive | 30–40 pieces/month | Monthly Reels, Stories, ongoing usage documentation, seasonal content |
| TOTAL | 170–220 UGC pieces/month |
POST-PURCHASE UGC EMAIL SEQUENCE
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
EMAIL 1 — Day 3 (Post-Delivery):
Subject: "Your PureRoots ritual begins 🌿"
Content: Welcome + how to use your product + link to tutorial video
CTA: None (value only — don't ask for anything yet)
EMAIL 2 — Day 10 (Early Results):
Subject: "Noticing a difference yet? ✨"
Content: "By now, your skin is absorbing the goodness..."
+ Link to other customers' before/after stories
CTA: Soft — "We'd love to hear how it's going! Reply to this email."
EMAIL 3 — Day 14 (UGC Ask):
Subject: "Share your glow, earn rewards 📸"
Content: "Your skin story matters! Share a photo or video of your
PureRoots routine and earn 200 loyalty points (₹200 value)."
CTA: "Upload your content here" → Typeform with photo/video upload
+ "Or post on Instagram with #PureRootsGlow and tag @pureroots"
EMAIL 4 — Day 21 (Review Ask):
Subject: "Quick question about your experience"
Content: Direct ask for product review on website
CTA: "Leave a review" → Shopify product review page
EMAIL 5 — Day 30 (Testimonial Ask — for high-rating reviewers):
Subject: "Would you share your story on video? 🎥"
Content: "Your review was amazing! Would you be open to recording a
quick 30-second video testimonial? We'll feature you on our page
+ send you a surprise gift!"
CTA: "Yes, I'm in!" → Loom recording link or WhatsApp video submission
AUTOMATION: Zapier triggers based on Shopify order status + timing
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Element | Details |
|---|---|
| Front | “Your glow deserves to be seen 🌿” — warm, inviting design with brand colors |
| Back — Instructions | “Share your PureRoots moment: 1️⃣ Snap a photo or record a short video 2️⃣ Tag @pureroots + #PureRootsGlow 3️⃣ Earn 200 loyalty points + chance to be featured!” |
| QR Code | Links to Typeform UGC submission form (for customers not on Instagram) |
| Incentive | 200 loyalty points (₹200 value) + monthly “Featured Creator” spotlight on PureRoots’ Instagram (10K+ audience exposure) |
| Kit Component | Format | Contents |
|---|---|---|
| Welcome Guide | PDF (12 pages, beautifully designed) | Brand story, mission, values, target audience, product range overview, why we chose them, what to expect |
| Brand Guidelines (Social) | PDF (6 pages) | Color palette, tone of voice, hashtags to use, tags, do’s and don’ts, visual style examples |
| Campaign Brief | Notion page (campaign-specific) | Campaign name, objective, key messages, content deliverables, format requirements, deadlines, examples of great content, dos/don’ts |
| Product Information Sheet | PDF (per product sent) | Key ingredients, benefits, how to use, hero claims, what makes it unique, talking points (not a script — talking points) |
| Content Examples | Google Drive folder | 15–20 examples of excellent influencer content (from other brands/campaigns) showing the style, authenticity, and quality level desired |
| Hashtag & Tagging Guide | 1-page PDF | Primary hashtags (#PureRootsNaturals, #PureRootsGlow, #AyurvedicSkincare), tag @pureroots, location tags, campaign-specific hashtags |
| Affiliate/Discount Code | Unique per creator | “CREATOR-NAME15” — 15% discount for their audience, tracked via UpPromote for commission attribution |
| Content Submission Instructions | Loom video walkthrough (3 min) | How to upload content drafts to Google Drive for approval before posting (Tier 3–4 only), how to submit final links |
| FAQ Document | PDF (2 pages) | Common questions: shipping timeline, content revision policy, payment terms, usage rights summary, who to contact for help |
| Brief Section | Details Provided |
|---|---|
| Campaign Name | e.g., “7-Day Glow Challenge — Kumkumadi Serum” |
| Campaign Objective | Drive awareness + conversions for Kumkumadi Face Serum through authentic 7-day usage documentation |
| Key Messages (NOT Scripts) | 3–4 talking points: “Made with real saffron & kumkumadi tailam,” “Visible glow in 7 days,” “Ayurvedic formulation backed by clinical testing,” “Lightweight, non-greasy, works for Indian skin” — creators express these in their own words |
| Content Deliverables | 1 Instagram Reel (60–90 sec, 7-day journey or before/after), 3 Instagram Stories (Day 1, Day 4, Day 7 check-ins), 1 TikTok (15–30 sec, before/after or “watch my skin transform”) |
| Content Do’s | ✅ Use the product genuinely for 7 days before creating final content. ✅ Show real skin — no heavy filters or beauty mode. ✅ Be honest — mention what you genuinely liked. ✅ Good natural lighting. ✅ Show the product packaging clearly at least once. ✅ Include your unique discount code in caption. |
| Content Don’ts | ❌ No scripted or robotic-sounding endorsements. ❌ No claims we haven’t approved (“cures acne” etc.). ❌ No heavy filters that alter skin appearance. ❌ Don’t tag competitor brands. ❌ Don’t use copyrighted music. ❌ Don’t post without approval (Tier 3–4). |
| Content Examples | Links to 5 example videos showing desired style — authentic, well-lit, genuine reaction, casual but polished |
| Timeline | Products shipped: [Date] → Usage period: 7 days → Draft submission: [Date] → Feedback/approval: 48 hours → Post by: [Date] → Stories: Days 1, 4, 7 |
| Compensation | Products (worth ₹X) + Cash fee (₹X) + Affiliate code (15% commission on sales) |
| Usage Rights | PureRoots may repost on brand channels, use in paid ads (6 months), feature on website. Creator retains ownership and can keep on their profile. |
| Stage | Process | Timeline | Tool |
|---|---|---|---|
| Draft Submission | Creator uploads draft content (video/image + caption) to campaign-specific Google Drive folder | By agreed deadline | Google Drive + Slack notification |
| Quality Review | Content manager reviews against brief: messaging accuracy, visual quality, brand guideline compliance, disclosure compliance (paid partnership label) | Within 24 hours | Checklist in Airtable |
| Feedback (if needed) | Specific, constructive feedback sent via preferred channel — “Love the opening! Could you adjust the lighting on the product close-up? And add your discount code to the caption?” | Within 24 hours of submission | Slack DM / WhatsApp / Email |
| Approval | Confirmed “approved to post” with suggested posting time based on audience analytics | Within 48 hours of submission | Slack confirmation + Airtable status update |
| Publication Confirmation | Creator posts → sends link → content manager verifies live post matches approved draft | Within posting window | Creator sends link → Airtable log |
| Asset Collection | High-resolution content files downloaded and added to UGC asset library | Within 24 hours of posting | Google Drive — organized by creator, campaign, content type |
| Right | Tier 1 (Nano) | Tier 2 (Micro) | Tier 3 (Mid) | Tier 4 (Macro/Expert) | Tier 5 (Ambassador) |
|---|---|---|---|---|---|
| Repost on PureRoots social | ✅ Included (with credit) | ✅ Included (with credit) | ✅ Included (with credit) | ✅ Included (with credit) | ✅ Included (with credit) |
| Use in paid social ads | ✅ 6 months (included in gifting agreement) | ✅ 6 months (included in compensation) | ✅ 6 months (negotiated, +20% fee for ad usage) | ⚠️ Negotiated separately — 3 months, additional fee | ✅ 12 months (included in ambassador agreement) |
| Feature on website | ✅ Included | ✅ Included | ✅ Included | ✅ Included | ✅ Included |
| Use in email marketing | ✅ Included | ✅ Included | ✅ Included | ⚠️ Additional permission needed | ✅ Included |
| Use in print/offline | ❌ Not included | ❌ Not included | ⚠️ Negotiated separately | ⚠️ Negotiated separately | ⚠️ Case-by-case |
| Exclusivity period | None | None | 30 days (can’t post competitor skincare) | 60–90 days (negotiated) | Ongoing during ambassadorship |
| Content ownership | Creator retains | Creator retains | Creator retains | Creator retains | Creator retains |
| UGC Use Case | How Content Is Repurposed | Platform/Channel | Monthly Volume |
|---|---|---|---|
| Social Proof Repost | Creator’s Reel/post reposted on PureRoots’ Instagram/TikTok with credit tag and branded frame | Instagram Feed, TikTok, Facebook | 15–20 reposts/month |
| Story Features | Creator content shared to PureRoots’ Instagram Stories with “See what @creator says about our Kumkumadi Serum!” overlay | Instagram Stories | 25–30 stories/month |
| UGC Ad Creatives | Best-performing creator content turned into paid ad creatives — “real customers, real results” format | Meta Ads, TikTok Ads | 8–12 ad creatives/month |
| Website Testimonials | Video testimonials and photo reviews embedded on product pages and dedicated “Real Results” page | Shopify product pages, /results page | Evergreen — updated monthly |
| Email Marketing | UGC photos and quotes included in email campaigns — “See what [Name] says about this product” | Klaviyo email campaigns | 4–6 emails/month featuring UGC |
| Product Page Social Proof | Instagram feed embed on product pages showing real customer photos using that specific product | Shopify product pages | Evergreen embed — auto-updates |
| Compilation Reels | Monthly “Best of UGC” compilation — 10–15 clips from different creators edited into one showcase Reel | Instagram Reels, TikTok, YouTube Shorts | 2 compilations/month |
| Pitch & PR Deck | Best UGC included in investor/retail pitch deck — “our customers are our best marketers” | PDF/presentation | Updated quarterly |
| Amplification Method | Process | Budget Allocation |
|---|---|---|
| Organic Reposting | Best creator content reposted on PureRoots’ channels with credit — extends reach to brand’s audience | ₹0 (organic) |
| Paid Whitelisting (Spark Ads / Partnership Ads) | Top-performing creator content boosted as paid ads directly from the creator’s handle — appears as native content, not brand ad | 40% of monthly influencer ad budget |
| Dark Posting | Creator content used as ad creative under PureRoots’ ad account — reaches beyond creator’s audience with brand targeting | 35% of monthly influencer ad budget |
| Creator Collaboration Post | Instagram “Collab” feature — post appears on both brand and creator’s feed simultaneously | ₹0 (organic) |
| Story Reshare Chain | When creator posts → PureRoots reshares to Stories → Other creators reshare PureRoots’ reshare → Snowball effect | ₹0 (organic) |
| Best-Performer Retainer | Creators whose content performs exceptionally well get offered ongoing monthly retainer — guaranteed continued high-performing content | 25% of monthly influencer ad budget |
| Metric | Tier 1 (Nano) Target | Tier 2 (Micro) Target | Tier 3 (Mid) Target | Tier 4 (Macro) Target |
|---|---|---|---|---|
| Engagement Rate | 6%+ | 4%+ | 3%+ | 2%+ |
| View-Through Rate (Reels) | 40%+ | 35%+ | 25%+ | 20%+ |
| Click-Through (Affiliate Link) | 2%+ | 1.5%+ | 1%+ | 0.8%+ |
| Conversion Rate (Link → Sale) | 4%+ | 3%+ | 2%+ | 1.5%+ |
| Cost Per Acquisition | <₹250 | <₹400 | <₹600 | <₹1,000 |
| Content Quality Score (1–10) | 6+ | 7+ | 8+ | 9+ |
| Response to Reuse in Ads | CTR 2%+ when used as ad creative | CTR 2.5%+ | CTR 3%+ | CTR 3.5%+ |
| Program Element | Details |
|---|---|
| Program Name | PureRoots Glow Collective |
| Selection Criteria | Existing collaborators who: scored 80+ on vetting, delivered 2+ successful campaigns, demonstrated genuine brand affinity, audience engagement above tier average |
| Application Process | Invite-only (from top performers) or application via website (evaluated against criteria) |
| Cohort Size | 25–30 ambassadors per cohort, refreshed quarterly |
| Monthly Commitment | 1 Instagram Reel or TikTok (60 sec+), 2 Instagram Stories, 1 product review/testimonial update |
| Compensation | Monthly product box (₹2,500 value — new launches + favorites), 15% affiliate commission on all sales via unique code, early access to new products (2 weeks before public launch), exclusive “Glow Collective” community access (WhatsApp group + quarterly virtual meetup), annual “PureRoots Creator Retreat” (top 10 performers), featured on PureRoots website “Our Creators” page |
| Tracking | UpPromote — unique affiliate link + discount code per ambassador, monthly dashboard showing: clicks, orders, revenue, commission earned |
| Content Guidelines | Lighter than campaign briefs — ambassadors know the brand, follow general guidelines, post authentic content. No pre-approval required. Monthly theme suggestions (not mandates). |
| Recognition Tiers | 🌱 Seed (0–10 sales/month): Base benefits, 🌿 Sprout (11–25 sales): +Bonus product, 🌳 Bloom (26–50 sales): +Cash bonus ₹5,000, 🌺 Flourish (50+ sales): +₹10,000 bonus + Creator Retreat invite |
| Offboarding | Ambassadors who don’t meet minimum content commitment for 2 consecutive months are gently transitioned out with appreciation — “doors always open” messaging |
| Dashboard Section | Metrics Tracked | Review Frequency |
|---|---|---|
| Campaign Overview | Active campaigns, total creators engaged, content pieces delivered vs. target, budget spent vs. allocated | Weekly |
| Creator Performance Leaderboard | Top 10 creators by: engagement generated, clicks driven, sales attributed, content quality score | Monthly |
| Content Library Growth | Total UGC pieces collected (cumulative), pieces by type (photo/video/review), pieces by source (organic/prompted/creator/ambassador) | Monthly |
| Revenue Attribution | Total revenue from influencer affiliate codes, total revenue from UGC-based ads, blended CPA across all influencer tiers, ROAS (Return on Ad Spend) for UGC ad creatives | Monthly |
| Pipeline Health | Creator pipeline: discovery → outreach → confirmed → content received (conversion rates at each stage), response rates, average time from outreach to content live | Monthly |
| Platform Performance | Best-performing platform for influencer content (Instagram vs. TikTok vs. YouTube), best content format, best posting time | Monthly |
| Ambassador Program | Active ambassadors, monthly content delivery rate, total affiliate revenue, top 5 ambassadors, churn rate | Monthly |
| Content Repurposing ROI | UGC pieces repurposed as ads — CPA comparison vs. brand-produced ad creatives, CTR comparison, conversion comparison | Monthly |
| Relationship Health | Creator satisfaction (quarterly survey), average response time to creators, repeat collaboration rate, ambassador retention rate | Quarterly |
| Touchpoint | Frequency | Action | Purpose |
|---|---|---|---|
| Post-Campaign Thank You | After every campaign | Personalized thank you message + highlight of what we loved about their content | Appreciation, relationship building |
| Performance Share | Monthly (for ambassadors), post-campaign (for others) | “Your content generated X views, Y clicks, and Z sales! You’re amazing!” — share results transparently | Transparency, motivation |
| Birthday/Anniversary | Annual | Send a surprise product bundle + handwritten note on their birthday or collaboration anniversary | Personal connection |
| New Product Early Access | Per launch (6–8x/year) | Send new products 2 weeks before public launch — “You’re the first to try this!” | Exclusivity, excitement |
| Creator Spotlight | Monthly | Feature top creator on PureRoots’ Instagram Feed + Stories + email newsletter — “Creator of the Month” | Recognition, social proof for creator |
| Feedback Loop | Quarterly | Short survey: “How’s your experience working with PureRoots? What can we improve?” | Continuous improvement, voice |
| Quarterly Virtual Meetup | Quarterly | Zoom meetup: brand updates, upcoming campaigns preview, creator Q&A, networking among creators | Community building |
| Annual Creator Retreat | Annual | In-person event for top 10 performers: brand headquarters visit, product development input session, content creation day, dinner | Deep loyalty, advocacy |
| Compliance Area | Requirement | How We Ensure It |
|---|---|---|
| ASCI Guidelines | All paid partnerships must include clear disclosure — “#ad,” “#sponsored,” or “Paid partnership with @pureroots” | Required in campaign brief, checked during content review, flagged if missing |
| Claims Compliance | Creators cannot make medical/drug claims (“cures acne,” “anti-aging guaranteed”) — only approved benefit language | Approved talking points in brief, prohibited claims list, review process catches violations |
| Content Rights | Written agreement for content usage rights before any repurposing | Typeform agreement signed before product shipment |
| FTC/ASCI Disclosure | Disclosure must be immediately visible (not buried in hashtags) — “Paid partnership” label on Instagram, #ad in first line of caption | Brief requirement, review checklist, post-publication audit |
| Competitor Exclusivity | Tier 3–4 creators cannot post competitor skincare content during exclusivity period | Documented in collaboration agreement, monitored during exclusivity window |
| Data Privacy | Creator personal information (email, phone, address) stored securely, not shared with third parties | Airtable access restricted, data handling policy shared with creators |
| Feature | Description |
|---|---|
| 5-Tier Influencer Framework | Nano, Micro, Mid-Tier, Macro/Expert, and Brand Ambassador tiers — each with defined roles, compensation models, content expectations, and volume targets |
| Creator Vetting Scorecard | 100-point evaluation system covering engagement rate, audience authenticity, content quality, demographic match, niche relevance, brand safety, posting consistency, and collaboration history |
| Multi-Channel Discovery System | 6 discovery channels — hashtag mining, competitor analysis, platform tools (Modash/HypeAuditor), customer mining, inbound applications, and community monitoring |
| 5-Stage Warm Outreach System | Relationship-first outreach: warm-up engagement → personalized DM → follow-up → value-add touchpoint → graceful close — with 22%+ collaboration conversion rate |
| Influencer CRM | Complete Airtable-based CRM tracking: creator profile, audience data, vetting score, relationship stage, campaign assignment, compensation, content log, performance history, and relationship notes |
| 4-Stream UGC Collection Pipeline | Organic customer UGC, prompted post-purchase UGC (email sequence + packaging inserts), creator UGC (campaigns), and ambassador UGC — targeting 170–220 pieces/month |
| Post-Purchase UGC Automation | 5-email automated sequence triggered post-delivery, escalating from value-only welcome to UGC ask to video testimonial invitation — powered by Zapier |
| Creator Onboarding Kit | 9-component professional kit: welcome guide, brand guidelines, campaign brief, product info sheets, content examples, hashtag guide, affiliate code, submission instructions, FAQ |
| Campaign Brief System | Detailed yet creator-friendly briefs with talking points (not scripts), content dos/don’ts, visual examples, timeline, compensation details, and usage rights |
| Content Rights Framework | Tiered usage rights covering reposting, paid ads, website, email, and print — documented in plain-language 2-page agreements, not intimidating legal contracts |
| UGC Repurposing System | 8 repurposing channels: social repost, Story features, ad creatives, website testimonials, email marketing, product page embeds, compilation Reels, and pitch decks |
| Content Amplification Strategy | Organic reposting, paid whitelisting (Spark/Partnership Ads), dark posting, collab posts, and reshare chains — maximizing reach for every piece of creator content |
| Brand Ambassador Program | “PureRoots Glow Collective” — 25–30 invite-only ambassadors with monthly product boxes, 15% affiliate commission, early access, recognition tiers, and annual Creator Retreat |
| Performance Dashboard | 9-section dashboard tracking: campaign overview, creator leaderboard, content library growth, revenue attribution, pipeline health, platform performance, ambassador program, repurposing ROI, and relationship health |
| Relationship Nurturing System | 8 touchpoints: post-campaign thank you, performance sharing, birthday surprises, early access, creator spotlights, feedback surveys, quarterly meetups, and annual retreat |
| Legal & Compliance Framework | ASCI-compliant disclosure requirements, claims compliance, content rights documentation, competitor exclusivity management, and data privacy policies |
| Metric | Before | After (Month 6) | Change |
|---|---|---|---|
| Active Influencer Partnerships | 0 (dormant) | 180+ creators in network (40 nano, 60 micro, 15 mid, 3 macro/expert, 28 ambassadors, 34+ in pipeline) | — |
| Monthly Creator Content Pieces | 0 | 420+ pieces/month (across all tiers + UGC) | — |
| UGC Pieces Collected (Cumulative) | ~40 (unmanaged text reviews) | 1,800+ pieces (photos, videos, reviews, testimonials) | ⬆ 4,400% |
| Monthly UGC from Customers (Organic + Prompted) | ~12 sporadic | 90+ pieces/month | ⬆ 650% |
| Instagram Followers (PureRoots) | 24,000 | 67,400 | ⬆ 181% |
| TikTok Followers (PureRoots) | 3,800 | 41,200 | ⬆ 984% |
| Instagram Engagement Rate | 2.1% | 5.8% (boosted by UGC reposts) | ⬆ 176% |
| Creator Content Delivery Rate | 8% (previous attempt) | 88% (of confirmed collaborators) | ⬆ 1,000% |
| Revenue from Influencer Affiliate Codes | ₹0 | ₹8.4L/month | — |
| Revenue from UGC-Based Ad Creatives | ₹0 | ₹12.6L/month | — |
| Total Influencer-Attributed Revenue (Monthly) | ₹0 | ₹21L+/month | — |
| Customer Acquisition Cost (Influencer Channel) | ₹2,500+ (failed macro experiment) | ₹340 (blended across tiers) | ⬇ 86% |
| Overall Customer Acquisition Cost (All Channels) | ₹780 | ₹360 | ⬇ 54% |
| UGC Ad Creative CTR vs. Brand-Produced Ads | No UGC ads existed | UGC ads: 3.2% CTR vs. Brand ads: 1.4% CTR (128% higher) | ⬆ 128% |
| UGC Ad Creative CPA vs. Brand-Produced Ads | No UGC ads existed | UGC ads: ₹280 CPA vs. Brand ads: ₹620 CPA (55% lower) | ⬇ 55% |
| Ambassador Program Revenue | ₹0 | ₹4.2L/month (from 28 ambassadors) | — |
| Brand Mentions (Monthly, Organic) | ~30 | 380+ | ⬆ 1,167% |
| Website Traffic from Influencer Content | ~200 visits/month (untracked) | 8,400 visits/month (UTM tracked) | ⬆ 4,100% |
| Repeat Collaboration Rate | 0% | 72% (creators who do 2+ campaigns) | — |
| Creator Satisfaction Score | N/A | 9.1/10 (quarterly survey) | — |
Challenge: PureRoots Naturals — a D2C Ayurvedic skincare brand with genuinely excellent products (4.6-star average, 3,200+ reviews) — was invisible in India’s influencer-dominated skincare market. Two previous influencer attempts failed catastrophically: a 50-creator product seeding yielded only 4 posts (8% post rate), and a ₹2.5L macro-influencer campaign generated 0 orders. No UGC collection system existed despite 3,200+ happy customers. Competitors like Mamaearth and mCaffeine dominated social proof with 200+ influencer posts monthly while PureRoots had zero.
Solution: We built a complete influencer and UGC coordination program — a 5-tier influencer framework (Nano to Ambassador) with a 100-point creator vetting scorecard; a 6-channel discovery system; a warm 5-stage outreach sequence; an Airtable influencer CRM; a 4-stream UGC collection pipeline with post-purchase automation; professional creator onboarding kits with campaign briefs; a content rights and licensing framework; an 8-channel UGC repurposing system; a content amplification strategy including whitelisted paid ads; a “Glow Collective” brand ambassador program with tiered recognition and 15% affiliate commissions; a 9-section performance dashboard; a relationship nurturing system with 8 touchpoints; and full ASCI-compliant legal and disclosure framework.
Result: PureRoots built a network of 180+ active creators generating 420+ content pieces monthly. Influencer-attributed revenue reached ₹21L+/month. Overall customer acquisition cost dropped 54% (from ₹780 to ₹360). UGC ad creatives achieved 128% higher CTR and 55% lower CPA than brand-produced ads. Instagram grew 181% and TikTok grew 984%. The ambassador program alone generated ₹4.2L/month. Brand mentions increased 1,167%. Creator satisfaction scored 9.1/10 with a 72% repeat collaboration rate.
We built a complete social media content creation and design system for MapleLeaf Café Chain — producing 180+ branded content pieces monthly across 5 platforms, increasing engagement by 248%, and establishing a visual identity so consistent that followers recognize a MapleLeaf post before reading the caption.
| Client Name | MapleLeaf Café Chain (Fictional/Showcase Project) |
| Industry | Food & Beverage / Café & Restaurant Chain |
| Project Duration | 5 Weeks |
| Services Delivered | Content Strategy & Pillar Development, Visual Brand System for Social, Photo & Video Content Direction, Reels/Shorts Production Framework, Carousel & Infographic Design, Story & Ephemeral Content System, Content Template Library, Multi-Platform Adaptation, Content Production Workflow |
| Tools & Platforms Used | Canva Pro, CapCut Pro, Adobe Lightroom (presets), ChatGPT API (OpenAI), Notion, Airtable, Later (scheduling), Instagram, TikTok, Facebook, YouTube, Pinterest, Google Drive, Zapier, Slack, Midjourney (lifestyle imagery), Eleven Labs (voiceover) |
| Project Year | 2025 |
MapleLeaf Café is a specialty coffee and artisan bakery chain with 8 locations across Bangalore and Chennai. Known for their single-origin pour-over coffees, sourdough pastries, and Instagram-worthy interiors, they had all the ingredients for social media success — beautiful spaces, photogenic products, and a passionate customer base. But their social content didn’t reflect any of it.
Their Instagram feed was a chaotic mix of poorly-lit phone photos, inconsistent filters, random font choices, and graphics that looked like they were made in PowerPoint. One post would be warm-toned and moody, the next would be neon-bright with clip art. Their TikTok was empty. Their Pinterest was dormant. Their Facebook was a graveyard of auto-shared Instagram posts with cropped images and broken formatting.
Despite having the most photogenic product in the food industry — beautifully crafted coffee and pastries — MapleLeaf’s social media made their offerings look generic. Competitors with inferior products but superior content were stealing the spotlight, getting the tags, earning the UGC, and becoming the “must-visit” cafés in Bangalore’s crowded specialty coffee scene.
We designed and implemented a complete social media content creation and design system — from visual brand identity and content pillars to production workflows, template libraries, and multi-platform adaptation — giving MapleLeaf a distinctive, professional, instantly-recognizable social presence that matches the premium quality of their actual café experience.
| Competitor | IG Followers | Avg Engagement | Content Quality | MapleLeaf Gap |
|---|---|---|---|---|
| Third Wave Coffee | 142K | 4.8% | Professional photography, strong Reels, consistent brand | MapleLeaf looks amateur in comparison |
| Blue Tokai | 186K | 5.2% | Educational coffee content, UGC program, stunning visuals | No educational content at MapleLeaf |
| Subko Coffee | 68K | 6.1% | Bold graphic design, video-forward, distinctive aesthetic | No visual identity at MapleLeaf |
| Element | Specification | Application |
|---|---|---|
| Primary Palette | Forest Green (#2D4A2D), Cream (#F5F0E8), Espresso Brown (#3C2415), Warm Gold (#C8A96E) | Backgrounds, text, accents, highlights |
| Secondary Palette | Latte Beige (#D4C5B2), Sage Green (#8FA87E), Charcoal (#2B2B2B), White (#FFFFFF) | Supporting colors, gradients, overlays |
| Typography — Headlines | Playfair Display (serif) | Quotes, announcements, titles |
| Typography — Body | DM Sans (sans-serif) | Descriptions, captions, info text |
| Typography — Accent | Caveat (handwritten) | Personal touches, annotations, arrows |
| Photo Editing Style | Warm tones, slightly desaturated greens, rich browns, soft natural light, shallow depth of field for product shots | Custom Lightroom preset pack (3 presets: “Morning Light,” “Cozy Afternoon,” “Evening Warmth”) |
| Graphic Style | Clean, minimal, generous white space, organic shapes (soft curves, no sharp corners), subtle texture overlays (paper grain, linen) | Templates, carousels, story frames |
| Video Style | Warm color grading matching photo presets, smooth transitions (dissolve, not jump cuts), lo-fi/acoustic music from approved library | Reels, TikToks, Stories |
| Icon Set | Custom line-art icons: coffee cup, croissant, leaf, bean, pour-over, heart, location pin | Used across graphics, stories, highlights |
| Pillar | Purpose | Content Types | % of Mix |
|---|---|---|---|
| ☕ Product Showcase | Drive cravings, highlight craftsmanship | Latte art close-ups, pastry reveals, menu highlights, seasonal specials, process shots | 25% |
| 📚 Coffee Education | Build authority, provide value | Origin stories, brewing methods, bean profiles, “did you know” facts, taste wheel guides | 20% |
| 🏠 Café Vibes & Experience | Drive visits, create FOMO | Interior aesthetics, ambient videos, “a day at MapleLeaf,” golden hour shots, rain-day cozy vibes | 20% |
| 👥 Community & People | Build emotional connection | Barista spotlights, customer features, UGC reshares, behind-the-scenes, team celebrations | 20% |
| 🎯 Promotional & CTA | Drive action — visits, orders, loyalty | New launches, offers, events, loyalty program, online ordering, seasonal campaigns | 15% |
| Content Type | Camera Setup | Lighting | Composition | Mood |
|---|---|---|---|---|
| Latte Art (Hero Shot) | Overhead 90° angle, close-up | Soft natural side-light from window | Cup centered, negative space, surface texture visible | Artisanal, precision |
| Pastry/Food | 45° angle, shallow DOF | Natural light, diffused (no harsh shadows) | Rule of thirds, supporting elements (napkin, fork, coffee in background) | Warm, appetizing |
| Interior/Ambience | Wide-angle, human presence | Golden hour or warm indoor lighting | Leading lines (tables, shelves), depth layers | Inviting, cozy |
| Pour-Over/Process | Eye-level, medium close-up, video | Backlit or side-lit for steam visibility | Hands visible, slow motion for pour | Craft, ritual |
| Barista Portrait | Upper body, slight angle | Soft natural light, café background blurred | Eye contact, genuine smile, apron/brand visible | Approachable, skilled |
| Customer Moment | Candid, medium distance | Available light, unposed | Customer enjoying coffee, reading, laughing | Authentic, relatable |
| Platform | Content Focus | Optimal Formats | Posting Frequency |
|---|---|---|---|
| Instagram Feed | Hero visual content, brand building | Carousels (40%), Single image (30%), Reels (30%) | 5-6 posts/week |
| Instagram Stories | Daily behind-the-scenes, polls, promotions | Photos, short videos, polls, quizzes, countdown stickers | 4-8 stories/day |
| Instagram Reels | Process videos, café vibes, trending content | 15-30 sec vertical video | 4-5 reels/week |
| TikTok | Entertaining, educational, trend-driven | 15-60 sec native vertical video | 5-7 videos/week |
| Community engagement, events, promotions | Adapted from IG (reformatted) + event posts | 3-4 posts/week | |
| YouTube | Long-form education, café tours, brand films | 3-10 min horizontal video | 2-4 videos/month |
| Recipe pins, café aesthetics, coffee guides | Vertical infographics, recipe pins, aesthetic boards | 10-15 pins/week |
| Template Category | # Templates | Sizes Included | Use Case |
|---|---|---|---|
| Product Showcase | 12 | IG Feed (1:1), Story (9:16), Pinterest (2:3) | Menu highlights, new item launches, seasonal specials |
| Educational Carousels | 10 | IG Carousel (1:1, 10 slides each) | Coffee origins, brewing guides, bean profiles, food pairings |
| Quote/Typography | 8 | IG Feed (1:1), Story (9:16) | Coffee quotes, customer testimonials, brand values |
| Behind-the-Scenes | 6 | Story (9:16), Reel cover (9:16) | Baking process, coffee roasting, barista life |
| Promotional/Offer | 12 | IG Feed, Story, Facebook, Print (A4) | Happy hours, loyalty rewards, seasonal campaigns, events |
| Event Announcement | 6 | IG Feed, Story, Facebook Event Cover | Workshops, tastings, live music, pop-ups |
| Customer Feature/UGC | 8 | IG Feed, Story | Reshared UGC with branded frame, customer spotlight |
| Location-Specific | 8 | IG Feed, Story | Each of 8 café locations — local highlights, team features |
| Infographic | 6 | Pinterest (2:3), IG Carousel | Coffee knowledge, nutrition info, process explanations |
| Video Thumbnails | 5 | YouTube (16:9), Reel Cover (9:16) | Consistent thumbnail branding for all video content |
| Story Highlight Covers | 8 | IG Highlight (1:1, circle crop) | Menu, Locations, Behind Scenes, Reviews, Events, Coffee 101, Offers, Careers |
| Seasonal Collection | Variable | All sizes | Monsoon, Diwali, Christmas, Summer, Valentine’s — seasonal themes overlaid on brand system |
| Asset Category | Contents | Organization |
|---|---|---|
| Product Photography | Professional shots of every menu item (3-5 angles each), organized by category (coffee, pastry, food, drinks) | By product category → By item name |
| Interior/Ambience | Each location photographed (15-20 shots per café: exterior, interior zones, details, golden hour, evening) | By location → By zone |
| People | Barista portraits, team photos, customer moments (with consent), event photos | By location → By person/event |
| Process/Behind-Scenes | Coffee brewing methods, baking process, roasting, latte art creation — photo + video | By process type |
| Lifestyle/Mood | Flatlay coffee scenes, reading with coffee, rain-day windows, work-from-café setups | By mood/theme |
| Brand Elements | Logo files (all formats), icon set, pattern files, texture overlays, color swatches, font files | Brand Assets folder |
| Lightroom Presets | 3 custom presets: Morning Light, Cozy Afternoon, Evening Warmth | Presets folder |
| Music Library | 30 royalty-free tracks: lo-fi, acoustic, jazz, ambient — approved for all platforms | By mood/genre |
| Sound Effects | Coffee pouring, espresso machine, milk steaming, bakery sounds, café ambience | By sound type |
| Video Type | Structure | Duration | Production Method | Monthly Volume |
|---|---|---|---|---|
| Process Videos | Satisfying coffee/baking process, ASMR-style, minimal text | 15-30 sec | Phone on tripod, natural sound, slight slow-mo, preset color grade | 8 videos |
| Educational | “Did you know?” or “3 ways to…” format with text overlay and voiceover | 30-60 sec | B-roll clips + text overlay + AI voiceover (Eleven Labs) or barista narration | 6 videos |
| Trending Audio | MapleLeaf twist on trending TikTok/Reels audio | 15-30 sec | Quick production, fun/relatable, brand personality shining | 8 videos |
| Customer/Staff Feature | “Day in the life of a MapleLeaf barista” or customer testimonial | 30-60 sec | Phone interview style, candid feel, warm editing | 4 videos |
| Café Ambience | Aesthetic café shots set to lo-fi music — the “virtual visit” | 15-30 sec | Cinematic B-roll compilation, smooth transitions, no talking | 6 videos |
| Menu Reveal | New item launch with dramatic reveal, taste reaction, ingredients | 15-30 sec | Close-up product shots, reaction clips, text overlay | 4 videos |
BATCH VIDEO PRODUCTION DAY (Bi-Weekly)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
PREP (1 hour):
→ Review content calendar for next 2 weeks
→ List all videos needed (typically 18)
→ Prepare shot lists for each video
→ Charge equipment, prepare products/setups
SHOOT (3 hours at café — during slow period):
→ Process videos: Set up tripod, film 6-8 processes
→ Product shots: Film new menu items, seasonal specials
→ Ambience B-roll: Capture golden hour, interior details
→ Staff content: Quick interviews, day-in-life clips
→ Customer content: Ask willing customers for quick testimonials
EDIT (4 hours — can be done remotely):
→ Import footage to CapCut Pro
→ Apply brand color grading preset
→ Add text overlays using brand fonts
→ Add music from approved library
→ Export in platform-specific formats
→ Create thumbnail using Canva template
TOTAL: 8 hours of production → 18 videos
COST PER VIDEO: ~$12 (time + tools)
COMPARED TO: $200-500 per video from freelance videographer
FREQUENCY: 2 batch days/month → 36 videos/month
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Carousel Type | Slides | Structure | Monthly Volume |
|---|---|---|---|
| Coffee Origin Story | 8-10 slides | Cover → Map of origin → Farmer story → Processing method → Flavor profile → Brewing recommendation → Available at MapleLeaf → CTA | 2 |
| Brewing Guide | 6-8 slides | Cover → Equipment needed → Step 1 → Step 2 → Step 3 → Pro tip → Save for later CTA | 2 |
| “This or That” | 5-6 slides | Cover → Choice 1 vs. 2 → Choice 3 vs. 4 → Choice 5 vs. 6 → “Comment your picks!” → CTA | 2 |
| Menu Feature | 5-6 slides | Cover → Hero product shot → Ingredients/story → How it’s made → Pair it with → “Order now” CTA | 4 |
| Coffee Facts | 6-8 slides | Cover → Fact 1 → Fact 2 → Fact 3 → Fact 4 → Fact 5 → “Share with a coffee lover” CTA | 2 |
| Customer/Staff Spotlight | 5-6 slides | Cover → Photo → Their story → Their favorite order → Quote → “Come say hi at [location]” | 2 |
| Original Content | Instagram Feed | Instagram Story | Instagram Reel | TikTok | YouTube | ||
|---|---|---|---|---|---|---|---|
| Product photo | ✅ 1:1 with caption | ✅ 9:16 with poll/question | — | — | ✅ Reformatted with link | — | ✅ 2:3 pin with recipe link |
| Educational carousel | ✅ 10-slide 1:1 | ✅ Story series (1 slide per story) | — | — | ✅ Reformatted album | — | ✅ 2:3 infographic version |
| Process Reel | — | ✅ BTS story version | ✅ 9:16 with captions | ✅ Native repost with TikTok captions | ✅ Reel cross-post | ✅ Compiled into YouTube Short | ✅ Video pin |
| Café ambience video | — | ✅ 15-sec loop | ✅ Full version | ✅ With trending audio swap | — | ✅ Extended 3-min version with music | ✅ Video pin |
| Customer testimonial | ✅ Quote card | ✅ Video testimonial clip | ✅ Full testimonial Reel | ✅ TikTok testimonial | ✅ Cross-post | — | — |
| Promotional offer | ✅ Branded graphic | ✅ Countdown sticker + CTA | ✅ Quick promo video | ✅ Quick promo with CTA | ✅ Event/offer post with link | — | ✅ Offer pin with link |
| Platform | Feed Posts | Stories | Videos (Reels/Shorts/TikTok) | Pins | Total |
|---|---|---|---|---|---|
| 22 | 120+ | 18 | — | 160+ | |
| TikTok | — | — | 24 | — | 24 |
| 14 | — | 6 | — | 20 | |
| YouTube | — | — | 4 (long) + 8 (Shorts) | — | 12 |
| — | — | — | 50+ | 50+ | |
| TOTAL | 266+ pieces/month |
CONTENT CALENDAR WORKFLOW
━━━━━━━━━━━━━━━━━━━━━━━━
MONTH PLANNING (Day 1 of previous month):
→ Review past month performance (top/bottom content)
→ Identify upcoming events, holidays, seasons, promotions
→ Map content to 5 pillars (ensure balance)
→ Assign content to weekly themes
→ Create monthly calendar in Notion
WEEKLY PLANNING (Every Friday):
→ Finalize next week's content from monthly calendar
→ Assign to team members (photographer, designer, writer)
→ Brief each piece: concept, format, platform, caption direction
PRODUCTION (Monday-Wednesday):
→ Photography/video batch shoots
→ Carousel/graphic design in Canva
→ Caption writing (ChatGPT draft → human polish)
→ Content adaptation for all platforms
SCHEDULING (Thursday):
→ All content for next week loaded into Later
→ Preview grid for Instagram aesthetic check
→ Story schedule set with interactive elements
→ Captions reviewed, hashtags added, tags confirmed
→ Approved → Auto-publish activated
MONITORING (Daily):
→ Engage with comments within 1 hour of posting
→ Track early performance signals
→ Amplify winners (boost or reshare to Stories)
→ Note learnings for next cycle
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Content Level | What | Who Creates | Frequency |
|---|---|---|---|
| Brand-Level | Educational carousels, brand campaigns, seasonal content, process videos | Central marketing team | 60% of content |
| Location-Level | Daily specials, local events, barista spotlights, “today at [location]” Stories | Trained café staff using templates | 30% of content |
| UGC/Community | Customer features, reshared UGC, reviews, community moments | Community manager curates | 10% of content |
| Training Module | Duration | Topics Covered |
|---|---|---|
| Brand Guidelines 101 | 1 hour | Color palette, fonts, photo style, tone of voice, do’s and don’ts |
| Phone Photography Masterclass | 2 hours | Lighting, composition, angles, food photography tips, Lightroom preset application |
| Story Creation | 1 hour | Canva templates, interactive elements (polls, quizzes, countdowns), behind-the-scenes capture |
| Quick Video | 1.5 hours | CapCut basics, transitions, text overlay, music selection, vertical framing |
| Content Submission | 30 min | How to submit content for approval, Google Drive upload process, quality checklist |
| Step | Action | Tool |
|---|---|---|
| Staff captures content at café | Photo/video taken following guidelines | Phone + Lightroom preset |
| Uploads to location folder | Raw content + brief description | Google Drive |
| Community manager reviews | Quality check, brand compliance, edit if needed | Slack approval channel |
| If approved → scheduled | Added to content calendar | Later |
| If needs improvement → feedback sent | Specific, constructive guidance | Slack DM with screenshot annotations |
| Metric | How Tracked | Frequency | Benchmark |
|---|---|---|---|
| Engagement rate per post | Later analytics + Airtable log | Per post, summarized weekly | Target: 4.5% (industry: 3.5%) |
| Save rate | Instagram Insights | Per post | Target: 2.5%+ |
| Share rate | Instagram Insights | Per post | Target: 1.5%+ |
| Content pillar performance | Airtable — tagged by pillar | Monthly comparison | Identify strongest/weakest pillar |
| Content format performance | Airtable — tagged by format | Monthly comparison | Reels vs. Carousel vs. Static vs. Story |
| Location content quality | Quality score per location | Weekly | Identify locations needing more training |
| Grid aesthetic score | Visual review of IG feed | Weekly | Consistent color, variety, storytelling flow |
| Follower growth per post type | Instagram Insights correlation | Monthly | Which content drives follows? |
| Website clicks per content | UTM tracking + GA4 | Per post with link | Target: 2%+ CTR |
| Revenue attributed | UTM → Shopify/order tracking | Monthly | Social-driven online orders + café visits (estimated) |
| Feature | Description |
|---|---|
| Complete Visual Brand System | Color palette, typography, photo editing presets, graphic style, video direction, icon set — ensuring every piece of content is instantly recognizable as MapleLeaf |
| 5-Pillar Content Strategy | Product Showcase, Coffee Education, Café Vibes, Community & People, Promotional — balanced mix driving engagement, education, and sales |
| 85 Canva Template Library | Reusable, brand-locked templates across 11 categories for every content need — anyone can create on-brand content in minutes |
| Photo & Video Asset Library | 2,000+ organized, searchable assets with Lightroom presets, music library, and sound effects |
| 36-Video Monthly Production System | Bi-weekly batch shooting workflow producing 18 videos per session at $12/video — covering Reels, TikToks, and Shorts |
| 14 Monthly Carousel Production | 6 carousel frameworks with brand templates for educational, feature, and engagement content |
| Multi-Platform Adaptation System | Each hero piece generates 3-6 platform-optimized versions — maximizing content ROI across Instagram, TikTok, Facebook, YouTube, and Pinterest |
| 266+ Monthly Content Pieces | Full content volume across all 5 platforms — from a streamlined, efficient production system |
| Multi-Location Content Program | 8 trained “Content Champions” producing location-specific daily content using templates and brand guidelines |
| Content Calendar & Scheduling | Monthly planning → weekly production → Thursday scheduling workflow with approval gates and quality checks |
| Photography & Videography Direction Guide | Shot-by-shot guidance for every content type — camera angle, lighting, composition, and mood specifications |
| Performance Tracking System | Per-post tracking across engagement, saves, shares, clicks, and revenue — with pillar, format, and location-level analysis |
| Metric | Before | After (Month 6) | Change |
|---|---|---|---|
| Monthly Content Pieces (All Platforms) | 40-50 (inconsistent) | 266+ (systematic) | ⬆ 432% |
| Instagram Engagement Rate | 1.4% | 4.9% | ⬆ 250% |
| Instagram Save Rate | 0.3% | 2.8% | ⬆ 833% |
| Instagram Share Rate | 0.1% | 1.6% | ⬆ 1,500% |
| TikTok Average Views | 800 (when posting at all) | 14,200 | ⬆ 1,675% |
| Pinterest Monthly Clicks | 42 | 680 | ⬆ 1,519% |
| Instagram Followers | 18,400 | 42,600 | ⬆ 132% |
| TikTok Followers | 2,100 | 28,400 | ⬆ 1,252% |
| Brand Visual Consistency Score | 2/10 (audit assessment) | 9.2/10 | ⬆ 360% |
| Content Production Time per Piece | 45-60 minutes | 12-15 minutes (with templates) | ⬇ 75% |
| Video Production Cost per Video | $0 (none produced) or $300+ (freelancer) | $12 (batch system) | ⬇ 96% |
| Social-Driven Online Orders/Month | 24 | 186 | ⬆ 675% |
| Café Visit Attribution (Estimated) | Unmeasured | 420+ monthly visits from social | — |
| UGC Generated (Monthly) | ~15 (unmanaged) | 120+ (content inspires UGC) | ⬆ 700% |
| Staff Content Contributions/Month | 0 | 64 pieces (8 locations × 8 pieces) | — |
Challenge: MapleLeaf Café’s social media was a chaotic mess — poorly-lit phone photos, inconsistent branding, no templates, no video content, zero TikTok/Pinterest presence, and just 40-50 random posts monthly across platforms. Despite having beautifully photogenic products and spaces, their social presence made them look amateur while competitors with inferior products dominated through superior content.
Solution: We built a complete content creation and design system — a visual brand identity with color palette, typography, and Lightroom presets; an 85-template Canva library; a 2,000+ asset library; a bi-weekly batch video production workflow producing 36 videos/month at $12 each; 14 monthly carousels from 6 frameworks; multi-platform adaptation turning each piece into 3-6 versions; a multi-location content program training 8 staff “Content Champions”; and a monthly planning → weekly production → scheduling workflow with performance tracking.
Result: Content output grew from 50 to 266+ monthly pieces. Instagram engagement jumped 250%. TikTok grew from 2,100 to 28,400 followers. Save rate increased 833%. Social-driven online orders grew 675%. Content production time dropped 75% per piece. Video cost dropped from $300+ to $12 each. Brand visual consistency scored 9.2/10 (from 2/10). MapleLeaf is now visually indistinguishable from premium international coffee brands.
We built a strategic community management system for FitVerse Fitness App — transforming scattered, reactive social interactions into an organized engagement engine that increased community-driven app downloads by 156%, boosted brand sentiment to 94% positive, and turned 2,400 customers into active brand advocates.
| Client Name | FitVerse Fitness App (Showcase Project) |
| Industry | Fitness & Wellness / Mobile App / SaaS |
| Project Duration | 5 Weeks |
| Services Delivered | Community Strategy Development, Engagement Framework Design, Comment & DM Management System, Crisis & Reputation Management Protocol, User-Generated Content Pipeline, Community Growth Programs, Sentiment Monitoring, Community Health Dashboard |
| Tools & Platforms Used | Sprout Social, Agorapulse, Brand24, Instagram, Facebook Groups, TikTok, YouTube, Twitter/X, Discord, Slack, Zapier, Make (Integromat), ChatGPT API (OpenAI), Google Sheets, Airtable, Notion, Canva, Google Looker Studio, WordPress |
| Project Year | 2025 |
FitVerse is a subscription fitness app offering AI-personalized workout plans, nutrition tracking, and live group classes. With 34,000 app users, a $14.99/month subscription, and a social presence across Instagram (62K), TikTok (38K), Facebook Group (8,400 members), YouTube (14K), Twitter/X (9K), and a newly launched Discord server (1,200 members), they had built a sizable audience — but were failing to turn that audience into a community.
Comments went unanswered for days. DMs piled up in an unmanaged inbox. Negative reviews spread without response. Their Facebook Group was overrun with spam. Their Discord was a ghost town. User-generated content — transformation photos, workout videos, app screenshots — was being posted by customers but never acknowledged, reshared, or leveraged. Brand mentions went unmonitored. And there was zero system for identifying and nurturing their most passionate fans into brand advocates.
The difference between an “audience” and a “community” is engagement, belonging, and reciprocity. FitVerse had an audience. We built them a community.
| Interaction Type | Volume (3 months) | % of Total | Current Response Rate | Priority |
|---|---|---|---|---|
| Positive feedback / praise | 2,400 | 28% | 12% responded | 🟡 High (acknowledge!) |
| Product questions (how-to, features) | 1,800 | 21% | 34% responded | 🔴 Critical (unanswered = lost user) |
| Transformation stories / results | 680 | 8% | 8% responded | 🔴 Critical (UGC goldmine) |
| Customer support issues | 940 | 11% | 41% responded | 🔴 Critical (churn risk) |
| Purchase/subscription inquiries | 620 | 7% | 28% responded | 🔴 Critical (revenue loss) |
| Negative comments / complaints | 480 | 6% | 18% responded | 🔴 Critical (reputation damage) |
| Spam / irrelevant | 1,200 | 14% | N/A | Remove |
| Engagement bait (emoji, tags) | 440 | 5% | 4% responded | 🟢 Low (batch respond) |
| Element | Guideline | Example |
|---|---|---|
| Personality | Encouraging coach, not corporate brand | “You’ve got this! 💪” not “Thank you for your inquiry.” |
| Tone Spectrum | Motivational ↔ Empathetic (adjusts to context) | Celebration: “INCREDIBLE transformation!! 🔥” / Support: “We totally hear you — let’s fix this together.” |
| Response Length | Match the energy — short comments get short replies, detailed questions get thorough answers | Quick: “Love this! 🙌” / Detailed: paragraph with steps + link |
| Emoji Usage | Moderate — 1-3 per response, fitness/wellness themed | 💪🔥🏋️♀️✨🥗🎯 (approved set) |
| Never Say | “Per our policy,” “Unfortunately,” “We can’t” | Always reframe positively or offer alternatives |
| Escalation Language | Warm handoff, never defensive | “I’d love to get our support specialist to help — DMing you now so we can sort this out personally!” |
| Priority | Response Time Target | Interaction Types |
|---|---|---|
| 🔴 P1 — Immediate | Under 1 hour | Negative reviews, complaint comments, support issues, purchase questions, crisis mentions |
| 🟠 P2 — Fast | Under 4 hours | Product questions, feature inquiries, transformation shares, influencer mentions |
| 🟡 P3 — Standard | Under 12 hours | Positive comments, general praise, engagement responses |
| 🟢 P4 — Batch | Within 24 hours | Emoji reactions, friend tags, generic engagement |
| Tag | Trigger | Action |
|---|---|---|
| 🔴 NEGATIVE | Keywords: “cancel,” “terrible,” “worst,” “refund,” “doesn’t work,” “scam” | P1 priority, alert Slack, assign senior community manager |
| 💰 PURCHASE INTENT | Keywords: “how much,” “subscribe,” “worth it,” “free trial,” “pricing,” “discount” | P1 priority, respond with value prop + link |
| ❓ QUESTION | Keywords: “how to,” “can I,” “does it,” “what is,” “help,” “?” | P2 priority, respond with helpful answer + resource link |
| 🏆 TRANSFORMATION | Keywords: “results,” “transformation,” “lost weight,” “gained muscle,” “before after,” “#FitVerseResults” | P2 priority, celebrate + request UGC permission |
| ⭐ PRAISE | Keywords: “love this,” “amazing,” “best app,” “changed my life,” “thank you” | P3 priority, acknowledge warmly |
| 🤖 SPAM | Keywords: “buy followers,” “check my profile,” “DM for collab,” MLM terms | Auto-hide, report, block repeat offenders |
AI RESPONSE WORKFLOW
━━━━━━━━━━━━━━━━━━━━
1. Comment/DM arrives in Agorapulse
2. Auto-tagged by category
3. AI generates draft response based on:
→ Comment content and sentiment
→ FitVerse brand voice guidelines
→ Category-specific response templates
→ Customer's profile (new user vs. long-term subscriber)
4. Community manager reviews draft (5-10 seconds)
5. Approves, edits slightly, or rewrites if needed
6. Publishes response
RESULT:
Response quality: Consistent, on-brand, personalized
Response speed: 80% faster than writing from scratch
Community manager capacity: 3× more interactions handled/hour
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Scenario | Response Framework | Escalation |
|---|---|---|
| App bug/technical issue | Acknowledge → Apologize → Ask for details → Promise resolution → DM for follow-up | Slack alert to dev team with details |
| Billing complaint | Empathize → Explain → Offer resolution (refund/extension) → DM to process | Slack alert to billing team |
| Feature dissatisfaction | Validate frustration → Explain reasoning → Note as feedback → Share roadmap hint | Log in product feedback database |
| False/unfair claim | Respond professionally with facts → Don’t argue → Invite offline conversation | Manager review before publishing |
| Competitor comparison (negative) | Acknowledge competitor strengths → Differentiate FitVerse value → Invite to try specific feature | No escalation — handled by senior CM |
| Troll/harassment | One professional response → If continued, hide and block → Document | Report to platform if TOS violation |
| Scenario | Template Example |
|---|---|
| Transformation share | “OH WOW [Name]!! 🔥🔥 This transformation is absolutely incredible — [specific detail from their post]. You put in the work and it SHOWS. Would you mind if we shared your story? You’re going to inspire so many people! 💪” |
| App question | “Great question, [Name]! 😊 You can [answer their specific question]. Here’s a quick guide that walks through it step by step → [link]. Let me know if you need anything else — we’re always here!” |
| Complaint | “Hey [Name], I’m really sorry you’re experiencing this — that’s not the experience we want for you. 😔 I’ve DMed you so we can get this sorted personally. We’ve got your back!” |
| Purchase inquiry | “Hey [Name]! Love the interest! 🎯 FitVerse gives you [key benefit 1], [key benefit 2], and [key benefit 3] — all personalized to YOUR goals. You can try it free for 7 days here → [link]. No credit card needed! Let me know if you have any questions!” |
| Element | Before | After |
|---|---|---|
| Rules & Guidelines | None | 8 clear rules posted (no spam, no promotions, be supportive, content guidelines) |
| Moderation | None | 3 trained moderators (1 staff + 2 volunteer power members) with removal authority |
| Spam Cleanup | 35% of posts were spam | All spam removed + auto-moderation rules catching 90% of future spam |
| Admin Posting | Last admin post 4 months ago | Daily branded posts (challenges, questions, tips, polls, shoutouts) |
| Welcome System | None | Auto-welcome post for new members with intro template + rules link |
| Content Pillars | Random | Monday: Motivation Monday, Tue: Technique Tuesday, Wed: What I Ate Wednesday, Thu: Transformation Thursday, Fri: Free Talk Friday, Sat: Saturday Challenge, Sun: Self-Care Sunday |
| Member Recognition | None | Monthly “Member of the Month” spotlight + badge in group |
| Expert Engagement | None | Weekly “Ask a Trainer” thread with FitVerse coach responding |
| Day | Content Type | Engagement Mechanic |
|---|---|---|
| Monday | Motivational quote + weekly goal setting prompt | “Share your #1 goal for this week in the comments 👇” |
| Tuesday | Technique tip (short video from FitVerse trainer) | “Try this and comment your form check video!” |
| Wednesday | Nutrition focus (meal prep idea or recipe) | “Drop your favorite healthy meal below 🥗” |
| Thursday | Transformation Thursday (member spotlight) | “Tag someone whose journey inspires you!” |
| Friday | Open discussion (trending fitness topic) | Poll or debate format — high engagement |
| Saturday | Weekend challenge (specific workout challenge) | “Post your completion screenshot for a badge!” |
| Sunday | Self-care Sunday (recovery, mental health, rest) | Reflective prompt — builds emotional connection |
| Metric | Before | After |
|---|---|---|
| Active members (monthly) | 840 (10%) | 4,200 (50%) |
| Daily posts by members | 4-6 (mostly spam) | 25-35 (quality content) |
| Admin/brand posts per week | 0 | 7+ |
| Spam percentage | 35% | Under 2% |
| Average post engagement | 3 reactions | 28 reactions + 8 comments |
| App downloads attributed to group | Unmeasured | 120+/month |
| Channel | Purpose | Engagement Strategy |
|---|---|---|
| #welcome | Auto-greet new members + role selection | Bot welcome message with community guide |
| #introductions | Members introduce themselves + goals | Template prompt: “Name, fitness goal, favorite exercise, one fun fact” |
| #daily-workout | Daily workout of the day from FitVerse | Members share completion photos/stats |
| #nutrition-talk | Meal prep, recipes, supplement discussion | Weekly recipe challenge with featured winner |
| #transformations | Before/after photo sharing | Monthly transformation contest with prizes |
| #accountability-partners | Find workout buddies | Matching system based on goals + timezone |
| #ask-a-trainer | Q&A with FitVerse trainers | Scheduled weekly AMA sessions |
| #app-feedback | Feature requests and bug reports | Product team reviews weekly, responds to top requests |
| #off-topic | General conversation, memes, fun | Builds human connection beyond fitness |
| #announcements | Official FitVerse updates | New features, app updates, events |
| Tactic | Implementation |
|---|---|
| In-App Prompt | “Join our Discord community for exclusive workouts + accountability partners” — shown after 5th workout |
| Instagram Story CTA | Weekly “Join our Discord” Story with member testimonial |
| Exclusive Discord Content | Workout plans shared ONLY in Discord (24 hrs before app release) |
| Weekly Events | Live Q&A with trainers, group workout sessions, nutrition workshops |
| Gamification | XP system: earn points for posting, helping members, sharing results → unlock roles (Bronze → Silver → Gold → Platinum member) |
| Ambassador Selection | Most active Discord members invited to Brand Ambassador program |
UGC PIPELINE WORKFLOW
━━━━━━━━━━━━━━━━━━━━━
DISCOVERY (Automated):
→ Brand24 monitors: #FitVerse, #FitVerseResults, @FitVerse tags
→ Agorapulse captures tagged posts across IG, TikTok, Facebook
→ Daily digest delivered to community manager via Slack
ENGAGEMENT (Within 4 hours):
→ Like/react to the post
→ Leave enthusiastic, personalized comment
→ DM creator: "Love your [specific detail]! Would you mind
if we featured your story on our page? 🌟"
PERMISSION (Automated + Manual):
→ If creator agrees → send UGC permission form (Typeform)
→ Form captures: full name, handle, permission level
(social only / website / ads), preferred credit format
→ Signed → added to UGC library in Airtable
CURATION (Weekly):
→ Community manager reviews UGC library
→ Selects top 5-8 pieces for the coming week
→ Tags with: content type, platform suitability, quality score
→ Assigns to content calendar
PUBLISHING:
→ UGC shared on FitVerse channels with full credit
→ Creator tagged + thanked publicly
→ Creator receives "Featured Fan" badge + 1-month free premium
→ High-performing UGC flagged for paid ad use (with permission)
TRACKING:
→ Every UGC post tracked in Airtable with performance metrics
→ UGC vs. brand-produced content performance comparison
→ Revenue attributed to UGC content vs. other types
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Source | Current Volume | 6-Month Target | Tactic |
|---|---|---|---|
| Organic tags (unprompted) | ~120/month | 300/month | Better community engagement → more sharing |
| Prompted (app notification) | 0 | 80/month | In-app “Share Your Results” prompt after milestones |
| Challenges/contests | 0 | 60/month | Monthly transformation challenge with prizes |
| Ambassador program | 0 | 40/month | 50 ambassadors producing 3-4 pieces/month each |
| Total UGC Pipeline | ~120/month | 480/month | 4× increase |
| Element | Details |
|---|---|
| Selection Criteria | Active FitVerse user (3+ months), genuine transformation results, active social presence (1K+ followers), positive community contributions, applies and gets approved |
| Program Size | 50 ambassadors (10 new per quarter, rolling program) |
| Benefits | Free premium subscription, exclusive merch, early feature access, monthly group call with founders, featured on FitVerse channels, ambassador badge on Discord, referral commission (20% of referred subscriptions for 3 months) |
| Requirements | 3-4 social posts/month mentioning FitVerse, participate in monthly challenges, provide product feedback, attend quarterly virtual meetup |
| Application | Typeform application → scored by community manager → top applicants selected → onboarding call |
| Tracking | Ambassador Airtable dashboard: content produced, engagement generated, referral conversions, sentiment |
| Monitor | Source | Frequency | Alert Threshold |
|---|---|---|---|
| Brand mentions | All social + web + forums + Reddit | Real-time | Any negative mention from account with 5K+ followers |
| Hashtag tracking | #FitVerse, #FitVerseResults, #FitVerseApp | Real-time | Volume spike (3× average) — investigate viral moment |
| App store reviews | iOS App Store + Google Play | Daily digest | Any 1-2 star review — respond within 24 hours |
| Competitor mentions | 5 competitor brand names | Daily digest | Weekly competitive sentiment report |
| Industry keywords | “fitness app,” “workout app,” “best fitness” | Weekly | Share of voice tracking |
| Sentiment score | Aggregate across all sources | Daily | Score drops below 80% positive → investigate |
| Crisis Level | Definition | Response Protocol | Timeline |
|---|---|---|---|
| Level 1: Minor | Single negative comment/review, isolated complaint | Community manager responds empathetically, resolves individually | Within 1 hour |
| Level 2: Moderate | Multiple complaints about same issue, negative review cluster | Senior CM coordinates response, update/apology post if needed, internal investigation | Within 2 hours |
| Level 3: Serious | Viral negative post, media attention, significant user backlash | Crisis team activated (CM + Marketing Director + CEO), official statement drafted, all channels addressed simultaneously | Within 1 hour, statement within 4 hours |
| Level 4: Critical | Data breach, safety issue, legal matter, major PR crisis | Executive crisis team, legal counsel, professional crisis communication, proactive media outreach | Immediate activation, public response within 2 hours |
| Scenario | Response Framework |
|---|---|
| App outage/downtime | Acknowledge immediately → Provide timeline → Update every 30 min → Post-resolution summary + apology + compensation (free premium day) |
| Data/privacy concern | Take seriously → Investigate immediately → Transparent communication → Remediation steps → Policy improvements |
| Offensive content by ambassador | Remove association immediately → Public statement distancing → Review ambassador program → Implement better vetting |
| Viral negative review | Don’t delete → Respond publicly with empathy → Take conversation private → Resolve → Follow up publicly with resolution |
| Section | Metrics |
|---|---|
| Response Performance | Avg response time (by platform), response rate %, P1 response time, unresponded items count |
| Sentiment Health | Overall sentiment score (% positive/neutral/negative), sentiment trend, negative sentiment by topic |
| Community Growth | Facebook Group members + activity, Discord members + DAU, brand mentions volume |
| UGC Pipeline | UGC pieces discovered, permissions obtained, pieces published, UGC vs. brand content performance |
| Ambassador Program | Active ambassadors, content produced, referral conversions, ambassador-attributed revenue |
| Engagement Quality | Comment quality score (meaningful vs. generic), conversation depth, questions answered |
| Crisis Monitor | Open issues, escalated items, resolution rate, brand health score |
FITVERSE COMMUNITY INTELLIGENCE — MARCH 2025
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
📊 COMMUNITY HEALTH: Strong (Score: 88/100, ↑6 vs Feb)
💬 RESPONSE METRICS:
Avg response time: 42 minutes (target: <60 min) ✅
Response rate: 96% (↑ from 92% Feb) ✅
P1 (critical) avg response: 18 minutes ✅
😊 SENTIMENT:
Overall: 94% positive (↑ from 89% Feb)
Top positive themes: "love the new HIIT programs," "community
is so supportive," "app keeps me accountable"
Negative themes (6%): "subscription price" (2%), "Android
bugs" (2%), "want more yoga content" (2%)
👥 COMMUNITY GROWTH:
Facebook Group: 12,400 members (↑1,800), 52% monthly active
Discord: 3,200 members (↑680), 180 DAU (↑ from 22 at launch!)
Brand mentions: 1,420 this month (↑34%)
📸 UGC:
UGC pieces discovered: 286
Permissions obtained: 184
Published on FitVerse channels: 32
UGC content engagement rate: 5.8% (vs. 3.2% brand content)
Revenue attributed to UGC posts: $4,200
🏆 AMBASSADOR PROGRAM:
Active ambassadors: 38
Content produced: 142 pieces
Referral signups: 89
Ambassador-attributed revenue: $6,400
🎯 RECOMMENDATIONS:
1. UGC performing 81% better than brand content — increase
UGC to 40% of content calendar
2. "Yoga content" is #1 feature request — flag for product team
3. Launch "Transformation Tuesday" Instagram series using
top UGC (data shows Tuesday transformations get 2× saves)
4. Discord accountability partner channel driving highest
retention — promote heavily in onboarding
5. Ambassador Priya (IG 12K) generated 28 referrals —
consider micro-influencer collaboration
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━| Feature | Description |
|---|---|
| Unified Social Inbox | All comments, DMs, mentions, and reviews across 6 platforms consolidated in Agorapulse with auto-tagging and priority routing |
| AI-Assisted Response System | ChatGPT draft responses for high-volume interactions — community manager reviews in 5-10 seconds, maintaining consistent brand voice at 3× speed |
| Response Priority Framework | 4-tier priority system ensuring critical interactions (complaints, purchase intent, support) get sub-1-hour responses |
| Facebook Group Revival | Spam-free, actively moderated group with daily themed content, weekly expert Q&A, and member recognition — active membership grew from 10% to 52% |
| Discord Community Build | 10-channel structured server with gamification (XP/roles), weekly events, accountability partners, and exclusive content — DAU grew from 22 to 180 |
| UGC Collection Pipeline | Automated discovery → engagement → permission → curation → publishing workflow processing 280+ UGC pieces monthly |
| Brand Ambassador Program | “FitVerse Champions” — 50 ambassadors producing 140+ content pieces monthly with referral tracking and revenue attribution |
| Sentiment Monitoring | Real-time Brand24 monitoring across all social, web, forums, and app stores with automated alerts and daily sentiment scoring |
| Crisis Management Protocol | 4-level crisis framework with response templates, escalation paths, and team activation procedures |
| Community Health Dashboard | Real-time tracking of response times, sentiment, community growth, UGC pipeline, ambassador performance, and engagement quality |
| Monthly AI Intelligence Report | ChatGPT-generated analysis with community health score, sentiment themes, UGC performance, and strategic recommendations |
| Metric | Before | After (Month 6) | Change |
|---|---|---|---|
| Average Response Time (Comments) | 38 hours | 42 minutes | ⬇ 98% |
| Average Response Time (DMs) | 52 hours | 28 minutes | ⬇ 99% |
| Response Rate | 39% | 96% | ⬆ 146% |
| Brand Sentiment (Positive %) | 74% | 94% | ⬆ 27% |
| Facebook Group Active Members | 840 (10%) | 6,400 (52%) | ⬆ 662% |
| Discord Daily Active Users | 22 | 180 | ⬆ 718% |
| UGC Pieces Collected/Month | ~120 (unmanaged) | 480 (systematic) | ⬆ 300% |
| UGC Content Performance vs. Brand | Unmeasured | 81% higher engagement rate | — |
| Active Brand Ambassadors | 0 | 50 | — |
| Ambassador-Generated Content/Month | 0 | 142 pieces | — |
| Community-Attributed App Downloads/Month | Unmeasured | 340+ | — |
| Community-Attributed Revenue/Month | $0 (unmeasured) | $18,400 | — |
| Ambassador Referral Revenue/Month | $0 | $6,400 | — |
| Negative Reviews Left Unresponded | 82% | Under 2% | ⬇ 98% |
| App Store Rating (iOS) | 3.8★ | 4.6★ | ⬆ 21% |
| Customer Retention (Community Members vs. Non) | — | 34% higher for community members | — |
Challenge: FitVerse had 62K Instagram followers and 8,400 Facebook Group members but zero community management — 38-hour average response times, 61% of DMs unanswered, Facebook Group overrun with 35% spam, Discord dead at 22 daily users, 120+ monthly UGC posts going unacknowledged, no brand advocate program, no sentiment monitoring, and no crisis protocol.
Solution: We built a complete community management system — unified social inbox with AI-assisted responses, 4-tier priority framework, Facebook Group revival with themed daily content and active moderation, Discord community build with gamification and weekly events, automated UGC collection pipeline, 50-person Brand Ambassador program, real-time sentiment monitoring, 4-level crisis protocol, and a community health dashboard with AI intelligence reports.
Result: Response time dropped from 38 hours to 42 minutes. Sentiment improved from 74% to 94% positive. Facebook Group active membership grew 662%. Discord DAU grew from 22 to 180. UGC collection quadrupled. Ambassador program generates 142 content pieces and $6,400 monthly revenue. Community-attributed app downloads: 340+/month. App store rating climbed from 3.8 to 4.6 stars. Community members retain 34% better than non-members.
We built a comprehensive social media analytics and growth tracking system for PureGlow Skincare — replacing vanity metrics with revenue-connected intelligence that identified their highest-ROI content types, optimized posting strategy, and grew social-attributed revenue by 182%
| Client Name | PureGlow Skincare |
| Industry | Beauty & Skincare / D2C E-Commerce |
| Project Duration | 5 Weeks |
| Services Delivered | Social Media Audit, KPI Framework Development, Cross-Platform Analytics Setup, Growth Tracking Dashboard, Competitor Benchmarking System, Content Performance Intelligence, ROI Attribution Model, Automated Reporting |
| Tools & Platforms Used | Sprout Social, Google Analytics 4, Google Looker Studio, Meta Business Suite, Instagram Insights, TikTok Analytics, YouTube Studio, Pinterest Analytics, Iconosquare, Brandwatch, Rival IQ, Google Sheets, Airtable, Zapier, Make (Integromat), ChatGPT API (OpenAI), Slack, Notion, Shopify (data source), WordPress |
| Project Year | 2025 |
PureGlow Skincare is a D2C beauty brand selling clean, cruelty-free skincare products through their Shopify store and marketplace presence. With active accounts on Instagram (48K followers), TikTok (22K), Facebook (18K), YouTube (8K), and Pinterest (12K), they were posting consistently — 4-5 times daily across platforms — but had zero visibility into what was actually working.
The social media manager tracked “likes and followers” in a basic spreadsheet updated monthly. That was the extent of their analytics. Nobody could answer fundamental questions: “Which platform actually drives sales?” “What content type generates the most revenue?” “Is our Instagram growing or stagnating?” “Should we invest more in TikTok or YouTube?” “What’s our actual ROI from social media?”
They were creating content in the dark — no data-driven decisions, no performance benchmarks, no competitor comparison, and no connection between social media activity and business revenue. High-effort content pieces that took hours to produce might generate zero sales, while a quick behind-the-scenes Story might drive thousands in revenue — but nobody could see the difference.
We built a complete social media analytics and growth tracking ecosystem that connects every platform’s data into unified dashboards, tracks content performance at the individual post level, attributes revenue to specific social activities, benchmarks against competitors, and delivers actionable intelligence that transforms social media from a “hope it works” activity into a measurable, optimizable revenue channel.
| Platform | Followers | Avg Engagement Rate | Avg Reach Rate | Website Clicks/Month | Content Volume/Month | Health Assessment |
|---|---|---|---|---|---|---|
| 48,200 | 1.8% (benchmark: 3.5%) | 12% (benchmark: 25%) | 420 | 65 posts | 🟡 Underperforming | |
| TikTok | 22,400 | 4.2% (benchmark: 6%) | 34% (benchmark: 40%) | 180 | 30 videos | 🟡 Below potential |
| 18,100 | 0.6% (benchmark: 1.5%) | 6% (benchmark: 12%) | 140 | 40 posts | 🔴 Poor | |
| YouTube | 8,200 | 3.8% (benchmark: 4%) | N/A | 95 | 8 videos | 🟡 Decent, low volume |
| 12,400 | N/A (pin saves: 2.1%) | 8% (benchmark: 15%) | 310 | 45 pins | 🟡 Untapped potential |
| Content Type | Volume (12 months) | Avg Engagement Rate | Avg Saves | Avg Shares | Avg Website Clicks | Revenue Attributed |
|---|---|---|---|---|---|---|
| Static Product Photos | 380 posts | 1.2% | 18 | 4 | 8 | Unknown |
| Carousel (Educational) | 82 posts | 3.8% | 86 | 32 | 28 | Unknown |
| Reels (Tutorial) | 64 videos | 4.6% | 124 | 68 | 42 | Unknown |
| Reels (Trending Audio) | 48 videos | 5.2% | 42 | 94 | 12 | Unknown |
| Stories | 420+ | 2.1% (reply rate) | N/A | N/A | 34 avg/day | Unknown |
| UGC Reposts | 34 posts | 3.2% | 44 | 28 | 22 | Unknown |
| Product Launch Posts | 28 posts | 2.4% | 36 | 18 | 64 | Unknown |
| KPI Category | Metrics | Why It Matters |
|---|---|---|
| Growth | Follower growth rate (%), net new followers/week, growth velocity trend, follower quality score | Are we growing, and is growth accelerating or decelerating? |
| Reach & Visibility | Reach rate (%), impressions, impression-to-reach ratio, hashtag reach %, explore/FYP reach % | How many people actually see our content? |
| Engagement Quality | Engagement rate (%), save rate, share rate, comment sentiment, engagement per reach (true engagement) | Are people interacting meaningfully, not just passively scrolling? |
| Content Efficiency | Performance by content type, topic, posting time, caption length, hashtag set | What works best and how do we do more of it? |
| Traffic & Conversion | Link clicks, CTR, landing page visits from social, social-referred sessions | Are we driving people to our website? |
| Revenue Attribution | Social-attributed revenue, revenue per platform, revenue per content type, ROAS on paid social | Is social media generating money? |
| Competitor Position | Relative engagement rate, relative growth rate, share of voice, content gap analysis | How do we stack up and where are opportunities? |
| Audience Quality | Demographics match to buyer persona, active follower %, audience overlap across platforms | Are we attracting the right people? |
| ❌ Vanity Metric (Stop Celebrating) | ✅ Value Metric (Start Tracking) |
|---|---|
| Total follower count | Follower growth rate (% per week) |
| Total likes | Engagement rate per reach (%) |
| Impressions (raw number) | Reach rate (% of followers who see content) |
| “We went viral!” (one-off spike) | Consistent engagement trend (sustained performance) |
| Post count (volume) | Performance per post (efficiency) |
| Follower count by platform | Revenue attributed per platform |
| Comments count | Comment sentiment and conversation quality |
| “Best performing post” (by likes) | Best performing post (by saves + shares + clicks + revenue) |
| Platform | Tracking Tool | Data Captured | Integration |
|---|---|---|---|
| Sprout Social + Instagram Insights API | Posts, Stories, Reels — engagement, reach, saves, shares, profile visits, link clicks | API → Looker Studio | |
| TikTok | Sprout Social + TikTok Analytics API | Videos — views, engagement, FYP reach, profile visits, link clicks | API → Looker Studio |
| Sprout Social + Meta Business Suite | Posts — reach, engagement, clicks, video views | API → Looker Studio | |
| YouTube | YouTube Studio API + Sprout Social | Videos — views, watch time, CTR, subscribers gained, traffic sources | API → Looker Studio |
| Pinterest Analytics API + Sprout Social | Pins — impressions, saves, clicks, closeups | API → Looker Studio | |
| All Platforms → Website | GA4 + UTM tracking | Social referral traffic, behavior flow, conversions | GA4 → Looker Studio |
| Website → Revenue | Shopify + GA4 | Purchase attribution from social referral | Shopify → GA4 → Looker Studio |
textUTM STRUCTURE FOR SOCIAL MEDIA
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
LINK IN BIO:
?utm_source=instagram&utm_medium=social&utm_campaign=link-in-bio&utm_content=main-bio-link
STORY LINK:
?utm_source=instagram&utm_medium=social&utm_campaign=story-swipeup&utm_content=[post-topic]-2026
REEL CTA:
?utm_source=instagram&utm_medium=social&utm_campaign=reel-cta&utm_content=[reel-topic]-2026
TIKTOK BIO:
?utm_source=tiktok&utm_medium=social&utm_campaign=link-in-bio&utm_content=main-bio-link
PINTEREST PIN:
?utm_source=pinterest&utm_medium=social&utm_campaign=pin&utm_content=[pin-title]-[board]
FACEBOOK POST:
?utm_source=facebook&utm_medium=social&utm_campaign=organic-post&utm_content=[topic]-2026
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━[/protected]
textREVENUE ATTRIBUTION FLOW
━━━━━━━━━━━━━━━━━━━━━━━━
LEVEL 1: DIRECT ATTRIBUTION (Last-Click)
→ User clicks UTM-tagged link in social → lands on Shopify
→ Purchases within session → Revenue credited to that social post
→ Tracked in: GA4 + Shopify attribution
LEVEL 2: ASSISTED ATTRIBUTION (Multi-Touch)
→ User sees Instagram Reel (Day 1) → Visits website from
bio link (Day 3) → Returns via Google search (Day 6)
→ Purchases
→ Social credited as "assisted conversion" with weighted attribution
→ Tracked in: GA4 multi-channel funnel report
LEVEL 3: INFLUENCED ATTRIBUTION (View-Through)
→ Correlate social posting activity with overall revenue trends
→ Did revenue spike when certain content went live?
→ Weekly correlation analysis: social engagement ↔ revenue
→ Tracked in: Custom Looker Studio correlation widget
RESULT: Three levels of attribution showing social's FULL
revenue impact — not just last-click (which undervalues social)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━[/protected]
| Competitor | TikTok | Why Track | |
|---|---|---|---|
| Competitor A (Market Leader) | 186K | 94K | Content strategy benchmark, aspiration target |
| Competitor B (Direct Rival) | 52K | 28K | Closest competitor, market share battle |
| Competitor C (Fast Grower) | 34K | 68K | TikTok-first strategy worth studying |
| Competitor D (Premium Brand) | 42K | 12K | Brand positioning reference |
| Competitor E (Indie Darling) | 28K | 44K | Community-building approach to learn from |
| Competitor F (International) | 120K | 56K | Global best practices to adapt locally |
| Metric | PureGlow | Industry Avg | Top Competitor | Gap |
|---|---|---|---|---|
| IG Engagement Rate | 1.8% | 3.5% | 5.2% | -3.4% (major gap) |
| IG Growth Rate/Month | +1.2% | +2.8% | +4.6% | -3.4% (falling behind) |
| TikTok Avg Views | 4,200 | 12,000 | 48,000 | Need viral content strategy |
| Content Mix (Video %) | 28% | 55% | 72% | Underweight on video |
| Posting Frequency (IG) | 2.1/day | 1.5/day | 1.8/day | Posting MORE but performing LESS |
| Saves per Post (IG) | 18 avg | 45 avg | 124 avg | Save-worthy content deficit |
| UGC as % of Content | 4% | 18% | 32% | Massive UGC opportunity |
| Data Field | What It Tracks | Why It Matters |
|---|---|---|
| Post ID/URL | Link to original post | Reference and audit trail |
| Platform | Instagram, TikTok, etc. | Cross-platform comparison |
| Content Type | Reel, Carousel, Static, Story, Pin, Video | Performance by format |
| Topic/Theme | Product launch, education, tutorial, UGC, behind-scenes, trending | Performance by topic |
| Content Pillar | Educate, Entertain, Inspire, Sell | Balance assessment |
| Post Day/Time | Day of week + time posted | Optimal posting schedule |
| Caption Length | Short (<50), Medium (50-150), Long (150+) | Caption optimization |
| Hashtag Set | Which hashtag group used | Hashtag effectiveness |
| CTA Type | Shop now, Save this, Comment, Link in bio, None | CTA effectiveness |
| Impressions | Raw view count | Visibility measure |
| Reach | Unique viewers | True audience size |
| Engagement (Total) | Likes + comments + saves + shares | Overall interaction |
| Engagement Rate | Engagement ÷ Reach × 100 | True performance metric |
| Saves | Bookmark/save count | Content value signal |
| Shares | Share/send count | Virality signal |
| Link Clicks | Bio link, Story link, Pin clicks | Traffic driver |
| Revenue Attributed | Direct revenue from UTM tracking | Bottom-line impact |
| Performance Score | Weighted composite (see below) | Single performance number |
| Factor | Weight | Measurement |
|---|---|---|
| Engagement Rate vs. Account Average | 25% | 2× avg = full score, 1× = half, <0.5× = zero |
| Save Rate | 20% | Saves ÷ Reach — highest value signal |
| Share Rate | 20% | Shares ÷ Reach — virality signal |
| Link Clicks | 15% | Website traffic driven |
| Revenue Attributed | 15% | Direct sales generated |
| Comments Quality | 5% | Positive/meaningful vs. spam/emoji-only |
| Widget | Shows |
|---|---|
| Total Audience (All Platforms) | Combined follower count with growth trend |
| Growth Rate by Platform | Weekly/monthly growth % — which platform is accelerating? |
| Total Engagement (Cross-Platform) | Blended engagement rate with industry benchmark comparison |
| Social-Attributed Revenue | Direct + assisted revenue from social with monthly trend |
| Revenue by Platform | Which platform generates most sales? |
| Top 5 Performing Posts (This Month) | Thumbnail + platform + performance score |
| Content Mix Health | Pie chart: content type distribution vs. recommended mix |
| Competitor Position Map | PureGlow vs. 6 competitors — engagement rate × growth rate scatter plot |
| Widget | Shows |
|---|---|
| Platform selector dropdown | Filter entire dashboard by individual platform |
| Follower growth timeline | Daily follower count with trend line and growth events annotated |
| Reach & impressions trend | Weekly reach rate with benchmark line |
| Engagement breakdown | Likes, comments, saves, shares — composition and trend |
| Best posting times heatmap | Day × hour grid showing engagement rate (when to post) |
| Content type performance | Bar chart comparing Reels vs. Carousel vs. Static vs. Stories |
| Hashtag effectiveness | Top 10 hashtag sets ranked by reach and engagement contribution |
| Top/bottom 5 posts | Best and worst performers with performance scores |
| Audience demographics | Age, gender, location, active hours — with changes over time |
| Widget | Shows |
|---|---|
| Content Performance Distribution | Histogram: how many posts fall in each score bracket (Top/Strong/Average/Under) |
| Performance by Content Pillar | Educate vs. Entertain vs. Inspire vs. Sell — which pillar drives results? |
| Performance by Topic | Which topics (ingredients, routines, launches, UGC, trending) perform best? |
| Content Efficiency Score | Performance per hour of production effort — ROI of content creation time |
| Repurposing Opportunities | Top performers from one platform recommended for cross-posting |
| Content Calendar Adherence | Planned vs. published vs. performance by week |
| A/B Test Results | Caption length, CTA type, posting time — winning variants |
| Widget | Shows |
|---|---|
| Social-Attributed Revenue (MTD) | Direct + assisted + influenced — total social revenue impact |
| Revenue by Platform | Bar chart — Instagram, TikTok, Pinterest, Facebook, YouTube |
| Revenue by Content Type | Which format drives most sales? |
| Revenue per Follower | Value metric by platform — quality over quantity |
| Cost of Social (Team + Tools) | Monthly social media investment |
| Social Media ROI | Revenue ÷ Cost — clear ROI calculation |
| Revenue Correlation | Social engagement activity vs. Shopify revenue — weekly correlation graph |
| Top Revenue-Driving Posts | Posts with highest attributed revenue this month |
| Report | Frequency | Recipient | Delivery |
|---|---|---|---|
| Daily Engagement Snapshot | Daily 9 AM | Social Media Manager | Slack #social-metrics |
| Weekly Performance Summary | Monday 9 AM | Marketing Director + Social Team | Email + Slack |
| Monthly Social Intelligence Report | 2nd of month | CEO + Marketing Director | Email (PDF) + Slack summary |
| Quarterly Strategic Review | Quarterly | Leadership team | PDF + presentation deck |
| Real-Time Alerts | As triggered | Social Team | Slack |
| Alert | Trigger | Notification |
|---|---|---|
| Viral Content | Any post reaches 3× average reach within 24 hours | Slack 🔥: “Viral alert! [Post] is blowing up — consider boosting” |
| Engagement Drop | Weekly engagement rate drops 25%+ vs. 4-week average | Slack ⚠️: Investigate — content quality or algorithm change? |
| Follower Spike | 200+ new followers in a day (unusual growth) | Slack 📈: Identify source — viral post, mention, or bot attack? |
| Follower Drop | 100+ unfollows in a day | Slack 📉: Investigate — controversial post or bot cleanup? |
| Competitor Alert | Competitor post goes viral (10× their average) | Slack weekly digest: what competitors are doing differently |
| Revenue Spike from Social | Daily social-attributed revenue exceeds 2× average | Slack 💰: Identify which post/platform is driving sales |
| Negative Sentiment Spike | Comment sentiment analysis detects surge in negative comments | Slack 🚨: Potential PR issue — review immediately |
Based on 12 months of data analysis, we delivered actionable strategy shifts:
| Finding | Recommendation | Expected Impact |
|---|---|---|
| Educational carousels have 3.8% engagement vs. 1.2% for static photos | Shift content mix: 40% carousels, 35% Reels, 15% UGC, 10% static (from current 49% static) | +60% average engagement rate |
| Tutorial Reels drive 3× more saves than trending audio Reels | Prioritize educational Reels over trend-chasing Reels | Higher save rate → algorithm boost |
| Wednesday 7-8 PM and Sunday 10-11 AM show 42% higher engagement | Shift posting schedule to peak engagement windows | +20-30% reach per post |
| UGC content has 2.8× higher conversion rate than brand-produced | Launch UGC program — target 25% of content from customers | Higher revenue attribution |
| Pinterest drives 310 clicks/month (more than Facebook at 140) | Increase Pinterest investment, reduce Facebook organic effort | Better traffic ROI per hour invested |
| Captions 80-120 words outperform both shorter and longer | Standardize caption length to medium-form | +15% engagement consistency |
| Posts with “Save this for later” CTA get 2.4× more saves | Add save-focused CTA to all educational content | Increased algorithmic distribution |
| Long-form YouTube videos drive highest revenue per view | Increase YouTube to 4 videos/month (from 2) | Higher total social revenue |
| Platform | Current | 6-Month Target | Growth Strategy |
|---|---|---|---|
| 48K, 1.8% ER | 72K, 3.8% ER | Quality content shift, UGC program, Reels-first | |
| TikTok | 22K, 4.2% ER | 55K, 6.5% ER | Tutorial-focused content, consistent posting, trends with brand twist |
| YouTube | 8K, 3.8% ER | 16K, 4.5% ER | Increased upload frequency, SEO-optimized titles, end screens |
| 12K, 2.1% save rate | 28K, 3.5% save rate | SEO-rich pin descriptions, fresh pins daily, idea pins | |
| 18K, 0.6% ER | 18K, 1.2% ER | Reduce organic effort, focus on community group, boost top performers | |
| Social-Attributed Revenue | $8,200/month | $23,100/month | Revenue-focused content strategy + UTM tracking optimization |
textPUREGLOW SOCIAL MEDIA INTELLIGENCE — MARCH 2025
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
📊 OVERALL: Strong Improvement (Score: 74/100, ↑11 vs Feb)
👥 AUDIENCE GROWTH:
Total audience: 112,400 (+4,200 this month, +3.9%)
Fastest growing: TikTok (+8.2%) 🚀
Needs attention: Facebook (+0.3%) — consider reducing effort
💬 ENGAGEMENT:
Blended engagement rate: 3.1% (↑ from 2.4% Feb)
Top platform: TikTok (6.8% ER) — tutorial Reels crushing it
Most saved content: "5-Step Night Routine for Oily Skin" carousel
(842 saves — highest ever! Repurpose for TikTok + Pinterest)
💰 REVENUE ATTRIBUTION:
Social-attributed revenue: $14,800 (↑42% vs Feb)
Top revenue platform: Instagram ($6,400) then Pinterest ($3,800)
Top revenue post: Product launch Reel for Vitamin C Serum ($2,400 direct)
Revenue per follower: Instagram $0.13, Pinterest $0.31 (Pinterest
is the hidden revenue champion!)
🏆 COMPETITOR SNAPSHOT:
PureGlow engagement rate now ABOVE industry average (3.1% vs 3.0%)
Competitor C went viral on TikTok with dermatologist collab — consider
expert collaboration content
Competitor A losing engagement (-12% MoM) despite follower growth —
their audience growth is lower quality
📈 TOP RECOMMENDATIONS:
1. Triple down on educational carousels — 3.8% ER, highest saves
2. Launch "SkinSchool" series on TikTok (tutorial format dominating)
3. Increase Pinterest effort — highest revenue per follower ($0.31)
4. Reduce Facebook organic to 3 posts/week (ROI doesn't justify more)
5. Start UGC collection program — customer photos convert 2.8× better
6. Repurpose top IG carousel as Pinterest infographic pins (easy win)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━[/protected]
| Feature | Description |
|---|---|
| 5-Platform Unified Analytics | Instagram, TikTok, Facebook, YouTube, and Pinterest data aggregated into a single view via Sprout Social + custom Looker Studio integration |
| Value-Based KPI Framework | Replaced vanity metrics with 8 KPI categories measuring growth, reach, engagement quality, content efficiency, traffic, revenue, competitor position, and audience quality |
| Content Performance Scoring (100-Point) | Every post scored across 6 weighted factors — engagement, saves, shares, clicks, revenue, comment quality — enabling data-driven content decisions |
| 3-Level Revenue Attribution | Direct (last-click), assisted (multi-touch), and influenced (correlation) attribution connecting social activity to Shopify revenue |
| Competitor Benchmarking System | 6 competitors tracked continuously with relative performance comparison across engagement, growth, content strategy, and share of voice |
| Content Intelligence Database | Airtable tracker logging every post with 18 data fields — enabling topic, format, timing, and CTA performance analysis |
| 4 Custom Dashboards | Executive overview, platform deep-dives, content intelligence, and revenue attribution — all real-time |
| Automated Reporting Suite | Daily snapshots, weekly summaries, monthly intelligence reports, and quarterly strategic reviews — all auto-generated |
| Intelligent Alert System | 7 automated alerts for viral content, engagement drops, follower anomalies, competitor spikes, revenue spikes, and negative sentiment |
| Best Posting Time Heatmap | Data-driven optimal posting schedule by platform, day, and hour based on actual engagement data |
| Monthly AI Intelligence Briefing | ChatGPT-generated strategic analysis with growth metrics, engagement insights, revenue attribution, competitor updates, and actionable recommendations |
| UTM Governance System | Standardized link tracking with auto-generator tool ensuring every social link is properly attributed in GA4 |
| Metric | Before | After (Month 6) | Change |
|---|---|---|---|
| Total Social Audience | 108,700 | 154,200 | ⬆ 42% |
| Instagram Engagement Rate | 1.8% | 4.1% | ⬆ 128% |
| TikTok Engagement Rate | 4.2% | 7.8% | ⬆ 86% |
| Instagram Follower Growth Rate | +1.2%/month | +4.8%/month | ⬆ 300% |
| Average Save Rate (Instagram) | 0.4% | 2.1% | ⬆ 425% |
| Average Share Rate (Instagram) | 0.2% | 1.4% | ⬆ 600% |
| Social-Attributed Revenue/Month | $8,200 (estimated, not tracked) | $23,100 (precisely measured) | ⬆ 182% |
| Revenue Per Follower (Instagram) | Unknown | $0.14/month | Measurable |
| Revenue Per Follower (Pinterest) | Unknown | $0.34/month (highest!) | Measurable |
| Content Pieces Published/Month | 140+ (quantity-focused) | 95 (quality-focused) | ⬇ 32% (intentional) |
| Average Content Performance Score | Unmeasured | 62/100 (and improving monthly) | Measurable |
| Top Performer Posts (Score 80+) | Unmeasured | 18% of all posts | Measurable |
| Reporting Time | 4 hours/month (manual, incomplete) | Zero (fully automated) | ⬇ 100% |
| Social Media ROI | Unknown (assumed cost center) | 4.2× return on social team + tools investment | From invisible to proven |
| Decisions Made from Data | 0 (gut feeling) | 12+ strategic shifts/quarter | From blind to data-driven |
Challenge: PureGlow Skincare was active on 5 social platforms, publishing 140+ posts monthly, but tracking only vanity metrics (likes and followers) in a manual spreadsheet. No revenue attribution, no content performance scoring, no competitor benchmarking, no unified dashboard, and no way to answer “is social media actually making us money?” The team overproduced low-performing static product photos while underinvesting in high-engagement formats.
Solution: We built a complete social media analytics ecosystem — unified 5-platform tracking via Sprout Social, a value-based KPI framework replacing vanity metrics, a 100-point content performance scoring system, 3-level revenue attribution connecting social to Shopify sales, continuous competitor benchmarking against 6 brands, 4 real-time Looker Studio dashboards, automated reporting, intelligent alerts, and monthly AI strategy briefings.
Result: Social-attributed revenue grew 182% ($8,200 to $23,100/month) while actually publishing 32% fewer posts (quality over quantity). Instagram engagement rate jumped from 1.8% to 4.1%. Content production shifted to data-proven formats. Pinterest revealed as highest revenue-per-follower platform ($0.34). Social ROI proven at 4.2× return. Every strategic decision now backed by data, not gut feeling.
