Unlocking Hidden HubSpot Data: How to Find Internal Property Values for Better Reporting

Ever found yourself scratching your head, wondering why a HubSpot filter isn't quite catching all the data you expect? Or maybe you're trying to build a killer report, but some crucial property values just aren't showing up the way their labels suggest? If so, you're definitely not alone. This is a classic HubSpot head-scratcher that recently popped up in the HubSpot Community, and it's a perfect example of how understanding the platform's inner workings can save you a ton of frustration.

The Case of the Missing Filter Data

Imagine you're trying to segment your companies based on where they originally came from – say, "Original Source data 2." You type "Zoominfo" into the filter, expecting to see all those companies sourced from Zoominfo. But… crickets. Nothing. That's exactly what happened to the original poster in a recent HubSpot Community discussion. They quickly realized the culprit: HubSpot's filters don't always search by the friendly, human-readable text you see in the UI. Instead, they often rely on an "internal value" – a unique, often numeric ID that HubSpot uses behind the scenes.

For instance, while you might see "Zoominfo" in a dropdown, HubSpot internally refers to it as something like "206398." Trying to filter by "Zoominfo" yields nothing, but plugging in "206398" works like a charm. The challenge, of course, is finding these internal values, especially when you need a whole list of them for a complex report or a detailed segmentation strategy. The manual workaround – hovering over the little 'i' icon next to each property value in a record – is, as the original poster put it, "bonkers" when you need a bunch of them. We agree!

Unlocking the Hidden Data: A Community-Powered Solution

Thankfully, a clever community member stepped in with a brilliant, straightforward solution that turns a frustrating data hunt into a simple reporting exercise. The trick? Leveraging HubSpot's custom report builder to create a quick mapping table of your property's human-readable labels and their corresponding internal values. This is a game-changer for anyone dealing with granular segmentation, complex workflows, or detailed RevOps reporting.

Step-by-Step: Building Your Internal Value Map Report

Here's how you can create this essential report in HubSpot, inspired by the community's wisdom:

1. Start a New Custom Report: Navigate to Reports > Reports > Create report.
2. Choose Your Data Source: Select "Custom Report" and then pick the object type relevant to your property. In the original poster's case, it was "Companies," but it could also be "Contacts" or "Deals," depending on where your property lives.
3. Select "Table" View: Once in the report builder, make sure your report is set to "Table" view. This is key for seeing the data laid out clearly.
4. Add Your Property and a Count:
   • In the left sidebar, under "Data," search for and drag your problematic property (e.g., "Original Source data 2") into the "Columns" section.
   • Next, add a basic metric like "Count of Companies" (or Contacts, Deals, etc.) to your "Columns" as well. This will give you some context on how many records are associated with each value.
5. Create a Formula Field for Internal Values: This is the magic step!
   • In the left sidebar, scroll down to "Calculations" and click "Add formula field."
   • Give your formula field a descriptive name, like "Original Source Data 2 (Internal Value)."
   • In the formula editor, simply click "Insert field" and search for the exact same property you added in the previous step (e.g., "Original Source data 2").
   • Select the property, and HubSpot will automatically insert its internal representation.
   • Click "Create."
6. Arrange and Save: Drag your new formula field into the "Columns" section of your report. You should now see columns for the human-readable label, the internal value, and the count of records. Arrange them as you like, then save your report.

Voila! You now have a comprehensive table mapping your property's labels to their internal IDs, ready for filtering, segmentation, and deeper analysis.

Why This Matters for Your E-commerce and RevOps Strategy

Understanding and easily accessing these internal HubSpot property values isn't just about fixing a quirky filter. It's about empowering your RevOps team, marketers, and sales reps with cleaner, more precise data. When you can accurately segment your audience based on specific source data, product interests, or any other custom property, you unlock a world of possibilities:

• Hyper-Targeted Campaigns: Build workflows and email sequences that trigger based on exact internal values, ensuring your messages reach the right audience at the right time.
• Precise Reporting: Create robust reports that truly reflect your data, helping you measure ROI more accurately for different channels or initiatives.
• Seamless Integrations: If you're connecting HubSpot to other systems, like a specialized marketing automation tool or even a shopify ecommerce automation platform, knowing these internal IDs can be crucial for mapping fields correctly and ensuring data flows smoothly. This level of detail ensures your automated processes, whether for lead nurturing or post-purchase follow-ups, are always firing on all cylinders.
• Data Governance: Maintain cleaner data by understanding exactly how HubSpot interprets and stores your information, leading to better overall data health.

ESHOPMAN Team Comment

This community discussion highlights a common friction point in HubSpot's powerful but sometimes opaque data structure. The proposed solution is elegant and practical, transforming a tedious manual lookup into an automated report. We think this approach is absolutely essential for any RevOps professional or marketer who needs to build truly robust segmentation and reporting. It's a prime example of leveraging HubSpot's native tools to overcome what initially feels like a platform limitation, ultimately leading to better data-driven decisions for your storefront.

So, the next time you hit a wall with a HubSpot filter or report, remember this little trick. It's a testament to the power of the HubSpot Community and a vital insight for anyone aiming to master their CRM data. By taking a few extra steps to map those internal values, you'll be well on your way to more precise segmentation, more effective campaigns, and ultimately, a more insightful view of your customer journey. Happy reporting!