How To Connect Tableau to Adobe Analytics

By default, there is no functionality in Tableau to connect Adobe Analytics or vice versa.Till now no Connector is available for data transfer developed by Adobe or Tableau.

Option available for now is to get file processed from Data Warehouse which is supported by Tableau i.e

  • Tableau Workbook (.twb)
  • Tableau Packaged Workbook (.twbx)

But now cognetik developed a connector which is made available to analysts & marketers worldwide.

It’s free to use, for now, it’s got a fairly easy set-up, it takes a few minutes to import the data and it allows for easy refreshes.

In addition to Adobe, works fine with Facebook Ads, Facebook Pages, Adwords, Bing, Kochava, Youtube and Twiter.

 

How To Connect R-Studio to Adobe Analytics

With the help of Web Services API R-studio can be used to connect Adobe Analytics.

The Web Services APIs provide programmatic access to marketing reports and other Suite services that let you duplicate and augment functionality available through the Analytics interface.

Analytics > Admin > Company Settings > Web Services

RSiteCatalyst is a kind of good package of R.

SCAuth Store Credentials For The Adobe Analytics API

Usage:

SCAuth(key, secret, company = “”, token.file = “”, auth.method = “legacy”, debug.mode = FALSE, endpoint = “”, locale = “en_US”)

Arguments

key
Client id from your app in the Adobe Marketing cloud Dev Center OR if you are using auth.method=’legacy’, then this is the API username (username:company)

secret
Secret from your app in the Adobe Marketing cloud Dev Center OR if you are using auth.method=’legacy’, then this is the API shared secret

company
Your company (only required if using OAUTH2 AUTH method)

token.file
If you would like to save your OAUTH token and other auth details for use in future sessions, specify a file here. The method checks for the existence of the file and uses that if available.

auth.method
Defaults to legacy, can be set to ‘OAUTH2’ to use the newer OAUTH method.

debug.mode
Set global debug mode

endpoint
Set Adobe Analytics API endpoint rather than let RSiteCatalyst decide (not recommended)

locale
Set encoding for reports (defaults to en_US)

Details
Authorize and store credentials for the Adobe Analytics API

Value
Global credentials list ‘SC.Credentials’ in AdobeAnalytics (hidden) environment

References

The list of locale values can be obtained from the Adobe Analytics documentation:

https://marketing.adobe.com/developer/documentation/analytics-reporting-1-4/r-reportdescriptionlocale

After loading the library by library(RSiteCatalyst) command use the below command to authenticate.

SCAuth(“pheonixm.sptz:Tots”, “73ng567ygd93cf57e83ehgrteswefvaa”)

Note:It a sample for example purpose only,use your own correct user key and secret.