Instructions: Use the Excel template provided as a starting point for your communication planning for a one$-$month period. Your task is the following:

$1.$ In column B $($starting in row $27,$ write the social media platforms that you selected in step $4($previous assignment $$Selecting Social Media$).$

$2.$ Using the goals identified in step $1($previous assignment $$Identifying Your Goals$),$ allocate them in the corresponding day of the month and social media to achieve them. Use your criteria.

For example:

i$.$ To achieve my goal $1,$ I will use Facebook on Day $1,$ Day $3$ and Day $5$ in the first week.

ii$.$ To achieve my goal $2,$ I will use Instagram in Day $2$ and $4$ in the first week.

iii. To achieve my goal $3,$ I will use Pinterest on Day $1,$ Day $3$ and Day $5$ in the first week.

iv$.$ and so on$...$for every day and week until day $30$ in the template.

$3.$ Regarding the other traditional marketing channels described in column A and B$,$ you can modify them according to your criteria and needs.

$4.$ Use color coding to better identify your goals. For example, goal $1$ is in grey; goal $2$ in peach; goal $3$ in green; etc.

REFERENCES: B$26$

$f_x$

A

B

C

D

F

$G$

Description

Perpetuate my brand

Build my social network

Generate Leads that turn into clients