Import analytics data

To get started, simply download the Tableau desktop application http://www.tableau.com/products/desktop/download and install it onto your computer.

Once the application has been installed and opened, you can begin importing your data.

 

The application lets you import from different sources of data: flat files, web data or even SQL server data.

Import AT Internet data

To import your AT Internet data into Tableau Software, please use the web data connector feature available in the drop-down menu (More servers > Web data connector).

You’ll get access to the Web Data Connector interface where you’ll need to enter the following URL in order to connect to your AT Internet interface and import your data:

Paste this URL into the navigation bar (shown in pink in the screenshot below):

https://apps.atinternet-solutions.com/tableau

Enter your AT Internet credentials: login and password

Choose which data to import

After entering your login and password, a new window will open.

1: You’ll have two choices: Either select a standard template, or a custom template.

Standard templates: Connect multi-site data with standard dimensions and metrics (like those in the API)

Custom templates: Connect your own Data Query templates with custom metrics or segments, for each of your sites (please note: multiple sites are not possible in this second option, as in the AT Internet API).

2: Enter the name you wish to give to the AT Internet data source which will appear in Tableau Software.

3: Select the site name whose data you want to import. It’s also possible to enter a level 2 site.

 4: Enter the desired period. Entering a period is not required. By default, without any period selected, we’ll show you data from the previous day in Tableau.

5: Prior to this crucial last step, it’s necessary to select the template to import.

Please note, you may only import one template at a time. Please repeat the operation as many times as necessary.

6: Click on Test to know the number of rows contained in your request.

If the number of rows exceeds 500,000, we’ll start by importing only the first 500,000 rows. This means that the data imported into Tableau won’t be exhaustive.

In the above case, as the request contains 833 rows, all data will be imported upon clicking Import data.

Find imported data in Tableau

Once you’re connected to the data source, dimension and measure fields are displayed in the Data window on the left-hand side of your workbook.

 

1: Find the name given to your setup in the previous steps (see #2 above).

In the left-hand menu, you can also identify all other data sources that have been loaded (ex: CRM).

2: Find imported metrics in the format "M Metric name".

3: Find imported dimensions in the format "D Dimension name".

4: Create your views in different tabs of your workbook (ex: Visits by country).

To create a view, simply drag fields from the Data window, and drop them onto shelves. To learn more about using Tableau, please see the various trainings offered by Tableau Software: Visit http://www.tableau.com/learn/training

5: Summarise all views in a dashboard (ex: Dashboard 1).

Once you’ve created a view, you can integrate it into a history. The Story Points feature in Tableau lets you present links between occurrences, add context, and show how decisions influence results.  

To learn more about using Tableau, please see the various trainings offered by Tableau Software: Visit http://www.tableau.com/learn/training

Have more questions? Submit a request