Adwords – How To Send All Mobile Users To Specific URLs

Hi, unhealthy

this is a cool trick to let you quickly change Final URL for mobile devices in all your campaigns at once. With just a line of code.

Imagine that you have set a specific landing page for each of your ads, keywords, … very granular. Now you developed a mobile version of your landing pages (not responsive, but specialized landing page). But the problem is… how to send all ppc mobile users to this new landing page?

Option A: detect device on your site (client side with javascript) and redirect user to mobile landing page. Problem: another redirection that slow down your site, and degrade user experience.

Option B: detect device on your site (server side with php) and return the new mobile landing page. Problem: you will use the same URL but with different content depending on user.. this will not be good for analytics.

Option C: in URL Option, add Value Track «device» variable in your tracking template.

click in shared library

Captura de pantalla 2016-03-16 23.49.46


then in URL options

Captura de pantalla 2016-03-16 23.49.59

then edit tracking template with this value





Captura de pantalla 2016-03-17 00.11.43

Then, go to your site, detect «d» variable in your PHP and return your new mobile landing page.

if( isset($_GET[‘d’]) &&$_GET[‘d’]==’m’)

Option D: The one I’m using. Just put this conditionals in your Tracking Template:


Captura de pantalla 2016-03-17 00.26.35

and thats it!

NOTE: in my case, my lpurl is always a root URL of several domains (one per country). In the web site I implemented this it is a 1 product niche website, thats why I send all trafic to root URL. I also send from adwords other Value Track variables and do a Dynamic Keyword Insertion in the landing page.

INFO: {lpurl} is the landing page URL you put in your Ads.


I know that I wrote this quite fast, with no deep explanations, if you need some detailed info, ask in comments and I will expand the info.

¿Cómo Cambiar el Password de MySQL en Mac OS X?


No te preocupes, cambiar la clave de root de MySQL en OSX es bien facil, y no eres al primero que necesita hacerlo. … yo mientras escribo esto, lo estoy haciendo 😉

0.- Abre el terminal, y copia y pega los siguientes comandos.

1.- Para el servicio de MySQL

sudo /usr/local/mysql/support-files/mysql.server stop

2.- arrancalo de nuevo en safe mode

sudo /usr/local/mysql/support-files/mysql.server start –skip-grant-tables

3.- abre el cliente mysql


4.- ahora aparecerá el prompt de mysql : mysql>  , y escribe en el:


5.- pulsa enter y después

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘mypasswordnuevo’;

6.- pulsa enter y Listo!!


Para comprobar si se ha cambiado correctamente puedes hacer lo siguiente:

sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server start
/usr/local/mysql/support-files/mysql -u root -p

y escribe mypasswordnuevo


SI NO TE HA FUNCIONADO, prueba los siguientes métodos alternativos.

Los mismos pasos de antes, pero sustituyendo el paso 5.- por el siguiente:


UPDATE mysql.user SET Password=’mypasswordnuevo’ WHERE User=’root’;

Y si tampoco funciona, prueba lo siguiente en el paso 5.-


UPDATE mysql.user SET authentication_string = ‘mypasswordnuevo’
WHERE User = ‘root’ AND Host = ‘localhost’;



si deseas manejar las bases de datos de forma visual, descargate phpmyadmin, lo pones en la carpeta de apache, abrelo en tu navegador, e introduce el usuario root y la clave que acabas de poner.

si te ha servido de ayuda, déjame un comentario abajo 😉



phpBB to BBpress migration + SEO 301 redirects

In this Article I will explain how I successfully migrated a forum from PHPbb to BBpress in 5 minutes. It was easiest than I ever thought. After migrating to BBpress I just add few lines of code in a template file of phpBB to make a clean SEO redirect to the new forum. All worked like charm.

Be careful: Why to move from phpBB to BBpress?

I supose you already spend some time taking this decision, but remember this quick comparison phpBB Vs BBpress:

«bbpress is SIMPLICITY», «PHPbb is POWERFUL».

if you want to migrate a small starting community from phpBB to BBpress, it’s OK, if you want to migrate a large big community, maybe users will not understand the lack of functionality they are used to have in your phpBB forum.

In my case, I did a migration of a phpBB forum to wordpress BBpress because it was a in the early days of the creation of a community, the simplicity benefit of bbpress, worpress blogging integration, and the flexibility to add and mould the website towards the needs of the future community.

The migration from phpBB to BBpress:

STEP 1.- Installation of bbpress (Skip if you already installed it):

  • Install wordpress,
  • settings–> permalinks –>select post name
Captura de pantalla 2016-02-27 17.45.30

settings to migrate phpbb to bbpress


  • install bbpress
  • settings–> forums –>configure as I show in the screenshot
bbpress configuration

migrate phpbb to bbpress: configure bbpress like this

STEP 2.- And the only one step to migrate from phpbb to bbpress is:

