Files and Database Tables

A description of the database tables created by ClickerVolt

ClickerVolt Team
Written by ClickerVolt TeamLast update 3 years ago

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_actionsgranular log of all your conversions / transactions
wp_clickervolt_actions_summarysemi-aggregated conversion data on a click-id basis
wp_clickervolt_aidsAID (the first 3 steps of Attention/Interest/Desire/Action) for all clicks
wp_clickervolt_clicksgranular log of all clicks coming in from your visitors
wp_clickervolt_custom_reportscustom reports created by you in the reports tab
wp_clickervolt_devicesdevice data of your visitors
wp_clickervolt_external_idsmapping of third party traffic source click-ids to ClickerVolt click-ids
wp_clickervolt_parallel_idsmapping of Google-Ads, Facebook-Ads and Microsoft-Ads visitor-ids to ClickerVolt click-ids
wp_clickervolt_funnel_linksfunnel relation between your links
wp_clickervolt_geosgeo-location data of your visitors
wp_clickervolt_linksall your link settings
wp_clickervolt_referrerslog of where did your visitors came from
wp_clickervolt_source_templatesyour traffic source settings
wp_clickervolt_stats_baseaggregated hourly stats without any segment
wp_clickervolt_stats_whole_pathaggregated hourly stats showing the paths followed by your visitors
wp_clickervolt_stats_whole_path_devicesaggregated hourly stats showing the devices and paths followed by your visitors
wp_clickervolt_stats_whole_path_geosaggregated hourly stats showing the geo-data and paths followed by your visitors
wp_clickervolt_stats_whole_path_referrersaggregated hourly stats showing the referrers and paths followed by your visitors
wp_clickervolt_stats_whole_path_var1aggregated hourly stats showing the incoming V1 data and paths followed by your visitors
wp_clickervolt_stats_whole_path_var2aggregated hourly stats showing the incoming V2 data and paths followed by your visitors
wp_clickervolt_stats_whole_path_var3aggregated hourly stats showing the incoming V3 data and paths followed by your visitors
wp_clickervolt_stats_whole_path_var4aggregated hourly stats showing the incoming V4 data and paths followed by your visitors
wp_clickervolt_stats_whole_path_var5aggregated hourly stats showing the incoming V5 data and paths followed by your visitors
wp_clickervolt_stats_whole_path_var6aggregated hourly stats showing the incoming V6 data and paths followed by your visitors
wp_clickervolt_stats_whole_path_var7aggregated hourly stats showing the incoming V7 data and paths followed by your visitors
wp_clickervolt_stats_whole_path_var8aggregated hourly stats showing the incoming V8 data and paths followed by your visitors
wp_clickervolt_stats_whole_path_var9aggregated hourly stats showing the incoming V9 data and paths followed by your visitors
wp_clickervolt_stats_whole_path_var10aggregated hourly stats showing the incoming V10 data and paths followed by your visitors
wp_clickervolt_suspicious_clicksfraud score assigned to your incoming clicks
wp_clickervolt_urls_pathshashed 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?