In [48]:

    

import pandas as pd
from sqlalchemy import create_engine
engine = create_engine('postgresql://localhost:5432/ci_inspirations')


    

In [2]:

    

action_df = pd.read_csv('data/actions.csv')
custom_insp_df = pd.read_csv('data/custom_inspirations.csv')


    

In [4]:

    

action_df.fillna('')
custom_insp_df.fillna('')


    

    
Out[4]:







  

    

      

      
inspiration_uuid
      
name
      
excerpt
      
description
      
source_inspiration
      
created_at
      
updated_at
      
account
      
question_id
      
question_text
    
  
  

    

      
0
      
2aaa820b-b908-41a8-949b-f2001a00a47d
      
Unconscious bias
      
Unconscious bias training
      
Address bias in the workplace by training indi...
      

      
2018-01-25T05:32:10.508004
      
2018-01-25T05:32:10.518295
      
cimic
      
71c5d846-f9d1-4488-a759-4a6665ed26c9
      
My job performance is evaluated fairly
    
    

      
1
      
2aaa820b-b908-41a8-949b-f2001a00a47d
      
Unconscious bias
      
Unconscious bias training
      
Address bias in the workplace by training indi...
      

      
2018-01-25T05:32:10.508004
      
2018-01-25T05:32:10.518295
      
cimic
      
0abf1183-464c-46ca-bf3b-7e3cddaa0cb4
      
I have access to the learning and development ...
    
    

      
2
      
2aaa820b-b908-41a8-949b-f2001a00a47d
      
Unconscious bias
      
Unconscious bias training
      
Address bias in the workplace by training indi...
      

      
2018-01-25T05:32:10.508004
      
2018-01-25T05:32:10.518295
      
cimic
      
c430d34c-fd6a-49fb-83e5-a3039188c5a3
      
My job performance is evaluated fairly
    
    

      
3
      
2aaa820b-b908-41a8-949b-f2001a00a47d
      
Unconscious bias
      
Unconscious bias training
      
Address bias in the workplace by training indi...
      

      
2018-01-25T05:32:10.508004
      
2018-01-25T05:32:10.518295
      
cimic
      
93e616c9-25a0-4b0f-8a29-59793e4c12e1
      
I have access to the learning and development ...
    
    

      
4
      
9c63d8d0-27f6-4e40-8838-cf37d3b03f12
      
Broaden your network
      
Learning from someone external to the team
      
Learn from leaders outside the business. Invit...
      

      
2018-01-25T06:48:02.535976
      
2018-01-25T06:48:02.541787
      
cimic
      
309bf0c9-4e6e-495e-ac04-7ef4909abf03
      
I am given opportunities to develop skills rel...
    
    

      
5
      
9c63d8d0-27f6-4e40-8838-cf37d3b03f12
      
Broaden your network
      
Learning from someone external to the team
      
Learn from leaders outside the business. Invit...
      

      
2018-01-25T06:48:02.535976
      
2018-01-25T06:48:02.541787
      
cimic
      
e5aa72d5-f73c-4e09-a5a3-6082cfa6672c
      
I am given opportunities to develop skills rel...
    
    

      
6
      
6badccba-9ac5-4592-a23c-80f2aaade083
      
Embrace failure
      
Use failure as a learning experience
      
Encourage team members to share learning that ...
      

      
2018-01-25T06:54:59.617961
      
2018-01-25T06:54:59.624123
      
cimic
      
93e616c9-25a0-4b0f-8a29-59793e4c12e1
      
I have access to the learning and development ...
    
    

      
7
      
6badccba-9ac5-4592-a23c-80f2aaade083
      
Embrace failure
      
Use failure as a learning experience
      
Encourage team members to share learning that ...
      

      
2018-01-25T06:54:59.617961
      
2018-01-25T06:54:59.624123
      
cimic
      
0abf1183-464c-46ca-bf3b-7e3cddaa0cb4
      
I have access to the learning and development ...
    
    

      
8
      
2b1d8949-e901-4cbd-972a-fe532462f11c
      
The how sandwich
      
Directing focus and attention on others vs. self
      
The challenge is for managers to apply the 'ho...
      

      
2018-01-25T06:57:08.957746
      
2018-01-25T06:57:08.962405
      
cimic
      
c21732da-1e0d-4e32-8b04-78b0fa9343e6
      
My Supervisor genuinely cares about my wellbeing
    
    

      
9
      
2b1d8949-e901-4cbd-972a-fe532462f11c
      
The how sandwich
      
Directing focus and attention on others vs. self
      
The challenge is for managers to apply the 'ho...
      

      
2018-01-25T06:57:08.957746
      
2018-01-25T06:57:08.962405
      
cimic
      
828b5f09-a395-49e9-a979-c74961d93edb
      
My manager genuinely cares about my wellbeing
    
    

      
10
      
2b1d8949-e901-4cbd-972a-fe532462f11c
      
The how sandwich
      
Directing focus and attention on others vs. self
      
The challenge is for managers to apply the 'ho...
      

      
2018-01-25T06:57:08.957746
      
2018-01-25T06:57:08.962405
      
cimic
      
2e504135-8d0e-4add-b848-96f6456d91ed
      
My manager genuinely cares about my wellbeing
    
    

      
11
      
2b1d8949-e901-4cbd-972a-fe532462f11c
      
The how sandwich
      
Directing focus and attention on others vs. self
      
The challenge is for managers to apply the 'ho...
      

      
2018-01-25T06:57:08.957746
      
2018-01-25T06:57:08.962405
      
cimic
      
4d447e39-7db3-4eb9-b1c9-1e54b3ad4a00
      
My manager genuinely cares about my wellbeing
    
    

      
12
      
844aed7f-e796-4727-a04b-316f2f1d0b13
      
One-on-One meetings
      
Prioritise One-on-One meetings
      
Embed a consistent practice of one-on-one meet...
      

      
2018-01-25T06:59:33.927723
      
2018-01-25T06:59:33.933766
      
cimic
      
4b24843a-c0b1-4b53-ad48-50e30e1b8a42
      
My manager gives me useful feedback on how wel...
    
    

      
13
      
844aed7f-e796-4727-a04b-316f2f1d0b13
      
One-on-One meetings
      
Prioritise One-on-One meetings
      
Embed a consistent practice of one-on-one meet...
      

      
2018-01-25T06:59:33.927723
      
2018-01-25T06:59:33.933766
      
cimic
      
9fd46883-eee2-4861-9d6f-5b061ab7b258
      
My manager gives me useful feedback on how wel...
    
    

      
14
      
844aed7f-e796-4727-a04b-316f2f1d0b13
      
One-on-One meetings
      
Prioritise One-on-One meetings
      
Embed a consistent practice of one-on-one meet...
      

      
2018-01-25T06:59:33.927723
      
2018-01-25T06:59:33.933766
      
cimic
      
b776da4e-05ed-43a6-8268-5e9fd7f65aa0
      
My manager gives me useful feedback on how wel...
    
    

      
15
      
844aed7f-e796-4727-a04b-316f2f1d0b13
      
One-on-One meetings
      
Prioritise One-on-One meetings
      
Embed a consistent practice of one-on-one meet...
      

      
2018-01-25T06:59:33.927723
      
2018-01-25T06:59:33.933766
      
cimic
      
b4df1e15-62db-4429-91fe-a4650e44cd2f
      
My supervisor gives me useful feedback on how ...
    
    

      
16
      
bee87760-18c4-4872-a157-676060dc3f63
      
Shared responsibilities
      
Setting high standards
      
Use safety interactions, team meetings and dis...
      

      
2018-01-25T07:08:20.394341
      
2018-01-25T07:08:20.399707
      
cimic
      
740f12ca-5d1f-4124-9fd3-4eab0a4c50dc
      
If I notice a workplace hazard, I would stop a...
    
    

      
17
      
bee87760-18c4-4872-a157-676060dc3f63
      
Shared responsibilities
      
Setting high standards
      
Use safety interactions, team meetings and dis...
      

      
2018-01-25T07:08:20.394341
      
2018-01-25T07:08:20.399707
      
cimic
      
ba9400c7-360a-4646-b12f-c7ed6ea18610
      
If I notice a workplace hazard, I would stop a...
    
    

      
18
      
bee87760-18c4-4872-a157-676060dc3f63
      
Shared responsibilities
      
Setting high standards
      
Use safety interactions, team meetings and dis...
      

      
2018-01-25T07:08:20.394341
      
2018-01-25T07:08:20.399707
      
cimic
      
a1416846-c559-40e3-90a2-8d861c44741f
      
If I notice a workplace hazard, I would stop a...
    
    

      
19
      
bee87760-18c4-4872-a157-676060dc3f63
      
Shared responsibilities
      
Setting high standards
      
Use safety interactions, team meetings and dis...
      

      
2018-01-25T07:08:20.394341
      
2018-01-25T07:08:20.399707
      
cimic
      
870a5459-5f4f-4d8f-8fc8-60fba2c6c7c8
      
If I notice a workplace hazard, I would stop a...
    
    

      
20
      
ce23b8c3-4e4b-4c30-8d7a-28f3b425a7dc
      
Thank you
      
End each meeting with a  thank you
      
Leaders to recognize others in the team or bus...
      

      
2018-01-25T07:13:00.497839
      
2018-01-25T07:13:00.502978
      
cimic
      
15557a81-c519-41c8-b82d-cfbae7101dce
      
We acknowledge people who deliver outstanding ...
    
    

      
21
      
ce23b8c3-4e4b-4c30-8d7a-28f3b425a7dc
      
Thank you
      
End each meeting with a  thank you
      
Leaders to recognize others in the team or bus...
      

      
2018-01-25T07:13:00.497839
      
2018-01-25T07:13:00.502978
      
cimic
      
d9311d3c-25cc-4d9a-8d4e-e8b02d84a8a7
      
We acknowledge people who deliver outstanding ...
    
    

      
22
      
76cc932f-d992-426e-b26d-72ebb0017399
      
Names on parade
      
Ensure team member's names are visible
      
Ensure team member's names are visible on thei...
      

      
2018-01-25T07:21:44.610965
      
2018-01-25T07:21:44.616728
      
cimic
      
166e361c-532d-4dbd-82f6-0b5c936c337f
      
I feel I am part of a team
    
    

      
23
      
76cc932f-d992-426e-b26d-72ebb0017399
      
Names on parade
      
Ensure team member's names are visible
      
Ensure team member's names are visible on thei...
      

      
2018-01-25T07:21:44.610965
      
2018-01-25T07:21:44.616728
      
cimic
      
bb7c8606-fe0f-4f2f-83f0-238a982687fc
      
I feel I am part of a team
    
    

      
24
      
76cc932f-d992-426e-b26d-72ebb0017399
      
Names on parade
      
Ensure team member's names are visible
      
Ensure team member's names are visible on thei...
      

      
2018-01-25T07:21:44.610965
      
2018-01-25T07:21:44.616728
      
cimic
      
6b95bf22-be11-4b82-9e3a-bc8f2fc06090
      
I feel I am part of a team
    
    

      
25
      
76cc932f-d992-426e-b26d-72ebb0017399
      
Names on parade
      
Ensure team member's names are visible
      
Ensure team member's names are visible on thei...
      

      
2018-01-25T07:21:44.610965
      
2018-01-25T07:21:44.616728
      
cimic
      
0db502e7-06dd-497a-a06e-47dd0638caf7
      
I feel I am part of a team
    
    

      
26
      
0dbb8ce9-cff4-4d47-8d7f-4284ef378160
      
Seat shuffle
      
Get to know others in the business
      
Allow employees to work from alternate site/of...
      

      
2018-01-25T07:23:14.106600
      
2018-01-25T07:23:14.112953
      
cimic
      
6b95bf22-be11-4b82-9e3a-bc8f2fc06090
      
I feel I am part of a team
    
    

      
27
      
0dbb8ce9-cff4-4d47-8d7f-4284ef378160
      
Seat shuffle
      
Get to know others in the business
      
Allow employees to work from alternate site/of...
      

      
2018-01-25T07:23:14.106600
      
2018-01-25T07:23:14.112953
      
cimic
      
bb7c8606-fe0f-4f2f-83f0-238a982687fc
      
I feel I am part of a team
    
    

      
28
      
0dbb8ce9-cff4-4d47-8d7f-4284ef378160
      
Seat shuffle
      
Get to know others in the business
      
Allow employees to work from alternate site/of...
      

      
2018-01-25T07:23:14.106600
      
2018-01-25T07:23:14.112953
      
cimic
      
166e361c-532d-4dbd-82f6-0b5c936c337f
      
I feel I am part of a team
    
    

      
29
      
0dbb8ce9-cff4-4d47-8d7f-4284ef378160
      
Seat shuffle
      
Get to know others in the business
      
Allow employees to work from alternate site/of...
      

      
2018-01-25T07:23:14.106600
      
2018-01-25T07:23:14.112953
      
cimic
      
0db502e7-06dd-497a-a06e-47dd0638caf7
      
I feel I am part of a team
    
    

      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
    
    

      
8943
      
c544ffb6-d586-4bab-8aed-bb2c68bf00c2
      
D&I as a Company Discussion
      
D&I Highlights
      
During department All-hands, talk about D&I co...
      

      
2018-11-06T10:11:08.380137
      
2018-11-06T10:11:08.392112
      
slack
      
c5e8570d-280a-4082-b0bd-c207e23b6871
      
My department lead demonstrates a visible comm...
    
    

      
8944
      
183df24e-f316-4063-a766-e7b7c6d12d6e
      
Respect All Identities
      
Use language that shows respect for all identi...
      
Use language that shows respect for all identi...
      
29f1cb2d-12aa-4584-aa43-efbf8f924092
      
2018-11-06T10:11:08.543189
      
2018-11-06T10:11:08.559371
      
slack
      
c4e278ba-d261-4222-8361-1811b451f927
      
I feel comfortable being myself at work.
    
    

      
8945
      
8e3ef618-b818-4d7e-9f08-083603e4a9e4
      
Visit other team meetings
      
Increase visibility into and empathy between o...
      
Increase executive visibility and empathy betw...
      
49c02d4c-512a-4637-a49e-201992d522a4
      
2018-11-06T10:11:08.728031
      
2018-11-06T10:11:08.748971
      
slack
      
fc5fed4e-0fb0-467b-83f8-04e51cb1cbbe
      
My department allocates resources toward the h...
    
    

      
8946
      
acd5b7ae-3be5-41d7-82f3-0f1afd5d0561
      
Bridge Courses
      
Share learning opportunities in your departmen...
      
Guide employees to enroll in Bridge courses du...
      

      
2018-11-06T10:11:09.694531
      
2018-11-06T10:11:09.710673
      
slack
      
2d3bded9-f906-4e8e-822b-66078a13a345
      
My manager solicits feedback from me about the...
    
    

      
8947
      
73f0fad3-ff36-4571-abf7-6b76945f0127
      
Listening Sessions
      
Host internal Listening Sessions
      
Have "Listening Sessions" where dept leads mee...
      

      
2018-11-06T10:11:08.283155
      
2018-11-06T10:11:08.299398
      
slack
      
11c6d059-559c-4330-bc48-b3af3174660a
      
I have confidence in my department lead to eff...
    
    

      
8948
      
67fec691-dc64-4bc3-aa8e-4020f047d2e2
      
Respect All Identities
      
Use language that shows respect for all identi...
      
Use language that shows respect for all identi...
      
29f1cb2d-12aa-4584-aa43-efbf8f924092
      
2018-11-06T10:11:08.406939
      
2018-11-06T10:11:08.425726
      
slack
      
eb2e6fc3-d87d-4785-a926-d2a7b75be13f
      
I fit in with my teammates.
    
    

      
8949
      
4764a325-412b-4481-8db9-0f6ce6c8b569
      
Alignment workshops
      
Align work to organization change efforts and ...
      
Align company work processes to company change...
      
f6acf8c7-e8ff-4299-97cd-347bbcacf989
      
2018-11-06T10:11:08.750366
      
2018-11-06T10:11:08.764085
      
slack
      
fc5fed4e-0fb0-467b-83f8-04e51cb1cbbe
      
My department allocates resources toward the h...
    
    

      
8950
      
4b47f43b-8321-4b38-90a4-3aad29b33d6d
      
Feedback in Slack
      
Learn more about Feedback @ Slack
      
Enroll in the SF: Feedback @ Slack course offe...
      

      
2018-11-06T10:11:09.715254
      
2018-11-06T10:11:09.728255
      
slack
      
2d3bded9-f906-4e8e-822b-66078a13a345
      
My manager solicits feedback from me about the...
    
    

      
8951
      
87d43634-7b31-40ce-bf9c-7e3c510b2594
      
Hack the halls
      
Decorate collaboratively
      
Get employees involved in improving their desk...
      
6c2fdcd1-596d-4716-82e2-bc45b0ed6abb
      
2018-11-06T10:11:08.799994
      
2018-11-06T10:11:08.815593
      
slack
      
96e861cd-b6b9-4b9c-bfc7-725acbe02313
      
I enjoy my physical workspace.
    
    

      
8952
      
8d4a2fdf-8b64-40ed-82d3-adee36674fa5
      
Rotating team leads
      
Rotating team leads and assessing impact
      
Increase ownership for team deliverables. One ...
      
5260bfce-b7e5-42e1-a794-a54fc6a8c628
      
2018-11-06T10:11:08.963017
      
2018-11-06T10:11:08.979410
      
slack
      
8e8693f2-6aed-4a9d-8bc8-e833aaafe8ee
      
I can depend on my teammates to deliver qualit...
    
    

      
8953
      
e71cbbd9-5dbb-401e-b124-6e0749198cf3
      
Donut bot
      
Set up meetings with employees that don't know...
      
Encourage employees to join their local #donut...
      
7c144a98-d41e-491c-b425-64b8ca0851eb
      
2018-11-06T10:11:09.092417
      
2018-11-06T10:11:09.144983
      
slack
      
c6d4f6ab-cd58-4557-a1ac-811281cda2fc
      
My team collaborates well with other teams to ...
    
    

      
8954
      
5a5c0fc4-3d95-438e-a5a6-19e48131477e
      
Our vision of the future
      
Frame leadership's vision for the future
      
To frame the long-term vision of the company a...
      
0cc33224-093a-4026-9bb7-29691825b3be
      
2018-11-06T10:11:09.258558
      
2018-11-06T10:11:09.274445
      
slack
      
d22bb1fa-b61a-4239-8622-30cf021b248c
      
I clearly understand Slack's vision.
    
    

      
8955
      
6420bfbd-5367-402b-a8ce-4e5546b3b48a
      
Action update emails
      
Communicate progress addressing feedback
      
Communicate often and regularly about what is ...
      
00e41e9a-d260-49ad-98b5-f70f6c92a258
      
2018-11-06T10:11:09.421226
      
2018-11-06T10:11:09.436445
      
slack
      
f94cd260-cb6e-49bd-9006-71232dd81da3
      
I believe we will act on the results of this s...
    
    

      
8956
      
3d18b58d-d3a4-4fc4-9347-8deed63165eb
      
Coffeehouse meetings
      
Enable casual cross-business current work sharing
      
Create casual forums for cross-team sharing. O...
      
fcc8b1f2-d92c-48de-a08d-dffde6d83431
      
2018-11-06T10:11:08.822339
      
2018-11-06T10:11:08.856082
      
slack
      
225c26e6-81b3-44f0-a6bf-babe58c15f80
      
I'm encouraged and supported in sharing my ide...
    
    

      
8957
      
bbe93c4b-d80d-484a-8e42-2034e64fd57e
      
Process hackathon
      
Use diverse perspectives to improve processes
      
Bring together diverse perspectives to improve...
      
8967feca-5e3f-4239-9c55-91abb8a1e9e5
      
2018-11-06T10:11:08.989218
      
2018-11-06T10:11:09.007680
      
slack
      
69613580-a5b7-4ad3-ab9a-55664c76d1e7
      
My team welcomes diverse perspectives.
    
    

      
8958
      
3491b471-1799-4dad-8e0a-3bacb82d61f7
      
Project day
      
Work together on short term projects
      
Work together across departments and functions...
      
62f2e979-0332-438e-9f6c-f4679c419879
      
2018-11-06T10:11:09.147611
      
2018-11-06T10:11:09.167998
      
slack
      
c6d4f6ab-cd58-4557-a1ac-811281cda2fc
      
My team collaborates well with other teams to ...
    
    

      
8959
      
3a166c46-0695-4156-bef9-e9b44b51637f
      
The Power of Reiteration
      
Communicate your company and team vision multi...
      
Communicate your company and team vision multi...
      
4c4d757e-1178-497f-9af2-f7188914bbbb
      
2018-11-06T10:11:09.282259
      
2018-11-06T10:11:09.299602
      
slack
      
d22bb1fa-b61a-4239-8622-30cf021b248c
      
I clearly understand Slack's vision.
    
    

      
8960
      
a000744c-0a94-47de-a703-370ad050bf8f
      
Synthesis sessions
      
In-person leader facilitated discussions
      
