What's the differnce between this calculated metric and 'metrics/visits'? | Community
Skip to main content
July 21, 2021
Solved

What's the differnce between this calculated metric and 'metrics/visits'?

  • July 21, 2021
  • 1 reply
  • 1018 views

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_5d9cb1dd961e9c361a903f2a) instead of 'metrics/visits.'

 

Here is the cm definition I receive from the API:

{ "rsid": <removed>, "reportSuiteName": <removed>, "id": "cm300005330_5d9cb1dd961e9c361a903f2a", "name": "Visits", "description": "", "polarity": "positive", "precision": 0, "type": "decimal", "definition": { "formula": { "func": "metric", "name": "metrics/visits", "description": "Visits" }, "func": "calc-metric", "version": [ 1, 0, 0 ] }, "compatibility": { "identityMetrics": [{ "identity": "metrics/visits" }], "validator_version": "1.0.0", "supported_products": [ "oberon", "frag" ], "supported_schema": [ "schema_oberon", "schema_frag" ] }, "categories": [ "Calculated Metrics" ], "tags": [] }

 

So when I compare the report the client built in the UI with the data I exported with Data Warehouse, the 'visits' don't match up, but the 'page_views' metric does match.

 

The UI report uses these: calculated metric 'cm300005330_5d9cb1dd961e9c361a903f2a,'  and 'metrics/pageviews'

 

Whereas the Data Warehouse export I built uses 'metrics/visits' and 'metrics/pageviews'.

 

I'm looking at the calculated metric and it looks like it's just a wrapper around the 'metrics/visits' metric. it's not adding or removing anything. Am I missing something? Lemme know if you need any more info. Thanks.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by amgup

@samlehman2  Can you try using "Visits-All Visits" metric in Data Warehouse ? Let us know if it matches the visits of Workspace project report. Refer the below links :-

https://experienceleague.adobe.com/docs/analytics/components/metrics/visits.html?lang=en

1 reply

amgupAccepted solution
Level 7
July 22, 2021

@samlehman2  Can you try using "Visits-All Visits" metric in Data Warehouse ? Let us know if it matches the visits of Workspace project report. Refer the below links :-

https://experienceleague.adobe.com/docs/analytics/components/metrics/visits.html?lang=en

July 22, 2021

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.