Client Background
Client: A leading Marketing firm in the USA
Industry Type: Marketing
Services: Marketing consulting
Organization Size: 100+
Project Objective
Prepare a daily report for data from Local Service Ads dashboard and email to client.
Project Description
- Extracts data from the LSA dashboard for the last 24 hours.
- The data is sent to the client email in the form of a daily report using SendGrid.
- The script runs every morning and is deployed to Heroku by the name “lead-details-to-email”.
- 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:
- Number of Leads
- Cost Per Lead
- Lead Type
- Dispute amount to be approved
- Dispute amount approved
- Cost per Call
Our Solution
- Use LSA API to extract data.
- Clean the data to make it readable and dispose the data not needed.
- Get the email id of each company from the given Sheet
- Send an email to the client using SendGrid
- Deploy to Heroku
Project Deliverables
A working deployed automated tool that runs everyday in the morning hours and sends a report to the client. Tool is monitored everyday.
Tools used
Heroku
LSA API
SendGrid
Sheets API
Language/techniques used
Python
Skills used
Data extraction, cleaning, and summarising
Databases used
Data is not stored and is sent directly to the client
Web Cloud Servers used
Heroku
What are the technical Challenges Faced during Project Execution
Ensuring a company’s data does not go to another company
How the Technical Challenges were Solved
Testing on multiple dummy email ids