The 'trickledata' fields, as far as I can make out, are as follows: id, hostid, count(CPM), date, lat, long, ?, experimentation flag, rev, version. I don't know how often the earliest data gets archived, or if older data is available through another URL.

Some records have an odd count value but they also have a different flag value "f"; I don't know the meaning of these but presumably they do not represent measured CPM values.

The URL for obtaining raw data gives the first 5000 raw records available on the server for the selected hostID, which goes back some 2 months. To get subsequent records, use startid=id of first desired record.

It seems the URL itself is what is flagged as spam. I will try and squeeze it through in my next post.