Hold open forums to share information about th...
      
7222a089-95dc-4eed-a181-500d5e1711b2
      
2018-11-06T10:11:08.857306
      
2018-11-06T10:11:08.876510
      
slack
      
225c26e6-81b3-44f0-a6bf-babe58c15f80
      
I'm encouraged and supported in sharing my ide...
    
    

      
8961
      
6cddce57-d427-4f84-87b9-7bd78825dfd1
      
Shark tank style competition
      
Cross-functional teams pitch award ideas
      
Encourage employees to pitch ideas to leaders ...
      
58f77db6-d764-4827-9c13-ada9d996f512
      
2018-11-06T10:11:09.014370
      
2018-11-06T10:11:09.048700
      
slack
      
c6d4f6ab-cd58-4557-a1ac-811281cda2fc
      
My team collaborates well with other teams to ...
    
    

      
8962
      
30b30ab3-d671-407e-b8d2-2e88037210de
      
Personal Operating Manual
      
Consult with L&D to foster internal team colla...
      
Set-up time to speak with an L&D team member a...
      

      
2018-11-06T10:11:09.172154
      
2018-11-06T10:11:09.187534
      
slack
      
c6d4f6ab-cd58-4557-a1ac-811281cda2fc
      
My team collaborates well with other teams to ...
    
    

      
8963
      
772b3911-5b6d-46a8-ad13-25acd73690c6
      
Positive-for-a-week challenge
      
Broadening the meaning and practice of feedback
      
Help managers understand and practice providin...
      
15a34a39-6da8-41b1-a2b1-f112f78f799e
      
2018-11-06T10:11:09.306710
      
2018-11-06T10:11:09.346157
      
slack
      
bdf77f05-a864-4ffb-8a15-8d87b7e88d19
      
My manager gives me useful feedback on how I'm...
    
    

      
8964
      
1abdae9f-3c8a-49eb-adfc-2430c7ad41e0
      
Rapid feedback session
      
Hold sessions focused on sharing admiration of...
      
Provide employees with an opportunity to give ...
      
2732a32f-7c0b-4595-a1aa-55c5a81f96e9
      
2018-11-06T10:11:09.498087
      
2018-11-06T10:11:09.515823
      
slack
      
ed77c4ca-84ae-40e6-917e-5b2526c82a80
      
I get actionable feedback from my peers to imp...
    
    

      
8965
      
bb89188d-449b-45bd-b005-78296fb518e6
      
Enabling innovative ideas
      
Surfacing cross-functional innovative ideas
      
Encourage sharing of ideas across organization...
      
3bfc9c46-ead5-451a-913d-c72878bac070
      
2018-11-06T10:11:08.877822
      
2018-11-06T10:11:08.895797
      
slack
      
225c26e6-81b3-44f0-a6bf-babe58c15f80
      
I'm encouraged and supported in sharing my ide...
    
    

      
8966
      
e5a34fd6-bc3f-4a45-8737-90620c7e6561
      
Information flows exercise
      
Identify information flow blockers
      
The information flows exercise focuses on iden...
      
3dc4a7cb-8908-4581-8d17-b19702df1de8
      
2018-11-06T10:11:09.049773
      
2018-11-06T10:11:09.068687
      
slack
      
c6d4f6ab-cd58-4557-a1ac-811281cda2fc
      
My team collaborates well with other teams to ...
    
    

      
8967
      
eb8ce9a7-700e-4603-b007-41ee4d00fbf6
      
Managing Learning Activities
      
Explore Managing on Bridge
      
Explore our Managing courses provided through ...
      

      
2018-11-06T10:11:09.195655
      
2018-11-06T10:11:09.207105
      
slack
      
b59245cc-d0e4-4064-9946-f02cc46c53e3
      
I'm confident in my manager’s ability to do th...
    
    

      
8968
      
68520dca-bc61-4526-95fe-e5a862847408
      
Decision-making framework
      
Include consulting others in your decision-mak...
      
Making consultation part of the formal decisio...
      
ef4cdbe2-439e-43a7-a198-895e32847b30
      
2018-11-06T10:11:09.523174
      
2018-11-06T10:11:09.549684
      
slack
      
30ffab5a-082d-4a54-8f58-2b25dbcd54ee
      
My manager values my perspectives, even when d...
    
    

      
8969
      
0136a984-d306-4741-bf94-297a686d5b76
      
Team commitments
      
Weekly team targets and commitments
      
Encourage greater individual accountability by...
      

      
2018-11-06T10:11:08.902533
      
2018-11-06T10:11:08.958467
      
slack
      
8e8693f2-6aed-4a9d-8bc8-e833aaafe8ee
      
I can depend on my teammates to deliver qualit...
    
    

      
8970
      
c3ab7a59-8f66-4032-910f-2e7ee478326c
      
Department liaison
      
Facilitate collaboration and prioritization
      
Create a role that facilitates communication b...
      
9b4bca01-674d-4864-a501-d94d3e190c27
      
2018-11-06T10:11:09.071063
      
2018-11-06T10:11:09.088064
      
slack
      
c6d4f6ab-cd58-4557-a1ac-811281cda2fc
      
My team collaborates well with other teams to ...
    
    

      
8971
      
b22e5c61-de4a-4277-bfe3-190b966967a3
      
Level-up alignment sessions
      
Connect employees to organization mission, vis...
      
Connect employees to the organization's missio...
      
eb0aa1a9-0aaf-4009-a985-167c8780aaa7
      
2018-11-06T10:11:09.218555
      
2018-11-06T10:11:09.248060
      
slack
      
d22bb1fa-b61a-4239-8622-30cf021b248c
      
I clearly understand Slack's vision.
    
    

      
8972
      
52453839-d2dc-4023-8793-66e1fd908945
      
Courage to share action stories
      
Share what your team is doing to address feedback
      
To maintain momentum, it's essential that the ...
      
d987ecd5-5e79-4246-aac1-1c3ee4a5f489
      
2018-11-06T10:11:09.400536
      
2018-11-06T10:11:09.412575
      
slack
      
f94cd260-cb6e-49bd-9006-71232dd81da3
      
I believe we will act on the results of this s...
    
  

8973 rows × 10 columns

In [12]:

    

core_insp_df = pd.read_sql_query('select * from core_insp limit 10', con=engine)


    

In [50]:

    

matched_df = pd.read_sql_query('select * from matched limit 20', con=engine)


    

In [52]:

    

import json


    

In [42]:

    

core_insp_dict = [
    {
        'id': str(row['id']),
        'name': row['name'],
        'excerpt': row['excerpt'],
        'description': row['description']
        
    }
    for i, row in core_insp_df.iterrows()
]
json.dumps(core_insp_dict)


    

    
Out[42]:





'[{"id": "3d227a78-2002-4ef4-98c6-03347faa866c", "name": "Swap worst tasks", "excerpt": "Swap your least favorite tasks and see if they can be improved", "description": "Create empathy and understanding by \'working in someone else\'s shoes\'. Encourage employees to swap their least favorite tasks for a week. The goal is for each person to identify a better way of getting the task done by the end of the week. People get better visibility into the not-so-pleasant parts of each role. Additionally, fresh eyes can often lead to new ideas."}, {"id": "c52aefeb-54c5-46fe-b8c6-9285f89e461e", "name": "Manager lotteries", "excerpt": "Connect managers across the business to talk about action", "description": "Pair managers across the organization so that they can meet over lunch or coffee to discuss opportunities and what actions their teams are taking. One company pairs managers who have similar opportunities (identified from recent employee survey results) so that they can learn from each other and break down organizational boundaries. "}, {"id": "4873cbf7-44c0-44e2-9702-a7216daab121", "name": "Reverse interview", "excerpt": "Making dedicated time and formalizing", "description": "Try reverse-interviewing to help prospective employees understand the job expectations and ensure the job is a match for them. The prospect interviews the people who would be their colleagues about the job, the culture and anything else they\'re interested in. The employees being interviewed don\'t ask questions, but focus on responding to the prospect. These sessions usually last 30-45 minutes."}, {"id": "b36cb2af-00ac-43bf-9a54-a83a5cc9fa7c", "name": "Realistic job preview", "excerpt": "Aligning expectations of new hires", "description": "Be intentional about setting expectations for newcomers. One company enhances alignment and establishes trust during the recruiting and onboarding processes through Realistic Job Previews (RJPs). RJPs are communicated through video, sound bites, text and graphics and highlight the positive aspects of the role, organization and values. They provide specific examples of what\'s expected within the first six months of employment. Of equal importance, the RJP covers the challenging aspects of the role, reasons people left in the past and potential challenges new people may face."}, {"id": "4ef79dcb-02b0-494e-a5f4-9ea05cab571b", "name": "Internal communications channels", "excerpt": "Using internal communication channels to align on decisions", "description": "Use internal communications channels to align on decisions. One company uses internal collaboration channels to help team members feel more involved in decision making. Individual channels are created for specific projects and teams to support cross-communication. All key decisions are shared and debated in the relevant channels, ensuring that team members are involved in outcomes that affect day-to-day work activities. Team members are not required to be involved in the conversation, but are welcome to participate if they choose to."}, {"id": "207205f9-8a8b-4903-937e-288b80d4dca2", "name": "Team retrospectives and planning", "excerpt": "Using team retrospectives and planning to learn", "description": "Achieve role clarity through team retrospectives and planning. Retrospective and planning meetings can be held with managers and team leads to align and improve processes. The meetings provide an opportunity to reflect on previous goals, work and processes; discuss what worked well and what could be improved and plan, redirect and align efforts to company goals. At the meeting decisions can be made and alignment on key priorities and roles improved."}, {"id": "d987ecd5-5e79-4246-aac1-1c3ee4a5f489", "name": "Courage to share action stories", "excerpt": "Share what your team is doing to address feedback", "description": "To maintain momentum, it\'s essential that the actions taken as a result of survey feedback are visible to employees. At one company, individual and team actions resulting from feedback are shared at regular state-of-the-business all hands meetings by leaders from each team."}, {"id": "00e41e9a-d260-49ad-98b5-f70f6c92a258", "name": "Action update emails", "excerpt": "Communicate progress addressing feedback", "description": "Communicate often and regularly about what is being done based on employee feedback. One company set up a monthly email update from each leader in the business. The content and format of the email is driven by the leader with no predefined formats or approaches. Leaders get creative in their communications but always make sure to link back to the original feedback and associated action."}, {"id": "58f77db6-d764-4827-9c13-ada9d996f512", "name": "Shark tank style competition", "excerpt": "Cross-functional teams pitch award ideas", "description": "Encourage employees to pitch ideas to executives in a \\"Shark Tank-style\\" competition. At one company cross-fuctional teams were formed to build ideas to pitch to the \\"Sharks\\" - a collection of senior leaders. This program encouraged cross-functional collaboration, healthy competition and recognition of great ideas. Once an idea was selected, resources were made available to implement."}, {"id": "ef4cdbe2-439e-43a7-a198-895e32847b30", "name": "Decision-making framework", "excerpt": "Include consulting others in your decision-making framework", "description": "Making consultation part of the formal decision-making process facilitates transparency and clarity. Share who has been consulted on a decision whenever a decision is shared. By highlighting the names of people who were consulted, reviewers of the decision can quickly identify the basis for the decision. This practice is particularly helpful in global organizations. It is not to demonstrate consensus, but to show that decision-makers considered other perspectives and implications."}]'

In [51]:

    

matched_df.head()


    

    
Out[51]:







  

    

      

      
created_at
      
updated_at
      
_id
      
id1
      
id2
      
type1
      
type2
      
field1
      
field2
      
similarity_score
      
valuable_score
      
constructive_score
    
  
  

    

      
0
      
2018-02-23 00:46:50.662457
      
2018-02-23 00:46:50.662457
      
6d2bb529-caad-4001-8a40-29eaa9cb0cbd
      
a56d35c9-f274-4fd5-a7ac-681ce775529c
      
4e1e81a2-9f33-4473-83dc-c6b8e4917a93
      
action
      
core_insp
      
description
      
description
      
0.08
      
0.994987
      
0.3
    
    

      
1
      
2018-02-22 05:47:46.031484
      
2018-02-22 05:47:46.031484
      
45ff1309-cce0-4f9f-a220-40615094a5c8
      
8bf4dd83-7247-416e-9043-94f621d941f6
      
67e03ed1-02e2-4b2f-89b0-f607c1236212
      
action
      
core_insp
      
description
      
description
      
0.09
      
0.994987
      
0.0
    
    

      
2
      
2018-03-01 19:35:51.723112
      
2018-03-01 19:35:51.723112
      
4b5533e8-0575-48be-b79d-4d7a5705f283
      
46051fb5-0547-4f2a-8c70-33387a27d0db
      
931d7762-9fa4-4a3f-85e3-f8bf75f8f903
      
action
      
core_insp
      
description
      
description
      
0.06
      
0.994987
      
0.0
    
    

      
3
      
2018-01-24 18:27:21.315432
      
2018-01-24 18:27:21.315432
      
291ea717-2ff0-4615-883c-5740c10b4016
      
8f186a80-7ba4-4c59-95e3-cbeb785fba20
      
1ea5dcec-a94d-42df-8104-1f85f43c22d9
      
action
      
core_insp
      
description
      
description
      
0.49
      
0.994987
      
0.0
    
    

      
4
      
2018-02-20 17:51:40.089668
      
2018-02-20 17:51:40.089668
      
0ec59167-327e-4472-b0df-1fba517bb44c
      
5a29fcb3-c2a3-40fe-9f69-e89ee2cfd999
      
c43f038b-c1cf-4204-a2f1-c1e6aa86f587
      
action
      
core_insp
      
description
      
description
      
0.46
      
0.994987
      
0.3
    
  

In [55]:

    

matched_dict = [
    {
        "_id": str(row['_id']),
        "id1": str(row['id1']),
        "id2": str(row["id2"]),
        "type1": row["type1"],
        "type2": row["type2"],
        "field1": row["field1"],
        "field2": row["field2"],
        "similarity_score": row["similarity_score"],
        "valuable_score": row["valuable_score"],
        "constructive_score": row["constructive_score"]
    }
    for i, row in matched_df.iterrows()
]
json.dumps(matched_dict)


    

    
Out[55]:





'[{"_id": "6d2bb529-caad-4001-8a40-29eaa9cb0cbd", "id1": "a56d35c9-f274-4fd5-a7ac-681ce775529c", "id2": "4e1e81a2-9f33-4473-83dc-c6b8e4917a93", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.08, "valuable_score": 0.994987468671679, "constructive_score": 0.3}, {"_id": "45ff1309-cce0-4f9f-a220-40615094a5c8", "id1": "8bf4dd83-7247-416e-9043-94f621d941f6", "id2": "67e03ed1-02e2-4b2f-89b0-f607c1236212", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.09, "valuable_score": 0.994987468671679, "constructive_score": 0.0}, {"_id": "4b5533e8-0575-48be-b79d-4d7a5705f283", "id1": "46051fb5-0547-4f2a-8c70-33387a27d0db", "id2": "931d7762-9fa4-4a3f-85e3-f8bf75f8f903", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.06, "valuable_score": 0.994987468671679, "constructive_score": 0.0}, {"_id": "291ea717-2ff0-4615-883c-5740c10b4016", "id1": "8f186a80-7ba4-4c59-95e3-cbeb785fba20", "id2": "1ea5dcec-a94d-42df-8104-1f85f43c22d9", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.49, "valuable_score": 0.994987468671679, "constructive_score": 0.0}, {"_id": "0ec59167-327e-4472-b0df-1fba517bb44c", "id1": "5a29fcb3-c2a3-40fe-9f69-e89ee2cfd999", "id2": "c43f038b-c1cf-4204-a2f1-c1e6aa86f587", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.46, "valuable_score": 0.994987468671679, "constructive_score": 0.3}, {"_id": "bcd400ad-0afd-473e-b627-aa73ed34a3a8", "id1": "4bd4043c-eff1-4d42-b44f-d2e11cc007f7", "id2": "1f60e471-1c2b-4ba9-8130-b4c3a0fb0956", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.12, "valuable_score": 0.994987468671679, "constructive_score": 0.0}, {"_id": "df22dd30-7f48-40c0-ad71-5c5f9b2b1369", "id1": "938e3a8d-521b-4973-b239-475cf6f2cf25", "id2": "065c067a-8127-4290-b9e0-695ef5ebb2b3", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.1, "valuable_score": 0.994987468671679, "constructive_score": 0.15}, {"_id": "f31dc6d3-a103-44df-978d-0efdd0ba3418", "id1": "af9ac9e5-5fc0-41a2-b006-76277fd82ba4", "id2": "fade6361-3514-45f9-8ad7-9be84dafb609", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.14, "valuable_score": 0.994987468671679, "constructive_score": 0.3}, {"_id": "00e482fc-e443-4a55-b942-0f5bc9fa5565", "id1": "dfca426b-58c6-4351-a35e-25bed3696df4", "id2": "40b6b2a8-0d03-4212-9969-3751d711a118", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.08, "valuable_score": 0.994987468671679, "constructive_score": 0.0}, {"_id": "2e206854-09e3-4ce8-9f52-3a00397c145f", "id1": "c2d30785-e08f-4ea4-9084-373a1a0233f6", "id2": "622179d7-b06b-4493-9b17-9f8d5ff5b7b0", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.1, "valuable_score": 0.994987468671679, "constructive_score": 0.0}, {"_id": "b34ca77c-7808-4026-823b-14acb3e7b1c2", "id1": "a961148f-df9e-44b7-8a0e-90a40f2a08ad", "id2": "6b0d0bd5-ce50-480c-b937-7faab0026b19", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.09, "valuable_score": 0.994987468671679, "constructive_score": 0.0}, {"_id": "91616d9c-b5ba-470b-98a5-d3863c21d53f", "id1": "fd8882ac-998b-412e-96dc-cb5e6f9872f7", "id2": "5bc61e87-87db-4829-bff5-401802755e0a", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.08, "valuable_score": 0.994987468671679, "constructive_score": 0.95}, {"_id": "339983af-958d-45f9-9a6d-0c4f9e32a5ad", "id1": "f5d5f749-dce3-4e52-a151-9d6fda0d11f8", "id2": "40b6b2a8-0d03-4212-9969-3751d711a118", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.08, "valuable_score": 0.994987468671679, "constructive_score": 0.0}, {"_id": "6edcd790-8aea-41eb-944c-ed5189f86bb3", "id1": "52627568-895f-49ac-9797-f3aad86e1b6f", "id2": "3a61033b-429c-42ee-aa32-f51d18dfffce", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.09, "valuable_score": 0.994987468671679, "constructive_score": 0.15}, {"_id": "a9259ae4-a4cd-4f82-92ad-bdeebb1d392f", "id1": "34dcfc05-c3c4-4650-bb9c-aed2b1c3d5b9", "id2": "6f94343e-e9e5-4e69-a69d-7613e969214f", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.08, "valuable_score": 0.994987468671679, "constructive_score": 0.0}, {"_id": "d654c09f-42bf-406b-946c-50c80f055bc7", "id1": "9299eee9-9008-4baf-bf1b-c1afbf9f6b0f", "id2": "1f60e471-1c2b-4ba9-8130-b4c3a0fb0956", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.06, "valuable_score": 0.994987468671679, "constructive_score": 0.0}, {"_id": "21322ca4-0fbc-482e-bd6d-82251c4d3dd0", "id1": "f0b6ca31-7841-498e-a115-5574f5a6086f", "id2": "aef097ea-4280-4fc9-a5dc-447d62f31d55", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.09, "valuable_score": 0.994987468671679, "constructive_score": 0.913636}, {"_id": "b01d28f9-0695-476b-ad8f-e610e77b24b4", "id1": "7937820b-a176-4e15-b0d9-1d582ac29243", "id2": "ba678913-7756-49d6-9351-40680df96bc6", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.1, "valuable_score": 0.994987468671679, "constructive_score": 0.15}, {"_id": "32b1f93a-74e8-4cff-a472-cfc236121c6b", "id1": "9136fa90-140a-4190-ad77-3e6990d4d699", "id2": "0826f61d-c88d-4842-b6c2-5ed20fd172d1", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.07, "valuable_score": 0.994987468671679, "constructive_score": 0.0}, {"_id": "2def62de-3d19-4943-ade3-c4407e583abd", "id1": "d93ac66c-5f83-4b47-ba1d-ee930a30ee1d", "id2": "33b35e97-4627-4e79-92bb-64a7842ed118", "type1": "action", "type2": "core_insp", "field1": "description", "field2": "description", "similarity_score": 0.07, "valuable_score": 0.994987468671679, "constructive_score": 0.0}]'

In [60]:

    

tuple(matched_df['id1'])


    

    
Out[60]:





