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
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.
We use fallback values, which contains negative numbers for specific use cases.
monthly_metric_valueis a calculated field for all-time counters. The calculation is in prep_monthly_usage_data_all_time.
last_ping_valuewhich is utilized in the
monthly_metric_valuecalculation,is “value from the last ping of the previous month".
original_metric_valueis the value returned in the service ping payload.
Checkout out the Getting started with Product Intelligence.