Marketo Connector and Data Validation

Hi All,
I have been trying to use the Marketo Dashboard and have it populating. However, I cannot see to properly validate the data compared to the Marketo reports. I've been researching and I found something on the Marketo Community where a user posted:
Marketo Support said DOMO is taking raw data logs from API connection while Marketo's algorithm is doing the following:
- Reporting unique clicks <> DOMO gets all clicks
- Marketo is giving best interpretation of truth and filtering out bots/server clicks <> DOMO gets all clicks
- Marketo is drawing inferences based on behavior. So if someone clicked but didn't open, Marketo is counting that as an open. If someone unsubscribes, but did not open, Marketo is counting that as an open <> DOMO is only getting raw data so if there wasn't an actual open it is not in DOMO
The user was asking for help on how to handle this, but there was no respond. Because of the IDs, unique clicks are not straightforward. Also, I would think that IPs might be a way to determine some duplicates or missing Opens when an email has Clicks, but there are a lot of NULLs in that field. Has anyone worked through how to get this raw data to work correctly to match the Email Performance Report in Marketo?
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有