Tuesday, February 18, 2014

Set up canonical url for A/B test page variations

Say you have 2 page variations for an A/B test. Page A (original) - /home Page B (variation) - /home_variation In order for Google spiders to only pick up contents in Page A since it has already been crawled and SEO-ed and we don't want Page B to affect SEO rankings, we need to specify in Page B that the url to Page A is canonical, ie. the main url.

Saturday, February 8, 2014

Export queried data from MySQL in bash command line

SELECT distinct(users.email), users.firstname INTO OUTFILE '~/Downloads/users.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' FROM users;