Slack is where the people you need, the information you share, and the tools you use come together to get things done. With Knowi's Slack integration, its powerful Search-based analytics (or Natural Language Processing) capabilities combine with Slack's intuitive messaging UI, allowing you to ask questions from your Knowi data directly from the Slack app and get answers instantly. This allows you to obtain quick insights from your data, optimize by integrating it into your workflows, and enhance collaboration within your team.
Installing the Knowi bot
Step 1: Add the Knowi bot to your workspace by clicking the link below.
Step 2: After clicking the link, you will be guided through the authentication flow to connect your Knowi and Slack accounts.
The previous authentication flow grants the Knowi app access to your Slack workspace. The following authentication flow will grant your Slack workspace access to your Knowi account.
Step 3: Back in your workspace, enter the command /knowi. You will then be prompted to connect to your Knowi account. Click the link and enter your Knowi credentials.
Step 4: On the following screen, click Allow to grant your workspace permission to access Knowi, then click Get Started on the next screen.
Step 5: Once redirected back to your Slack workspace, enter the command /knowi again. Now that your Slack workspace has been connected to your Knowi account, you will receive a response with Dashboards, Widgets, and Queries options to query and explore.
This confirms a successful connection to your Knowi account, and you are now ready to start asking questions from your Knowi data via Slack.
Enable/Disable Slack Integration
Knowi's NLP Slack Integration is enabled for each account by default. Admin users can enable/disable the feature by navigating to Settings > User Settings > NLP Slack Integration in your Knowi app.
Hands-on With Knowi’s Search-based Analytics
Fundamentally, Knowi’s search-based analytics (NLP) capabilities with Slack integration function are similar to how they work when using NLP within the Knowi UI. It allows you to ask questions in plain English from your data and queries across all datasets within your account.
Once you type in a question, Knowi will detect and query the dataset that best matches the question and return the most appropriate visualization for the returned data.
In the following examples, we’ll use Knowi’s Search-based analytics via Slack to ask questions and retrieve data about an email marketing campaign.
Example 1:
We want to know the total number of emails delivered to each customer. So, in Slack, we’ll type:
/knowi total emails delivered by customer
Knowi will briefly process your question and then return an answer in the form of a visualization. And other options to download, share, and schedule the response.
Notice that the response returned is a pie chart, so you can quickly visualize the proportion of emails delivered to each customer. Use the magnifying glass to zoom in on the visualization.
Download Data
Users can download the query results as a CSV by clicking Download Data. The data in our example looks like:
Explore/Validate
You’ll also notice the Explore/Validate button below the results. Clicking on this will take you to another screen showing the results' visualization settings. This interface will look familiar to what you see working within the Knowi UI.
You can do further analysis by clicking the Data tab to see how the results were initially aggregated and make any necessary changes. You can also change the type of visualization to display the results. Finally, you can use the NLP text bar to edit your question or ask a new question.
Note: In the NLP text bar, hit the space bar following your question to see the dataset name displayed to the right.
Favorite
Users can tag a query as a favorite for easy access. To favorite a query, click Favorite, choose a category, create a new category, and click Save.
Share
Users can share a query on Slack. To share, click Share, choose a contact you want to share the query with along with a message, and click Share.
Schedule
Users can schedule a query to post results to contacts/conversations based on the chosen frequency. To schedule a query, click Schedule. In the settings, edit the query string if required, and choose a conversation to which you want to send the results. Add a message and set the time and frequency to schedule the query to run and post results. Click Schedule.
Example 2:
Let’s ask another question from our data. This time, to find out the average converted emails by campaign name every week. Back in Slack, type:
/knowi avg conversions by campaign name weekly
The results return an Area Chart visualization, with each line area representing the different email campaigns and their average conversions over the past several weeks. The analysis further shows that the “30% off Limited Sale” email campaign had the most conversions per email in the most recent week.
Example 3 - Select a Dataset:
Knowi’s Search-based analytics (NLP) also allows you to ask questions from a specific dataset in your connected account by specifying a flag (-d) at the end of your query to return a matching dataset suggestion. You can then select the dataset from the list of suggestions to execute your query. Note that the first dataset listed is the default it will use unless you choose another one.
Format:
/knowi <query/question> -d <dataset name>
Example:
/knowi total tickets this week -d zendesk
Example 4 - "All Details" Command:
A handy query for getting detailed results for a particular entity (i.e. customer, sales associate, email address, etc.) in your dataset is to include "all details for..." in your question. This will return all fields in the dataset for the given entity.
Format:
/knowi <"all details for.."> <entity> -d <dataset name>
Example:
/knowi all details for Wells Fargo -d sending activity
You can also add conditions (i.e., rolling date ranges) to the "all details for..." command to refine your results. Below are some examples:
/knowi all details for Wells Fargo since yesterday -d sending activity
/knowi all details since last 4 months for campaign like Newsletter -d sending activity
/knowi all details for Wells Fargo where message type is Marketing -d sending activity
Natural Language Processing Settings
Knowi’s search-based analytics can be figured out by navigating to Settings > User Settings > Natural Language Processing Settings. You can toggle the settings below to disable/enable. By default, they are enabled.
NLP Across Datasets
Enabled/ON enables a natural language interface across datasets, and the NLP text bar appears at the top of dashboards. When Disabled/OFF, the NLP text bar will disappear from the top of the dashboards. Note that you can still use the NLP interface within individual widgets on the Analyze screen.
Index By Default
By default, all datasets will be automatically indexed. Turning this off will automatically exclude NEW datasets from being indexed. Datasets can be individually indexed from the Data Management section of the query listing Queries > Data Management > NLP. If you want to turn off historical datasets for indexing as a one-time operation, use the option in the pop-up.
NLP Slack Integration
When Enabled/ON, it enables a natural language interface from Slack.
Data Management for Natural Language Processing
To configure NLP settings at the dataset level, navigate to Queries > Data Management > NLP. It can also be accessed at the widget level via More Settings > Data Diagram > Edit Dataset (click on the pencil icon in the blue box representing the dataset).
NLP Indexer
Defaults to ON. Turning it off will exclude the dataset from Search-based Analytics/NLP queries. Note that it may take a few minutes for the change to take effect.
Synonyms
Synonyms are useful for adding context awareness to your Search-based Analytics/NLP queries. For example, if you have a field in your dataset named customer, you can add a synonym “tag” to this field, such as “shopper”, “buyer”, “client”, etc. So, when you type in a question like “total sent by the client”, it will recognize the term “client” as equivalent to the field “customer”. Multiple synonyms can be added for each field.