We use cookies to make HubSpot's community a better place. Cookies help to provide a more personalized experience and relevant advertising for you, and web analytics for us. To learn more, and to see a full list of cookies we use, check out our Cookie Policy (baked goods not included).
Dec 26, 2021 3:00 PM - edited Jan 6, 2022 4:16 PM
I was initially struggling with how to easily create realistic Hubspot sample data for testing. Something that would hopefully involve less work than juggling data between API calls.
For anyone else in a similar spot, here's a walkthrough for how to generate a large volume of realistic and associated records in the CRM using the Hubspot admin UI and Mockaroo.com (an online tool data generation tool) -
The video above and steps below detail creating a set of associated Companies, Contacts, and Deals – but a similar approach should work for other object types as well.
High-Level Steps (for example to create an associated set of Companies, Contacts, Deals) –
Example Generated Data
(CSV files that would be imported in step 3 above)
Example Input Data Sets
(CSV files that would be used in Mockaroo modeling in step 2 above. Some sets that have many options, like Web Technologies and Industry may make sense to duplicate and trim to a subset of meaningful values to have a greater likelihood of seeing repeat values and patterns across generated dummy data.)
Jan 18, 2022 11:03 PM
@Clayton_ 👌 clutch move to help the community power through details and start pumping out results.
Jan 6, 2022 9:29 AM
Jan 6, 2022 12:14 PM - edited Jan 6, 2022 12:14 PM
Well done @dennisedson, correct response : )
Makes me happy to see someone work hard, clearly communicate, and the community elevate the work #loveit
Again, well done @Clayton_.
@Clayton_
Jan 5, 2022 1:19 PM
@Clayton_ , this is great. Thanks for sharing. I love to have random movie sets or The A-Team as contacts for small projects : )
What you've here is a great rundown! Looking forward to incorporating some of your work here.
Dec 28, 2021 3:06 PM
Thanks for sharing, @Clayton_ ! This is fantastic 😄
![]() | Did you know that the Community is available in other languages? Join regional conversations by changing your language settings ! |