HI folks, I am trying to calculate Revenue for the Placed Order metric using metric aggregate endpoint but it seems that the results are not matching with klaviyo dashboard metrics.

For reference, I am using this request structure:
 

{
     "data": {
          "type": "metric-aggregate",
          "attributes": {
               "measurements":  
                    "sum_value"
               ],
               "filter":  
                    "greater-or-equal(datetime,YYYY-MM-DDTHH:MM:SS),less-than(datetime,YYYY-MM-DDTHH:MM:SS)"
               ],
               "by":  "$attributed_message"],
               "interval": "INTERVAL (hour,day,week,month)",
               "timezone": "TIMEZONE",
               "metric_id": "PLACED_ORDER_METRIC_ID"
          }
     }
}

I have looked into the Reporting API. The results are accurate to the decimal points but it has strict daily rate limits and data is not in an interval based breakdown (“day” based breakdown is desirable in my case). So is there any other way I can achieve this? Maybe manually aggregate data from events? but then I don’t see how I can relate the events data to campaigns.