* You are viewing the archive for the ‘QueryCell’ Category

Banner Ad Results

These three banners all ran on a website targeted squarely at computer geeks.

It seems that banner ads designed to look like part of the site itself are more effective, even with technically savvy audiences.

Is there something ethically wrong with running banner ads designed to look like part of the website ?  I’m not sure.

Banner 1 – Designed to look good
Banner1

Creative Name
Impressions Delivered
Clicks Recorded
Click Rate
Rounded

Banner1.gif
37225
46
0.123572868
0.13

Banner 2 – Designed fit in seamlessly with the website
Banner1Continue Reading

SQL Visual Query Builder

The recently released QueryCell V1.5 adds a visual query builder.

visual_builder

QueryCell Visual Query Builder

Being a long time SQL user and happy writing code I resisted adding a visual builder to QueryCell for a long time.  I was wrong to resist.

Users of QueryCell repeatedly told me they wanted a visual builder so they could create select statements, joins and aggregates without having to type it all up manually.

I think the new visual query builder has struck a good balance between the power of composing SQL directly and the convenience of … Continue Reading

Hello world, QueryCell now has a blog!

Welcome to The QueryCell Blog.

Over time I will be adding posts to this blog about QueryCell, data, SQL, Excel and anything else that seems relevant.

The next post will be about the right way to store relational data in Excel.