Employer Branding & Recruitment Marketing Dashboard Template

	A	B	C	D	E	F	H	I	K	L
1	Recruitment Channels YTD 2020						Glassdoor Rating YTD	YoY	Comparably Rating YTD	YoY
2	Channel	Program	Applicants	YoY +/-	Hires	YoY	0	0.00%	0	0.00%
3	Career Site	Recruitment Marketing	0	0.00%	0	0.00%
4	The Muse	Recruitment Marketing	0	0.00%	0	0.00%
5	Careers2.0 StackOverflow	Recruitment Marketing	0	0.00%	0	0.00%
6	Glassdoor	Recruitment Marketing	0	0.00%	0	0.00%	Social Engagements YTD	YoY	FairyGodboss Rating YTD	YoY
7	Google Job	Recruitment Marketing	0	0.00%	0	0.00%	0	0.00%	0	0.00%
8	Indeed	Recruitment Marketing	0	0.00%	0	0.00%	Social Engagements are defined as a combination of likes, shares, post clicks, links clicks and comments.
9	LinkedIn (Campaigns)	Recruitment Marketing	0	0.00%	0	0.00%
10	LinkedIn Limited Listing	Recruitment Marketing	0	0.00%	0	0.00%
11	LinkedIn Ad Posting	Recruitment Marketing	0	0.00%	0	0.00%	Social Followers YTD	YoY	Indeed Rating YTD	YoY
12	Entelo	Prospecting	0	0.00%	0	0.00%	0	0.00%	0	0.00%
13	SeekOut	Prospecting	0	0.00%	0	0.00%
14	StackOverflow (Prospecting)	Prospecting	0	0.00%	0	0.00%
15	LinkedIn Prospecting	Prospecting	0	0.00%	0	0.00%
16	Referral	Internal	0	0.00%	0	0.00%	Career Site Traffic YTD	YoY
17	Handshake	Campus	0	0.00%	0	0.00%	0	0.00%
18
19
20	How To Use
21	Here is where you can show a snapshot of all the main touchpoints of recruitment marketing + employer branding to key stakeholders. The thought process is to have a main hub that is updated automatically once you insert the data into the tables. This shows YTD - YOY data but you can adjust to show MoM. The tables are set-up in a way where you can show or pull any data in the way that your team or stakeholders would like to see.
22
23
24	Each dashboard will be updated once you input your data into the tables. Here all the "Export" tabs is where I am sourcing my data and creating formulas off of. I would recommend trying to automate this process as it will be easier in the long run. I've left some formulas in the tables that you can you use to reverse-engineer based on the social tool you are exporting data from. Right now the social media formulas are set up from Sprout Social. Feel free to shoot me an email with any questions! CFitzner@Gmail.com
25
26	I've also left some screenshots beneath each dashboard tab for reference on what an end result would look like.
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