Example: Monitoring Campaign Performance

In this example, marketing executives want to monitor how the various categories are performing currently for a particular campaign in the UK.

The marketing executives use this query to help them decide whether to intervene and take any action:

select wt.cg_n, wt.cg_s where ext.geo.country=united+kingdom, wt.mc_id=456

The resulting stream from this query can be processed on the client side with JavaScript or other means to create a running top n list of content groups:

  1. Tops
  2. Pants
  3. Skirts
  4. Shoes
  5. Perfumes
  6. Dresses
  7. Hair
  8. Cosmetics
  9. Sale
  10. Jackets