on 05-13-2016 08:28 AM - edited on 07-27-2021 11:40 PM by APIUserOpsDM
The ‘How to Guide’ To Adobe Analytics
Through Adobe Analytics the ability to collect and visualize data from your websites has allowed for improved decision making, yet the format of that data can only take you so far. Within Alteryx you now have the ability to connect to Adobe Analytics and bring that data into Alteryx, allowing you to perform greater data manipulation to provide further insights, as well as Predictive & Spatial Analytics!
There are just a few things you need in order to use the Adobe Analytics connector:
Step 1: Download the Connector
Step 2: Sign In
User Login
Developer Login
Step 3: Configuration
Report Suite
Date Range & Granularity
Metric
Element (1, 2, 3)
Segments
Step 4: Run the connector
Tips and Tricks
All report suites do not offer all elements. Use ReportSuite.GetAvailableElements (in the Administration API) to get a list of Element IDs available in a particular report suite.
Social elements are available only if Social is enabled.
Video elements are available only if v15 video measurement is configured in Admin Console.
Mobile elements are available only if mobile application reporting is enabled in Admin Console.
Factors affecting report generation time please see API best practices
Common Issues
"As the connector auto-populates based on your log in credentials you should not receive any errors related to Adobe."
If you have any issues please reach out to Alteryx Support
Best,
Jordan Barker
Solutions Consultant, Alteryx Inc.
This tool is great! I'm having some problems though.
The "Metrics" field under "Report Breakdown" isn't showing all the metrics that I can see through my Adobe Analytics UI. Is there a reason I wouldn't be able to see it?
I have no problems creating my entire report in Report Builder for Excel, but we're trying to automate this process.
thanks.
-Bryan
@bryanbumgardnerSorry to hear you've had issue with the current Adobe Analytics tool. We are in the process of developing a new Adobe Analytics tool and believe your issue will be resolved by the new release of the connector. That said, we are expecting a delivery of late-March or early-April for the new connector.
Please reach out with any further questions/concerns.
Alex Polly
Will the new Adobe Analytics tool have the ability to pull metrics by segment? I have a number of segments we used to pull data from Adobe Analytics so that is a critical need for us.
In addition, it would be great if the End time could be set to yesterday or today.
Tim
Hello,
thanks for the tutorial, I'm trying to add a filter to return only specific page names that contains "WEB" for example. Is there a way to pass this filter in the tool?
-Joseph
Hi @joeantwi
Unfortunately the tool cannot be opened nor values past into the interface due the html front end. I would suggest adding a filter after the adobe analytics tool to reduce your dataset.
Best,
Jordan
@JordanB
Thank you for replying, i'm trying to get data for two months and it takes forever to return results, i thought adding filter will hep but i guess that's not available...
Hi,
@jordanB
My Adobe log in page ask for Company, user name and pwd.
On the Tool I only get ether user name an pwd or user name and secret ID.
Nether combination allows me to log in.
Hello,
Currently using V2 of the connector.
I have a use case that requires 4 Elements (Visit Number > Device > Traffic Driver > Offer). Given the cascading nature of Elements, is there a way to incorporate an additional Element into the connector? If not, how would I incorporate the 4th Element (in my case mentioned above the Offer Element)?
Thanks,
James
Hi @jamesus
You can find the inside of the adobe analytics engine macro here C:\Users\%Username%\AppData\Roaming\Alteryx\Tools\AdobeAnalytics\Supporting_Macros
I would suggest taking a look at the adobe reporting API documentation to see if an additional 4th element can be added. If so, this is where it can be added.
You could then re save the macro, however because this is a html front end there would need to be additional work to add this element into the interface.
Alternatively, you could just run the workflow as it is rather than inserting as a tool on the canvas.
Best,
Jordan
Does this connector still work? I tried installing this, but it does not open up the 'Tool Installer' option. Rather, it opens up a zipped file.
Hi @LukeAhn
Yes I've just tested it and it works. You should be getting a .yxi file
Please try this link: http://downloads.alteryx.com/Tools/AdobeAnalytics_v2.yxi
Best,
Jordan
Thanks @JordonB ! I had to open up the URL directly. Think it was something on my end.
I have a colleague who's tried the install of the connector, as have I, but we're having different results. When my colleague attempts the install, she encounters a brief "splash screen", followed by this "empty" dialog where all that seems possible is to dismiss:
11.7
Hey Jordan,
I have a use case I was hoping you could help with. I have around 20 report suites that I need to pull the same data out of (metrics, dimensions, same segments). I know i could run these extractions all separately and then Union the results, however I was hoping to do this via a macro that just changed the report suite name. That way if I edited the workflow I would not have to repeat this process in 20 places.
Is there a relative easy way to do this?
Thanks,
Chris
And followup question - has anyone had success in adding additional metrics to the tool? I know the limit is 5, but i need about 15 for my reports which means x3 connectors across multiple report suites meaning the workflow takes about an hour to run...
Anyone had experience of using a lower level of granularity than hour? If so, how did you do it?
Anyone tried to login via the Developer option now? Adobe changed its API details in Adobe IO and it seems that it doesn't work. Even if I create an OAuth Integration or a Service Integration, I'm always getting this message below:
I installed the tool, logged in, configured the report, but am getting errors after many tries: tool#43 and tool#51.
My alteryx is version 2018.3. The tool version is AdobeAnalytics_v2.0.1.yxi
Can anyone tell me what I'm not doing right? Thanks for your help!
Any plans to release an updated version of the connector leveraging Report API 2.0?
I am encountering the same errors as ninasun.
Error: Adobe Analytics (2): Tool #43: Cannot find macro "AdobeAnalytics\Supporting_Macros\adobe-analytics-report.get.yxmc".
Error: Adobe Analytics (2): Tool #51: Cannot find macro "AdobeAnalytics\Supporting_Macros\adobe-analytics-parsing.yxmc".
Please advise how to resolve this error
Hi,
Just installed this tool and it's very needed. I can connect to Adobe but when I run workflow I get error Cannot find macro "AdobeAnalytics\Supporting_macros\adobe-analytics-report.get.yxmc". When I searched this macro I found out that it's located in C:\Users\XXXXXXX\AppData\Roaming\Alteryx\Tools\AdobeAnalytics_v2.0.1\Supporting_Macros. Is there a way fix this new address?
Cheers
Janne
@mkav9893, @ninasun, and @jannekol -
I had the same error and found a simple hack that resolved it. The tool seems to be looking for macros within AdobeAnalytics\ instead of AdobeAnalytics_v2.0.1. So I made a duplicate of the v_2.0.1 folder and renamed it AdobeAnalytics\. After restarting Alteryx, the tool finds the macros it needs.
CC @JordanB
@jaylewis thank you very much!!! :)
Anyone ever solve this problem?
Anyone tried to login via the Developer option now? Adobe changed its API details in Adobe IO and it seems that it doesn't work. Even if I create an OAuth Integration or a Service Integration, I'm always getting this message below:
Unfortunately I could not get to the level of detail needed for reporting by this macro. The workaround that I have implemented is the following:
1. scheduled report within Adobe Analytics warehouse drops report on specified basis
2. utilize the download tool to download file from ftp to local/server drive, see below
3. utilize dynamic input tool that finds the file from local/server drive that is referenced within the workflow
Hi There,
These instructions are out of date, as adobe has updated their API manager - your links are also out of date. This makes it had to navigate the details of the connection. Personally, I cannot get a connection using this connector - I always get an error!!
@ecarpe & Arwilding.
If you are an admin and you navigate to user management you can set up a legacy oauth connection.
Just validated; a new connection works fine.
Hello,
Could an Alteryx Rep please answer this...
Your Adobe connector currently leverages the 1.4 API - which will be discontinued in two months (2020). As I understand it, we will no longer be able to use 1.4 and will be forced to use 2.0 and higher. When will this connector be updated?
Furthermore, when there are multiple organizations in the account - the dropdown randomly switches between the segments under each org. Basically, we cannot rely on this connector as is currently stands. Please advise.
Many Thanks,
I had a job that used to work and recently got this error message below. Could this be related to above comment?
API Method API Response Response JSON Report Description Report ID
Report.Queue HTTP/1.1 500 Internal Server Error
Date: Fri, 03 Jan 2020 22:03:52 GMT
Server: Apache
Cache-Control: no-cache
Vary: x-api-uri-scheme,Accept-Encoding,User-Agent
Access-Control-Allow-Credentials: true
Access-Control-Allow-Origin: *
Access-Control-A... {"error":"system_failure","error_description":"A system failure has occurred (7000)","error_uri":null} :
I have followed the instructions as outlined above, and was able to download-install the Adobe Analytics Connector. However, when I get to "Select Segments to Include" while setting parameters, the Tool seems to time out and I get 2 errors
"Tool#43: Cannot find macro "AdobeAnalytics\Supporting_Macros\adobe-analytics-report.get.yxmc'
Tool#51: Cannot find macro "AdobeAnalytics\Supporting_Macros\adobe-analytics-parsing.yxmc'
When the tool installs, it is stored on my C: drive (C:\Users\........\AppData\Roaming\Alteryx\Tools’ and I see the install there, and the .yxmc files the tool claims in cannot find. I've tried uninstalling and re-installing a few different ways, changing the location where the .yxi is found, and under User Settings, setting the macro location to reference where the .yxi is stored. None of these have fixed the problem.
Any ideas? I'm really at a dead end and my company would greatly benefit from pulling this data into Alteryx. THANK YOU!!!!
*** I use Alteryx Designer 2019.3 x64***
Spenc, this doesn't answer your question - but one thing to keep in mind is that the method of authentication this relies on is reaching end of life in November - so be aware that later this year the workflow will need to be rebuilt. Depending on your use case, a more durable method is using datawarehouse to FTP and using Alteryx to grab files from there.
Are you able to set this up as a server connection that users would use on the server, and not on their desktops?
I was worried about this macro no longer working when Adobe retires the 1.4 API, but Adobe is only retiring the 1.4 SOAP Analytics API (pushed out to April 30th 2021).
This macro uses the 1.4 Analytics REST API
If you open the macro you can see the endpoint: 'https://api.omniture.com/admin/1.4/rest/?method=Report.Queue&access_token=' + [access_token]