How can I see the daily revenue generated by campaign, based on the actual date of the purchase (not the send date)?
I tried using Analytics → Dashboard, and it shows daily revenue, but it’s tied to the send date — so conversions that happen a day later aren’t included in the following day’s total. The same issue happens when I try with a custom report.
Basically, I want to see the revenue that a campaign generated on day X, regardless of whether the email was sent on day X–1.
Has anyone found a way to do this?
Best answer by Byrne C
Hi @RafaelL,
You can pull this information via API using the Query Metric Aggregates endpoint! Our doc here explains how to structure this API call and this one explains how to use the endpoint.
To summarize, the Query Metric Aggregates endpoint is an API call that allows you to pull data for a certain metric, measure by value/sum/unique events, while choosing the date interval and grouping. For example, using this API call, you can request the value of the Placed Order events that happened between 11/1-11/30, by day, and grouping by campaign name. This would provide you with the information that you were looking for.
You can pull this information via API using the Query Metric Aggregates endpoint! Our doc here explains how to structure this API call and this one explains how to use the endpoint.
To summarize, the Query Metric Aggregates endpoint is an API call that allows you to pull data for a certain metric, measure by value/sum/unique events, while choosing the date interval and grouping. For example, using this API call, you can request the value of the Placed Order events that happened between 11/1-11/30, by day, and grouping by campaign name. This would provide you with the information that you were looking for.
