Measures tables | Acquia Product Documentation

Loading search...

Measures tables | Acquia Product Documentation

The following is the list of tables for standard measures:

Measure table	Description
Attribution	Attributing outcomes or results to specific factors such as marketing campaigns or customer interactions.
Customer	Quantifying aspects of customer behavior such as purchase frequency, lifetime value, or churn rate.
Cohorts	Focusing on groups of users who share common characteristics or experiences over a defined period, often used for cohort analysis.
Market Basket Analysis	Analyzing the co-occurrence or relationships between items purchased together, revealing patterns and associations in customer buying behavior.
Machine Learning	Deriving from machine learning models such as predictive accuracy, model performance metrics, or output scores.
Transaction	Relating to financial transactions such as revenue, average order value, or transaction count.

Attribution

Measure Name	Description	Pre-calculated field?
Attributed Buyer Count	The total number of individual customers converted in the attribution window.	No
Attributed Events	The total number of events attributed.	No
Attributed Sales Revenue	The sales revenue attributed to campaigns for the selected attribution type.	No
Attributed Transaction Count	The total number of transactions attributed to the campaign.	No
Attributed Transaction Line Count	The total number of transaction line items attributed to the campaign.	No
Average No Of Days to Convert	The average number of days to convert.	No
Email Click Rate	The ratio of email clicks to email sends.	No
Email Open Rate	The ratio of email opens to email sends.	No
Event Count	The total number of events in the selected date range.

Customer

Measure Name	Description	Pre-calculated field?
All Individuals Count	The count of distinct master customers.	No

Cohorts

Measure Name	Description	Pre-calculated field?
AOV in AttrWindow	The average order value (AOV) calculated within the Attribution window, representing the average monetary value of orders placed within the specified timeframe.	No
Average Unit Price in AttrWindow	The average price per unit of products sold within the Attribution window, reflecting the average cost per item purchased during the specified period.	No
Buyer Count in AttrWindow	The count of unique buyers who made purchases within the Attribution window, indicating the number of distinct customers contributing to transactions during the specified timeframe.	No
Conversion Rate in AttrWindow	The percentage of visitors or users who completed a desired action. For example, making a purchase within the Attribution window, relative to the total number of visitors or users within the specified timeframe.	No
Discount Amount in AttrWindow	The total amount discounted from transactions within the Attribution window, representing the cumulative value of discounts applied to purchases during the specified period.

Market Basket Analysis

Sub-Group	Measure Name	Description	Pre-calculated field?
-	Combined Sales Revenue	The sales revenue for the combination.	No
-	Combined Transaction Count	The total count of all transactions.	No
First Item Details	First Number of Association	The total number of different items purchased together with the first item.	No
First Item Details	First Sales Revenue Contribution	The sales revenue contribution of the first item in the combination.	No
First Item Details	First Total Quantity	The total quantity for the first item.

Machine Learning

Sub-Group	Measure Name	Description	Pre-calculated field?
CC Studio	Custom Calculation Measure	The custom calculation measure created within CC Studio for specific analytic needs.	No
Evaluation - Clustering Model	Cluster Silhouette	A metric to assess the quality of clusters formed by a clustering algorithm, based on cluster cohesion and separation.	No
Evaluation - Clustering Model	Cluster Stability	A measure to assess the stability of clusters across different subsets of data or different runs of the clustering algorithm.	No
Evaluation - Clustering Model	Cluster WSS	A Within-cluster sum of squares (WSS) measure to assess the compactness of clusters in a clustering algorithm.	No

Transaction

Measure Name	Description	Pre-calculated field?
AOV	The average order value for transactions calculated using [Product Revenue] / [Transaction Count].	No
Average Unit Price	The average unit price for transactions calculated using [Product Revenue] / [Product Quantity].	No
Buyer Count	The count of distinct master customers with at least one transaction.	No
Discount Amount	The discount amount for transactions.	No
Items Count	The count of distinct products bought in transactions.	No
Margin per Customer	The margin per customer based on transactions calculated using [Total Margin] / [Buyer Count].	No
Product Cost	The product Cost Of Goods Sold (COGS) for transactions.

