José J. Capó gaygenius

Notes about Multivariate Tests for Sponsored Petitions (Upsells)

Please see the document Post-Sign Logic Map for more information about the flow for Promoted Petitions and Sponsored Petitions.

A user who has previously signed a petition. We don’t show an upsell after the very first petition signed.

GET /soa/petition_ads/:id

(id is the lead-in petition id)

additional params:

(required) context=after_sign_sponsored
(required) locale
(required) country_code
(optional) include_phone_upsells (only if phone_petition is not in the user’s request)
(optional) source=fe-services-app

I hereby claim:

I am gaygenius on github.
I am gaygenius (https://keybase.io/gaygenius) on keybase.
I have a public key whose fingerprint is 5F9D D3F4 4679 0144 9DC9 696F 9E23 7A2E E21E 3E6D

To claim this, I am signing this object:

	source 'https://rubygems.org'

	gem 'rails', '3.2.1'
	gem 'haml-rails'
	gem 'rails-backbone'

	# Bundle edge Rails instead:
	# gem 'rails', :git => 'git://github.com/rails/rails.git'

	group :development, :test do

	source 'https://rubygems.org'

	gem 'rails', '3.2.1'

	# Bundle edge Rails instead:
	# gem 'rails', :git => 'git://github.com/rails/rails.git'

	group :development, :test do
	gem 'sqlite3'
	gem 'heroku'

	#places
	:javascript
	$(function() {
	window.router = new BackboneJs.Routers.PlacesRouter({places: #{@places.to_json.html_safe}});
	Backbone.history.start();
	});

	#!/usr/bin/env ruby -w

	require 'fileutils'

	Dir.chdir('/users/josecapo/Pictures')
	months = Dir['201?-??-??'].map {\|date\| date[0..6]}.uniq

	months.each do \|month\|
	FileUtils.mkdir_p(month)
	Dir["#{month}-*"].each do \|date\|

	WITH
	config_oes_ids AS (
	SELECT (config->>'precedingOESId')::integer AS id, organization_id
	FROM connections
	GROUP BY organization_id
	),
	max_deliv_oes_ids AS (
	SELECT max(id) as id, organization_id
	FROM deliverables
	GROUP BY organization_id

	mysql> SELECT * FROM user_targeting_conditions WHERE event_id = 1272920;
	+-------+----------+-----------+
	\| id \| event_id \| condition \|
	+-------+----------+-----------+
	\| 14875 \| 1272920 \| cUS \|
	\| 14876 \| 1272920 \| sCA \|
	+-------+----------+-----------+
	2 rows in set (0.00 sec)

	mysql> SELECT * FROM user_targeting_conditions WHERE event_id = 1272920;

	REDIRECTS (301 http status code)

	/p (petitions_path) if
	user not identified
	no previous signature
	no lead-in petition found (missing or incorrect petition_id param)

	(already happening -- we do nothing) OTHER DESTINATIONS per upsell_list_redirect