Client Background

Client: A leading IT & tech firm in the USA

Industry Type: IT

Products & Services: IT Consulting, IT Support, SaaS

Organization Size: 200+

The Problem

Create a ROASing dashboard to fetch google ads budget spent data using google ads api(campaign-wise). The challenge is to develop a ROAS (Return on Ad Spend) dashboard that efficiently retrieves and displays Google Ads budget spent data on a campaign-wise basis using the Google Ads API. The current system lacks a streamlined method for tracking and analyzing ad spend across various campaigns, leading to difficulties in assessing performance and optimizing budget allocation. The goal is to create a comprehensive dashboard that accurately fetches and visualizes budget data, enabling more effective analysis and decision-making. This involves integrating with the Google Ads API, ensuring data accuracy, and providing clear, actionable insights for better campaign management.

4o mini

Our Solution

  1. Get Data source access
    a. Google ads accounts
  2. Get Access to google cloud platform
    a. Bigquery
    b. VM
  3. Setup Google Big Query Data warehouse
  4. Design db schema / models
  5. Develop Python ETL tool to pull data from source and save it to the data warehouse
  6. Deploy ETL tool to VM and run it as cron to update data at db frequently
    a. Check frequency to run
    b. Recommended 3 to 6 times a day
    c. The ETL tool should run automatically at the set intervals and update the db
    d. Add slack integration module for notifications on Cronjob failure
  7. Get Design Access of the Dashboard
  8. Implement the Dashboard
    a. Use Vuexy React Template
    b. List KPI to display in UI
    c. List Charts to display in the UI
  9. Implement Backend API needed to build the dashboard

Solution Architecture

https://drive.google.com/file/d/1ygYpSWiOQnREeOMAn4Zk5taNbWv8eaN8/view?usp=sharing

Deliverables

ETL Tool

Dashboard

Documentations

Source codes

Support and Maintenance

Tech Stack

  • Tools used
  • VS Code
  • Digital Ocean
  • Language/techniques used
  • Python
  • Google Big Query
  • Google Cloud Platform
  • Google Ads
  • API
  • React.js
  • Node.js
  • Github
  • Models used
  • Python libraries (Pandas) 
  • Skills used
  • Data Scientist
  • Full Stack developer 
  • Databases used
  • MySQL
  • Web Cloud Servers used
  • Digital Ocean

What are the technical Challenges Faced during Project Execution

Getting the Google Ads campaigns data

How the Technical Challenges were Solved

Used the google Ads APIs

Project Snapshots

Project website url

https://roasing.com

Summarize

Summarized: https://blackcoffer.com/

This project was done by the Blackcoffer Team, a Global IT Consulting firm.

Contact Details

This solution was designed and developed by Blackcoffer Team
Here are my contact details:
Firm Name: Blackcoffer Pvt. Ltd.
Firm Website: www.blackcoffer.com
Firm Address: 4/2, E-Extension, Shaym Vihar Phase 1, New Delhi 110043
Email: ajay@blackcoffer.com
Skype: asbidyarthy
WhatsApp: +91 9717367468
Telegram: @asbidyarthy

RELATED ARTICLESMORE FROM AUTHOR