Our client has a leasing business across the United States, providing various retail products like clothing, gadgets, electronic home appliances, and other essential healthcare/beauty needs to customers.
We built a custom event-based mobile application that transferred event-level customer information to the purpose-built PostgreSQL database. The data from the PostgreSQL database was then consumed using a custom-built API that produced JSON events. To flatten the JSON data, we leveraged Azure Synapse and extracted the most recent customer record of each session from the database. Customer data was cleansed to standardized values relating to City, State, and Age Groups.
We also identified the products that the customers showed interest in based on each session mapping before it lapsed. The customers were filtered and segmented into different categories based on Age, Gender, Income Category, Historical Significance, Product Interest, and Lease Threshold Status.
To monitor the Lead generation results and evaluate campaign performances, we leveraged Power BI to create business intelligence dashboards and focused on identifying high-value leads coming from different segments of audiences (Age, Location, Payment frequency, and gender). These Leads were broken down further to assess and identify detailed information about each customer with the number of leases available, product interest, and potential approval amounts.
We implemented a marketing dashboard for targeting the customers who showed interest in marketing campaigns and evaluated the response through bounce rates, clicks, and repeated visits. This enabled target marketing and helped the client’s sales team to reach the target customers specifically.
For enabling effective targeted marketing campaigns, the segmented customer information was exported as CSV to Salesforce through a common FTP server. Various campaigns targeting the customers were run and the results were sent back to the Azure Data platform through the aforementioned FTP server. With this two-way sync downstream Salesforce, the client was able to get insights on recommendations with more personalized notifications for the customers, products the customers showed interest in, and suggestions for leasing discounts & coupons. Further, these details with highly personalized notifications with relevant offers and discount coupons were consumed by the front-end application and displayed to customers through the UI of the app. The end users received notifications for this.
Have a similar use case and want to resolve it immediately to attain business growth? Let’s talk and discuss how we can help!
Call Us : +1 732 737 9188
Email Us : email@example.com
Book a Demo
Connect with our experts!
+1 732 737 9188