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.