We need updates made to our marketing comparison script which use 2 MS SQL stored procedures and a MySQL database. The script currently compares our marketing mailing lists to our order entry system and gives us a count of matches based on the matching of Street address, zip code and last name.
The new version of this system should take these matching names and then filter the results down based on:
1. The date of order being greater then the start date of the campaign.
2. Must contain a product from the mailing list (matching order must be for the product included in the mailing list to which the order has been matched).
The output results will remain the same as they are now, which is by campaign name or by mailing list name Once the bid is awarded I will give the winner specific tables and fields to find the data points needed for these comparisons.
We are a full service software development studio. Our Jr. Engineers can update your old script very easily and deliver to you a 100% guaranteed new deliverable with any required revisions.