SQL like queries on DataWarehouse

Avatar

Avatar

gaurav2

Avatar

gaurav2

gaurav2

17-02-2010

On several occassions, you want Data Warehouse report which have particular value(s) of certain variable(s) only. But the interface allows only to select all values of the variable or none at all. If the query could have been created more like SQL queries where you could, for eg.

 

Select Gender, Age

Where Campaign variable = "Valentines email blast" AND Product = "Roses"

 

While in SiteCatalyst we have the ability  to do simple stuff like this through Segment but it is an overkill since I just want only 'Gender' and 'Age' values and not all other reports. And Discover is costly Smiley Indifferent !!

 

Ofcourse Group by etc. would be great as well if you have not used SAINT.

 

I suppose the resulting reports would be created much faster as well?

1 Comment (1 New)
1 Comment

Avatar

Avatar

rodan32

Avatar

rodan32

rodan32

21-02-2010

Unica's NetInsight includes this feature.