# Data fields/properties report **URL:** \ **Category:** Dashboards & Reporting\ **Tags:** reports\ **Created:** [August 18, 2024, 9:18pm UTC](https://community.hubspot.com/t/data-fields-properties-report/114703 "2024-08-18T21:18:10Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![KNagpal9](https://avatars.discourse-cdn.com/v4/letter/k/3e96dc/32.png) [@KNagpal9](https://community.hubspot.com/u/KNagpal9)\ **Post date:** [August 18, 2024, 9:18pm UTC](https://community.hubspot.com/t/data-fields-properties-report/114703/1 "2024-08-18T21:18:10Z")
I need help creating reports for the fields/properties of an object to see how much data is populated in each field. Example- For deals, I want to see which field is populated/not populated and how much. Similarly for other objects as well. ---
**Author:** ![jnix284](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jnix284/32/29_2.png) [@jnix284](https://community.hubspot.com/u/jnix284)\ **Post date:** [August 18, 2024, 11:09pm UTC](https://community.hubspot.com/t/data-fields-properties-report/114703/2 "2024-08-18T23:09:12Z")
Hi @KNagpal9 happy to help with your question about what fields are used and which aren’t. HubSpot includes a [Data Model](https://knowledge.hubspot.com/data-management/view-a-model-of-your-crm-object-and-activity-relationships) that let’s you visualize your CRM architecture and how the various objects (Contacts, Companies, Deals, Tickets, and custom objects) relate to each other and activities (calls, emails, etc.) Within the Data Model, you can click into each object to see Property Insights: ![Jnix284_0-1724022362018.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/b/8b77a26752b1604ab79e70a783f74b955654e614.png) When you click the Properties tab, you can see where the properties are used and what the Fill Rate (%) is. To do this, it requires Ops Hub Pro or Enterprise. You’d also gain access to the [Data Quality](https://knowledge.hubspot.com/data-management/data-quality-command-center) tools, which includes a [weekly notification](https://knowledge.hubspot.com/reports/receive-a-weekly-data-quality-digest) to review your property usage, etc. as well as the ability to monitor specific qualities. ---
**Author:** ![KNagpal9](https://avatars.discourse-cdn.com/v4/letter/k/3e96dc/32.png) [@KNagpal9](https://community.hubspot.com/u/KNagpal9)\ **Post date:** [August 19, 2024, 2:52am UTC](https://community.hubspot.com/t/data-fields-properties-report/114703/3 "2024-08-19T02:52:11Z")
Can I still export these properties that have no data even if I don’t have Ops Hub Pro or Enterprise? Also, what does unused stand for in this? Does that mean that the property is not being used in any workflow, campaign, or segment? Also, I am not able see the data model for leads any specific reason ? ---
**Author:** ![jnix284](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jnix284/32/29_2.png) [@jnix284](https://community.hubspot.com/u/jnix284)\ **Post date:** [August 19, 2024, 11:46am UTC](https://community.hubspot.com/t/data-fields-properties-report/114703/4 "2024-08-19T11:46:38Z")
@KNagpal9 here are the answers to your questions: 1. With any subscription you can [export properties](https://knowledge.hubspot.com/properties/organize-and-export-properties) and [export the property history](https://knowledge.hubspot.com/properties/export-property-history) and with the CRM API you can [retrieve properties](https://knowledge.hubspot.com/properties/export-property-history). The export functionality for properties with no data is part of the data quality tools and isn’t possible without the Pro or Enterprise subscription - you could either start a 2 week trial if you only need temporary access, or you could run a script to gather the data you need. I used Hub Helper Harry (an AI chatbot built with chatGPT and trained on HubSpot) to generate a starting point: " To export properties that have no values, you would typically need to: 1. **Identify Properties with Null or Empty Values** : First, go through your dataset and identify the properties that are either `null`, `undefined`, or have empty values (e.g., empty strings or arrays). 2. **Filter and Export** : After identifying these properties, you can create a script (e.g., in Python, JavaScript, or another programming language) to filter out entries that have values and then export the remaining properties without values. Here’s a general approach you can use, depending on your dataset structure (e.g., JSON): Example with JSON Data in Python: ```lia-code-sample import json # Load your JSON data with open('data.json', 'r') as file: data = json.load(file) # Initialize a list to store properties with no values empty_properties = [] # Iterate through the JSON data for entry in data: for key, value in entry.items(): if value in [None, '', [], {}]: # Adjust conditions based on your needs empty_properties.append({key: value}) # Export the empty properties to a new file with open('empty_properties.json', 'w') as output_file: json.dump(empty_properties, output_file, indent=4) print("Exported properties with no values ``` " I didn’t test this code and it may require further modifications. 1. Unused means these properties aren’t being used in any tools, which would include workflows, campaigns, lists, forms, etc. 1. The leads object is a pseudo object, or secondary object, that is a subset of the contact object. I’m not sure why it’s not included in the Data Model other than it having just been recently released. ---
**Author:** ![KNagpal9](https://avatars.discourse-cdn.com/v4/letter/k/3e96dc/32.png) [@KNagpal9](https://community.hubspot.com/u/KNagpal9)\ **Post date:** [August 20, 2024, 1:49am UTC](https://community.hubspot.com/t/data-fields-properties-report/114703/5 "2024-08-20T01:49:43Z")
![KNagpal9_0-1724118544720.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/3/f339431b0900e73ca9e7763417a80eed38f5b5b6.png) I see the above screenshot when Iopen leads in hubspot any specific reason? ---
**Author:** ![jnix284](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jnix284/32/29_2.png) [@jnix284](https://community.hubspot.com/u/jnix284)\ **Post date:** [August 20, 2024, 2:10am UTC](https://community.hubspot.com/t/data-fields-properties-report/114703/6 "2024-08-20T02:10:34Z")
Where are you opening leads @KNagpal9 ? in the data model or directly in the workspace? ---
**Author:** ![noahmckeon](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/noahmckeon/32/78446_2.png) [@noahmckeon](https://community.hubspot.com/u/noahmckeon)\ **Post date:** [August 20, 2024, 7:11pm UTC](https://community.hubspot.com/t/data-fields-properties-report/114703/7 "2024-08-20T19:11:08Z")
@KNagpal9 Our migration platform includes an Estimator tool (completely free to use) which will do exactly what you’re asking for. If you connect it to your HubSpot portal, we’ll take a look at your objects and fields, then we’ll show you how populated each field is (% and #). You can access the tool [here](https://migratemycrm.syncmatters.com/estimate/register?utm_source=hs&utm_medium=social&utm_campaign=forum), then after registering click on the calculator icon on the left. Here’s a quick walkthrough: [Estimate - 20 August 2024 | Loom](https://www.loom.com/share/d9c5a15dc13440ea94ecb51ef9b3fbe1?sid=f69b48db-915f-490e-a5a3-21a13699a398) And here’s a snippet of the PDF that you’ll receive: ![Screenshot 2024-08-20 at 3.03.12 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/b/b606ee1b39b110f06015e0a92e075cfea2194160.png) Hope this helps! ---
**Author:** ![jnix284](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jnix284/32/29_2.png) [@jnix284](https://community.hubspot.com/u/jnix284)\ **Post date:** [August 20, 2024, 7:39pm UTC](https://community.hubspot.com/t/data-fields-properties-report/114703/8 "2024-08-20T19:39:10Z")
@noahmckeon sorry, replied to the wrong thread, disregard my previous question 🙂 ---
**Author:** ![KNagpal9](https://avatars.discourse-cdn.com/v4/letter/k/3e96dc/32.png) [@KNagpal9](https://community.hubspot.com/u/KNagpal9)\ **Post date:** [August 24, 2024, 7:57pm UTC](https://community.hubspot.com/t/data-fields-properties-report/114703/9 "2024-08-24T19:57:41Z")
Would you also know more about the deduping the companies since I currently have many companies created every time a new record enters the system? I want to set up a proficient process to ensure I can do bulk deduping to make it much easier.