Trace organic search to revenue and pipeline

This is the question a dedicated SEO tool cannot answer, because the answer lives in three systems: what people searched for (Search Console), what they did on the site (GA4), and what they paid or became (HubSpot, Stripe). Joining them is what makes an SEO number a business number.

Steps

1. Pick the revenue path. Self-serve or ecommerce: revenue is in GA4 (path A). Sales-led B2B: pipeline is in HubSpot (path B). Both can be true; run both and keep them separate. Ask which applies if it is not obvious.

2. Pull the organic side. google_search_console.query with dimensions: ["page"] over 90 days ending 3 days ago, rowLimit: 500, and again with dimensions: ["query", "page"], rowLimit: 5000. Ninety days, because the path from search to money is longer than the path from search to click.

3. Path A: revenue in GA4. google_analytics.run_report with dimensions: ["landingPage"], metrics: ["sessions", "conversions", "totalRevenue", "ecommercePurchases"], the same dates, dimensionFilter on sessionMedium EXACT organic. Join to Search Console on the normalised path. Compute revenue per organic click per page.

4. Path B: pipeline in HubSpot. First hubspot.list_properties for contacts and for deals to find the analytics source and first-page fields. They are usually hs_analytics_source, hs_analytics_first_url and hs_analytics_source_data_1, but accounts differ; do not hardcode. Then:

   • hubspot.search_contacts with a filterGroups entry for the source property EQ ORGANIC_SEARCH and createdate within the window, requesting properties for email, create date and first URL. Group contacts by the path of their first URL and join to Search Console pages. This gives leads per organic page.
   • hubspot.list_pipelines for deals to learn which stage ids mean closed won. Then hubspot.search_deals filtered to the organic source and closed won within the window, requesting amount, close date and the first-URL property if deals carry one. This gives revenue from organic at the account level even when deal-to-page attribution is missing. Page through with after until exhausted; a partial pull silently understates everything.

5. Stripe or Dodo Payments, only if attribution was captured. A payment provider has no idea where a customer came from unless the checkout stored it. Ask whether UTM or referrer values are written to customer, subscription or payment metadata. If they are, stripe.search with a metadata query on the organic value gives revenue directly. Dodo returns metadata on every row of dodo_payments.list_payments but cannot filter on it, so pull the window with status: "succeeded" and filter the metadata column in the workbench. If nothing was captured, skip this step and say so rather than guessing.

6. Attribute queries. For the top revenue pages, take their query rows from step 2 and report the queries as the demand behind the revenue. This is query-to-page-to-revenue, not query-to-revenue; keep that distinction in the write-up.

7. Report. Top ten organic pages by revenue or pipeline: page, clicks, sessions, conversions or contacts, revenue or closed-won amount, revenue per click, and the top three queries behind it. Then the share of total revenue or pipeline that organic accounts for, pages with real traffic and no revenue, and the one or two queries most worth defending. Keep GA4 revenue and HubSpot revenue in separate columns; never add them.

Gotchas

• Different systems attribute differently. HubSpot's source is first touch by its own tracking cookie; GA4's is session-scoped and defaults to last non-direct click. Present each as what it is. Adding them double counts.
• GA4 revenue requires ecommerce events. If totalRevenue is zero everywhere, the site is not sending purchase events; that is a tracking gap, not zero revenue.
• HubSpot's ORGANIC_SEARCH is HubSpot's classification, based on referrer, not on Search Console. It includes all search engines and misses visitors whose referrer was stripped.
• Sales cycles outlast the window. A deal closed this quarter came from a search last quarter. Use the contact's create date for lead attribution and the close date for revenue, and say the windows differ.
• Stripe amounts are in minor units (cents). Divide by 100 once, and report per currency.
• Join on the path. Strip origin, query string and trailing slash from Search Console, GA4 and HubSpot URLs before joining, and report the unmatched share.