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 6, 2022 12:14 PM - edited Jan 6, 2022 12:14 PM
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