Cube does not return zero values for a given date range
What does this MR do and why?
This MR adds a transformer to the Cube proxy query service. In the event that Cube returns data which doesn't cover the entire date range selected, it will only automatically fill the data between known data points and not the entire date range. This is a problem because it means the resulting axis doesn't show the full date range selected, and as a result looks misleading.
With this MR, we zero-fill each missing day in the date range, so we get a full axis in the visualizations and export functionalities. This is not meant to be a long-term solution as it doesn't support different time dimensions (minutes, hours, quarters, years etc…), ignores the limit defined by the query, and only works with the filter in the UI; whilst Cube supports filtering time dimensions within the timeDimensions
property too.
Long-term, groupproduct analytics will remove this transformer and upstream a fix to Cube's Clickhouse driver instead: Add WITH FILL ORDER BY modifier to Cube Clickho... (#417231 - closed)
Screenshots or screen recordings
Before | After |
---|---|
![]() |
![]() |
Export query
Example query used
curl --location '<GDK_HOST>/api/v4/projects/<PROJECT_ID>/product_analytics/request/load?queryType=multi' \
--header 'PRIVATE-TOKEN: <PRIVATE_TOKEN>' \
--header 'Content-Type: application/json' \
--data '{
"query": {
"measures": [
"SnowplowTrackedEvents.uniqueUsersCount"
],
"timeDimensions": [
{
"dimension": "SnowplowTrackedEvents.derivedTstamp",
"granularity": "day"
}
],
"limit": 100,
"timezone": "UTC",
"filters": [
{
"member": "SnowplowTrackedEvents.derivedTstamp",
"operator": "inDateRange",
"values": [
"2023-01-01",
"2023-07-01"
]
}
],
"dimensions": []
},
"queryType": "multi"
}'
Before output
{
"queryType": "regularQuery",
"results": [
{
"query": {
"measures": [
"SnowplowTrackedEvents.uniqueUsersCount"
],
"timeDimensions": [
{
"dimension": "SnowplowTrackedEvents.derivedTstamp",
"granularity": "day"
}
],
"limit": 100,
"timezone": "UTC",
"filters": [
{
"member": "SnowplowTrackedEvents.derivedTstamp",
"operator": "inDateRange",
"values": [
"2023-01-01",
"2023-07-01"
]
}
],
"dimensions": [],
"order": [],
"rowLimit": 100,
"queryType": "regularQuery"
},
"data": [
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-30T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-30T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "1"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-05T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-05T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "1"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-06T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-06T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "1"
}
],
"lastRefreshTime": "2023-07-17T08:26:07.630Z",
"refreshKeyValues": [
[
{
"refresh_key": "168958236"
}
]
],
"usedPreAggregations": {},
"transformedQuery": {
"sortedDimensions": [
"SnowplowTrackedEvents.derivedTstamp"
],
"sortedTimeDimensions": [
[
"SnowplowTrackedEvents.derivedTstamp",
"day"
]
],
"timeDimensions": [
[
"SnowplowTrackedEvents.derivedTstamp",
"day"
]
],
"measures": [
"SnowplowTrackedEvents.uniqueUsersCount"
],
"leafMeasureAdditive": false,
"leafMeasures": [
"SnowplowTrackedEvents.uniqueUsersCount"
],
"measureToLeafMeasures": {
"SnowplowTrackedEvents.uniqueUsersCount": [
{
"measure": "SnowplowTrackedEvents.uniqueUsersCount",
"additive": false,
"type": "countDistinct"
}
]
},
"hasNoTimeDimensionsWithoutGranularity": true,
"allFiltersWithinSelectedDimensions": false,
"isAdditive": false,
"granularityHierarchies": {
"year": [
"year",
"quarter",
"month",
"month",
"day",
"hour",
"minute",
"second"
],
"quarter": [
"quarter",
"month",
"day",
"hour",
"minute",
"second"
],
"month": [
"month",
"day",
"hour",
"minute",
"second"
],
"week": [
"week",
"day",
"hour",
"minute",
"second"
],
"day": [
"day",
"hour",
"minute",
"second"
],
"hour": [
"hour",
"minute",
"second"
],
"minute": [
"minute",
"second"
],
"second": [
"second"
]
},
"hasMultipliedMeasures": false,
"hasCumulativeMeasures": false,
"windowGranularity": null,
"filterDimensionsSingleValueEqual": null,
"ownedDimensions": [
"SnowplowTrackedEvents.derivedTstamp"
],
"ownedTimeDimensionsWithRollupGranularity": [
[
"SnowplowTrackedEvents.derivedTstamp",
"day"
]
],
"ownedTimeDimensionsAsIs": [
[
"SnowplowTrackedEvents.derivedTstamp",
"day"
]
]
},
"requestId": "3845ec09-0fc8-4938-a6a3-75ee45be4bcc-span-1",
"annotation": {
"measures": {
"SnowplowTrackedEvents.uniqueUsersCount": {
"title": "Snowplow Tracked Events Unique Users Count",
"shortTitle": "Unique Users Count",
"type": "number",
"drillMembers": [],
"drillMembersGrouped": {
"measures": [],
"dimensions": []
}
}
},
"dimensions": {},
"segments": {},
"timeDimensions": {
"SnowplowTrackedEvents.derivedTstamp.day": {
"title": "Snowplow Tracked Events Derived Tstamp",
"shortTitle": "Derived Tstamp",
"type": "time"
},
"SnowplowTrackedEvents.derivedTstamp": {
"title": "Snowplow Tracked Events Derived Tstamp",
"shortTitle": "Derived Tstamp",
"type": "time"
}
}
},
"dataSource": "default",
"dbType": "clickhouse",
"extDbType": "cubestore",
"external": false,
"slowQuery": false,
"total": null
}
],
"pivotQuery": {
"measures": [
"SnowplowTrackedEvents.uniqueUsersCount"
],
"timeDimensions": [
{
"dimension": "SnowplowTrackedEvents.derivedTstamp",
"granularity": "day"
}
],
"limit": 100,
"timezone": "UTC",
"filters": [
{
"member": "SnowplowTrackedEvents.derivedTstamp",
"operator": "inDateRange",
"values": [
"2023-01-01",
"2023-07-01"
]
}
],
"dimensions": [],
"order": [],
"rowLimit": 100,
"queryType": "regularQuery"
},
"slowQuery": false
}
After output
{
"queryType": "regularQuery",
"results": [
{
"query": {
"measures": [
"SnowplowTrackedEvents.uniqueUsersCount"
],
"timeDimensions": [
{
"dimension": "SnowplowTrackedEvents.derivedTstamp",
"granularity": "day"
}
],
"limit": 100,
"timezone": "UTC",
"filters": [
{
"member": "SnowplowTrackedEvents.derivedTstamp",
"operator": "inDateRange",
"values": [
"2023-01-01",
"2023-07-01"
]
}
],
"dimensions": [],
"order": [],
"rowLimit": 100,
"queryType": "regularQuery"
},
"data": [
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-30T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-30T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "1"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-05T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-05T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "1"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-06T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-06T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "1"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-01T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-01T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-02T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-02T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-03T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-03T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-04T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-04T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-05T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-05T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-06T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-06T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-07T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-07T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-08T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-08T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-09T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-09T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-10T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-10T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-11T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-11T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-12T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-12T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-13T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-13T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-14T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-14T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-15T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-15T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-16T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-16T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-17T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-17T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-18T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-18T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-19T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-19T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-20T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-20T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-21T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-21T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-22T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-22T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-23T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-23T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-24T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-24T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-25T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-25T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-26T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-26T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-27T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-27T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-28T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-28T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-29T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-29T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-30T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-30T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-01-31T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-01-31T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-01T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-01T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-02T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-02T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-03T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-03T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-04T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-04T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-05T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-05T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-06T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-06T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-07T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-07T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-08T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-08T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-09T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-09T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-10T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-10T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-11T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-11T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-12T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-12T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-13T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-13T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-14T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-14T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-15T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-15T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-16T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-16T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-17T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-17T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-18T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-18T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-19T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-19T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-20T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-20T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-21T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-21T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-22T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-22T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-23T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-23T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-24T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-24T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-25T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-25T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-26T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-26T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-27T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-27T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-02-28T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-02-28T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-01T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-01T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-02T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-02T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-03T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-03T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-04T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-04T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-05T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-05T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-06T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-06T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-07T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-07T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-08T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-08T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-09T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-09T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-10T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-10T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-11T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-11T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-12T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-12T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-13T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-13T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-14T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-14T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-15T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-15T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-16T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-16T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-17T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-17T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-18T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-18T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-19T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-19T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-20T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-20T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-21T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-21T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-22T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-22T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-23T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-23T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-24T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-24T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-25T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-25T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-26T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-26T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-27T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-27T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-28T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-28T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-29T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-29T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-30T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-30T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-03-31T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-03-31T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-01T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-01T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-02T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-02T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-03T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-03T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-04T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-04T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-05T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-05T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-06T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-06T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-07T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-07T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-08T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-08T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-09T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-09T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-10T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-10T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-11T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-11T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-12T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-12T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-13T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-13T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-14T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-14T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-15T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-15T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-16T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-16T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-17T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-17T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-18T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-18T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-19T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-19T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-20T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-20T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-21T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-21T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-22T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-22T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-23T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-23T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-24T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-24T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-25T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-25T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-26T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-26T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-27T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-27T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-28T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-28T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-29T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-29T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-04-30T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-04-30T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-01T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-01T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-02T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-02T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-03T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-03T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-04T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-04T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-05T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-05T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-06T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-06T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-07T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-07T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-08T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-08T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-09T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-09T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-10T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-10T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-11T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-11T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-12T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-12T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-13T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-13T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-14T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-14T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-15T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-15T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-16T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-16T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-17T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-17T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-18T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-18T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-19T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-19T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-20T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-20T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-21T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-21T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-22T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-22T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-23T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-23T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-24T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-24T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-25T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-25T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-26T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-26T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-27T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-27T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-28T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-28T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-29T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-29T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-05-31T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-05-31T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-01T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-01T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-02T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-02T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-03T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-03T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-04T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-04T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-07T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-07T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-08T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-08T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-09T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-09T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-10T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-10T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-11T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-11T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-12T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-12T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-13T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-13T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-14T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-14T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-15T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-15T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-16T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-16T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-17T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-17T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-18T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-18T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-19T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-19T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-20T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-20T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-21T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-21T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-22T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-22T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-23T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-23T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-24T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-24T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-25T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-25T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-26T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-26T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-27T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-27T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-28T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-28T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-29T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-29T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-06-30T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-06-30T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
},
{
"SnowplowTrackedEvents.derivedTstamp.day": "2023-07-01T00:00:00.000",
"SnowplowTrackedEvents.derivedTstamp": "2023-07-01T00:00:00.000",
"SnowplowTrackedEvents.uniqueUsersCount": "0"
}
],
"lastRefreshTime": "2023-07-17T08:19:20.533Z",
"refreshKeyValues": [
[
{
"refresh_key": "168958195"
}
]
],
"usedPreAggregations": {},
"transformedQuery": {
"sortedDimensions": [
"SnowplowTrackedEvents.derivedTstamp"
],
"sortedTimeDimensions": [
[
"SnowplowTrackedEvents.derivedTstamp",
"day"
]
],
"timeDimensions": [
[
"SnowplowTrackedEvents.derivedTstamp",
"day"
]
],
"measures": [
"SnowplowTrackedEvents.uniqueUsersCount"
],
"leafMeasureAdditive": false,
"leafMeasures": [
"SnowplowTrackedEvents.uniqueUsersCount"
],
"measureToLeafMeasures": {
"SnowplowTrackedEvents.uniqueUsersCount": [
{
"measure": "SnowplowTrackedEvents.uniqueUsersCount",
"additive": false,
"type": "countDistinct"
}
]
},
"hasNoTimeDimensionsWithoutGranularity": true,
"allFiltersWithinSelectedDimensions": false,
"isAdditive": false,
"granularityHierarchies": {
"year": [
"year",
"quarter",
"month",
"month",
"day",
"hour",
"minute",
"second"
],
"quarter": [
"quarter",
"month",
"day",
"hour",
"minute",
"second"
],
"month": [
"month",
"day",
"hour",
"minute",
"second"
],
"week": [
"week",
"day",
"hour",
"minute",
"second"
],
"day": [
"day",
"hour",
"minute",
"second"
],
"hour": [
"hour",
"minute",
"second"
],
"minute": [
"minute",
"second"
],
"second": [
"second"
]
},
"hasMultipliedMeasures": false,
"hasCumulativeMeasures": false,
"windowGranularity": null,
"filterDimensionsSingleValueEqual": null,
"ownedDimensions": [
"SnowplowTrackedEvents.derivedTstamp"
],
"ownedTimeDimensionsWithRollupGranularity": [
[
"SnowplowTrackedEvents.derivedTstamp",
"day"
]
],
"ownedTimeDimensionsAsIs": [
[
"SnowplowTrackedEvents.derivedTstamp",
"day"
]
]
},
"requestId": "bc4c4afd-c1a0-4e15-9745-75f4879efa47-span-1",
"annotation": {
"measures": {
"SnowplowTrackedEvents.uniqueUsersCount": {
"title": "Snowplow Tracked Events Unique Users Count",
"shortTitle": "Unique Users Count",
"type": "number",
"drillMembers": [],
"drillMembersGrouped": {
"measures": [],
"dimensions": []
}
}
},
"dimensions": {},
"segments": {},
"timeDimensions": {
"SnowplowTrackedEvents.derivedTstamp.day": {
"title": "Snowplow Tracked Events Derived Tstamp",
"shortTitle": "Derived Tstamp",
"type": "time"
},
"SnowplowTrackedEvents.derivedTstamp": {
"title": "Snowplow Tracked Events Derived Tstamp",
"shortTitle": "Derived Tstamp",
"type": "time"
}
}
},
"dataSource": "default",
"dbType": "clickhouse",
"extDbType": "cubestore",
"external": false,
"slowQuery": false,
"total": null
}
],
"pivotQuery": {
"measures": [
"SnowplowTrackedEvents.uniqueUsersCount"
],
"timeDimensions": [
{
"dimension": "SnowplowTrackedEvents.derivedTstamp",
"granularity": "day"
}
],
"limit": 100,
"timezone": "UTC",
"filters": [
{
"member": "SnowplowTrackedEvents.derivedTstamp",
"operator": "inDateRange",
"values": [
"2023-01-01",
"2023-07-01"
]
}
],
"dimensions": [],
"order": [],
"rowLimit": 100,
"queryType": "regularQuery"
},
"slowQuery": false
}
How to set up and validate locally
- Follow these instructions to setup Product Analytics in GDK. Ensure
product_analytics_snowplow_support
feature flag is enabled. - View the dashboards listing page at Project -> Analyze -> Application Analytics.
- If not already onboarded, onboard Product Analytics by clicking on
set up
and following the onboarding process. - Go back to the dashboards listing page at Project -> Analyze -> Application Analytics.
- Select a dashboard and confirm that given any date range, it fills in the missing dates.
- Run the export query and confirm that it returns JSON with the missing dates filled in.
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #415687 (closed)