Post Pay Counter

The best way to pay authors on WordPress

  • Features
    • PRO version
  • Cart
    • Addons
  • Documentation
  • Support

General

  • Pay writers per visit on WordPress
  • Shortcodes – Display stats in public pages
  • Define settings priority (user, role, category)
  • Pay per bbPress Topics and Replies
  • Caching features and stats snapshots
  • WP-CLI commands

Payment features

  • Payment features and PayPal payments
  • Setup an effective payment flow for lifetime visits
  • PayPal setup and configuration
  • Set users’ PayPal email address

Developer documentation

  • Add a custom payment criteria
  • Add a custom column to the stats table
  • Set users’ PayPal email address
  • Extract selected information from stats table
  • Handle massive Analytics data imports
  • Backup plugin data
  • Caching features and stats snapshots
  • Hide stats columns from BuddyPress Members page
  • WP-CLI commands

Analytics integration

  • Google Analytics setup and configuration
  • The future of Google Analytics integration and support for GA4
  • Matomo Analytics setup and configuration
  • Plausible Analytics setup and configuration
  • Migrate visits data away from Google Analytics
  • Share Google Adsense revenue with authors
  • Fix the “All Website Data” Analytics label issue
  • Handle massive Analytics data imports

Troubleshooting

  • Fixed a Publisher Bonus issue with complex settings setups
  • Issue with Publisher Bonus negative due payment
  • License activation failure with timeout error
  • Home
  • Docs
  • Developer documentation
  • Backup plugin data

There are cases in which you may want to backup data from Post Pay Counter (and maybe Post Pay Counter PRO). If you have access to PhpMyAdmin, this can be easily achieved through a handful of custom queries that can pull out all relevant data. Selected rows can then be exported in a SQL file, serving as a backup. The three queries are the following:

SELECT * FROM wp_options WHERE option_name IN ("ppc_settings", "ppc_errors", "ppcp_ga_stuff", "ppc_dismissed_notifications", "ppc_addons_list", "_ppcp_payment_history", "ppcp_ga_first_request", "ppcp_ga_last_request")

SELECT * FROM wp_postmeta WHERE meta_key IN ( "_ppcp_ga_visits", "_ppcp_adsense_revenue", "_ppcp_ga_data", "_ppcp_payment_history",  "_ppcp_exclude")

SELECT * FROM wp_usermeta WHERE meta_key IN ( "_ppcp_payment_history" ) OR meta_key LIKE "%ppcp_paypal_email"

These queries will extract all Post Pay Counter and Post Pay Counter PRO data (general settings, custom user settings, Analytics authorization information and visits for each post, payment history both for posts and authors, user PayPal emails, excluded posts from stats – it should really include ALL possible database data). Notice that other addons may need additional backup to be done.

You can then use the PhpMyAdmin Export feature to download the sql file for each query and store them safely. Below is an animated example of the process (for one query):

Post Pay Counter Backup

  • Was this Helpful ?
  • Yes   No
What are your Feelings
Updated on April 11, 2022
Handle massive Analytics data importsCaching features and stats snapshots

Copyright © 2025 · Centric Theme on Genesis Framework · WordPress · Log in