Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 24 Next »

Steps to export data from Zendesk to Tableau

Before you start

To be able to import data from Zendesk into Tableau, your Zendesk administrator should grant you permission to access Tableau Connector for Zendesk application.

If you don't have this access, please contact your Zendesk Administrator to grant Tableau Connector for Zendesk permissions first. Zendesk Administrators can always access application configurations.

Create a data source in Zendesk

3.Create DS.mkv

Step 1. Launch Tableau Connector for Zendesk application, by clicking on it’s icon in Navigation menu. Then choose Connectors.

Step 2. On the opened page, select Create a Data Source

Below you can find a description of the fields, buttons, and settings of data source creation page:

Title section

1. Name - Enter data source name.

2. Description - Enter data source description.

3. Share settings - You may share this data source with users or groups of users who have permission to use the application.

  • Select users - start typing to find and add relevant users.

  • Select groups - start typing to find and add relevant users group.

  • Submit - click to confirm changes.

  • Cancel - click to cancel changes.

Please note! Other users who have access to Tableau Connector for Zendesk app might not get all data from this data source due to different Zendesk permissions.

Export Zendesk Support data

Filter tickets section

1. All - choose if you want to export all existing tickets.

2. Select by query - choose if you want to use search query to create your own request and filter data.

3. Query - Zendesk search query.

Zendesk provides us with a set of keywords and common search operators, to narrow search results. More details on the syntax can be found here.

4. Filter - allows to modify our search query, using set of pre-defined filters:

  • Status - include only tickets, which are in one of the statuses, selected here.

  • Type - include only tickets of types selected.

  • Tag - include only tickets, which have tags specified. Start typing tag name to get autocompletion working.

  • Assignee - include only tickets, assigned to any of users specified. Start typing user name or email to get autocompletion working.

  • Updated date - limit resulting tickets to specific date ranges.

  • Show search tip - opens Zendesk guide to search query syntax.

Select Fields section

1. Search field - enter the required field that you want to display in the report. Only fields, matching the search, will be shown.

2. Clear the search field.

3. Entity - represents one of the entities, available for export. Checkbox will toggle all/none fields in the subsection. Subsections can be expanded at will, by clicking on them

4. Field - represents specific field, available for export. Toggle checkbox, to include/exclude it from the export.

At the moment, the output of the following Zendesk Support tables is being logged:

Zendesk Support

  • Tickets 

  • Tickets Via

  • TicketMetrics

  • TicketAudits

  • TicketsAudits Via

  • TicketAuditEvents Via

  • Comments

  • Comments Via

  • SatisfactionRating

  • SharingAgreement

  • Users

  • Groups

  • Organizations

View Options section

1. Click View options to modify what field parameters will be shown

2. Click Show IDs to see the field names how they will appear in Tableau. Click again to hide IDs.

3. Click Show Types to see the field types. Click again to hide Types.

“Apply” section

1. Save - click to save a data source.

2. Preview ERD - click to open the ERD schema preview popup.

3. Close - leave data source creating page. Changes you’ve made will not be saved.

Import data into Tableau.

To work with Tableau, Tableau Connector for Zendesk generates the OData Feed URL. Use this URL to import data to your Tableau application.

Step 1. Copy the URL of your connector, generated by the app.

Step 2. Launch Tableau and Click on Connect > Get Data > OData and paste the URL.

Step 3. Fill the form:

  • Server: past your copied feed URL.

  • Authentication: Select Username and Password

  • Username: your email address

  • Password: API token. For how to obtain API token - read How to obtain Zendesk API Access Token? section.

Finish authorization by pressing Sign In. Now wait for query to finish.

After step 3 data will be loaded into Tableau.

If there is a big amount of data to be imported, it can take some time.

After this, you can start building graphs and sheets based on the imported Zendesk data. To do this, switch to Sheet 1 and choose the visualization type and select the data you want to see on the graph.

How to export Zendesk SELL data

Note! In order to use our application for Zendesk SELL data, you must install it on your Zendesk Support account.

Follow this step-by-step instruction to export Zendesk Sell data you need to Tableau.

Additional features

(1) Click the Copy icon to copy the connector URL to the clipboard.

(2) Click the Preview ERD icon to get to the Entity Relationship Diagram for a data source.

(3) Click on the More on the actions panel to select such additional Actions as:

(4) To make changes to the Connector, select Edit item.

(5) To remove Connector, press Delete option.

(6) To distribute the Data Source to users who have permissions to use this plugin, select the Share option. The users can find this data source in the Shared with me tab.

(7) To make a copy of the data source, choose Clone option. You will become an owner of the cloned datata source.

(8) To transfer the ownership of the data source, click Change owner option.

Only (1) Copy, (2) Preview ERD and (3) Clone are available for data sources in Shared tab.

  • No labels