Introduction

SeekWell's Stories let you write narratives about your data using SQL. Think of it as an always up-to-date Wall Street Journal article about your company automatically refreshed and delivered to your inbox daily. For example, using this SQL:

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a95997c7-6d92-405e-9ff7-bf54c542cf48/Untitled.png

You can write a story like this:

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/8e0775ee-073c-4b6f-8bfc-5f023d84902a/stories1.gif

Hitting = allows you to access all your SQL results and add them to the Story. The output is rendered below the editor as you type. You can format the Story (e.g. H1, H2, bold, etc.) and add HTML and JavaScript snippets.

Stories are great for short regular updates (e.g. daily metrics) or alerts (e.g. a canceled subscription). Stories can be shared via email, Slack, or in SeekWell Dashboards. Get started here.

Demo

Please pardon the "SQL query" phrase, that's what I get for going off script

Please pardon the "SQL query" phrase, that's what I get for going off script

Adding data (single data points)

Let's break this down a bit. Once you hit = you'll see all saved query results with exactly one row (Note: to save a result, simply title the block). Press return or click to select a data point and it will be added into the story.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/035ce4a3-df0b-47a0-ba8e-cd24d27568f9/Untitled.png

Adding Formulas and Javascript

You can do math (including references to data points) within the Story using double curly braces, {{2 + 2}} or logic (1 < 2) ? 'down' : 'up'

This will render .30239, see "Formatting" below to clean that up

This will render .30239, see "Formatting" below to clean that up