Question

What data do you check every day—and do you have it all combined in a single dashboard?

There’s data about everything today, some of it crucial to your business (revenue and signups, perhaps) and others less important (total social followers, say). When you first start your work day, which data do you find most important to check? Do you open a handful of apps to check each data point, or have you pulled the important data together into a dashboard? Or perhaps do you have a more unique way of getting updated about important stats via Slack, an automated email, or something else?

Mentioned
#Data #Analytics #Gmail #Slack #Zapier #Databricks #Looker #Graphy #Shopify #Tableau
Share
-Lee-'s avatar
17d

We use Grow to pull in data from all our sources and mash it into some dashboards. From Grow depending on the user they can check the dashboard, get a report emailed or have a metric posted to Slack. For most of the data we check the dashboard but email / Slack can be a handy way to act as a trigger at a set time each month / week.

Has completely changed our business.

4 points
maguay's avatar
@maguay (replying to @-Lee- )
17d

Grow dashboards look amazing. Were they difficult to setup, or for the most part does Grow just use default integrations where you connect it to an app and let it do its thing? Looks easier to use than Looker/Amplitude/et al from its landing page, at least.

1 point
-Lee-'s avatar
@-Lee- (replying to @maguay )
17d

Extremely easy to setup, you can have it running with default dashboards in 30mins. Setting up an integration just requires you to login to the app and approve Grow. For most of the integrations you can one click add some default metrics.

The dashboards are powerful but simple, you can start by using their transformations to modify your data, simply from their GUI. When you want to do more you can insert SQL or mix SQL with their transforms.

1 point
maguay's avatar
@maguay (replying to @-Lee- )
14d

That's awesome to hear—sounds simpler than setting up Looker at least.

1 point
optemization's avatar
@optemization (replying to @-Lee- )
12d

noice. trying to figure out if i can embed Grow components into Notion...

1 point
-Lee-'s avatar
@-Lee- (replying to @optemization )
12d

It does support iframe so it should technically be possible.

2 points
maguay's avatar
@maguay (replying to @optemization )
12d

Now that would be cool, having an automatically updated dashboard inside Notion!

1 point
bigal123's avatar
17d

Definitely no dashboard given the variety of stats I check. I try to funnel all notifications into Gmail so I can triage what other apps I need to check. Instead of checking Intercom, Slack, Coda, I just look at the notifications to see if I need to provide input. Trying to do email only twice a day (thanks 4-Hour Workweek).

3 points
maguay's avatar
@maguay (replying to @bigal123 )
17d

Email's a great fit for that. Do you rely on the apps' built-in email notifications, or do you use 3rd party integrations to build custom notification emails?

1 point
bigal123's avatar
@bigal123 (replying to @maguay )
17d

Built-in notifications. Haven't had a need to use a connector for custom notifications.

2 points
nirajshah's avatar

I use Slack for daily dashboard-type data Google Analytics, Jira, Signups, Finance, QuickBooks, System Errors, Usage, etc. Homegrown aggregated data into slack channels.

2 points
maguay's avatar
@maguay (replying to @nirajshah )
17d

Very cool. Are those each custom integrations into Slack you built yourself, or are you using something like Zapier to pull the data from the apps and push it into Slack?

1 point
rpatools's avatar
13d

Definitely check out Jetadmin.io first then either retool.com or internal.io for an “all-in-one” dashboard concept!

2 points
maguay's avatar
@maguay (replying to @rpatools )
13d

Which one do you use for your site?

1 point
rpatools's avatar
@rpatools (replying to @maguay )
12d

JetAdmin.io

1 point
bostjanpisler's avatar

Anyone using Redash? We're looking to use it to visualize data like signups, sales, usage, and understand how advertising and SEO affected app adoption either using Redash or another tool if a more suited one exits? Tnx

1 point
maguay's avatar
@maguay (replying to @bostjanpisler )
14d

I haven't used Redash—though at a glance it looks similar to Looker, with essentially easier ways to visualize SQL queries and combine data from multiple apps.

Interesting to see that Databricks acquired Redash in June—I would imagine the products will end up getting combined over time.

1 point
reflectivedata's avatar
11d

We are using Google Data Studio for general reporting/dashboarding needs but since it doesn't have a service-account-based connection to BigQuery (which we need in certain cases) we are using Redash for that purpose and absolutely love the experience.

It isn't as advanced or flexible as many other tools but does its job really well. Definitely worth giving it a try!

1 point
jeff_graphy's avatar

Graphy! But I was always going to say that wasn't I! :)

In all seriousness, Graphy (https://www.graphyapp.com) hopes to be the go to product to solve this problem. We aim to make it easy to connect all your SaaS tools in a few clicks and build the beautiful, flexible, and yet powerful dashboards and live data documents imaginable, all without a single line of SQL. The best part is that we've built powerful collaboration features to allow you to work with your team in real-time or share you data with contracts, investors, your board, or the whole world.

If you're interested in trying it out, let me know!

1 point
lightyaer's avatar

I think I'm a bit old school, I use RSS from various sites to curate my stuff..

1 point
maguay's avatar
@maguay (replying to @lightyaer )
13d

Oh neat! Curious, which apps do you use that have RSS feeds to check in on data?

1 point
mitchellreynolds's avatar

For our eCommerce store, we have Shopify which has some decent build-in reporting. For a bit more sophisticated reporting, I built a couple Tableau dashboards that update daily (automatically) and monthly (some data is from other teams and less automated).
For weekly marketing promotions, I generate a csv file with a Python / SQL script.

1 point
maguay's avatar
@maguay (replying to @mitchellreynolds )
13d

That's great to hear. One huge benefit of all-in-one eCommerce platforms is unified reporting. That was one thing I'd hoped Ghost would bring to blogging, as their original Kickstarter envisioned, but that has yet to come.

1 point
How do you automate follow-up emails?

I've got a funny use-case for a client I'm volunteering on. They're dealing with some legacy folks who work in Excel. Every week they send out an email to a series of people with an Excel sheet at...

The community for power users.