Create sales reporting records from qualifying ecommerce orders

Collab sales arrive unstructured, leaving campaign managers unclear on product revenue and partner splits. Capture qualifying orders into a central reporting table so managers have accurate revenue rows before month end.