Automattic\WooCommerce\Admin\API\Reports\Orders\Stats

Segmenter::get_segment_selections_order_level() │ protected │ WC 1.0

Returns column => query mapping to be used for order-related product-level segmenting query (e.g. avg items per order when segmented by category).

Method of the class: Segmenter{}

No Hooks.

Return

Array. Column => SELECT query mapping.

Usage

// protected - for code of main (parent) or child class
$result = $this->get_segment_selections_order_level( $unique_orders_table );
$unique_orders_table(string) (required)
Name of SQL table containing the order-level segmenting info.

Segmenter::get_segment_selections_order_level() code WC 8.7.0

woocommerce/src/Admin/API/Reports/Orders/Stats/Segmenter.php 
protected function get_segment_selections_order_level( $unique_orders_table ) {
	$columns_mapping = array(
		'orders_count'        => "COUNT($unique_orders_table.order_id) AS orders_count",
		'avg_items_per_order' => "AVG($unique_orders_table.num_items_sold) AS avg_items_per_order",
		'avg_order_value'     => "SUM($unique_orders_table.net_total) / COUNT($unique_orders_table.order_id) AS avg_order_value",
		'total_customers'     => "COUNT( DISTINCT( $unique_orders_table.customer_id ) ) AS total_customers",
	);

	return $columns_mapping;
}