Hi there! I need help with importing conversion information from HubSpot into Google Ads without using automated tools. Our HubSpot subscription doesn’t include the advanced marketing features, so I have to do this process manually.
I want to send our completed sales data to Google Ads so the campaigns can learn better and drive more revenue. I understand that each conversion needs a GCLID parameter to work properly with Google Ads. Some of our deals have this tracking code but not all of them.
Can anyone help me with these steps:
Where to locate the right conversion data in HubSpot
What format Google Ads expects for the upload file
The actual process to import this data into Google Ads
I’m stuck and would really appreciate any step-by-step guidance or resources you can share. Thanks so much!
honestly, gclid tracking will be your main pain point. start small - test with 10-20 recent deals before uploading everything. your conversion action needs to be set up in google ads first, or the upload won’t work. also, check if your hubspot admin turned on gclid capture for forms. if not, you’re losing a ton of future data.
hey mandy! just went through this recently. export those deals from hubspot and make sure to include the gclid field. in google ads, head over to tools > conversions > uploads, use their csv template - super easy. just a tip, without gclids, you might miss out on some data, so maybe think about adding utm tracking in the future!
Been there when our agency switched tracking methods. Your conversion data’s in HubSpot deals properties - create a custom report pulling closed deals with original source drill-down. This shows which deals came from Google Ads. Download Google’s offline conversion template from the conversions section first, then map your HubSpot fields to their requirements. Timestamp formatting’s the tricky part - Google wants exactly YYYY-MM-DD HH:MM:SS timezone format. Filter deals by original source containing ‘google’ or ‘cpc’ before exporting since not every closed deal matters for Google Ads attribution. Google has a lookback window too, so older conversions might get rejected even with valid GCLIDs.
I dealt with this exact thing last year when we ditched automated tracking. You need to prep your data right before uploading anything. Go to your deals section in HubSpot and set up a custom view with the GCLID property, conversion value, and date fields. Export that as CSV. Google Ads wants their specific offline conversion template format - you’ll need columns for conversion name, conversion time, conversion value, and GCLID. Make sure the conversion time format is exactly what Google wants or it’ll fail. Here’s what bit me: deals without GCLIDs can’t be traced back to clicks, so you basically lose those conversions. I’d suggest setting up proper UTM parameters now so you’ll have cleaner data for future uploads.