Adobe Analytics - Connector Toolkit

[Coxta45]

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.

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.

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...

Configuration Window (4 tabs)...

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

[dataMack · Accepted solution]

Excellent write up.  I can't wait to try out your macro

[jensroy · Accepted solution]

Fantastic tool, and much more convenient to use than the Adobe Connector tool (version 1.0.0.2).

First of all, more than 1 metric (up tp 5) is such a time saver. Now I only need 1 tool instead of 5 (pulling visits, unique visits, orders, revenue and cart additions) in one tool. 

Also, since the data does not come in a wrongly transposed format where dimension 2 become column headlines, I can pull much more data (YTD instead of maximum 1 week). This makes it much more stable.

I would love to see an option for 3 elements. We run Test&Targets at our site where we run user experience tests. 1 test can have X versions, and each version may have an Order ID connected to it. Right now i need 2 tools to connect Order ID to the right version of a test.

An excellent tool! I hope you will continue to develop this!

[Coxta45]

@jensroy,

I'm so glad you found this helpful!  It has definitely been very useful for myself and our company.  I am actually meeting with Alteryx today to discuss further development of this tool.  I'll keep an update on this thread.

Taylor

[dataMack]

Taylor- I wanted to thank you again for building this - finally had a chance to install 10.6 and I first tested the stock Adobe Analytics app, and then yours.  I really like the way your's stores the Report Suite info in a library, so future uses of the tool are greatly streamlined.  Also very much appreciate the ability to download up to 5 metrics in a single shot - with the stock app I was having to copy and paste it over and over to get all the metrics I need.  So for now, your tool will be my go-to for Adobe API downloads.

I hope the team from Alteryx can bring together the great features in your tool, with the flexibility of html-based forms that they used in theirs.  

[Coxta45]

Jason,

First and foremost, I'm glad that you've found the tool to be useful.  I worked on and off with this for a few months and finally reached a version that I felt was worthy of publication.  I've actually received excellent feedback from a few others that have tried it out and also found it to be a timesaver.  Secondly, I've also had the opportunity to meet with members of the Alteryx Product Development team a couple of times now to discuss this tool and Adobe Analytics in general.  It is my understanding that a new version of their tool should be in the making and will combine the HTML/Javascript elegance from their original version with the functional capabilities from my version.  Time will tell, I guess!

Regards,

Taylor

[scottiewardell]

Hi @Coxtra45!  First of all, thank you for developing this tool - SO much more useful than the awful pre-built one that doesn't work at all.

One issue I'm having - when I create a new segment via omniture/adobe analytics, I can't find that new segment in the tool.  I tried to run the tool to try to refresh the segment list, but that doesn't seem to work.  Any suggestions?

Thank you!

[Coxta45]

Glad you like it!

Make sure that after adding the segment in Omniture, you run the  "Adobe Analytics - Library Manager" Alteryx application and  selected the "Add Report Suite to available library" option for the appropriate report suite.  If it already exists, this option should overwrite all of the metadata for that report suite.  If it runs successfully, the new segment should appear in a new instance of the download tool.

If this doesn't work...

1. Make sure that you created the Segment with that same account that you set up the Alteryx tool with
2. Make sure that the account has been granted privileges to the Segment (in Omniture).

Regards,

Taylor

[scottiewardell]

That worked!  Thank you!!

[scottiewardell]

hi @coxta45!  I am wondering one other thing ... is there any way to change the date ranges that are in the tool?  I opened up the macro but didn't want to break it.....

I would really like to have the ability to do last 30 and last 90 days on a rolling basis, but I only see last 14.

Any guidance to make this work?

Thanks!