Rapid Analytics

“GOODBYE, THE TRADITIONAL MARKETING! HELLO, NEUROMARKETING!” ― Hedda Martina Sola M. Econ

Goal

The Goal of the project is to respond to the customers emails faster by prioritising the list of emails received from different customers. It priorities which email to respond first and which is urgent.
Small scale companies can find this very useful for an efficient customer support.
This will help them prioritize and resolve high priority support queries compared to traditional mode of customer email support.

Technical Specifications

WordPress

Creating a webapp to view the dashboard in which the prioritized emails are displayed.

Zapier

To get the emails from Gmail and Outlook 365 and store it into Google Big Query.

Google Big Query

Using the Auto ML model in Big Query to prioritize the emails.

Functionality

Zapier

Zapier is an online automation tool that connects your favorite apps, such as Gmail, Slack, Mailchimp, and more.
Zapier can connect two or more apps and automate repetitive tasks without coding or relying on developers to build the integration
After sign in with google the user have to onetime Authenticate the email permissions using Zapier.

Zapier to connect with gmail and outlook

Here the Gmail is Connected to Big Query to store all the emails in Big Query Database
URL: https://zapier.com/app/editor/105974871/nodes/105974871/auth

Here the Outlook is Connected to Big Query to store all the emails in Big Query Database
URL: https://zapier.com/app/editor/105975199/nodes/105975199/auth

GOOGLE BIG QUERY

The Auto ML in Big Query Prioritizes the emails and present it on the dashboard created on Google Data Studio.
Main actions performed in Big Query
Creating ML model
Viewing ML model
List of Tables in Big Query
Inserting into output