Sunday, March 27, 2016

Full List of AdWords URL Parameters for Tracking Templates

AdWords has added the ability to add parameters to all your URLs via Shared Library -> URL
options -> Tracking Template, which was a very welcome upgrade to those of us who tag all our URLs. However, I struggled to find a complete list of parameters available to me for use in the Tracking Template, and decided to make my own list and share it.

However, when investigating the creation of the table, I found a Google page "Set up tracking with ValueTrack parameters", which has a complete list of all the values and give good explanations. To find the list, you will need to expand the sections in "Available ValueTrack parameters" to see the values, but the list seems complete.

Thursday, March 24, 2016

In Search of the Lost MailChimp API v3 PHP Wrapper

After spending some time deciding "MailChimp or some other service", for various reasons I decided to stay with MailChimp, especially since it's free for me at the current time. I dug into the docs, and immediately detect that MailChimp has moved from v2 of their API to the new v3, as of the spring of 2015. Since v2 will be turned off at the end of 2016, v3 was the logical choice.

Is there a wrapper? Let's see lists wrappers for a bunch of languages... but no mention of wrappers for v3.

When I reached out to MailChimp, they said:
"Because API v3.0 recently reached feature parity [emphasis mine] with previous versions, we haven't been able to set up any resources to promoting wrappers API 3.0. With said, our developers are working on improving our API 3.0 experience for our users, and if you'd like to check in on any feature updates or news relating to 3.0, please be sure to head to our Road map page below and sign up to receive our API announcements.
Going forward, while we don't have any documentations of various 3.0 wrappers, github would be a good resource to find any v3.0 wrappers that can be used."

Since Drew McLellan has updated his PHP API wrapper to v3, and his component is mentioned on the MailChimp site (listed as a v2 component), and since his component has more stars and downloads on, I will go with that wrapper to start.

Wednesday, March 16, 2016

MySQL Split / Explode

Note to self: Although MySQL does not have a split / explode type function, it DOES have a built SUBSTRING_INDEX function that can be used in some circumstances. E.g. if you have a field with value '12345-right', you can get the left part with SUBSTRING_INDEX(value, '-', 1), and the right part with SUBSTRING_INDEX(value, '-', -1).

In general, I agree with Melchior Blausand's rant on StackOverflow: that I shouldn't be looking for explode, I should be looking at a better way to store my data. If you are reading this, think about storing differently rather than using a hack like this.

Tuesday, March 15, 2016

TPV Virtual, BBVA, y PrestaShop

En diciembre, escribí sobre mi uso del TPV de ING en mi tienda Funcionaba bien, pero faltaba la posibilidad de quitar 3D Secure (Verified by Visa, SecureCode, etc.) en pedidos seguros, y la opción de "Pago en 1 clic" (clicktopay).

Desde entonces, he cambiado a un TPV de BBVA. Sale ligeramente mas barato que el TPV de ING (creo que la commission es 0,48%, y recibo el dinero dentro de 72 horas), per mas importante, ahora tengo control de 3D Secure, y la opción de "Pago en 1 clic". Mi agente de BBVA entendía exactamente lo que estaba buscando, y necesitaba relativamente poco tiempo en tener todo en marcha.

También he cambiado al modulo RedSys de idnovate. El modulo tiene muchas opciones, y David siempre responde rápido a mis preguntas.

Da igual que banco estas utilizando, si esta a través de RedSys no olvides a utilizar la opción de "AutoReturn".