{"action":"opened","issue":{"url":"https://api.github.com/repos/inboundnow/leads/issues/143","labels_url":"https://api.github.com/repos/inboundnow/leads/issues/143/labels{/name}","comments_url":"https://api.github.com/repos/inboundnow/leads/issues/143/comments","events_url":"https://api.github.com/repos/inboundnow/leads/issues/143/events","html_url":"https://github.com/inboundnow/leads/issues/143","id":111036490,"number":143,"title":"Events DB table ","user":{"login":"atwellpub","id":2002207,"avatar_url":"https://avatars.githubusercontent.com/u/2002207?v=3","gravatar_id":"","url":"https://api.github.com/users/atwellpub","html_url":"https://github.com/atwellpub","followers_url":"https://api.github.com/users/atwellpub/followers","following_url":"https://api.github.com/users/atwellpub/following{/other_user}","gists_url":"https://api.github.com/users/atwellpub/gists{/gist_id}","starred_url":"https://api.github.com/users/atwellpub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/atwellpub/subscriptions","organizations_url":"https://api.github.com/users/atwellpub/orgs","repos_url":"https://api.github.com/users/atwellpub/repos","events_url":"https://api.github.com/users/atwellpub/events{/privacy}","received_events_url":"https://api.github.com/users/atwellpub/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"atwellpub","id":2002207,"avatar_url":"https://avatars.githubusercontent.com/u/2002207?v=3","gravatar_id":"","url":"https://api.github.com/users/atwellpub","html_url":"https://github.com/atwellpub","followers_url":"https://api.github.com/users/atwellpub/followers","following_url":"https://api.github.com/users/atwellpub/following{/other_user}","gists_url":"https://api.github.com/users/atwellpub/gists{/gist_id}","starred_url":"https://api.github.com/users/atwellpub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/atwellpub/subscriptions","organizations_url":"https://api.github.com/users/atwellpub/orgs","repos_url":"https://api.github.com/users/atwellpub/repos","events_url":"https://api.github.com/users/atwellpub/events{/privacy}","received_events_url":"https://api.github.com/users/atwellpub/received_events","type":"User","site_admin":false},"milestone":null,"comments":0,"created_at":"2015-10-12T19:10:26Z","updated_at":"2015-10-12T19:10:26Z","closed_at":null,"body":"All actions are currently stored as post meta data inside the user profile. I would like to see us migrate our 'Activity' into it's own table. This will make it easier to discover action data by either content id or lead id rather than lead id alone. \r\n\r\nFor example, if a form submission was stored in it's own table with a lead id and a page id associated to it then we would be able to easily discover all submissions related to a piece of content. \r\n\r\n* [ ] Create events table.\r\n* [ ] Store form submissions, tracked content clicks, tracked email clicks , sent emails. \r\n* [ ] Provide room for custom events\r\n* [ ] Migrate lead data into new system using a database routine.\r\n\r\nThis issue is not priority, but it is something that will improve our data archetecture in the future. It should not be hard to implement either. Data migration to the new system would be the hardest part of implementation. "}}