{"product_id":"marketing-planner","title":"Marketing Planner","description":"\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Marketing ideas, budgets and posting plans end up in notebooks, inboxes and memory. Nobody has one clear view of what has been spent, what each lead cost, what is due to be published this month or which lead source brings in the customers.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of campaigns, one content calendar and one table of lead sources. The workbook works out cost per lead for each campaign, adds up budget and spend, counts this month's content by status, and shows which lead source turns the most leads into customers.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee total budget, spend to date, budget left and the share of budget spent.\u003c\/li\u003e\n\u003cli\u003eSee cost per lead for each campaign and for all campaigns together, as a table and a bar chart.\u003c\/li\u003e\n\u003cli\u003eSee how many campaigns are running and how many are over budget.\u003c\/li\u003e\n\u003cli\u003eSee content published this month against everything planned, and content by status: idea, drafted, scheduled or published.\u003c\/li\u003e\n\u003cli\u003eSee leads, customers and conversion for each lead source, and the best source.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (home services, professional services or retail) to load suitable lists of marketing channels, content types and lead sources, 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 three export sheets repeat your campaigns, content and lead sources 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 and currency symbol, and choose your industry.\u003c\/li\u003e\n\u003cli\u003eAdd your campaigns, your content calendar and your lead sources.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard each week.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Sole traders, freelancers, trades and small businesses that plan their own marketing and want to keep track of it by hand.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Teams that already work in marketing software, or that need posts, ads or emails sent or tracked automatically. This is a spreadsheet: it does not connect to your advertising, social media, email or website accounts, and it does not publish anything for you.\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\u003eWorks with any currency: you set the symbol on the Settings sheet.\u003c\/li\u003e\n\u003cli\u003e200 campaign rows, 500 content rows and 40 lead source rows are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up business 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":48859261862093,"sku":null,"price":29.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_0007932f-7785-455a-a9ad-52598bec4c54.png?v=1795099801","url":"https:\/\/www.teleworld.online\/vi\/products\/marketing-planner","provider":"TeleWorld Online","version":"1.0","type":"link"}