How to Inspect & Export Database Logs

AdFuz maintains an immutable, relational audit log inside the wp_adfuz_audit_logs database table. This log records who changed what, when, from which IP address, and captures before/after values of modified campaign and ad settings.

You can inspect, search, and export database audit logs from WordPress Admin > AdFuz > Tools > Database Logs.

---

Database Logs Overview Interface

The Database Logs viewer provides a complete audit trail of user and API actions:

1. Summary Health Counters

Top metric cards give an instant breakdown of your audit records:

• Total: Total audit records logged in the database.
• Errors 0: Failed database operations or invalid API payloads.
• Critical 0: Security anomalies or privilege escalations.
• Warnings 0: Rate-limiting alerts or deprecated attribute usage.
• Info 2: Successful create, update, and delete mutations.

---

Filter & Search Options

The filter bar enables granular investigation of historical events:

Filter Field	Options	Purpose
Log Level	All levels, Info, Warning, Error, Critical	Filter by severity level
Action	All actions, insert, update, delete	Filter by mutation type
Entity Type	All entities, campaign, ad, ad_space, setting	Filter by target entity model
Date	Datepicker (dd-mm-yyyy)	Scope records to a specific day
Search	Free-text search	Search within messages or diff payload text

---

Understanding Audit Table Columns

Each record in the audit log table contains the following data points:

Column	Example	Description
#	26	Unique auto-incrementing record ID
LEVEL	Info	Event severity classification
ACTION	update	Performed operation (insert, update, delete)
ENTITY	campaign #1	Affected entity type and ID
MESSAGE / CHANGES	> update	Diff breakdown of modified attributes
USER	wpadz	WordPress user login who initiated the action
IP	::1 / 192.168.1.1	Origin IP address of the request
DATE & TIME	Aug 28, 2026 15:33:10	Exact timestamp of execution

---

How to Export Audit Trail to CSV

For compliance audits, security reviews, or client reporting:

1. Go to AdFuz > Tools > Database Logs.
2. (Optional) Apply filters for a specific date range or entity type (e.g., campaign).
3. Click the Export CSV button in the top right header.
4. The filtered dataset will download immediately as a .csv spreadsheet containing all metadata, timestamps, user IDs, and payload diffs.

Pruning Audit Logs

To prevent excessive database growth on high-volume networks, older audit logs can be automatically archived or cleared under AdFuz > Tools > Database Tools > wp_adfuz_audit_logs > Clear Data.