Skip to content

Marketing attribution data for Looker reporting

If you want Looker to show which channels, campaigns and ads produce leads, customers and revenue, the attribution details first need to be captured on your site and stored with each lead.

This page explains a form-to-CRM workflow that makes that data available for Looker reports.

Why attribution needs to travel with the lead

Looker reports are only as useful as the data connected to them. When attribution fields travel with a lead from the first visit through form submission and into the CRM, Looker can break results down by the source that created the opportunity. Without those fields, reports tend to show totals without explaining which marketing activity produced them.

How the workflow works

Start by adding hidden fields to the lead forms visitors submit. Those fields are not typed in by the visitor; they are there to receive values automatically. Next, the attribution tool monitors the marketing channel a visitor arrived from and completes the hidden fields with that information. When the form is submitted, the channel, campaign name, ad name and related details are passed into the CRM alongside the lead's other details. Finally, with the CRM connected to Looker, you can build reports showing which channels, campaigns and ads are driving leads, customers and revenue.

What information you get

Channel data identifies the broad source, such as Paid Search, Paid Social or Organic Search, and can add channel-specific detail. For Paid Search, that detail may include campaign, ad group and keyword. Landing-page data records the first page the lead sees and the category of that page, such as a blog. Together, channel and landing-page fields let you compare both where traffic came from and where it first landed.

Checklist for a reliable Looker report

Use this checklist before building reports: confirm every lead form has the hidden fields; submit a test lead from a known campaign and check the values in the CRM; confirm the CRM is connected to Looker; then build a report grouped by channel, campaign and ad, and a second view grouped by landing page. If a test lead arrives with blank attribution fields, fix the form or capture step first rather than adding more Looker charts.

Getting started

Before you commit to a plan, check the current pricing, any trial length and the signup route directly with the provider, since these commercial terms can change. A practical way to evaluate fit is to run the form-to-CRM workflow on a small set of lead forms first, confirm that channel, campaign and landing-page values arrive correctly in the CRM, and only then decide whether the reporting value justifies the cost for your team.

Attribution fields to check in the CRM
Field groupWhat it recordsUse in Looker
Channel dataBroad channel plus campaign, ad group and keyword detail where applicableCompare lead, customer and revenue volume by source
Landing-page dataFirst page seen and its categorySee which entry pages convert by channel
CRM lead recordAttribution values submitted with the formJoin attribution to downstream lead and revenue outcomes

Exact field names and form controls are governed by protected module form-controls-contract; do not infer additional fields.

Frequently asked questions

Does Looker capture attribution data on its own?

Looker itself does not capture the visit. The workflow described here captures channel and landing-page details on the website, passes them through a form into the CRM, and then uses the CRM connection in Looker for reporting. If the CRM fields are missing or the form does not submit them, Looker will have nothing to report.

What detail is captured for a channel such as Paid Search?

Channel-level detail can include the campaign, ad group and keyword for Paid Search, alongside broader channel labels such as Paid Social and Organic Search. The exact fields available depend on the form and CRM setup in use.

What landing-page information is stored?

The landing-page record includes the first page a lead sees and the category of that page, for example a blog page. That lets you separate where a visitor arrived from the channel that brought them.