Free Social Media Content Calendar Template - Google Sheets - Updated 14 Mar, 2018

	B	D	F	H	J	L
1
2
3
4	Month	Markets	Focus	Objective	Promoted	Type of post
5	Jan 2018	AE	No post	Engagement	Yes	Photo post
6	Feb 2018	SA	Product 1	Views	No	Video post
7	Mar 2018		Product 2	Reach	No post	Link post
8	Apr 2018		Product 3	Traffic
9	May 2018		Product 4	Conversion
10	Jun 2018		Occasion	No post
11	Jul 2018		Competition
12	Aug 2018		Campaign
13	Sep 2018
14	Oct 2018
15	Nov 2018
16	Dec 2018

	A	B	C	D	E	F	G	H	I
1	Client	Brand Name
2	Channel	Facebook
3	Month	Apr 2018
4	Market	AE
5	Version	V1
6	Created by
7	Created on	2/19/2018
8	Budget	$400
9	Allocated	$400
10
11			Sunday, April 1, 2018	Monday, April 2, 2018	Tuesday, April 3, 2018	Wednesday, April 4, 2018	Thursday, April 5, 2018	Friday, April 6, 2018	Saturday, April 7, 2018
12		Focus	No post	No post	No post	No post	Product 1	No post	No post
13		Objective	No post	No post	No post	No post	Engagement	No post	No post
14		Post type					Video post
15		Visual
16		Main caption					lorem ipsum
17		Post ID					123
18		Secondary caption					أبجد هوز
19		Post ID					1234
20		Promotion start					5-Mar-2018
21		Promotion end					7-Mar-2018
22		As per budget sheet	No content	No content	No content	No content	$20	No content	No content
23		Actual allocation					$30
24		Approved?	Yes	Yes	Yes	Yes	Yes	Yes	Yes
25		Promoted?	Yes	No	No	No	Yes	No	No
26
27
28			Sunday, April 8, 2018	Monday, April 9, 2018	Tuesday, April 10, 2018	Wednesday, April 11, 2018	Thursday, April 12, 2018	Friday, April 13, 2018	Saturday, April 14, 2018
29		Focus	Occasion	No post	No post	No post	Product 1	No post	No post
30		Objective	Engagement	No post	No post	No post	Engagement	No post	No post
31		Post Type
32		Visual
33		Main caption	lorem ipsum				lorem ipsum
34		Post ID	1234				14214
35		Secondary caption	أبجد هوز				أبجد هوز
36		Post ID	12345				4235
37		Promotion start	8-Mar-2018				12-Mar-2018
38		Promotion end	10-Mar-2018				14-Mar-2018
39		As per budget sheet	$20	No content	No content	No content	$20	No content	No content
40		Actual allocation	$20				$10
41		Approved?	Yes	Yes	Yes	Yes	Yes	Yes	Yes
42		Promoted?	No	No	No	No	Yes	No	No
43
44
45			Sunday, April 15, 2018	Monday, April 16, 2018	Tuesday, April 17, 2018	Wednesday, April 18, 2018	Thursday, April 19, 2018	Friday, April 20, 2018	Saturday, April 21, 2018
46		Focus	Campaign	No post	No post	No post	No post	Occasion	No post
47		Objective	Engagement	No post	No post	No post	No post	Engagement	No post
48		Post Type
49		Visual
50		Main caption	lorem ipsum					lorem ipsum
51		Post ID	1245
52		Secondary caption	أبجد هوز					أبجد هوز
53		Post ID	15423
54		Promotion start	15-Mar-2018
55		Promotion end	17-Mar-2018
56		As per budget sheet	$100	No content	No content	No content	No content	$20	No content
57		Actual allocation	$100					$20
58		Approved?	Yes	Yes	Yes	Yes	Yes	Yes	Yes
59		Promoted?	No	No	No	No	No	No	No
60
61
62			Sunday, April 22, 2018	Monday, April 23, 2018	Tuesday, April 24, 2018	Wednesday, April 25, 2018	Thursday, April 26, 2018	Friday, April 27, 2018	Saturday, April 28, 2018
63		Focus	Product 3	No post	No post	No post	Competition	No post	No post
64		Objective	Engagement	No post	No post	No post	Engagement	No post	No post
65		Post Type	Video post				Photo post
66		Visual
67		Main caption	lorem ipsum				lorem ipsum
68		Post ID	1234
69		Secondary caption	أبجد هوز				أبجد هوز
70		Post ID					1245
71		Promotion start	22-Mar-2018				26-Mar-2018
72		Promotion end	24-Mar-2018				28-Mar-2018
73		As per budget sheet	$100	No content	No content	No content	$80	No content	No content
74		Actual allocation	$100				$80
75		Approved?	Yes	Yes	Yes	Yes	Yes	Yes	Yes
76		Promoted?	No	No	No	No	No	No	No
77
78
79			Sunday, April 29, 2018	Monday, April 30, 2018	Tuesday, May 1, 2018
80		Focus	Product 4	No post	No post
81		Objective	Engagement	No post	No post
82		Post Type
83		Visual
84		Main caption	lorem ipsum
85		Post ID	1245
86		Secondary caption	أبجد هوز
87		Post ID
88		Promotion start
89		Promotion end	29-Mar-2018
90		As per budget sheet	$40	No content	No content
91		Actual allocation	$40
92		Approved?	Yes	Yes	Yes
93		Promoted?	No	No	No

	A	B	C	D	E	F	G	H	I
