Client Background

Client: A leading Marketing firm in the USA

Industry Type:  Marketing

Services: Marketing consulting

Organization Size: 100+

Project Objective

Prepare an annual report for the companies and upload it to database. Data is from callrail and contains call analytics.

Project Description

  • Extracts data from CallRail database for the last 1 year.
  • The data is uploaded to BigQuery database “lead_report_alert_callrail”
  • The script runs once a year and is deployed to Heroku by the name “lead-report-alert”.
  • Currently, the script is programmed to run for only 2 companies (on a trial basis) – Capital Law Firm and Wilshire Law Firm.
  • The following data is uploaded:
    • Company Name
    • No. of calls answered
    • No. of calls missed
    • No. of calls abandoned
    • No. of calls to voicemail
    • Total Calls

Our Solution

Use CallRail API to get data from database.

Set time window to be one year.

Filter out excess data

Prepare report

Upload to BigQuery

Project Deliverables

A working deployed automated tool that runs once a year in the morning hours and uploads the data to BigQuery. Tool is in prototype phase and hence is operational for 2 companies.

Tools used

Heroku

CallRail API

BigQuery

Language/techniques used

Python

Skills used

Data extraction, cleaning and summarising

Databases used

BigQuery –  lead_report_alert_callrail

Web Cloud Servers used

Heroku

What are the technical Challenges Faced during Project Execution

Working on a large amount of data since a year’s data contains hundred of thousands of records

How the Technical Challenges were Solved

Optimized code for faster processing.