To correctly model the impact marketing campaigns have on sales, all of the sales data is needed from the CRM and this needs to be tied into the marketing campaigns currently active and that recently ended. To truly evaluate the marketing campaign, some measure of the reach of the campaign is needed. This reach data may be from Digital Ads platforms or web analytics databases, or it may be necessary to incorporate measures of how many unique views a billboard or television ad received. As the region the campaign was run is important, external data including regional demographics and economic information is needed. For physical products, data about how widely available the product was in the market is needed. Finally, as competitive marketing and sales will impact your sales, information about this activity should be sourced. All this data needs to be cleaned, joined and transformed into valuable ML features before going into model training. This pre-modeling prep process can be frustrating and time consuming. We are here to help.