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

Custom Report

1. Make sure your events are sent to Klaviyo as metrics (e.g., task_completed).

2. Include consumer_id as an event property.

3. In Klaviyo → Analytics → Custom Reports:

   • Select the metric (e.g., task_completed)

   • Group by consumer_id

   • Add Count of Events

This gives you:
consumer_id | type (metric name) | count

Metrics Aggregate API

You 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.

Hi ​@vijayk,

This is best done through a custom report. I’d recommend making a Single metric deep-dive report, and choosing the metric that contains the data you referenced above. After that, you can group by any event property that the metric carries over. You can’t group by multiple event properties at a time, so you’d want to make one report by each property you’d like to group by. While I don’t have the same event you have in your account, you could set the report up using this basic structure:

Let me know if this makes sense or if I can help with anything else.