DMA Advents Article - Creative and Data Collection
Using data and business logic to drive ROI

Sum_Of_Valid_Charges ???

A funny thing happened on the way past our developers today.  I was asked what reports and calculations may be necessary to collect and display out of the next iteration of our shopping cart.  Now, I’m not a tech guy and the database schema was laid out in all its complexity for my review.  I was stumped by the column temporarily titled “Sum_Of_Valid_Charges” and asked what it was.  Our otherwise brilliant database guru explained the data field to me (at least three times – I’m slow) and how it was calculated and the relationships among the various pipes and tables.  I asked if there were “invalid charges.” No?  Ok then, what is it?  In the end, I got “well, it’s pretty much the total billed minus refunds.”  Eureka – there is your title.  Why not just called it what it is?  The expression on his face was priceless.  He sheepishly looked at me, sighed, and said I really hate you, in a most respectful way, of course.  “Total_Billed_Minus_Refunds.”  It pays to call it like it is.


Nancy Scott

Great story... great lesson ... great K.I.S.S. :-)

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Your Information

(Name and email address are required. Email address will not be displayed with the comment.)