◾Smartico DWH \ System views

dwh_ext_xxx.dm_event_type

List of event types used for triggering real-time campaigns and tracking user activities.

Column	Type	Description
event_type_id	INT64	Unique identifier for the event type
event_type_name	STRING	Internal name of the event type
event_type_uiname	STRING	UI display name of the event type
product_id	INT64	ID of the product this event type belongs to
tracks_mau	BOOL	Indicates if this event type tracks Monthly Active Users
create_date	TIMESTAMP	Date and time when the event type was created
update_date	TIMESTAMP	Date and time when the event type was last updated

dwh_ext_xxx.j_events_stats_daily

Events stats daily, aggregated by event type and user. Updated every hour. Can be joined with dm_event_type table that contains event_type_name. Note that event_type_name from dm_event_type corresponds to the table with prefix 'tr_', for example 'tr_acc_deposit_approved'.

Column	Type	Description
event_date	TIMESTAMP	Event date, truncated to day
event_type_id	INT64	Event type ID
user_id	INT64	Smartico user ID
cnt	INT64	Count of events during the day

dwh_ext_xxx.j_events_stats_hourly

Events stats hourly, aggregated by event type and user. Updated every hour. Can be joined with dm_event_type table that contains event_type_name. Note that event_type_name from dm_event_type corresponds to the table with prefix 'tr_', for example 'tr_acc_deposit_approved'.

Column	Type	Description
event_date	TIMESTAMP	Event date, truncated to hour
event_type_id	INT64	Event type ID
user_id	INT64	Smartico user ID
cnt	INT64	Count of events during the hour