HubSpot Google Ads Reporting Setup

Summary
Project Overview
We need an experienced HubSpot professional to build a custom weekly performance report that tracks our Google Ads campaigns using UTM parameters and calculates cost-per-lead metrics based on actual leads in HubSpot.
What We Need
Current Situation:

20+ active Google Ads campaigns running (Search & PMAX)
Each campaign has unique UTM content tags (e.g., campaign_name_1, campaign_name_2)
Leads are flowing into HubSpot with UTM tracking
We manually track ad spend weekly
We need automated reporting showing Raw Leads, Funded Leads, Cost, and CPL by campaign

Deliverables:
1. Custom Properties Setup

Create necessary custom properties for campaign tracking and lead classification
Set up proper field mapping from UTM parameters

2. Workflows Creation

Workflow to automatically tag contacts with campaign names from UTM data
Workflow to identify and mark "Funded Leads" vs "Raw Leads"
Any additional automation needed for accurate tracking

3. Weekly Reporting System

Custom HubSpot report showing:

Campaign name
Raw lead count
Funded lead count
Total cost
Cost per raw lead
Cost per funded lead


Table format with date range filtering
Automated weekly email delivery

4. Cost Data Integration

Process for importing weekly Google Ads spend data (CSV or API integration)
Documentation on how to update costs weekly

5. Dashboard Creation

Add report to a dashboard with additional relevant metrics
Clean visualization for executive review

6. Documentation & Training

Step-by-step documentation of the setup
30-minute screen recording or live call to walk through the system
Instructions for weekly maintenance

Required Skills & Experience:

✅ Proven experience with HubSpot CRM (please share portfolio)
✅ Custom HubSpot reporting and analytics
✅ HubSpot workflows and automation
✅ Understanding of UTM tracking and Google Ads metrics
✅ Experience with marketing attribution and performance reporting
✅ Bonus: Google Ads API or integration experience

Project Details:

Timeline: 5-7 days
Budget: $[Your budget] - please provide your quote
Communication: English, responsive communication via Upwork
Access: We'll provide HubSpot admin access and campaign details

To Apply, Please Include:

Your relevant HubSpot experience (certifications, years of experience)
Examples of similar reporting projects youve completed
Your proposed approach to this project
Estimated timeline
Your rate and total project cost
Any questions about the project

Example Output:
We need a weekly report table that looks like this:
See attached pic.
We need this data automatically generated in HubSpot weekly based on UTM tracking and imported cost data.

Looking forward to working with a HubSpot pro who can deliver a clean, automated solution! Please start your proposal with "HubSpot Reporting Expert" so I know youve read the full brief.