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.

Sample Code :

library(“RSiteCatalyst”)

SCAuth(“Gaga:Ameri lines”,”2f40922f54f3ad116c2ca72317661b30″)

datefrom=Sys.Date()-91

dateto=Sys.Date()-1

trended_id<-QueueTrended(“productionreportsuite”,

datefrom,

dateto,

metrics = “visits”,

elements = c(“evar10″,”mobiledevicetype”),

segment.id = c(“s300000988_5be8bc302b36874afe33502f”,”s300000899_5bedfc3e706e9e558c910e1a”),

date.granularity = “day”,

interval.seconds = 300,

top = 30000

,expedite = TRUE

,enqueueOnly = TRUE

)

trended<-GetReport(trended_id, interval.seconds = 5, max.attempts = 5)

Note: RSiteCatalyst is a community-driven, open-source effort, not an official package from Adobe. As such, bug fixes and improvements rely on a vibrant community of users and developers contributing their free time and resources.

https://rdrr.io/cran/RSiteCatalyst/man/QueueDataWarehouse.html