Posts

Do you use Qlik to analyse your user satisfaction and assure quality in Customer Service? Do you use Zendesk to manage your customer tickets?

In that case continue reading to know how to smoothly connect Qlik with your Zendesk support tool and create tickets easily from Qlik.

We will use Qlik, LLodi & Zendesk. If you use an integration tool like Zapier or Workato, you can also use it but is not required.

The extension provides the user with an interface to enter data directly from the dashboard, flow from discovery to action in a seamless gesture.

Checking the Zendesk API Documentation we can set up authentication and know the URL and parameters of our action, in this case “create ticket”.

Following the documentation instructions, we will create our LLodi Form with the fields we want to use. We are using only the required fields: subject, priority and body.

Integrate Qlik in your customer service workflows using LLodi, gives you a lot of possible actions, such as:

  • Create and edit tickets
  • Automate responses directly from the analysis
  • Creates a CSAT rating for a solved ticket
  • SLA prioritization
  • Keep sales and support in-sync
  • Integrate your support apps with your development tools
  • Predictive support system and automatically creates support tickets
  • And much more!

Being able to reach the right audience with digital marketing is basic to get customer engagement with your brand online. In marketing, less is more. The fewer messages each user receives, the more powerful it will become. Make each message count and learn how to get the most out of your marketing campaigns by targeting the right audience.

Use Qlik analytics abilities to segment smartly your contacts in Mailchimp. We can get data from different sources in Qlik to improve our knowledge about our contacts and blend data to reach insights that make the difference.

Create a dashboard and explore without limits using Qlik Associative engine, segment your contacts and organize them into a list in MailChimp.

 

We will use Qlik, LLodi & Mailchimp. If you use an integration tool like Zapier or Workato, you can also use it but is not required.

You must have LLodi Writer Extension installed in your Qlik Sense and LLodi Agent enabled in your server. See LLodi Architecture.

The extension provides the user with an interface to enter data directly from the dashboard, selecting the target contacts and choosing the list where they will be included.

LLodi Agent will solve the CORS problem request due to MailChimp does not support client-side implementation of their API using CORS requests due to the potential security risk of exposing account API keys.  LLodi Agent provides a server-side environment to make your requests safer and more powerful.

Checking the MailChimp API Documentation we can set up authentication and know the URL and parameters of our action, in this case “add a new list member”.

 

 

Following the documentation instructions, we will create our LLodi Form with the fields we want to use. We are using only the required fields: list_id, email_address and status. The id of our list is a path parameter, so we can use Dynamic Request fields to create dynamic URL in our forms.

 

 

Integrate Qlik in your marketing workflows using LLodi, gives you a lot of possible actions, such as:

  • Send personalized emails.
  • Create new campaigns.
  • Add contact to automation.
  • Send marketing campaigns from Qlik.
  • And much more!

 

 

These days whether you’re a start-up or a big corporation, every business needs tools to communicate quickly and effectively among its members. Instant Messaging (IM) is flexible: you can maintain chat conversations with different people or you can participate in a group conference session. Your online colleagues can be in the same building or on another continent.

IM tools, like Slack, Microsoft Teams, Flock, Hangouts or Salesforce Chatter, provide organizations more than communication, becoming a collaborative tool with features like file sharing, calls or screen sharing; working as a HUB that helps you to maintain your organization connected so you can get things done.

But if you want to be a Data-Driven organization, you will need the data from the analysis in your favourite IM tool to build a closed loop from data to action and LLodi can help you with this. You can get this data manually or you can enjoy the possibilities of integration and let LLodi work for you.

LLodi can drive your digital transformation by providing a tool that can connect Qlik to REST APIs and get the most of Business Intelligence where you need it.

Because of that, we want to give you the guidelines to work in Slack within Qlik, set notifications and alerts and know how to get the most of the Slack API to build distinctive messages, more useful and effective. All this post will be collect in our blog under the tag “Slack Tips”.

