We have a scenario where we have approximately 20 websites, each with a dedicated Google Adwords account associated to it.
I have been struggling to find shelfware solutions that enables linking of multiple google adwords accounts to Salesforce in order to enrich our incoming leads with data from Google adwords.
Anyone with experience from similar cases? Is is possible to build a manual integration via the Google Adwords API?
Any advice is appreciated!
20 accounts is a lot to wrangle through the API directly. It's technically doable (the Google Ads API will give you campaign, ad group, and keyword data tied to a GCLID), but you'd be maintaining a fairly hefty integration across 20 accounts that likely all have different naming conventions and campaign structures. That's a real ongoing project, not a one-off build.
Before committing to that, it's worth asking what you actually need in Salesforce. If the goal is just knowing which campaign, ad group, or keyword produced a given lead, you don't need to query the API at all. You can just out UTM parameters behind your ads that contain the campaign, ad group and keyword. Then when the visitor lands on your site, the data is sitting right there in the URL.
You can then use tools like Attributer to capture that data when someone lands on any of your sites, store it in a cookie, and write it into hidden fields on whatever forms feed into Salesforce (it works with Web to Lead Forms plus 50+ other form builders, schedulign widgets, etc). It doesn't care how many ad accounts you're running since it's not tied to the account, just whatever's in the URL.
Worth being clear though, it won't pull cost or conversion stats back into Salesforce. For that you'd still need the API. But if it's lead enrichment you're after, this is a lot less to build and maintain than a custom integration across 20 accounts.