}

Create a 1-Page Marketing Plan

by Jennifer Beever

I like working from a one-page marketing plan for my clients and for my own business, whether or not we have a multi-page written plan as well. I used to use Microsoft Project to create a Gantt chart of the marketing plan timeline, but few of my clients had the program nor did they want to endure the learning curve in order to be able to use it.

I now use Microsoft Excel to show the marketing objective, tasks, resources, start dates, and timeline as well as the estimated and actual costs and measurable results. My clients can more easily maintain the chart if they choose to, which is so important in light of the fact that marketing is an iterative process, ever-changing as we learn about new tactics, new markets, new ways to do things, etc. On one page we can see where we are, what each person has to do, how much we have or will spend, and what results we’ve achieved.

One Page Marketing Plan One Page Marketing Plan

I usually reserve a cell at the top of the Excel spreadsheet to enter in the business goals that the plan supports. Goals should be measurable and achievable, such as close 100 new customers; increase market share by 30%; double revenues… Whatever your goals are, it’s important to keep everyone’s eyes on them and tie your marketing tactics back to them.

I list the marketing tasks to be done in a left side column. These might include trade show marketing, web site updates, creating brochures and white papers, sending out press releases, holding webinars, etc. Next I add a column for who will do the work, either an employee of the company or an outsource vendor. The next columns are for duration and start date.

In the middle I graphically show each task, indicating its start date, duration and end date. The time segments in most of my timelines are by week, so I show beginning and ending dates by starting or ending the graphic in the week in which the date is. I use different colors for milestones, and sometimes I use different colors for activities that fall in different departments, such as marketing and sales.

On the right side are a number of columns for estimated and actual costs, estimated and actual results. You can add columns to track the variance from estimated to actual. For example, if you budgeted $5,000 to update your web site but spent only $3,000, you are under budget by 40%. Or, if you estimate that you will generate 20 qualified leads and you generate 30, you’ve achieved 150% of your goal.

I take the one-page marketing plan a step further and add a column on the far left, which is for category of marketing tasks. Categories include print, web site, social networking, trade shows, etc. I do this so that I can sort the spreadsheet by person responsible, by category, by date, etc. Sorting by category allows you to see at a glance how much you’re doing or spending in any particular marketing area.

Of course a lot more than formatting a one-page marketing plan on an Excel spreadsheet goes into planning your marketing. You need to have a clear vision, mission and goals; an understanding of your target markets and market personae; data on what has or has not worked in the past; analyses of your marketplace and competition; and a clear understanding of a variety of marketing tactics. But the one-page marketing plan is simple and nets out the information I, my associates, and my clients need to know as we implement marketing for the year.

Do you create a marketing plan each year? How? Do you use it? Please comment below.

Share

{ 6 trackbacks }

Marketing Consultant Dynamics of Marketing Work Process
November 2, 2010 at 7:48 am
Plan Your Marketing for Success So You Don't Crash and Burn
February 3, 2011 at 8:10 am
Is Your Marketing Plan SMART? | NewIncite
August 4, 2011 at 1:07 pm
B2B Marketers: If You Fail to Plan, You Are Planning to Fail — NewIncite
September 5, 2014 at 1:27 pm
Spark New Results from Your B2B Marketing at Mid-Year — NewIncite
July 1, 2015 at 12:31 pm
Event Budget Vorlage Excel - tippsvorlage.info - tippsvorlage.info
October 18, 2019 at 3:32 am

{ 26 comments… read them below or add one }

Tom Slage January 26, 2011 at 3:09 pm

I know this is an old post, but I found it very helpful. Many thanks. I am going to do this for the first time this year. I am an ecommerce marketing manager for a large corporation and I can see this plan lending us a much clearer direction for the year.

Excellent content, my kudos.

olivia February 16, 2011 at 5:06 am

HI, do you have a downloadable template of the one page excel marketing plan? I’d like to see it more closer.
Thanks,

