Skip to content

Track affiliate leads and customers in Sugar CRM

If you cannot see which affiliates create leads, customers and revenue, you cannot judge whether the programme earns its keep. This guide shows a practical UTM-to-form-to-CRM flow that records affiliate type and individual affiliate on every Sugar CRM lead, then turns those fields into three decision-ready reports.

1. Tag every affiliate link with a consistent UTM pattern

Start with the links you give affiliates. Each link needs UTM parameters that separate three levels: the programme, the kind of affiliate, and the specific affiliate. A workable pattern is medium = affiliates, source = affiliate type (for example bloggers, podcasters, YouTubers or influencers), and campaign = the person's name. Keep the values short, consistent and lower-case where possible so Sugar CRM reports do not split one affiliate across spelling variants. Decide the pattern before issuing links; changing it later fragments historical reporting.

2. Add hidden attribution fields to your forms

Next, add hidden fields to the forms visitors submit, such as Contact Us or Request a Quote. Use Channel, Channel Drilldown 1, Channel Drilldown 2, Channel Drilldown 3, Landing Page and Landing Page Group. Hidden fields keep the form clean for visitors while giving the CRM structured attribution data. Many form builders support hidden fields directly; see the step-by-step hidden-field tutorials for common form builders linked below. Check that each hidden field name in the form matches the field name expected by your CRM mapping.

3. Let the tool carry UTM values to form submission

When someone arrives through a tagged affiliate link, the attribution tool stores the UTM values in the browser. If the visitor browses several pages, leaves and returns, or submits a form later, those values are still available. On form submission the tool writes the stored values into the hidden fields. This persistence is the key difference from a one-page click tag: the lead record reflects the affiliate who first brought the visitor in, not just the page where the form happened to sit.

4. Map the captured values into Sugar CRM

On submission, the form builder captures the hidden-field values together with the visitor's name, email and other answers. Send that payload into Sugar CRM through a built-in form-to-CRM integration or a third-party connector such as Zapier, mapping each hidden field to the matching Sugar CRM field. Test with a tagged link first: submit a form, open the new lead, and confirm Channel, the drilldowns and landing-page fields are populated before you roll the pattern out to all affiliates.

What lands in Sugar CRM

With the pattern above, an affiliate visit from a blogger named John Smith is stored as Channel = Affiliates, Channel Drilldown 1 = Bloggers and Channel Drilldown 2 = John Smith. The same mechanism handles other channels: an organic Google visit can be stored as Channel = Organic Search, Drilldown 1 = Google, Drilldown 2 = the Google domain, and Drilldown 3 = the keyword when available. That unified structure means one report can compare affiliates with organic search, social and paid channels without rebuilding fields.

Three reports to run once data flows

Run three reports first. Leads by Channel, by month, shows whether affiliates are growing and how they compare with SEO, paid search and social — useful when deciding where to invest next. Customers by Affiliate Type groups converted customers by blogger, podcaster, YouTuber or influencer, so you can recruit more of the type that actually closes. Revenue by Affiliate ranks individual affiliates by new revenue, helping you reward top performers and support those who need help. Together they answer whether the programme works, which type works best, and who drives value.

Launch checklist

Before launch, use this checklist: (1) agree the UTM pattern and value list; (2) add all six hidden fields to every lead form; (3) map each hidden field to Sugar CRM; (4) test one tagged affiliate link end-to-end; (5) test one organic visit to confirm non-affiliate channels are labelled; (6) build the three reports above; and (7) document the pattern so new affiliates are issued links the same way. If a lead arrives with blank attribution, check the link tagging first, then the hidden fields, then the CRM mapping — in that order.

Affiliate UTM pattern and CRM mapping
UTM parameterExample valueStored in Sugar CRM as
utm_mediumaffiliatesChannel = Affiliates
utm_sourcebloggersChannel Drilldown 1 = Bloggers
utm_campaignjohn-smithChannel Drilldown 2 = John Smith

Example pattern from the workflow; adapt values to your affiliate types and naming rules.

Three starter reports
ReportBreakdownDecision it supports
Leads by ChannelLeads per month by channelCompare affiliates with SEO, paid and social; spot growth opportunities
Customers by Affiliate TypeCustomers by affiliate typeRecruit more of the best-performing affiliate types
Revenue by AffiliateNew revenue per individual affiliateReward top affiliates and target support where needed

Reports depend on Channel and drilldown fields being populated on leads and customers.

Frequently asked questions

What UTM structure works best for affiliate links?

Use one consistent pattern per affiliate: medium for the programme, source for affiliate type, and campaign for the individual affiliate. That lets you roll up by programme, compare types such as bloggers and podcasters, and still identify a named person.

Which hidden fields should a form include?

Add Channel, Channel Drilldown 1, Channel Drilldown 2, Channel Drilldown 3, Landing Page and Landing Page Group as hidden fields. The attribution tool fills them from the visit, the form builder captures them with the visitor's details, and your Sugar CRM integration maps them to the lead record.

Can the same setup track non-affiliate channels?

Yes. The same fields can record organic search, social, paid search and other channels, so affiliate results can be compared with the rest of your pipeline in one view instead of in a separate spreadsheet.