Skip to main content
Datasource Customizations
Maximilian Rast avatar
Written by Maximilian Rast
Updated over a week ago

We have just released a powerful suite of datasource customizations that allow you to quickly adjust your data to reflect the reality of how your business operates.

  • ❌ Exclude Orders from Shop Datasource

  • πŸ” Identify Replacement Orders

  • 🧩 Ad Account Filters / Overlaps

  • βš™οΈ Product Information Configuration of Shopify

❌ Exclude Orders from Shop Datasource
Some orders are not part of your actual business and skew your data. Could be test orders or products sent to influencer. Simply filter them out based on tags, discount code or revenue value.
​
Also, together with the ability to create multiple stores, this gives you the flexibility to create different views on your data allowing you to quickly analyse your business in any way you want.

πŸ” Identify Replacement Orders
Same, same but different.


Replacement orders also skew your data but behave slightly different.

Here an example:
When a delivery is late or a product arrives broken, your customer service might manually create a new order and send it free of charge to the customers.
By default, this looks like this customer placed another order with a 100% discount which is obviously not what happened.

You also don't want to filter them out completely because you did have product and logistics costs for a second time.


Replacement orders solve this issues. Orders identified as replacements orders have an order count, revenue and discount/voucher of 0 but we do keep the product and logistics costs.

🧩 Ad Account Filters / Overlaps
There is not always a one to one relationship between stores and analytics or ad account datasources.

You might have multiple Shopify accounts but have the ads running for them through the same ad account.


Or you change your primary analytics views but the old one keeps collecting data.

Together with our new filtering logics and the ability to have multiple stores in Klar, you can now match up data.

Let's say you have two stores, one containing your Shopify business in the EU and the other containing your Shopify business in the US, but have ads running for both accounts through the same ad accounts.


You can now connect your ad account into both stores but apply a filter to it so that only campaigns that contain "EU" are included in the one and only campaigns that contain "US" are included in the other.

βš™οΈ Product Information Configuration of Shopify
Once you reach a certain size, you always wish that you had made clean data a priority as cleaning up takes forever.

With Klar, cleaning up your product names now takes a few seconds.
If you have changed the name of the same product (title, type, variant, SKU) over time, the same product will show up with multiple names in your reports. That will make life pretty tough.
​

With Klar, you can now simply edit your shop datasource and decide yourself if product meta information at the point of order (from the order table) or from today (from the product table) is being used.

Did this answer your question?