Client Background

Client: A leading Marketing firm in the USA

Industry Type:  Marketing

Services: Marketing consulting

Organization Size: 100+

Project Objective

A real time tool to send a report of missed calls and messages to the client.

Project Description

Extracts data from CallRail database for the last 5 minutes

  • All the calls which are marked as “missed” and all messages in the data are sent in the form of a report to the client.
  • The script runs every 5 minutes and is deployed to Heroku by the name “missed-messages”.
  • The data is collected only for the companies that are not marked in red in the “Missed Messages Notification Automation – Master File” sheet.
  • The following data is uploaded:
    • Company Name
    • Date
    • Time
    • Customer Name
    • Contact No.
    • Customer Location
    • Call Type
  • In case of messages:
    • Company Name
    • Date
    • Time
    • Customer Name
    • Contact No.
    • No. of messages
    • Direction (Inbound/Outbound)
    • Content

Our Solution

To provide data real time, schedule the tool to check for data every 5 minutes.

Extract data from CallRail

Filter out all answered calls

Prepare report

Get email ids from sheets

Send email through SendGrid

Project Deliverables

An automated tool which provides real time updates to the client along with all information about the call.

Tools used

Heroku

CallRail API

SendGrid

Sheets API

Language/techniques used

Python

Skills used

Data extraction, cleaning and summarising

Databases used

Google Big Query

Web Cloud Servers used

Heroku

What are the technical Challenges Faced during Project Execution

Sending correct reports only to the companies which are active

How the Technical Challenges were Solved

Using Google Sheet’s cell formatting in Python