(UUID('a56d35c9-f274-4fd5-a7ac-681ce775529c'),
 UUID('8bf4dd83-7247-416e-9043-94f621d941f6'),
 UUID('46051fb5-0547-4f2a-8c70-33387a27d0db'),
 UUID('8f186a80-7ba4-4c59-95e3-cbeb785fba20'),
 UUID('5a29fcb3-c2a3-40fe-9f69-e89ee2cfd999'),
 UUID('4bd4043c-eff1-4d42-b44f-d2e11cc007f7'),
 UUID('938e3a8d-521b-4973-b239-475cf6f2cf25'),
 UUID('af9ac9e5-5fc0-41a2-b006-76277fd82ba4'),
 UUID('dfca426b-58c6-4351-a35e-25bed3696df4'),
 UUID('c2d30785-e08f-4ea4-9084-373a1a0233f6'),
 UUID('a961148f-df9e-44b7-8a0e-90a40f2a08ad'),
 UUID('fd8882ac-998b-412e-96dc-cb5e6f9872f7'),
 UUID('f5d5f749-dce3-4e52-a151-9d6fda0d11f8'),
 UUID('52627568-895f-49ac-9797-f3aad86e1b6f'),
 UUID('34dcfc05-c3c4-4650-bb9c-aed2b1c3d5b9'),
 UUID('9299eee9-9008-4baf-bf1b-c1afbf9f6b0f'),
 UUID('f0b6ca31-7841-498e-a115-5574f5a6086f'),
 UUID('7937820b-a176-4e15-b0d9-1d582ac29243'),
 UUID('9136fa90-140a-4190-ad77-3e6990d4d699'),
 UUID('d93ac66c-5f83-4b47-ba1d-ee930a30ee1d'))

In [65]:

    

id1_tuple = tuple(str(row['id1']) for i, row in matched_df.iterrows())
id2_tuple = tuple(str(row['id2']) for i, row in matched_df.iterrows())


    

In [66]:

    

id2_tuple


    

    
Out[66]:





('4e1e81a2-9f33-4473-83dc-c6b8e4917a93',
 '67e03ed1-02e2-4b2f-89b0-f607c1236212',
 '931d7762-9fa4-4a3f-85e3-f8bf75f8f903',
 '1ea5dcec-a94d-42df-8104-1f85f43c22d9',
 'c43f038b-c1cf-4204-a2f1-c1e6aa86f587',
 '1f60e471-1c2b-4ba9-8130-b4c3a0fb0956',
 '065c067a-8127-4290-b9e0-695ef5ebb2b3',
 'fade6361-3514-45f9-8ad7-9be84dafb609',
 '40b6b2a8-0d03-4212-9969-3751d711a118',
 '622179d7-b06b-4493-9b17-9f8d5ff5b7b0',
 '6b0d0bd5-ce50-480c-b937-7faab0026b19',
 '5bc61e87-87db-4829-bff5-401802755e0a',
 '40b6b2a8-0d03-4212-9969-3751d711a118',
 '3a61033b-429c-42ee-aa32-f51d18dfffce',
 '6f94343e-e9e5-4e69-a69d-7613e969214f',
 '1f60e471-1c2b-4ba9-8130-b4c3a0fb0956',
 'aef097ea-4280-4fc9-a5dc-447d62f31d55',
 'ba678913-7756-49d6-9351-40680df96bc6',
 '0826f61d-c88d-4842-b6c2-5ed20fd172d1',
 '33b35e97-4627-4e79-92bb-64a7842ed118')

In [67]:

    

core_insp_df = pd.read_sql_query(f"select * from core_insp where id in {id2_tuple}", con=engine)


    

In [69]:

    

core_insp_dict = [
    {
        'id': str(row['id']),
        'name': row['name'],
        'excerpt': row['excerpt'],
        'description': row['description']
        
    }
    for i, row in core_insp_df.iterrows()
]
json.dumps(core_insp_dict)


    

    
Out[69]:





'[{"id": "fade6361-3514-45f9-8ad7-9be84dafb609", "name": "Expanded career conversations", "excerpt": "Hold mid-year career conversations", "description": "Hold more regular career-focused conversations with employees. One approach is to hold mid-year career conversations that focus solely on development and career planning. These conversations are led by the employee so that they are encouraged to take ownership of their development. They are provided with a simple template to complete as a guide for the conversation. The employees are encouraged to include a discussion of their personal and job-related goals so the manager can give recommendations for individual skills development opportunities."}, {"id": "4e1e81a2-9f33-4473-83dc-c6b8e4917a93", "name": "Anonymous questions", "excerpt": "Create anonymous comms channel for employees ", "description": "Make space for feedback and questions from all employees. To facilitate questions at all hands meetings, one company created an anonymous communications channel (using its internal comms software). Employees ask questions anonymously prior to all hands meetings. The questions are then answered by leadership at these meetings. Employees feel that their voices are heard and they can express their opinions without connecting their name to the question. This could also be done at a team level prior to team meetings."}, {"id": "622179d7-b06b-4493-9b17-9f8d5ff5b7b0", "name": "Skip level meetings", "excerpt": "Implement skip level meetings around decision making", "description": "Foster open communication and alignment using skip-level meetings. Encourage people leaders who manage other people leaders to implement regular skip-level meetings. A skip level meeting occurs between a people leader and someone (or a group) two levels below them - without the people leader who those people report to attending - thereby skipping a layer of management. The people leader asks open questions to get an insight into how the people are going and can answer questions about the mission and objectives as well as how decisions are made. This fosters an open environment where employees feel included in important decisions. "}, {"id": "6b0d0bd5-ce50-480c-b937-7faab0026b19", "name": "Seat shuffle", "excerpt": "Get to know others in the business", "description": "Encouraging employees to get to know others outside their team, the seat shuffle moves employees around the office and introduces them to other people in the organization. One company shuffles seats every three months. Not all teams are required to participate and some teams that need to work closely in person each day prefer to keep the shuffle within the team."}, {"id": "0826f61d-c88d-4842-b6c2-5ed20fd172d1", "name": "Who\'s who in the zoo", "excerpt": "Keeping employees connected", "description": "Growing quickly can result in newcomers finding it difficult to feel part of a team. To help people get to know each other, set-up a \'who\'s who in the zoo\' program. A quiz and competitions in each region with questions such as, \'If you make a change to the pricing, who do you need to involve?\' and \'Which team do you go to for advice on contracts?\' provide fun ways to get to know people and procedures. The quiz also includes more general questions such as, \'Where is the all staff directory\', and fun facts like \'Which team member has nine brothers?\' and \'Which customer coach was a finalist in American Idol?\'."}, {"id": "33b35e97-4627-4e79-92bb-64a7842ed118", "name": "Product advisory group", "excerpt": "Cross-team oversight to get a fresh perspective", "description": "Enable cross-functional input into product development through a Product Advisory Board. At one organization a representative from each team has a place on the Product Advisory Board. The board meets once a week with the product manager and designer to discuss the evolution of the product, provide feedback on key decision points and help develop internal and external content. A similar group could be implemented at the team level with collaboration from other teams. Another lightweight alternative would be to invite members from other teams to your team planning meeting to get a fresh perspective."}, {"id": "aef097ea-4280-4fc9-a5dc-447d62f31d55", "name": "Project FAQs", "excerpt": "Answer and archive cross-department FAQs", "description": "Create living FAQs for each project and ask employees outside of the team what they want to know. One company uses this approach to ensure all relevant information is easily accessible. The project owner answers questions in the living document as they\'re asked, keeping the document up-to-date."}, {"id": "3a61033b-429c-42ee-aa32-f51d18dfffce", "name": "Learning passport", "excerpt": "Fully reimbursed self development programs", "description": "Give people the opportunity to develop skills relevant to their work. One organization has a learning passport program. Each person receives up to $1000 each year towards courses to help them learn and grow. Their direct manager is responsible for signing off on the course and then the employee receives full reimbursement. They are creating a database of learning opportunities funded by the organization to help generate ideas for other employees and to highlight in employer branding. This organization also plans to connect the training to a Learning Management System. Team Level: Implement skill-sharing sessions within your department. First, develop a skills inventory where individuals can document what topics they are willing to teach. Second, plan brown-bag style lunches so employees can learn new skills from each other."}, {"id": "ba678913-7756-49d6-9351-40680df96bc6", "name": "Adopt a plant", "excerpt": "Foster team commitment by keeping a plant alive", "description": "Foster team commitment and engagement. One company encourages teammates across each pod of desks to choose a plant to purchase. They are encouraged to do research based on how much light and water is needed - and also to name their plant creatively. Keeping the plant alive is a team activity and they also decorate the plants during festive holidays."}, {"id": "1ea5dcec-a94d-42df-8104-1f85f43c22d9", "name": "Personalized recognition", "excerpt": "Ask your employees about how they prefer to be recognized", "description": "Get to know how each employee prefers to receive recognition, and then document and store these preferences for when an employee is to be recognized. This includes understanding how they like to receive recognition (e.g. in public or one-on-one) and how they like to be rewarded (e.g. vacation days, bonus, dinner, flowers, gifts). This information is stored across the company, so as employees move teams, their recognition preferences go with them."}, {"id": "6f94343e-e9e5-4e69-a69d-7613e969214f", "name": "Termination explanations", "excerpt": "Giving employees more information about why a termination occurred", "description": "Provide as much detail as possible to people at your organization on why a termination has occurred to avoid rumors and encourage the right behaviors. When an organization has to let someone go because they are not delivering, the traditional approach is to provide relatively generic communications to the team (for example, \\"Joe found another opportunity and we wish them all the best.\\"). Instead, consider using clearer communications which include more detail about the reason for someone\'s departure. Communicating a reason for termination, including underperformance, can help employees understand that they are working in an organization that sets high standards."}, {"id": "931d7762-9fa4-4a3f-85e3-f8bf75f8f903", "name": "Celebrate New Learning", "excerpt": "Acknowledge team members who share lessons learned", "description": "Acknowledge team members who share the most lessons learned (successes and failures) from trying new ways of working. Strive to do this on a monthly basis in your weekly stand-up meetings."}, {"id": "1f60e471-1c2b-4ba9-8130-b4c3a0fb0956", "name": "Project Retrospectives", "excerpt": "Conduct team retrospective sessions", "description": "Conduct post-mortems on projects with your team. Implement a practice wherein after each project is launched and/or completed, a discussion is held to reflect on what could have been done better, and what opportunities have risen to learn more. Where appropriate, involve your team members to own and run the retrospective discussion."}, {"id": "67e03ed1-02e2-4b2f-89b0-f607c1236212", "name": "Lightning presentations", "excerpt": "Present on personal interests to get to know each other", "description": "Give your employees a formal opportunity in team meetings to share something important to them from outside of work. Start one team meeting monthly with a lightning presentation. People self-nominate to briefly present on something they care about or are interested in outside work. This can help people identify common interests and helps managers demonstrate an interest in getting to know people."}, {"id": "c43f038b-c1cf-4204-a2f1-c1e6aa86f587", "name": "Support requests in meetings", "excerpt": "Facilitate giving and receiving support", "description": "Give employees an easy way to highlight a need for support. One team has a space in their meeting notes for individuals to request support. Support includes sharing workload, sharing expertise, or simply making internal referrals. Not only does this help employees manage their workload, it also increases visibility on what team members are focused on."}, {"id": "40b6b2a8-0d03-4212-9969-3751d711a118", "name": "Weekly weigh-ups", "excerpt": "Hold team check-ins weekly", "description": "Hold team check-ins weekly to discuss workloads. Often team members are not aware of each other\'s workloads, making it hard to know who needs help and how to help them. One company makes managing workloads a shared challenge by having a formalized check-in each week to share what people are working on. When team members are more aware of other\'s work and challenges, it\'s easier to offer to jump in and help."}, {"id": "065c067a-8127-4290-b9e0-695ef5ebb2b3", "name": "Cross-training", "excerpt": "Train employees across positions to ensure adequate coverage", "description": "Train employees across positions to ensure adequate coverage. One organization uses a cross-training program to ensure every role has adequate coverage if an employee leaves the organization or just needs to take time off. An inventory of high risk roles and associated tasks is created and people are given the opportunity to identify tasks they are most interested in learning. The training typically starts as shadowing and culminates in a small project to make sure the person can successfully perform the task. Team Level: Within your team you can initiate cross-training by encouraging team members to shadow each other, particularly when one individual is starting a new project. You can also incorporate cross-training opportunities into your one-on-one meetings to help achieve team members\' developmental goals."}, {"id": "5bc61e87-87db-4829-bff5-401802755e0a", "name": "Rewarding V2.0", "excerpt": "Setup an employee committee to find creative ways to reward top performance", "description": "Find new and creative ways to reward top performance at your company that fits your culture and employee interests. The more aligned rewards are with employee interests the more successful the reward program will be. One company set up a \\"rewards committee\\" made up of interested employees across functions to evaluate available rewards. Some companies reward employees with adventurous experiences, some by donating to an employee\'s selected social cause, or providing work time to give back to community, and even (extra) work time for personal development. The most important thing is having employees involved in the selection process to ensure alignment of possible rewards that will fit with employee interests."}]'

In [76]:

    

action_df = pd.read_sql_query(f"select * from action where id in {id1_tuple}", con=engine)
action_df.head()


    

    
Out[76]:







  

    

      

      
created_at
      
updated_at
      
id
      
name
      
description
      
survey_id
      
src_insp_id
      
status
      
account_name
    
  
  

    

      
0
      
2018-01-15 23:19:12.643674
      
2018-01-15 23:40:01.138296
      
f0b6ca31-7841-498e-a115-5574f5a6086f
      
Career Interest
      
As part of Talent review and Mid-Year discussi...
      
59dd1b172c86121ff72c1a32
      
d983d168-6e34-4de8-9359-3e6edece4709
      
None
      
nbnco
    
    

      
1
      
2018-01-22 04:43:06.121770
      
2018-01-23 02:28:36.640499
      
af9ac9e5-5fc0-41a2-b006-76277fd82ba4
      
Development Conversation
      
Hold regular development-focused conversations...
      
59dd1b172c86121ff72c1a32
      
1c1f6117-99fb-4d00-adbd-2e78a6abb9bd
      
None
      
nbnco
    
    

      
2
      
2018-03-01 20:56:40.563236
      
2018-03-01 20:56:40.579238
      
52627568-895f-49ac-9797-f3aad86e1b6f
      
Health Management Program Development Team
      
- Continue to include skills development oppor...
      
59b14bf6e94dd938236ed344
      
None
      
None
      
healthnowny
    
    

      
3
      
2018-01-16 21:48:37.866753
      
2018-01-16 22:00:39.361434
      
f5d5f749-dce3-4e52-a151-9d6fda0d11f8
      
2017 - Consult with Women of PSAV Group
      
Communicate out to the IT department that ther...
      
59b95a208672356c5f239b0e
      
None
      
None
      
psav
    
    

      
4
      
2018-02-22 05:47:46.025119
      
2018-02-22 05:47:46.031484
      
8bf4dd83-7247-416e-9043-94f621d941f6
      
Demonstrate the Importance of People
      
1. Action:  Identify potential candidate for a...
      
59b5d55950dd771453d8b9d6
      
None
      
None
      
cimic
    
  

In [74]:

    

custom_insp_df = pd.read_sql_query(f"select * from custom_insp where id in {id1_tuple}", con=engine)


    

In [80]:

    

action_dict = [
    {
        "id": str(row["id"]),
        "name": row["name"],
        "description": row["description"],
        "survey_id": row["survey_id"],
        "src_insp_id": str(row["src_insp_id"]),
        "account_name": row["account_name"]
    }
    for i, row in action_df.iterrows()
]
json.dumps(action_dict)


    

    
Out[80]:





