{"id":1244,"date":"2016-12-09T10:23:27","date_gmt":"2016-12-09T10:23:27","guid":{"rendered":"https:\/\/gosqeng.test\/?p=1244"},"modified":"2019-11-28T11:21:17","modified_gmt":"2019-11-28T11:21:17","slug":"november-hack-day-2","status":"publish","type":"post","link":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2","title":{"rendered":"November Hack Day"},"content":{"rendered":"<p><img decoding=\"async\" src=\"https:\/\/static.gosquared.com\/images\/liquidicity\/16_12_08_hackday_01@2x.png\" alt=\"GoSquared Growth Hack Day\"\/><\/p>\n<p>This month, we picked a theme for the first time: growth. We had a little brainstorm to kick things off, and worked in pairs to come up with ideas we could hack up to help us grow in under 24 hours.<\/p>\n<h2>Automatic Lead Qualification<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/static.gosquared.com\/images\/liquidicity\/16_12_08_hackday_02@2x.png\" alt=\"GoSquared Growth Hack Day\"\/><\/p>\n<p>This hack day Russell created a web service that receives a GoSquared webhook to qualify new users.<\/p>\n<p>The service, built using a lightweight Rails API framework, automatically qualifies a new user\u2019s website, identifies which relevant tools they are currently using and recommends which GoSquared features are a suitable fit for their site\/app. It then posts a notification to slack channel and adds a custom property to that user in GoSquared.<\/p>\n<p>Having this information on hand allows us to effectively reach out to users, more informed about what their current set up is and what GoSquared features can offer the most value. By adding a custom property to that user in GoSquared People, we can use smart groups to improve how we cater our email automation to them and communicate the content that that they would see the most value in.<\/p>\n<p>It offers a significant improvement to our sales workflow and it also helps us to make sure we are communicating the right message to the right people.<\/p>\n<h2>Clearbit data analysis of customer base<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/static.gosquared.com\/images\/liquidicity\/16_12_08_hackday_03@2x.png\" alt=\"GoSquared Growth Hack Day with Clearbit\"\/><\/p>\n<p>Everyone on the team here believes it\u2019s vital for us to deeply understand our customers. GoSquared itself enriches user profiles in People Analytics to show you who your users are. We find this data indispensable on a day-to-day basis. So we decided to see what we could learn from detailed company data provided by Clearbit.<\/p>\n<p>Hugh and Geoff set about the process of compiling a list of customers using GoSquared, and running them through the Clearbit company lookup service. With the resulting data, they sought to answer the following key questions:<\/p>\n<ul>\n<li>What are the industries and sectors amongst our paying customers?<\/li>\n<li>Which sectors have the most customers?<\/li>\n<li>Which sectors account for the most value?<\/li>\n<li>What is the breakdown of company size (employees)?<\/li>\n<\/ul>\n<p>The method of analysis was nothing groundbreaking. Simply loading the Clearbit results into Google Sheets and setting pivot tables and graphs was enough to provide these results.<\/p>\n<p>In addition to the reports, there\u2019s also a wealth of qualitative data that\u2019s useful in Sales \/ Marketing \/ Product scenarios, such as company description, location, founder info and social profiles.<\/p>\n<p>Something we found particularly interesting was the \u201cCompany Tech\u201d results. This is a list of tools and services the company uses. For example it can tell you if Amazon Web Services powers their infrastructure, and what advertising \/ analytics services are in place on their website. As such we can gauge how teams are using GoSquared alongside other tools and services.<\/p>\n<p>Overall, we saw that we can learn a lot about companies and their needs with detailed company information at hand. It\u2019s an important reference point that helps us be clear on how our product and direction can best serve our customers.<\/p>\n<h2>Inbox &rarr; Trello feature request logging<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/static.gosquared.com\/images\/liquidicity\/16_12_08_hackday_04@2x.png\" alt=\"GoSquared Growth Hack Day with Trello\"\/><\/p>\n<p>The Growth team often get feature requests from our customers via Live Chat, and <a target=\"_blank\" href=\"https:\/\/trello.com\/\" rel=\"noopener noreferrer\">Trello<\/a> is a great place to record them \u2014 but Brennan was itching for a better, less manual, way of getting the requests onto our \u2018Features\u2019 board. He and Leo decided to take this on for hackday. Brennan specced out the feature, deciding that a slash command, in the style of <a href=\"https:\/\/api.slack.com\/slash-commands\" target=\"_blank\" rel=\"noopener noreferrer\">Slack<\/a>, seemed like the natural way to implement this, without having to create lots of custom UI.<\/p>\n<p>Ben had previously created a generic auto-completion list, that pops up upon typing <code>\/<\/code> in the message composer, which Leo was able to build upon, hooking up to the Trello API to pull down a list of our existing feature requests. Running the slash command then creates notes both the the Live Chat conversation, and on the Trello card \u2014 each linking to the other. That way, the Growth team have a handy list of customers to contact once we\u2019ve implement something new and shiny.<\/p>\n<h2>Templating for our Weekly Newsletter<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/static.gosquared.com\/images\/liquidicity\/16_12_08_hackday_05@2x.png\" alt=\"GoSquared Growth Hack Day\"\/><\/p>\n<p>If you&#8217;re a subscriber to our newsletter, then GoSquared Weekly has probably become a fixture of your Friday mornings. And if you&#8217;re not, then you should subscribe right now for a weekly fix of helpful insights to grow your business. <\/p>\n<p>What you might not know, however, is that the process of researching, compiling, and composing each issue of Weekly &#8211; finding useful articles, collating links, writing a summary for each, creating all the necessary images, optimising and uploading everything, putting all the content into an HTML template in Mailchimp, and sending it out to the whole mailing list &#8211; is almost entirely manual, and almost entirely handled by James (our Glorious Leader). This can often take quite<br \/>\na lot of time.<\/p>\n<p>In true developer fashion, JT decided to see how much of the process could be automated or templated away &#8211; after all, there&#8217;s a lot that is the same from week to week. So he set about building a small webapp to handle generating the HTML content for the email from some templates.<\/p>\n<p>In the end, most of the time ended up being spent trying to get <a href=\"http:\/\/ejs.co\/\" target=\"_blank\" rel=\"noopener noreferrer\">EJS<\/a> and <a href=\"https:\/\/github.com\/Automattic\/juice\" target=\"_blank\" rel=\"noopener noreferrer\">Juice<\/a> to work in a browser environment, with the final result of hack day being a simple templater that can handle adding and removing individual sections, along with their titles, descriptions and links.<\/p>\n<p>More ambitious future plans include assisted generation, cropping, optimising, and uploading of the images for each section. Sadly this proved a little too optimistic to achieve in a single hack day.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This month, we picked a theme for the first time: growth. We had a little brainstorm to kick things off,&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1452],"tags":[1009,1514],"class_list":["post-1244","post","type-post","status-publish","format-standard","hentry","category-engineering","tag-growth","tag-hack-day"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.6 (Yoast SEO v19.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>November Hack Day - GoSquared Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"November Hack Day\" \/>\n<meta property=\"og:description\" content=\"This month, we picked a theme for the first time: growth. We had a little brainstorm to kick things off,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2\" \/>\n<meta property=\"og:site_name\" content=\"GoSquared Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GoSquared\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-09T10:23:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-28T11:21:17+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/static.gosquared.com\/images\/liquidicity\/16_12_08_hackday_01.png\" \/>\n<meta name=\"twitter:creator\" content=\"@floopily\" \/>\n<meta name=\"twitter:site\" content=\"@GoSquared\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"JT\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/#organization\",\"name\":\"GoSquared\",\"url\":\"https:\/\/www.gosquared.com\/blog\/\",\"sameAs\":[\"https:\/\/instagram.com\/gosquaredteam\",\"https:\/\/www.linkedin.com\/company\/go-squared-ltd.\",\"https:\/\/www.facebook.com\/GoSquared\",\"https:\/\/twitter.com\/GoSquared\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.gosquared.com\/blog\/wp-content\/uploads\/2015\/07\/gosquared.png\",\"contentUrl\":\"https:\/\/www.gosquared.com\/blog\/wp-content\/uploads\/2015\/07\/gosquared.png\",\"width\":1270,\"height\":250,\"caption\":\"GoSquared\"},\"image\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/#website\",\"url\":\"https:\/\/www.gosquared.com\/blog\/\",\"name\":\"GoSquared Blog\",\"description\":\"Turn visitors into customers.\",\"publisher\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.gosquared.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#webpage\",\"url\":\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2\",\"name\":\"November Hack Day - GoSquared Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#primaryimage\"},\"datePublished\":\"2016-12-09T10:23:27+00:00\",\"dateModified\":\"2019-11-28T11:21:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.gosquared.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"November Hack Day\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#webpage\"},\"author\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/bfcd35bf2eba92ecbeea67937cd23eef\"},\"headline\":\"November Hack Day\",\"datePublished\":\"2016-12-09T10:23:27+00:00\",\"dateModified\":\"2019-11-28T11:21:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#webpage\"},\"wordCount\":934,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#primaryimage\"},\"thumbnailUrl\":\"\",\"keywords\":[\"Growth\",\"Hack Day\"],\"articleSection\":[\"Engineering\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/bfcd35bf2eba92ecbeea67937cd23eef\",\"name\":\"JT\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/772e026206b900a5ba17ebbe63e34a4c8a9103524cf0ba3accfa38b14d7d03ba?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/772e026206b900a5ba17ebbe63e34a4c8a9103524cf0ba3accfa38b14d7d03ba?s=96&d=mm&r=g\",\"caption\":\"JT\"},\"description\":\"JT is a co-founder and the lead front-end engineer at GoSquared. He's responsible for the shiniest of the shiny projects we work on.\",\"sameAs\":[\"https:\/\/twitter.com\/floopily\"],\"url\":\"https:\/\/www.gosquared.com\/blog\/author\/jt\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"November Hack Day - GoSquared Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2","og_locale":"en_US","og_type":"article","og_title":"November Hack Day","og_description":"This month, we picked a theme for the first time: growth. We had a little brainstorm to kick things off,...","og_url":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2","og_site_name":"GoSquared Blog","article_publisher":"https:\/\/www.facebook.com\/GoSquared","article_published_time":"2016-12-09T10:23:27+00:00","article_modified_time":"2019-11-28T11:21:17+00:00","twitter_card":"summary_large_image","twitter_image":"https:\/\/static.gosquared.com\/images\/liquidicity\/16_12_08_hackday_01.png","twitter_creator":"@floopily","twitter_site":"@GoSquared","twitter_misc":{"Written by":"JT","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.gosquared.com\/blog\/#organization","name":"GoSquared","url":"https:\/\/www.gosquared.com\/blog\/","sameAs":["https:\/\/instagram.com\/gosquaredteam","https:\/\/www.linkedin.com\/company\/go-squared-ltd.","https:\/\/www.facebook.com\/GoSquared","https:\/\/twitter.com\/GoSquared"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gosquared.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.gosquared.com\/blog\/wp-content\/uploads\/2015\/07\/gosquared.png","contentUrl":"https:\/\/www.gosquared.com\/blog\/wp-content\/uploads\/2015\/07\/gosquared.png","width":1270,"height":250,"caption":"GoSquared"},"image":{"@id":"https:\/\/www.gosquared.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.gosquared.com\/blog\/#website","url":"https:\/\/www.gosquared.com\/blog\/","name":"GoSquared Blog","description":"Turn visitors into customers.","publisher":{"@id":"https:\/\/www.gosquared.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gosquared.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#primaryimage","url":"","contentUrl":""},{"@type":"WebPage","@id":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#webpage","url":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2","name":"November Hack Day - GoSquared Blog","isPartOf":{"@id":"https:\/\/www.gosquared.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#primaryimage"},"datePublished":"2016-12-09T10:23:27+00:00","dateModified":"2019-11-28T11:21:17+00:00","breadcrumb":{"@id":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gosquared.com\/blog\/november-hack-day-2"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gosquared.com\/blog"},{"@type":"ListItem","position":2,"name":"November Hack Day"}]},{"@type":"Article","@id":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#article","isPartOf":{"@id":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#webpage"},"author":{"@id":"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/bfcd35bf2eba92ecbeea67937cd23eef"},"headline":"November Hack Day","datePublished":"2016-12-09T10:23:27+00:00","dateModified":"2019-11-28T11:21:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#webpage"},"wordCount":934,"commentCount":0,"publisher":{"@id":"https:\/\/www.gosquared.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.gosquared.com\/blog\/november-hack-day-2#primaryimage"},"thumbnailUrl":"","keywords":["Growth","Hack Day"],"articleSection":["Engineering"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.gosquared.com\/blog\/november-hack-day-2#respond"]}]},{"@type":"Person","@id":"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/bfcd35bf2eba92ecbeea67937cd23eef","name":"JT","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/772e026206b900a5ba17ebbe63e34a4c8a9103524cf0ba3accfa38b14d7d03ba?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/772e026206b900a5ba17ebbe63e34a4c8a9103524cf0ba3accfa38b14d7d03ba?s=96&d=mm&r=g","caption":"JT"},"description":"JT is a co-founder and the lead front-end engineer at GoSquared. He's responsible for the shiniest of the shiny projects we work on.","sameAs":["https:\/\/twitter.com\/floopily"],"url":"https:\/\/www.gosquared.com\/blog\/author\/jt"}]}},"wps_subtitle":"Another month, another hack day at GoSquared HQ","_links":{"self":[{"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/posts\/1244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/comments?post=1244"}],"version-history":[{"count":0,"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/posts\/1244\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/media?parent=1244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/categories?post=1244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/tags?post=1244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}