By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.
Case Study
February 28, 2024

How Monograph is Moving Upmarket with OneSchema

Architects and engineering firms use Monograph to track and analyze their performance across projects. Learn how OneSchema provided Monograph with the ease of adoption, flexibility, and cost-effectiveness they were looking for in a data importer tool.

Andrew Luo
Andrew is the co-founder & CEO at OneSchema.
“Even if OneSchema was priced 10x what it was today, it would be worth it - I still wouldn’t want to build my own.”
Devin Burke
Senior Software Engineer at Monograph
"The biggest thing was OneSchema allowed us to write our own validation hooks in our system, in our language. Other platforms don't allow you to do that."
Devin Burke
Senior Software Engineer at Monograph
“When you move towards a more defined solution like OneSchema, it then allows you to have more well-tested migrations. Now that we have built it out, we have tests and more confidence around data migrations.”
Devin Burke
Senior Software Engineer at Monograph
"If we were a company with only one competitor, building an in-house solution might make sense, but we saw all different kinds of companies coming through. By using OneSchema, Monograph is able to focus on building the product and scaling with our customers.”
Devin Burke
Senior Software Engineer at Monograph
Automate CSV imports from anywhere
Companies like Ramp, Toast, Scale AI, and Vanta trust OneSchema to provide a delightfully guided spreadsheet import experience for their customers.

Request a demo

Problem

Architects and engineering firms use Monograph to track and analyze their financial and operational performance across projects. As Monograph expanded its services to larger customers, robust data migrations became a top priority. Monograph implemented manual methods, but they weren’t scalable. Since each customer file was not standardized, each data file had different required columns / mapping validations. Unimported data migrations piled up, and the team knew they needed a better long-term solution. Being able to ingest customer data quickly and efficiently was a key component of Monograph’s onboarding experience. After evaluating different solutions for a data importer tool, they arrived at the conclusion that with each customer having 10-15 different data sources, building a generic data importer tool in-house wasn’t feasible. 

Solution

During Monograph’s evaluation process, Devin Burke, lead engineer heading the onboarding and data migrations project, highlighted the most important factors: 

Time to Market

Monograph knew that building an in-house importer didn't make sense for their business. It wasn't just a matter of cost-savings. Devin had worked at a data migrations company previously and knew firsthand how complicated data migrations could be.

{{quote-1}}

He knew that as an application grows over time and new features are added, each one of those new features could potentially break the data migration flow. A senior engineer on the team was leading these migrations for large, new customers and much of the time was spent in Excel data cleaning, which is now automatically done with OneSchema. As Devin puts it, "You don't need senior engineers working in Excel to validate data and work on data transformations, but sometimes you have to. "

Monograph was drawn to the ease of adoption and flexibility of Oneschema, allowing them to implement a frontend immediately and use OneSchema out of the box.

{{quote-2}}

This level of flexibility allowed Monograph to focus on building out their product while OneSchema handled the template header matching and data validation layer.

Ease of Adoption

OneSchema was more user-friendly for their developers and more plug-and-play compared to other options. During their initial presentations, OneSchema Devin noted that OneSchema was faster to implement compared to other solutions and had predefined validations that they still use to this day, which meant less code for them to write. In contrast, other data importer platforms didn't have any custom validations to use out of the box or would have required them to learn a new language. 

Another important requirement for Monograph was that the tool needed to be clean and user-friendly for their customer experience team. Devin explained that OneSchema's UI for fixing errors was more intuitive to use compared to other options.

{{quote-3}}

Monograph's complex data required a tool that could scale and handle importing from multiple SaaS platforms.

Cost Benefit Analysis

When it came down to the cost-benefit analysis, Monograph found that using a third-party option like OneSchema had strong ROI. Devin explained that with an in-house solution, there wouldn't be additional new features unless they built it themselves. In contrast, with OneSchema, they saved upfront on development costs and have been pleased with monthly new feature launches. With increasing migrations on the horizon, Monograph knew that building a generic importer wasn’t an option. Additionally, with 10-15 different data sources, OneSchema could handle standardization across all templates, and the Monograph team was able to create a single template to map across the board. 

Results

This sub table in Monograph's product represents each webhook sent from OneSchema

Monograph found that OneSchema provided them with the ease of adoption, flexibility, and cost-effectiveness they were looking for in a data importer tool.

{{quote-4}}

{{blog-content-cta}}

Problem

Architects and engineering firms use Monograph to track and analyze their financial and operational performance across projects. As Monograph expanded its services to larger customers, robust data migrations became a top priority. Monograph implemented manual methods, but they weren’t scalable. Since each customer file was not standardized, each data file had different required columns / mapping validations. Unimported data migrations piled up, and the team knew they needed a better long-term solution. Being able to ingest customer data quickly and efficiently was a key component of Monograph’s onboarding experience. After evaluating different solutions for a data importer tool, they arrived at the conclusion that with each customer having 10-15 different data sources, building a generic data importer tool in-house wasn’t feasible. 

Solution

During Monograph’s evaluation process, Devin Burke, lead engineer heading the onboarding and data migrations project, highlighted the most important factors: 

Time to Market

Monograph knew that building an in-house importer didn't make sense for their business. It wasn't just a matter of cost-savings. Devin had worked at a data migrations company previously and knew firsthand how complicated data migrations could be.

{{quote-1}}

He knew that as an application grows over time and new features are added, each one of those new features could potentially break the data migration flow. A senior engineer on the team was leading these migrations for large, new customers and much of the time was spent in Excel data cleaning, which is now automatically done with OneSchema. As Devin puts it, "You don't need senior engineers working in Excel to validate data and work on data transformations, but sometimes you have to. "

Monograph was drawn to the ease of adoption and flexibility of Oneschema, allowing them to implement a frontend immediately and use OneSchema out of the box.

{{quote-2}}

This level of flexibility allowed Monograph to focus on building out their product while OneSchema handled the template header matching and data validation layer.

Ease of Adoption

OneSchema was more user-friendly for their developers and more plug-and-play compared to other options. During their initial presentations, OneSchema Devin noted that OneSchema was faster to implement compared to other solutions and had predefined validations that they still use to this day, which meant less code for them to write. In contrast, other data importer platforms didn't have any custom validations to use out of the box or would have required them to learn a new language. 

Another important requirement for Monograph was that the tool needed to be clean and user-friendly for their customer experience team. Devin explained that OneSchema's UI for fixing errors was more intuitive to use compared to other options.

{{quote-3}}

Monograph's complex data required a tool that could scale and handle importing from multiple SaaS platforms.

Cost Benefit Analysis

When it came down to the cost-benefit analysis, Monograph found that using a third-party option like OneSchema had strong ROI. Devin explained that with an in-house solution, there wouldn't be additional new features unless they built it themselves. In contrast, with OneSchema, they saved upfront on development costs and have been pleased with monthly new feature launches. With increasing migrations on the horizon, Monograph knew that building a generic importer wasn’t an option. Additionally, with 10-15 different data sources, OneSchema could handle standardization across all templates, and the Monograph team was able to create a single template to map across the board. 

Results

This sub table in Monograph's product represents each webhook sent from OneSchema

Monograph found that OneSchema provided them with the ease of adoption, flexibility, and cost-effectiveness they were looking for in a data importer tool.

{{quote-4}}

{{blog-content-cta}}

Stay Connected

Subscribe to receive our newsletter.