Associating paid ad spend with company records

[JamesG1]

Hi there,

We're a digital ad agency, and we often bill clients as a % of their overall media spend.

At the moment, it's a manual process to collect ad spend for the month passed and calculate billing.

Are there any solutions available that would enable us to pull a clients ad spend in, and have it associated with their company record to be updated on the 1st day of each month.

Thanks

[Josh · Accepted solution]

Hi @JamesG1,

I would say that would depend on what platforms you're pulling ad spend from. If it's just Google Ads, you could probably do that with Zapier. If there are other mediums that are spending which you also want to pull in, you could potentially create something in which it pulls into Google Sheets and then Zapier/HubSpot. Alternatively, you could pull each medium into a different property in HubSpot with Zapier and then use calculated fields to pull a percentage. 

Short answer...I think it's possible, but it will require a bit of leg work.

Josh