Order statistics

Group statistics by one or more dimensions. Each value is a <Table>.<field> key.

• Time.hour / Time.day / Time.month / Time.year — by date bucket
• Order.source / Order.order_sources — by order source / account
• Order.status — by order status code
• Order.warehouse_id — by warehouse
• Order.post_id — by Facebook post
• Order.partner_id — by shipping carrier
• Order.marketplace_id — by e-commerce marketplace
• Order.country_code / Order.province_id / Order.district_id / Order.commune_id / Order.region_filter — by shipping geography
• Order.tag — by order tag
• Order.is_wholesale / Order.is_livestream — wholesale / livestream flag
• Order.livestream_manager_ids — by livestream manager
• Order.total_price — by order total price bucket
• Order.ads_or_normal / Order.ad_account_id / Order.ad_id — ad partitioning
• User.id / User.sale_group / User.department_id — by staff / sale group / department
• Customer.id / Customer.level_id / Customer.new — by customer / level / new vs. old
• Variation.id / Variation.product_id — by variation / product
• Variation.category / Variation.supplier / Variation.brand_id / Variation.tag — by product taxonomy
• Variation.price_range / Variation.quantity_range — by product price/quantity bucket
• Variation.upsale / Variation.quantity — upsell flag / sold quantity
• UTM.p_utm_source / UTM.p_utm_campaign / UTM.p_utm_medium / UTM.p_utm_term / UTM.p_utm_content — by UTM tag
• Promotion.default / Promotion.advance / Promotion.combo — by promotion / combo
• Ads.ad_id / Ads.ad_set_id / Ads.ad_campaign_id — by ad / ad set / campaign

Filter applied to the order set. Object keyed by <Table>.<field>; each value is an array of strings. Append _exclude to a key to negate it (e.g. Order.status_exclude, Variation.category_exclude). Append _and to AND-combine multi-valued list filters (e.g. Variation.tags_and). Common keys:

• Variation.id / Variation.product_id — by variation / product
• Variation.category / Variation.supplier / Variation.brand_id / Variation.brand — by product taxonomy
• Variation.tag / Variation.tags / Variation.attribute — by product tag / attribute
• Variation.price_range / Variation.quantity_range / Variation.quantity — by product price/quantity
• Variation.upsale / Variation.one_time_product / Variation.is_bonus_product / Variation.product_price_of_zero / Variation.unlink_ecommerce — flag filters
• Order.source / Order.source_exclude / Order.order_sources — order source
• Order.status — order status code
• Order.warehouse_id / Order.post_id / Order.partner_id / Order.shop_partner_id / Order.marketplace_id — operational filters
• Order.country_code / Order.province_id / Order.district_id / Order.commune_id / Order.region_filter / Order.region_filter_phil — shipping geography
• Order.tag / Order.is_wholesale / Order.is_livestream / Order.received_at_shop / Order.is_upsale_order — order flags
• Order.total_price / Order.revenue — by total/revenue bucket
• Order.ad_id / Order.ads_source / Order.ad_account_id / Order.ads_or_normal — ads filters
• Order.order_currency — order currency
• Order.id / Order.project — by order id / project
• Order.p_utm_source / Order.p_utm_campaign / Order.p_utm_medium / Order.p_utm_term / Order.p_utm_content / Order.utm_affiliate / Order.link — UTM filters
• Order.instant / Order.N24H / Order.GSGN — service partner filters
• Order.livestream_manager_id / Order.livestream_manager_ids — livestream manager
• User.id / User.sale_group / User.department_id / User.pke_mkter / User.assigning_seller_id / User.assigning_care_id / User.item_assign_seller_id — staff filters
• Customer.id / Customer.level_id / Customer.gender / Customer.tag / Customer.conversation_tags / Customer.new / Customer.referral_code — customer filters
• Promotion.default / Promotion.advance / Promotion.id / Promotion.combo — promotion filters

Select fields