Skip to main content
Solved

Export List of Order IDs


Forum|alt.badge.img

I need help figuring out how to export a list of order IDs, attributed revenue, and the campaign name tied to that order. I can currently find some of this info three ways, but each of these methods either don’t provide all the data fields I’m looking for, yield incomplete data, or are challenging to extract.

In a perfect scenario, I’d be able to download a CSV file that at least gives me the order ID and the revenue value, but adding the campaign name/ID too would be so, so great.

Current methods with limitations:

  1. Metrics > Purchase — Set my date range, then assign the filter value as “BY” OrderID, and the measurement set to “Value.” However, whenever I export the CSV file, no matter which timeframe I set in the date range, I can only view 25 orders at a time. Also can’t view the campaign info.
  2. Create a single metric deep dive report with purchase value as the metric and OrderID as the group. This would be perfect, except it’s missing the campaign name. I tried setting it up with a new multi-metric report, but grouping/filtering by OrderID is not an option in that view.
  3. I can go into each campaign individually and use the customer’s email address to look up the OrderID in our CRM system, and manually pull the data into a spreadsheet — which is effective but extremely time-consuming.

Thank you!

Best answer by chloe.strange

@Alicia_T, I’ve submitted this request on your behalf. Thank you for the feedback!

~Chloe

View original
Did this topic or the replies in the thread help you find an answer to your question?

2 replies

ArpitBanjara
Principal User I
Forum|alt.badge.img+36
  • Principal User I
  • 371 replies
  • January 16, 2025

Hey ​@Alicia_T 

All your approaches are correct,  however yes, those are the limitations that klaviyo has. I am sure ​@stephen.trumble , ​@kaila.lawrence ​@chloe.strange would be able to forward this to their tech team as feature request? or please let them know if there is any other way to add campaign name to their reports?

Thanks
Arpit


chloe.strange
Community Manager
Forum|alt.badge.img+41
  • Community Manager
  • 425 replies
  • Answer
  • February 4, 2025

@Alicia_T, I’ve submitted this request on your behalf. Thank you for the feedback!

~Chloe