The following is the list of tables for standard measures:

Measure table	Description
Attribution	Attributing outcomes or results to specific factors such as marketing campaigns or customer interactions.
Customer	Quantifying aspects of customer behavior such as purchase frequency, lifetime value, or churn rate.
Cohorts	Focusing on groups of users who share common characteristics or experiences over a defined period, often used for cohort analysis.
Market Basket Analysis	Analyzing the co-occurrence or relationships between items purchased together, revealing patterns and associations in customer buying behavior.
Machine Learning	Deriving from machine learning models such as predictive accuracy, model performance metrics, or output scores.
Transaction	Relating to financial transactions such as revenue, average order value, or transaction count.

Attribution

Measure Name	Description	Pre-calculated field?
Attributed Buyer Count	The total number of individual customers converted in the attribution window.	No
Attributed Events	The total number of events attributed.	No
Attributed Sales Revenue	The sales revenue attributed to campaigns for the selected attribution type.	No
Attributed Transaction Count	The total number of transactions attributed to the campaign.	No
Attributed Transaction Line Count	The total number of transaction line items attributed to the campaign.	No
Average No Of Days to Convert	The average number of days to convert.	No
Email Click Rate	The ratio of email clicks to email sends.	No
Email Open Rate	The ratio of email opens to email sends.	No
Event Count	The total number of events in the selected date range.

Customer

Measure Name	Description	Pre-calculated field?
All Individuals Count	The count of distinct master customers.	No

Cohorts

Measure Name	Description	Pre-calculated field?
AOV in AttrWindow	The average order value (AOV) calculated within the Attribution window, representing the average monetary value of orders placed within the specified timeframe.	No
Average Unit Price in AttrWindow	The average price per unit of products sold within the Attribution window, reflecting the average cost per item purchased during the specified period.	No
Buyer Count in AttrWindow	The count of unique buyers who made purchases within the Attribution window, indicating the number of distinct customers contributing to transactions during the specified timeframe.	No
Conversion Rate in AttrWindow	The percentage of visitors or users who completed a desired action. For example, making a purchase within the Attribution window, relative to the total number of visitors or users within the specified timeframe.	No
Discount Amount in AttrWindow	The total amount discounted from transactions within the Attribution window, representing the cumulative value of discounts applied to purchases during the specified period.

Market Basket Analysis

Sub-Group	Measure Name	Description	Pre-calculated field?
-	Combined Sales Revenue	The sales revenue for the combination.	No
-	Combined Transaction Count	The total count of all transactions.	No
First Item Details	First Number of Association	The total number of different items purchased together with the first item.	No
First Item Details	First Sales Revenue Contribution	The sales revenue contribution of the first item in the combination.	No
First Item Details	First Total Quantity	The total quantity for the first item.

Machine Learning

Sub-Group	Measure Name	Description	Pre-calculated field?
CC Studio	Custom Calculation Measure	The custom calculation measure created within CC Studio for specific analytic needs.	No
Evaluation - Clustering Model	Cluster Silhouette	A metric to assess the quality of clusters formed by a clustering algorithm, based on cluster cohesion and separation.	No
Evaluation - Clustering Model	Cluster Stability	A measure to assess the stability of clusters across different subsets of data or different runs of the clustering algorithm.	No
Evaluation - Clustering Model	Cluster WSS	A Within-cluster sum of squares (WSS) measure to assess the compactness of clusters in a clustering algorithm.	No

Transaction

Measure Name	Description	Pre-calculated field?
AOV	The average order value for transactions calculated using [Product Revenue] / [Transaction Count].	No
Average Unit Price	The average unit price for transactions calculated using [Product Revenue] / [Product Quantity].	No
Buyer Count	The count of distinct master customers with at least one transaction.	No
Discount Amount	The discount amount for transactions.	No
Items Count	The count of distinct products bought in transactions.	No
Margin per Customer	The margin per customer based on transactions calculated using [Total Margin] / [Buyer Count].	No
Product Cost	The product Cost Of Goods Sold (COGS) for transactions.