Segmentation and custom question

Work with segmentation and custom question data

The next step in crepe is to generate data that is specific to each funder. This includes segmentation and custom question data. First off, if you can’t find your client’s name in the *pr/clients folder, make a copy of *pr/cloneme and save it under *pr/clients. For example, if I plan to generate funder-specific data for Commonwealth 14X, I will copy cloneme to *pr/clients folder and rename it as Commonwealth 14X.

At crepe interface, type option 4 to enter the fundue interface:

Fundue Interface

LA FONDUE DE LA CREPE
=======================================
"Do fun things with funder data since 2013"

You are currently set to work with the following environment:
     - product: spr
Please select your options:
     1. Refresh CQ + subgroup data for a funder in /clients
         (Use this option when you had an update to CQ data or subgroup labels in SQL)

     2. Refresh aggregate data for a funder in /clients
         (Use this option when you had an update to output_XL in SQL)
         (NOTE: Doing this will destroy any trend CQ data you added manually to funder data in /agg!)

     3. Refresh data with CQ + subgroup for ALL funders in /clients
         (Use this option when you want to RESET all CQ & subgroup data for all funders in /clients!!!)

     4. Refresh aggregate data for ALL funders in /clients
         (Use this option when you want to RESET all aggregate data for all funders in /clients)

     5. Return to main LA CREPE interface


Enter your options here:

To generate funder-specific data, use option 1.

Found the following clients in the /clients folder
Use the number assigned to the left of the funder name to proceed

[0]: Commonwealth 14X
[1]: Ford 14X

Enter the number for the funder here:

Enter the number of the funder that you want to generate data for. For example, if I want to run data for Commonwealth 14X, I will enter 1. This will generate the following data files in your client folder:

• fdn_xl.csv: This file contains all responses for a given client. This may also include historical data, i.e., respondent data for client from previous rounds that it has participated in. For example, if Commonwealth participated in 12X and 10X, their 12X and 10X data will also be available here. This file will also contain all custom question and segmentation data, combined from seg/segdata.csv and custom/custom.csv.
• custom/cqmean.csv: Using the respondent data file fdn_xl.csv and the list of CQ likert variables in <client>/var/likert.csv, crepe will generate all funder-level Likert ratings in this file.
• custom/cqprop.csv: Using the respondent data file fdn_xl.csv and the variable dictionaries from bar.csv and stack.csv in <client>/var, crepe will generate all funder-level categorical proportions, used for bar charts, stacked bar charts, and toggle tables, in this file.
• custom/cqcount.csv: Using all CQ variable dictionaries in <client>/var and the respondent data file fdn_xl.csv, crepe will generate counts of responses by funder by question. This file is used to filter out funder CQ data that has fewer than five responses.
• seg/segmean.csv: Using the respondent data file fdn_xl.csv and the list of combined likert variables in *pr/core/var/likert.csv and <client>/var/likert.csv, crepe will generate all segmentation-level Likert ratings in this file.
• seg/segprop.csv: Using the respondent data file fdn_xl.csv and the combined variable dictionaries from bar.csv and stack.csv in *pr/core/var and <client>/var, crepe will generate all segmentation-level categorical proportions, used for bar charts, stacked bar charts, and toggle tables, in this file.
• seg/segcount.csv: Using all variable dictionaries in *pr/core/var and <client>/var, and the respondent data file fdn_xl.csv, crepe will generate counts of responses by segmentation by question. This file is used to filter out segmentation data that has fewer than five responses.

This step is colloquially known as 4-1.