4 Replies Latest reply: Sep 22, 2017 3:20 AM by Asuncion Vazquez RSS

    Filtering Google Analytics data in load script

    Asuncion Vazquez

      Hi all,

       

      I need to filter data from different Google Analytics data connections in my load script.

       

      I have seen examples of filtering using "where" SQL statement but I've always got error when tried.

       

      For example, how could I edit this script:

       

      GARsummaryM:

      LOAD

          dim_yearMonth,

          metric_newUsers

      FROM [lib://GAR-summary-mensual (escorpesqs_divisadero)]

      (qvx);

       

      to get only data matching dim_yearMonth = '201701' or metric_newUsers > 1000?

       

      Regards,

       

      Suni