Sawan Gosrani June 13, 2011 at 12:58 pm

Thanks so much for this. Really appreciate the fantastic content. This is the first post I found as I was looking for a marketing timeline strategy and I’m definitely going to use this strategy. Thank you so much!

Jennifer Beever September 20, 2011 at 11:49 am

Hi Olivia,

I will format one for downloading – thanks for the suggestion!

David January 22, 2012 at 8:53 am

Hi Jennifer

I love the structure and format. This looks like a great planning sheet, and what even better, everything is in one place

Is it possible for you to send me this template please.

Many Thanks
David

Sarah March 2, 2012 at 7:57 am

Hi there – would you mind sending me the template as well? As they say, copying is the biggest form of flattery! Thank you!

satya pramod March 17, 2012 at 10:35 pm

I need one page strategic plan for automotive refinish products

Holly Heine March 26, 2012 at 11:00 am

Thank you Olivia. This information is so helpful.

Jennifer, I too am wondering if the document you formatted is available for me to download? If not, are you able/willing to send the template out?

Thank you,
Holly

Joy J. May 11, 2012 at 5:58 am

Hi Jennifer –

This information truly is helpful. Do you have a downloadable template of the spreadsheet or would you be willing to send me the template? Thanks so much!

Jennifer Beever May 14, 2012 at 7:58 pm

I am working on that. It seems there are download performance issues. Any thoughts?

Sally G July 25, 2012 at 12:26 pm

Hi Jennifer,

I am new a creating a marketing plan and found this very helpful. I don’t see that you’ve created a downloadable template as yet – would you be willing to send me the template? Thank you for your consideration!

Best regards,

Sally

Jennifer Beever August 21, 2012 at 10:32 am

Hi Sally, I will work to get the template up ASAP.

Anshumalii October 27, 2012 at 7:26 am

Wow-format as its answers key issues raised by clients: money spends, ROI and timelines in a easy to comprehend dashboard manner. How do I get to start using it? Regards Anshumalii

Chris December 13, 2012 at 9:27 am

This is great! I know it’s been mentioned a few times but is there a download available or would it be possible to get the template emailed Jennifer?
Best regards,
Chris

Chris December 19, 2012 at 4:11 pm

Does anybody know where to download this excellent spreadsheet? Many thanks!

Emily January 28, 2013 at 2:49 am

Just wondering if the template was available?? Thanks

tim santos February 7, 2013 at 4:42 am

Hi, very nice work. I would love to have a copy of this spreadsheet. Is it available for download? Thanks.

Marie Tupy February 15, 2013 at 6:50 am

Can you please direct me to (or email me) your wonderful “One Page Marketing Plan” in Excel? I’m unable to find where the template is up (as alluded to in your Aug. 21, 12 comment) and/or downloadable. Many thanks!

Jennifer Beever April 15, 2013 at 2:56 pm

Hi Tim,

I set up the download in bold at the end of the blog post. Any feedback is appreciated! Happy Marketing!

Jennifer Beever April 15, 2013 at 2:57 pm

Emily, see the download link for the one page marketing plan in bold at the end of the post. It’s also here – https://www.newincite.com/contact/form-to-download-plan/. Please share and comment – I’d appreciate it!

Jennifer Beever April 15, 2013 at 2:57 pm

Hi Chris,

https://www.newincite.com/contact/form-to-download-plan/. Let me know how your marketing goes!

Jennifer Beever April 15, 2013 at 2:58 pm
Jennifer Beever April 15, 2013 at 2:58 pm
Jennifer Beever April 15, 2013 at 2:58 pm
Aneez Rajbhandari January 16, 2015 at 2:31 am

How can I access this template

Jennifer Beever January 17, 2015 at 5:20 pm

Hi Aneez, just use the Download form here and it will direct you to the file. https://www.newincite.com/contact/form-to-download-plan/

Leave a Comment

Previous post:

Next post: