Unique Visitors how to deduplicate them in Domo
Hi,
Maybe some of you know Adobe Analytics platform
Anyhow for a selected date range the tool will determine the correct number of Unique Visitors who visited a website.
Example in the month of September I visited the domo.com web site 4 time: 3 time in week 1, once in week 2, 0 in week 3 and 0 in week 4).
For the monthly visits I count as 1 Unique visitors.
For week 1 I count as 1 Unique Visitor
For week 2 I count as 1 Unique Visitor
For weeks 3 and 4 I count 0
Adobe Analtyics can deduplicate my visits
But what happens when I load this data in Domo?
Using the Adobe Analytics connectors and importing the metric Daily Unique Visitors in Domo for the month of September I will incurre into an issue.
If I graph the number of Unique Visitors by day in a trend or bar chart, no issue.
If I change the aggregation to weekly it will be a problem as for monthly
Furthermore if I want to had a Summary Number with the total of Unique Visitors cleary it will add them and the total will not correspond to the one from Adobe.
Has anyone got Ideas on how to solve this issue?
Or has got suggestions?
We believe the only way would be to extract for each day ALL users ID and create a dataflow to replicate the "deduplication" mechanism that AA has.
BUT if anyone has got better suggestion we would be happy to hear ti.
Many thanks
Regards
Marialisa
Comments
-
Hi @mmanuzzi
Because of the nature of unique visitors and how platforms like Adobe or Google Analytics calculates it it does the deduplication and summarization before it sends you the data via the Domo connector based on the time slice you have selected. Because of this you can over count if you sliced based on days but then graph by something larger like a week or a month. The only way to get a truly accurate count for a specific time slice would be to list every single visit and then utilize domo to count the distinct values based on the grouping (day, week, month etc) just as you mentioned.
When I've run into this in the past I've ask the stakeholders how accurate they want their data and then essentially "freeze" the data on that type of slice and make sure they know it's only accurate when plotting based on the time slice they selected.
You other option would be to pull the data multiple times based on the different time slices and then graph those (day dataset, week dataset, month dataset etc) but you wouldn't be able to change the slicing in the chart without issues of over counting unique visitors.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi,
This is exactly what we have been telling the final users.
Also if we want to have daily granularity as you said we would need to extract loads of data.
Think a somebody that wants a year of data and more!!!!
Anyhow, it's all clear to us.
We also explained them the difference between the two plaftorm: Domo and Adobe Analytics.
Let's see if other have found a workaround it.
Thank you!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive