HubSpot Ideas

Search HubSpot Ideas or Create Idea
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Status: Idea Submitted
Adriane
Submitted by Top Contributor | Diamond Partner on ‎Mar 26, 2025 8:12 AM

Combine "Ad Performance Metrics" and "Ad Interactions by Contact" in a single report

We need the ability to combine data from "Ad Performance Metrics" and "Ad Interactions by Contact" in a single custom report.

 

Currently, these two data sources cannot be used together, limiting our ability to gain comprehensive insights into our advertising efforts.

 

This feature would allow us to:

  • Analyze ad performance alongside individual contact interactions
  • Create more detailed and insightful reports on our advertising campaigns
  • Save time by eliminating the need to cross-reference multiple reports

Implementing this functionality would greatly enhance our ability to measure and optimize our advertising strategies within HubSpot, and provide a more holistic view of our advertising performance.

3 Replies
KRodriguez90
Member
‎Mar 26, 2025 8:14 AM

As a quick workaround, I'd suggest exporting both the "Ad Performance Metrics" and "Ad Interaction" reports into Excel or Google Sheets. Then you can merge them using VLOOKUP or INDEX/MATCH formulas based on common fields like campaign or ad ID. Another option is to set up a pivot table after combining the data, which helps easily analyze and visualize everything in one place.

Adriane
Top Contributor | Diamond Partner
Top Contributor | Diamond Partner
‎Mar 27, 2025 5:44 AM

Hi @KRodriguez90 , thanks for the workaround! Our ultimate goal is to have this report in HubSpot Dashboards; automatically updated when there's new data. Do you happen to have a workaround for this? Maybe via Google Sheets which can be integrated with Dashboards...but how could we set up Google Sheets so that the data is pulled automatically from Facebook and HubSpot? I've already tried a lot with Looker Studio but couldn't find a great HubSpot data source...it's really frustrating.

KRodriguez90
Member
‎Mar 27, 2025 6:37 AM

Hi @Adriane, I've looked into something similar before. Your idea to use Google Sheets is actually spot-on—you can pull Facebook data into Sheets directly with their built-in data connector (it's pretty straightforward to set up). HubSpot also has a native Sheets integration. So, once you have both datasets updating automatically in Sheets, you can feed that combined sheet into your HubSpot Dashboard.

I haven't fully tested it yet, but that’s the route I'd take—seems doable without needing extra tools.