1.- choose a different URL for the new forum. for example, if you used /forum/ in phpBB, use /forums/ in bbpress
2.- don’t delete your phpBB forum.
3.- as an extra, in phpbb you could disable registration of new users, and add a message in the /styles/prosilver/template/overall_header.html   file.

Preserving the SEO after moving from PHPbb to BBpress

It’s very easy!!!

and this is very important, not only to avoid penalizations, but to correctly direct potential users that come from SERP results in google to the new forum and don’t loose or frustrate visitors after the phpBB to BBpress migration.

STEP 3.- SEO 301 redirect


search for:

// Send vars to template
‘FORUM_ID’ => $forum_id,

and just above this lines add this piece of code:

$titleac = trim($topic_data[‘topic_title’]);
$relativeurl = str_replace(‘ ‘,’-‘,$titleac);
$relativeurl = strtolower($relativeurl);
header(«HTTP/1.1 301 Moved Permanently»);

Comparison from the bbpress comunity point of view:
If this tutorial mof moving phpBB to BBpress was useful for you, please just let me know with a comment

Root kindle fire 7 5.1.1 with OSX

This is a quick recap for rooting a Kindle Fire 7″ with OSX, link
and install google play. The following are a list of shell commands.

# install ADB

Install homebrew

ruby -e «$(curl -fsSL»
Install adb

brew install android-platform-tools

# Enable ADB-Debugging in Developer Settings then:

adb devices

#en kindle will see a message to grant permission, viagra dosage
check always, erectile
and press OK

# Root

adb reboot-bootloader

fastboot oem append-cmdline «androidboot.unlocked_kernel=true»
fastboot continue
adb wait-for-device && adb shell

#You should now hopefully have a shell with root-priviledges: root@ford:/ #

adb remount
adb push files/ /data/local/tmp/
adb push files/ /data/local/tmp/
adb push files/su /data/local/tmp/
adb push files/Superuser.apk /data/local/tmp/
adb push files/supolicy /data/local/tmp/
adb shell chmod 777 /data/local/tmp/
adb shell /data/local/tmp/
# This Part reopened fastboot and I just re-ran the cmds from the first post in this thread #

fastboot oem append-cmdline «androidboot.unlocked_kernel=true»
fastboot continue

adb wait-for-device && adb remount
adb shell /system/xbin/su –install
adb reboot


Dowload apps:

unpack and copy files to device sdcard

install ES file explorer from Amazon App store

go to sdcard, and install each .apk


Allow Apps from Unknown Sources
Settings>Security>tap toggle>Ok

Download Google apks :!AI5...
Download GoogleLoginService.apk: GoogleLoginService.apk 5.1.1
Download GoogleLoginService.apk: GoogleServicesFramework.apk 5.1.1

place on sd card

Install these files
Google Play (
Google Play Services (
Google Account Manager (GoogleLoginService.apk)
Framework (GoogleServicesFramework.apk)

open with file manager ( install ES file explorer from Amazon App store)

file manager will ask if you want to install

Rebooting is a good idea.

adb shell pm grant android.permission.INTERACT_ACROSS_USERS

If play store will not open correctly


# para cambiar el lancher
# hay que pasarlo a formato OSX

adb push NovaLauncher_4.2.0.apk /data/local/tmp/
adb shell «cp /data/local/tmp/NovaLauncher_4.2.0.apk /system/priv-app/NovaLauncher_4.2.0.apk»
adb shell «cp /system/priv-app/ /sdcard/»
adb shell «rm /system/priv-app/»

# REMOVE ADs in lockscreen

adb reboot bootloader

fastboot oem append-cmdline «androidboot.unlocked_kernel=true»
fastboot continue
adb wait-for-device && adb remount
adb shell «pm hide»
adb reboot




install adb in OSX:


Install Google Play:

Replace launcher + remove ads:


mi nombre es Abilio Caetano Pereira,
soy teleco, padre y emprendedor.

He abierto esta web porque me apetece compartir las cosas que voy descubriendo durante mi aventura como emprendedor, y que creo que puedan ser de utilidad para otros aventureros.

Los tropiezos que he dado, los fallos que he cometido y las cosas que he aprendido se lo debo principalmente a Keruve, un reloj localizador para personas con alzheimer.

reloj localizador keruve para personas con alzheimerKeruve es un increíble proyecto que empecé en el 2005 con Francisca García, cuyo fin es cambiar radicalmente la calidad de vida de millones de personas con alzheimer y sus familiares en todo el mundo. Estuvimos 3 años desarrollando el producto, nos financiamos a base de premios de concursos de emprendedores, lo empezamos a comercializar en España en 2008, en 2009 abrimos una filial en Francia, en 2011 empezamos en Alemania, UK y EEUU, en 2013 lo lanzamos en Italia, Holanda y Portugal. Actualmente hay miles de personas con alzheimer en más de 30 países que usan Keruve.

Mete tu contacto en el formulario de la derecha (o abajo) y te aviso cuando escriba mi primer post (no voy a mandarte publicidad ni basura).

Saludos y hasta pronto,