how to create custom report using event attributes and make use of metrics and group by.

Question

Hi,We have klaviyo events such as this on every profilecreated_at: 2025-11-24T21:36:41.084Zinitiated_by_user_id: nulltype: task_completedid: 15303601target_type: Taskenvironment: productionconsumer_id: ed42321a-d65f-4794-9bbf-1a2cb79e76edtarget_id: 9ec15878-3395-4427-a18e-e49b58cdf673updated_at: 2025-11-24T21:36:41.084Zi want to create an report for the following  select consumer_id, type, count(*) from all events  group by consumer_id, typei tried going through the documentation for custom report using metrics https://help.klaviyo.com/hc/en-us/articles/360046242952  and also the documentation for using metrics aggregate apis https://developers.klaviyo.com/en/docs/using_the_query_metric_aggregates_endpoint  but could not find any hints that will help to solve my reporting requirements.how to achieve this via custom report , could you share some samples or create a example report in our  customer reports and share details.  also could you share how to make use of metrics aggregate api endpoint and create the same report.   Thanks

talha.hussain · Answer

Custom ReportMake sure your events are sent to Klaviyo as metrics (e.g., task_completed).Include consumer_id as an event property.In Klaviyo → Analytics → Custom Reports:Select the metric (e.g., task_completed)Group by consumer_idAdd Count of EventsThis gives you:consumer_id | type (metric name) | countMetrics Aggregate APIYou must query one metric at a time:Request:{  "data": {    "type": "metric-aggregate",    "attributes": {      "metric_id": "YOUR_METRIC_ID",      "interval": "all",      "by": ["consumer_id"],      "measures": ["count"]    }  }}This returns counts grouped by consumer_id.To mimic your SQL, run this once per event type (metric) and combine results.

Metrics Aggregate API

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials

Scanning file for viruses.

This file cannot be downloaded