What can I learn from this page? | How to populate our template for an external historical comparison data import request |
Who is this guide for? | Account Admins, Survey Admins, Survey Creators |
Culture Amp can work with Engagement enabled customers (specifically Account or Survey Administrators) to arrange for historical survey data to be loaded in as a comparison to your Culture Amp surveys.
Culture Amp Product Support will need to provide you with an excel template for you to populate, which is exported directly from the relevant survey on your Culture Amp account (i.e the one you'd like the comparison loaded into).
NOTE: If your survey is still in draft, your survey design (Questions & Factors) will need to be completed first.
Please note that....
Comparisons can only be loaded against Rating questions and Factors on your Culture Amp survey
Company Overall only or Company Overall & Demographic level comparisons can be loaded as part of this process (Note that when Demographic level comparisons are loaded, we need to load in at least 1 company overall score; even if it's loaded against a new dummy question (not assigned to a section or a factor) or a new dummy factor (without any questions assigned)).
1 file per historical survey is required
Comparisons are loaded to a specific survey only; if you require the comparison again in the future, the task will need to be repeated on the future survey
These types of comparisons are not compatible with Leader Based Reports
These types of comparisons are not compatible with the Powerpoint export for demographic reports
File Preparation
Company Overall only
type - this should be either question or factor (lowercase), depending on if you're adding the comparison to a question or the factor
demographic - leave blank for company overall comparisons - column still needs to be present in the file
demographic_question_code - leave blank for company overall comparisons - column still needs to be present in the file
score - the historical comparison score expressed as a decimal (NOT a percentage score) rounded to two decimal places, eg 93% score would read as 0.93 in the file, 100% would read 1 in the file.
entity_code - the code of the question or the factor you are adding the comparison to. This should already be populated upon template download
reference_text - reference for identifying the question or factor. This should already be populated upon template download
Example screenshot of a populated file (using just 2 Factors and 9 questions for the example):
NOTE: Please delete the rows for any Factors or Questions where you are not providing comparison scores.
Company Overall & Demographic level
In addition to populating the factor and question set with the company overall comparison scores, you'll need to duplicate the entire factor and question set of rows for each demographic value you'd like to add comparison scores for within the same file:
type - this should be either question or factor (lowercase), depending on if you're adding the comparison to a question or the factor
demographic - the demographic value (group). Example, Department = Customer Success; Customer Success will need to be entered into the 'demographic' column
demographic_question_code - the title of the demographic. Example, Department = Customer Success; Department will need to be entered into the 'demographic_question_code' column. (Note that we'll convert the data in this column to the back end code for the specific demographic for import purposes)
score - the historical comparison score expressed as a decimal (NOT a percentage score) rounded to two decimal places, eg 93% score would read as 0.93 in the file, 100% would read 1 in the file.
entity_code - the code of the question or the factor you are adding the comparison to. This should already be populated upon template download
reference_text - reference for identifying the question or factor. This should already be populated upon template download
Example screenshot of a populated file (using just 2 Factors and 9 questions for the example):
NOTE: Please delete the rows for any Factors or Questions where you are not providing comparison scores.
Need further guidance / support? Contact our Product Support Team and we'll be happy help!