Google Analytics eCommerce: upload product data with Google Sheets

In this post, I will show you how to streamline your eCommerce tracking implementation and upload product data to Google Analytics.
From a remote CSV file.
Over Google Sheets.

Sounds good? Here we go!

TL;DR: I have a Github project to help you upload product data for Google Analytics Enhanced eCommerce via the API

Continue reading “Google Analytics eCommerce: upload product data with Google Sheets”

Google Universal Analytics Cheat Sheet – Measurement Protocol Parameters

Google Universal Analytics Cheat SheetHere is a Google Universal Analytics Cheat Sheet to help you make sure you use the right parameters to track data on your websites and mobiles apps!

Working on Hub’Scan means I need to master every single aspect of Google Universal Analytics data collection. This means I get to maintain an accurate, updated list of parameters for the 500+ tags in the Hub’Scan library.
Don’t get me wrong, there are Google Universal Analytics cheat sheets out there but they are not complete and the official Google reference does not provide a list of all parameters.


Continue reading “Google Universal Analytics Cheat Sheet – Measurement Protocol Parameters”

Tracking your dog with GPS and Google Universal Analytics

After posting on Google+ about my blog post on the measurement of offline stores with Google Universal Analytics, I got a dare by user Damion Brown from Melbourne, Australia, to track what his dog was doing using a similar method.

Damion: I’m sorry, mate. I’m afraid I have bad news and good news.

  • The bad news is: I don’t own a dog so I’m not sure as to what I’d want to track.
  • The good news is: I can give you pointers on how to do it. I have done enough tinkering in the last 2 weeks so I’ll let by blog readers do it this time around. You guys get to test (and prove) the concept yourself!

In this experiment, you will attempt the following: track your dog’s location (in 5 minute increments), in relationship to your house, with Google Universal Analytics.

I have a few ideas about that and I’ll be sharing them after the jump.

Continue reading “Tracking your dog with GPS and Google Universal Analytics”

(not provided) is here to stay – deal with it

Google logo

If you work in digital analytics or SEO, by now you’ve heard about the web tracking phenomenon that is (not provided).

Since the end of 2011, Google has implemented measures to respect the privacy of Internet users on the words and expressions they use on its search engine. Specifically, Google is gradually switching searches to secure mode (SSL / HTTPS) and no longer passes referrer information to the search result website, which means that keyword information is lost.

As of now you can still know the source and medium (Google organic search), but the keyword is replaced with a useless “(not provided)” label.

The impact for marketing and SEO agencies seems enormous. Entire business models based on Google search could collapse.

Or could they?

Continue reading “(not provided) is here to stay – deal with it”

Move to

Hi folks,

for those of whose you followed my English posts on the now defunct OX2/LBi web analytics blog, this my new online home.

The personally-branded domain name just makes more sense, and using my own hosting means I can customize this platform just the way I like it 😉

Feel free to leave a comment and drop a note!

French Net blackout against “graduated response”

Paris, February, 25th. Opposing the stubborn and ridiculous will of the French governement to disconnect whole families from the Internet without real proof or trial, La Quadrature du Net issues a call to all freedom-cherishing citizens to a “black-out” of their sites, blogs, profiles, avatars,… As has been done in New Zealand, the only other country with France where the “graduated response” would have been imposed by law, and was finally pushed back: to protest against this stupid law and its “white list” of authorized websites, the French Web must act and dress in black.

New Zealand was so far the only other country besides France where such a stupid law as the “graduated response” was to be voted. In France, upon N. Sarkozy’s will, and defended by the minister of Culture C. Albanel, the “HADOPI” law is soon to be voted at the National Assembly. It just has been repelled thanks to a massive mobilization, during which New Zealand has proceeded to a voluntary “blackout”.

“This is a strong signal that shows the foolishness and dangerousness of this law. The “graduated response” will convict innocent people, without tangible proof and without trial. Artists will not earn more money and it will not change anything to the strategical and structural problems causing the crisis the industries asking for this law are facing.” says Jérémie Zimmermann, spokesperson of La Quadrature du Net. “To go all the way through with this logic of repression, the government said it would filter all public wi-fi accesses to a “whitelist”1 of allowed websites. It doesn’t make any sense. Actions have to be taken to show a huge part of the Web is decided not to become permanently black.”

La Quadrature calls its supports, individuals and organizations, to :

    • Paint their sites, blogs, profiles, mails, comments, or avatars in black, if necessary by using the images put at their disposal2.
    • Display a message explaining the reasons for this protest against an absurd, ineffective and dangerous law which threatens the French web, innovation, and basic freedoms3.






HADOPI - Le Net en France : black-out

“This call is a tribute to New Zealand citizens who were able to make their government hear the voice of reason. This is a remix of an idea which, like culture, exist only to be shared. Those who treat their customers of being “pirates” and the elected representatives who vote their laws are the ones who should be disconnected !”

“The Net was made for and by its users. Some archaic businesses and politicians who try to control it have not yet understood how the Net works. Together we are infinitely more intelligent and powerful and we must show it, act to protect our freedoms and the open architecture of the network. “ concludes Zimmermann, slightly angry.


  1. On this matter, see: “graduated response”: “White list” for a dark age of the Net in France –
  2. Images are available here : More information and contributed images, templates and scripts on the wiki page of the black-out:
  3. Anyone can publish their messages on a dedicated wiki page:
  5. The Political Memory tool is available to find the coordinates of deputies and their votes, especially on the DADVSI law: A help page on how to contact a deputy is also still being improved:
  6. The dossier is available here:, as well as a 2-page synthesis:


[source 1=”<a” 2=”2="href=""></a>"” language=”:”][/source]