Your company has run a couple of campaigns on your website and on social media. As an analyst, you want to bring Adobe Analytics data and Facebook Ads data into Tableau with the purpose of creating campaign performance dashboards for your management team.
We will show you how Cognetik Cloud Connector works with one single block and two data sources, with dimensions and measures changing per data source, while using Tableau’s feature to join data. The common element, in this case, is the 'Campaign Name.'
After accessing the connector and creating a Cognetik account, you need to link your Adobe Analytics credentials in order to bring your data into Tableau.
How to link the connector to your other sources:
To see a list of all your linked accounts, click on 'Credential List.'
Let’s start building our Adobe Analytics query.
Choose 'Adobe Analytics' from the 'Choose a provider' drop-down list.
Select your Credential and Report Suite.
You can now filter your data: You can choose from Dimensions (optional), Metrics (mandatory), and Segments (optional). It’s easy to find them from the drop-down list. You can bring anything that’s set up in your Adobe Analytics report suite.
As an example, I’ve selected data related to my campaign performance and also a segment of users I'm interested in that I’ve previously set up in Adobe Analytics.
You can choose from three types of granularities:
You can choose from three types of calendars:
You can now also select a Timezone for your data.
In the present, you already have a lot of Preset Date ranges you can use. Our connector also includes the option to use Date Expressions for all connectors. This is frequently used for Adobe Analytics data. Here's more information on date expressions.
If you need a specific period of time, you can use a Start Date and an End date.
The row limit is 50,000 rows.
Top limit is only applicable to Adobe Analytics (filters out and returns the first 'n' rows ordered by the first metric chosen).
Function - takes the first n breakdowns, aggregated by the first metric requested, over the entire period specified, then returns the daily values for those values, whether or not they are in the top values for that given day.
*For more information about the Top limit, visit this article.
You can now Preview your request before creating a data extract in Tableau. This will allow you to explore the data quicker and confirm you have the correct data.
The preview runs quickly because the processing is done by Cognetik’s distributed API engine and does not require waiting for Tableau to create a local database for the extract.
The preview section offers a few features to make data exploration easier:
Once you click Submit, your data will be sent to Tableau.
In the 'Data Source' tab, click 'Update now.'
Your Adobe Analytics data is now displayed in Tableau.
To add your Facebook data in Tableau, click the 'Add' button next to 'Connections.'
Select 'Web data connector' to access our connector. Paste http://tableau.cognetik.com in the URL Box and hit Enter.
Use your Cognetik credentials to log in.
Choose Facebook Ads from the Provider drop-down list.
Start building your query with the desired dimensions/metrics/segments.
Note - Make sure you link your Facebook Ads data first.
The rest of the fields (granularity, timezone, calendar, date range, and row limit) are the same ones we used to create the first Adobe Analytics extract.
Once you’re done, click Submit.
You can now see both of your data sources, Adobe Analytics, and Facebook under 'Connections.'
You can now easily join your data by a common element which is the 'Campaign Name.' I’m going to choose left join.
We can now go ahead and build our dashboards!
Here are some basic dashboards you could build:
