Unable to Cross Filter Between Pages and Source via Supermetrics API in Data Studio

Hello!

I’m currently using Supermetrics to pull in data into Google Data Studio to visualize our Hubspot Landing Pages data. Specifically, I’m trying to show a source breakdown on a page level basis.

I’ve reached out to their support and they told me that Pages and Sources are incompatible fields due to the underlying API connection.

I was curious if anyone else here has come across this same issue? Will there be any changes to the API to allow these fields to work together? My experience with APIs is a bit limited so any information will help!

Hey @dill,

When looking to pull analytics on HubSpot pages, you can use the Analytics API Overview.

If you’re looking to pull sources analytics, you can use this endpoint: Get analytics data breakdowns | Analytics API and breakdown it down by sources.

If you’re looking to retrieve analytics data for specifically the page object, you can use this endpoint: Get Analytics data for specific objects and set the object type as pages.