Jobs Closed by Quarter / Job Age - Greenhouse Reports Connector
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
2
3
Objective: How many jobs are closing each quarter? How long have jobs been open for?
4
5
6
7
8
Context: You should use this report if you are trying to view job openings over time and view how long jobs stay open. This is a useful metric if you are trying to determine team capacity for future recruiting efforts. This resource leverages additional calculations based off of the standard Greenhouse reports.
9
10
INSTRUCTIONS
11
STEP 1: COPY this Google Sheet, so you have a version you can make changes to and edit!
12
13
STEP 2: IMPORT a report from Greenhouse. Go to the IMPORT tab on this sheet. It is has all the instructions for which report to import. Check out the GIF to the right for more help on where to find the report for this example.
14
STEP 3: CALCULATE in a separate tab from the imported data. This is where you have the power to build out additional formulas and calculations that you can't get directly in Greenhouse!
15
16
17
18
19
STEP 4: VISUALIZE the data with additional flexibility. Now you are ready to manipulate your data! In another tab add in any charts, visuals, or pivot tables!
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
Loading...