Hello @Khurshid_Alam , I tried using 'Visits (All Visitors)' and the numbers are still way off. For example, when comparing the Devices column, the workshop report says the visits for Mobile Phone are 688,717, but the data warehouse says 854,641.
So I built a simple report in the workspace using both the metric and the computed metric, and both match each other. But if I compare it to what the Data Warehouse exported, the DW number is way higher. For example, the workspace says the 'mobile phone' under the mobile device dimension has 688,717...
(I had asked this question yesterday, but I accidentally marked someone's reply as a solution, but it wasn't) I've been working with a client trying to ingest their Analytics data using the 'Data Warehouse' feature, but was seeing some discrepancies. Under the 'workspace' tab, the client created a r...
Opps, I didn't mean to mark this as the solution... I attempted using the 'all visits' field (I also added the unique visits field as well) and the totals still are way larger than what the calculated metric is showing.
I've been working with a client trying to ingest their Analytics data using the 'Data Warehouse' feature, but was seeing some discrepancies. Under the 'workspace' tab, the client created a report. I noticed that when they use the 'visits' metric, they are using a calculated metric (ID: cm300005330_5...