Matomo Integration

Getting Started

TBD

Set Up Your Site

TBD

Appendix

Query Results using Azure Data Explorer

Summary

xdr_matomo_events(startofday(ago(7d)), startofday(now()))
| where idsite == 39
| where server_time >= startofday(ago(7d))
| where server_time < startofday(now())
| summarize count() by startofday(server_time)

Pageview (w/ outlinks)

xdr_matomo_events(startofday(ago(7d)), startofday(now()))
| where idsite == 39
| where not (custom_url == "" and outlink_url == "")
| project server_time, custom_url, outlink_url

Tracking Events

xdr_matomo_events(startofday(ago(7d)), startofday(now()))
| where idsite == 39
| where custom_url == ""
| where outlink_url == ""
| order by server_time, idvisitor
| project server_time, idvisitor, event_category, event_action, event_name, custom_dimension_1