Slack is a cloud-based set of proprietary team collaboration tools and services. The name is an acronym for “Searchable Log of All Conversation and Knowledge”. Slack features include direct-messaging capabilities, document sharing, notifications and alerts, group chat and search.

Connect Qlik with Slack is really easy and we will help you to through the process. You can apply this guidelines to use other similar tools so pay attention although you don’t use Slack.

If you don’t have one yet, create your free LLodi account and join a Slack workspace, make your workflows smarter and save time of your team.

Business changes every day, but there are some answers we need to resolve daily. ¿Do I have some pending Issues? ¿There’s any transaction waiting for my approval?

Streamline your day with Qlik and LLodi, let the information come automatically to your preferred Slack channel, set data alerts and invest your time in what really requires your attention.

In this post, we are going to show you how to achieve that, in an easy and quick way.

Sales Channel in Slack

We are going to use our LLodi Writer Connector that allows you to do actions directly from your Qlik Script anytime the app is reloaded, we can leverage the Qlik logic to make our automatic messages smarter and get the information we need when we need it.

We already show you how to Use Slack as your Qlik Alert Center in a previous video, but today we introduce to you our new feature “Direct Payload”. Enabling Direct Payload sends your Qlik Script as it is, so you can add format, indentations and spaces that won’t be trimmed.

Weekly report Script

We can schedule a weekly report in our sales channel, we get the values directly from our data model and we can even modify our message to the team depending on the results so far. We are going to use only Qlik language therefore you can get the most of Qlik Associative engine and logic capabilities.

Let’s take a look at the Script:

SELECT *

FROM Slack

WITH GUID xxxxx-xxxxx-xxxx

WITH FIELDS ( {

“username”:”LLodi Sales Assistant”,

“icon_url”:”https://pbs.twimg.com/profile_images/836639005387161600/P5WRI7RU_400x400.jpg”,

“channel”:”sales”,

“text”:”Hey Team! Find your Weekly Report. For more info: <www.llodi.com|Sales Dashboard>. $(WeeklyMessage)”,

“attachments”:[

{“fallback”:”Weeklyreport fallback”,

“color”:”good”,

“fields”:[{

“title”:”Global:”,

“value”:”*Outbound Mails:* $(CurrentWeekMail), *Previous:* $(PreMail), *Increment:* $(IncrementMail)%”,

“short”:false},

{“value”:”*New Prospects:* $(CurrentWeekProspects)C, *Previous:* $(PreProspects), *Increment:* $(IncrementProspects)%”,

“short”:false}]

},

{“fallback”:”WeeklyReport fallback”,

“color”:”red”,

“fields”:[{

“title”:”Katy Liss:”,

“value”:”*Outbound Mails:* &(NoMail), *Previous:* $(AggrMail), *Increment:* $(IndividualIncrementMail)%”,

“short”:false},

{“value”:”*New Prospects:* $(NoProspects), *Previous:* $(AggrProspects), *Increment:* $(IndicidualIncrementProspect)%”,

“short”:false}]}]})

WITH CONFIG (directpayload “true”);

You can copy this snippet in your script and begin to use it today as a reporting solution. If you don´t have LLodi yet you can create a Free Account and begin your journey!

We are combining the Direct Payload feature with the formatting options from Slack to add more context to our message, making it more useful and effective. We built the structure of our report and then the connector fills it with updated data directly just before sending it to Slack.

Take your team to the next level and become a Data-Driven company, providing them with the answers they need before they have to ask the question. Automate your reports with Qlik and LLodi Writer connector, working smarter and saving time (and money) in the process.

 

With LLodi Actions for Qlik® now your sales team can create and update records in Salesforce within the context of the analysis of accounts, opportunities, cases, tasks, etc. The clients that use data to boost their business can now access their Salesforce data from their analytical app and update them in real time.

If you don’t have LLodi yet, start today.

Actions that create tasks (cases, leads, campaings) in Salesforce.

With LLodi you can create tasks manually: you introduce the proper data in the form and launch the process. But another magical functionality of LLodi is the automatic creation of tasks, which can be performed as a function of the value of certain indicators or business logic variables, without the need of the user’s interaction:

  • Manual

You start by analyzing your data in Qlik app. Thanks to Qlik’s associative technology, you can perform several analyses as a function of different object selections. LLodi appears as another object in the dashboard, as it behaves just like the other objects and interacts with the selected data.

You can’t lose a second, when you discover a new idea you can create the task associated to it, without having to change in between tabs or copying data manually from one app to the other.

Some examples are:

– Analyze opportunities and assign tasks to go forward with the sales process.
– Detect how some clients have not been followed in the last few months. Create tasks to call them in the following days.
– See how sales previsions are low for the trimester and identify new possible opportunities to launch a qualification process start task.

  • Automate

Like every day, you access your CRM to see tasks and surprise!, there are tasks that were not created by you, but by LLodi’s intelligent system, driven by an analytical app. In this occasion, the tasks have been made to contact certain clients that are at risk of abandonment. But you also have other tasks to start with the client renovation process, for those clients whose contract will expire in the next 60 days.

If this does not feel magical enough, you can also see that the tasks have been notified by Slack, where all the team is talking and sharing their work.

And now, what?

Our objective is to have you working on your critical data just by discovering new ideas on Qlik.

In the next articles we will be talking about how to work with other CRM systems like Hubspot, Pipedrive, InfusionSoft, etc. As well as with other technical support apps, project management apps, or marketing apps.

If you don’t have LLodi yet, start today.

Nowadays, we have highly specialized tools to work with. This has undeniable pros and the power of this tools make our work stronger, but this myriad of solutions may add some delay to our decisions by switching between tabs, software or just by transferring insights from one app to another.

A business application is a collection of components that provides a business functionality that you can use internally, externally, or with other business applications. These business applications are used to increase or measure productivity and to perform other business functions accurately.

Thanks to LLodi we can create a business data-driven application, that allows you to increase the productivity of your team, by combining operational, integration and analytic capabilities in just one window.

As a proof of concept, we will show you our LLodi Pizza application, that we took to the Innovation Showcase at Qlik Qonnections 2018 celebrated in Orlando.

The use case is creating a sales application that allows the user to create an order based on the previous orders then receiving a confirmation email and being mentioned on Twitter.

We decide to use Salesforce as data source and as the CRM where we will create the orders and Workato as integration tool.

This business application will be located in Qlik Sense, using Qlik analytic capabilities to make our decisions, LLodi to turn decisions into actions and the integration power of Workato to run our workflow.

From the Qlik dashboard the user can design his order, taking decisions based on the previous orders stored in Salesforce. These days instinct is not enough, data-driven decision making help you to get advantage from your competitors. Data leads to insights that you can turn into decisions that improve your business.

Once you made your decisions turn it into actions couldn´t be easier with LLodi. Thank to our forms you can define your actions and get the required data directly from your Qlik app, you can also define some data entry fields to complete your insights with the user experience.

Using hidden fields, we can send to Salesforce all the information about the selected toppings and dough in our pizza and relate them to the applicable price book, we can also retrieve all the required personal data to create order, send the email and the Tweet.

There is no need to copy the information to one tab to another or even leave your Qlik dashboard; Directly from Qlik, working smarter and saving time (and money) in the process.

In this case we are using Workato to run our workflow, automating tasks and getting the work done faster.

But that´s not all, after doing your actions the extension can reload your data. “Close the circle” thank to our write-back capabilities and work always with updated data.

As you can see build a business application in Qlik with LLodi is easy, and provides you a boost in productivity and quickness, allowing your team to take advantage of new opportunities and improve the company’s efficiency.

Introduction to LLodi

About This Guide
Welcome to the complete guide to getting started with LLodi. Learn how to integrate LLodi for Qlik Sense and automate workflows with Zapier,“no code required”.

