Export Search Analytics Data to Tableau

You can export the data in Search Analytics to Tableau for powerful visualization. Data transfers happen through a Web Data Connector which converts Search Analytics data into JSON before pushing it into Tableau.

Exporting Data from Search Analytics to Tableau

  1. Download Tableau Desktop for Windows.
  2. Create an app named "tableau_connector" in SearchUnify. While creating the app, enter https://{{base URL}}/analytics/tableauConnector/authTableau in Redirect URL and select Analytics in Scope. RelatedHow to Create an App in SearchUnify?
  3. Open Web Data Connector from the To a Server menu.

  4. In the Enter your web data connector URL here field, paste https://{{base URL}}/analytics/tableauConnector/authTableau.

  5. You will be prompted to sign in. Click Login With SU.

  6. After entering your SearchUnify login ID and password, click Submit.

  7. tableauConnector will ask for a permission to access your data in SearchUnify. Click Allow.

  8. Select a search client, date range, and click Get Data.

  9. Drag the fields in the left column to the white area (highlighted) on the top and click Automatically Update.

  10. Click Sheet next to the data source and wait for the Extract process to finish.

Now you can drag and drop fields in Tableau rows and columns to build graphs.

Last updatedFriday, September 4, 2020