A reference for what the plugin stores and what it reads. It creates one table and a couple of options of its own; everything else in a report is read from data WooCommerce already holds.

Table created by the plugin

{prefix}acreports_activity stores the Pro activity log. It is created the first time the plugin runs in the admin and is left in place when the plugin is deactivated.

id             mediumint(9)  AUTO_INCREMENT
user_id        mediumint(9)
activity_type  varchar(255)
activity_date  datetime
details        text

activity_type is one of order, login, subscription, subscription_renewal, payment_failed, coupon_applied, billing_address_updated, shipping_address_updated or password_updated. details holds an order ID or a coupon code depending on the type.

Options

• acreports_settings – an array holding activity_per_user, sort_users_by and merge_guest_orders.
• acreports_activity_db_version – the activity table schema version, so the table check does not run on every admin page load.

Coupon meta

Coupons generated from the recommended actions panel carry meta identifying who they were created for, which is how duplicates are detected:

• _acreports_recommended_action_type – winback, second_order or loyalty.
• _acreports_recommended_action_user_id – the customer’s user ID, or 0 for a guest.
• _acreports_recommended_action_username
• _acreports_recommended_action_customer_email
• _acreports_recommended_action_is_guest – yes or no.
• _acreports_recommended_action_created_at
• _acreports_recommended_action_created_by – the username of the admin who generated it.

WooCommerce data the plugin reads

• {prefix}wc_order_stats – order totals, statuses, dates, tax and item counts.
• {prefix}wc_customer_lookup – the customers list and customer search, including guests as the rows with no user ID.
• {prefix}woocommerce_order_items and {prefix}woocommerce_order_itemmeta – line items, shipping method names and coupon codes.
• {prefix}wc_orders, {prefix}wc_order_operational_data, {prefix}wc_order_addresses and {prefix}wc_orders_meta – per-order fields when HPOS is enabled. On legacy storage these come from post meta instead.
• {prefix}woocommerce_sessions – the Cart tab.
• The comments table, for order notes.

Order attribution is read from order meta under the _wc_order_attribution_ prefix, which the plugin resolves through WooCommerce’s own wc_order_attribution_tracking_field_prefix filter rather than hard coding it.

Persistent cart

Saved carts are read from the user meta key _woocommerce_persistent_cart_{blog_id}, which is WooCommerce’s own. The plugin only reads it.

Related

• How report data is compiled
• Action hooks reference
• The customer activity log (Pro)