Hi, all. I'm still learning my way around the database via SuiteAnalytics Connect. I'm trying to build a query where I can pull up orders that were entered using a particular marketing promotion. I see the promotion in the PROMOTION_CODES table, and I see that there is a line item called "Marketing Promotion" on one of the affected orders. However, I cannot figure out how to identify on a particular order what promotion or promotions were applied.
How can I write a query that identifies orders placed using a particular marketing promotion?