Sebastián S.

tracking conversions on launchrock with analytics

Small snippet for tracking conversions on launchrock with analytics, before the :

<script type="text/javascript">
  function checkSignup() {
    if ($(".LR-site-share:visible").length == 0) {
        setTimeout(checkSignup, 100);
    } else {
        _gaq.push(['_trackPageview', '/landing/share/']);
    }
}
checkSignup();
</script>

then in analytics you can add a goal base on tracking the page /landing/share/

Cheers

Install postgresql 9.1 with utf-8 encoding on Ubuntu 12.04 LTS precise for django

Last set of commands use to install postgres with UTF8 encoding on ubuntu LTS

$ sudo apt-get install postgresql

$ sudo passwd postgres

$ su postgres

$ createuser -P django_login

$ psql

$ CREATE DATABASE mydb WITH ENCODING = ‘UTF-8’ LC_CTYPE = ‘en_US.utf8’ LC_COLLATE = ‘en_US.utf8’ OWNER django_login TEMPLATE template0;

$ \q

$ exit

$ sudo nano /etc/postgresql/9.1/main/pg_hba.conf

### change the lines with:
local   all             postgres                        peer
local   all             all                             peer 
### to
local   all             postgres                        md5 
local   all             all                             md5

$ sudo /etc/init.d/postgresql restart

test the connection

$ psql -d mydb -U django_login

alternative to set the permissions (different to pass OWNER on the create)

postgres=# CREATE USER test WITH PASSWORD ‘test’;

postgres=# GRANT ALL PRIVILEGES ON DATABASE mydb to test;

my weekend reading list

• Why We’re Pivoting from Mobile-first to Web-first http://philosophically.com/why-were-pivoting-from-mobile-first-to-web-first

• AngelList Raising A Big Round, To Be Valued at $150 Million Or More http://techcrunch.com/2012/12/14/angellist-to-be-valued-at-150-million-or-more/

• BarkBox’s road to 20,000 customers and 95% retention: “Dog owners are dog parents” http://blog.perfectaudience.com/2012/12/13/barkboxs-road-to-20000-customers-and-95-retention-dog-owners-are-dog-parents/

• End of the year startup checklist http://tomtunguz.com/end-of-the-year-startup-checklist/

• Designing products for single and multiplayer modes http://cdixon.org/2010/06/12/designing-products-for-single-and-multiplayer-modes/

• Fight against Software Complexity http://santosh-log.heroku.com/2012/05/20/fight-against-software-complexity/

• THE WEB WE LOST http://dashes.com/anil/2012/12/the-web-we-lost.html

• Working alone sucks http://fleetadmiral.tumblr.com/post/37907736486/working-alone-sucks

• Tips to improve CPA immediately ttp://blog.adstage.io/2012/12/13/cpa/

• What Fred Wilson and the VCs don’t get about advertising http://pandodaily.com/2012/12/12/what-fred-wilson-and-the-vcs-dont-get-about-advertising/

• Are You Making the Most Common Pricing Mistake? http://thinktraffic.net/most-common-pricing-mistake