{"product_id":"social-media-content-calendar","title":"Social Media Content Calendar","description":"\u003cp\u003eGeneral information only. It is not accounting, tax, legal or financial advice.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Content plans live in notes, chats and half-finished lists. Nobody can see at a glance what is planned for which week, what is ready, what has gone out and what has slipped past its date.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of content ideas, one of posts, one of campaigns and one of results. Each post has a date, a title, a channel, a format, a campaign, an owner, a status and its caption text. The workbook counts posts by status for each week, by channel and by format, and adds up the reach, clicks and leads you type for each campaign. Nothing is posted, scheduled, sent or fetched by this workbook. A post's status is a note you type, and results are numbers you type after the post has gone out.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eKeep content ideas in one place, with a theme and format, and mark each one New, Scheduled or Set aside.\u003c\/li\u003e\n\u003cli\u003ePlan one row per post, with its date, channel, format, campaign, owner, status and caption text.\u003c\/li\u003e\n\u003cli\u003eSee posts by status (Draft, Ready, Posted, Skipped) for each of eight weeks, as a table and a bar chart.\u003c\/li\u003e\n\u003cli\u003eSee posts past their date and not yet posted, shown in amber, and ready posts that have not gone out.\u003c\/li\u003e\n\u003cli\u003eSee which channels and formats you use most, with a share of all posts.\u003c\/li\u003e\n\u003cli\u003eType the reach, clicks and leads for each post, and see them added up by campaign, with a click rate.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (hospitality, retail or professional services) to load suitable channel, format and content theme lists, then edit them to suit you.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and four export sheets repeat your records under plain field names.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your business name, choose your industry, and type the date your first week starts.\u003c\/li\u003e\n\u003cli\u003eAdd your ideas, posts and campaigns, and type each result after the post has gone out.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard each week.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eHow the weeks work.\u003c\/strong\u003e Weeks on the dashboard are 7-day blocks counted from the start date you type on Settings (First week starts on). The workbook does not work out weekdays: you choose which day a week starts.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Sole traders and small teams who plan their own content and want one clear view of what is planned, ready, posted and overdue.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Businesses that need scheduling or publishing software. This is a spreadsheet: it does not post, schedule, send or fetch anything, and it does not connect to your accounts, your email or other software.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e300 ideas, 500 posts, 100 campaigns and 500 results are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eStatus is a note you type, and results are numbers you type. Nothing is fetched or imported.\u003c\/li\u003e\n\u003cli\u003eThe week table shows eight weeks. A post dated outside them is still counted in the cards at the top.\u003c\/li\u003e\n\u003cli\u003eA result is linked to its post by the post title, so type the title the same way on both sheets.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up bakery shows every sheet working before you start.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eUse this template to capture and improve your business data now. In future you can automate with AI.\u003c\/li\u003e\n\u003cli\u003eGeneral information only. It is not accounting, tax, legal or financial advice.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262419149,"sku":null,"price":21.95,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_26527e69-69a1-49c4-9c96-b799d9d042a2.png?v=1795097636","url":"https:\/\/www.teleworld.online\/en-it\/products\/social-media-content-calendar","provider":"TeleWorld Online","version":"1.0","type":"link"}