The Custom Calculations feature improves data-driven decision-making with new patterns and insights. It connects with main features such as Action, Analytics, and 360 Profile for marketers. To use this feature effectively, you must have SQL and Python skills.

Features¶

• Flexibility in calculation: Add new custom calculations to the existing data calculation standards. This enhancement broadens business case applicability to offer a complete solution for various requirements.

• Notebook-based framework: Simplify adoption with an easy-to-use Jupyter notebook framework.

  This method uses the following:

  • SQL queries to fit the scoring model and achieve the required output
  • Python commands for quick learning of users
• Streamlined deployment: Get a streamlined process that offers a clear, UI-guided, step-by-step pathway for creating queries, reviewing results, and deploying data in real time across key features such as Campaign+, Metrics, and 360 Profiles. This process is streamlined from concept to execution.
• Accelerated learning curve:  Simplify the adoption process with pre-built demo notebooks, covering basic to advanced custom calculation scenarios to highlight possibilities and inspire user innovation.

Capabilities:¶

Data analysts and scientists can:

• Create simple to complex custom calculations in CDP. 
  • Beginners start with basic analyses such as counting customers' discounted return orders from the past week
  • Advanced users calculate complex metrics such as RFM scores for each customer.
• Create or update custom calculations for customer segmentation in campaigns. Rapid code iteration facilitates quick data adaptation and refinement using real-time insights.
• Identify KPI opportunities and generate relevant custom calculations. These insights refine marketing strategies, act as dynamic filters for campaign execution, and provide key metrics for reporting. Additionally, they enhance 360 Profiles by providing a deeper understanding of customer behavior and preferences.
• Create or update custom calculations and adjust scoring views or data for customer segmentation within campaigns. This rapid cycle of code updates enables quick data adaptation and refinement, using insights to improve results.

Important considerations¶

• Custom calculations limit: Maximum five custom calculations are supported. To exceed this limit, consult with the customer value manager (CVM).

• SQL scope of calculations: Custom calculations are supported only at the master-customer level.

• Data type display: Currently, only string columns are displayed. While decimal data types can be calculated, their self-service display is not yet supported.

• Expansion of tables: Acquia does not recommend you to expand the available tables. For exceptions, create a Support ticket. Each request is assessed for feasibility.

• Scheduler frequency: The scheduler for calculation refreshes is currently set to operate daily.

Available Entities¶