What is a customer data hub

A Customer data platform (CDP) is a unified, persistent database for storing your customer data. A good CDP is a place where you can store large amounts of customer data and access/analyze it at will.

Why do you need a CDP?

A CDP is built to handle fragmented information across multiple production systems, monitor customer behaviors across different products, and make smart decisions based on each customer journey. To have an instant, unified view of a customer before or after he/she purchases a product is pivotal for a marketer to identify high-value prospects, optimize campaigns, and predict revenue.

As data is piling up at different applications, it will make more economical and operational sense to manage them in one place. This way you will not need customized solutions from point A to point B, and worry about breakage and surprise billings.

connect apps to acho studio
connect-all-apps-to-acho-studio

Now, how do you build a CDP? There are dozens of companies there building it. In this article however, we will teach you how to build a customer data hub at no costs within a few minutes.

How to build a CDP for free?

1. Connect to your customer data

First, connect your existing data. Let’s use Salesforce as an example. Once you have salesforce data connected to Acho’ Studio. You can start building your CDP in an Acho project. Each integration comes with a different set of tables, you can go to the integration page to check out what’s available in a Salesforce database for example.

connect salesforce to acho studio
connect-salesforce-to-acho-studio

2. Combine/manipulate the data

Within the project, you can access tables from different sources. Here I have a few tables open from Salesforce and Braintree (a payment processor). You can use the “join/union” action to combine these tables together to see the correlation between account history and the transactions made.

join multiple tables on acho studio
join-tables-on-acho-studio

3. Analyze the data

When exploring your datasets, you can use the built-in actions such as (filter, pivot table, SQL editor) to perform analytics. Try using the “Generate Summary” function to produce a quick chart on your columns. These analytical features are there to help you gain a better understanding of your customer data regardless of its sizes or formats. I just tried running a column summary on a table with more than 3 million records. It took about 10 seconds.

generate column summary on acho studio
generate-column-summary-acho-studio

4. Distribute the data

After exploring your datasets, you can share them with your teammates.

share a project on acho studio
share-project-on-acho-studio.

5. Calculate your usage

Around 50GB will be granted for free each month on Acho Studio. For example, you have a database that contains around 100MB of data, you can update or transform the table 512 times in a month. That’s more than a dozen times in a day.

By limiting your usage within the Free Plan’s allowance, you will essentially have a customer data platform for free. If your data usage jumps all of a sudden, you may consider an upgrade. Otherwise, take advantage of the free plan and build yourself a powerful customer experience.