# \#datasets **URL:** https://community.hubspot.com/tag/datasets/3527.md [Latest](https://community.hubspot.com/latest.md) · [Categories](https://community.hubspot.com/categories.md) · [Tags](https://community.hubspot.com/tags.md) --- ## [Create a report using Google Search Console data (including queries)](https://community.hubspot.com/t/create-a-report-using-google-search-console-data-including-queries/149288)
**Author:** [@UserLL](https://community.hubspot.com/u/UserLL)\ **Replies:** 2\ **Last updated:** [May 13, 2026, 4:37am UTC](https://community.hubspot.com/t/create-a-report-using-google-search-console-data-including-queries/149288 "2026-05-13T04:37:07Z")
I’m trying to build a report in HubSpot that uses Google Search Console data, specifically including the Query (keyword) dimension. Ideally, I want to connect customer properties with GSC dimensions such as: Query (se… --- ## [Soumitra Dutta Oxford-How do I clean and manage messy HubSpot data?](https://community.hubspot.com/t/soumitra-dutta-oxford-how-do-i-clean-and-manage-messy-hubspot-data/149053)
**Author:** [@soumitradutta26](https://community.hubspot.com/u/soumitradutta26)\ **Replies:** 3\ **Last updated:** [May 12, 2026, 4:08am UTC](https://community.hubspot.com/t/soumitra-dutta-oxford-how-do-i-clean-and-manage-messy-hubspot-data/149053 "2026-05-12T04:08:32Z")
Greetings, I am Soumitra Dutta, an Oxford-based entrepreneur and photographer. I am currently trying to clean and organize some messy data in HubSpot and could use some guidance. For those who have worked with HubSpot C… --- ## [Bummed with Unsummarized data not being flexible](https://community.hubspot.com/t/bummed-with-unsummarized-data-not-being-flexible/148998)
**Author:** [@CTolentino](https://community.hubspot.com/u/CTolentino)\ **Replies:** 2\ **Last updated:** [May 5, 2026, 3:56am UTC](https://community.hubspot.com/t/bummed-with-unsummarized-data-not-being-flexible/148998 "2026-05-05T03:56:02Z")
Anyone else frustrated with how “Unsummarized data” works in HubSpot reports? I’ve been trying to customize the layout, but it feels really rigid. I can’t even figure out how to move Record IDs to the leftmost column it… --- ## [Struggling to get form submission data](https://community.hubspot.com/t/struggling-to-get-form-submission-data/148825)
**Author:** [@swadib](https://community.hubspot.com/u/swadib)\ **Replies:** 4\ **Last updated:** [April 29, 2026, 3:28pm UTC](https://community.hubspot.com/t/struggling-to-get-form-submission-data/148825 "2026-04-29T15:28:40Z")
I’m trying to get the total number of form submissions from a certain email campaign. I want to be able to do this for a set of email campaigns, I know I can see them at an individual level but I need this data for 200 e… --- ## [Report - # of Tickets divided by # of deals in a specific stage](https://community.hubspot.com/t/report-of-tickets-divided-by-of-deals-in-a-specific-stage/147754)
**Author:** [@ManuelRoc](https://community.hubspot.com/u/ManuelRoc)\ **Replies:** 4\ **Last updated:** [April 9, 2026, 12:00pm UTC](https://community.hubspot.com/t/report-of-tickets-divided-by-of-deals-in-a-specific-stage/147754 "2026-04-09T12:00:19Z")
I’m trying to build a report in HubSpot (Data Hub Professional) that shows the following ratio on a weekly basis: Tickets created in calendar week X ÷ Total deals currently in stage “Active” (pipeline: “Operations”) T… --- ## [Data Studio sync from Airtable](https://community.hubspot.com/t/data-studio-sync-from-airtable/147568)
**Author:** [@BGreen92](https://community.hubspot.com/u/BGreen92)\ **Replies:** 2\ **Last updated:** [March 31, 2026, 5:06pm UTC](https://community.hubspot.com/t/data-studio-sync-from-airtable/147568 "2026-03-31T17:06:21Z")
Hello, We’ve set up a connection between HubSpot Data Studio and a table in our Airtable account that contains the data we need to import into HubSpot for reporting. The connection has been in place for over a week now… --- ## [Is There a Ready-Made Demo CRM Dataset for Learning HubSpot?](https://community.hubspot.com/t/is-there-a-ready-made-demo-crm-dataset-for-learning-hubspot/147140)
**Author:** [@IOcheretnyi](https://community.hubspot.com/u/IOcheretnyi)\ **Replies:** 5\ **Last updated:** [March 19, 2026, 2:36am UTC](https://community.hubspot.com/t/is-there-a-ready-made-demo-crm-dataset-for-learning-hubspot/147140 "2026-03-19T02:36:38Z")
Hi HubSpot Community, I’m new to HubSpot, although I have around 15 years of experience in IT as a Software Developer (Adobe Commerce). Currently, I’m studying for the HubSpot Marketing Hub Software Certification and t… --- ## [Enhancing report with external source dataset](https://community.hubspot.com/t/enhancing-report-with-external-source-dataset/146266)
**Author:** [@JulienD8](https://community.hubspot.com/u/JulienD8)\ **Replies:** 4\ **Last updated:** [February 23, 2026, 9:10pm UTC](https://community.hubspot.com/t/enhancing-report-with-external-source-dataset/146266 "2026-02-23T21:10:53Z")
Hi there! I’m building custom reports in HubSpot using datasets connected to Snowflake. I need to use the dynamic “Me” filter (owner filter) on these custom datasets, but it’s not working even though I’ve: - Added an … --- ## [External Data Sources Don't Automatically Refresh?](https://community.hubspot.com/t/external-data-sources-dont-automatically-refresh/146093)
**Author:** [@SGross27](https://community.hubspot.com/u/SGross27)\ **Replies:** 5\ **Last updated:** [February 20, 2026, 4:29pm UTC](https://community.hubspot.com/t/external-data-sources-dont-automatically-refresh/146093 "2026-02-20T16:29:34Z")
We’ve recently started using Data Studio to pull in Google Sheets as an external data source. It was our assumption that this would keep up-to-date in realtime, or at least automatically refresh itself at a reasonable ca… --- ## [Harmandeep Singh Kandhari - Exploring the Future of AI in New Delhi](https://community.hubspot.com/t/harmandeep-singh-kandhari-exploring-the-future-of-ai-in-new-delhi/146234)
**Author:** [@HarmanKandhari](https://community.hubspot.com/u/HarmanKandhari)\ **Replies:** 0\ **Last updated:** [February 14, 2026, 6:49am UTC](https://community.hubspot.com/t/harmandeep-singh-kandhari-exploring-the-future-of-ai-in-new-delhi/146234 "2026-02-14T06:49:27Z")
Hello Guys, I’m Harmandeep Singh Kandhari, At AI Summit 2026, hosted in New Delhi, I plan to listen closely to global tech CEOs discussing AI advancements. I expect the summit to influence startups, enterprises, and pol… --- ## [Why are new contacts not associating with companies in HubSpot?](https://community.hubspot.com/t/why-are-new-contacts-not-associating-with-companies-in-hubspot/145865)
**Author:** [@LPhillips0](https://community.hubspot.com/u/LPhillips0)\ **Replies:** 2\ **Last updated:** [February 5, 2026, 12:18pm UTC](https://community.hubspot.com/t/why-are-new-contacts-not-associating-with-companies-in-hubspot/145865 "2026-02-05T12:18:00Z")
Hi The last 2 days we have noticed that HubSpot is not linking new contacts with the company, via their email address. How do we fix this please? --- ## [Summary Formulas in Datasets](https://community.hubspot.com/t/summary-formulas-in-datasets/90448)
**Author:** [@smcmillian](https://community.hubspot.com/u/smcmillian)\ **Replies:** 5\ **Last updated:** [January 26, 2026, 4:52pm UTC](https://community.hubspot.com/t/summary-formulas-in-datasets/90448 "2026-01-26T16:52:56Z")
Introduction Hi, my name is Stephen, and I’m the product manager for datasets at HubSpot. I put together a series of videos to demonstrate how our new summary functions work to complement the knowledgebase article. Sum… --- ## [How do I filter threads by date?](https://community.hubspot.com/t/how-do-i-filter-threads-by-date/140830)
**Author:** [@LucasGodoi](https://community.hubspot.com/u/LucasGodoi)\ **Replies:** 3\ **Last updated:** [October 13, 2025, 7:00pm UTC](https://community.hubspot.com/t/how-do-i-filter-threads-by-date/140830 "2025-10-13T19:00:59Z")
How do I filter conversations by date? I’d like to filter by date to get conversations created or ended after 2025, but I can’t find the correct field. Has anyone done this and have a practical example for me to apply? --- ## [Dissertation data analysis help](https://community.hubspot.com/t/dissertation-data-analysis-help/140333)
**Author:** [@jnderu](https://community.hubspot.com/u/jnderu)\ **Replies:** 4\ **Last updated:** [October 3, 2025, 12:44pm UTC](https://community.hubspot.com/t/dissertation-data-analysis-help/140333 "2025-10-03T12:44:17Z")
Hi everyone. A couple of friends recently pointed me toward Hartle1998, a Data Analysis Service when I mentioned I needed help with dissertation data analysis. They swear by it, but what they don’t know is I’m not reall… --- ## [How to create report or dataset on all custom events (not just 5 years)](https://community.hubspot.com/t/how-to-create-report-or-dataset-on-all-custom-events-not-just-5-years/134348)
**Author:** [@cyberwombat](https://community.hubspot.com/u/cyberwombat)\ **Replies:** 3\ **Last updated:** [June 13, 2025, 4:19am UTC](https://community.hubspot.com/t/how-to-create-report-or-dataset-on-all-custom-events-not-just-5-years/134348 "2025-06-13T04:19:14Z")
Client wants to know how many entries for example of a custom event (lets call it Purchase) over the entire history. Is there a workaround to the 5 year range limit that could be used (merging datasets in reports etc). N… --- ## [Datasets - Use association labels](https://community.hubspot.com/t/datasets-use-association-labels/92079)
**Author:** [@SLABONNE](https://community.hubspot.com/u/SLABONNE)\ **Replies:** 4\ **Last updated:** [April 4, 2025, 10:19am UTC](https://community.hubspot.com/t/datasets-use-association-labels/92079 "2025-04-04T10:19:12Z")
Hello, I am creating a dataset for Transactions and a Custom Object I would like to see and use association labels, as in a normal report, but this seems impossible Is there another way? Thank you! --- ## [Some use cases for Datasets](https://community.hubspot.com/t/some-use-cases-for-datasets/128840)
**Author:** [@DanMYD](https://community.hubspot.com/u/DanMYD)\ **Replies:** 1\ **Last updated:** [March 28, 2025, 9:36am UTC](https://community.hubspot.com/t/some-use-cases-for-datasets/128840 "2025-03-28T09:36:25Z")
I feel like Datasets are an underappreciated part of Operation Hub. Especially with the improvements over the last year or so. I made a video to highlight some of the powers it has since there isn’t a lot of content show… --- ## [Datasets: Join contacts as secondary source?](https://community.hubspot.com/t/datasets-join-contacts-as-secondary-source/118266)
**Author:** [@fiberpunk](https://community.hubspot.com/u/fiberpunk)\ **Replies:** 3\ **Last updated:** [October 17, 2024, 6:45am UTC](https://community.hubspot.com/t/datasets-join-contacts-as-secondary-source/118266 "2024-10-17T06:45:01Z")
Hey folks, In my database, I have some contacts who are affiliates who are referring new contacts. When that happens, a new contact will store the affiliate ID of the person it has been referred by. Now, in my dataset … --- ## [Managing Partner and Referral Data: Best Practices](https://community.hubspot.com/t/managing-partner-and-referral-data-best-practices/117512)
**Author:** [@Stef\_N](https://community.hubspot.com/u/Stef_N)\ **Replies:** 3\ **Last updated:** [October 6, 2024, 4:45pm UTC](https://community.hubspot.com/t/managing-partner-and-referral-data-best-practices/117512 "2024-10-06T16:45:22Z")
Hello everyone, I am curious if any of you are utilising HubSpot as your CRM to manage the partner master database. While we use a Partner Relationship Management (PRM) system, I would like to understand how you link de… --- ## [Preview data tables while working on formula fields](https://community.hubspot.com/t/preview-data-tables-while-working-on-formula-fields/117435)
**Author:** [@ErikHolmberg](https://community.hubspot.com/u/ErikHolmberg)\ **Replies:** 2\ **Last updated:** [October 3, 2024, 1:15pm UTC](https://community.hubspot.com/t/preview-data-tables-while-working-on-formula-fields/117435 "2024-10-03T13:15:07Z")
Hi, I’m trying to get into building datasets and using the formula fields. Howver, it’s hard to get an overview of the datastructure and the how the properties are structured. For instance, say I want to use \[COMPANY.h… --- ## [Dataset values not matching report values](https://community.hubspot.com/t/dataset-values-not-matching-report-values/110562)
**Author:** [@00000](https://community.hubspot.com/u/00000)\ **Replies:** 3\ **Last updated:** [July 10, 2024, 7:08pm UTC](https://community.hubspot.com/t/dataset-values-not-matching-report-values/110562 "2024-07-10T19:08:10Z")
Hello, I think I missed a part of documentation. Could someone please point me in the right direction to solve the issue below? How do I get the dataset forumla field value to display in the custom report? Dataset foru… --- ## [Presenting to you: Datasets!](https://community.hubspot.com/t/presenting-to-you-datasets/46298)
**Author:** [@smcmillian](https://community.hubspot.com/u/smcmillian)\ **Replies:** 12\ **Last updated:** [June 17, 2024, 10:21pm UTC](https://community.hubspot.com/t/presenting-to-you-datasets/46298 "2024-06-17T22:21:57Z")
Hi everyone, I’m Stephen McMillian and I’m the Product Manager of Datasets by HubSpot. I’m very excited to finally release Datasets to all of you here!! I wanted to make this post to introduce myself and share what we’v… --- ## [Hubspot can't find common field in Airtable? One Way Data Sync](https://community.hubspot.com/t/hubspot-cant-find-common-field-in-airtable-one-way-data-sync/94986)
**Author:** [@KHerrod](https://community.hubspot.com/u/KHerrod)\ **Replies:** 8\ **Last updated:** [March 28, 2024, 5:47pm UTC](https://community.hubspot.com/t/hubspot-cant-find-common-field-in-airtable-one-way-data-sync/94986 "2024-03-28T17:47:36Z")
Hello! We recently upgraded to Operations Hub and I’ve been tasked with starting a migration of datasets from Airtable INTO Hubspot. A colleague and I worked manually (the only way to get this to work at first) to ente… --- ## [Change in Record ID format](https://community.hubspot.com/t/change-in-record-id-format/103418)
**Author:** [@Robin\_Miller](https://community.hubspot.com/u/Robin_Miller)\ **Replies:** 2\ **Last updated:** [March 26, 2024, 9:37am UTC](https://community.hubspot.com/t/change-in-record-id-format/103418 "2024-03-26T09:37:38Z")
Hi All Hope this is the right place for this question. Has anyone else’s ‘Record ID’ format changed recently? Ours has been 6-digits for a long time, but suddenly recently it’s jumped to 10-digits. Obviously this does… --- ## [Deal Number by Company](https://community.hubspot.com/t/deal-number-by-company/102727)
**Author:** [@MWilliamson8](https://community.hubspot.com/u/MWilliamson8)\ **Replies:** 2\ **Last updated:** [March 19, 2024, 10:28am UTC](https://community.hubspot.com/t/deal-number-by-company/102727 "2024-03-19T10:28:15Z")
I want to have insight into a companies deal performance by individual order number (i.e. how does a companies 8th deal closed, compare to their next 5 deals closed). In the past I have done this outside of HubSpot, but… --- ## [Dataset-based reports crashed](https://community.hubspot.com/t/dataset-based-reports-crashed/102672)
**Author:** [@TRichard7](https://community.hubspot.com/u/TRichard7)\ **Replies:** 1\ **Last updated:** [March 15, 2024, 11:42am UTC](https://community.hubspot.com/t/dataset-based-reports-crashed/102672 "2024-03-15T11:42:20Z")
After Hubspot improved the look of the dataset yesterday, all of our dataset-based reports crashed. Reports created from scratch, identical to the ones that crashed, work just fine. Anyone facing the same issue? Any sol… --- ## [Calculate the average number of tickets per user](https://community.hubspot.com/t/calculate-the-average-number-of-tickets-per-user/96496)
**Author:** [@enorberg](https://community.hubspot.com/u/enorberg)\ **Replies:** 3\ **Last updated:** [January 2, 2024, 7:44am UTC](https://community.hubspot.com/t/calculate-the-average-number-of-tickets-per-user/96496 "2024-01-02T07:44:54Z")
I’m trying to set up a report that shows the average number of Hubspot tickets per user. My definition of “Users” is a custom property on the company object with that same name - each customer has this filled in. So to a… --- ## [Dataset-created field sorting alphabetically](https://community.hubspot.com/t/dataset-created-field-sorting-alphabetically/95646)
**Author:** [@00000](https://community.hubspot.com/u/00000)\ **Replies:** 5\ **Last updated:** [December 13, 2023, 6:29pm UTC](https://community.hubspot.com/t/dataset-created-field-sorting-alphabetically/95646 "2023-12-13T18:29:44Z")
Hello, In a report, how does one get dataset-created fields to display results in the order they were entered into the dataset field filter (or based on the value of the original property) instead of alphabetically by f… --- ## [Contact integration](https://community.hubspot.com/t/contact-integration/95725)
**Author:** [@DChampion01](https://community.hubspot.com/u/DChampion01)\ **Replies:** 2\ **Last updated:** [December 10, 2023, 7:12am UTC](https://community.hubspot.com/t/contact-integration/95725 "2023-12-10T07:12:19Z")
Having a hard time with start up and contact integration --- ## [Turn Data Set Fields into Contact Properties](https://community.hubspot.com/t/turn-data-set-fields-into-contact-properties/92234)
**Author:** [@LSimon3](https://community.hubspot.com/u/LSimon3)\ **Replies:** 3\ **Last updated:** [December 6, 2023, 7:11pm UTC](https://community.hubspot.com/t/turn-data-set-fields-into-contact-properties/92234 "2023-12-06T19:11:15Z")
I currently have a calculation that I made using Data Sets that basically adds up all the deals that each contact has made in the past 1.5 years so that I can have a running revenue number for each person. It would be ni… [Next page](https://community.hubspot.com/tag/datasets/3527.md?match_all_tags=true&page=1&tags%5B%5D=datasets)