Backing out bad data in Omniture

Hello blog…I’ve missed you.  How are you these days? I see you’ve accumulated quite a lot of dust since last we spoke.

Oh right. 

Anywho…so my post today is actually a plea to blogistan. And to some extent Omniture. Since I know people occassionally read this, here is my dilema. I have some bad transactions in my data that I need removed. For reasons beyond my comprehension our website had $800,000 Thinkpads for sale and somehow someone bought one or two. Truth be told they were just pricing errors, but somehow those transactions went through and are now sitting in my data. Honestly, if we’d just sell 3 or 4 of these $800k computers we’d be having a fabulous quarter, so maybe we should figure out how to do more of them. But in reality this is just bad data. Unfortunately, bad data is not easy at all to remove from SiteCatalyst. 

If you ask Omniture, they’ll tell you to create a couple of new metrics and import via Data Sources so that you’d have a metric that says something like ‘Cancelled Revenue’, “Cancelled Units”, “Cancelled Orders”, etc and then create a calculated metric to net them out. Unfortunately, that would cause a ton of work to redo about a billion reports and cause a ton of user education to not use the metric called ‘revenue’ anymore. Shouldn’t we be able to just remove or alter the offending records if needed? I think so. Maybe I am crazy.

So, here is where I need your help. I know someone, somewhere has created a Data Source that has taken out bad records via using negative numbers. I’d love to hear how you’ve done it. I created a Data Source rule that had the real metrics like revenue, orders, units and then loaded in the bad order id and a negative number but nothing happened. I know the reason that this method is frowned upon as it has possibilites to corrupt the database and open up a wormhole in the fabric of the universe (saw Star Trek yesterday) but I don’t care, I want the bad data out. It looks ugly. I’m a big boy, I’ll take the risk. I just want to figure out how to do it.

The other route I’d love to see taken is for Omniture to create a way to do this via a GUI in SiteCatalyst. Almost treat Purchase IDs and data associated with it as a classification to some extent that can be altered. I know that the reason this doesn’t exist (or at least I think I do) is because all the data is pre-processed into OLAP cubes for speed of delivery and redoing that stuff would cause reprocessing and slow the whole cycle down. But there has got to be a way to do this. Because right now the only true solution is getting Omniture engineering to back that out for you and that isn’t remotely cheap, especially if it keeps happening all over the world.

To repeat myself…if you’ve cracked the code on how to do this, please post….and I’ll owe you a beer (or 10) at next years Summit.  Lets see the Wisdom of Crowds in action!

Advertisements

2 responses to “Backing out bad data in Omniture

  1. I have the same Problem. I tried to alter the Units and Revenue of products of a “thick-thumb-order”. Every other metric than these two were possible to subtract from the original value. Have you ever found out, if its possible?

  2. Same thing, I’ve been unable to reduce revenue with a negative value.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s