Incorrect data when using Adobe Analytics connector
Hi all, I am trying to create an Adobe Analytics connector to report on page views across various pages on our website. The report type for all of the testing I have done is Intermediate - Custom.
When I create a connector with only one dimension (page name), and one metric (page views), then the page views on each page and on each date match exactly what I see when I run the equivalent report in Adobe's Ad Hoc Analysis.
However, when I add a second dimension for tracking marketing channel data, then the page views for each page and for each marketing channel are almost all larger in Adobe's Ad Hoc Analysis than they are when I view the data in Domo. This happens when I run the connector for a month, a week, or even a day. The totals are off for non-null page names and marketing channels, so I don't think that it has to do with nulls being counted strangely.
I've added the following JSON:
{“top”:50000,
“id”:”page”}
but am still seeing the same results.
Has anyone ever run into similar behavior? The totals are only off by around 1-3%, but it would be nice to get them exactly right.
Any thoughts or troubleshooting suggestions would be most welcome.
Comments
-
When comparing Domo to Adobe I HIGHLY recommend using Adobe's API Explorer - https://marketing.adobe.com/developer/api-explorer
You start off with a Report - Queue and put in the JSON for the report you want to Queue. You will get a return of your Report ID. You can then run Report - GetQueue and watch it in the queue. Once it is no longer in the Queue you can pull the report using Report - Get and inputting the Report ID you were using. This will return the report!
Using this method you will always find that Domo and Adobe Matches. Why? Because Domo is just calling Adobe's API with what you've put into the connector.
I've tried to compare Adobe AdHoc Reporting VS Adobe Suite Catalyst (using the UI) VS Adobe's API and have found varying degrees of differences between them. There might be some expert that can compare these 3 and get them to match perfectly, but I can't.
I can, however, affirm Domo and Adobe's API do match. DomoSupport can help confirm that too if needed.
3 -
Thanks, that's all really good info to know. I'll try calling the API directly and see if it turns out the same.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive