{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/2849","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2849/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2849/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2849/events","html_url":"https://github.com/CartoDB/cartodb/issues/2849","id":63267691,"number":2849,"title":"Change Mailchimp import to use campaigns","user":{"login":"Kartones","id":2085449,"avatar_url":"https://avatars.githubusercontent.com/u/2085449?v=3","gravatar_id":"","url":"https://api.github.com/users/Kartones","html_url":"https://github.com/Kartones","followers_url":"https://api.github.com/users/Kartones/followers","following_url":"https://api.github.com/users/Kartones/following{/other_user}","gists_url":"https://api.github.com/users/Kartones/gists{/gist_id}","starred_url":"https://api.github.com/users/Kartones/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kartones/subscriptions","organizations_url":"https://api.github.com/users/Kartones/orgs","repos_url":"https://api.github.com/users/Kartones/repos","events_url":"https://api.github.com/users/Kartones/events{/privacy}","received_events_url":"https://api.github.com/users/Kartones/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/CartoDB/cartodb/labels/0%20-%20Backlog","name":"0 - Backlog","color":"CCCCCC"},{"url":"https://api.github.com/repos/CartoDB/cartodb/labels/3%20-%20Done","name":"3 - Done","color":"CCCCCC"},{"url":"https://api.github.com/repos/CartoDB/cartodb/labels/importer","name":"importer","color":"eb6420"}],"state":"open","locked":false,"assignee":{"login":"Kartones","id":2085449,"avatar_url":"https://avatars.githubusercontent.com/u/2085449?v=3","gravatar_id":"","url":"https://api.github.com/users/Kartones","html_url":"https://github.com/Kartones","followers_url":"https://api.github.com/users/Kartones/followers","following_url":"https://api.github.com/users/Kartones/following{/other_user}","gists_url":"https://api.github.com/users/Kartones/gists{/gist_id}","starred_url":"https://api.github.com/users/Kartones/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kartones/subscriptions","organizations_url":"https://api.github.com/users/Kartones/orgs","repos_url":"https://api.github.com/users/Kartones/repos","events_url":"https://api.github.com/users/Kartones/events{/privacy}","received_events_url":"https://api.github.com/users/Kartones/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/CartoDB/cartodb/milestones/35","html_url":"https://github.com/CartoDB/cartodb/milestones/Baeza","labels_url":"https://api.github.com/repos/CartoDB/cartodb/milestones/35/labels","id":1011914,"number":35,"title":"Baeza","description":"- [ ] New dashboard final fixes and enhancements (@jmedina)\r\n- [ ] Named places on Import (@rtorre)\r\n- [ ] Torque infowindow (@fdans)\r\n- [ ] Kepler integration (@rtorre)\r\n- [ ] Back refactor (@rtorre)\r\n- [ ] /explore API v1 (@nacho)\r\n- [ ] URL rewrite (@kartones)\r\n- [ ] oneclick for visualizations (@kartones)\r\n- [ ] Odyssey fixes (@javierarce)\r\n- [ ] New modals on editor (@vikingo)\r\n- [ ] Named places on Import (@rtorre)\r\n- [ ] Limits APIs (@rochoa)\r\n- [ ] Medusa v2 (@rochoa)","creator":{"login":"juanignaciosl","id":932968,"avatar_url":"https://avatars.githubusercontent.com/u/932968?v=3","gravatar_id":"","url":"https://api.github.com/users/juanignaciosl","html_url":"https://github.com/juanignaciosl","followers_url":"https://api.github.com/users/juanignaciosl/followers","following_url":"https://api.github.com/users/juanignaciosl/following{/other_user}","gists_url":"https://api.github.com/users/juanignaciosl/gists{/gist_id}","starred_url":"https://api.github.com/users/juanignaciosl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanignaciosl/subscriptions","organizations_url":"https://api.github.com/users/juanignaciosl/orgs","repos_url":"https://api.github.com/users/juanignaciosl/repos","events_url":"https://api.github.com/users/juanignaciosl/events{/privacy}","received_events_url":"https://api.github.com/users/juanignaciosl/received_events","type":"User","site_admin":false},"open_issues":80,"closed_issues":19,"state":"open","created_at":"2015-03-09T07:59:31Z","updated_at":"2015-03-24T10:23:23Z","due_on":"2015-04-01T22:00:00Z","closed_at":null},"comments":2,"created_at":"2015-03-20T17:16:53Z","updated_at":"2015-03-24T10:23:23Z","closed_at":null,"body":"[Branch](https://github.com/CartoDB/cartodb/tree/issue-2849)\r\n\r\n### 1st round\r\n- [x] Show users who have opened a campaign\r\n- [x] anonimize data returned (emails)\r\n- [x] Replace old code that used lists\r\n\r\n### 2nd round\r\n- [x] Remove campaigns who have tracking disabled\r\n- [x] Change flow to:\r\n  - retrieve campaign list\r\n  - retrieve then subscriber activity\r\n  - set `opened` field of campaign data with subscriber activity data\r\n  - anonymize emails and other personal data (except ip)\r\n\r\n### 3rd round\r\n- [x] Try to apply some CartoCSS to color differently `opened=true` emails\r\n\r\ncc @saleiva "},"comment":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/comments/85439963","html_url":"https://github.com/CartoDB/cartodb/issues/2849#issuecomment-85439963","issue_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2849","id":85439963,"user":{"login":"saleiva","id":132149,"avatar_url":"https://avatars.githubusercontent.com/u/132149?v=3","gravatar_id":"","url":"https://api.github.com/users/saleiva","html_url":"https://github.com/saleiva","followers_url":"https://api.github.com/users/saleiva/followers","following_url":"https://api.github.com/users/saleiva/following{/other_user}","gists_url":"https://api.github.com/users/saleiva/gists{/gist_id}","starred_url":"https://api.github.com/users/saleiva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/saleiva/subscriptions","organizations_url":"https://api.github.com/users/saleiva/orgs","repos_url":"https://api.github.com/users/saleiva/repos","events_url":"https://api.github.com/users/saleiva/events{/privacy}","received_events_url":"https://api.github.com/users/saleiva/received_events","type":"User","site_admin":false},"created_at":"2015-03-24T10:23:23Z","updated_at":"2015-03-24T10:23:23Z","body":"Assigning to @xavijam to update the texts"}}