Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

SQL like queries on DataWarehouse

Avatar

Level 6

2/17/10

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