Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Adobe Analytics - Connector Toolkit

Coxta45
11 - Bolide

Hi, Alteryx Community!

 

I have been working for several months now on my very own edition of an Abode Analytics connector.  I was very pleased to see the publication of the first iteration of Alteryx's connector with the release of 10.5.  However,  I thought I'd share the work that I've done for those that may still be seeking some additional options and/or capabilities from the Adobe Marketing Cloud API.

 

The toolkit can be downloaded and imported via the attached package (Adobe Analytics.yxzp).  Upon importing, please review the README.txt file!  It is very helpful in understanding not only how the toolkit is configured but more importantly understanding, at a high-level, how the API is architected and what its limitations are.

 

REQUIREMENT:  Alteryx 10.1+ with predictive tools

RECOMMENDED:  Install/import this package in your Macro folder

 

There are 2 configuration Applications that must be run prior to using the included download tool.

 

FIRST

 

In the package folder, run the application 'Adobe Analytics' (as an app, of course).   It prompts to load automatically upon importing this package. This application will authenticate your login credentials and, if successful, load a list of available Report Suites that can then be added to your available library.

 

 

Auth.png

 

 

SECOND

 

The aforementioned app should chain to a Library Manager app.  This app loads metadata for a specific Report Suite into your available library.


1.  Either re-enter your login credentials or choose from a saved profile if you saved one from the prior app.
2.  Select a Report Suite to load into your library.
3.  Click finish.

 

Library_Creds.pngLibrary_Add.png


After this runs, if you were to exit and re-open the application, you should see the available library in the list at the bottom of te second tab.
You can run this at any time to add additional Report Suites, reset your library, or refresh the list of available Report Suites.

FINALLY!  

Now that configuration is complete, the Download Tool can go to work!  Open the Adobe Analytics - Example workflow to get started!

 

Sample Workflow...

Sample Flow.PNG

 

Configuration Window (4 tabs)...

 

Config_1.PNG

Config_2.PNG

Config_3.PNG

Config_4.PNG

 

I hope you all will find this to be very useful if you're looking to pull Adobe data into your Alteryx workflows.  Please don't hesitate to post questions/concerns.  Feedback is always welcome and I'm sure there is significant room for improvement.  In the meantime,  I'll be working on a second version that uses different authentication methods and won't be limited to developer connections (requiring API Shared Secret). However, if the need for this data is urgent enough, you should be able to ask your site admin for an API Shared Secret (API Key).

 

P.S.  The Adobe Analytics - Download Tool can easily be converted into an Application!  I've published one to our company's gallery to provide self-service capabilities to our gallery users!

 

Best Regards,

 

Taylor Cox

23 REPLIES 23
Christopher11
5 - Atom

 

Coxta45

 

Awesome. Thank you for sharing. This is also similar to what i found yesterday, while digging through your macro.

Anyhow, it was nice to be confirmed and once again, thumbs up for your macro :-)  

 

 

 

engdell2
8 - Asteroid

Just in case someone is following this thread. Found a small thing that I had to manipulate to make it work a bit more robust. The iteration that takes place after submitting the report request is constructed as 2000 request that asks the api if the report is ready as fast as possible. A nicer way of doing it it is to ask, then wait for a little while and then ask again. So I installed a "wait a second" (with 10 seconds grace) on my iteration output. The added benefit is that I don't reach the dreaded 2000 iterations before my report is ready. Perhaps something that should go into the next version of the tool. 

 

Best regards//Leif

N-Dru
5 - Atom

Thanks for the connector! Is there an option to change preset date selector "last week" to range from Monday until Sunday? I tried setting up a custom date range in Adobe Analytics but it doesn't shop up in the selector.

pavan530
5 - Atom

I am using the Omniture API to pull records from Adobe in Python. It's going in loop forever saying 152 records pulled out of 154. Means Job will complete if it pulls remaining 2 records but it's running in loop for days and I had to kill with no hope. 

 

I am using report layout something like this :

 

{
"0" :
{
"reportDescription": {
"reportSuiteID": "VIT",
"dateGranularity": "day",
"metrics": [
{"id": "visits"},
{"id": "entries"},
{"id": "bounces"},
{"id": "pageviews"},
{"id": "totaltimespent"},
{"id": "uniquevisitors"},
{"id": "event11"},
{"id": "event18"},
{"id": "event25"},
{"id": "event26"},
{"id": "event27"},
{"id": "event34"},
{"id": "event50"}
],
"segments": [],
"elements": [
{"id": "trackingcode", "top": 50000}
]
}
}

 

 

Let me know if you have seen such kind of issue.

 

Labels