Build a Fishbowl Sales Dashboard with AI (Live Orders, Backorders & Top Customers)
Watch a Fishbowl sales dashboard get built live by asking ILC MCP — live orders, backorders and top customers on one screen, no manual report building.
Read the full write-up, with the steps and screenshots →
Transcript
Auto-generated from the video. Timestamps jump to that moment in the clip.
- 0:07let's make a Salesforce dashboard so I've got my TV
- 0:13quote -unquote here on the right
- 0:16and I've got Claude here on the left and we're gonna go through the typical
- 0:19process of what it looks like to connect a TV with fishbowl
- 0:25and display some data
- 0:26and we're gonna see how that works
- 0:28looks. First, I need to tell the MCP, please enable
- 0:34TV code Y9D5T8.
- 0:41And when I do that,
- 0:42what will happen is the platform will know that a TV is ready to receive a
- 0:48code. It looks
- 0:48like it updated the code. Oh, I think it
- 0:53timed out. I let this open.
- 0:56UNA HN4.
- 1:04So we got that.
- 1:05Let's call it sales floor.
- 1:08Put it in Seattle, Washington,
- 1:14USA location.
- 1:21Okay, perfect.
- 1:23Let's do.
- 1:24So, let's put our first metric, let's call it the how many, first
- 1:30metric, how many sales
- 1:36orders we took today.
- 1:44Okay, perfect, it's given us a number, it's updated that, we've got the location, got
- 1:49some
- 1:49weather in there, looks great.
- 1:52add another one add another metric for sales
- 1:58amount next to it I'll fix that
- 2:02okay perfect
- 2:10looks good now let's add in some count other counts
- 2:15let's do add
- 2:20metric for borders still open and what are
- 2:25backordered.
- 2:44Okay, we've added that.
- 2:45Now let's add the...
- 2:48Let's add some charts.
- 2:51Let's add a bar chart for the top
- 2:56five customers by sales from the last 30 days.
- 3:06Okay, perfect.
- 3:07Awesome.
- 3:08We've got a chart.
- 3:09Looks great.
- 3:11Now let's add another one.
- 3:13Let's do a salesperson leaderboard.
- 3:16Add a chart of sales person's
- 3:22Leaderboard by sales dollars for the last 30 days
- 3:38There we go all the data came in perfect now
- 3:42I think we have got one more feature that I want to share
- 3:44it which is the notification bar so let's add a notification
- 3:49message this
- 3:55week product XYZ is on promo
- 4:05perfect right and you can kind of see how we can create multiple
- 4:10dashboards
- 4:12In other demos, we'll be showing you
- 4:14how to create dashboards that have multiple components to it.
- 4:19You can change the colors, you can change the messaging,
- 4:22you can add the location of the dashboard
- 4:23so that we can add things like the weather.
- 4:27And yeah, so I think this is pretty cool.
- 4:29If you have any questions, let us know.
- 4:31We'll be happy to talk to you about how you can get this
- 4:33connected to your official platform.
- 4:35Thanks, have a good one.
- 4:47You