Scrutinizing the results of a campaign with NQL

After you publish a campaign, targeted employees start answering the campaign questions. Create Nexthink Query Language (NQL) investigations to see how employees interacted with the campaign and answered questions.

The results of campaigns triggered by remote actions are only available locally during the execution of a remote action screen. Consequently, remote action campaigns have no response data available on the Campaign details page.

Viewing the results of a campaign in Investigations

Select Campaigns from the main menu.
Select a campaign listed in the navigation panel to view more details. The navigation panel shows published and retired campaigns.
Select Campaign overview from the navigation panel to view all published and retired campaigns and their statistics.

On the Campaigns details page, click on the action menu at the top right corner of the page and select Investigate to open the Investigations page with a prewritten query to generate results for campaign responses, including:

User information.
Response state and state details.
Answers to each question and free-text comments where applicable.
Values of the parameters in case the campaign is parametric.

On the Investigations page, you can refine the NQL query to adjust the columns or filter the results according to your requirements.

Querying campaign information and results with NQL

Using NQL, you can access key information regarding your campaign and their responses querying the following tables:

campaign.campaigns contains the basic information about all campaigns with a published or retired state.
campaign.responses contains details of every campaign response, given or expected. Use it when you need to gather statistics across campaigns but do not need to inspect campaign-specific data, such as answers to questions or parameter values.
For each campaign (after the campaign is published), a dynamic table campaign.nql_id_of_the_campaign.responses is available to inspect the responses of that particular campaign, for example, campaign.#my_campaign.responses or campaign.dex_score_campaign.responses. In addition to the fields available in the table campaign.responses, the dynamic data model table of a campaign includes fields with answers to each question and, if the campaign is parametric, values of each parameter.

Inspecting answers and parameters using the dynamic data model

The dynamic data model provides fields per question to gather details about the employees' answers. The question identifier NQL uses corresponds to the question ID defined in the campaign. When using Campaigns (Classic), the question identifiers are based on the question order, for example, #1 and #2.

The available fields correspond to the type of question:

For single-answer questions, you can get the answer label the employee selected using answers.question_id.label.
For multiple-answer questions, you can get the list of the answer labels selected by the employee using answers.question_id.labels.
For opinion scale questions, you can get the answer label the employee selected using answers.question_id.label and its associated value with answers.question_id.value. The value is the name of the answer selected, followed by the numerical value attributed to the answer between parentheses.
For NPS questions, you can get the details of the selected choice in different ways using answers.question_id.value (numeric values from 0 to 10), answers.question_id.category (either promoter, passive, or detractor) and answers.question_id.label (ranging from detractor with 0 to promoter with 10).

In addition, for all question types, you can access the optional free text comment using answers.question_id.comment and know the question type using answers.question_id.type.

For parametric campaigns, you can access the value of the parameters specified at the time of triggering the campaign, using parameters.parameter_id.

Response state

The state of a response informs about the delivery status of the campaign, the employee interactions with it, and the employee answers to the campaign question. The field state and state_details in the responses tables reflect the current state of a response. The historized state information is available using the historical_state, historical_state_details and historical_time fields.

Find below the details of the different states for a response.