Files and Database Tables
A description of the database tables created by ClickerVolt
When you first install ClickerVolt, a set of tables are created in your WordPress database and some external files are downloaded.
In this article, we will have a look at what is being added to your WordPress installation.
1. The Database
ClickerVolt makes use of the relational properties of MySQL databases.
A well designed application separates database tables and use the relational properties of MySQL to inter-connect data between them.
This is why this list may look big, but each table has a very specific mean.
Furthermore this separation is what allows ClickerVolt to run stat reports on literally millions of clicks in just a few milliseconds.
wp_clickervolt_actions | granular log of all your conversions / transactions |
wp_clickervolt_actions_summary | semi-aggregated conversion data on a click-id basis |
wp_clickervolt_aids | AID (the first 3 steps of Attention/Interest/Desire/Action) for all clicks |
wp_clickervolt_clicks | granular log of all clicks coming in from your visitors |
wp_clickervolt_custom_reports | custom reports created by you in the reports tab |
wp_clickervolt_devices | device data of your visitors |
wp_clickervolt_external_ids | mapping of third party traffic source click-ids to ClickerVolt click-ids |
wp_clickervolt_parallel_ids | mapping of Google-Ads, Facebook-Ads and Microsoft-Ads visitor-ids to ClickerVolt click-ids |
wp_clickervolt_funnel_links | funnel relation between your links |
wp_clickervolt_geos | geo-location data of your visitors |
wp_clickervolt_links | all your link settings |
wp_clickervolt_referrers | log of where did your visitors came from |
wp_clickervolt_source_templates | your traffic source settings |
wp_clickervolt_stats_base | aggregated hourly stats without any segment |
wp_clickervolt_stats_whole_path | aggregated hourly stats showing the paths followed by your visitors |
wp_clickervolt_stats_whole_path_devices | aggregated hourly stats showing the devices and paths followed by your visitors |
wp_clickervolt_stats_whole_path_geos | aggregated hourly stats showing the geo-data and paths followed by your visitors |
wp_clickervolt_stats_whole_path_referrers | aggregated hourly stats showing the referrers and paths followed by your visitors |
wp_clickervolt_stats_whole_path_var1 | aggregated hourly stats showing the incoming V1 data and paths followed by your visitors |
wp_clickervolt_stats_whole_path_var2 | aggregated hourly stats showing the incoming V2 data and paths followed by your visitors |
wp_clickervolt_stats_whole_path_var3 | aggregated hourly stats showing the incoming V3 data and paths followed by your visitors |
wp_clickervolt_stats_whole_path_var4 | aggregated hourly stats showing the incoming V4 data and paths followed by your visitors |
wp_clickervolt_stats_whole_path_var5 | aggregated hourly stats showing the incoming V5 data and paths followed by your visitors |
wp_clickervolt_stats_whole_path_var6 | aggregated hourly stats showing the incoming V6 data and paths followed by your visitors |
wp_clickervolt_stats_whole_path_var7 | aggregated hourly stats showing the incoming V7 data and paths followed by your visitors |
wp_clickervolt_stats_whole_path_var8 | aggregated hourly stats showing the incoming V8 data and paths followed by your visitors |
wp_clickervolt_stats_whole_path_var9 | aggregated hourly stats showing the incoming V9 data and paths followed by your visitors |
wp_clickervolt_stats_whole_path_var10 | aggregated hourly stats showing the incoming V10 data and paths followed by your visitors |
wp_clickervolt_suspicious_clicks | fraud score assigned to your incoming clicks |
wp_clickervolt_urls_paths | hashed list of all the paths followed by your visitors |
With no traffic, these tables only take a few kilobytes of space.
2. The Files
In addition to the database tables, ClickerVolt also downloads the free GeoLite2 files from Maxmind and saves them in wp-content/plugins/clickervolt-data/maxmind_dbs/
These files are relatively big and take about 70MB of space.
They are used to resolve the geo-location properties of your visitors, such as their country, city and ISP.
If you are interested in learning more about Maxmind, head to their official website here.
3. Uninstalling
At this time, there is no automated clean-up operation when you uninstall ClickerVolt. The database tables and the clickervolt-data folder remains on your server.
The reason is that performance marketers give a very high importance to the stats collected through their paid advertising campaigns.
This allows to re-install ClickerVolt and see all the past reports.
In a coming update, we will offer an option to completely wipe this data.
At the current tine, if you want to get rid of it, you can use phpMyAdmin and delete all the database tables mentioned above.
Additionally, you can use your cPanel file manager or any FTP software to delete the clickervolt-data folder.
We understand that this makes uninstalling a bit more difficult for the average user, however we give higher importance to data retention at this point as ClickerVolt is designed for performance marketers.
In case you do not know how to use phpMyAdmin, there is no harm in leaving the tables and Maxmind files on your server, unless you are really short on space. Unused binary files and database tables will NOT slow down your blog in any way.
Did this answer your question?