Who Is This Guide For?
Technical and non-technical users, new users to LLodi, and anyone who uses Qlik Sense for the analysis of their data.

Table of Contents

-1- Custom LLodi Forms for Qlik®.

With the LLodi platform, companies can display and connect the analysis of their data, processes and business applications in a single interface, boosting their employees’ productivity and letting them do what they do best. Create a LLodi Free Account.

-2- Create a Zapier Account and your first Zap.

Zapier offers a free trial for 14 days, which allows you to create any process without limits of steps or applications. https://zapier.com/signup. After creating the account, you have access to the platform in order to create your first Zap. In the Explore option, all possible applications that can be used are displayed. If you select Salesforce, you will see some pre-configured zaps and if we keep scrolling down, a box appears with the different actions that this connector allows.A Zap can take several steps. If you create a Zap to be integrated into a LLodi Form, in the first step you will always have to select the “Webhooks by Zapier” app.In the “Choose Trigger” section mark the “Catch Hook” option – Continue
Set up Webhooks by Zapier Hook – Continue
The following screen appears, with the address “webhook url”. When you press OK, Zapier will wait for a test.

The address “Webhook URL” should be copied in the URL field of the Custom Forms that we are going to create. Add the name, the type, in this case Zapier and click on the insert button. 

If you know the fields to create the action, you can click on the gear and enter “Show form Fields” to add and configure the different fields that will later be used in the form and sent to Zapier.

If you do not know the fields, access the Zap in Zapier and select App in the second step, choose Salesforce (Slack, Mailchaimp, Google Shett, etc) and all available actions appear. Tag “Create Task”, click on the continue button (Zapier will ask you to connect your Salesforce account) and later a screen with all fields that you need in Salesforce will appear to create the task.

More help “Creating a Zap” in Zapier.

Cool, now you have all the information to create the form. It’s been quite easy, hasn’t it?

-3- Create a Custom Form and fields.

If you already have a Workflow (Zapier, Workato, Scribe Online or Custom Integration), you can create your own forms to be used with LLodi.

This LLodi App lets you register new workflows just by adding a name and URL (WebHook, endpoint).
You can also see the workflows you have already registered, edit the LLodi Fields and their attributes and delete them.
Once you register a workflow you will be guided to the page to create/edit your LLodi Fields, in the option “Show form fields”

At first the URL field can be empty, until the workflow has been created in the chosen tool. At that time, it will be mandatory to enter the WebHook address or the endpoint.

Input Text (the field number is defined as text)
Input Area
Input Select
Input Select Combo
Input Check
Read Only
Hidden

All Check type fields (Input Check, Multi Check) are default false.

Placeholders
You can edit the Placeholders for every text and area type field.

Labels
You can edit the Labels for every field that is not hidden.

After creating the fields in LLodi, return to the Custom Forms screen and click again on the gear, on this occasion you will have to access the “Test Form” option of the gear to run the test. This process will connect LLodi and Zapier, and in the previous screen, you will be able to join each Salesforce field with a field of LLodi.

It’s time to add the extension on your Qlik platform and configure the new worflow.

-4- Qlik Sense Extension

Download the extension.
Install the extension in your server or your desktop version.
Drag and drop the extension into the dashboard.
Introduce the GUID of the LLodi Map you are going to use.
Fill up the LLodi Fields.
Fill up the monitoring fields.
Custom the style of the LLodi Form.
Check out some Useful Formulas

At the moment you can only use one LLodi Form in each tab. But we are working on it!
You have the possibility to use the same extension for different forms. Ask our support team.
SenseField Feature: With Qlik Sense you can just select one existing field to fill up a selector.

Keep in mind:

The default value for the fields App id, App Name and Current Selections are DocumentName(), DocumentTitle() and GetCurrentSelections(). Make sure you check it before you start working with your LLodi Workflow. You may need to select it and press Enter to force Qlik Sense to evaluate those formulas.
In some cases a Workflow may get you back a selection. In those cases a button “Select” will be displayed besides your Response.

