ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Social Media PlatformsDeployment DateTarget Audience(s)Content TypeContent Pillars
(List the 3 over arching themes across all posts)		Short DescriptionAssetsHashtagsMeasurement
2
list which platforms e.g.,Twitter, Facebook
(please group social media activity by platform)		date postedlist 1-3 audiencese.g., post, video, article, shopping, stories, blogPillar 1Pillar 2Pillar 3What is the post about?Images or videos usedList 1-3 hastagsList 3 success measurements? E.g., likes, shares, comments, engagement (time viewing), conversion/sales, new followers
3
ExampleFacebook11-Nov-21Students (18-25VideoStudent LifeBasketball season has begun. Cheer on our Huskies!30 sec video#GBC, #GoHuskiesComments, Time spent viewing
4
Post 1Instagram13-Apr-22photographers (18-29)Multiple photos encouraging
Showcase of Marco Photo Challenge
carrosel images
#ShotoniPhone, #iPhoneMarcoChallenge
likes, comments and new followers
5
Post 2Instagram4-Apr-22men and women (18-29)photo
Testimonial
Testimonial / story about photography
single image#ShotoniPhonelikes, amount of shares and comments
6
Post 3 Instagram1-Apr-22
photographers, men and women (18-29)
Multiple photos
Testimonial
Story about photography and tips
carrosel images#ShotoniPhonelikes, amount of shares and comments
7
Post 4 Instagram31-Mar-22
photographers, men and women (18-29)
photocreativityTips on photography on iPhonesingle image#ShotoniPhonelikes, amount of shares and comments
8
Post 5 Instagram29-Mar-22
photographers, men and women (18-29)
Multiple photos creativityTips on photography on iPhone carrosel images#ShotoniPhonelikes, amount of shares and comments
9
Post 6Instagram15-Mar-22Women (all ages)Multiple photos encouragingWomen History monthimage #ShotoniPhonelikes, amount of shares and comments
10
Post 7Instagram14-Mar-22Film-makers (18-29)Multiple photos encouragingCapturing moments image#ShotoniPhonelikes, amount of shares and comments
11
Post 8Instagram2-Mar-22brazilians, south americians (all ages)video creativityCarnaval in Brazilvideo - 1:01 min
#ShotoniPhone, fantasia, Carnaval
likes, comments and views
12
Post 9Instagram21-Feb-22African American Community (all ages)videoencouragingBlack History Monthvideo - 38 seconds#ShotoniPhonelikes, comments and views
13
Post 10Instagram21-Jan-22photographers (18-29)video
Testimonial
Ability of iPhone 13 Pro Camera video - 54 seconds#macro, #ShotoniPhonelikes, comments and views
14
Post 11Instagram21-Jul-21men and women (18-30), film makersvideoMaking movie with iPhonevideo - 32 seconds#DIY, #ShotoniPhonelikes, comments and views
15
Post 12Instagram30-Jun-21
men and women (18-30), photographers
videocreativityFilming Golden Hour Silouettesvideo - 32 seconds#GoldenHour, #ShotoniPhonelikes, comments and views
16
Post 13TikTok18-Jan-01
women and men (18-30), health conscious
videoencouraging
Close Your Fitness Rings on Apple Watch
video - 34 seconds#CloseYourRingslikes, comments and views
17
Post 14TikTok8-Dec-21artists, women (18-29)videocreativity
How to make digital masks on iPad
video - 45 seconds#MadeOniPad, #BrutalMaskslikes, comments and views
18
Post 15TikTok9-Sep-09artists, men and women (18-30)video
How to make digital masks on iPad
video - 45 seconds#MadeOniPad, #BrutalMaskslikes, comments and views
19
Post 16Instagram15-Jun-21
women and men (all ages), LGBTQ+ community
blog
Pride 2021 - Pride History - Guide
images and text#Pride, #ShotoniPhonelikes, amount of shares and comments
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100