📋Project Description.

• Developed a comprehensive SERP tracking system for a leading F&B brand to monitor SEO and ad performance on Google Search.
• Automated keyword and competitor data collection, providing visibility into ranking trends and ad placement effectiveness.
• Built reliable ETL pipelines with Apache Airflow and BigQuery for data processing and integration.
• Designed interactive dashboards in Looker Studio to visualize performance metrics and drive smarter SEO and advertising decisions.
• Enabled data-driven marketing strategies through real-time insights on visibility, competition, and campaign impact.

🖼️Screenshot Dashboard.

(Note: Screenshot dahsboard partially blurred to maintain client confidentiality)