-5- Qlik Connector 

The new connector allows to integrate the insights automatically into workflows of the main tools of data integration directly from your own Qlik® Sense or Qlikview® script.

Instructions
Install the Connector.
Create a new connection using your LLodi credentials.
Complete the script with the following format:
SELECT *
FROM [LLodiFormName]
WITH GUID [GUID]
WITH FIELDS (
[key] “value”,
[key] “value”
);

Start Take Actions on your Data Analysis. Create a LLodi Free Account.

Trello is a team collaboration tool that lets you organize anything and everything to keep your projects on task.

Trello allows you to capture different “cards” and organize them into lists and boards. Use it to plan complex projects, its beauty is in the flexibility. Trello can be adapted to fit your workflow or your team, so you can use anyway you need to.

Now with LLodi for Trello, Qlik users will be able to write a new comment on a specific card, adds one or more members to a specific card, create card, update card, create List, creates a new checklist item in a card, etc.

Design your first Trello Action creating your own Custom Form on LLodi Product and Workflow with a few clicks on Zapier.

Create a LLodi Free Account.

Zapier “Connect Your Apps and Automate Workflows” www.zapier.com

Zapier is one of the leading applications to automate easy-to-use cross-application workflows for both business and IT users. Ideal for developing simple processes (Zaps) with more than 750 applications.

Zapier offers a free trial for 14 days, which allows you to create any process without limits of steps or applications. https://zapier.com/signup

After creating the account, you have access to the platform in order to create your first Zap. In the Explore option, all possible applications that can be used are displayed. If you select Trello, you will see some pre-configured zaps and if we keep scrolling down, a box appears with the different actions that this connector allows.

 

A Zap can take several steps. If you create a Zap to be integrated into a LLodi form, in the first step you will always have to select the “Webhooks by Zapier” app.

In the “Choose Trigger” section mark the “Catch Hook” option – Continue
Set up Webhooks by Zapier Hook – Continue
The following screen appears, with the address “webhook url”. When you press OK, Zapier will wait for a test.

The address “Webhook URL” should be copied in the URL field of the Custom Forms that we are going to create. Add the name, the type, in this case Zapier and click on the insert button

If you know the fields to create the action, you can click on the gear and enter “Show form Fields” to add and configure the different fields that will later be used in the form and sent to Zapier.

 

If you do not know the fields, access the Zap in Zapier and select App in the second step, choose Trello and all available actions appear. Tag “Create Card”, click on the continue button (Zapier will ask you to connect your Trello account) and later a screen with all fields that you need in Trello will appear to create the card.

Cool, now you have all the information to create the form. It’s been quite easy, hasn’t it?

After creating the fields in LLodi, return to the Custom Forms screen and click again on the gear, on this occasion you will have to access the “Test Form” option of the gear to run the test. This process will connect LLodi and Zapier, and in the previous screen, you will be able to join each Trello field with a field of LLodi.

More help “Creating a Zap” in Zapier.

it’s time to add the extension on your Qlik platform and configure the new worflow.

Qlik Sense Gmail: LLodi gives you the power to integrate Gmail with your Qlik Insights.

Let’s say that you are analyzing the clients you haven’t seen in the last three months and you wished to send an email in order to request a follow-up meeting or you are analyzing the clients that have not asked for support in the last week regarding a certain aspect and you wished to invite them to a training session.

Design your first Gmail Action creating your own Custom Form on LLodi Product and Workflow with a few clicks on Zapier.

Create a LLodi Free Account.

Zapier “Connect Your Apps and Automate Workflows” www.zapier.com

Zapier is one of the leading applications to automate easy-to-use cross-application workflows for both business and IT users. Ideal for developing simple processes (Zaps) with more than 750 applications.

Zapier offers a free trial for 14 days, which allows you to create any process without limits of steps or applications. https://zapier.com/signup

