Data Storage Configuration #

inPIPE stores your marketing tracking data in your WordPress database. This section explains how to configure data storage settings for optimal performance and compliance with data retention policies.

Database Structure #

inPIPE uses the following custom database tables:

• wp_inpipe_utm_records: Stores UTM parameter data

  • utm_source
  • utm_medium
  • utm_campaign
  • utm_term
  • utm_content
  • created_at
  • updated_at

• wp_inpipe_pluginsettings: Stores plugin configuration

  • utm_tracking_enabled
  • utm_processing_enabled
  • created_at
  • updated_at

• wp_inpipe_service_connections: Manages external service integrations

  • service_name
  • service_type
  • connection_data
  • created_at
  • updated_at

Note: The “wp_” prefix may differ based on your WordPress configuration.

Data Retention Settings #

inPIPE includes configurable data retention periods:

• UTM Records: Default 30 days (configurable)
• Subscription Logs: 180 days (6 months)
• Debug Logs: 30 days

To configure retention periods:

1. Navigate to inPIPE → Settings → Data Storage
2. Set your preferred retention periods
3. Click Save Changes

Automatic Cleanup #

The plugin automatically manages data cleanup:

• UTM Records: Cleaned after retention period expires
• Log Files: Automatically purged based on retention settings
• Cache: Regularly cleared to maintain performance

Database Optimization #

To maintain optimal performance:

1. Navigate to inPIPE → Tools → Database
2. Use the following tools:
   • Cleanup Now: Manually remove expired data
   • Optimize Tables: Improve database performance
   • Clear Cache: Remove temporary data

Data Export #

Export your marketing data in multiple formats:

1. Navigate to inPIPE → Reports
2. Select your desired:
   • Date range
   • UTM parameters
   • Export format (CSV/JSON)
3. Click Export

Storage Requirements #

• Base Installation: ~2MB
• UTM Records: ~1KB per record
• Service Connections: ~5KB per connection
• Logs: Varies based on activity

Privacy & Compliance #

When configuring data storage:

• Set retention periods according to your privacy policy
• Consider GDPR requirements for EU visitors
• Review data storage laws in your region
• Enable IP anonymization if needed

Backup Recommendations #

• Include inPIPE tables in your WordPress backups
• Regular backup frequency based on data volume
• Test backup restoration periodically
• Store backups securely

Properly configured data storage settings help maintain optimal plugin performance while ensuring compliance with data privacy requirements.