topic Re: Summarising common terms from a custom multi-line text property in Content Strategy & SEO

Summarizing common terms from a custom multi-line text property

WFoster — Fri, 10 Jan 2025 21:33:34 GMT

Hi,

In my HubSpot environment, I have a custom multi-line property that captures the areas of interest from people who have submitted a form.

I can report on the most recent areas of interest submitted e.g. over 7 days. I was wondering if it was possible for HubSpot to produce a report on the most prominent terms from all time?

This would be of great help to our marketing efforts.

Thanks in advance,

William

Re: Summarising common terms from a custom multi-line text property

Crystal_Hopper — Thu, 09 Jan 2025 17:53:40 GMT

Hi @WFoster! Cool idea! This might not be exact but I think you can get there. I'm pulling from my multi-line "Message" field which I use as a general dump all. So, my data isn't great. But yours might be better if your terms are more consistent.

Here's my setup in a custom report:

I'm pulling in Contacts and Message. Then Filtering the Message field on certain terms which seem to then distribute themselves in the pie chart. Hope that gets you started in a good direction.

Re: Summarising common terms from a custom multi-line text property

WFoster — Mon, 13 Jan 2025 11:53:52 GMT

Hi @Crystal_Hopper ,

Many thanks for the suggestion! That has helped to summarise our data into more manageable segments.

Best,

William