The back
Origination on the post. Alignment on the opty.
The plumbing is Sprout and Salesforce. Grain, stages, association, sauce, HTML live in the periphery and feed the opty. HubSpot can call. It is not a pipe. Start a trial and connect a Developer Edition.
Origin
li_2041
q3-pipeline · q3-pipeline
100% origination. Always the post.
Opty
open
$48,000 · forecast $9,600 · 20% influence
Northline · Q3 pipeline. Forecast category Pipeline.
Outbound payload
Opportunity is the object. The grain is origin + opty. Person is a contact role, not the record.
{
"object": "opportunity",
"origin": {
"post": "li_2041",
"page": "q3-pipeline",
"campaign": "q3-pipeline"
},
"opty": {
"name": "Northline · Q3 pipeline",
"band": "open",
"stage": "open",
"amount": 48000,
"forecast": 9600,
"influence": 0.2,
"converts": false,
"forecastCategory": "Pipeline"
},
"person": {
"first_name": "",
"email": "",
"company": "Northline",
"role": "Demand lead",
"intent": "demo"
},
"grain": {
"iota": "io_c5666d",
"src": "sprout",
"post": "li_2041",
"net": "linkedin",
"utm": {
"s": "linkedin",
"m": "social",
"c": "q3-pipeline",
"ct": "founder-note"
},
"page": "q3-pipeline",
"co": "Northline",
"role": "Demand lead",
"intent": "demo",
"rev": 48000,
"opty": {
"amt": 48000,
"band": "open",
"w": 0.2
},
"tgt": 250000,
"t": 1791405352
}
}Field map
The grain is the source. Salesforce fields sit on Opportunity. Contact is along for the ride.
| Grain | HubSpot | Salesforce |
|---|---|---|
| iota | deal.jetfly_id | Opportunity.Jetfly_Id__c |
| post | deal.jetfly_post_id | Opportunity.Jetfly_Post_Id__c |
| page | deal.jetfly_page | Opportunity.Jetfly_Page__c |
| utm.c | deal.utm_campaign | Opportunity.UTM_Campaign__c |
| utm.s | deal.utm_source | Opportunity.UTM_Source__c |
| utm.m | deal.utm_medium | Opportunity.UTM_Medium__c |
| utm.ct | deal.utm_content | Opportunity.UTM_Content__c |
| rev | deal.amount | Opportunity.Amount |
| opty.band | deal.dealstage | Opportunity.StageName |
| opty.w | deal.jetfly_influence | Opportunity.Jetfly_Influence__c |
| opty.fcst | deal.hs_forecast_amount | Opportunity.ForecastCategoryName |
| co | contact.company | OpportunityContactRole |
| role | contact.jobtitle | Contact.Title |