>
home Funnels Building a Dashboard for an Online Funnel with Airtable

Building a Dashboard for an Online Funnel with Airtable

51 / 100



Take our free Airtable Crash Course!
https://garethpronovost.com/airtable-crash-course

Getting Stuck? See how we can help!
https://garethpronovost.com

Get our Airtable Field Type download!
https://garethpronovost.ck.page/field-types

_________________________________________

Table of Contents:

00:00 – Intro
00:44 – Setting the Stage
01:13 – Explaining the Structure
03:26 – The “Opt-in” Table
04:22 – The “Sales” Table
06:05 – Automating this Dataflow
07:15 – Alert Dashboard
08:20 – Opt-in Dashboard
08:58 – Sales Dashboard
09:39 – Finance Dashboard
11:41 – Get More Help

_________________________________________

Software Resources (may contain affiliate links):

Airtable – https://airtable.com/invite/r/v0eI3ASY

_________________________________________

In my previous life as a financial analyst, I was confused by the inefficient systems I was required to use. In one role, I received Excel files with tens of thousands of records from three different vendors. Each of those files was completely different, but I was expected to combine all of that data into one file and generate a report that senior leaders could then use to make decisions about future growth. It was an enormous waste of time and brain power. I often found myself wondering why there wasn’t a streamlined system built to serve this function.

This problem is similar to the problems faced by online entrepreneurs. There are lots of tools that go into building an online funnel. For example, let’s imagine a free email course. General steps are as follows:

1. The entrepreneur builds a landing page to capture email addresses.
2. Once someone signs up, emails are delivered on a predetermined schedule.
3. Deliver an overwhelming amount of value over several emails.
4. Extend an offer to help further – usually through an online service of sorts.

The model has many variations and different software is used in each step along the way. For example, the opt-in page (step #1) might be built in Mailchimp, Active Campaign, Convert Kit, or any other email service provider – or maybe the submission is captured by a standard form software that adds the new email to the funnel with automation. Then, the entrepreneur uses another software to process their sales (step #4) – this might be Stripe, Paypal, or any other online payment processing system. The struggle is in getting the sales data relating to the opt-in data, since the software used for each step is completely different. Or, if you are using the same software for both steps, the dashboards available to you are likely not adequate to help you track the metrics you want to see.

This is the perfect example of the value of having a ‘Single Source of Truth’ – aka: Airtable! In this video, I walk through how to capture this information from the different sources and combine them together into one Airtable database. Most importantly, I detail a dashboard for instant analysis. This way the entrepreneur can know the important KPIs at a glance and in real time.

There is a lot of great software out there to help you build a business, but without having all of that data reporting back to one place, you’re no better off than I was in my financial analyst role… you’re doomed to spend countless hours every day/week/month just collecting data and trying to put it into some coherent report so that you can make proper decisions. Isn’t it wiser to build your system once and set it to run on auto-pilot?

_________________________________________

Take our free Airtable Crash Course!
https://garethpronovost.com/airtable-crash-course

Getting Stuck? See how we can help!
https://garethpronovost.com

Get our Airtable Field Type download!
https://garethpronovost.ck.page/field-types

#AutomateYourLife #GarethPronovost #Airtable

Source