ONE12th is a Data, Marketing and Automation consultancy. In ONE12th they see the world rapidly heading into a more data-driven and automated future. With that vision, they came to Blendo and below is their story.

Read the full ONE12th’s case study here.

A few introductory words

Austin Tucker is a Data Engineer in ONE12th: “It is my responsibility to ensure that the data architecture we implement for our clients is representative of their data needs and the data that is available is relevant and pertinent for them to conduct business. This role allows for ONE12th to enable data-driven business action by setting up the necessary infrastructure for each of our clients to house and consume their data.”

The Challenge

“In the context of one of the projects we had with our client, we needed to include, in our solution, a data warehouse containing marketing data that was generated as a result of their ongoing and past digital efforts. While evaluating the methodology for extracting this information, it was determined that we would need a solution that used the respective APIs of those platforms, built out the parsing of that data and migrated it to a data warehouse solution, all while being on a scheduled routine so that data could be consistently updated.”

“We had previously investigated other ETL as a service solutions as these seemed to be the precise type of product we were looking for to perform this task. We also had experimented with connections to separate data warehousing solutions that could fit the model of our client.

By resolving this, we would be able to appropriately create links between all of our client’s data sources and allow for powerful insights on what was working for their digital marketing as related to sales.

Prior to Blendo, these deductions would be made with going between platforms and comparing numbers, utilizing the capabilities of spreadsheet programs.”

“Prior to Blendo, these deductions would be made with going between platforms and comparing numbers, utilizing the capabilities of spreadsheet programs.” 

How Blendo Helped

By introducing Blendo, we were able to set up a database that had pertinent digital marketing data from platforms such as Facebook Ads, Google Ads and Pardot on a consistent basis, which was a requirement to facilitate the insights generation component of our System of Intelligence solution.

Within this SOI is also a data warehousing infrastructure that has multiple databases that serve separate purposes such as reporting, application management, and raw data management, which in this case, Blendo is integrated into.

How Blendo Connects everything

With Blendo One12th syncs Salesforce Pardot, Salesforce, Linkedin Ads, Facebook Ads, and Google Ads in their MS SQL Server in Azure.

Results

The biggest impact that we saw by using Blendo was our ability to open up the SOI to be able to have one source of truth when it came to our data through our data warehousing solution.

“The biggest impact that we saw by using Blendo was our ability to open up the SOI to be able to have one source of truth when it came to our data through our data warehousing solution.”

By being able to accurately store most of our data sources in one standardized data repository, we can now report more efficiently, create suggestions for our clients to interact more expeditiously and, in the future, automate the insights generation and action selection processes of the SOI so that the most optimal decisions can be made for the business.

To those considering utilizing Blendo, one of the unheralded aspects of picking an ETL as a service to go with for your solution is customer support and service. Our experience with Blendo has been a mutually beneficial one, that has been open and responsive. Should you start to see problems with your pipelines, Blendo will consistently work with you to ensure that, as a customer, you can count on having the correct data flowing into your solution. I would say that Blendo has been one of our better experiences with a service provider due to their professionalism and commitment to always perform a job well.

“I would say that Blendo has been one of our better experiences with a service provider due to their professionalism and commitment to always perform a job well.”

Read the full ONE12th’s case study here.