Expand my Community achievements bar.

SOLVED

Data Quality: Automated Process

Avatar

Level 1

Hi all,

We collect approximately 150-200 different eVars, a lot of which are built on frequently changing factors on the website (i.e. data layers/button clicks etc.)

Currently, we aim to manually audit this data twice a year but it is extremely time consuming and often is a lower priority.

We've been looking for a way to automate the process of checking that data is collecting the right data, in the right places etc.

Has anyone automated this process already and have any tips? Initial thoughts are to do it via report builder but again - setting up requests for 200 eVars seems quite time consuming.

Thanks!

1 Accepted Solution

Avatar

Correct answer by
Level 4

Data Quality is one key thing that needs focus but needs to be done at the right level of implementation.

We have build extensive Processes using Observe Point Audits and Few Custom Validation tools to check and make sure the data being captured is as per expectations.

The key validation has to happen before data lands to report suites and more automated validation you have the improvement in data quality is significant.

thanks

Saneesh

View solution in original post

3 Replies

Avatar

Correct answer by
Level 4

Data Quality is one key thing that needs focus but needs to be done at the right level of implementation.

We have build extensive Processes using Observe Point Audits and Few Custom Validation tools to check and make sure the data being captured is as per expectations.

The key validation has to happen before data lands to report suites and more automated validation you have the improvement in data quality is significant.

thanks

Saneesh

Avatar

Level 1

When you say "custom" validation tools - do you mean 3rd party tools or things you have built yourself?

Avatar

Level 4

Built it on our own. However, on the tools side Observe point has been really helpfull in enabling those tools.

So basically we been using the base as Observe point tool to provide the audit data and from that crawl data extract we were validation the data layer and variables, also setting up simulations to validate with use cases.