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:
- 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.
- 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.
- 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!