Testing Various Implementation Strategies for GROUPBY

  • The customer was interested in finding the most efficient method of grouping and summing transactions in Affinium Campaign.
  • Argos Analyzer can evaluate and compare the performance of many scenarios at the Process level, and identify those with the best performance.  In this case, tested scenarios included grouping with Affinium macros vs. SQL, and use of Temp Tables vs. Extract Process.
  • Results: For this customer, the run times varied from 2 hours to 2 minutes. The fastest run times resulted from implementation of Custom Macro, which further increased ROI by reducing the campaign development effort.
  • Benefits: By utilizing the Argos Analyzer tool, experts at Argos Group are able to identify, recommend, test, and evaluate various campaign logic strategies.