How to use the Cognetik Cloud Connector (from accessing the Connector to building a dashboard in Tableau using your freshly-added data)

Accessing the connector, creating an account, linking your credentials. Building and submitting a query, and building a dashboard in Tableau

1. Accessing the Connector

To access the connector, open Tableau desktop.

On the left-hand side under Connect to a Server, click 'Web Data Connector.'

In the URL box, type and hit Enter.




2. Creating a Cognetik Account

Click the 'Sign Up' button



Fill in the fields, check the marketing consent box and click 'Create my account.' Your account is created on the spot.



3. Linking Your Accounts

In order to bring in data from your cloud source platforms, you need to link your accounts.

Advanced Mode

Choose the Source you want to link from the Data Connector drop down, then click the 'Link' button. 


Insert your Google credentials.


Click 'Allow' to finalize the process.


Wizard Mode

Choose the Data Source you want to bring data from and click the 'Go to Next Step' button.


On the credential page, click the 'Link' button.


Insert your Google credentials.


Click 'Allow' to finalize the process.



You can even add multiple users to the same platform, by repeating the process.


4. Building & Submitting a Query

After you choose your provider, you need to select a credential in the drop-down menu. Since you can link multiple accounts for the same platform, this gives you the option to select which credential you want to use.

Under 'Account,' choose one of the Google Analytics profiles your credential has access to (if there are more than one), and choose the property and profile you need to extract data from.


Dimensions & Metrics

You can choose a combination of metrics and dimensions from the ones provided in the drop-down menu.

Keep in mind that these are provided by the Google API (in this specific case), and Cognetik has no control over the selection of metrics and dimensions that are displayed. The connector acts like a pipeline that transfers data from your platform in Tableau without processing it.

Not all combinations of metrics and dimensions work. Each dimension and metric has a scope, so it only makes sense to combine dimensions and metrics that share the same scope.

You also have the option to select a segment you created in Google Analytics.


Granularity, Calendar & Presets

In terms of granularity, you can choose between:

  • Daily
  • Weekly
  • Monthly
  • No granularity

There are three types of calendars:

  • Standard calendar - Uses Gregorian calendar (the first day of the week is Sunday, and months are determined by the calendar dates).
  • Retail calendar - Uses the National Retail Federation calendar (The first day of the week is Sunday, but the months are defined by the 4-5-4 NRF calendar).
  • Custom calendar - Select the day the week starts (very useful if the first day of the week is not Sunday. This option allows the user to define custom start days for weeks). This comes in handy when pulling data from a data source at a weekly or monthly granularity because data would already be correctly aggregated at these levels, with the Cognetik Cloud Connector doing all the heavy lifting.

You can also select a Timezone for your data and choose between a Preset or a custom date range using the 'Start Date' and 'End Date.'

Our connector also includes the option to use Date Expressions for all connectors, which is frequently used for Adobe Analytics data. Here's more information on Date expressions.

The row limit is 50,000 rows.


Previewing & Submitting the Query

You can Name your extract and Preview your request before creating a data extract in Tableau. This option helps confirm you have the correct data.

The preview section offers a few features to make data exploration easier:

  1. Search
  2. Sorting
  3. Pagination

After the data is displayed, click 'Submit'


Click 'Update Now' to display the data.


5. Building Your Dashboard in Tableau

After the data is displayed, go to 'Sheet 1' to start working with the data.


You have a lot of options for your dashboard to choose from.

Select the dimension and metric to create your dashboard.



Here's what we went for!