'[{"id": "f0b6ca31-7841-498e-a115-5574f5a6086f", "name": "Career Interest", "description": "As part of Talent review and Mid-Year discussions ask all your employees to capture their Career Interests and Aspirations in Workday. This will ensure it is visible and create visibility for who is able to assist. With your employee, have a conversation about strategies that might help move closer to this career goal and support actions that build relevant critical experiences. Connect them to others who can assist them including more senior leaders, networks and relevant teams.\\\\n\\\\nAction on team to fill in Talant in workday. Ian to actively review and Talent for team.", "survey_id": "59dd1b172c86121ff72c1a32", "src_insp_id": "d983d168-6e34-4de8-9359-3e6edece4709", "account_name": "nbnco"}, {"id": "af9ac9e5-5fc0-41a2-b006-76277fd82ba4", "name": "Development Conversation", "description": "Hold regular development-focused conversations with all your employees in your team. With care, find time to provide regular feedback to your people  \\u2013 providing behavioural observations, impact of those behaviours and suggestions for changes. Together the Leader and Employee can discuss their personal and job-related goals and agree on individual skills development opportunities. This may include everything from formal learning opportunities to secondments to filling in for someone on leave. The key is open and regular conversations with all your people.  Information on the Leadership portfolio of programs avilable on the Hub. Additional on-line resources available through  MIndtools and Lynda.com.\\\\n\\\\n\\\\n1. Get back into 3 questions:\\\\nWhat are you trying to achieve and why?\\\\nWhat is the current state?\\\\nWhat is the next steps?", "survey_id": "59dd1b172c86121ff72c1a32", "src_insp_id": "1c1f6117-99fb-4d00-adbd-2e78a6abb9bd", "account_name": "nbnco"}, {"id": "52627568-895f-49ac-9797-f3aad86e1b6f", "name": "Health Management Program Development Team", "description": "- Continue to include skills development opportunities within 1:1 discussions \\\\n- Include individual plans related to skills development in Quarterly Check-in discussions & documentation \\\\n- Review of HealthNow learning opportunities regularly (HN University) \\\\n- Distribution of continuing education / CEU opportunities as identified \\\\n- Consideration for staff attendance at national conferences for topics relevant to program development, corporate  initiatives, and industry best practice, with reporting back to HN teams and action plan developed \\\\n- Submit major accomplishments as iConnect article topic suggestions \\\\n- Team building activity/opportunities, coordinated by team member volunteer(s) \\\\n- Manager will increase distribution of Tipper points as appropriate", "survey_id": "59b14bf6e94dd938236ed344", "src_insp_id": "None", "account_name": "healthnowny"}, {"id": "f5d5f749-dce3-4e52-a151-9d6fda0d11f8", "name": "2017 - Consult with Women of PSAV Group", "description": "Communicate out to the IT department that there is going to be a survey taking place to get more info on women\'s perspectives in the workplace \\\\nContact Women of PSAV Group and gather data on members\' perspectives around open and honest two-way communication - what does this mean to them, is it working, etc. \\\\nGather information from the survey and determine next steps\\\\n\\\\n\\\\n\\\\nWho is taking action?  Core IT leadership team \\\\nBy when?  last week February 2018\\\\nHow will they be held accountable?  As a team, hold ourselves accountable - Cathie will check-in end of February, then in 6 months do a progress check", "survey_id": "59b95a208672356c5f239b0e", "src_insp_id": "None", "account_name": "psav"}, {"id": "8bf4dd83-7247-416e-9043-94f621d941f6", "name": "Demonstrate the Importance of People", "description": "1. Action:  Identify potential candidate for a rotation and start the discussions and make it happen - SA (2x process and 1X Mech) and possibly Chile or Aus -look to simplify the process.\\\\n\\\\n2. Action - regular and informal feedback from leaders - not just paperwork but informal - performance plans - just done procedural purposes - aspirations not used as it should be used - \\\\n\\\\n3. Action:  Monthly Management Meeting - what is going on - what is in the forecast - what opportunities for the team/members relating to development and interests. (leaders keep me informed)\\\\n\\\\nGeneral comments\\\\n- long site periods and low site uplifts - long hours - missing important personal days that is just as important - look at other rewards and consultations\\\\n- communicating the benefits of doing site work - other than monetary reasons\\\\n- flight times - looking at ways of managing flights outside work time - looking at better ways of agreeing these challenges", "survey_id": "59b5d55950dd771453d8b9d6", "src_insp_id": "None", "account_name": "cimic"}, {"id": "34dcfc05-c3c4-4650-bb9c-aed2b1c3d5b9", "name": "Monthly NPS Survey Highlights by Location", "description": "Our purpose here is to communicate to our entire regional team the successes we are having at each location with our Medallia scores.  We would enlist the assistance of each location DET to submit their best customer surveys each month.  Natalie and I will select the final ones we want to highlight each month and distribute to the entire regional team.  We will also include a MTD ranking with each communication to drive some friendly competition.  It also gives us an opportunity to recognize our employees mentioned by name in another way in front of the entire region.\\\\n\\\\nMonthly newsletter started in Q2", "survey_id": "59b95a208672356c5f239b0e", "src_insp_id": "e0d33e54-6b68-4cde-b34c-72b70bcc4aa6", "account_name": "psav"}, {"id": "7937820b-a176-4e15-b0d9-1d582ac29243", "name": "Adopt a plan", "description": "Foster team commitment and engagement. Encourage team members to do research based on demographics. \\\\n\\\\nI am always researching tools for my team and the rest of the Account Managers to assist them in better understand their accounts. In 2017 I forwarded to the team the Guidestar website for them to take a deep dive and look at how their individual accounts are trending based on their strategic goals. In doing so, they can look for opportunities and find solutions to help meet their plans.", "survey_id": "59b95a208672356c5f239b0e", "src_insp_id": "ba678913-7756-49d6-9351-40680df96bc6", "account_name": "psav"}, {"id": "dfca426b-58c6-4351-a35e-25bed3696df4", "name": "IAN Action plan", "description": "Based on a break out session the team concluded that the team spirit should be enhanced by:\\\\n- Organising a team building day\\\\n- Starting a IA NL Group app to share information to get to know each other better\\\\n- A Management drives session facilitated by HR to know about each others prefered drives for performing\\\\n- Intervision to solve work related barriers to be effective and efficient\\\\n\\\\nFurthermore each team member has the responsibility to organise their work better by:\\\\n- Managing exceeding deadlines in a \\u2018week start\\u2019 meeting\\\\n- Each auditor organizes a single point of contact in the business to help them with documentation etc. to conduct the audit\\\\n\\\\nSee for more information: the document \'Employee Engagement Survey IA NL\'\\\\n", "survey_id": "59ad26a71124a24e0cad8ed3", "src_insp_id": "None", "account_name": "aegon"}, {"id": "d93ac66c-5f83-4b47-ba1d-ee930a30ee1d", "name": "Lessons Learned", "description": "During the Lead/Manager meeting a designated Lead will gather and discuss results of (i, ii, iii) and summarize for the leadership of IA.    When necessary, these results will also be shared with the greater team during the monthly Internal Audit team meeting.  We will rotate this monthly responsibility among the Leads.\\\\n     i.\\\\t  Constructive feedback from the customer survey after each audit.\\\\n     ii.\\\\t  Areas of improvement identified in the quality assurance review for each audit .\\\\n     iii.  Lessons learned from each audit.\\\\n", "survey_id": "59ad26a71124a24e0cad8ed3", "src_insp_id": "None", "account_name": "aegon"}, {"id": "4bd4043c-eff1-4d42-b44f-d2e11cc007f7", "name": "PSAV - Communication/Meeting Cadence", "description": "Take the time to ask your team members about what could be done differently/better.  Genuinely listen to what they tell you and implement a few of the best ideas.\\\\nThe PGE Leadership team will establish a regular meeting cadence to share and exchange ideas, improve communication, and direct business discussion and decisions as needed. (The leadership team is defined as VP\'s and Director level leaders)\\\\nThe leadership team will meet in person once per quarter, and the Director leadership team will join the established Monday call, once per month. (last Monday of each month)\\\\nAll PGE Leaders will conduct one-on-one meetings with each team member to set expectations, check on progress and check-in to find out how they are doing. These meeting will be conducted monthly.", "survey_id": "59b95a208672356c5f239b0e", "src_insp_id": "f499fbe1-418f-4785-9b36-19e5179afd89", "account_name": "psav"}, {"id": "938e3a8d-521b-4973-b239-475cf6f2cf25", "name": "Restructures", "description": "Managing a restructure well is a real test of leadership. Restructures must be handled with upmost care and planning. Planning which strongly relates to your strategy and operating model. Strong communication and change management is essential prior, during and post any change to not only those impacted but your whole team and across teams.  Reach out to your Leader and HRBPs for guidance and support ahead of your next workforce changes to ensure our nbn frameworks are being leveraged for consistency of approach and employee experience. Also please attend change management training as part of our Learning and Development offers. Organisational needs or roles may change but how we treat our people through restructures will often be what you are remembered for.  ", "survey_id": "59dd1b172c86121ff72c1a32", "src_insp_id": "6167d0c4-63c7-497b-9de6-10c6e771168b", "account_name": "nbnco"}, {"id": "5a29fcb3-c2a3-40fe-9f69-e89ee2cfd999", "name": "2017 -Team Oriented - Skip Level Meetings", "description": "Give employees an easy way to highlight a need for support. One team has a space in their meeting notes for individuals to request support. Support includes sharing workload, sharing expertise, or simply making internal referrals. Not only does this help employees manage their workload, it also increases visibility on what team members are focused on.\\\\n\\\\nShare results of successes and areas of focus from each venue during skip level meetings, help others to understand different challenges throughout Region.  Share not only each venue, but other Areas feedback (ex. Cleveland, Michigan, etc.)\\\\n\\\\nAction will be completed by RVP / Area Manager / Team Leader\\\\nThese will be held in August.  One in Columbus to include all of Ohio / Kentucky the other in Michigan for all team members without DET\'s present.", "survey_id": "59b95a208672356c5f239b0e", "src_insp_id": "c43f038b-c1cf-4204-a2f1-c1e6aa86f587", "account_name": "psav"}, {"id": "46051fb5-0547-4f2a-8c70-33387a27d0db", "name": "Improving Equipment Dependability", "description": "IT is in the process of replacing/updating the PC kiosks currently on the floor with new hardware at 4 end cap positions.                                                                                                                                                           Player\'s Club management is appointing a TSA in our department to be responsible for checking all equipment twice a day, this includes kiosks, desk tops, pin pads, scanners, boca machines and radios.  A spread sheet will be created in order to track equipment failures, the TSA will be empowered to contact the proper department (IT or Security for radios), completing a work order as soon as a problem is detected. The TSA will then track the progress of the issue and note when resolved, following up with Management for assistance if needed.  By designating a team member to this task, we will be creating greater engagement from team members. This will also improve the \\"wait time\\" for repairs, therefore improving team members experience.  \\\\nOur goal is to have all equipment working properly at all times to insure our team members are able to preform to the best of their ability.", "survey_id": "58211baddb4d0863f100004b", "src_insp_id": "None", "account_name": "stofgaming"}, {"id": "c2d30785-e08f-4ea4-9084-373a1a0233f6", "name": "2017-Individual Culture Conversations", "description": "This also applies to \\"proud to work for PSAV\\" and \\"I rarely think about working elsewhere.\\" These items could not be identified as tasks for taking action.\\\\n\\\\nRVP to conduct one-on-one meetings with each manager during the annual performance review about driving the PSAV culture, and to encourage each manager to be an ambassador of PSAV. Instill a sense of pride by recognizing the contributions that each of team member is making to the company, and emphasizing their place in the overall business community. Each manager must cascade the conversation down to their direct reports. These conversations will be completed by the end of the annual review process, and will be recorded in the annual reviews.\\\\n\\\\n8.1 Update - RVP had one-on-one conversations with each manager during the annual review process to enforce the Culture Conversations. In addition, each monthly team meeting / call includes a segment on company culture.", "survey_id": "59b95a208672356c5f239b0e", "src_insp_id": "None", "account_name": "psav"}, {"id": "a961148f-df9e-44b7-8a0e-90a40f2a08ad", "name": "2017 - Transparent team discussions", "description": "At next town hall, have an open and transparent conversation about whether or not people feel safe to speak up at PSAV - invite comments and conversation around this topic.\\\\n\\\\nIn smaller group meetings, model this behavior by being open to others speaking up and sharing his/her thoughts. Reward your team members for good ideas that get shared forward - celebrate the wins!\\\\n\\\\n\\\\nWho is taking action?  Cathie will take care of town hall, then all other leaders will be responsible for modeling this moving forward\\\\nBy when? Town hall in February (tbd)\\\\nHow will they be held accountable? Survey IT team in 6 months to progress check \\\\nSanti will also work to find us a Feedback class", "survey_id": "59b95a208672356c5f239b0e", "src_insp_id": "None", "account_name": "psav"}, {"id": "8f186a80-7ba4-4c59-95e3-cbeb785fba20", "name": "Personalized recognition", "description": "Get to know how each employee prefers to receive recognition, and then document and store these preferences for when an employee is to be recognized. This includes understanding how they like to receive recognition (e.g. in public or one-on-one) and how they like to be rewarded (e.g. vacation days, bonus, dinner, flowers, gifts). This information is stored across the company, so as employees move teams, their recognition preferences go with them.\\\\n\\\\nTactic:\\\\n\\\\n- each manager/supervisor will discuss the employee engagement results with their staff\\\\n- focus on the items we have selected for our focus for 2018\\\\n- in the staff meeting, discuss this topic and ask staff to write down how they prefer to be recognized\\\\n- we will keep an inventory of just the suggestions and determine our next steps towards improving our teams\' performance in this category  -- names are optional", "survey_id": "59b14bf6e94dd938236ed344", "src_insp_id": "1ea5dcec-a94d-42df-8104-1f85f43c22d9", "account_name": "healthnowny"}, {"id": "9136fa90-140a-4190-ad77-3e6990d4d699", "name": "PSAV - 2017: Innovation", "description": "Local management will do a better job on passing down information on new technology that the company is deploying or considering deploying.  Our staff was very vocal in the survey that they don\'t feel we invest in innovating technology to stay ahead of the competition.  More transparency on the company\'s technology path is key here.  We will also make initiatives to hear the ideas that are being discussed in this region so we can then pass innovation ideas back up to corporate.", "survey_id": "59b95a208672356c5f239b0e", "src_insp_id": "None", "account_name": "psav"}, {"id": "a56d35c9-f274-4fd5-a7ac-681ce775529c", "name": "Open communication", "description": "Leaders encourage their team members to ask the tough or controversial questions (either privately or in meetings) and share responses transparently at team meetings. Encourage difference of thought openly.\\\\n\\\\nleadership - work on how we model/manage behaviors in the - call people on behavours without it being taking badly - plan around this work already on way\\\\n- what is the action as a team - leaders to call it up and then to action a plan to resolve this behaviour\\\\n- international offices - happens more frequently - \\\\nimportantant piece of work for stat as its hurting bottom line\\\\nhow we mange well - handover to projects - behavioural piece\\\\n\\\\nDescribe the action - calling it / coaching /ownership of the action - good coaching - admit we wrong  - leadership support - fear of having to own something and run with it and be accountable for it.\\\\n\\\\nPeople feel safe to call people on behaviors - build trust that something will be done about it when it happens. Encourage to do the right thin\\\\n\\\\ncompany wide \\\\n\\\\n\\\\n", "survey_id": "59b5d55950dd771453d8b9d6", "src_insp_id": "77e80d6f-b652-4283-a794-d9eec4da4dae", "account_name": "cimic"}, {"id": "fd8882ac-998b-412e-96dc-cb5e6f9872f7", "name": "Seek a road map that clearly outlines comparitives", "description": "Provide access to a template to compare and relate too with colleagues. Encourage comparisons of income by staff in similar roles.  Develop transparent budgeting in relation to KPI\'s, salary, and recognised skill and time active in posistion. \\\\nEncourage staying on, to achieve the best with extra benefits to kiwi saver,holiday allowance \\\\nDevelop best earning practise by showcasing successful internal company skill and income .Give examples of how high achievers started, how long it took, and what made them a high income source to value.  Belief is one thing and understanding your current income and potential income is fair unbiased and not arbituary are positive motivators .\\\\n Failure is part of successfully improving income potential.", "survey_id": "59ffde1d1124a245d85fb42e", "src_insp_id": "None", "account_name": "mediaworks"}]'

In [87]:

    

question_df = pd.read_sql_query("select * from question", con=engine)
ref_question_df = pd.read_sql_query("select * from ref_question", con=engine)


    

In [91]:

    

ref_question_df.head()


    

    
Out[91]:







  

    

      

      
created_at
      
updated_at
      
code
      
description
      
factor
      
survey_type
    
  
  

    

      
0
      
None
      
None
      
All-Goal-3
      
At least one of my career development goals al...
      
Goal Alignment
      
The Alliance Diagnostic
    
    

      
1
      
None
      
None
      
Int-Over-2
      
I would highly recommend an internship at %ACC...
      
Overall
      
Intern Survey
    
    

      
2
      
None
      
None
      
Ben-Expl-1
      
The availability of 401k matching is a potenti...
      
Exploring 401k Matching
      
Benefits Survey
    
    

      
3
      
None
      
None
      
Eng.5
      
I see myself still working at %ACCOUNT_NAME% i...
      
Engagement
      
Onboard Survey (Phased Week 5 )
    
    

      
4
      
None
      
None
      
Can-Awar-4
      
How did you first hear about an opportunity to...
      
Awareness
      
Candidate Survey
    
  

In [92]:

    

ref_question_dict = [
    {
        'code': row['code'],
        'description': row['description'],
        'factor': row['factor'],
        'survey_type': row['survey_type']
    }
    for i, row in ref_question_df.iterrows()
]
json.dumps(ref_question_dict)


    

    
Out[92]:





'[{"code": "All-Goal-3", "description": "At least one of my career development goals aligns with the work I do at %ACCOUNT_NAME%", "factor": "Goal Alignment", "survey_type": "The Alliance Diagnostic"}, {"code": "Int-Over-2", "description": "I would highly recommend an internship at %ACCOUNT_NAME%", "factor": "Overall", "survey_type": "Intern Survey"}, {"code": "Ben-Expl-1", "description": "The availability of 401k matching is a potential benefit that is top of mind for me as I plan for the future", "factor": "Exploring 401k Matching", "survey_type": "Benefits Survey"}, {"code": "Eng.5", "description": "I see myself still working at %ACCOUNT_NAME% in two years\' time", "factor": "Engagement", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Can-Awar-4", "description": "How did you first hear about an opportunity to work at %ACCOUNT_NAME%?", "factor": "Awareness", "survey_type": "Candidate Survey"}, {"code": "All-Miss-3", "description": "I receive clear and constructive feedback about progress toward my performance goals", "factor": "Mission & Objectives", "survey_type": "The Alliance Diagnostic"}, {"code": "Ons-Recr-5", "description": "Reviewer Comments on Recruitment", "factor": "Recruitment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "On1-Chec-6", "description": "Reviewer Comments on Organizational Alignment", "factor": "Checklist", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Ind-Mana-7", "description": "Giving you feedback on how you are progressing", "factor": "Manager Feedback", "survey_type": "Individual Effectiveness"}, {"code": "Mgrcap.1", "description": "My manager has a good understanding of the challenges our team encounters in our work", "factor": "Technical Capability", "survey_type": "Manager Effectiveness"}, {"code": "Mgremo.1", "description": "My manager remains calm and productive under pressure", "factor": "Resilience ", "survey_type": "Manager Effectiveness"}, {"code": "Mgreff.4", "description": "I would recommend this person as a manager", "factor": "Overall Manager Effectiveness", "survey_type": "Manager Effectiveness"}, {"code": "Lea.1", "description": "I have confidence in the leaders at %ACCOUNT_NAME%", "factor": "Leadership", "survey_type": "Engagement"}, {"code": "Mgrcoa.5", "description": "My manager gives me actionable feedback on a regular basis", "factor": "Coaching", "survey_type": "Manager Effectiveness"}, {"code": "Eng.2", "description": "%ACCOUNT_NAME% motivates me to go beyond what I would in a similar role elsewhere", "factor": "Engagement", "survey_type": "Onboard Survey (Single Point)"}, {"code": "On1-Chec-5", "description": "Reviewer Comments on Welcome & Induction", "factor": "Checklist", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Ben-Exis-10", "description": "I believe investing more of the company\'s money into improving benefits at %ACCOUNT_NAME% will help attract and retain top talent", "factor": "Existing Benefits", "survey_type": "Benefits Survey"}, {"code": "Ben-Unde-6", "description": "Select the existing perk you would be most willing to sacrifice to allow for new benefits", "factor": "Understanding Existing Perks", "survey_type": "Benefits Survey"}, {"code": "Tea.2", "description": "We hold ourselves and our team members accountable for results", "factor": "Focus and Accountability", "survey_type": "Team Effectiveness"}, {"code": "Con.2", "description": "%ACCOUNT_NAME% effectively directs resources (funding, people and effort) towards company goals", "factor": "Company Performance", "survey_type": "Engagement"}, {"code": "Ind-Mana-2", "description": "Managing our teams workload (allocating work assignments, setting priorities, scheduling, etc.)", "factor": "Manager Feedback", "survey_type": "Individual Effectiveness"}, {"code": "Fee.2", "description": "My job performance is evaluated fairly", "factor": "Fairness", "survey_type": "Inclusion Survey"}, {"code": "Ben-Exis-7", "description": "Should I have or care for a(nother) child, the parental leave policy is sufficient", "factor": "Existing Benefits", "survey_type": "Benefits Survey"}, {"code": "Mgrcom.4", "description": "My manager is a good listener (allows ample time for others to speak)", "factor": "Communicating", "survey_type": "Supplementary ME"}, {"code": "Tea-Role-1", "description": "I know how my work contributes to the team\'s success", "factor": "Role Clarity", "survey_type": "Team Effectiveness"}, {"code": "Ons-Indu-7", "description": "The onboarding experience gave me the opportunity to establish good relationships with people that are key to my role", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Col.3", "description": "Other departments at %ACCOUNT_NAME% collaborate well with us to get the job done", "factor": "Collaboration & Communication", "survey_type": "Engagement"}, {"code": "Int-Awar-3", "description": "My peers on campus are aware of %ACCOUNT_NAME% products or services", "factor": "Awareness", "survey_type": "Intern Survey"}, {"code": "Exi-The -5", "description": "Which company will you be moving to?", "factor": "The Future", "survey_type": "Exit Survey"}, {"code": "Ben-Expl-2", "description": "401k matching is something that %ACCOUNT_NAME% should offer, even if the funding has to come from other budgets (such as budgets for salary increases, bonuses, perks, equity, and events)", "factor": "Exploring 401k Matching", "survey_type": "Benefits Survey"}, {"code": "Tea-Comt-1", "description": "What is one thing you would like our team to do differently?", "factor": "Comments", "survey_type": "Team Effectiveness"}, {"code": "Inn.2", "description": "We are encouraged to be innovative even though some of our initiatives may not succeed", "factor": "Innovation", "survey_type": "Engagement"}, {"code": "Lea.3", "description": "The leaders at %ACCOUNT_NAME% have communicated a vision that motivates me", "factor": "Leadership", "survey_type": "Quick Engagement Survey"}, {"code": "All-Mana-2", "description": "My manager guides problem solving rather than solving problems for me", "factor": "Manager As Coach", "survey_type": "The Alliance Diagnostic"}, {"code": "All-Mana-3", "description": "My manager has explored my core work values", "factor": "Manager As Coach", "survey_type": "The Alliance Diagnostic"}, {"code": "Ons-Orga-2", "description": "The organizational values of %ACCOUNT_NAME% align well with my own values", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Mgrdev.3", "description": "My manager helps me understand potential career paths at %ACCOUNT_NAME%", "factor": "Career Conversations", "survey_type": "The Alliance Diagnostic"}, {"code": "Tea-Deve-2", "description": "Team members give each other constructive feedback", "factor": "Development", "survey_type": "Team Effectiveness"}, {"code": "On1-Expe-1", "description": "What\'s one thing we could have done differently to improve the first week of your onboarding experience?", "factor": "Experience", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Eng-Comm-2", "description": "Are there some things we are not doing so great here?", "factor": "Comments", "survey_type": "Engagement"}, {"code": "All-Inde-2", "description": "%ACCOUNT_NAME% is a safe place to be open and honest", "factor": "Alliance Index", "survey_type": "The Alliance Diagnostic"}, {"code": "Wel-Over-5", "description": "I usually feel I am making progress at work", "factor": "Overall Wellbeing", "survey_type": "Wellbeing Survey"}, {"code": "Int-Over-4", "description": "I felt inspired to go above and beyond the expectations of my role", "factor": "Overall", "survey_type": "Intern Survey"}, {"code": "Eng.4", "description": "I rarely think about looking for a job at another company", "factor": "Engagement", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Exi-Your-5", "description": "Please indicate how long you have been considering leaving %ACCOUNT_NAME% for:", "factor": "Your Decision", "survey_type": "Exit Survey"}, {"code": "Eng.1", "description": "I would recommend %ACCOUNT_NAME% as a great place to work", "factor": "Engagement", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Ons-Indu-3", "description": "I have had good training on the processes applicable to my role", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Ons-Expe-3", "description": "I am feeling welcome here", "factor": "Experience", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Ons-Your-1", "description": "Please indicate the reasons why you joined %ACCOUNT_NAME%", "factor": "Your Decision", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Di-Bel-3", "description": "I feel respected at %ACCOUNT_NAME%", "factor": "Belonging", "survey_type": "Inclusion Survey"}, {"code": "Mgrcar.5", "description": "I would consider speaking with my manager if I was thinking about leaving %ACCOUNT_NAME%", "factor": "Alliance Index", "survey_type": "The Alliance Diagnostic"}, {"code": "Exi-Deve-3", "description": "I believe there would have been good career opportunities for me at %ACCOUNT_NAME%", "factor": "Development", "survey_type": "Exit Survey"}, {"code": "Ons-Indu-9", "description": "The information provided has been at the right level for me", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Di-Dem-1", "description": "I am included in decisions that affect my work", "factor": "Decision Making", "survey_type": "Inclusion Survey"}, {"code": "Man.3", "description": "My manager is a great role model for employees", "factor": "Management", "survey_type": "Engagement"}, {"code": "Lea.4", "description": "The leaders at %ACCOUNT_NAME% keep people informed about what is happening", "factor": "Leadership", "survey_type": "Engagement"}, {"code": "Mgrvis.2", "description": "My manager helps us set a clear strategy for achieving our goals", "factor": "Vision and Goal Setting", "survey_type": "Manager Effectiveness"}, {"code": "Tea-Comm-2", "description": "Team members collaborate well with one another to get the job done", "factor": "Communication and Collaboration", "survey_type": "Team Effectiveness"}, {"code": "Ali.1", "description": "I am appropriately involved in decisions that affect my work", "factor": "Alignment & Involvement", "survey_type": "Engagement"}, {"code": "Ons-Expe-4", "description": "I am feeling productive", "factor": "Experience", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Wel-Over-1", "description": "I usually feel very positive at work", "factor": "Overall Wellbeing", "survey_type": "Wellbeing Survey"}, {"code": "Wel-Over-3", "description": "I receive support from people around me at work when I need it", "factor": "Overall Wellbeing", "survey_type": "Wellbeing Survey"}, {"code": "All-Trus-1", "description": "Vision and strategy are well communicated at %ACCOUNT_NAME%", "factor": "Trust & Communication", "survey_type": "The Alliance Diagnostic"}, {"code": "Ind-Supp-1", "description": "What is one way that I help you or your team to succeed?", "factor": "Supporting success", "survey_type": "Individual Effectiveness"}, {"code": "Ons-Orga-1", "description": "I know what the organizational values of %ACCOUNT_NAME% are", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Di-Dem-2", "description": "Perspectives like mine are included in the decision making at %ACCOUNT_NAME%", "factor": "Decision Making", "survey_type": "Inclusion Survey"}, {"code": "Can-Recr-5", "description": "The recruitment process left me with a clear understanding of the role I was interviewing for", "factor": "Recruitment", "survey_type": "Candidate Survey"}, {"code": "Tea-Supp-1", "description": "When my teammates say they\\u2019ll do something, they follow through with it", "factor": "Supportive Climate", "survey_type": "Team Effectiveness"}, {"code": "Ons-Recr-1", "description": "Is there something we could have done to improve the recruitment process?", "factor": "Recruitment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Ind-Mana-8", "description": "Providing you with responsibility and autonomy", "factor": "Manager Feedback", "survey_type": "Individual Effectiveness"}, {"code": "Ons-Role-1", "description": "My role so far matches the role description provided to me", "factor": "Role Perceptions", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Tea-Orga-2", "description": "%ACCOUNT_NAME% recognizes and celebrates our team\'s achievements", "factor": "Organizational Alignment", "survey_type": "Team Effectiveness"}, {"code": "Int-Inte-2", "description": "My actual assignments were similar to my expectations", "factor": "Intern Experience", "survey_type": "Intern Survey"}, {"code": "Ons-Expe-1", "description": "Is there anything else you would have liked included in your onboarding process?", "factor": "Experience", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Act.3", "description": "I have seen positive changes taking place based on recent employee survey results", "factor": "Action", "survey_type": "Engagement"}, {"code": "Di-Comm-1", "description": "What is one thing your company could do to create a more inclusive culture?", "factor": "Comments", "survey_type": "Inclusion Survey"}, {"code": "Eng.2", "description": "%ACCOUNT_NAME% motivates me to go beyond what I would in a similar role elsewhere", "factor": "Engagement", "survey_type": "Engagement"}, {"code": "Fee.4", "description": "Generally, the right people are rewarded and recognized at %ACCOUNT_NAME%", "factor": "Feedback & Recognition", "survey_type": "Engagement"}, {"code": "Ons-Expe-3", "description": "I am feeling welcome here", "factor": "Experience", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Ons-Your-1", "description": "Please indicate the reasons why you joined %ACCOUNT_NAME%", "factor": "Your Decision", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Ben-Exis-3", "description": "My benefits package provides quality coverage for myself and, if applicable, my dependents", "factor": "Existing Benefits", "survey_type": "Benefits Survey"}, {"code": "Tea-Team-1", "description": "We resolve most conflicts or disagreements effectively", "factor": "Team Processes", "survey_type": "Team Effectiveness"}, {"code": "Ben-Eval-7", "description": "My choice in medical plan was impacted by carrier", "factor": "Evaluating Medical Plans", "survey_type": "Benefits Survey"}, {"code": "Ons-Indu-10", "description": "My on-the-job training has been effective", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Act.4", "description": "I believe action will take place as a result of this survey", "factor": "Action", "survey_type": "Engagement"}, {"code": "Ons-Orga-4", "description": "I understand how my role contibutes to the organizational goals of %ACCOUNT_NAME%", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Mgrvis.1", "description": "My manager helps me understand how my role contributes to %ACCOUNT_NAME%\'s success", "factor": "Vision and Goal Setting", "survey_type": "Supplementary ME"}, {"code": "Eng.3", "description": "I am proud to work for %ACCOUNT_NAME%", "factor": "Engagement", "survey_type": "Inclusion Survey"}, {"code": "Lea.2", "description": "The leaders at %ACCOUNT_NAME% demonstrate that people are important to the company\'s success", "factor": "Leadership", "survey_type": "Engagement"}, {"code": "Di-Dvs-1", "description": "%ACCOUNT_NAME% values diversity", "factor": "Diversity", "survey_type": "Inclusion Survey"}, {"code": "Ben-Unde-1", "description": "Our perks were chosen to enhance the employee experience at %ACCOUNT_NAME%. Do you think our perks program is effective in enhancing our culture?", "factor": "Understanding Existing Perks", "survey_type": "Benefits Survey"}, {"code": "Ben-Exis-4", "description": "I believe our benefits package is one of the top reasons why people apply to work at %ACCOUNT_NAME%", "factor": "Existing Benefits", "survey_type": "Benefits Survey"}, {"code": "Can-Inte-1", "description": "My interview started on time", "factor": "Interviews", "survey_type": "Candidate Survey"}, {"code": "Act.1", "description": "I have been provided an opportunity to see and discuss recent employee survey results", "factor": "Action", "survey_type": "Engagement"}, {"code": "Di-Fan-3", "description": "People from all backgrounds have equal opportunities to succeed at %ACCOUNT_NAME%", "factor": "Fairness", "survey_type": "Inclusion Survey"}, {"code": "Eng-Comm-1", "description": "Are there some things we are doing great here?", "factor": "Comments", "survey_type": "Quick Engagement Survey"}, {"code": "Di-Opr-1", "description": "When there are career opportunities at %ACCOUNT_NAME%, I am aware of them", "factor": "Opportunities & Resources", "survey_type": "Inclusion Survey"}, {"code": "Ena.1", "description": "I have access to the things I need to do my job well", "factor": "Enablement", "survey_type": "Engagement"}, {"code": "All-Inde-1", "description": "I feel like %ACCOUNT_NAME% and I are allies in developing my career", "factor": "Alliance Index", "survey_type": "The Alliance Diagnostic"}, {"code": "Mgrinc.2", "description": "My manager shows that they value diversity on the team", "factor": "Inclusion ", "survey_type": "Manager Effectiveness"}, {"code": "Eng.4", "description": "I rarely think about looking for a job at another company", "factor": "Engagement", "survey_type": "Engagement"}, {"code": "Eng.1", "description": "I would recommend %ACCOUNT_NAME% as a great place to work", "factor": "Engagement", "survey_type": "Engagement"}, {"code": "Dev.3", "description": "I have access to the learning and development I need to do my job well", "factor": "Learning & Development", "survey_type": "Engagement"}, {"code": "Ons-Recr-1", "description": "Is there something we could have done to improve the recruitment process?", "factor": "Recruitment", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Val-Conn-3", "description": "I believe these core values are right for a company like ours", "factor": "Connection", "survey_type": "Values Survey"}, {"code": "Tea.3", "description": "Workloads are divided fairly among people where I work", "factor": "Teamwork & Ownership", "survey_type": "Engagement"}, {"code": "Ind-Gene-1", "description": "Please describe anything else, not listed above, that you\'d like to see me continue, improve or do more of.", "factor": "General", "survey_type": "Individual Effectiveness"}, {"code": "Tea-Comm-3", "description": "There is open and honest two-way communication within our team", "factor": "Communication and Collaboration", "survey_type": "Team Effectiveness"}, {"code": "Exi-The -6", "description": "What excites you about your new role?", "factor": "The Future", "survey_type": "Exit Survey"}, {"code": "Eng-Comm-3", "description": "Is there something else you think we should have asked you in this survey?", "factor": "Comments", "survey_type": "Engagement"}, {"code": "Can-Recr-3", "description": "The recruitment team kept in regular touch with me through the whole process", "factor": "Recruitment", "survey_type": "Candidate Survey"}, {"code": "Can-Awar-2", "description": "In my experience, %ACCOUNT_NAME% is a company people really want to work for", "factor": "Awareness", "survey_type": "Candidate Survey"}, {"code": "Man.2", "description": "My manager gives me useful feedback on how well I am performing", "factor": "Management", "survey_type": "Engagement"}, {"code": "Exi-Deve-4", "description": "Reviewer Comments on Development", "factor": "Development", "survey_type": "Exit Survey"}, {"code": "Fee.2", "description": "My job performance is evaluated fairly", "factor": "Feedback & Recognition", "survey_type": "Engagement"}, {"code": "On1-Your-4", "description": "Reviewer Comments on Role Perceptions", "factor": "Your Decision", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Mgrcar.2", "description": "My manager regularly checks in with how I am doing (not just work related)", "factor": "Caring", "survey_type": "Supplementary ME"}, {"code": "Mgreff.5", "description": "My manager makes me feel valued", "factor": "Overall Manager Effectiveness", "survey_type": "Manager Effectiveness"}, {"code": "Ons-Indu-8", "description": "I have had a good quality one on one with my manager", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Ser.1", "description": "Day-to-day decisions here demonstrate that quality and improvement are top priorities", "factor": "Alignment", "survey_type": "Quick Engagement Survey"}, {"code": "Di-Opr-3", "description": "%ACCOUNT_NAME% believes that people can always greatly improve their talents and abilities", "factor": "Opportunities & Resources", "survey_type": "Inclusion Survey"}, {"code": "Eng.3", "description": "I am proud to work for %ACCOUNT_NAME%", "factor": "Engagement", "survey_type": "Onboard Survey (Single Point)"}, {"code": "All-Comm-1", "description": "If there was one element that could positively impact careers at %ACCOUNT_NAME% what would that be?", "factor": "Comments", "survey_type": "The Alliance Diagnostic"}, {"code": "Eng.2", "description": "%ACCOUNT_NAME% motivates me to go beyond what I would in a similar role elsewhere", "factor": "About the Company", "survey_type": "Manager Effectiveness"}, {"code": "Mgrres.3", "description": "My manager helps me remove barriers in my work", "factor": "Results-oriented", "survey_type": "Supplementary ME"}, {"code": "Ser.1", "description": "Day-to-day decisions here demonstrate that quality and improvement are top priorities", "factor": "Service & Quality Focus", "survey_type": "Engagement"}, {"code": "Tea-Focu-3", "description": "Workloads are divided fairly among team members", "factor": "Focus and Accountability", "survey_type": "Team Effectiveness"}, {"code": "All-Inve-1", "description": "%ACCOUNT_NAME% has committed to providing me opportunities to learn skills relevant to my career development goals", "factor": "Career Investment", "survey_type": "The Alliance Diagnostic"}, {"code": "On1-Recr-5", "description": "Reviewer Comments on Recruitment", "factor": "Recruitment", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Ali.2", "description": "I am happy with my current role relative to what was described to me", "factor": "Alignment & Involvement", "survey_type": "Engagement"}, {"code": "Val-Conn-1", "description": "I know our company values", "factor": "Connection", "survey_type": "Values Survey"}, {"code": "Tea-Open-1", "description": "If someone makes a mistake, they admit it to the team", "factor": "Openness", "survey_type": "Team Effectiveness"}, {"code": "Ben-Exis-1", "description": "I understand my benefits package at %ACCOUNT_NAME%", "factor": "Existing Benefits", "survey_type": "Benefits Survey"}, {"code": "Ben-Eval-5", "description": "My choice in medical plan was impacted by coverage", "factor": "Evaluating Medical Plans", "survey_type": "Benefits Survey"}, {"code": "Exi-Lead-2", "description": "The leaders at %ACCOUNT_NAME% communicated a vision that motivated me", "factor": "Leadership", "survey_type": "Exit Survey"}, {"code": "Int-My M-4", "description": "My manager communicated what was important for me to focus on during my internship", "factor": "My Manager", "survey_type": "Intern Survey"}, {"code": "Tea-Role-2", "description": "Where necessary, we have clearly defined roles and responsibilities for each team member", "factor": "Role Clarity", "survey_type": "Team Effectiveness"}, {"code": "Mgrdev.5", "description": "My manager helps me find things in my work and career that really inspire me", "factor": "Development", "survey_type": "Manager Effectiveness"}, {"code": "Mgrres.1", "description": "My manager ensures performance standards are maintained", "factor": "Results-oriented", "survey_type": "Manager Effectiveness"}, {"code": "All-Goal-2", "description": "My manager has spoken with me about how my career goals align with my work at %ACCOUNT_NAME%.", "factor": "Goal Alignment", "survey_type": "The Alliance Diagnostic"}, {"code": "All-Idea-3", "description": "%ACCOUNT_NAME% allows us to actively experiment with new ideas", "factor": "Idea Ecosystem", "survey_type": "The Alliance Diagnostic"}, {"code": "Dev.5", "description": "%ACCOUNT_NAME% is a great company for me to make a contribution to my development", "factor": "Learning & Development", "survey_type": "Engagement"}, {"code": "Dev.4", "description": "My manager (or someone in management) has shown a genuine interest in my career aspirations", "factor": "Development", "survey_type": "Quick Engagement Survey"}, {"code": "Inn.1", "description": "At %ACCOUNT_NAME% we act on promising new or innovative ideas", "factor": "Innovation", "survey_type": "Engagement"}, {"code": "Ben-Eval-2", "description": "The main benefit of my medical coverage is the variety of choice in selecting a doctor", "factor": "Evaluating Medical Plans", "survey_type": "Benefits Survey"}, {"code": "Ons-Indu-6", "description": "I have a good idea about what I can do to have a successful career here", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Dev.3", "description": "I have access to the learning and development I need to do my job well", "factor": "Enablement", "survey_type": "Quick Engagement Survey"}, {"code": "Int-Inte-4", "description": "I had a clear understanding of my role and responsibilities", "factor": "Intern Experience", "survey_type": "Intern Survey"}, {"code": "Di-Fan-4", "description": "Administrative tasks that don\'t have a specific owner (e.g., taking notes in meetings, scheduling events, cleaning up shared space) are fairly divided at %ACCOUNT_NAME%", "factor": "Fairness", "survey_type": "Inclusion Survey"}, {"code": "Int-My M-2", "description": "My manager made it easy for me to get my work done (e.g., removed roadblocks, supplied the resources I needed, connected me with the right people)", "factor": "My Manager", "survey_type": "Intern Survey"}, {"code": "Ons-Indu-11", "description": "My induction program was thorough and effective", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Int-Comm-1", "description": "Is there something we could have done to improve the internship process?", "factor": "Comments", "survey_type": "Intern Survey"}, {"code": "Mgremo.2", "description": "I believe my manager is aware of how their emotions/moods affects others", "factor": "Resilience ", "survey_type": "Supplementary ME"}, {"code": "Ind-Impr-1", "description": "What are my biggest opportunities to improve that you think could make a real difference?", "factor": "Improvement Areas", "survey_type": "Individual Effectiveness"}, {"code": "Wel-Ener-2", "description": "In a typical day, I can accomplish all I need to during my normal working hours", "factor": "Energy", "survey_type": "Wellbeing Survey"}, {"code": "Exi-Lead-3", "description": "My manager was a great role model for me", "factor": "Leadership", "survey_type": "Exit Survey"}, {"code": "Ons-Expe-2", "description": "What\'s one thing we could have done differently to improve your onboarding experience?", "factor": "Experience", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Mgrcoa.3", "description": "My manager asks questions about how I might solve problems, rather than just giving advice", "factor": "Coaching", "survey_type": "Manager Effectiveness"}, {"code": "Eng.4", "description": "I rarely think about looking for a job at another company", "factor": "About the Company", "survey_type": "Manager Effectiveness"}, {"code": "Ben-Exis-8", "description": "The vacation policy allows me sufficient time to recharge", "factor": "Existing Benefits", "survey_type": "Benefits Survey"}, {"code": "Eng.1", "description": "I would recommend %ACCOUNT_NAME% as a great place to work", "factor": "About the Company", "survey_type": "Manager Effectiveness"}, {"code": "Exi-Your-3", "description": "Please indicate the 3 main reasons you joined %ACCOUNT_NAME%:", "factor": "Your Decision", "survey_type": "Exit Survey"}, {"code": "Tea-Focu-2", "description": "We have a shared strategy for how to achieve our team goals", "factor": "Focus and Accountability", "survey_type": "Team Effectiveness"}, {"code": "Col.1", "description": "At %ACCOUNT_NAME% there is open and honest two-way communication", "factor": "Voice", "survey_type": "Inclusion Survey"}, {"code": "Exi-Alig-4", "description": "Reviewer Comments on Alignment", "factor": "Alignment & Involvement", "survey_type": "Exit Survey"}, {"code": "Int-Awar-2", "description": "Before applying for the internship I was already aware of %ACCOUNT_NAME%", "factor": "Awareness", "survey_type": "Intern Survey"}, {"code": "Ben-Eval-4", "description": "My choice in medical plan was impacted by cost", "factor": "Evaluating Medical Plans", "survey_type": "Benefits Survey"}, {"code": "Can-Inte-2", "description": "I felt comfortable during the interview process", "factor": "Interviews", "survey_type": "Candidate Survey"}, {"code": "All-Miss-1", "description": "I have a clear mission objective to accomplish in my current role", "factor": "Mission & Objectives", "survey_type": "The Alliance Diagnostic"}, {"code": "Soc.2", "description": "%ACCOUNT_NAME%\'s commitment to social responsibility (e.g. community support, sustainability, etc.) is genuine", "factor": "Social Connection", "survey_type": "Engagement"}, {"code": "Eng.3", "description": "I am proud to work for %ACCOUNT_NAME%", "factor": "Engagement", "survey_type": "Engagement"}, {"code": "Ben-Eval-6", "description": "My choice in medical plan was impacted by plan type (HMO, PPO, etc)", "factor": "Evaluating Medical Plans", "survey_type": "Benefits Survey"}, {"code": "Exi-Deve-1", "description": "%ACCOUNT_NAME% was a great organization for me to make a contribution to my development", "factor": "Development", "survey_type": "Exit Survey"}, {"code": "Ons-Expe-5", "description": "I\'ve been supported to take time to complete the onboarding process", "factor": "Experience", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Ali.5", "description": "I know what I need to do to be successful in my role", "factor": "Alignment", "survey_type": "Quick Engagement Survey"}, {"code": "Mgrcar.4", "description": "My manager supports me if I need to make use of flexible working arrangements", "factor": "Caring", "survey_type": "Supplementary ME"}, {"code": "Ons-Orga-6", "description": "I still feel like this is a great organization for me", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Di-Dvs-2", "description": "%ACCOUNT_NAME% builds teams that are diverse", "factor": "Diversity", "survey_type": "Inclusion Survey"}, {"code": "Ons-Indu-5", "description": "I have a good idea about what is expected of me in my role", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Mgrdev.1", "description": "My manager frequently recognises progress I make, not just results", "factor": "Development", "survey_type": "Supplementary ME"}, {"code": "Ben-Unde-2", "description": "The perks at %ACCOUNT_NAME% are equal to or better than what is offered by similar employers", "factor": "Understanding Existing Perks", "survey_type": "Benefits Survey"}, {"code": "Ons-Enga-6", "description": "Reviewer Comments on Engagement", "factor": "Engagement", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Tea-Supp-3", "description": "We genuinely care about each team member\'s wellbeing", "factor": "Supportive Climate", "survey_type": "Team Effectiveness"}, {"code": "Mgrcar.3", "description": "My manager takes time to get to know me", "factor": "Caring", "survey_type": "Manager Effectiveness"}, {"code": "Eng.4", "description": "I rarely think about looking for a job at another company", "factor": "Engagement", "survey_type": "Inclusion Survey"}, {"code": "Int-Inte-8", "description": "My pay was competitive compared to the pay for other intern programs", "factor": "Intern Experience", "survey_type": "Intern Survey"}, {"code": "Fee.3", "description": "When it is clear that someone is not delivering in their role we do something about it", "factor": "Feedback & Recognition", "survey_type": "Engagement"}, {"code": "Eng.1", "description": "I would recommend %ACCOUNT_NAME% as a great place to work", "factor": "Engagement", "survey_type": "Inclusion Survey"}, {"code": "Ali.4", "description": "I know how my work contributes to the goals of %ACCOUNT_NAME%", "factor": "Alignment & Involvement", "survey_type": "Engagement"}, {"code": "Ali.5", "description": "I know what I need to do to be successful in my role", "factor": "Alignment & Involvement", "survey_type": "Engagement"}, {"code": "Dev.2", "description": "I believe there are good career opportunities for me at %ACCOUNT_NAME%", "factor": "Learning & Development", "survey_type": "Engagement"}, {"code": "Can-Over-3", "description": "From what I saw, %ACCOUNT_NAME% was a place I\'d love to work", "factor": "Overall", "survey_type": "Intern Survey"}, {"code": "All-Trus-2", "description": "I trust our leaders to keep us informed about things relevant to us and our work", "factor": "Trust & Communication", "survey_type": "The Alliance Diagnostic"}, {"code": "Ena.5", "description": "Most of the systems and processes here support us getting our work done effectively", "factor": "Enablement", "survey_type": "Engagement"}, {"code": "Exi-The -3", "description": "Is the remuneration package for your role:", "factor": "The Future", "survey_type": "Exit Survey"}, {"code": "Ons-Role-2", "description": "I still feel like this is a great role for me", "factor": "Role Perceptions", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Di-Opr-4", "description": "%ACCOUNT_NAME% enables me to balance work and personal life", "factor": "Opportunities & Resources", "survey_type": "Inclusion Survey"}, {"code": "Ons-Indu-1", "description": "What are the three things you have most enjoyed so far working at %ACCOUNT_NAME%", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Tea.2", "description": "We hold ourselves and our team members accountable for results", "factor": "Teamwork & Ownership", "survey_type": "Engagement"}, {"code": "Exi-The -1", "description": "Are you intending to continue working immediately?", "factor": "The Future", "survey_type": "Exit Survey"}, {"code": "Wli.2", "description": "We are genuinely supported if we choose to make use of flexible working arrangements", "factor": "Work & Life Blend", "survey_type": "Engagement"}, {"code": "Can-Inte-4", "description": "My interviewers were prepared for the interview (familiar with my background, etc)", "factor": "Interviews", "survey_type": "Candidate Survey"}, {"code": "Ind-Mana-1", "description": "Setting direction or a strategy for achieving our goals", "factor": "Manager Feedback", "survey_type": "Individual Effectiveness"}, {"code": "Can-Over-5", "description": "The on-site experience at %ACCOUNT_NAME% was fantastic", "factor": "Overall", "survey_type": "Candidate Survey"}, {"code": "All-Goal-1", "description": "My manager and I have discussed how my mission here will benefit %ACCOUNT_NAME%\'s success", "factor": "Goal Alignment", "survey_type": "The Alliance Diagnostic"}, {"code": "Ons-Orga-3", "description": "I know what the organizational goals of %ACCOUNT_NAME% are", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "All-Conv-3", "description": "My manager and I speak openly about the skills and experiences I need to move forward career-wise", "factor": "Career Conversations", "survey_type": "The Alliance Diagnostic"}, {"code": "Man.1", "description": "My manager genuinely cares about my wellbeing", "factor": "Management", "survey_type": "Engagement"}, {"code": "Int-Comm-4", "description": "What was the most important lesson you learned during your internship at %ACCOUNT_NAME%?", "factor": "Comments", "survey_type": "Intern Survey"}, {"code": "Ons-Indu-12", "description": "Reviewer Comments on Onboarding Experience", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Eng.2", "description": "%ACCOUNT_NAME% motivates me to go beyond what I would in a similar role elsewhere", "factor": "Engagement", "survey_type": "Inclusion Survey"}, {"code": "All-Empl-2", "description": "I feel my relationship with %ACCOUNT_NAME% would likely continue even if I left", "factor": "Employee-Employer Relationship", "survey_type": "The Alliance Diagnostic"}, {"code": "Ena.4", "description": "We have enough autonomy to perform our jobs effectively", "factor": "Enablement", "survey_type": "Engagement"}, {"code": "Mgrdev.6", "description": "My manager ensures I am in the right place in the company to be successful", "factor": "Development", "survey_type": "Manager Effectiveness"}, {"code": "Ind-Impr-2", "description": "What examples can you give for your selections that will help me know where to improve?", "factor": "Improvement Areas", "survey_type": "Individual Effectiveness"}, {"code": "Ben-Exis-9", "description": "I believe our benefits package is one of the top reasons why people stay at %ACCOUNT_NAME%", "factor": "Existing Benefits", "survey_type": "Benefits Survey"}, {"code": "Exi-Alig-2", "description": "I received appropriate recognition for good work", "factor": "Alignment & Involvement", "survey_type": "Exit Survey"}, {"code": "Ons-Indu-2", "description": "I\'m confident using the systems I need in my role", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Int-My M-3", "description": "My manager gave me actionable feedback to improve and develop", "factor": "My Manager", "survey_type": "Intern Survey"}, {"code": "Ons-Orga-5", "description": "My experience of the organization has matched my expectations", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "All-Idea-2", "description": "We are encouraged to develop ideas here even if they might fail", "factor": "Idea Ecosystem", "survey_type": "The Alliance Diagnostic"}, {"code": "Int-Awar-1", "description": "What most attracted you to applying at %ACCOUNT_NAME%?", "factor": "Awareness", "survey_type": "Intern Survey"}, {"code": "Exi-Enab-2", "description": "Most of the systems and processes here supported me getting my work done effectively", "factor": "Enablement", "survey_type": "Exit Survey"}, {"code": "On5-Enga-6", "description": "Reviewer Comments on Engagement", "factor": "Engagement", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Int-Inte-5", "description": "I had several good opportunities to refine my skills", "factor": "Intern Experience", "survey_type": "Intern Survey"}, {"code": "Int-Inte-7", "description": "Within my team, we worked together effectively to get things done", "factor": "Intern Experience", "survey_type": "Intern Survey"}, {"code": "Ons-Indu-4", "description": "I have a good idea about what I still need to learn to do my job well", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Ser.1", "description": "Day-to-day decisions here demonstrate that quality and improvement are top priorities", "factor": "Alignment & Involvement", "survey_type": "Exit Survey"}, {"code": "Ena.2", "description": "Our physical workspace is enjoyable to work in", "factor": "Enablement", "survey_type": "Engagement"}, {"code": "Mgremo.3", "description": "My manager copes well in a changing environment", "factor": "Resilience ", "survey_type": "Manager Effectiveness"}, {"code": "All-Inde-4", "description": "I see 2-3 years (or potentially more) at %ACCOUNT_NAME% as a great way to develop my career", "factor": "Alliance Index", "survey_type": "The Alliance Diagnostic"}, {"code": "Di-Bel-1", "description": "I can be my authentic self at work", "factor": "Belonging", "survey_type": "Inclusion Survey"}, {"code": "All-Conv-2", "description": "My manager and I have discussed people and/or career paths that inspire me", "factor": "Career Conversations", "survey_type": "The Alliance Diagnostic"}, {"code": "Tea-Team-3", "description": "Generally, I support how decisions are made in our team", "factor": "Team Processes", "survey_type": "Team Effectiveness"}, {"code": "Ons-Recr-3", "description": "The recruitment and selection process was professionally conducted", "factor": "Recruitment", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Tea-Focu-4", "description": "We regularly check in on how we are progressing towards our goals", "factor": "Focus and Accountability", "survey_type": "Team Effectiveness"}, {"code": "Ons-Indu-6", "description": "I have a good idea about what I can do to have a successful career here", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "All-Empl-1", "description": "Promises concerning my role and development are honored at %ACCOUNT_NAME%", "factor": "Employee-Employer Relationship", "survey_type": "The Alliance Diagnostic"}, {"code": "Lea.3", "description": "The leaders at %ACCOUNT_NAME% have communicated a vision that motivates me", "factor": "Leadership", "survey_type": "Engagement"}, {"code": "Mgrcap.5", "description": "My manager shares their knowledge and expertise with the team", "factor": "Technical Capability", "survey_type": "Supplementary ME"}, {"code": "Ons-Indu-11", "description": "My induction program was thorough and effective", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Con.3", "description": "%ACCOUNT_NAME% is in a position to really succeed over the next three years", "factor": "Company Performance", "survey_type": "Engagement"}, {"code": "Ons-Expe-2", "description": "What\'s one thing we could have done differently to improve your onboarding experience?", "factor": "Experience", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Tea-Deve-1", "description": "Working on this team provides me with opportunities that contribute to my development", "factor": "Development", "survey_type": "Team Effectiveness"}, {"code": "All-Chec-2", "description": "I\'m confident that I will have the opportunity to speak about my career here", "factor": "Check Ins", "survey_type": "The Alliance Diagnostic"}, {"code": "All-Inde-3", "description": "%ACCOUNT_NAME% is a place to explore and build great things", "factor": "Alliance Index", "survey_type": "The Alliance Diagnostic"}, {"code": "Exi-Enga-2", "description": "%ACCOUNT_NAME% motivated me to go beyond what I would in a similar role elsewhere", "factor": "Engagement", "survey_type": "Exit Survey"}, {"code": "On5-Role-3", "description": "Reviewer Comments on Role Perceptions", "factor": "Role Perceptions", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Tea.1", "description": "I feel I am part of a team", "factor": "Teamwork & Ownership", "survey_type": "Engagement"}, {"code": "Eng-Comm-2", "description": "Are there some things we are not doing so great here?", "factor": "Comments", "survey_type": "Quick Engagement Survey"}, {"code": "On5-Indu-12", "description": "Reviewer Comments on Onboarding Experience", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Di-Cbp-2", "description": "The work that we do at %ACCOUNT_NAME% is important", "factor": "Contribution to Broader Purpose", "survey_type": "Inclusion Survey"}, {"code": "Man.4", "description": "My manager keeps me informed about what is happening at %ACCOUNT_NAME%", "factor": "Management", "survey_type": "Engagement"}, {"code": "Man-Comt-1", "description": "Do you have any other feedback you want to share about your manager?", "factor": "Comments", "survey_type": "Manager Effectiveness"}, {"code": "Mgrfai.3", "description": "My manager ensures that people\'s ideas and work are attributed to them appropriately", "factor": "Fair Treatment", "survey_type": "Supplementary ME"}, {"code": "Wel-Ener-1", "description": "I typically wake up feeling fresh and rested for work", "factor": "Energy", "survey_type": "Wellbeing Survey"}, {"code": "Int-Awar-4", "description": "How did you first hear about an opportunity to intern at %ACCOUNT_NAME%?", "factor": "Awareness", "survey_type": "Intern Survey"}, {"code": "Ali.3", "description": "I believe my total compensation (base salary+any bonuses+benefits+equity) is fair, relative to similar roles at other companies", "factor": "Alignment & Involvement", "survey_type": "Engagement"}, {"code": "Ons-Recr-3", "description": "The recruitment and selection process was professionally conducted", "factor": "Recruitment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Int-My M-1", "description": "My manager had the relevant expertise required to effectively coach me", "factor": "My Manager", "survey_type": "Intern Survey"}, {"code": "Ons-Indu-8", "description": "I have had a good quality one on one with my manager", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Col.1", "description": "At %ACCOUNT_NAME% there is open and honest two-way communication", "factor": "Collaboration & Communication", "survey_type": "Engagement"}, {"code": "Ben-Eval-3", "description": "The main benefit of my medical coverage is protection in case of an emergency", "factor": "Evaluating Medical Plans", "survey_type": "Benefits Survey"}, {"code": "Tea-Team-4", "description": "We share or rotate some leadership responsibilities in our team (e.g., running meetings, tracking goals, follow-up)", "factor": "Team Processes", "survey_type": "Team Effectiveness"}, {"code": "Eng.3", "description": "I am proud to work for %ACCOUNT_NAME%", "factor": "Engagement", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Tea-Supp-2", "description": "Team members volunteer to help each other when needed", "factor": "Supportive Climate", "survey_type": "Team Effectiveness"}, {"code": "Tea-Over-3", "description": "I believe I am on the best team for me right now", "factor": "Overall Team Effectiveness", "survey_type": "Team Effectiveness"}, {"code": "Exi-Enab-4", "description": "Reviewer Comments on Enablement", "factor": "Enablement", "survey_type": "Exit Survey"}, {"code": "Mgrcap.4", "description": "My manager is willing to work side by side with the team when necessary", "factor": "Technical Capability", "survey_type": "Supplementary ME"}, {"code": "Tea-Know-3", "description": "I believe we can successfully accomplish our team goals", "factor": "Knowledge and Capability", "survey_type": "Team Effectiveness"}, {"code": "Ben-Eval-1", "description": "I understand how to select the best medical coverage", "factor": "Evaluating Medical Plans", "survey_type": "Benefits Survey"}, {"code": "Tea-Orga-1", "description": "Our team goals are well aligned with the company goals", "factor": "Organizational Alignment", "survey_type": "Team Effectiveness"}, {"code": "Wel-Over-2", "description": "I often get absorbed in my work and lose track of time", "factor": "Overall Wellbeing", "survey_type": "Wellbeing Survey"}, {"code": "Con.1", "description": "The products and services %ACCOUNT_NAME% provides are as good as, or better than, our main competitors", "factor": "Company Performance", "survey_type": "Engagement"}, {"code": "On1-Chec-4", "description": "Reviewer Comments on Onboarding Experience", "factor": "Checklist", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Ons-Role-2", "description": "I still feel like this is a great role for me", "factor": "Role Perceptions", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "On1-Chec-2", "description": "Reviewer Comments on Onboarding Checklist", "factor": "Checklist", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Eng.5", "description": "I see myself still working at %ACCOUNT_NAME% in two years\' time", "factor": "Engagement", "survey_type": "Inclusion Survey"}, {"code": "Ons-Indu-1", "description": "What are the three things you have most enjoyed so far working at %ACCOUNT_NAME%", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Ons-Your-3", "description": "Reviewer Comments on Your Decision", "factor": "Your Decision", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Tea-Orga-3", "description": "The work our team does makes a positive difference at %ACCOUNT_NAME%", "factor": "Organizational Alignment", "survey_type": "Team Effectiveness"}, {"code": "Ons-Chec-2", "description": "Reviewer Comments on Onboarding Checklist", "factor": "Checklist", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Ons-Orga-3", "description": "I know what the organizational goals of %ACCOUNT_NAME% are", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Tea-Focu-1", "description": "I understand what our team is meant to accomplish", "factor": "Focus and Accountability", "survey_type": "Team Effectiveness"}, {"code": "On5-Orga-7", "description": "Reviewer Comments on Organizational Alignment", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Eng-Comm-1", "description": "Are there some things we are doing great here?", "factor": "Comments", "survey_type": "Engagement"}, {"code": "Ind-Mana-3", "description": "Focusing on performance outcomes", "factor": "Manager Feedback", "survey_type": "Individual Effectiveness"}, {"code": "Ena.1", "description": "I have access to the things I need to do my job well", "factor": "Enablement", "survey_type": "Quick Engagement Survey"}, {"code": "Ons-Your-3", "description": "Reviewer Comments on Your Decision", "factor": "Experience", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Eng.4", "description": "I rarely think about looking for a job at another company", "factor": "Engagement", "survey_type": "Quick Engagement Survey"}, {"code": "Exi-Your-6", "description": "Reviewer Comments on Your Decision", "factor": "Your Decision", "survey_type": "Exit Survey"}, {"code": "Ons-Recr-4", "description": "How long did your recruitment process take from application to offer?", "factor": "Recruitment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Ons-Chec-1", "description": "The following list includes things that are important for your successful onboarding here at %ACCOUNT_NAME%. Please tick the things that you believe have NOT been covered or completed so far:", "factor": "Checklist", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Eng.1", "description": "I would recommend %ACCOUNT_NAME% as a great place to work", "factor": "Engagement", "survey_type": "Quick Engagement Survey"}, {"code": "Ons-Orga-5", "description": "My experience of the organization has matched my expectations", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Ons-Indu-2", "description": "I\'m confident using the systems I need in my role", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Ons-Your-2", "description": "What were you doing before you began working here?", "factor": "Your Decision", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Tea-Team-2", "description": "Our team meetings and discussions are effective", "factor": "Team Processes", "survey_type": "Team Effectiveness"}, {"code": "Can-Over-1", "description": "What is ONE thing you think we could do to attract great talent?", "factor": "Overall", "survey_type": "Candidate Survey"}, {"code": "All-Inve-2", "description": "I have a good understanding of how contributing at %ACCOUNT_NAME% will also benefit my career", "factor": "Career Investment", "survey_type": "The Alliance Diagnostic"}, {"code": "Mgrcom.1", "description": "My manager communicates a vision that motivates me", "factor": "Vision and Goal Setting", "survey_type": "Manager Effectiveness"}, {"code": "Ons-Indu-4", "description": "I have a good idea about what I still need to learn to do my job well", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Val-Conn-4", "description": "I believe our company values match our culture", "factor": "Connection", "survey_type": "Values Survey"}, {"code": "Eng-Comm-3", "description": "Is there something else you think we should have asked you in this survey?", "factor": "Comments", "survey_type": "Quick Engagement Survey"}, {"code": "Exi-Your-1", "description": "Please indicate in a brief statement the major reason behind your decision to leave %ACCOUNT_NAME%:", "factor": "Your Decision", "survey_type": "Exit Survey"}, {"code": "Mgrfai.2", "description": "My manager does a good job of managing our team\'s work (allocating work assignments, setting priorities, scheduling, etc.)", "factor": "Fair Treatment", "survey_type": "Supplementary ME"}, {"code": "Val-Impo-1", "description": "[INSERT VALUE] is an extremely important value for me in this company", "factor": "Importance", "survey_type": "Values Survey"}, {"code": "Mgrcap.3", "description": "My manager has the right technical knowledge to help our team", "factor": "Technical Capability", "survey_type": "Manager Effectiveness"}, {"code": "Di-Voc-2", "description": "I can voice a contrary opinion without fear of negative consequences", "factor": "Voice", "survey_type": "Inclusion Survey"}, {"code": "Can-Awar-3", "description": "Before applying for the job I was already aware of %ACCOUNT_NAME%", "factor": "Awareness", "survey_type": "Candidate Survey"}, {"code": "Ons-Your-3", "description": "Reviewer Comments on Your Decision", "factor": "Your Decision", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Ben-Exis-5", "description": "Should I die, my life insurance plan provides sufficient coverage for my dependents/beneficiaries", "factor": "Existing Benefits", "survey_type": "Benefits Survey"}, {"code": "Lea.4", "description": "The leaders at %ACCOUNT_NAME% keep people informed about what is happening", "factor": "Leadership", "survey_type": "Quick Engagement Survey"}, {"code": "Tea-Over-1", "description": "As a team we consistently deliver high quality work", "factor": "Overall Team Effectiveness", "survey_type": "Team Effectiveness"}, {"code": "Ons-Expe-5", "description": "I\'ve been supported to take time to complete the onboarding process", "factor": "Experience", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Ind-Mana-6", "description": "Helping to remove barriers in your work", "factor": "Manager Feedback", "survey_type": "Individual Effectiveness"}, {"code": "All-Miss-2", "description": "I know what I need to do to be successful in my current role/mission", "factor": "Mission & Objectives", "survey_type": "The Alliance Diagnostic"}, {"code": "Ons-Orga-6", "description": "I still feel like this is a great organization for me", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Tea-Comt-2", "description": "What is one thing that you would like our team to keep doing?", "factor": "Comments", "survey_type": "Team Effectiveness"}, {"code": "Ind-Stre-1", "description": "What have you observed me excelling at that I should continue?", "factor": "Strength Areas", "survey_type": "Individual Effectiveness"}, {"code": "Col.2", "description": "Most people here make a good effort to consult other staff where appropriate", "factor": "Collaboration & Communication", "survey_type": "Engagement"}, {"code": "On5-Expe-9", "description": "Reviewer Comments on Welcome & Induction", "factor": "Experience", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Dev.1", "description": "I am given opportunities to develop skills relevant to my interests", "factor": "Learning & Development", "survey_type": "Engagement"}, {"code": "Mgrdec.1", "description": "My manager makes decisions effectively (i.e. timely, with sufficient information/ perspectives)", "factor": "Results-oriented", "survey_type": "Manager Effectiveness"}, {"code": "Ons-Indu-5", "description": "I have a good idea about what is expected of me in my role", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Ons-Expe-6", "description": "Reviewer Comments on Welcome & Induction", "factor": "Experience", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Ons-Orga-7", "description": "Reviewer Comments on Organizational Alignment", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Tea-Know-2", "description": "Team members readily share their knowledge and lessons learned", "factor": "Knowledge and Capability", "survey_type": "Team Effectiveness"}, {"code": "Ons-Recr-4", "description": "How long did your recruitment process take from application to offer?", "factor": "Recruitment", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Ons-Chec-1", "description": "The following list includes things that are important for your successful onboarding here at %ACCOUNT_NAME%. Please tick the things that you believe have NOT been covered or completed so far:", "factor": "Checklist", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Int-Inte-1", "description": "My intern experience gave me valuable information about my chosen field", "factor": "Intern Experience", "survey_type": "Intern Survey"}, {"code": "Ons-Your-2", "description": "What were you doing before you began working here?", "factor": "Your Decision", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Eng.2", "description": "%ACCOUNT_NAME% motivates me to go beyond what I would in a similar role elsewhere", "factor": "Engagement", "survey_type": "Quick Engagement Survey"}, {"code": "All-Exte-2", "description": "We are encouraged to connect with former employees", "factor": "External Learning", "survey_type": "The Alliance Diagnostic"}, {"code": "Ind-Mana-4", "description": "Sharing my knowledge and expertise", "factor": "Manager Feedback", "survey_type": "Individual Effectiveness"}, {"code": "Exi-Enab-1", "description": "I had access to the learning and development I needed to do my job well", "factor": "Enablement", "survey_type": "Exit Survey"}, {"code": "Can-Over-3", "description": "From what I saw, %ACCOUNT_NAME% was a place I\'d love to work", "factor": "Overall", "survey_type": "Candidate Survey"}, {"code": "Exi-Deve-2", "description": "My manager (or someone in management) showed a genuine interest in my career aspirations", "factor": "Development", "survey_type": "Exit Survey"}, {"code": "Int-Inte-6", "description": "When I did an excellent job my accomplishments were recognized", "factor": "Intern Experience", "survey_type": "Intern Survey"}, {"code": "Ons-Indu-7", "description": "The onboarding experience gave me the opportunity to establish good relationships with people that are key to my role", "factor": "Induction", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Di-Voc-1", "description": "When I speak up, my opinion is valued", "factor": "Voice", "survey_type": "Inclusion Survey"}, {"code": "Soc.1", "description": "%ACCOUNT_NAME% really allows us to make a positive difference", "factor": "Social Connection", "survey_type": "Engagement"}, {"code": "Fee.1", "description": "I receive appropriate recognition for good work at %ACCOUNT_NAME%", "factor": "Alignment", "survey_type": "Quick Engagement Survey"}, {"code": "Can-Recr-2", "description": "Overall, I was provided clear information about %ACCOUNT_NAME% and working there", "factor": "Recruitment", "survey_type": "Candidate Survey"}, {"code": "All-Chec-1", "description": "My manager encourages me to \'check-in\' as a method to stay on track", "factor": "Check Ins", "survey_type": "The Alliance Diagnostic"}, {"code": "Tea-Open-3", "description": "Team members encourage each other to share their unpolished thoughts and ideas", "factor": "Openness", "survey_type": "Team Effectiveness"}, {"code": "Exi-Lead-1", "description": "The leaders at %ACCOUNT_NAME% kept people informed about what is happening", "factor": "Leadership", "survey_type": "Exit Survey"}, {"code": "Di-Opr-2", "description": "I know where to find information to do my job well", "factor": "Opportunities & Resources", "survey_type": "Inclusion Survey"}, {"code": "Ons-Recr-2", "description": "I was provided accurate information about %ACCOUNT_NAME% during the recruitment process", "factor": "Recruitment", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Di-Cbp-1", "description": "I understand how my work contributes to %ACCOUNT_NAME%\\u2019s mission", "factor": "Contribution to Broader Purpose", "survey_type": "Inclusion Survey"}, {"code": "Wel-Over-4", "description": "In general, I feel what I do at work is worthwhile", "factor": "Overall Wellbeing", "survey_type": "Wellbeing Survey"}, {"code": "Ons-Orga-2", "description": "The organizational values of %ACCOUNT_NAME% align well with my own values", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Mgrres.2", "description": "My manager helps us get workable results from our team meetings", "factor": "Results-oriented", "survey_type": "Supplementary ME"}, {"code": "Ben-Unde-3", "description": "The perks at %ACCOUNT_NAME% save me a great deal of time and/or money, and add significant value to my employee experience", "factor": "Understanding Existing Perks", "survey_type": "Benefits Survey"}, {"code": "Int-Comm-2", "description": "What other companies did you consider for your internships?", "factor": "Comments", "survey_type": "Intern Survey"}, {"code": "Ser.2", "description": "We acknowledge people who deliver outstanding service here", "factor": "Service & Quality Focus", "survey_type": "Engagement"}, {"code": "Ind-Mana-9", "description": "Helping you with your career and personal development", "factor": "Manager Feedback", "survey_type": "Individual Effectiveness"}, {"code": "Man.4", "description": "My manager keeps me informed about what is happening at %ACCOUNT_NAME%", "factor": "Communicating", "survey_type": "Manager Effectiveness"}, {"code": "Mgrcom.5", "description": "My manager collaborates well across organisational boundaries (e.g. teams, departments, etc.)", "factor": "Communicating", "survey_type": "Manager Effectiveness"}, {"code": "Mgrcom.3", "description": "My manager keeps me informed about important decisions (including those that impact my work)", "factor": "Trust & Communication", "survey_type": "The Alliance Diagnostic"}, {"code": "Int-Inte-3", "description": "During my internship, I had the time I needed to create and innovate", "factor": "Intern Experience", "survey_type": "Intern Survey"}, {"code": "Eng.1", "description": "I would recommend %ACCOUNT_NAME% as a great place to work", "factor": "Engagement", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Ben-Unde-4", "description": "The wellness offerings at %ACCOUNT_NAME% help me lead a happier, healthier life", "factor": "Understanding Existing Perks", "survey_type": "Benefits Survey"}, {"code": "Ons-Indu-3", "description": "I have had good training on the processes applicable to my role", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Mgrcom.3", "description": "My manager keeps me informed about important decisions (including those that impact my work)", "factor": "Communicating", "survey_type": "Supplementary ME"}, {"code": "Eng.4", "description": "I rarely think about looking for a job at another company", "factor": "Engagement", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Dev.5", "description": "%ACCOUNT_NAME% is a great company for me to make a contribution to my development", "factor": "Development", "survey_type": "Quick Engagement Survey"}, {"code": "Dev.4", "description": "My manager (or someone in management) has shown a genuine interest in my career aspirations", "factor": "Learning & Development", "survey_type": "Engagement"}, {"code": "Act.2", "description": "My manager, or someone else, has communicated some clear actions based on recent employee survey results", "factor": "Action", "survey_type": "Engagement"}, {"code": "Exi-Enga-4", "description": "Reviewer Comments on Engagement", "factor": "Engagement", "survey_type": "Exit Survey"}, {"code": "Di-Bel-2", "description": "Even when something bad happens (e.g., when I get critical feedback from my manager, I have a negative social interaction with a peer, etc.), I don\\u2019t question whether or not I belong at %ACCOUNT_NAME%", "factor": "Belonging", "survey_type": "Inclusion Survey"}, {"code": "Can-Over-2", "description": "Is there something we could have done to improve the candidate/recruitment process?", "factor": "Overall", "survey_type": "Candidate Survey"}, {"code": "Mgrcoa.2", "description": "My manager regularly gives me feedback I can put to use", "factor": "Manager As Coach", "survey_type": "The Alliance Diagnostic"}, {"code": "Val-Conn-2", "description": "I think I have a good understanding of what our company values mean", "factor": "Connection", "survey_type": "Values Survey"}, {"code": "Mgrinc.1", "description": "My manager builds an inclusive team environment", "factor": "Inclusion ", "survey_type": "Manager Effectiveness"}, {"code": "Eng.5", "description": "I see myself still working at %ACCOUNT_NAME% in two years\' time", "factor": "Engagement", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Wel-Ener-3", "description": "I usually have enough energy to overcome challenges at work", "factor": "Energy", "survey_type": "Wellbeing Survey"}, {"code": "Exi-Enga-3", "description": "For most of my time with %ACCOUNT_NAME% I rarely  thought about looking for a job at another company", "factor": "Engagement", "survey_type": "Exit Survey"}, {"code": "All-Idea-4", "description": "%ACCOUNT_NAME% has established effective channels for us to pitch ideas", "factor": "Idea Ecosystem", "survey_type": "The Alliance Diagnostic"}, {"code": "Can-Inte-5", "description": "The interview sessions increased my excitement for the role", "factor": "Interviews", "survey_type": "Candidate Survey"}, {"code": "Exi-Your-2", "description": "Is there something we could have done to keep you with %ACCOUNT_NAME%?", "factor": "Your Decision", "survey_type": "Exit Survey"}, {"code": "Tea-Over-2", "description": "I am proud of what we accomplish as a team", "factor": "Overall Team Effectiveness", "survey_type": "Team Effectiveness"}, {"code": "Exi-The -4", "description": "Reviewer Comments on The Future", "factor": "The Future", "survey_type": "Exit Survey"}, {"code": "Tea-Over-5", "description": "I feel I belong on this team", "factor": "Overall Team Effectiveness", "survey_type": "Team Effectiveness"}, {"code": "Ons-Recr-2", "description": "I was provided accurate information about %ACCOUNT_NAME% during the recruitment process", "factor": "Recruitment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Exi-Your-4", "description": "Please indicate the 3 main reasons you are leaving %ACCOUNT_NAME%:", "factor": "Your Decision", "survey_type": "Exit Survey"}, {"code": "Wli.1", "description": "Generally, I believe my workload is reasonable for my role", "factor": "Work & Life Blend", "survey_type": "Engagement"}, {"code": "Ben-Unde-5", "description": "Select the perk you think would be the best new addition to the company\'s offering", "factor": "Understanding Existing Perks", "survey_type": "Benefits Survey"}, {"code": "All-Idea-5", "description": "%ACCOUNT_NAME% helps us take promising ideas through to implementation/testing", "factor": "Idea Ecosystem", "survey_type": "The Alliance Diagnostic"}, {"code": "On5-Expe-8", "description": "Reviewer Comments on Onboarding Checklist", "factor": "Experience", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Di-Bel-4", "description": "I feel like I belong at %ACCOUNT_NAME%", "factor": "Belonging", "survey_type": "Inclusion Survey"}, {"code": "Mgrcoa.1", "description": "My manager makes time for one-on-one meetings with me", "factor": "Coaching", "survey_type": "Supplementary ME"}, {"code": "Eng.2", "description": "%ACCOUNT_NAME% motivates me to go beyond what I would in a similar role elsewhere", "factor": "Engagement", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Can-Recr-4", "description": "The recruitment process gave me a good insight into the company\'s culture and values", "factor": "Recruitment", "survey_type": "Candidate Survey"}, {"code": "Int-Comm-3", "description": "What would you consider the most desirable companies to work for?", "factor": "Comments", "survey_type": "Intern Survey"}, {"code": "Mgrcoa.4", "description": "My manager regularly gives me feedback on how well I am performing", "factor": "Coaching", "survey_type": "Supplementary ME"}, {"code": "Man.3", "description": "My manager is a great role model for employees", "factor": "Leadership", "survey_type": "Quick Engagement Survey"}, {"code": "On1-Your-5", "description": "Reviewer Comments on Engagement", "factor": "Your Decision", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Ena.3", "description": "The information I need to do my job effectively is readily available", "factor": "Enablement", "survey_type": "Engagement"}, {"code": "All-Exte-1", "description": "We are encouraged to seek help or knowledge by connecting with people outside of %ACCOUNT_NAME%", "factor": "External Learning", "survey_type": "The Alliance Diagnostic"}, {"code": "Can-Over-4", "description": "I would encourage other people to apply at %ACCOUNT_NAME%", "factor": "Overall", "survey_type": "Candidate Survey"}, {"code": "Can-Recr-1", "description": "The recruitment team was well organized and professional to deal with", "factor": "Recruitment", "survey_type": "Candidate Survey"}, {"code": "Ena.5", "description": "Most of the systems and processes here support us getting our work done effectively", "factor": "Enablement", "survey_type": "Quick Engagement Survey"}, {"code": "Val-Perf-1", "description": "%ACCOUNT_NAME% really demonstrates a day-to-day commitment to [INSERT VALUE X]", "factor": "Performance", "survey_type": "Values Survey"}, {"code": "Ben-Exis-2", "description": "I believe my benefits package at %ACCOUNT_NAME% is equal to or better than what is offered by similar employers", "factor": "Existing Benefits", "survey_type": "Benefits Survey"}, {"code": "Tea-Comm-1", "description": "Overall, team members are provided equal opportunities to speak during team discussions", "factor": "Communication and Collaboration", "survey_type": "Team Effectiveness"}, {"code": "Mgrcar.5", "description": "I would speak to my manager if I was thinking about leaving %ACCOUNT_NAME%", "factor": "Caring", "survey_type": "Supplementary ME"}, {"code": "Ons-Orga-4", "description": "I understand how my role contibutes to the organizational goals of %ACCOUNT_NAME%", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "All-Idea-1", "description": "We are encouraged to take risks if we feel it might positively affect the work", "factor": "Idea Ecosystem", "survey_type": "The Alliance Diagnostic"}, {"code": "Ons-Indu-10", "description": "My on-the-job training has been effective", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Mgrinn.2", "description": "My manager encourages innovative ideas and approaches", "factor": "Fostering Innovation", "survey_type": "Supplementary ME"}, {"code": "All-Chec-3", "description": "Speaking openly about obstacles to accomplishing goals (getting the work done) is encouraged here", "factor": "Check Ins", "survey_type": "The Alliance Diagnostic"}, {"code": "Mgrinn.1", "description": "My manager gives me enough autonomy to make my own decisions ", "factor": "Fostering Innovation", "survey_type": "Manager Effectiveness"}, {"code": "Eng.3", "description": "I am proud to work for %ACCOUNT_NAME%", "factor": "Checklist", "survey_type": "Onboard Survey (Phased Week 1)"}, {"code": "Mgreff.2", "description": "My manager helps me stay motivated to do my best work", "factor": "Overall Manager Effectiveness", "survey_type": "Manager Effectiveness"}, {"code": "Exi-Enab-3", "description": "I had access to the things I needed to do my job well", "factor": "Enablement", "survey_type": "Exit Survey"}, {"code": "Lea.2", "description": "The leaders at %ACCOUNT_NAME% demonstrate that people are important to the company\'s success", "factor": "Trust & Communication", "survey_type": "The Alliance Diagnostic"}, {"code": "Dev.2", "description": "I believe there are good career opportunities for me at %ACCOUNT_NAME%", "factor": "Development", "survey_type": "Quick Engagement Survey"}, {"code": "Fee.1", "description": "I receive appropriate recognition for good work at %ACCOUNT_NAME%", "factor": "Feedback & Recognition", "survey_type": "Engagement"}, {"code": "Int-Over-3", "description": "Overall how satisfied were you with your intern experience at %ACCOUNT_NAME%?", "factor": "Overall", "survey_type": "Intern Survey"}, {"code": "Ons-Role-3", "description": "Reviewer Comments on Role Perceptions", "factor": "Role Perceptions", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Tea-Over-4", "description": "Being on this team enables me to do my best work", "factor": "Overall Team Effectiveness", "survey_type": "Team Effectiveness"}, {"code": "Can-Awar-5", "description": "What were you doing before you applied to work at %ACCOUNT_NAME%?", "factor": "Awareness", "survey_type": "Candidate Survey"}, {"code": "Tea-Open-2", "description": "When I contribute ideas and thoughts, I believe my opinion is valued", "factor": "Openness", "survey_type": "Team Effectiveness"}, {"code": "Ind-Mana-5", "description": "Working alongside the team", "factor": "Manager Feedback", "survey_type": "Individual Effectiveness"}, {"code": "Can-Awar-1", "description": "What things most attracted you to applying at %ACCOUNT_NAME%", "factor": "Awareness", "survey_type": "Candidate Survey"}, {"code": "Wli.3", "description": "I am able to arrange time out from work when I need to", "factor": "Work & Life Blend", "survey_type": "Engagement"}, {"code": "Ons-Expe-3", "description": "I am feeling welcome here", "factor": "Experience", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Di-Dem-3", "description": "I am satisfied with how decisions are made at %ACCOUNT_NAME%", "factor": "Decision Making", "survey_type": "Inclusion Survey"}, {"code": "Eng.1", "description": "I would recommend %ACCOUNT_NAME% as a great place to work", "factor": "Engagement", "survey_type": "Exit Survey"}, {"code": "On5-Expe-7", "description": "Reviewer Comments on Recruitment", "factor": "Experience", "survey_type": "Onboard Survey (Phased Week 5 )"}, {"code": "Ben-Exis-6", "description": "Should I become unable to work, my disability coverage provides sufficient coverage", "factor": "Existing Benefits", "survey_type": "Benefits Survey"}, {"code": "All-Inve-3", "description": "The effort I invest in my work is a fair exchange for what I have gained career-wise at %ACCOUNT_NAME%", "factor": "Career Investment", "survey_type": "The Alliance Diagnostic"}, {"code": "Tea-Know-1", "description": "My expertise is well utilized on this team", "factor": "Knowledge and Capability", "survey_type": "Team Effectiveness"}, {"code": "Exi-Lead-4", "description": "Reviewer Comments on Leadership", "factor": "Leadership", "survey_type": "Exit Survey"}, {"code": "Mgrdev.4", "description": "My manager has a good understanding of my longer term career aspirations (not necessarily just within %ACCOUNT_NAME%)", "factor": "Career Conversations", "survey_type": "The Alliance Diagnostic"}, {"code": "Ons-Indu-9", "description": "The information provided has been at the right level for me", "factor": "Induction", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Exi-The -2", "description": "What will you be moving to when you leave %ACCOUNT_NAME%?", "factor": "The Future", "survey_type": "Exit Survey"}, {"code": "Man.1", "description": "My manager genuinely cares about my wellbeing", "factor": "Caring", "survey_type": "Manager Effectiveness"}, {"code": "Mgrdev.2", "description": "My manager shows a genuine interest in my career at %ACCOUNT_NAME% ", "factor": "Development", "survey_type": "Supplementary ME"}, {"code": "Mgrinn.3", "description": "My manager helps me follow through on innovative ideas", "factor": "Fostering Innovation", "survey_type": "Manager Effectiveness"}, {"code": "Ons-Expe-4", "description": "I am feeling productive", "factor": "Experience", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Eng.5", "description": "I see myself still working at %ACCOUNT_NAME% in two years\' time", "factor": "Engagement", "survey_type": "Engagement"}, {"code": "Di-Fan-1", "description": "I believe that my total compensation (base salary+any bonuses+benefits+equity) is fair, relative to similar roles at %ACCOUNT_NAME%", "factor": "Fairness", "survey_type": "Inclusion Survey"}, {"code": "Ons-Orga-1", "description": "I know what the organizational values of %ACCOUNT_NAME% are", "factor": "Organizational Alignment", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Exi-Othe-1", "description": "Reviewer Comments on Other", "factor": "Other", "survey_type": "Exit Survey"}, {"code": "Mgrfai.1", "description": "My manager frequently recognises when I deliver good work", "factor": "Fair Treatment", "survey_type": "Manager Effectiveness"}, {"code": "Can-Inte-3", "description": "My interviewers asked me interesting questions that assessed my skills for performing in the role", "factor": "Interviews", "survey_type": "Candidate Survey"}, {"code": "Ons-Role-1", "description": "My role so far matches the role description provided to me", "factor": "Role Perceptions", "survey_type": "Onboard Survey (Single Point)"}, {"code": "Mgrdev.4", "description": "My manager has a good understanding of my longer term career aspirations (not necessarily just within %ACCOUNT_NAME%)", "factor": "Development", "survey_type": "Supplementary ME"}, {"code": "Mgrdev.3", "description": "My manager helps me understand potential career paths at %ACCOUNT_NAME%", "factor": "Development", "survey_type": "Manager Effectiveness"}, {"code": "Ons-Expe-1", "description": "Is there anything else you would have liked included in your onboarding process?", "factor": "Experience", "survey_type": "Onboard Survey (Phased Week 5 )"}]'

In [93]:

    

core_insp_df.head()


    

    
Out[93]:







  

    

      

      
created_at
      
updated_at
      
id
      
name
      
excerpt
      
description
      
status
    
  
  

    

      
0
      
2017-08-17 11:04:35.065515
      
2018-01-25 04:20:45.913654
      
fade6361-3514-45f9-8ad7-9be84dafb609
      
Expanded career conversations
      
Hold mid-year career conversations
      
Hold more regular career-focused conversations...
      
None
    
    

      
1
      
2017-08-17 11:01:07.333956
      
2018-01-25 04:20:45.787361
      
4e1e81a2-9f33-4473-83dc-c6b8e4917a93
      
Anonymous questions
      
Create anonymous comms channel for employees
      
Make space for feedback and questions from all...
      
None
    
    

      
2
      
2017-08-17 11:00:49.831106
      
2018-01-25 04:20:45.809673
      
622179d7-b06b-4493-9b17-9f8d5ff5b7b0
      
Skip level meetings
      
Implement skip level meetings around decision ...
      
Foster open communication and alignment using ...
      
None
    
    

      
3
      
2017-08-17 11:00:53.884463
      
2018-01-25 04:20:45.794741
      
6b0d0bd5-ce50-480c-b937-7faab0026b19
      
Seat shuffle
      
