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
orcampaign.dex_score_campaign.responses
. In addition to the fields available in the tablecampaign.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 withanswers.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) andanswers.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.
RELATED TOPICS
Last updated