original_metric_value
and monthly_metric_value
?Most SiSense models you can query do not include Snowplow tracking events from the staging environment. This ensures that all events you see are production events, and your dashboards and metrics are not skewed by staging events. Staging Snowplow events can be
queried from prod.legacy.snowplow_staging_unnested_events_30
table. Example query:
select *
from prod.legacy.snowplow_staging_unnested_events_30
where collector_tstamp >= DATE('2022-03-20')
order by collector_tstamp desc
It is not yet possible to add aggregated metrics due to differences in the implementation of the underlying algorithms for each of data sources. Issue 357577 outlines the work required in order to add this feature.
There is an API endpoint, see more details in the documentation
The feature flags for Redis HLL metrics are optional and we recommend them to be used for performance reasons.
The Copy query to clipboard feature from Metrics Dictionary, generates the query ready to be run in Sisense.
We use fallback values, which contains negative numbers for specific use cases.
original_metric_value
and monthly_metric_value
?monthly_metric_value
is a calculated field for all-time counters. The calculation is in prep_monthly_usage_data_all_time.
last_ping_value
which is utilized in the monthly_metric_value
calculation,is “value from the last ping of the previous month".original_metric_value
is the value returned in the service ping payload.Checkout out the Getting started with Analytics Instrumentation.
You can use the VersionApp UI to manually upload a Service Ping payload.