Dealing with multiple Floodlight Tags

I hate setting up Floodlight Tags

And because of that, I decided to try strip down the Floodlight Tag parameters using R. This tutorial is help others in the same pain and suffering like me, and hopefully reduce the time spend on implementing – analyzing, and finding insights instead.

What normally happens

For clients, their marketing team usually wants Floodlight tags to be added to the site, when an event is triggered, or when a page is loaded. While this is completely fair, it can be a hassle to set it up without cluttering up your Google Tag Manager setup, which in many cases starts to look like this:

What is even worse is how the tags are delivered to you

Whenever i am presented with all the floodlight tags marketeers want on the site it is a lot of excel rows to which i manually have to extract 3 values:

  • Source
  • Type
  • Category

This ends up looking like this:

Well, i can just copy the values from there?

Of course you can, however, when someone sends you 100 rows of floodlight tags it starts getting less funny.

R to the rescue

You could do an extraction in excel, however this causes two issues:

  • You need to remember and store the formular you are using
  • You need to re-do the process each time you have to do the task
Adding a script to fix it each time

By using R you ensure that you format your data the exact same way each time, and also it is basically a click & done task.

The script below is my take on how to extract the values from the script:

What does the output give in terms of floodlight tags?

From writing the script you get a data.frame with all the values extracted. From here you can either add it to Google Sheets, or add it into a CSV as I have done in the example.

This is it

In this post i have selected to showcase how to extract data from an excel file with R, and convert it into a bit more usefull format. It is something that have saved me a lot of time, and which i have used in multiple instances.

What’s next?

To see how you can make floodlight tags work even smarter for you in Google Tag Manager, see the next post about making smart triggers with lookup tabels

Join the discussion One Comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.