<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Rows - Medium]]></title>
        <description><![CDATA[The spreadsheet with superpowers - Medium]]></description>
        <link>https://medium.com/rows?source=rss----503b89cb1052---4</link>
        <image>
            <url>https://cdn-images-1.medium.com/proxy/1*TGH72Nnw24QL3iV9IOm4VA.png</url>
            <title>Rows - Medium</title>
            <link>https://medium.com/rows?source=rss----503b89cb1052---4</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Mon, 16 Nov 2026 10:11:11 GMT</lastBuildDate>
        <atom:link href="https://medium.com/feed/rows" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[An honest look at how we’re running the Product/Market fit survey at dashdash]]></title>
            <link>https://medium.com/rows/an-honest-look-at-how-were-running-the-product-market-fit-survey-at-dashdash-1bbebc2e6b07?source=rss----503b89cb1052---4</link>
            <guid isPermaLink="false">https://medium.com/p/1bbebc2e6b07</guid>
            <dc:creator><![CDATA[Henrique Cruz]]></dc:creator>
            <pubDate>Mon, 03 Aug 2020 11:34:37 GMT</pubDate>
            <atom:updated>2020-08-03T12:39:58.762Z</atom:updated>
            <content:encoded><![CDATA[<h3>An Honest Look at How We’re Running the Product/Market Fit Survey at dashdash</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*tV4UCyAFvWeK8UTw5WiIBA.png" /></figure><p>If you are a B2B company or have been following the tech <em>Twittersphere</em> over the past year, you’ve probably seen mentions of the mystical “Product/Market Fit Survey”. With a few short questions, it promises to be the barometer for where you are on the quest for the holy grail for early-stage startups.</p><blockquote>“Product/market fit means being in a good market with a product that can satisfy that market.” — Marc Andreessen</blockquote><p>Initially introduced by <a href="https://blog.growthhackers.com/using-product-market-fit-to-drive-sustainable-growth-58e9124ee8db">Sean Ellis</a> a decade ago, the survey re-gained prominence last year when Rahul Vohra wrote a great post on <a href="https://firstround.com/review/how-superhuman-built-an-engine-to-find-product-market-fit/">First Round</a> about using the survey at Superhuman. In short, <strong>a leading indicator of a startup product/market fit can be measured as the percentage of users who would reply being “very disappointed” when asked how they would feel if they could no longer use your product</strong>. If you’re over 40%, you’re golden. If not, you’ve got work to do.</p><p>At <a href="http://dashdash.com/">dashdash</a> — a spreadsheet on steroids — we’ve been using the survey for over a year. We thought it might be useful to others if we shared what we’re doing, what is working, what’s not, and how we’re thinking about it. This is an honest take on the ins and outs of using this survey as an important tool in your business discovery toolkit. Let’s dive in:</p><h3>Timing and Frequency</h3><p>For the past year, we’ve been sending the survey every 3 months, usually in the first week of a new quarter. We chose this timing and frequency because:</p><p>1) <strong>Product roadmap</strong>: Large product initiatives are normally delivered in the latter half of the quarter, and we want to give our users enough time to experience large product updates before responding to the survey.</p><p>2) <strong>KPI mapping</strong>: We set our company, product, and business KPIs on a quarterly cadence, and the survey should be part of the quarterly objectives.</p><p>There is one disadvantage of this timing though. At the end of every quarter, we conduct our “Growth workshop”, where the Product and Business teams get together to lay out the challenges to tackle in the following 3 months and analyze how the previous quarter went.</p><p>Since the survey is only sent a few weeks after the workshop, we don’t use its results directly in our quarterly planning meetings. It is one of the reasons we’re separating the Growth workshop into two sessions: the Quarter Planning, held 3–4 weeks before the end of the quarter, and the Quarter Retrospective, held 2–3 weeks after the quarter is over and all the data has come in.</p><h3>Audience</h3><p>After deciding when to send the survey, you’ll need to select your audience. For this, we’re only interested in feedback from people who actually used the product. We’ve defined our audience as <strong>users who were active at least in 2 of the previous 6 months</strong>. We could have used a much shorter timeframe, but since we have use cases with a daily/weekly/monthly frequency, we felt it would be relevant to gather feedback from a large pool of people.</p><p>As general principles, you’ll want to select an audience that:</p><p>1) <strong>Aligns with the natural frequency of your product</strong>: If you’re running a product with daily usage (let’s say Facebook or Gmail), selecting an audience based on the activity of the last 2–3 weeks is probably enough. But if your use case is less frequent (e.g. Airbnb guests), you’ll want to widen the audience.</p><p>2) <strong>Gives room for churned users to participate</strong>: You’re also looking for responses from people who used the product but were not retained. For that, it is important to define an audience that encompasses people who have used the product but left.</p><h3>Format</h3><p>As for the format, we keep it pretty much true to the original version by Sean Ellis. We use <a href="http://typeform.com/">Typeform</a> to collect the answers, and link them to a Google Sheet (soon a dashdash spreadsheet 😊).</p><p>Here’s a quick recap of the questions:</p><ol><li><strong>How would you feel if you could no longer use dashdash?</strong><br>a) Very disappointed<br>b) Somewhat disappointed<br>c) Not disappointed<br>d) N/A—I no longer use dashdash</li></ol><p>This is where we’re looking for the magical 40% of “very disappointed” users 🎯</p><p><strong>2) What would you likely use as an alternative if dashdash no longer existed?</strong></p><p><strong>3) What is the main benefit you received from dashdash?</strong></p><p><strong>4) How can we improve dashdash for you?</strong></p><p><strong>5) What type of people do you think would most benefit from dashdash?</strong></p><h3>Managing Replies</h3><p>One of the toughest things is getting people to reply to the survey. Your users are probably busy with multiple projects, have dozens of browser tabs opened, and a long backlog of unread emails. Catching their attention is hard. We’ve tried multiple twists on the survey email but still, see that only 10–20% of recipients respond to the survey.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YC3D7kkQzL8X7ubakzFyfw.png" /><figcaption>The email from our last campaign</figcaption></figure><p>Don’t skip on a mid-week reminder. In the past 2 quarters, <strong>+65% of our survey replies came in the days following the reminder</strong>. We’re also seeing that plain text emails work better than “polished” ones (no buttons, no images, no GIFs), so next quarter we’re moving off of <a href="http://mailchimp.com/">Mailchimp</a> for a 100% plain text email. Plus, emails sent from the CEO/Founder resonate better with our audience.</p><p>Finally, we keep the reply-to email the same as the sender&#39;s email (we’re not afraid of getting some emails), and intentionally don’t track open rates, click rates, or collect personal information on who replied to the survey.</p><h3>Output</h3><p>Once the results are in, we’re mostly interested in four things:</p><p><strong>1) How are we doing against the 40% goal?</strong></p><p>This is the barometer of product/market fit and the overarching KPI that comes out of the survey.</p><p><strong>2) What do we need to do to convert on-the-fence users?</strong></p><p>As pointed out by <a href="https://firstround.com/review/how-superhuman-built-an-engine-to-find-product-market-fit/">Rahul in his article</a>, we want to know what we are missing to turn our “somewhat disappointed” users into people that go crazy about us. <br>We go through the answers to “How can we improve dashdash for you?” and identify the features that might make the difference. Most of the time, these will be obvious improvements, but once in a while, you will find something new or something old described in a new way.</p><blockquote>“More templates / use-cases”</blockquote><blockquote>“More data sources and templates”,</blockquote><blockquote>“Data visualization”</blockquote><blockquote>“Provide me with proposals what I can use the tool for besides the use cases I already do with dashdash.”</blockquote><p><strong>3) How do our users explain the benefit of using dashdash?</strong></p><p>Here, we’re looking for patterns in answer to “What is the main benefit you received from dashdash?”. There is nothing better for positioning and messaging than hearing your users describe your product and what it does for them. It is a great — and often humbling exercise — that helps us craft product messaging that resonates with our audience.</p><blockquote>“Automation of repetitive searches — Time saved!”</blockquote><blockquote>“Integrations made easy”</blockquote><blockquote>“Building spreadsheets that would be impossible to build quickly without the easy API access.”</blockquote><blockquote>“Still haven’t figured that out.”</blockquote><p><strong>4) Who do our “not disappointed” users think would benefit the most from using dashdash?</strong></p><p>Quite often, you’ll attract users that are not a great fit for your product: they might be the wrong persona, they got into the product too early, or they just didn’t need your product bad enough. Nonetheless, these users can offer good feedback on who they think the product is for.</p><p>This is what we’re looking for in answer to “What type of people do you think would most benefit from dashdash”: is there untapped potential in going after a new user persona?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*b6er7t1BNew3IjFOMW9wKA.png" /><figcaption>A snippet of our Q2 survey results</figcaption></figure><p>We found that unless you have a very large number of responses (&gt;100), doing refined user segmentation is not incredibly helpful. Each additional segmentation will reduce the number of answers you’re looking at, and you will end up with a sample size too small to generalize any findings.</p><p>The output of the analysis is compiled in a short one-pager. We share it with the whole team on Slack and present it in an All-hands meeting 🙌.</p><h3>Conclusion</h3><p>The PMF survey has been an invaluable tool at dashdash. It gives us a pulse on how our users feel about the product, a target to chase, leaves us with areas to double down on, and occasionally surfaces new market opportunities. Hearing first hand from our customers about the benefits they see in dashdash and areas of improvement is also a great motivator for the team. And in a time where we’re all working remotely, sharing what’s going on across the company is more important than ever.</p><p>That being said, my advice would be not to lean too much on the survey results to drive decisions, but rather to inform them. There is a big selection bias in the results — you’ll only get feedback from the small percentage of people who actually responded — and it is easy to get infatuated with the enthusiasm of your most cheerful supporters.</p><p>We’ll keep running this survey in the next few quarters and for as long as we feel it is worth it. If you have any feedback, comments, or suggestions (tips on improving the reply rate would be nice), <a href="https://twitter.com/HenrM_Cruz">reach out</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5Iv6Ux4fHCLbSZHREVoh5A.png" /><figcaption>We’re getting there 💪</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/200/1*jC7S-QWeXWGJAGWqxDmeUQ.gif" /></figure><p><a href="http://dashdash.com/"><em>dashdash</em></a><em> is the spreadsheet for builders. Automate your processes with powerful Sales and Marketing tools that integrate with your stack. Currently in beta. Find out more on our </em><a href="http://dashdash.com/"><em>website</em></a><em> and </em><a href="https://app.dashdash.com/auth/get-early-access"><em>sign up</em></a><em> for our waitlist.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1bbebc2e6b07" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rows/an-honest-look-at-how-were-running-the-product-market-fit-survey-at-dashdash-1bbebc2e6b07">An honest look at how we’re running the Product/Market fit survey at dashdash</a> was originally published in <a href="https://medium.com/rows">Rows</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[5 Google Analytics Custom Alerts for SEO You Need to Track]]></title>
            <link>https://medium.com/rows/5-google-analytics-custom-alerts-for-seo-you-need-to-track-23a6ec1d3d36?source=rss----503b89cb1052---4</link>
            <guid isPermaLink="false">https://medium.com/p/23a6ec1d3d36</guid>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[growth]]></category>
            <category><![CDATA[google-analytics]]></category>
            <category><![CDATA[seo]]></category>
            <category><![CDATA[marketing]]></category>
            <dc:creator><![CDATA[Hady ElHady]]></dc:creator>
            <pubDate>Thu, 25 Jun 2020 10:56:57 GMT</pubDate>
            <atom:updated>2020-06-25T10:59:58.553Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KQR-95WDJsryugTMArqUGw.png" /></figure><p>As an SEO manager or a marketer, you’re probably too busy to go through the different data and metrics of your website and analyze it every single day to monitor your performance and notice any changes. Even the process of retrieving the data from Google Analytics and comparing it with historical data can be tedious.</p><p>To solve that, Google Analytics events tracking allows you to set up custom events that would trigger actions based on specific behaviors on your website — for example, tracking changes to your pageviews, session durations, traffic referral, etc.</p><p>With so many options that Google Analytics has to offer, it can be confusing as to which alerts you should set up. Below we will discuss the five essential Google Analytics custom alerts for SEO that are a must-have.</p><p>You’ll also find more information at the end of the post on how you can set them up instantly with <a href="https://app.dashdash.com/dashboard/templates/get_seo_website_performance_alerts">Slack alerts using dashdash</a> and how to get early access to the platform.</p><h3>Custom Alert #1: Drop in Organic Traffic</h3><p>A drop in organic traffic can be normal and can be affected by different factors like seasonality. However, since organic visitors come to your website from a search engine, it can be an indicator of SEO issues.</p><p>That’s why it’s crucial to get alerted when drastic changes in organic traffic occur. The change percentage that you should set depends entirely on your average website organic traffic. The higher your organic traffic, the lower you should set the percentage of change as its sensitivity decreases.</p><p>You should check the average daily organic traffic you get and the average change of traffic week-over-week. Then, you should set the alert trigger percentage to be slightly higher than your average. You can set the percentage to a positive value to track spikes or a negative one to track drops in your traffic. You can also choose to monitor the traffic of a specific page as opposed to the entire website.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*tnWF0t4ei8OhTt-D9jqtGA.png" /></figure><h3>Custom Alert #2: Drop in Page Visits</h3><p>Having an alert for when page visits drop is essential when tracking the performance of different pages individually — for example, your landing pages. It allows you to quickly identify any issues with your top-performing pages and fix them immediately. You can also track spikes in page visits, which could indicate an important mention on a website or social media.</p><p>A drop in pageviews starting somewhere from 20% to 50% week-over-week would be something to worry about.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZEWH3f3q2JKlTPrk1Q1yFA.png" /></figure><h3>Custom Alert #3: Drop in Goal Conversions</h3><p>A drop in your goal conversions or completions can indicate an issue with your conversion funnel. It could show that one of the funnel steps like a content piece or a landing page is performing poorly and needs your attention.</p><p>On average, a 15% drop in goal conversions from one week to the next would be alarming. That’s why not having such an alert can be very costly for your business as you would be missing out on a lot of opportunities that you could have had had you caught the issue earlier.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Wi-Atcm5HjP9PvzX4p4uKQ.png" /></figure><h3>Custom Alert #4: Spike in 404 Visits</h3><p>Not only can a spike in the number of users coming across 404 pages on your website indicate a problem with your user experience, but it can also affect your SEO performance. The number of 404 page visits that would be considered alarming depends on your website traffic. Having a few 404 page views when you get thousands of visitors should be fine, but if the number suspiciously increases drastically, this can be an indication of an SEO issue on your website.</p><p>Setting up an alert that is triggered by a week-over-week 10% increase in 404 visits is, in most cases, a good indicator. The issue is usually caused by broken internal links, which causes search crawlers to get stuck trying to reach non-existent pages on your website, which can harm your SEO and rankings. Once the alert is received, you can easily use <a href="https://search.google.com/search-console/">Google Search Console</a> to identify the issue’s source and fix it.</p><p>For the alert to work, your 404 pages need to have a custom page title that would be used to track them. The most common formats look something like “Website | Not Found” or “Page Not Found | Website”. However, you can always customize them as you wish.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*N-dFLHmkgt3LjxCbVmOAuQ.png" /></figure><h3>Custom Alert #5: Spike in Bounce Rate</h3><p>The last alert is for spikes in your bounce rate. The bounce rate is the percentage of users who exit the website after viewing only one page. You have to monitor the bounce rate, especially for your top-performing landing pages. That way, you can immediately take any needed actions like optimizing the content of the page or adjusting your call to actions.</p><p>Bounce rates can differ vastly depending on your business or the content of your website. For example, blogs naturally have lower bounce rate since it’s more likely for users to view more than one post or article as opposed to more commercial or business websites.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*oX8H5FG1XzzGvfzWcFNlMw.png" /></figure><h3>Get Started With These Alerts Now!</h3><p>Instead of having to spend a lot of time and effort setting up these custom Google Analytics alerts, you can get started with all five of them right away using the <a href="https://dashdash.com/templates/seo-website-performance-alerts-slack">“Get SEO website performance alerts”</a> dashdash template. It will send you timely alerts straight to your Slack workspace, which is a feature you can’t set up through Google Analytics. Alternatively, you can adjust it to have them sent to your email instead or even by SMS.</p><p>Did I mention that it’s <strong>FREE</strong> and only takes a few minutes to set up?</p><h3>Get Early Access!</h3><p>To get a dashdash account and set up your custom Google Analytics alerts, you can reach out to me via:</p><ul><li><strong>Email:</strong> <a href="/service/mailto:hady@dashdash.com">hady@dashdash.com</a></li><li><strong>Twitter:</strong> <a href="https://twitter.com/HadyElHady93">@HadyElHady93</a></li><li><strong>Calendly:</strong> <a href="https://calendly.com/dashdash-onboardings/early-access">Book a call</a> so I can help you set up your alerts and get started.</li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=23a6ec1d3d36" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rows/5-google-analytics-custom-alerts-for-seo-you-need-to-track-23a6ec1d3d36">5 Google Analytics Custom Alerts for SEO You Need to Track</a> was originally published in <a href="https://medium.com/rows">Rows</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Search GitHub Jobs using a Spreadsheet]]></title>
            <link>https://medium.com/rows/search-github-jobs-using-a-spreadsheet-f7f34cd33967?source=rss----503b89cb1052---4</link>
            <guid isPermaLink="false">https://medium.com/p/f7f34cd33967</guid>
            <category><![CDATA[spreadsheets]]></category>
            <category><![CDATA[api]]></category>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[jobs]]></category>
            <category><![CDATA[github]]></category>
            <dc:creator><![CDATA[Hady ElHady]]></dc:creator>
            <pubDate>Fri, 22 May 2020 12:19:42 GMT</pubDate>
            <atom:updated>2020-05-22T12:19:42.857Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4F-zfwWrvsbAfiRxs9qqYw.png" /></figure><p>The GitHub Jobs API allows you to search and view jobs. You can look up jobs by roles, functions, and locations, and retrieve a list of the job listings including the title, company name, location, description, how to apply, and more.</p><p>In this tutorial, you will learn how to create an app using the GitHub API to retrieve the listings in a spreadsheet. Then, publish it as a web app that you can share with other people.</p><p>You can use the <a href="https://dashdash.com/templates/find_jobs_on_github">Find jobs on GitHub</a> template to get started right away or follow this step-by-step guide to build it from scratch.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FXq2qtP9JsYU%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DXq2qtP9JsYU&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FXq2qtP9JsYU%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/816ffb6e9b0aaaf09cf8236bb6d64f40/href">https://medium.com/media/816ffb6e9b0aaaf09cf8236bb6d64f40/href</a></iframe><h3>What you’ll need</h3><ul><li>A <a href="https://app.dashdash.com/auth/get-early-access">dashdash account</a>. You’ll find more information at the end of the guide on how to get early access to the platform.</li></ul><h3>Connecting the API</h3><p>We’ll start by setting up the API request. We’ll be using the following parameters to perform our search:</p><ul><li><strong>description:</strong> A search term, such as “java” or “backend engineer”.</li><li><strong>location:</strong> A city name, zip code, or other location search term.</li><li><strong>full_time:</strong> If you want to limit results to full-time positions, set this parameter to “true”. Otherwise, you can leave it blank.</li><li><strong>page:</strong> Used for pagination as the API returns 50 listings at a time. By default, it’s set to “0” which retrieves the first page of results. You can set it to “1” for the second page, “2” for the third, and so on.</li></ul><p>All the parameters are optional and you can use any combination of them. We’ll list them down in column A.</p><blockquote><strong>A1:</strong> url<br><strong>A2:</strong> description<br><strong>A3:</strong> location<br><strong>A4:</strong> full-time<br><strong>A5:</strong> page</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*koo8RMctUq2VdqYzsGofig.png" /></figure><p>For “url”, we’ll copy and paste the API URL.</p><blockquote><strong>B1:</strong> <a href="https://jobs.github.com/positions.json">https://jobs.github.com/positions.json</a></blockquote><p>The API request is structured in the following way.</p><blockquote>[API URL]?[first parameter]=[value]&amp;[second parameter]=[value]&amp; …etc.</blockquote><p>That way, it corresponds to a request that looks like this.</p><blockquote><a href="https://jobs.github.com/positions.json?description=python&amp;location=new+york">https://jobs.github.com/positions.json?description=python&amp;location=new+york</a></blockquote><p>We’ll be using the GET function, which is the HTTP web request to retrieve data from the API, and structure the API call by adding the parameters and referencing their corresponding cells in which we’ll be adding the values.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*X01Ou2kwvt_a5qVG65Gcvg.png" /></figure><blockquote><strong>D1:</strong> Get jobs<br><strong>E1:</strong> =GET(B1&amp;”?description=”&amp;B2&amp;”&amp;location=”&amp;B3&amp;”&amp;full_time=”&amp;B4&amp;”&amp;page=”&amp;B5)</blockquote><p>By executing E1, you will get a #SIZE! error because the API is trying to retrieve all the roles on GitHub Jobs as no search parameters are defined. We can execute our first request by defining the values to the parameters in column B. For example, if we enter “Full Stack” in B2 and “California” in B3, we’ll get a list of relevant roles from GitHub.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hPaI0DOd_jgjzjptWbFjLw.png" /></figure><blockquote><strong>B2:</strong> Full Stack<br><strong>B3:</strong> California</blockquote><p>By clicking on the {data} object, we can view the list of retrieved roles. In the next section, we’ll discuss how we can have them automatically displayed in the spreadsheet with every search.</p><h3>Displaying the Jobs</h3><p>dashdash offers three functions that allow you to display JSON data in table form easily; INSERT_DATA, OVERWRITE_DATA, and UPDATE_DATA.</p><ul><li><strong>INSERT_DATA:</strong> Displays the data in a table and keeps adding any new data to the same table in new rows with every function execution.</li><li><strong>OVERWRITE_DATA:</strong> Overwrites the table data with every new function execution.</li><li><strong>UPDATE_DATA:</strong> Takes an extra key parameter, which is usually a unique identifier (e.g., url). It checks the defined key to check if the inserted rows are unique (don’t match the key) or not. If a row is unique, it’s inserted normally in the table, acting like INSERT_DATA. If a row is not unique, it doesn’t insert it in a new row and only updates the other data points it contains if they had any changes.</li></ul><p>We can use INSERT_DATA to display the retrieved job listings. All we have to do is define the data object (E1) and where we want to display the table (A8:8).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dYhRRAYtnfwelebRBBR4ZA.png" /></figure><blockquote><strong>D2:</strong> Fill table<br><strong>E2:</strong> =INSERT_DATA(E1,A8:8)</blockquote><p>When using INSERT_DATA, new job listings will be added to the table with every new search. If we would like to completely overwrite the table with each search, we can use OVERWRITE_DATA.</p><blockquote><strong>E2:</strong> =OVERWRITE_DATA(E1,A8:8)</blockquote><h3>Controlling the Function Execution</h3><p>Whenever any changes are made to any of the values of the parameters, the GET function automatically executes, and new results will be retrieved. However, if we want to control the function’s execution, we can use a button to do so.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KtT81M9bg0yALPi-hNuN9A.png" /></figure><p>To add a button, we need to select the cell where we want to add it (e.g. B6). Then, click on the action elements section, select “button”, and give it a label. We’ll give it the label “SEARCH”.</p><p>To link the button to the function, we need to use an IF function. The IF condition defines that if the button is pressed, the function is executed. Otherwise, we’ll show the text “Press the button”.</p><blockquote><strong>E1:</strong> =IF(B6=”SEARCH”,GET(B1&amp;”?description=”&amp;B2&amp;”&amp;location=”&amp;B3&amp;”&amp;full_time=”&amp;B4&amp;”&amp;page=”&amp;B5),”Press the button”)</blockquote><p>You might notice that E2 will return an error. That’s because until you press the button, E1 won’t be a data object anymore. We can use the IFERROR function to hide the error.</p><blockquote><strong>E2:</strong> =IFERROR(OVERWRITE_DATA(E1,A8:8),””)</blockquote><h3>Publishing as an App</h3><p>Once the spreadsheet is ready, we can go ahead and publish it as a web app.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rJ_pumqio-iJ1HbtoAjq5g.png" /></figure><p>All we have to do is define the cells where users can input the parameters values. To do that, we need to select the input cells B2:B5, click on the action elements section and select “Input field”.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rbyNl4-SITXy8-I4OAD-rQ.png" /></figure><p>To publish the app, click on the “Publishing Settings” icon in the upper left corner next to “Preview.” Then, hit the “Publish” button.</p><p>The app is now published, and the link is copied to the clipboard. We can also copy it by clicking on the “Copy link to clipboard” icon that has appeared next to the publishing one. We can view the published app version of the dashboard by pasting the link in the address bar.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0-77GXTQpGEK3It4OyDmrw.png" /></figure><p>The published app behaves in the same way as the spreadsheet. That way, you can share it with your other people.</p><h3>Make the Most out of dashdash!</h3><p>To take your app to the next level, you can leverage dashdash’s automation functions like the REFRESH function to automate the retrieval of new job listings. You can also combine it with other integrations like <a href="https://dashdash.com/integrations/slack">Slack</a> and <a href="https://dashdash.com/integrations/gmail">Gmail</a> to receive alerts of new jobs by Slack or email.</p><h3>Get Early Access!</h3><p>To get a dashdash account and start building your apps, you can reach out to me via:</p><ul><li><strong>Email:</strong> <a href="/service/mailto:hady@dashdash.com">hady@dashdash.com</a></li><li><strong>Twitter:</strong> <a href="https://twitter.com/HadyElHady93">@HadyElHady93</a></li><li><strong>Calendly:</strong> <a href="https://calendly.com/dashdash-onboardings/early-access">Book a call</a> so I can help you set up your dashboard and get started.</li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f7f34cd33967" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rows/search-github-jobs-using-a-spreadsheet-f7f34cd33967">Search GitHub Jobs using a Spreadsheet</a> was originally published in <a href="https://medium.com/rows">Rows</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Create a Custom Google Analytics Dashboard in a Spreadsheet]]></title>
            <link>https://medium.com/rows/how-to-create-a-custom-google-analytics-dashboard-in-a-spreadsheet-e1d309a35a3e?source=rss----503b89cb1052---4</link>
            <guid isPermaLink="false">https://medium.com/p/e1d309a35a3e</guid>
            <category><![CDATA[spreadsheets]]></category>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[google-analytics]]></category>
            <category><![CDATA[analytics]]></category>
            <dc:creator><![CDATA[Hady ElHady]]></dc:creator>
            <pubDate>Fri, 15 May 2020 11:36:31 GMT</pubDate>
            <atom:updated>2020-05-17T12:21:25.372Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rRc_RY43eZwSgowW0_D8VQ.png" /></figure><p>In this tutorial, you will learn how to create a custom Google Analytics dashboards in a spreadsheet. Then, publish it as a web app that you can share with your team members.</p><p>You can use the <a href="https://dashdash.com/templates/create_google_analytics_dashboards">Create Google Analytics dashboards</a> template to get started right away or follow this step-by-step guide to build it from scratch.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FrIZEQTjAYsQ%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DrIZEQTjAYsQ&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FrIZEQTjAYsQ%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/6e3239c48d464e8ffa4576b77e7b1589/href">https://medium.com/media/6e3239c48d464e8ffa4576b77e7b1589/href</a></iframe><h3>What you’ll need</h3><ul><li>A <a href="https://app.dashdash.com/auth/get-early-access">dashdash account</a>. You’ll find more information at the end of the guide on how to get early access to the platform.</li><li>A <a href="http://analytics.google.com/">Google Analytics</a> account.</li></ul><h3>1. Connecting Google Analytics</h3><p>First, you will need to connect the Google Analytics integration and retrieve the Google Analytics view ID that you will use to fetch the data.</p><h3>Connecting the Integration</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*_BGcLxAdlvJRCP8fQkHIlQ.png" /></figure><p>To connect the Google Analytics integration, you need to:</p><ol><li>Head to the <a href="https://app.dashdash.com/dashboard/integrations/google_analytics">Google Analytics integration page</a> or open it inside the spreadsheet by clicking on the “Integrations” button in the upper right corner.</li><li>Click the “Connect” button. This will redirect you to the Google Analytics website.</li><li>Select the Google Analytics account you want to connect.</li><li>Click “Allow” to authorize access to the platform.</li></ol><h3>Getting the View ID</h3><h4>Retrieving the ID manually</h4><figure><img alt="Retrieving the Google Analytics view ID manually" src="https://cdn-images-1.medium.com/max/1024/1*bcxSC72NHb7GJ6GdgO_5vQ.png" /></figure><p>To retrieve your ID manually, you need to:</p><ol><li>Head to <a href="http://analytics.google.com/">Google Analytics</a>.</li><li>Select your desired analytics account, property, and view.</li><li>You will find the view ID under the view name. For example, in the screenshot below the ID is the highlighted “12345678”.</li></ol><h4>Retrieving the ID using dashdash</h4><figure><img alt="Retrieving the Google Analytics view ID using dashdash" src="https://cdn-images-1.medium.com/max/1024/1*5-9wF4vcyC_O3XlqtUB0aw.png" /></figure><p>Alternatively, you can use the LIST_ACCOUNTS_ANALYTICS_GOOGLE function to list down your Google Analytics accounts, properties, and views.</p><pre><strong>D1: </strong>Get ID<strong><br>E1:</strong> =LIST_ACCOUNTS_ANALYTICS_GOOGLE()</pre><p>Find the view ID you want to use and PARSE it into a cell. You can do so by clicking on it to copy it to the clipboard and then paste it in a cell to generate the necessary formula automatically. You can always reference that cell whenever the view ID is required.</p><pre><strong>A1:</strong> ID<strong><br>B1:</strong> =PARSE(A1,”[‘items’][0].[‘webProperties’][0].[‘profiles’][0].[‘id’]”)</pre><p>Note that you need the view ID for the functions to work, not the account or property ID.</p><h3>2. Retrieving the Metrics</h3><h3>Analytics Functions</h3><p>dashdash offers three functions that allow you to retrieve data from Google Analytics.</p><ol><li><strong>PAGE_ANALYTICS_GOOGLE:</strong> Returns the Google Analytics page metrics of the website or a specific webpage including:</li></ol><ul><li>Page value (ga:pageValue)</li><li>Entrances (ga:entrances)</li><li>Entrance rate (ga:entranceRate)</li><li>Pageviews (ga:pageviews)</li><li>Pageviews per session (ga:pageviewsPerSession)</li><li>Unique pageviews (ga:uniquePageviews)</li><li>Time on page (ga:timeOnPage)</li><li>Average time on page (ga:avgTimeOnPage)</li><li>Exits (ga:exits)</li><li>Exit rate (ga:exitRate)</li></ul><p><strong>2. SESSION_ANALYTICS_GOOGLE:</strong> Returns the Google Analytics session metrics of the website or a specific webpage including:</p><ul><li>Users (ga:users)</li><li>New users (ga:newUsers)</li><li>% New Sessions (ga:percentNewSessions)</li><li>Sessions (ga:sessions)</li><li>Session duration (ga:sessionDuration)</li><li>Average session duration (ga:avgSessionDuration)</li><li>Sessions per user (ga:sessionsPerUser)</li><li>Bounces (ga:bounces)</li><li>Bounce rate (ga:bounceRate)</li><li>Hits (ga:hits)</li></ul><p><strong>3. CUSTOM_ANALYTICS_GOOGLE:</strong> Allows you to return a specified set of Google Analytics metrics of a website or a specific webpage. You can retrieve up to 10 metrics per request.</p><p>We’ll be using CUSTOM_ANALYTICS_GOOGLE to customize our dashboard with our desired set of metrics. However, you can use any of the other functions if they cover your needs.</p><h3>Getting the Metrics</h3><p>The CUSTOM_ANALYTICS_GOOGLE function has three required parameters and five optional ones:</p><p><strong>Required:</strong></p><ul><li><strong>id:</strong> The view ID retrieved in the previous section.</li><li><strong>date_range:</strong> The date range we want to look up.</li><li><strong>metrics:</strong> The aggregated statistics for user activity to your website, such as clicks or pageviews.</li></ul><p><strong>Optional:</strong></p><ul><li><strong>page_path:</strong> Used to look up the metrics of a specific webpage by entering its relative path.</li><li><strong>dimensions:</strong> Breaks down the metrics by common criteria (e.g. country, browser).</li><li><strong>sort:</strong> A list of metrics and dimensions indicating the sorting order and sorting direction for the returned data.</li><li><strong>filters:</strong> Restricts the data retrieved by defined dimensions or metrics expressions.</li><li><strong>segment:</strong> Restricts the data by a specific segment of users and sessions.</li></ul><p>For example, if we want to look up the pageviews and sessions of view “12345678” during the first week of April 2020. By browsing the returned {analytics} object, you will find the retrieved metrics and their values.</p><pre><strong>E2:</strong> =CUSTOM_ANALYTICS_GOOGLE(“12345678”,”[2020–04–01;2020–04–07]”,”ga:pageviews,ga:sessions”)</pre><figure><img alt="The Google Analytics Metrics &amp; Dimensions Explorer" src="https://cdn-images-1.medium.com/max/1024/1*lYI2RdCaqsPGrigz4lUw0g.png" /></figure><p>Check out the <a href="https://ga-dev-tools.appspot.com/dimensions-metrics-explorer/">Google Analytics Metrics &amp; Dimensions Explorer</a> for a full list of available metrics and dimensions.</p><p>To make this more customizable, we can list down the parameters in the spreadsheet and add them to the function as cell references. That way, we can easily change their values and have the function automatically reflect the changes.</p><figure><img alt="Google Analytics metrics retrieved" src="https://cdn-images-1.medium.com/max/1024/1*tP9JsTY4jBsN_bstNj4i9w.png" /></figure><pre><strong>A2:</strong> Date range<br><strong>A3:</strong> Metrics<br><strong>A4:</strong> Page path<br><strong>A5:</strong> Dimensions<br><strong>A6:</strong> Sort<br><strong>A7:</strong> Filters<br><strong>A8:</strong> Segment<br><strong>E2:</strong> =CUSTOM_ANALYTICS_GOOGLE(B1,B2,B3,B4,B5,B6,B7,B8)</pre><p>To recreate the previous request, we would just have to update the respective cells.</p><pre><strong>B2:</strong> [2020–04–01;2020–04–07]<br><strong>B3:</strong> ga:pageviews,ga:sessions</pre><figure><img alt="Retrieved Google Analytics metrics" src="https://cdn-images-1.medium.com/max/1024/1*S6VVjtEgUttE_MD_2fkCRg.png" /></figure><p>If a request has no dimensions, the returned metrics provide aggregate values for the requested date range, such as overall pageviews or total bounces. We can easily display these values by parsing them, the same way we did for the ID, by clicking on it and pasting it in a cell.</p><figure><img alt="Google Analytics pageviews" src="https://cdn-images-1.medium.com/max/1024/1*6hHtSiIXp8Z6FrvNt7SUJQ.png" /></figure><pre><strong>E3:</strong> =PARSE(E2,”[‘totalsForAllResults’].[‘ga:pageviews’]”)</pre><p>When dimensions are defined, the values of the metrics are segmented by the dimension values. For example, ga:pageviews requested with ga:country returns the total pageviews per country. That means that instead of aggregate values, a table is returned with multiple rows. For example, by requesting to get the pageviews and sessions of the website broken down by device categories.</p><pre><strong>B5:</strong> ga:deviceCategory</pre><figure><img alt="The values of the Google Analytics metrics are segmented by the dimension values" src="https://cdn-images-1.medium.com/max/521/1*tcLCwqXDY-rzjJ8-j4a7oQ.png" /></figure><p>You can still find the aggregate values of the metrics in the totalsForAllResults section. This includes the values for all retrieved device categories combined.</p><p>However, in this case, we also have three rows returned as the values of the pageviews and sessions are broken down by the retrieved device categories; desktop, mobile, and tablet.</p><p>We can parse these values to create the desired table. However, it’s not always efficient to parse them one at a time, especially if your request returns hundreds or thousands of rows. We also want the table to update automatically in case any changes occur.</p><p>In the next section, we’ll discuss the functions dashdash offers to automate the process of displaying the retrieved tables.</p><h3>3. Creating the Dashboard</h3><h3>Displaying the Metrics</h3><p>dashdash offers three functions that allow you to display JSON data in table form easily; INSERT_DATA, OVERWRITE_DATA, and UPDATE_DATA.</p><ul><li>I<strong>NSERT_DATA:</strong> Displays the data in a table and keeps adding any new data to the same table in new rows with every function execution.</li><li><strong>OVERWRITE_DATA:</strong> Overwrites the table data with every new function execution.</li><li><strong>UPDATE_DATA:</strong> Takes an extra key parameter, which is usually a unique identifier (e.g., date). It checks the defined key to check if the inserted rows are unique (don’t match the key) or not. If a row is unique, it’s inserted normally in the table, acting like INSERT_DATA. If a row is not unique, it doesn’t insert it in a new row and only updates the other data points it contains if they had any changes.</li></ul><figure><img alt="Google Analytics dashdash Recommended Tables" src="https://cdn-images-1.medium.com/max/1024/1*ZHt57ACMv0SQZBredHJe6A.png" /></figure><p>When opening the {analytics} object returned in E2, you will find two tabs; recommended and all data. The “all data” tab is the one we’ve been exploring so far which contains the API response. While the “recommended” tab offers recommended tables that you can create for specific custom dashdash functions. In this case, a Google Analytics report.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*K4hTHW8cOK635gOPc_tYwg.png" /></figure><p>By clicking on it, you are presented with two options. “Insert” which displays the data using an INSERT_DATA function and “Overwrite” which uses an OVERWRITE_DATA function. We’ll be using OVERWRITE_DATA to overwrite the table and create a new one whenever we make any changes to the parameters.</p><figure><img alt="Displaying the Google Analytics report in a dashdash Spreadsheet" src="https://cdn-images-1.medium.com/max/1024/1*MrD4VWGzZMsEg44hzYpjpg.png" /></figure><p>Click on Overwrite, select where you want to display the table (e.g. A10), and press Enter. The function will be inserted in A9 and the table displayed in A10:C10. You can also cut the function in A9 and paste it in E3 to move it out of the way.</p><pre><strong>D3:</strong> Fill table<strong><br>E3:</strong> =OVERWRITE_DATA(PARSE(E2,”[‘rows’]”),A10:10)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*iuTrvcZtiW0pdErXX4E5EA.png" /></figure><p>Now, if you make any changes to the parameters, the table will be updated automatically.</p><h3>4. Publishing the Dashboard</h3><p>Once you’ve created our desired dashboard, you can publish it as a web app. That way, you can share it with other people.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dD3w7k6R_bxAXRHcAC9urQ.png" /></figure><p>First, we need to define the cells where users can input data. To do that, we need to select the input cells B2:B8, click on the action elements section and select “Input field”. You can choose how much access you want to give to the users by limiting or eliminating certain parameters.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-p95ZefOnCLlKAEwn61V1w.png" /></figure><p>To publish the app, click on the “Publishing Settings” icon in the upper left corner next to “Preview.” Here, if the spreadsheet has multiple views, you can select which ones you want to publish and which ones to hide. For example, we can move the view ID to a separate view and reference it from that one, if we don’t want to display it in the shared app. Then, hit the “Publish” button.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*zo_ADf-or2fHPHU2hFjlgg.png" /></figure><p>The app is now published, and the link is copied to the clipboard. We can also copy it by clicking on the “Copy link to clipboard” icon that has appeared next to the publishing one. By pasting the link in the address bar, we can view the published app version of the dashboard.</p><p>The published app behaves in the exact same way as the spreadsheet. That way, you can share it with your team members without having to give them access to your dashdash or Google Analytics accounts.</p><h3>Make the Most out of dashdash!</h3><p>To take your dashboard to the next level, you can leverage dashdash’s automation functions like the REFRESH function to automate your report and have it retrieve new data periodically. You can also combine it with other integrations like <a href="https://dashdash.com/integrations/slack">Slack</a> and <a href="https://dashdash.com/integrations/gmail">Gmail</a> to receive daily or weekly reports of your website performance by Slack or email.</p><p>You can get started with pre-built templates for these use cases:</p><ul><li><a href="https://dashdash.com/templates/get_google_analytics_slack_reports">Get Google Analytics Slack reports</a></li><li><a href="https://dashdash.com/templates/get_google_analytics_email_reports">Get Google Analytics email reports</a></li></ul><p>Also, make sure to check out our forum post on <a href="https://forum.dashdash.com/t/how-to-use-google-analytics-in-dashdash-like-a-pro/513">how to use Google Analytics in dashdash like a pro</a> to learn more about the integration and how you can leverage its full power.</p><h3>Get Early Access!</h3><p>To get a dashdash account and start building your custom Google Analytics dashboard, you can reach out to me via:</p><ul><li><strong>Email:</strong> <a href="/service/mailto:hady@dashdash.com">hady@dashdash.com</a></li><li><strong>Twitter:</strong> <a href="https://twitter.com/HadyElHady93">@HadyElHady93</a></li><li><strong>Calendly:</strong> <a href="https://calendly.com/dashdash-onboardings/early-access">Book a call</a> so I can help you set up your dashboard and get started.</li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e1d309a35a3e" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rows/how-to-create-a-custom-google-analytics-dashboard-in-a-spreadsheet-e1d309a35a3e">How to Create a Custom Google Analytics Dashboard in a Spreadsheet</a> was originally published in <a href="https://medium.com/rows">Rows</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to generate enriched leads for outbound with dashdash and SalesLabs]]></title>
            <link>https://medium.com/rows/how-to-generate-enriched-leads-for-outbound-with-dashdash-and-saleslabs-ad9b4e81d0e1?source=rss----503b89cb1052---4</link>
            <guid isPermaLink="false">https://medium.com/p/ad9b4e81d0e1</guid>
            <category><![CDATA[b2b-lead-generation]]></category>
            <category><![CDATA[sales]]></category>
            <category><![CDATA[b2b-sales]]></category>
            <category><![CDATA[sales-tools]]></category>
            <category><![CDATA[lead-generation]]></category>
            <dc:creator><![CDATA[Thibaut Souyris]]></dc:creator>
            <pubDate>Wed, 13 Nov 2019 09:01:05 GMT</pubDate>
            <atom:updated>2019-11-13T09:01:04.961Z</atom:updated>
            <content:encoded><![CDATA[<h3>How to generate enriched leads for outbound with dashdash &amp; SalesLabs</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*iWfafpErnM-f10KCBPSeUQ.jpeg" /><figcaption>Image by<a href="https://unsplash.com/@anniespratt"> Annie Spratt via Unsplash</a></figcaption></figure><p>If you work in Sales or have ever been asked to <strong>generate lead lists for your business or sales team</strong>, you’re certainly familiar with the frustration of building and enriching prospect lists.</p><p>The process of obtaining qualified, verified leads that are ready for outreach is often messy and time-consuming. However, without these leads, your sales team can’t generate new opportunities and close deals.</p><p>There are a few approaches to lead generation: Either you hire an army of interns to manually scrape databases and find emails, have someone from your team do it manually, or you outsource it. No matter what you decide, you will either spend a lot of money or a lot of time.</p><p><strong>That’s why we’ve partnered with </strong><a href="https://dashdash.com/"><strong>dashdash</strong></a><strong> and created an end-to-end lead generation workflow that we use here at </strong><a href="https://www.saleslabs.io/"><strong>SalesLabs</strong></a><strong>.</strong></p><p>From company names and LinkedIn profiles to email addresses and even phone numbers, you can generate customized lead lists at scale, all in one spreadsheet and with no coding skills required. You can even send your leads directly to Hubspot or Pipedrive.</p><h4>TL;DR</h4><p>Find out how to build and enrich lead lists at scale in a spreadsheet — no coding skills required. Just the spreadsheet skills you already have!</p><h4>👉 <a href="https://saleslabs.typeform.com/to/zOxpi2"><em>Get access to the workflow here</em></a><em> </em>👈</h4><h3>Step 1: Generate a list of enriched companies</h3><p>Let’s assume we’re selling an HR solution to growing businesses. We’d like to build a list with CEOs of SaaS companies, based in Munich, with 50 to 100 employees.</p><p>In our first spreadsheet view, <em>Companies by Size</em>, we can retrieve data from Crunchbase thanks to dashdash’s custom API integration. You can build lists of companies and enrich them with Crunchbase data without the need of a Crunchbase Pro account! You only pay for what you use in dashdash, with $0.10 per search, and $0.01 per company enrichment via Crunchbase.</p><p>In order to fill an empty table with lead data , simply specify your search criteria, such as <strong>number of employees, category (industry), or location</strong>. Once ready, hit the <em>Get Companies</em> button and let the magic happen:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ye9Giecm-5bzETMbG-BBvA.gif" /><figcaption>Build a list of target companies with dashdash&#39;s custom Crunchbase functions.</figcaption></figure><p>And we’re not done yet! You can get additional data points like email domain, region, number of employees, funding rounds and investors, headquarter address, or <strong>names and LinkedIn profiles of the executive team</strong> by hitting the <em>Enrich All</em> button.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ogTNWozrcE1sbsrXpMXrUA.gif" /><figcaption>Enrich companies with Crunchbase data using dashdash&#39;s custom Crunchbase functions.</figcaption></figure><p>How cool is that? 🤩</p><p>Then, save your enriched lead list in a separate sheet (here: “Export Crunchbase”) with the <em>Save All</em> button.</p><p>But — what is a list of companies worth without the actual people you can get in touch with? Not much, right?</p><p>That’s why we added a sheet that <strong>identifies key stakeholders at our selected companies based on job title</strong>. Using dashdash&#39;s Google Custom Search integration, we can retrieve <strong>names, titles, and LinkedIn profile links</strong> of the decision makers we&#39;re looking for.</p><p>To send your companies to this sheet, just hit the <em>Send All</em> button and find the right POCs in a breeze. You can also get Xing profile links if you prefer.</p><h4>👉 <a href="https://saleslabs.typeform.com/to/zOxpi2">Get access to the workflow here</a> 👈</h4><h3>Step 2: Find people, enrich them with their work email and phone number</h3><p>The <em>Find people on LinkedIn</em> sheet lists your enriched companies from the first step. Let’s now find the CEOs of each company.</p><p>You would normally have to scrape that data manually on LinkedIn, which can be quite time-consuming (and super boring). Just make sure to put in the job title you are looking for in the <em>Job title/Function</em> column, then hit the <em>Get All Profiles </em>button.</p><p>Can you believe it?! You now have the first and last name of each CEO as well as their LinkedIn profile! You could already start your outreach on LinkedIn and get some deals running.</p><p>Now, you can choose to either use the <a href="https://dashdash.com/integrations/hunter">Hunter</a> or <a href="https://dashdash.com/integrations/pipl">Pipl</a> integration to further enrich your new contacts with an email address. Let’s use both, just in case. Pipl will give you phone numbers as well!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1ROtdQJHxIHAyvRR9JxzsA.gif" /><figcaption>Find the names, LinkedIn profile links, email addresses, and even phone numbers of each company’s CEO.</figcaption></figure><p>Amazing, right! We just found verified email addresses from two data sources as well as mobile phone numbers. Don&#39;t forget to save your new, fully enriched contacts in a separate sheet by hitting the <em>Save All </em>button.</p><p>Now, we are pretty much ready to start our outreach to our targeted list of leads, which brings us to our final step: Exporting our list to Hubspot. Luckily, we can also do that from within a spreadsheet cell!</p><h4>👉 <a href="https://saleslabs.typeform.com/to/zOxpi2">Get access to the workflow here</a> 👈</h4><h3>Step 3: Export to Hubspot</h3><p>From the <em>Export Contacts </em>view, which lists all your enriched leads in one place, just click on the <em>Add to HubSpot</em> button for each lead that you want to add to Hubspot, or press <em>Add All</em> to add them all at once<em>.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CQO4mso7KRT2fggs-I5LYQ.gif" /><figcaption>Automatically add your fully enriched leads to your HubSpot CRM.</figcaption></figure><p>And voilà! That’s how you generate massive lead lists from a spreadsheet, using dashdash and your spreadsheet skills — no scripts needed! With a bit of practice, you can generate hundreds of enriched leads in minutes, for a fraction of the cost that come with current solutions.</p><p><em>To give you an idea, I obtained around 1.260 enriched companies. I was able to find and enrich around 80% of CEOs, with a total spend of around $40, which results in about 4 cents per lead. This can vary based on your industry, but it is cheaper than anything I could find for enriched, targeted data.</em></p><p>This workflow is still in beta, and we very much welcome your feedback to make it even better. If you want to join the dashdash beta program and try this workflow yourself, <strong>fill in the </strong><a href="https://saleslabs.typeform.com/to/zOxpi2"><strong>form here</strong></a><strong> and we’ll get you set up as soon as possible!</strong></p><h4>👉 <a href="https://saleslabs.typeform.com/to/zOxpi2">Get access to the workflow here</a> 👈</h4><p><em>This article was co-authored by </em><a href="https://www.linkedin.com/in/thibautsouyris/"><em>Thibaut Souyris</em></a><em>, CEO &amp; Founder of </em><a href="https://www.saleslabs.io/"><em>SalesLabs</em></a><em>, and Nadja Beneš, Content Strategy &amp; Customer Success at dashdash.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ad9b4e81d0e1" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rows/how-to-generate-enriched-leads-for-outbound-with-dashdash-and-saleslabs-ad9b4e81d0e1">How to generate enriched leads for outbound with dashdash and SalesLabs</a> was originally published in <a href="https://medium.com/rows">Rows</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Introducing dashdash Templates]]></title>
            <link>https://medium.com/rows/introducing-dashdash-templates-97eeffe009c9?source=rss----503b89cb1052---4</link>
            <guid isPermaLink="false">https://medium.com/p/97eeffe009c9</guid>
            <category><![CDATA[saas]]></category>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[api]]></category>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[startup]]></category>
            <dc:creator><![CDATA[Humberto Ayres Pereira]]></dc:creator>
            <pubDate>Wed, 09 Oct 2019 05:44:38 GMT</pubDate>
            <atom:updated>2019-10-09T05:52:24.810Z</atom:updated>
            <content:encoded><![CDATA[<h4>Prebuilt, customizable tools to access business data and APIs</h4><figure><img alt="dashdash templates: Prebuilt, customizable tools to access business data and APIs" src="https://cdn-images-1.medium.com/max/1024/1*BPVIHM40Vanp2ys15emgmQ.jpeg" /></figure><p>Ever since we started building dashdash, our purpose has always been to “create tools that make computation accessible to everyone”. We want to allow the 1 billion Excel users worldwide to easily build tools catering to their personal and professional needs without code and using a familiar interface — a spreadsheet!</p><p>We gave users access to business data and APIs through Integrations with platforms like Crunchbase, LinkedIn, Mailchimp, Google Maps and more. To make it even easier, we introduced Instant Integrations, which allow calling these without the need for API keys or monthly subscriptions. You pay us for just what you consume, up to a monthly limit you define.</p><p>And now, to make building tools even easier, we’re launching Templates!</p><figure><img alt="The dashdash Templates page" src="https://cdn-images-1.medium.com/max/1024/1*3pZYR20XYA5zSuZmgBRq4A.png" /><figcaption>The dashdash Templates page</figcaption></figure><h3>dashdash Templates</h3><p>Our templates give you access to a gallery of prebuilt, customizable tools. Just select the desired template and start using it right away!</p><p>The templates cover many different use cases:</p><ul><li>Finding and enriching companies with Crunchbase.</li><li>Finding people with LinkedIn, Hunter, Pipl, and Infobel.</li><li>Creating stock trackers that send Slack alerts.</li><li>Looking up jobs on GitHub.</li></ul><p>More and more templates are added every week to cater to all of our users’ needs!</p><h3>Some templates to get you started!</h3><h4><a href="https://dashdash.com/page/templates/find_companies_by_size">1. Find companies by size</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*oktWZK0VqOdfuEp_fJdTpw.gif" /></figure><p><strong>Integrations:</strong> <a href="https://dashdash.com/page/integrations/crunchbase">Crunchbase</a><br><strong>Input:</strong><br>- <strong>Required:</strong> Company size, and category.<br>- <strong>Optional:</strong> Location, and founding date.<br><strong>Output:</strong> List of companies matching the criteria with data including company name, domain, founding date, status, description, categories, employee count, contact email, address, city, country, total funding amount in USD, funding rounds, investors, LinkedIn URL, Crunchbase URL, people associated with the company, and IPO information.<br><strong>Price:</strong> $0.10/request</p><h4><a href="https://dashdash.com/page/templates/get_phone_numbers_by_name_company"><strong>2. Get phone numbers by name and company</strong></a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*HpKwYXFjE7M9Z_P5Ro6wsQ.gif" /></figure><p><strong>Integrations:</strong> <a href="https://dashdash.com/page/integrations/pipl">Pipl</a> + <a href="https://dashdash.com/page/integrations/google_custom_search_site_restricted">Google Search — top sites (LinkedIn)</a><br><strong>Input:</strong> Full name, and company name.<br><strong>Output:</strong> Phone numbers linked to the person. The data object returned also contains additional information about the person including email addresses, career history, addresses, social media URLs, usernames, gender, date of birth, languages, relationships, and associated images.<br><strong>Price:</strong><br>- $0.05/request to retrieve the LinkedIn profile.<br>- $0.45/request to retrieve the phone numbers.</p><h4><a href="https://dashdash.com/page/templates/enrich_mailchimp_subscribers"><strong>3. Enrich Mailchimp subscribers</strong></a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZBMB5559ClAse2SYLot5Eg.gif" /></figure><p><strong>Integrations:</strong> <a href="https://dashdash.com/page/integrations/mailchimp">Mailchimp</a> + <a href="https://dashdash.com/page/integrations/crunchbase">Crunchbase</a><br><strong>Input:</strong> Mailchimp audience ID<br><strong>Output:</strong> List of Mailchimp subscribers enriched with Crunchbase company data including company name, domain, founding date, status, description, categories, employee count, contact email, address, city, country, total funding amount in USD, funding rounds, investors, LinkedIn URL, Crunchbase URL, people associated with the company, and IPO information.<br><strong>Price:</strong><br><strong>- Free</strong> to retrieve the Mailchimp subscribers.<br>- $0.04/request to retrieve the Crunchbase data.</p><h4><a href="https://dashdash.com/page/templates/find_and_enrich_people_on_linkedin">4. Find and enrich people on LinkedIn</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hy7NP3-5F4Fj-nuN7fjQrw.gif" /></figure><p><strong>Integrations:</strong> <a href="https://dashdash.com/page/integrations/google_custom_search_site_restricted">Google Search — top sites (LinkedIn)</a> + <a href="https://dashdash.com/page/integrations/hunter">Hunter</a><br><strong>Input:</strong> Job title/function, and company name or location.<br><strong>Output:</strong> Person’s name, title, LinkedIn URL, email address, and confidence score.<br><strong>Price:</strong><br>- $0.05/request to retrieve the LinkedIn profile.<br>- $0.04/request to retrieve the email address.</p><h4><a href="https://dashdash.com/page/templates/track_stocks_with_slack_alerts">5. Track stocks with Slack alerts</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VTH-SJ6RwdJhM1xS8x46EQ.gif" /></figure><p><strong>Integrations:</strong> <a href="https://dashdash.com/page/integrations/alphavantage">Alpha Vantage</a> + <a href="https://dashdash.com/page/integrations/slack">Slack</a><br><strong>Input:</strong> Company name, Slack username, and trigger logic, if needed.<br><strong>Output:</strong> The company stock symbol, as well as real-time data including the open, high, low, current price, volume, latest trading day, previous close, change, and percentage of change.<br><strong>Price:</strong><br><strong>- Free</strong> to get the stocks quotes.<br><strong>- Free</strong> to send Slack messages.</p><h4><a href="https://dashdash.com/page/templates/finds_news_articles_and_mentions">6. Find News articles and mentions</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ah2dDmy41sFgzviNbWevZA.gif" /></figure><p><strong>Integrations:</strong> <a href="https://dashdash.com/page/integrations/news_api">News API</a><br><strong>Input:<br>Required:</strong> Keywords.<br><strong>- Optional:</strong> Date, language, and domains.<br><strong>- Output:</strong> Articles including source, author, title, description, URL, image URL, publishing date, and content.<br><strong>Price:<br>- Free</strong> to get News articles and mentions (API key needed).</p><h3>Get Started with dashdash Templates Now!</h3><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F8W_qMRNC-dY%3Ffeature%3Doembed&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D8W_qMRNC-dY&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F8W_qMRNC-dY%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/e7f93e99508d7b595e24f2d8f28df1ba/href">https://medium.com/media/e7f93e99508d7b595e24f2d8f28df1ba/href</a></iframe><ul><li>Sign up for early access at <a href="http://www.dashdash.com/">www.dashdash.com</a>. We’ll be reaching out to you asap to give you access to your account.</li><li>Check out our <a href="https://www.youtube.com/channel/UCQUmiIyETHv8ccZLdsvNzdA/videos">Youtube channel</a> to learn more about what you can do with dashdash!</li><li>Check out our <a href="https://forum.dashdash.com/">forum</a> to see the different tools built by our community.</li><li>Follow us on <a href="https://medium.com/dashdash">Medium</a>, <a href="https://twitter.com/dashdash">Twitter</a>, and <a href="https://www.linkedin.com/company/dash-dash/">LinkedIn</a> for updates or come <a href="https://github.com/dashdash/hiring/blob/master/README.md">work with us</a>!</li></ul><p>Finally, we’re on <a href="https://www.producthunt.com/posts/dashdash-templates"><strong>Product Hunt</strong></a> today and would appreciate your support!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=97eeffe009c9" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rows/introducing-dashdash-templates-97eeffe009c9">Introducing dashdash Templates</a> was originally published in <a href="https://medium.com/rows">Rows</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How we innovate at dashdash]]></title>
            <link>https://medium.com/rows/how-we-innovate-at-dashdash-baced4a76b13?source=rss----503b89cb1052---4</link>
            <guid isPermaLink="false">https://medium.com/p/baced4a76b13</guid>
            <category><![CDATA[hackathons]]></category>
            <category><![CDATA[innovation]]></category>
            <category><![CDATA[engineering]]></category>
            <dc:creator><![CDATA[Nuno Veloso]]></dc:creator>
            <pubDate>Mon, 16 Sep 2019 11:24:45 GMT</pubDate>
            <atom:updated>2019-09-16T11:26:38.696Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Npatn-sfnsAwZyjcIYxjsA.png" /><figcaption>dashdash</figcaption></figure><p>Our business is based on a spreadsheet. Spreadsheets are used worldwide by approximately 1 billion users, and the supply of solutions is increasing exponentially — therefore, innovating and surprising our users is crucial to our success.</p><p>With the need of building an outstanding product comes the ambition to attract the best people. Our engineering team is extremely talented, and it goes without saying that we try to involve them in our innovation process wherever possible.</p><p><strong>Why do we do that?</strong></p><ul><li>Engineers get closer to the business and to the users’ needs/struggles</li><li>Innovating urges reflection of causes and solutions for current and future problems</li><li>We capitalize on and challenge incredibly smart and talented minds</li></ul><p>After taking into account several possibilities to stimulate the innovation process at dashdash, we decided to move forward with <strong>two initiatives</strong> which are running in parallel:</p><ul><li><strong>Internal Hackathon</strong></li><li><strong>Innovation Time</strong></li></ul><p>The Internal Hackathon initiative already took place in late 2018 and was structured like so:</p><h4><strong>Hackathon</strong></h4><ul><li>Duration: 2 days</li><li>Location: An hotel in Porto</li><li>Teams: 1–3 functions (Design team, Product team, and User Success team can be involved)</li><li>Jury: Product team (1 vote), Engineering Management team (1 vote), User Success team (1 vote), and People&#39;s Choice (every hackathon participant has 1 vote)</li></ul><p><strong>Event’s Agenda (Topics and Duration):</strong></p><ul><li>30 mins: Welcome Session</li><li>30 mins: Pre-Pitch</li><li>30 mins: Pitch</li><li>Development Time</li><li>1 hour: Showcase</li><li>30 mins: Awards Presentation</li><li>30 mins: Wrap-up and Retrospective</li></ul><p><strong>Pre-Pitch (Preparation/Organization)</strong></p><p>Any idea that is submitted to the Pitch should answer, at least, the following questions:</p><ul><li>What problem do you want to solve?</li><li>Why does it matter/why is it an important problem?</li><li>Why is it challenging?</li><li>Why are you excited about it?</li><li>What/Who do you need to make it happen?</li></ul><p><strong>Pitch (Idea Presentation Step)</strong></p><p>Every team has 5 mins to explain the purpose, relevance, and challenge of their mission.</p><p>At this stage, anyone attending the pitch who feels inspired by the mission can join the team/person that owns the idea, making sure that one person only belongs to one team.</p><p><strong>Showcase (Demonstration Step)</strong></p><p>In this session, each team has 15 mins to explain and demo the result of the mission and show what they managed to accomplish within the development time.</p><p>This showcase slot is an opportunity for each team to shine, conquer votes from the audience, and contribute to the hackathon&#39;s overall innovation goal.</p><p><strong>Awards Presentation (Recognition Step)</strong></p><p>At this stage, the Jury announces the awards.</p><p>We consider the following criteria for our decision:</p><ul><li><strong>Business Impact</strong>: Assess whether the project can be included in the product backlog for further implementation and whether it can have a clear positive impact on the business.</li><li><strong>Popular Choice</strong>: All the participants will vote on a project that they feel is the most innovative and has the highest impact on the business. (Each participant will have a vote to give.) It&#39;s not allowed to vote for one&#39;s own project.</li></ul><p><strong>Wrap-up and Retrospective (Improvement Step)</strong></p><p>This session&#39;s purpose is to allow all participants to do a retrospective of the event and give ideas on how it can be improved for next iterations.</p><h4><strong>Summary</strong></h4><p>As you can see, the major focus of this first initiative was “Business Impact”, and we couldn&#39;t be happier with the results.</p><p>Great ideas came out of it, and many proofs of concept that clearly showed the value of the mission and shed light on the way forward for implementation!</p><p>Also, the vast majority of ideas are already part of our backlog, and everyone loved the initiative that we set a date for the next hackathon already!</p><h4><strong>Innovation Time</strong></h4><p>Innovation time is an initiative to grant independent time for developers to be available to explore new ideas, concepts, or technologies.</p><p>MVPs and POCs are the expected outcomes of this Innovation Time.</p><p>We hope to achieve the following goals with this initiative:</p><ul><li>Supporting employees&#39; professional growth</li><li>Getting developers closer to the Product/Business</li><li>Explore innovative technologies</li><li>Develop innovative and out-of-the-box features</li><li>Challenge and motivate the team</li></ul><p>We kicked off this initiative with a basic and well-defined structure in order to minimize negative impact on the business.</p><p>The Innovation Time takes place on the last day of the development cycle (e.g. Sprint) with the following restrictions:</p><ul><li>The team has to have completed all development cycle goals before (in production). We believe that this is a motivation for everyone to work closely together as a team</li><li>Developers are free to choose how they&#39;d like to use the Innovation Time</li><li>The work done during the Innovation Time should be presentable in the end</li></ul><p>Note that this is a very recent initiative we implemented into our process—we&#39;re still evaluating it and thinking in extending it to one full week per quarter.</p><p><strong>How do you innovate at your company? Excited to hear your thoughts!</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=baced4a76b13" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rows/how-we-innovate-at-dashdash-baced4a76b13">How we innovate at dashdash</a> was originally published in <a href="https://medium.com/rows">Rows</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Find the Right Prospects and Track Investments in a Spreadsheet]]></title>
            <link>https://medium.com/rows/find-the-right-prospects-and-track-investments-in-a-spreadsheet-9f680a4fa34?source=rss----503b89cb1052---4</link>
            <guid isPermaLink="false">https://medium.com/p/9f680a4fa34</guid>
            <category><![CDATA[crunchbase]]></category>
            <category><![CDATA[lead-generation]]></category>
            <category><![CDATA[enrichment]]></category>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[how-to]]></category>
            <dc:creator><![CDATA[Nadja Beneš]]></dc:creator>
            <pubDate>Wed, 07 Aug 2019 09:11:49 GMT</pubDate>
            <atom:updated>2019-08-07T12:50:07.038Z</atom:updated>
            <content:encoded><![CDATA[<h4>dashdash launches their Crunchbase integration</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Oia5pk84-pVGYPVoUm8Pmg.png" /></figure><p>You <em>really</em> <strong>love Crunchbase</strong>, but you would’ve loved being able to access data about innovative tech companies and investments <strong>from within a spreadsheet</strong> even more?</p><p>The dashdash Crunchbase integration lets you do exactly that: Discover new prospects and stay updated on your leads; identify and track companies in your target industry; research investors and monitor competitors; or find the next big tech trend — <strong>all that out of a spreadsheet cell and without a monthly subscription fee!</strong></p><p>Since Crunchbase is part of our <a href="https://forum.dashdash.com/t/instant-integrations-in-dashdash-q-a/407"><em>Instant Integrations</em></a>, you can access their data <strong>using only your dashdash account</strong> — no need to set up an account with Crunchbase. Simply access Crunchbase data right away in dashdash!</p><h4><strong>Ready to start building?</strong></h4><p>Follow this how-to guide or check out our video tutorial and build your first Crunchbase app in dashdash!</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fh2Gzbann_Bk%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dh2Gzbann_Bk&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fh2Gzbann_Bk%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/f658564a49af6fb076ea76c96cbbf129/href">https://medium.com/media/f658564a49af6fb076ea76c96cbbf129/href</a></iframe><h4><strong>Connect to the Crunchbase integration</strong></h4><p>To use the Crunchbase integration, you first need to connect it to your dashdash account. Head to the <a href="https://app.dashdash.com/dashboard/integrations"><em>Integrations Marketplace</em></a><em>, </em>find the Crunchbase integration, and hit connect!</p><p>If you haven’t already, add a payment method to top up your dashdash Wallet. The prices of each function (which make a request to the Crunchbase API) are documented on the <a href="https://app.dashdash.com/dashboard/integrations/crunchbase">integration page</a>. Starting from $0.02 per request, you can use Crunchbase data in dashdash.</p><h4><strong>Discover the right leads</strong></h4><p>Use Crunchbase in dashdash to identify new prospects and build lead lists. You can track down companies based on criteria that you define, such as employee size, <a href="https://support.crunchbase.com/hc/en-us/articles/360009616373">category</a>, location, <a href="https://data.crunchbase.com/docs/funding-types">funding type</a>, investors, and more.</p><p>Depending on your search parameters, you can retrieve a list of company names, including, amongst others, their <strong>domain, founding date, short description, category, employee range, email, postal address, total funding amount, funding rounds, or founding team.</strong></p><p><strong>With our custom-built functions, you can find companies…</strong></p><p><strong>a) by size</strong></p><p>With <strong>COMPANIES_BY_SIZE_CRUNCHBASE</strong>, you can look up companies by employee size, <a href="https://support.crunchbase.com/hc/en-us/articles/360009616373">category</a>, location, and founding date.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*sFho3gaxmwQShpBiyV7WHw.gif" /><figcaption>Find companies by size with dashdash &amp; Crunchbase</figcaption></figure><p><strong>b)</strong> <strong>by investor(s)</strong></p><p>You can use <strong>COMPANIES_BY_INVESTORS_CRUNCHBASE</strong>to track down companies with one or more specified investors. If you enter the names of more than one investor <strong>separated by commas</strong>, you will get companies that <strong>either investor invested in</strong>. You can also filter by last funding date, last <a href="https://data.crunchbase.com/docs/funding-types">funding type</a>, or location here.</p><p><strong>c)</strong> <strong>by funding</strong></p><p><strong>COMPANIES_BY_FUNDING_CRUNCHBASE</strong>gets you companies by funding based on the last funding date, last <a href="https://data.crunchbase.com/docs/funding-types">funding type</a>, last funding amount, total funding amount, and if needed, a location or <a href="https://support.crunchbase.com/hc/en-us/articles/360009616373">category</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yjDgfnbv7VLtWlxOfQy77g.gif" /><figcaption>Find companies by funding with dashdash &amp; Crunchbase</figcaption></figure><p><strong>d) by event attended</strong></p><p><strong>COMPANIES_AT_EVENT_CRUNCHBASE</strong>lets you retrieve a list of companies that are attending or have attended a certain event. Here, you can also filter by the company’s employee size and location.</p><h4><strong>Stay updated on your leads and monitor competitors</strong></h4><p>If you’d like to stay updated on your leads or monitor a specific competitor, you can use the function <strong>COMPANIES_BY_NAME_CRUNCHBASE</strong>. <br>Simply enter the company name and location if you like.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qiTJBd4Lmo2v8napjVKrPQ.gif" /><figcaption>Find companies by name with dashdash &amp; Crunchbase</figcaption></figure><h4><strong>Invest in the right people</strong></h4><p>Companies led by founders <strong>who were previously employed at a very successful company</strong> might be a good indicator of future success.</p><p>Use <strong>COMPANIES_BY_EX_EMPLOYER_CRUNCHBASE</strong>and specify the companies’ location, founding date, and the names of one or more companies that their founders previously worked at, for example, “Google” or “Uber”. If you enter the names of more than one company <strong>separated by commas</strong>, you will get the companies founded by alumni of <strong>any of these companies</strong>.</p><p><strong>COMPANIES_BY_FOUNDERS_WITH_EXIT</strong>will get you a list of companies with founders who were previously employed at a company that exited. Provide the companies’ location, founding date, exit amount, and exit date.</p><h4><strong>Find emerging industry trends</strong></h4><p>Keep track of funding activities within a specific sector with our function <strong>SECTOR_FUNDING_CRUNCHBASE</strong>. Specify the last funding date, the companies’ location, and <a href="https://support.crunchbase.com/hc/en-us/articles/360009616373">category</a> to get a list of companies, along with their domain, founding date, short description, category, employee range, email, postal address, total funding amount, funding rounds, founding team, and more.</p><p>In addition to that, you can also retrieve the <strong>total funding amount</strong> that was raised in this category, as well as the <strong>total valuation of all companies post-funding</strong> in this category.</p><h3><strong>Filters</strong></h3><p>With any of our custom-built functions, you can filter by additional search parameters:</p><h4><strong>Locations</strong></h4><p>For locations, you can enter a <strong>country </strong>(“United States”) or <strong>country code</strong> (“USA”), <strong>state </strong>(“California”), <a href="https://support.crunchbase.com/hc/en-us/articles/360010018153-How-are-regions-in-Crunchbase-defined-"><strong>region</strong></a><strong> </strong>(“Greater Los Angeles Area”), or <strong>city </strong>(“San Francisco”).</p><h4><strong>Dates</strong></h4><p>For dates, you can use the <strong>&lt;</strong> (less than) and <strong>&gt;</strong> (greater than) signs to search before or after a certain date or year (“&gt;2016”).</p><p><strong>Please note that you need to at least specify a year</strong>. Then, you can specify the month and day if needed. A <strong>specific date range</strong> works, too, e.g. “[2018–01–01;2019–03–31]”.</p><h4><strong>Company and investor names</strong></h4><p>Names of companies and investors need to match their respective names on <a href="https://www.crunchbase.com/">Crunchbase</a> so that you can retrieve accurate results.</p><h4><strong>Funding types and categories</strong></h4><p>For funding types and company categories, make sure to use the values that are recognized by Crunchbase.</p><p>Find the <strong>full list of available funding types </strong><a href="https://data.crunchbase.com/docs/funding-types"><strong>here</strong></a>. Feel free to also use the <strong>&gt;</strong> (greater than) sign to search for a certain investment stage or later (“&gt;series_a”).</p><p>Find the <strong>full list of available company categories </strong><a href="https://support.crunchbase.com/hc/en-us/articles/360009616373"><strong>here</strong></a>. You can also enter a category <strong>group</strong>.</p><p>Both lists are also accessible from within the <em>Function Helper</em> in any dashdash app.</p><h4><strong>Optional parameters</strong></h4><p>For functions that have multiple <strong>optional parameters</strong>, you can skip any of the parameters by <strong>adding commas and leaving the parameter blank</strong>.</p><p>For example, if you’re using the <strong>COMPANIES_AT_EVENT</strong> function and you only want to retrieve a list of companies that attended a specific event from a certain location — no matter how big the company is — then simply skip the employees parameter by adding commas and leaving it blank, like so: COMPANIES_AT_EVENT_CRUNCHBASE(&quot;INBOUND 2018&quot;, ,&quot;Boston&quot;) .</p><h4><strong>Mapping out data</strong></h4><p>Once you’ve generated the list of companies you need, you can easily map out their information in one of the following ways: by using the functions <strong>INSERT_DATA</strong>, <strong>OVERWRITE_DATA</strong>, or <strong>UPDATE_DATA</strong>.</p><p>With all of these data mapping functions, make sure you first <em>parse</em> the entire data set (or JSON object) of companies into a cell (here: cell E1). Then, refer to this {data} cell and select the headers of the table you want to send the data to.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*b_kRoGSl1nCGsNZzOT-6Aw.png" /><figcaption>Our entire data set sits in cell E1</figcaption></figure><p>Use the <strong>INSERT_DATA</strong>function to create a data log. You choose the data you’d like to fill into the table, and create the headers of the table accordingly. The function will then take the {data} cell (or JSON object) and instantly map out the information inside the object matching the selected headers.</p><p>Whenever you make a new request to get a list of companies, <strong>it will keep adding new rows to the bottom of the table’s pre-existing ones</strong>, creating a data log.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*gLDpmdpaFzp0wFawgJn33Q.png" /><figcaption>The INSERT_DATA function in E2 adds new rows to the bottom of the table</figcaption></figure><p><strong>OVERWRITE_DATA</strong> lets you work with the data of your last request only. Instead of adding new rows to the list, it will <strong>replace any pre-existing cells below the target header with new data </strong>following every execution of the function. Be cautious not to <em>overwrite</em> any data you want to keep! Just copy-paste it to another app view beforehand. 😉</p><p>Finally, <strong>UPDATE_DATA</strong> helps you keep an updated list of companies. It inserts the data from a {data} cell (or JSON object), but it also takes a list of keys, such as the company domain for example, which become the reference values to match with. The function will then <strong>check if there are any changes in the data relative to the key in order to decide if new data will be added or just updated</strong>.</p><p>This is particularly useful if you’re building a company tracker to stay updated on your leads or competitors, or on all the companies with a certain funding in your industry, and just want the data to update periodically.</p><h4><strong>Avoid multiple charges with buttons</strong></h4><p>Our Crunchbase functions are charged per request. This means that you get charged every time you execute a function. That’s why we advise you to add an action element like a button that controls the execution of the function to avoid multiple charges when making changes to the input parameters.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*h3DtmFp3ziMPOLnT6XaTJQ.gif" /><figcaption>Create a button to avoid multiple charges when making changes to the input parameters</figcaption></figure><h3><strong>Take your lead gen process to the next level</strong></h3><p>You’ve identified new prospects with Crunchbase? Great! Now <strong>combine your app with our other data enrichment integrations</strong> like <a href="https://app.dashdash.com/dashboard/integrations/hunter">Hunter</a>, Pipl, and <a href="https://app.dashdash.com/dashboard/integrations/clearbit">Clearbit</a>, or send your leads directly to your CRM using our integrations with <a href="https://app.dashdash.com/dashboard/integrations/hubspot">HubSpot</a>, <a href="https://app.dashdash.com/dashboard/integrations/pipedrive">Pipedrive</a>, or <a href="https://app.dashdash.com/dashboard/integrations/zoho_crm">Zoho</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/620/1*braLGRtfeq-uvYiqv-LyPA.gif" /></figure><p>Happy <strong>prospecting</strong>, <strong>tracking</strong>, and <strong>investing</strong>! 🤓</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/200/1*jC7S-QWeXWGJAGWqxDmeUQ.gif" /></figure><p><em>We hope you enjoyed this how-to guide. For more, check out </em><a href="https://forum.dashdash.com/"><em>our forum</em></a><em>, create your own guide and </em><a href="https://forum.dashdash.com/c/show-and-tell"><em>share it with the community</em></a><em>, or </em><a href="/service/mailto:nadja@dashdash.com"><em>let us know</em></a><em> which use case you’d like to see featured next! ✌️</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9f680a4fa34" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rows/find-the-right-prospects-and-track-investments-in-a-spreadsheet-9f680a4fa34">Find the Right Prospects and Track Investments in a Spreadsheet</a> was originally published in <a href="https://medium.com/rows">Rows</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Get Any Email Address in a Few Seconds]]></title>
            <link>https://medium.com/rows/get-any-email-address-in-a-few-seconds-20c626bbb843?source=rss----503b89cb1052---4</link>
            <guid isPermaLink="false">https://medium.com/p/20c626bbb843</guid>
            <category><![CDATA[how-to]]></category>
            <category><![CDATA[spreadsheets]]></category>
            <category><![CDATA[email]]></category>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[lead-generation]]></category>
            <dc:creator><![CDATA[Nadja Beneš]]></dc:creator>
            <pubDate>Wed, 10 Apr 2019 13:51:36 GMT</pubDate>
            <atom:updated>2019-08-07T12:53:36.045Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nwwX0ry55R5zP68MzO8J6Q.png" /></figure><p>You’ve successfully created your <a href="https://medium.com/dashdash/generate-leads-through-linkedin-in-3-simple-steps-7281abfc6e9d">custom lead generation app</a> in dashdash, and now want to proceed to enrichment of your new leads? Let’s do it!</p><p>By connecting to our Hunter.io integration, you can <strong>find the email address of any professional based on their full name and domain name of the email address</strong>. You have <a href="https://hunter.io/pricing">100 searches per month for free</a>!</p><h3><strong>Step 1: Connect to the Hunter.io integration</strong></h3><p>If you don’t have one already, head to <a href="https://hunter.io/users/sign_up">Hunter.io</a> and create an account. Get your API key <a href="https://hunter.io/api_keys">here</a> and use it to connect to our <a href="https://app.dashdash.com/dashboard/integrations/all/hunter">Hunter.io integration</a> from the <em>Integrations </em>menu.</p><h3><strong>Step 2: Set up your app</strong></h3><h4><strong>2.1. Find the email address of a list of prospects</strong></h4><p><em>Create an app</em> in dashdash. Set up three columns for</p><ul><li>A1:Company Domain</li><li>B1:First Name</li><li>C1:Last Name</li></ul><p><strong>Caution</strong>: Domains are <strong>not</strong> URLs! <br><em>Example</em>: For Spotify, the domain name is “<strong>spotify.com</strong>”, and <strong>not </strong>“<a href="http://www.spotify.com/">www.spotify.com</a>&quot; or “<a href="https://www.spotify.com/">https://www.spotify.com</a>”.</p><p>Import your list of prospects in the dashdash app. Then, use the next column to make your request:</p><pre>A2=spotify.com<br>B2=Amy<br>C2=Ferris<br>D2=FIND_EMAIL_HUNTER(A2,B2,C2)</pre><p>Parse the <strong>email address</strong>:</p><pre>E2=PARSE(D2,&quot;[&#39;data&#39;].[&#39;email&#39;]&quot;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fDaf-eLtmgUqRN5EReDMrg.gif" /><figcaption>Find any email with our Hunter.io integration</figcaption></figure><p>To get the email address for your full contact list, simply copy-paste the formulas in <strong>D2 and E2</strong> down.</p><h4><strong>2.2 Find the email address of generated leads in another app view</strong></h4><p>In case you’ve built your <a href="https://medium.com/dashdash/generate-leads-through-linkedin-in-3-simple-steps-7281abfc6e9d">custom lead generation app</a> in dashdash, here&#39;s how you <strong>automatically send your qualified leads to Hunter from another app view.</strong></p><p>Let’s create a new <em>App View</em> by clicking on the &quot;+&quot; icon at the top left of the sidebar. Name the view &quot;Emails&quot;.</p><p><strong>Note</strong>: You can rename any app view by opening the dropdown menu on hover over a view.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GdDo1ghP8mTmWSvtSkdCLw.gif" /><figcaption>Create a new app view</figcaption></figure><p><strong>Make sure the column headers of the new &quot;Emails&quot; app view match the column headers of those data objects that you’d like to insert</strong> <strong>into the view. </strong>In this example, we’d like to import all names and titles, and therefore create a column with the title &quot;Name&quot; and one with the title &quot;Title&quot; in our Hunter app.</p><p>Back in your original LinkedIn lead generation app, go ahead and add an additional column to specify which of your generated leads qualify. Then, create a new column to manage your data (f.ex. &quot;Send to Emails&quot;). From this column, you&#39;ll automatically send <strong>the names and titles of</strong> <strong>all your qualified leads </strong>to the new &quot;Emails&quot; app view you’ve just created:</p><pre>E9=IF(D9=&quot;yes&quot;,INSERT(A$8:B$8,A9:B9,&#39;Emails&#39;!B$1:C$1))</pre><p><strong>Note</strong>: The INSERT()formula only sends those data objects from one table to another for which the column headers are identical (in this example, only names are sent to the &quot;Emails&quot; app view).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*HO-A22_SEUKISWgvQT9p-Q.gif" /><figcaption>Insert data from another app view</figcaption></figure><p>In the &quot;Emails&quot; view, add the organization’s domain (<strong>not URL!</strong>) in column A.</p><p>Since we need <strong>first and last name to find your prospects’ email address</strong>, let’s filter those out into two separate columns using the following formula in <strong>D2 (first name)</strong>:</p><pre>D2=IF(B2&lt;&gt;&quot;&quot;,LEFT(B2,FIND(&quot; &quot;,B2)-1),&quot;&quot;)</pre><p>And the one below in <strong>E2 (last name)</strong>:</p><pre>E2=IF(B2&lt;&gt;&quot;&quot;,RIGHT(B2,LEN(B2)-SEARCH(&quot; &quot;,B2)),&quot;&quot;)</pre><p>To get the first and last names filtered out for <em>all</em> your search results, simply copy-paste the formulas from <strong>D2 and E2</strong> and drag down.</p><p>Repeat <strong>Step 2.1.</strong> above to find the email address of your qualified leads:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YCkz1riFiS7aD3x4Ssuswg.gif" /><figcaption>Get the email address of your qualified leads</figcaption></figure><h4><strong>Can’t get enough of automation?</strong></h4><p>Now that you got plenty of new email addresses, it’s time to target! You can do this in dashdash as well! 💪 <strong>Connect to one of our email integrations</strong> such as Gmail, <a href="https://app.dashdash.com/dashboard/integrations/sendgrid">SendGrid</a>, and <a href="https://app.dashdash.com/dashboard/integrations/email">email by dashdash</a> to send out targeted emails, or simply subscribe the new leads to your <a href="https://app.dashdash.com/dashboard/integrations/mailchimp">Mailchimp</a> list!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/500/1*C522RL9xRQjtpXQ4ZjxnXg.gif" /></figure><p>You can also <strong>connect your CRM to dashdash </strong>and automatically add your new leads to your CRM! We currently integrate with <a href="https://app.dashdash.com/dashboard/integrations/hubspot">HubSpot</a>, <a href="https://app.dashdash.com/dashboard/integrations/pipedrive">Pipedrive</a>, and <a href="https://app.dashdash.com/dashboard/integrations/zoho_crm">Zoho</a> — and we&#39;ll add more soon! Learn how this works with HubSpot <a href="https://medium.com/dashdash/automate-your-hubspot-crm-from-within-a-spreadsheet-72644e20a905">here</a>.</p><p>Happy targeting! 🚀</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/200/1*jC7S-QWeXWGJAGWqxDmeUQ.gif" /></figure><p><em>We hope you enjoyed this how-to guide. For more, check out </em><a href="https://forum.dashdash.com/"><em>our forum</em></a><em>, create your own guide and </em><a href="https://forum.dashdash.com/c/show-and-tell"><em>share it with the community</em></a><em>, or </em><a href="/service/mailto:nadja@dashdash.com"><em>let us know</em></a><em> which use case you’d like to see featured next! ✌️</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=20c626bbb843" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rows/get-any-email-address-in-a-few-seconds-20c626bbb843">Get Any Email Address in a Few Seconds</a> was originally published in <a href="https://medium.com/rows">Rows</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Generate Leads Through LinkedIn in 3 Simple Steps]]></title>
            <link>https://medium.com/rows/generate-leads-through-linkedin-in-3-simple-steps-7281abfc6e9d?source=rss----503b89cb1052---4</link>
            <guid isPermaLink="false">https://medium.com/p/7281abfc6e9d</guid>
            <category><![CDATA[linkedin]]></category>
            <category><![CDATA[spreadsheets]]></category>
            <category><![CDATA[linkedin-automation]]></category>
            <category><![CDATA[lead-generation]]></category>
            <category><![CDATA[how-to]]></category>
            <dc:creator><![CDATA[Nadja Beneš]]></dc:creator>
            <pubDate>Tue, 09 Apr 2019 15:07:55 GMT</pubDate>
            <atom:updated>2019-08-20T09:51:07.099Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YJoi1VIzR9qtAvNZf5s2-w.png" /></figure><p>Finding<strong> high quality leads </strong>is tough! In the hope of getting through to the right decision makers to sell your new cool product to, you find yourself spending hours browsing LinkedIn.🕵️‍♀️<br>You’re also already using <em>LinkedIn Sales Navigator </em>to refine the LinkedIn database into your ideal target list, however still need to view the profiles of your prospects <strong>one by one</strong>. What a manual process!</p><h3>Automate your prospecting efforts in a spreadsheet</h3><p>Getting results on LinkedIn doesn’t have to be a time-consuming endeavor. With dashdash, you can <strong>leverage online services like <em>Google Custom Search </em>to create lists of prospects </strong>based on their function or job title in 3 simple steps! 🙌 Here’s how:</p><h4>Step 1: Connect to the Google Search integration 🔗</h4><p>To start using Google Search in dashdash, you first need to connect it to your dashdash account. Head to the <a href="https://app.dashdash.com/dashboard/integrations"><em>Integrations Marketplace</em></a><em>, </em>find the <a href="https://app.dashdash.com/dashboard/integrations/google_custom_search_site_restricted"><em>Google Search — Top Sites </em>integration</a>, and hit connect!</p><p>If you haven’t already, add a payment method to top up your dashdash Wallet. The prices of each function (which make a request to the Google Custom Search API) are documented on the <a href="https://app.dashdash.com/dashboard/integrations/google_custom_search_site_restricted">integration page</a>. You’ll only pay for the data/API calls you use.</p><p>Since Google Custom Search is part of our <a href="https://forum.dashdash.com/t/instant-integrations-in-dashdash-q-a/407"><em>Instant Integrations</em></a>, you can access their data <strong>using only your dashdash account</strong> — no need to go through the hassle of getting your own API key via the Google Cloud Platform. However, if you want to use your own API key, you can still do so. Simply click on <em>Use your own keys</em><strong><em> </em></strong>on the <a href="https://app.dashdash.com/dashboard/integrations/google_custom_search_site_restricted">integration page</a><strong><em>.</em></strong></p><h4>Step 2: Find people on LinkedIn 🔎</h4><p>Let’s create your custom LinkedIn lead generation app in dashdash! With the <em>Google Custom Search — Site Restricted </em>integration, you can search LinkedIn profiles by using the following functions:</p><ul><li>SEARCH_LINKEDIN_COMPANY_GOOGLE<br>This function searches for company profiles on LinkedIn using Google. Data includes link to profile, snippet, and more.</li><li>SEARCH_LINKEDIN_PERSON_GOOGLE<br>This function searches for personal profiles on LinkedIn using Google. Data includes job title, company, link to profile, snippet, and more.</li></ul><p><em>Create an app </em>in dashdash. Set up two columns for a) <strong>the function </strong>and b) <strong>the organization </strong>you’re looking for. In this example, we&#39;ve also added a column for the organization&#39;s URL. Use the next column to make your request:</p><pre>A2 = Marketing<br>B2 = Spotify<br>D2 = SEARCH_LINKEDIN_PERSON_GOOGLE(A2&amp;&quot; &quot;&amp;B2)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1skUvuRy8fcqRsplaAkntg.png" /><figcaption>Find people on LinkedIn based on function and organization</figcaption></figure><p>You will obtain {data}in <strong>D2</strong> — an object that contains <strong>data on the top 10 search results from your request</strong>. If you click on the window toggle next to {data}, you can crawl the information directly from within the data explorer and parse any data objects you need. Simply click <em>copy </em>next to the data object, and paste the copied formula into the desired cell.</p><p>Here, we’d like to parse</p><ul><li>Full Name,</li><li>Job Title (as displayed on LinkedIn),</li><li>LinkedIn Profile Link</li></ul><p>for each of the 10 search results.</p><h4>Step 3: Get their Name, Title, and Profile Link 💁🏼‍♀️💁🏽‍♂️</h4><p><strong>3.1. Get the Full Name</strong></p><p>Let’s parse the <strong>full name of all 10 results</strong>:</p><pre>E2=PARSE(D2,&quot;[&#39;items&#39;][*].[&#39;pagemap&#39;].[&#39;hcard&#39;][0].[&#39;fn&#39;]&quot;)</pre><p>In <strong>E2</strong>, you will also obtain {data}— a data object that contains the <strong>full name of all your 10 search results.</strong></p><p>To populate those full names in a table, we’ll use the INSERT_DATA()function. This function <strong>matches data objects </strong>(here: <strong>E2</strong>) <strong>with table headers </strong>(here: <strong>A8</strong>) and automatically populates a table with your desired data objects:</p><pre>A7=INSERT_DATA(E2,A8)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*_-WVtW7uElAcg9yrrBiXzg.gif" /><figcaption>Get all names</figcaption></figure><p>If you’d like to <strong>overwrite the names each time you execute a new profile</strong> search instead of creating a data log, simply replace the INSERT_DATA function in cell A7 with OVERWRITE_DATA. This will insert new names below the output header each time you execute a new search.</p><p><strong><em>Caution</em></strong>: With every new search, you would lose the data of your previous search.</p><p><strong>3.2. Get the Job Title</strong></p><p>Now, parse the <strong>job title of all 10 results</strong>:</p><pre>F2=PARSE(D2,&quot;[&#39;items&#39;][*].[&#39;pagemap&#39;].[&#39;hcard&#39;][0].[&#39;title&#39;]&quot;)</pre><p>{data}in <strong>F2 </strong>contains the <strong>job title of all your 10 search results. </strong>Populate those job titles into the “Title” column of your data table:</p><pre>B7=INSERT_DATA(F2,B8)</pre><p><strong>3.3 Get the LinkedIn Profile Link</strong></p><p>Lastly, let’s also get the <strong>LinkedIn profile link for all 10 results</strong>:</p><pre>G2=PARSE(D2,&quot;[&#39;items&#39;][*].[&#39;link&#39;]&quot;)</pre><p>{data}in <strong>G2 </strong>contains the <strong>profile links of all your 10 search results. </strong>Populate those links in the “Profile Link” column of your data table:</p><pre>C7=INSERT_DATA(G2,C8)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Eqx4Ss6wgGNT94y28nd-IA.gif" /><figcaption>Get all job titles and LinkedIn profile links</figcaption></figure><p>Now try to change either <strong>Function</strong> — this can also be a role like &quot;CEO&quot; or &quot;VP of Sales&quot;— or <strong>Organization</strong> of your query. New search results will be appended to your table automatically.</p><p>Again, feel free to use theOVERWRITE_DATA function in A7:C7 instead if you prefer <strong>to update the table content </strong>each time you execute a new profile search.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/320/1*iv-xTzeURldvO_6PC2Dmaw.gif" /></figure><p>Bravo! 👏👏 You just generated your custom lead generation tool in a spreadsheet!</p><p>Ready to <strong>enrich your new leads with their email address</strong>? Connect to our <a href="https://app.dashdash.com/dashboard/integrations/hunter">Hunter.io integration</a> and get email addresses of any professional in a few seconds! Learn how <a href="https://medium.com/dashdash/get-any-email-address-in-a-few-seconds-20c626bbb843">here</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/200/1*jC7S-QWeXWGJAGWqxDmeUQ.gif" /></figure><p><em>We hope you enjoyed this how-to guide. For more, check out </em><a href="https://forum.dashdash.com/"><em>our forum</em></a><em>, create your own guide and </em><a href="https://forum.dashdash.com/c/show-and-tell"><em>share it with the community</em></a><em>, or </em><a href="/service/mailto:nadja@dashdash.com"><em>let us know</em></a><em> which use case you’d like to see featured next! </em>✌</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7281abfc6e9d" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rows/generate-leads-through-linkedin-in-3-simple-steps-7281abfc6e9d">Generate Leads Through LinkedIn in 3 Simple Steps</a> was originally published in <a href="https://medium.com/rows">Rows</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>