Multiple forms for one content piece affecting reporting

Hello, I am hoping for advice on a situation I inherited.

We have quite a few guides, ebooks, case studies, etc. We have a HubSpot form for each content piece, but they are also advertised on LinkedIn. This has created a situation where we have at least one LinkedIn form (sometimes it can be 2-3) + 1 HubSpot form for the same, single piece of content.

This has affected my reporting since the forms are treated separately. I am thinking one way to handle is create a custom property called ‘content download’ with dropdown options that show each content title. Then, set up a workflow that reads for all the possible form submissions related to one content piece which then updates the property. My question is - won’t that property continue to update as someone downloads multiple content pieces? So my reporting would reflect the most recent property values not all historical downloads too?

Likewise with the date the form was submitted. If I create a date property to house the date the content was downloaded, won’t that only hold the most recent download date? Not sure if I have to create separate properties for each content piece or if there is an easier, more efficient way.

Any thoughts would be appreciated--thank you!

Hi @amatoaa8,
you could also look into lists and create one list for each content piece. In each list, you can add all the forms and then report on the list membership.

With the property you suggested, it would have to be a “multi select” property, so the previous value isn’t overwritten. But multi select properties bring their own challenges regarding reporting. I’d suggest to start with the question of what you want (need) to be able to report. Once you are clear on that, you can make a decision on what workarounds might be needed to get there.
Let me know if that helps, or if you need any further input.
Best
Colin

[


](https://www.leadwunder.com)

Hi @amatoaa8! Welcome to the Community-- happy to have you here :blush:

Thanks for your question. It sounds like you have put a lot of thought into your alternatives. I do agree with @colinwitt that a multi-select could be more beneficial than a drop-down. I assume that the amount of content can vary. Creating a separate property for each piece of content could also get clunky over time.
As Colin mentioned above, knowing exactly what you need to report on could help us here! There are possibilities to filter lists and reports by if a value has ever been equal to something, so that could help if you just want to know if someone has ever downloaded Content ABC even if they have downloaded something else since.

I’d love to invite @karstenkoehler, @Ben_M, and @TomM2 to the thread to see if they can provide and tips or tricks here! Thanks y’all

Best,
Kennedy