A key challenge in lead generation is proving that campaigns drive real revenue. While tracking clicks, form fills, and calls is straightforward, failing to connect these metrics to closed sales often leaves stakeholders with tough questions.
This guide outlines our process for connecting lead data from Gravity Forms and CallRail to actual revenue. By using Zapier to sync this data with a Google Sheet and importing it into Google Ads as offline conversions, you gain clear campaign-level visibility. These insights allow for better campaign optimization and improved client retention. This method is ideal for agencies and in-house teams managing lead generation for clients without a dedicated CRM, providing a direct link between ad spend and closed deals.
Why Standard Conversion Tracking Isn’t Enough
Generating high-quality leads is only half the battle; without visibility into their actual value, you’re flying blind.
For instance, a display campaign that appeared to be underperforming with a cost-per-conversion of over $200 would typically be a candidate for budget cuts. However, layering in revenue data revealed that this campaign was actually driving the account’s highest revenue.
By targeting affluent areas, it consistently generated large, high-value jobs that standard conversion metrics missed—an insight that saved the campaign from being paused.
Campaign-level revenue visibility unlocks several key benefits:
- Precise attribution: Identify exactly which campaigns, ad groups, and keywords drive actual revenue, rather than just clicks or conversions.
- Confident optimization: Make budget decisions backed by verifiable closed-deal data.
- Demonstrated value: Prove the ROI of paid advertising to clients who previously lacked clear performance metrics.
- Improved efficiency: Identify and correct underperforming campaigns before wasting budget on low-quality leads.
What You’ll Need Before You Start
Before building the Zapier pipeline, you’ll need the following in place:
- Google Ads account
- Gravity Forms or a similar form plugin on your website
- CallRail (optional, but recommended for tracking phone call leads)
- Zapier account
- Google Sheets
The one non-negotiable step is capturing GCLID (Google Click ID) data. This unique identifier is assigned to every click from Google Ads, and it’s what lets you tie a closed deal back to the exact campaign, ad group, or keyword that generated the lead.
Setting up GCLID capture on your website requires a developer and typically takes three to four hours depending on your form setup. Gravity Forms makes this relatively straightforward.
Step-by-Step: Building the Zapier Revenue Tracking Pipeline
Step 1: Connect Your Lead Sources to Zapier
Set up Zaps that trigger whenever a new form submission comes in via Gravity Forms, or a new call is logged in CallRail. Both platforms have native Zapier integrations. Each Zap should push a new row into your Google Sheet automatically.
Step 2: Configure Your Google Sheet With Two Tabs
Create one tab for form fills and one for calls. Both tabs should capture the following for each lead:
- Contact info
- Submission date and source URL
- UTM campaign parameters
- GCLID (Google Click ID)
- For calls: recording link, call duration, and marketing source (Google Ads, organic, Google Business Profile, etc.)
Step 3: Have the Sales Team Add Closed Revenue
This is the only manual step in the process, and it’s a light one. When a sale closes, a salesperson finds the matching row in the sheet by name, address, or phone number, and enters the revenue amount.
Establishing a regular cadence (for example, every Tuesday) helps build the habit. The sales manager should own accountability here. If the sales team is difficult to engage, consider scheduling a brief monthly review meeting to go through the sheet together.
Important note on sales cycle length: Google Ads only accepts offline conversion uploads within 90 days of the original click. If your client has a sales cycle longer than 90 days, the revenue data in the sheet is still valuable for internal reporting and client retention conversations, but it won’t feed back into Google’s bidding algorithm.
Step 4: Upload Revenue Data to Google Ads as Offline Conversions
Once per week, export the rows with revenue data and their corresponding GCLIDs into the Google Ads offline conversion upload format.
Upload this file in Google Ads under Tools → Conversions → Upload.
Google will match each GCLID to the campaign that drove it and populate a conversion value – which previously showed as zero. You can now see revenue, ROAS, and return broken down by campaign, ad group, and even individual keywords.
Step 5: Use the Data to Optimize and Report
Now you can have real conversations about budget allocation. Build a running ROAS summary tab that tracks total ad spend against total attributed revenue month over month. Share this with clients during reporting calls–it’s one of the most effective retention tools available for lead gen accounts.
Use the data to answer questions like:
- Which campaigns are generating the most revenue?
- Which geographies have the highest average order size?
- Which keywords are actually leading to closed deals?
Bonus: Geographic and Lead Quality Analysis
Beyond ROAS, the spreadsheet becomes a rich data source for segmenting performance by zip code and county. Average order size by geography is particularly useful for informing geo-targeting decisions – if one county consistently converts at $100K or more per job, that’s where you increase coverage and test new ad formats.
You can also add a lead quality rating column where the client’s team scores incoming leads on a 1–10 scale. This helps identify when certain campaigns – particularly Performance Max or broad display – are generating bot traffic or low-intent submissions, so you can make informed budget and exclusion adjustments before money is wasted.
When to Recommend a CRM Instead
The Zapier approach works well for clients who don’t have – and don’t want to invest in – a CRM. But if a client is ready to move up, platforms like HubSpot or Salesforce offer clear advantages:
- Real-time syncing – no manual weekly uploads
- Multi-touch attribution across all channels
- Customer lifetime value tracking for repeat buyers
- Reduced human error in revenue reporting
- Granular reporting on the full customer journey from first click to close
The tradeoff is cost and implementation complexity. For smaller clients who aren’t ready for a CRM investment, the Zapier pipeline is the right starting point.
Is This Right for Your Client?
This setup works best for service businesses that:
- Generate leads online (e.g., through form fills and/or phone calls)
- Don’t have an existing CRM
- Have an average deal size large enough that even a few closed sales provide clear performance insights.
This process is a natural fit for home services, construction, specialty contractors, and B2B service providers. If you’re pitching a client frustrated by a lack of transparency from their previous agency, this system serves as a powerful differentiator. Being able to demonstrate that you can track revenue directly back to the specific keywords that generated the lead changes the entire conversation—moving the focus from vanity metrics like impressions and click-through rates to actual business results.
Start Tracking What Actually Matters
The Zapier revenue tracking pipeline eliminates guesswork from lead generation. Instead of speculating on campaign performance, you gain precise insights down to the campaign, ad group, and keyword level, showing exactly where revenue originates.
Ready to implement this for your clients? Contact our PPC team to set up your Zapier revenue tracking.