How to query Ads Activity and Contact created data from HubSpot API

[khookguy]

We are pulling HubSpot data into a database and want to do some analysis on the contacts interaction with our Google Ads. In particular, we want to be able to pull the Ads Activity details (seen in the Contact Activity Field): Google Ads campaign, ads account, ad group, and keyword.

In addition, we'd like to pull the campaign data from the Contact created activity.

Examples of both appear in the image below:

 

[SKroon]

Any updates on this one?

[robbieboy]

Hi there, I have a need for this as well. Currently I'm able to pull, what appears to be, the original source of the contact. I believe this is the "Contact Created" portion of your screen shot. I found this on the contact record (via webhook in my case) as ["hs_latest_source"] and ["hs_latest_source_{n}"].

This does not include the Ads Activity data though, which I need to get access to. There must be a way to get this. Anyone else have any other ideas on this? Thx 

[tominal]

I don't think we can pull that particular engagement over the API.

Anyone?

[khookguy]

Thanks @dennisedson .  I'm still struggling with this, if anybody has ideas, I'd appreciate them!

[dennisedson]

hmmm

Maybe @tominal or @RMones have some ideas

[dennisedson]

Hi @khookguy !

Throwing a few smart people at this for you

@Phil_Vallender , @Josh , @Anonymous , @louischausse any of you all have ideas?