Use the Data Cleaning tab to manage the size of your analytics storage.
You can (1) clear individual tables, (2) delete old data by time period, (3) wipe everything, and (4) optimize tables.

---

What you see on this page

1) Table overview (size & quick actions)

A table lists the core storage tables with their purposes and current size:

• Clicks (wpmc_clicks) — individual click data (selectors, labels, coordinates, actions, targets).
• Views (wpmc_views) — page views, user IDs, scroll depth, device type, referrer info, timestamps.
• Sessions (wpmc_sessions) — session-level metadata (referrer, device type, user agent, last activity).

Each row shows:

• Table (exact DB table name)
• Purpose (what the table stores)
• Size (calculated via INFORMATION_SCHEMA, i.e., reserved space)
• Action → Clear [Table] (truncate this table only)

Important: “Clear” removes all data from that specific table (TRUNCATE). It cannot be undone.

---

2) Delete all tracking data

A separate section with a single action:

• Delete All Tracking Data — clears Clicks, Views, and Sessions in one go.

This is permanent. Use when you want a full reset (e.g., after a redesign or before a fresh test).

---

3) Delete old data (by period)

A form to remove records older than a chosen threshold.
Typical flow:

1. Select a time period (e.g., “older than 30 days” / a specific cutoff date).
2. Confirm deletion.
3. The plugin deletes rows older than that threshold from Clicks, Views, and Sessions.

This keeps recent data intact while freeing space from legacy records.

---

4) Optimize tables

• Optimize WPMC Tables — runs OPTIMIZE TABLE for wpmc_clicks, wpmc_views, and wpmc_sessions.
• This can reclaim space after large deletions and improve table statistics.

Note: Displayed sizes may not drop immediately after deletion until optimize completes.

---

How to use (recommended workflows)

A) Quick cleanup of one data type

1. Find the row (e.g., Clicks).
2. Click Clear Clicks.
3. Confirm the prompt.

B) Delete everything (full reset)

1. Use Delete All Tracking Data.
2. Confirm.
3. Optionally run Optimize afterward.

C) Prune old records, keep recent data

1. In Delete old data, choose your cutoff (e.g., older than 90 days).
2. Confirm deletion.
3. Click Optimize to reclaim space.

---

Safety notes

• All delete actions are permanent (no undo).
• Clearing a table may impact charts and heatmaps until new data accumulates.
• If you rely on historical comparisons, use Delete old data (periodic cleanup) instead of full clears.