What's the difference between this calculated metric and the 'metrics/visits' metric?
(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 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?
In my previous post, someone mentioned trying to use the 'all visits' metric, but the data was still way off for the visits field. Also Unique Visits metric doesn't match either.
Lemme know if you need any more info. Thanks.