1	Client	Brand Name
2	Channel	Facebook
3	Month	Mar 2018
4	Market	SA
5	Version	V1
6	Created by
7	Created on	2/19/2018
8	Budget	$600
9	Allocated	$600
10
11			Thursday, March 1, 2018	Friday, March 2, 2018	Saturday, March 3, 2018	Sunday, March 4, 2018	Monday, March 5, 2018	Tuesday, March 6, 2018	Wednesday, March 7, 2018
12		Focus	No post	No post	No post	No post	Product 3	No post	No post
13		Objective	No post	No post	No post	No post	Engagement	No post	No post
14		Post type					Link post
15		Visual
16		Main caption					lorem ipsum
17		Post ID					15123
18		Secondary caption					أبجد هوز
19		Post ID					132412
20		Promotion start
21		Promotion end
22		As per budget sheet	No content	No content	No content	No content	$90	No content	No content
23		Actual allocation					$90
24		Approved?	Yes	Yes	Yes	Yes	Yes	Yes	Yes
25		Promoted?	Yes	No	No	No	Yes	No	No
26
27
28			Thursday, March 8, 2018	Friday, March 9, 2018	Saturday, March 10, 2018	Sunday, March 11, 2018	Monday, March 12, 2018	Tuesday, March 13, 2018	Wednesday, March 14, 2018
29		Focus	Occasion	No post	No post	No post	Product 1	No post	No post
30		Objective	Engagement	No post	No post	No post	Engagement	No post	No post
31		Post Type	Link post				Video post
32		Visual
33		Main caption	lorem ipsum				lorem ipsum
34		Post ID	14212				124
35		Secondary caption	أبجد هوز				أبجد هوز
36		Post ID	5124				51234
37		Promotion start	8-Mar-2018				12-Mar-2018
38		Promotion end	11-Mar-2018				14-Mar-2018
39		As per budget sheet	$60	No content	No content	No content	$60	No content	No content
40		Actual allocation	$60				$60
41		Approved?	Yes	Yes	Yes	Yes	Yes	Yes	Yes
42		Promoted?	Yes	No	No	No	Yes	No	No
43
44
45			Thursday, March 15, 2018	Friday, March 16, 2018	Saturday, March 17, 2018	Sunday, March 18, 2018	Monday, March 19, 2018	Tuesday, March 20, 2018	Wednesday, March 21, 2018
46		Focus	Product 2	No post	No post	No post	No post	Product 1	No post
47		Objective	Engagement	No post	No post	No post	No post	Engagement	No post
48		Post Type	Photo post					Link post
49		Visual
50		Main caption	lorem ipsum					lorem ipsum
51		Post ID	1242
52		Secondary caption	أبجد هوز					أبجد هوز
53		Post ID	1235
54		Promotion start	15-Mar-2018
55		Promotion end	18-Mar-2018
56		As per budget sheet	$120	No content	No content	No content	No content	$60	No content
57		Actual allocation	$120					$60
58		Approved?	Yes	Yes	Yes	Yes	Yes	Yes	Yes
59		Promoted?	No	No	No	No	No	No	No
60
61
62			Thursday, March 22, 2018	Friday, March 23, 2018	Saturday, March 24, 2018	Sunday, March 25, 2018	Monday, March 26, 2018	Tuesday, March 27, 2018	Wednesday, March 28, 2018
63		Focus	Occasion	No post	No post	No post	Product 3	No post	No post
64		Objective	Engagement	No post	No post	No post	Engagement	No post	No post
65		Post Type	Photo post				Video post
66		Visual
67		Main caption	lorem ipsum				lorem ipsum
68		Post ID	124				4125
69		Secondary caption	أبجد هوز				أبجد هوز
70		Post ID					14123
71		Promotion start	22-Mar-2018				26-Mar-2018
72		Promotion end	25-Mar-2018				28-Mar-2018
73		As per budget sheet	$60	No content	No content	No content	$90	No content	No content
74		Actual allocation	$60				$90
75		Approved?	Yes	Yes	Yes	Yes	Yes	Yes	Yes
76		Promoted?	No	No	No	No	No	No	No
77
78
79			Thursday, March 29, 2018	Friday, March 30, 2018	Saturday, March 31, 2018
80		Focus	Product 4	No post	No post
81		Objective	Engagement	No post	No post
82		Post Type	Photo post
83		Visual
84		Main caption	lorem ipsum
85		Post ID
86		Secondary caption	أبجد هوز
87		Post ID
88		Promotion start	29-Mar-2018
89		Promotion end	31-Mar-2018
90		As per budget sheet	$60	No content	No content
91		Actual allocation	$60
92		Approved?	Yes	Yes	Yes
93		Promoted?	No	No	No

	A	B	C	D	E	F	G	H	I	J	K	L
1
2	Monthly Budget	$1,000
3	Current allocation	$1,000
4
5
6
7	Number of posts >> Calculated.
8	Markets	Mkt. Split	Budget	Total Posts	Product 1	Product 2	Product 3	Product 4	Occasion	Competition	Campaign
9	AE	40%	$400	8	2	0	1	1	2	1	1
10	SA	60%	$600	8	2	1	2	1	2	0	0
11	Total	100%	$1,000	16
12
13
14	Percentage Split	Enter product split >>
15	Markets	Mkt. Split	Budget	Current allocation	Product 1	Product 2	Product 3	Product 4	Occasion	Competition	Campaign	Totals
16	AE	40%	$400	$400	10%		25%	10%	10%	20%	25%	100%
17	SA	60%	$600	$600	20%	20%	30%	10%	20%			100%
18	Total	100%	$1,000	$1,000
19
20
21	Per Post Budget >>
22	Markets	Mkt. Split	Budget	Total Posts	Product 1	Product 2	Product 3	Product 4	Occasion	Competition	Campaign
23	AE	40%	$400	8	$20	$0	$100	$40	$20	$80	$100
24	SA	60%	$600	8	$60	$120	$90	$60	$60	$0	$0
25	Total	100%	$1,000	16