How to handle massive Analytics data imports

April 4, 2021 by Stefano Leave a Comment

Massive Analytics imports are possible with WP-CLI commands from the console, but there are still some limits even with them. Specifically, it looks like Google limits to 1 million rows the amount of results one can obtain in one request. If your site has a low of pages, and it is likely that the number of URLs for which Analytics has logged visits for the time range you requested exceeds 1 million, then the dataset Post Pay Counter will import will be incomplete. This can be noticed if the number of pending rows after the request is exactly 1 million.

To circumvent this, one can run multiple requests for shorter timeranges and let the plugin merge the data all together. The following bash script will for example import data from 2018-01-01 to 2021-12-31.

sudo -u www-data wp ppc ga clear
for year in {2018..2021}
do
  for month in {1..12}
  do
    lastday=$(date -d "$month/1 + 1 month - 1 day" "+%d") #https://stackoverflow.com/questions/12381501/how-to-use-bash-to-get-the-last-day-of-each-month-for-the-current-year-without-u
    sudo -u www-data wp ppc ga import --time-start="$year-$month-01" --time-end="$year-$month-$lastday"
    sudo -u www-data wp ppc ga process
  done
done

sudo -u www-data wp ppc ga clear

for year in {2018..2021}

for month in {1..12}

lastday=$(date -d "$month/1 + 1 month - 1 day" "+%d") #https://stackoverflow.com/questions/12381501/how-to-use-bash-to-get-the-last-day-of-each-month-for-the-current-year-without-u

sudo -u www-data wp ppc ga import --time-start="$year-$month-01" --time-end="$year-$month-$lastday"

sudo -u www-data wp ppc ga process

done

Fix the All Website Data Analytics label issue

May 27, 2016 by Stefano Leave a Comment

When linking Google Analytics with Post Pay Counter PRO, you need to select which of your profiles relates to the site you are using. However, sometimes you don’t see your website name, but only a cryptic All Website Data. If you have multiple profiles to choose from, it’s virtually impossible to know which one you should pick.

This is not an issue of the plugin, but a misconfiguration in Analytics. In this tutorial you’ll learn to change the label so that it carries your website name.

[Read more…]

Set up an effective payment flow for lifetime visits

May 27, 2016 by Stefano Leave a Comment

If you already know how to pay your writers per visits, you may want to pay them for all the visits their posts record through all time, not just for the current month. This can be easily achieved through the PRO version mark as paid feature. This tutorial will guide you through how to set up the payment flow in order to achieve that.

How to pay authors per views across multiple months

If you use Google Analytics, make sure you have selected the desired start day for visits. This can be done through the Update Analytics Data feature in the Google Analytics Status box. For example, if you want to pay writers for views since the beginning of 2016, then you need to select 2016/01/01. You may well want to start counting visits since the day you install the plugin, in which case just select that day or don’t do anything.
[Read more…]

Google Analytics setup and configuration with Post Pay Counter PRO

April 26, 2014 by Stefano

Post Pay Counter PRO allows you to pay your writers on WordPress basing on how many Google Analytics visits their posts logged. This tutorial shows how to set it up. After setting it up, you may be interested in putting up an effective visits payment flow.

Note: Post Pay Counter PRO does not keep track of Analytics visits, it can only use them to compute the payments. For the tracking you will need something like Google Analytics for WordPress.

First thing to look for is the Google Analytics Settings box. Every section is explained quite in detail, but what is important is that you go through these settings before going on with the setup. They are already set up in a standard and usually-fine way, but if you do want to change them, you should do that before anything else. Don’t forget to hit the Save options button when you are done.

[Read more…]