Organic Social media post campaign data for Looker Studio

Hi all,

I am trying to link my LinkedIn post analytics data from HubSpot (which includes a ‘campaign’ name - which is why I want to pull HubSpot data over LinkedIn direct data) into Google Looker Studio.

I need Publish date, Post, Impressions, Engagment and Campaign.

Does anyone know if this is possible via the API? Failing that the best pay to automate a weekly report for this data to import into Looker Studio?

Any help or ideas are appreciated.

Thanks

Hey @DigitalRM, thank you for posting in our Community!

Currently, we have an integration with Looker Studio (more information here). The capabilities could be more precise on our end since we do not support the integration; Datawarehouse helps with this. On the ecosystem page, you’ll see the support channels for this integration, where they can clarify the teachings of using this data.

I invite our top expert and owner of this integration, @johnelmer, to share his thoughts.

Kindly,

Pam

Hi,

Yes, integrating LinkedIn post analytics from HubSpot into Looker Studio is possible, and the best way to do it is usually through third-party connectors that support this type of integration. One good option to consider is Porter Metrics, which allows you to pull HubSpot data into Looker Studio, including your required fields: Publish Date, Post, Impressions, Engagement, and Campaign.

To automate a weekly report, you could:

• Use Porter Metrics or a similar third-party tool to directly connect HubSpot and Looker Studio.

•Set up Google Sheets as an intermediary, exporting HubSpot data on a schedule and linking it to Looker Studio.

•If you have API access, automate data extraction from HubSpot into a structured format Looker Studio can read.

If you’d like personalized help or want us to go through the setup together, feel free to reach out on our contact page at kodalogic.com. We’d be happy to assist!

Best,

Isaac Correa.