How can I Enter Themes into Cascade?

The Theme Table is the central store in Cascade for the people and their CliftonStrengths themes. After you enter themes in the Theme Table, you can create the reports within Cascade.

There are several ways to enter client themes into Cascade where the easiest is to import them from an export file from one of Gallup’s portals. The Import feature in Cascade’s Theme Table can insert the theme information from a range of export files.

The theme names must be entered into Cascade in English. Although Cascade supports other languages, it uses the English theme names behind the scenes to create the reports.

Head to the relevant section for the portal you use to administer the CliftonStrengths assessment codes.

Gallup Access

In Gallup Access (their main portal) you can export the themes of the people in the Community area. For more information see How can I import themes from Gallup Access?

Clifton Strengths for Students

Use the export file from the Gallup portal to import into Cascade. The import process recognises the slightly different layout of the csv file so the columns end up in the right place.

Gallup Corporate Portal

The export file from My Gallup is again slightly different in layout. However, Cascade’s import process recognises this to populate the Theme Table with the staff names and themes.

Gallup Strengths Center

The Gallup Strengths Center is now replaced by Gallup Access.

Assessment Codes in Gallup Books

The assessment codes in the various Gallup books are not linked to a specific portal. It is therefore not possible to export their results directly in an Excel format.

One option is to have each person share their results with you in the Gallup Access portal. You will see their result in your Community tab in Access, which you can then export into a spreadsheet.

Manually Enter Client Themes

As a last resort or if there are just a few themes to enter, use the drop-down lists to select the themes you need. When typing a theme name, please note that the spelling must be exact. For example, the theme of Self-Assurance must include the hyphen and no spaces should exist at the end of the theme names.

Other Formats?

We are pretty adept in manipulating data to obtain a usable format for Cascade. Please contact us with the information you have available so we can let you know what is possible.