After creating the account, you have access to the platform in order to create your first Zap. In the Explore option, all possible applications that can be used are displayed. If you select Gmail, you will see some pre-configured zaps and if we keep scrolling down, a box appears with the different actions that this connector allows.

 

A Zap can take several steps. If you create a Zap to be integrated into a LLodi form, in the first step you will always have to select the “Webhooks by Zapier” app.

In the “Choose Trigger” section mark the “Catch Hook” option – Continue
Set up Webhooks by Zapier Hook – Continue
The following screen appears, with the address “webhook url”. When you press OK, Zapier will wait for a test.

The address “Webhook URL” should be copied in the URL field of the Custom Forms that we are going to create. Add the name, the type, in this case Zapier and click on the insert button

If you know the fields to create the action, you can click on the gear and enter “Show form Fields” to add and configure the different fields that will later be used in the form and sent to Zapier.

If you do not know the fields, access the Zap in Zapier and select App in the second step, choose Gmail and all available actions appear. Tag “Send Email”, click on the continue button (Zapier will ask you to connect your Gmail account) and later a screen with all fields that you need in Gmail will appear to create the mail.

Cool, now you have all the information to create the form. It’s been quite easy, hasn’t it?

After creating the fields in LLodi, return to the Custom Forms screen and click again on the gear, on this occasion you will have to access the “Test Form” option of the gear to run the test. This process will connect LLodi and Zapier, and in the previous screen, you will be able to join each Gmail field with a field of LLodi.

More help “Creating a Zap” in Zapier.

it’s time to add the extension on your Qlik platform and configure the new worflow.

Qlik Sense Salesforce: The Salesforce® Widget for Qlik® allow add opportunities, leads, contacts, and cases from your Analytic App. Supercharge productivity by creating an app that combine analytics and actions.

Design your first Salesforce Action creating your own Custom Form on LLodi Product and Workflow with a few clicks on Zapier.

Create a LLodi Free Account.

Zapier “Connect Your Apps and Automate Workflows” www.zapier.com

Zapier is one of the leading applications to automate easy-to-use cross-application workflows for both business and IT users. Ideal for developing simple processes (Zaps) with more than 750 applications.

Zapier offers a free trial for 14 days, which allows you to create any process without limits of steps or applications. https://zapier.com/signup

After creating the account, you have access to the platform in order to create your first Zap. In the Explore option, all possible applications that can be used are displayed. If you select Salesforce, you will see some pre-configured zaps and if we keep scrolling down, a box appears with the different actions that this connector allows.

A Zap can take several steps. If you create a Zap to be integrated into a LLodi form, in the first step you will always have to select the “Webhooks by Zapier” app.

In the “Choose Trigger” section mark the “Catch Hook” option – Continue
Set up Webhooks by Zapier Hook – Continue
The following screen appears, with the address “webhook url”. When you press OK, Zapier will wait for a test.

The address “Webhook URL” should be copied in the URL field of the Custom Forms that we are going to create. Add the name, the type, in this case Zapier and click on the insert button

If you know the fields to create the action, you can click on the gear and enter “Show form Fields” to add and configure the different fields that will later be used in the form and sent to Zapier.

If you do not know the fields, access the Zap in Zapier and select App in the second step, choose Salesforce and all available actions appear. Tag “Create Task”, click on the continue button (Zapier will ask you to connect your Salesforce account) and later a screen with all fields that you need in Salesforce will appear to create the task.

Cool, now you have all the information to create the form. It’s been quite easy, hasn’t it?

After creating the fields in LLodi, return to the Custom Forms screen and click again on the gear, on this occasion you will have to access the “Test Form” option of the gear to run the test. This process will connect LLodi and Zapier, and in the previous screen, you will be able to join each Salesforce field with a field of LLodi.

More help “Creating a Zap” in Zapier.

it’s time to add the extension on your Qlik platform and configure the new worflow.