Relational reports from disparate sources:  Business Use case

1)  The reports on amazon associates affiliate site do not provide an amazon Seller Order ID: # XXX-XXXXXXX-XXXXXXX

2)  The amazon associates affiliate reports do provide a time/date stamp for when the order was placed. 

3)  the amazon associates affiliate report contains a sales order time stamp for the conversion:   Date YYYY-MM-DD HH:MM:SS

4)  The amazon associates affiliate report and the amazon seller central Sales order data contain the duplicate record fields:  Sales amount, and Product Description.  

5)  I would like to use zoho analytics to obtain the amazon associates affiliate report details, and amazon seller central sales order data for the purpose of triangulating the sales orders associated with the affiliate conversions.   The sales order ID is also time stamped, but there is a disparity between the two orders of 2-3 minutes.   I would like to triangulate the sales amount, product description and use some logic to say if the order was time stamped on the two systems within +/- 3 minutes of each other that the Sales Order is related, tagged, or otherwise as the sales order ID referenced/related in amazon seller central.

6)  If we use the above amazon info and combine that with any other informatics such as google analytics, zoho social, zoho campaigns, etc.... we can combine the information from various and disparate sources to evaluate and rank marketing spend for the purpose of comparing influencers, various landing pages, effectiveness of design, effectiveness of campaigns, graphic design, social media channel, etc... to evaluate ROI and guide future marketing efforts, etc...