Export File Definitions

Columinity allows a variety of exports (.CSV). This page contains a description of the export format.

The export formats may change over time to accomodate new features, requirements and other improvement. We do our best to keep this page up-to-date. Should you find a discrepancy, please let us know at info@columinity.com

Teams Dashboard: Participation Rates

This export contains the participation rate for snapshots in the date range. The export is accessible on the overview of teams ("Teams"), under "Tools".

Column Name	Column Index	Description
Team	1	Name of the team
Snapshot Start Date	2	Date and time when the snapshot started
Snapshot Closed Date	3	Date and time when the snapshot was closed
Participants (completed)	4	Number of participants who completed the snapshot
TeamMember (completed)	5	Number of team members who completed the snapshot
Stakeholder (completed)	6	Number of stakeholders who completed the snapshot
Supporter (completed)	7	Number of supporters who completed the snapshot

Teams Dashboard: Team Summaries

This export contains the information we show under "Teams" in the Teams Dashboard. The export is accessible on the overview of teams ("Teams"), under "Tools".

Column Name	Column Index	Description
Team	1	Name of the team
Team Type	2	Concatenated list of traits applicable to this team
Team Tags	3	Tags associated with the team (comma-separated)
Snapshot	4	Snapshot number or identifier
Snapshot Date	5	Date when the snapshot was taken
Factor	6	Name of the factor being measured
Factor Type	7	Type of the factor (e.g., Core Factor, Lower-Order Factor)
Normalized Average Score	8	Average score for the factor, normalized to a scale from 1-100 (Confidence intervals returned further separately further down)
Delta (Previous Snapshot)	9	Change in score compared to the team's previous snapshot
Participants	10	Number of participants in the snapshot
Participant Rate (%)	11	Participation rate, if applicable
Actions (Done)	12	Number of completed actions
Actions (Open)	13	Number of open actions
Actions (Impeded)	14	Number of impeded actions
Actions (Canceled)	15	Number of canceled actions
Improvement Goal	16	Goal for improvement, if set
Metadata 1 Key	17	If set, key for the first metadata item
Metadata 1 Value	18	If set, value for the first metadata item
Metadata 2 Key	19	If set, key for the second metadata item
Metadata 2 Value	20	If set, value for the second metadata item
Metadata 3 Key	21	If set, key for the third metadata item
Metadata 3 Value	22	If set, value for the third metadata item
Normalized Average Score (Lower Confidence)	8	15% CI of the normalized average score
Normalized Average Score (Upper Confidence)	8	85% CI of the normalized average score

Notes on this export:

• The metadata properties can be set manually when changing or adding a team or through the API. Columinity does not use these metadata properties, except that it returns them in exports and through the API. They help store some team-related properties useful for your integration (e.g., an internal team ID).

Teams Dashboard & Coaching Center: Factor Scores

This export returns the factor scores for the selected set of teams grouped into the selection sampling periods (e.g. per month, per quarter) and includes a selected benchmark, effectively providing a .csv version of what you see under "Insights" in either the Teams Dashboard or Coaching center. This export is most useful for your analyses in tools like PowerBI.

Column Name	Column Index	Description
Period	1	Sampling period for the data (e.g., Sep 2024-Dec 2024)
Factor	2	The specific factor being measured (e.g., Responsiveness, Continuous Improvement)
Team / Organization	3	Name of the team or organization
Tags	4	Any tags associated with the team or organization
Normalized Average Score (Weighted)	5	The weighted average score for the factor, normalized to a scale of 1-100
Lower Confidence	6	The lower 15% percentile value for the factor's score
Upper Confidence	7	The upper 85% percentile value for the factor's score
Qualification	8	Qualitative assessment of the score (e.g., Neutral)
Benchmark	9	The benchmark score for comparison
Benchmark Lower Confidence	10	The lower 15% percentile value of the benchmark score
Benchmark Upper Confidence	11	The upper 85% percentile value of the benchmark score

Notes on this export:

• In the Teams Dashboard, each factor score has a breakdown of scores into teams.
• In the Coaching Center, each factor score has a breakdown of scores into organizations / teams dashboards.

Teams Dashboard: Actions

This export contains all the actions in a provided daterange. Retrieve it under "Actions", then "Export".

Column Name	Column Index	Description
Team	1	Name of the team
Description	2	Detailed description of the action or task
Created	3	Date and time when the action was created
Due	4	Due date for the action (if applicable)
State	5	Current status of the action (e.g., Open, Completed, Impeded)
State Changed	6	Date and time when the state was last changed
Owner	7	Person or group responsible for the action
Type	8	Type of action (e.g., Workshop, RunExperiment, Conversation)
Url	9	Associated URL or link (if applicable)
Expected Impact On	10	The area or factor expected to be impacted by the action

Notes on this export:

• For performance reasons, the export can contain up to 200 actions. Use the date filter if you have more actions.