This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
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.
Now that configuration is complete, the Download Tool can go to work! Open the Adobe Analytics - Example workflow to get started!
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 easilybe converted into an Application! I've published one to our company's gallery to provide self-service capabilities to our gallery users!
Fantastic tool, and much more convenient to use than the Adobe Connector tool (version 126.96.36.199).
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!
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- 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.
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?
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...
Make sure that you created the Segment with that same account that you set up the Alteryx tool with
Make sure that the account has been granted privileges to the Segment (in Omniture).