Get to know others in the business
      
Encouraging employees to get to know others ou...
      
None
    
    

      
4
      
2017-08-17 11:01:02.865682
      
2018-01-25 04:20:45.773347
      
0826f61d-c88d-4842-b6c2-5ed20fd172d1
      
Who's who in the zoo
      
Keeping employees connected
      
Growing quickly can result in newcomers findin...
      
None
    
  

In [ ]:

    

ins


    

In [95]:

    

core_insp_to_ref_question_df = pd.read_sql_query(f"select * from core_insp_to_ref_question where insp_id in {id2_tuple}", con=engine)
core_insp_to_ref_question_df.head()


    

    
Out[95]:







  

    

      

      
created_at
      
updated_at
      
code
      
insp_id
    
  
  

    

      
0
      
2018-08-17 06:38:10.862574
      
2018-09-24 07:15:20.196662
      
ALI.5
      
fade6361-3514-45f9-8ad7-9be84dafb609
    
    

      
1
      
2018-08-17 06:38:10.878194
      
2018-09-24 07:15:20.212292
      
COL.1
      
622179d7-b06b-4493-9b17-9f8d5ff5b7b0
    
    

      
2
      
2018-08-17 06:38:10.893819
      
2018-09-24 07:15:20.212292
      
COL.1
      
