Campaign support team or consultants

below is a real business case that we are struggling to resolve.  This is a great opportunity to interact and automate the capture of information for the customer and disseminate/automate data propagation throughout our organization.  In this specific business use case we seek to Learn product attributes that are not resonating with the customers or discern logistical/distribution issues where our 3PL provider is not meeting their SLA.  In any event there are a number of root cause evaluations we can perform down stream by gathering additional data from the customer.  FYI, The above is as important as a dropped cart campaign.  The below use case can truly demonstrate the power of zoho one.  Particularly if we can make the workflow and process automation easily deployed by the zoho one end user.  

We occasionally get a customer whom returns a product.  

A return notification email is received in our zoho mail account from our sales channel, amazon.

The email contains the following record fields in the header:  

“Refund initiated for sale order ID xxxx-xxxxxxx-xxxxxxxxxx”

body of the email: sales order ID, dollar amount of refund, customer First name, customer last name, number of units returned, product name, reason for customer return

“We have initiated a refund in the amount of $25.99 to FName LName for the following items:

Order 111-xxxxxxx-xxxxxxx

Quantity Order Item Refund Reason

1 Xxxxxxxxxxxxxxxxxx   Customer Return

We will adjust your seller account accordingly.”

We are a zoho one subscriber: zoho books, zoho inventory, zoho crm, zoho campaign, social, etc...

Our goal:  initiate a campaign that works throughout the zoho ecosystem of apps and creates value for our org and the customer

1) add the customer to a list in zoho campaign

2) automate a template email containing a a zoho form to collect specific data and provide the person the ability to respond so that we can complete a root cause analysis for the return. 

3) monitor the customer for negative/positive social media feedback or posts using zoho social

4) monitor for negative product reviews on our product page on the sales channel.  

5) automate the creation a credit invoice in zoho inventory

6) tag the customer in zoho crm with A tag “returned product”

7) initiate a specific bot chat script if the customer returns to our website following the return of the product

8) monitor for the physical return of the product and automate the physical inventory adjustment for the returned units.  

The business case starts in a similar manner to a dropped cart the campaign Which can be initiated through a email notification from your shopping cart provider.  

I am sure while a complex solution might be needed the use case and resulting solution would be quite valuable to the community as we all face similar issues to the above.  A solution to the above can be used to learn to build a number of future solutions.  

I look forward to your response or how we can work together and share the solution with my fellow community members.