4e1e81a2-9f33-4473-83dc-c6b8e4917a93
    
    

      
3
      
2018-08-17 06:38:10.893819
      
2018-09-24 07:15:20.227911
      
COL.1
      
aef097ea-4280-4fc9-a5dc-447d62f31d55
    
    

      
4
      
2018-08-17 06:38:10.909445
      
2018-09-24 07:15:20.227911
      
COL.2
      
6b0d0bd5-ce50-480c-b937-7faab0026b19
    
  

In [99]:

    

core_insp_to_ref_question_dict = [
    {
        "code": row["code"],
        "insp_id": str(row["insp_id"]),
        "created_at": str(row["created_at"]),
        "updated_at": str(row["updated_at"])
    }
    for i, row in core_insp_to_ref_question_df.iterrows()
]
json.dumps(core_insp_to_ref_question_dict)


    

    
Out[99]:





'[{"code": "ALI.5", "insp_id": "fade6361-3514-45f9-8ad7-9be84dafb609", "created_at": "2018-08-17 06:38:10.862574", "updated_at": "2018-09-24 07:15:20.196662"}, {"code": "COL.1", "insp_id": "622179d7-b06b-4493-9b17-9f8d5ff5b7b0", "created_at": "2018-08-17 06:38:10.878194", "updated_at": "2018-09-24 07:15:20.212292"}, {"code": "COL.1", "insp_id": "4e1e81a2-9f33-4473-83dc-c6b8e4917a93", "created_at": "2018-08-17 06:38:10.893819", "updated_at": "2018-09-24 07:15:20.212292"}, {"code": "COL.1", "insp_id": "aef097ea-4280-4fc9-a5dc-447d62f31d55", "created_at": "2018-08-17 06:38:10.893819", "updated_at": "2018-09-24 07:15:20.227911"}, {"code": "COL.2", "insp_id": "6b0d0bd5-ce50-480c-b937-7faab0026b19", "created_at": "2018-08-17 06:38:10.909445", "updated_at": "2018-09-24 07:15:20.227911"}, {"code": "COL.2", "insp_id": "0826f61d-c88d-4842-b6c2-5ed20fd172d1", "created_at": "2018-08-17 06:38:10.909445", "updated_at": "2018-09-24 07:15:20.243538"}, {"code": "COL.2", "insp_id": "aef097ea-4280-4fc9-a5dc-447d62f31d55", "created_at": "2018-08-17 06:38:10.909445", "updated_at": "2018-09-24 07:15:20.243538"}, {"code": "COL.2", "insp_id": "33b35e97-4627-4e79-92bb-64a7842ed118", "created_at": "2018-08-17 06:38:10.925069", "updated_at": "2018-09-24 07:15:20.243538"}, {"code": "COL.3", "insp_id": "6b0d0bd5-ce50-480c-b937-7faab0026b19", "created_at": "2018-08-17 06:38:10.925069", "updated_at": "2018-09-24 07:15:20.259162"}, {"code": "DEV.1", "insp_id": "fade6361-3514-45f9-8ad7-9be84dafb609", "created_at": "2018-08-17 06:38:10.987569", "updated_at": "2018-09-24 07:15:20.321637"}, {"code": "DEV.1", "insp_id": "3a61033b-429c-42ee-aa32-f51d18dfffce", "created_at": "2018-08-17 06:38:10.987569", "updated_at": "2018-09-24 07:15:20.321637"}, {"code": "DEV.1", "insp_id": "065c067a-8127-4290-b9e0-695ef5ebb2b3", "created_at": "2018-08-17 06:38:11.003199", "updated_at": "2018-09-24 07:15:20.337265"}, {"code": "DEV.4", "insp_id": "fade6361-3514-45f9-8ad7-9be84dafb609", "created_at": "2018-08-17 06:38:11.050070", "updated_at": "2018-09-24 07:15:20.384139"}, {"code": "ENA.2", "insp_id": "ba678913-7756-49d6-9351-40680df96bc6", "created_at": "2018-08-17 06:38:11.096944", "updated_at": "2018-09-24 07:15:20.415385"}, {"code": "ENA.3", "insp_id": "aef097ea-4280-4fc9-a5dc-447d62f31d55", "created_at": "2018-08-17 06:38:11.096944", "updated_at": "2018-09-24 07:15:20.431011"}, {"code": "FEE.1", "insp_id": "5bc61e87-87db-4829-bff5-401802755e0a", "created_at": "2018-08-17 06:38:11.175070", "updated_at": "2018-09-24 07:15:20.493517"}, {"code": "FEE.3", "insp_id": "6f94343e-e9e5-4e69-a69d-7613e969214f", "created_at": "2018-08-17 06:38:11.190695", "updated_at": "2018-09-24 07:15:20.509142"}, {"code": "FEE.4", "insp_id": "5bc61e87-87db-4829-bff5-401802755e0a", "created_at": "2018-08-17 06:38:11.221945", "updated_at": "2018-09-24 07:15:20.540393"}, {"code": "INN.2", "insp_id": "931d7762-9fa4-4a3f-85e3-f8bf75f8f903", "created_at": "2018-08-17 06:38:11.253198", "updated_at": "2018-09-24 07:15:20.571646"}, {"code": "LEA.1", "insp_id": "4e1e81a2-9f33-4473-83dc-c6b8e4917a93", "created_at": "2018-08-17 06:38:11.268819", "updated_at": "2018-09-24 07:15:20.587281"}, {"code": "LEA.2", "insp_id": "622179d7-b06b-4493-9b17-9f8d5ff5b7b0", "created_at": "2018-08-17 06:38:11.284444", "updated_at": "2018-08-27 22:33:12.269460"}, {"code": "SER.1", "insp_id": "33b35e97-4627-4e79-92bb-64a7842ed118", "created_at": "2018-08-17 06:38:11.393823", "updated_at": "2018-09-24 07:15:20.712272"}, {"code": "SER.1", "insp_id": "1f60e471-1c2b-4ba9-8130-b4c3a0fb0956", "created_at": "2018-08-17 06:38:11.409448", "updated_at": "2018-09-24 07:15:20.712272"}, {"code": "SOC.1", "insp_id": "5bc61e87-87db-4829-bff5-401802755e0a", "created_at": "2018-08-17 06:38:11.440694", "updated_at": "2018-09-24 07:15:20.743517"}, {"code": "TEA.1", "insp_id": "6b0d0bd5-ce50-480c-b937-7faab0026b19", "created_at": "2018-08-17 06:38:11.471945", "updated_at": "2018-09-24 07:15:20.774769"}, {"code": "TEA.1", "insp_id": "ba678913-7756-49d6-9351-40680df96bc6", "created_at": "2018-08-17 06:38:11.471945", "updated_at": "2018-09-24 07:15:20.774769"}, {"code": "TEA.1", "insp_id": "67e03ed1-02e2-4b2f-89b0-f607c1236212", "created_at": "2018-08-17 06:38:11.503175", "updated_at": "2018-09-24 07:15:20.806025"}, {"code": "TEA.1", "insp_id": "c43f038b-c1cf-4204-a2f1-c1e6aa86f587", "created_at": "2018-08-17 06:38:11.503175", "updated_at": "2018-09-24 07:15:20.806025"}, {"code": "TEA.3", "insp_id": "40b6b2a8-0d03-4212-9969-3751d711a118", "created_at": "2018-08-17 06:38:11.518820", "updated_at": "2018-09-24 07:15:20.821646"}, {"code": "TEA.3", "insp_id": "c43f038b-c1cf-4204-a2f1-c1e6aa86f587", "created_at": "2018-08-17 06:38:11.518820", "updated_at": "2018-09-24 07:15:20.821646"}, {"code": "WLI.1", "insp_id": "c43f038b-c1cf-4204-a2f1-c1e6aa86f587", "created_at": "2018-08-17 06:38:11.534449", "updated_at": "2018-09-24 07:15:20.837277"}, {"code": "WLI.3", "insp_id": "065c067a-8127-4290-b9e0-695ef5ebb2b3", "created_at": "2018-08-17 06:38:11.565664", "updated_at": "2018-09-24 07:15:20.868531"}, {"code": "MGRCOM.5", "insp_id": "6b0d0bd5-ce50-480c-b937-7faab0026b19", "created_at": "2018-08-17 06:38:11.628167", "updated_at": "2018-09-24 07:15:20.915403"}, {"code": "MGRVIS.2", "insp_id": "622179d7-b06b-4493-9b17-9f8d5ff5b7b0", "created_at": "2018-08-17 06:38:11.768788", "updated_at": "2018-09-24 07:15:21.040406"}, {"code": "MGRDEV.1", "insp_id": "1ea5dcec-a94d-42df-8104-1f85f43c22d9", "created_at": "2018-08-17 06:38:11.925038", "updated_at": "2018-09-24 07:15:21.243527"}, {"code": "MGRDEV.2", "insp_id": "fade6361-3514-45f9-8ad7-9be84dafb609", "created_at": "2018-08-17 06:38:11.925038", "updated_at": "2018-09-24 07:15:21.259157"}, {"code": "MGRDEV.4", "insp_id": "fade6361-3514-45f9-8ad7-9be84dafb609", "created_at": "2018-08-17 06:38:11.940663", "updated_at": "2018-09-24 07:15:21.259157"}, {"code": "MGRFAI.3", "insp_id": "1ea5dcec-a94d-42df-8104-1f85f43c22d9", "created_at": "2018-08-17 06:38:11.956291", "updated_at": "2018-09-24 07:15:21.274787"}, {"code": "MGRVIS.1", "insp_id": "622179d7-b06b-4493-9b17-9f8d5ff5b7b0", "created_at": "2018-08-17 06:38:11.971917", "updated_at": "2018-08-27 22:33:12.925637"}, {"code": "FEE.1", "insp_id": "1ea5dcec-a94d-42df-8104-1f85f43c22d9", "created_at": "2018-08-17 06:38:11.175070", "updated_at": "2018-09-24 07:15:20.493517"}, {"code": "DI-DEM-3", "insp_id": "622179d7-b06b-4493-9b17-9f8d5ff5b7b0", "created_at": "2018-09-24 05:56:02.215782", "updated_at": "2018-09-24 07:15:21.134153"}]'

In [101]:

    

action_to_question_df = pd.read_sql_query(f"select * from action_to_question where action_id in {id1_tuple}", con=engine)
action_to_question_df.head()


    

    
Out[101]:







  

    

      

      
created_at
      
updated_at
      
action_id
      
question_id
    
  
  

    

      
0
      
2018-08-17 06:38:24.049668
      
2018-09-24 07:15:30.602841
      
f0b6ca31-7841-498e-a115-5574f5a6086f
      
0f5bda39-8c0e-449a-96d3-6c8f7614fc63
    
    

      
1
      
2018-08-17 06:38:29.565089
      
2018-09-24 07:15:35.696549
      
52627568-895f-49ac-9797-f3aad86e1b6f
      
642f3703-ad5c-45af-8c6d-098802a48065
    
    

      
2
      
2018-08-17 06:38:31.299419
      
2018-09-24 07:15:37.337148
      
a56d35c9-f274-4fd5-a7ac-681ce775529c
      
f0f04a05-3b40-4b47-b222-fc7f034f28e4
    
    

      
3
      
2018-08-17 06:38:31.330669
      
2018-09-24 07:15:37.352764
      
8bf4dd83-7247-416e-9043-94f621d941f6
      
890c2624-9068-4335-b7b5-745d8a293a01
    
    

      
4
      
2018-08-17 06:38:31.393169
      
2018-09-24 07:15:37.399645
      
34dcfc05-c3c4-4650-bb9c-aed2b1c3d5b9
      
95c9179a-3323-48f1-9f5e-3ecd0e3c4fc0
    
  

In [103]:

    

action_to_question_dict = [
    {
        "action_id": str(row["action_id"]),
        "question_id": str(row["question_id"]),
        "created_at": str(row["created_at"]),
        "updated_at": str(row["updated_at"])
    }
    for i, row in action_to_question_df.iterrows()
]
json.dumps(action_to_question_dict)


    

    
Out[103]:





'[{"action_id": "f0b6ca31-7841-498e-a115-5574f5a6086f", "question_id": "0f5bda39-8c0e-449a-96d3-6c8f7614fc63", "created_at": "2018-08-17 06:38:24.049668", "updated_at": "2018-09-24 07:15:30.602841"}, {"action_id": "52627568-895f-49ac-9797-f3aad86e1b6f", "question_id": "642f3703-ad5c-45af-8c6d-098802a48065", "created_at": "2018-08-17 06:38:29.565089", "updated_at": "2018-09-24 07:15:35.696549"}, {"action_id": "a56d35c9-f274-4fd5-a7ac-681ce775529c", "question_id": "f0f04a05-3b40-4b47-b222-fc7f034f28e4", "created_at": "2018-08-17 06:38:31.299419", "updated_at": "2018-09-24 07:15:37.337148"}, {"action_id": "8bf4dd83-7247-416e-9043-94f621d941f6", "question_id": "890c2624-9068-4335-b7b5-745d8a293a01", "created_at": "2018-08-17 06:38:31.330669", "updated_at": "2018-09-24 07:15:37.352764"}, {"action_id": "34dcfc05-c3c4-4650-bb9c-aed2b1c3d5b9", "question_id": "95c9179a-3323-48f1-9f5e-3ecd0e3c4fc0", "created_at": "2018-08-17 06:38:31.393169", "updated_at": "2018-09-24 07:15:37.399645"}, {"action_id": "938e3a8d-521b-4973-b239-475cf6f2cf25", "question_id": "584f047b-236e-4d0f-90e9-2352085ef0cf", "created_at": "2018-08-17 06:38:31.518172", "updated_at": "2018-09-24 07:15:37.524642"}, {"action_id": "5a29fcb3-c2a3-40fe-9f69-e89ee2cfd999", "question_id": "11c909d1-e81d-457a-bd06-85b7351ca48c", "created_at": "2018-08-17 06:38:31.877510", "updated_at": "2018-09-24 07:15:37.837148"}, {"action_id": "7937820b-a176-4e15-b0d9-1d582ac29243", "question_id": "11c909d1-e81d-457a-bd06-85b7351ca48c", "created_at": "2018-08-17 06:38:31.908763", "updated_at": "2018-09-24 07:15:37.868407"}, {"action_id": "fd8882ac-998b-412e-96dc-cb5e6f9872f7", "question_id": "85dca2cf-2967-464e-a3ac-1778fd7cd02c", "created_at": "2018-08-17 06:38:32.018133", "updated_at": "2018-09-24 07:15:37.977777"}, {"action_id": "dfca426b-58c6-4351-a35e-25bed3696df4", "question_id": "63981d1e-7f97-4d8b-9738-92af7129aa72", "created_at": "2018-08-17 06:38:33.221224", "updated_at": "2018-09-24 07:15:39.055928"}, {"action_id": "c2d30785-e08f-4ea4-9084-373a1a0233f6", "question_id": "c122e65d-fcfe-492b-a1c6-b2503de3b7a8", "created_at": "2018-08-17 06:38:33.283720", "updated_at": "2018-09-24 07:15:39.118416"}, {"action_id": "d93ac66c-5f83-4b47-ba1d-ee930a30ee1d", "question_id": "0e9f6c75-57f8-4a01-9277-b983c28e404e", "created_at": "2018-08-17 06:38:33.314970", "updated_at": "2018-09-24 07:15:39.134047"}, {"action_id": "52627568-895f-49ac-9797-f3aad86e1b6f", "question_id": "2c2f82d6-5a13-4835-ba04-36122f71b6d6", "created_at": "2018-08-17 06:38:29.565089", "updated_at": "2018-09-24 07:15:35.696549"}, {"action_id": "46051fb5-0547-4f2a-8c70-33387a27d0db", "question_id": "6b9395ea-5821-1bae-db4d-0863f10000cb", "created_at": "2018-08-17 06:38:33.439970", "updated_at": "2018-09-24 07:15:39.243424"}, {"action_id": "a961148f-df9e-44b7-8a0e-90a40f2a08ad", "question_id": "1dec0eb5-6269-43bf-8d2c-5bfb86630d02", "created_at": "2018-08-17 06:38:25.330887", "updated_at": "2018-09-24 07:15:31.774711"}, {"action_id": "f5d5f749-dce3-4e52-a151-9d6fda0d11f8", "question_id": "d1e24d2f-77de-4fd0-9236-0ed782fbd2d3", "created_at": "2018-08-17 06:38:25.330887", "updated_at": "2018-09-24 07:15:31.774711"}, {"action_id": "4bd4043c-eff1-4d42-b44f-d2e11cc007f7", "question_id": "66396665-f99b-4132-8914-8d3f8d172e2f", "created_at": "2018-08-17 06:38:25.955856", "updated_at": "2018-09-24 07:15:32.368445"}, {"action_id": "8f186a80-7ba4-4c59-95e3-cbeb785fba20", "question_id": "212492ec-a0ac-4f86-a9a8-257c81a25190", "created_at": "2018-08-17 06:38:27.112070", "updated_at": "2018-09-24 07:15:33.415311"}, {"action_id": "af9ac9e5-5fc0-41a2-b006-76277fd82ba4", "question_id": "150a180d-8ed4-4241-8355-632d3455693b", "created_at": "2018-08-17 06:38:28.690126", "updated_at": "2018-09-24 07:15:34.884059"}, {"action_id": "52627568-895f-49ac-9797-f3aad86e1b6f", "question_id": "95d6e52f-b70c-48a1-9aca-1fac5e5e364e", "created_at": "2018-08-17 06:38:29.565089", "updated_at": "2018-09-24 07:15:35.696549"}, {"action_id": "9136fa90-140a-4190-ad77-3e6990d4d699", "question_id": "a25da2c4-8c9b-4b61-8d43-d5b24301c746", "created_at": "2018-08-17 06:38:30.080714", "updated_at": "2018-09-24 07:15:36.180928"}]'

In [107]:

    

id1_tuple = tuple(str(row['id1']) for i, row in matched_df.iterrows())
question_id_tuple = tuple(str(row['question_id']) for i, row in action_to_question_df.iterrows())

question_id_tuple


    

    
Out[107]:





('0f5bda39-8c0e-449a-96d3-6c8f7614fc63',
 '642f3703-ad5c-45af-8c6d-098802a48065',
 'f0f04a05-3b40-4b47-b222-fc7f034f28e4',
 '890c2624-9068-4335-b7b5-745d8a293a01',
 '95c9179a-3323-48f1-9f5e-3ecd0e3c4fc0',
 '584f047b-236e-4d0f-90e9-2352085ef0cf',
 '11c909d1-e81d-457a-bd06-85b7351ca48c',
 '11c909d1-e81d-457a-bd06-85b7351ca48c',
 '85dca2cf-2967-464e-a3ac-1778fd7cd02c',
 '63981d1e-7f97-4d8b-9738-92af7129aa72',
 'c122e65d-fcfe-492b-a1c6-b2503de3b7a8',
 '0e9f6c75-57f8-4a01-9277-b983c28e404e',
 '2c2f82d6-5a13-4835-ba04-36122f71b6d6',
 '6b9395ea-5821-1bae-db4d-0863f10000cb',
 '1dec0eb5-6269-43bf-8d2c-5bfb86630d02',
 'd1e24d2f-77de-4fd0-9236-0ed782fbd2d3',
 '66396665-f99b-4132-8914-8d3f8d172e2f',
 '212492ec-a0ac-4f86-a9a8-257c81a25190',
 '150a180d-8ed4-4241-8355-632d3455693b',
 '95d6e52f-b70c-48a1-9aca-1fac5e5e364e',
 'a25da2c4-8c9b-4b61-8d43-d5b24301c746')

In [106]:

    

question_df = pd.read_sql_query(f"select * from question where id in {question_id_tuple}", con=engine)
question_df.head()


    

    
Out[106]:







  

    

      

      
created_at
      
updated_at
      
id
      
description
      
survey_type
    
  
  

  

In [ ]: