Latest / Inside Commerce: Ecommerce Strategy, CX and Technology Podcast / EP196: Using Airtable To Improve Operational Efficiency For Ecommerce, with Nolo Apps Co-Founder Oliver Rhodes
Transcript
- 0:02Thanks for tuning into the Re Platform podcast, sponsored by
- 0:04Crown Peak and Elastic Path and hosted by me, James Gerd.
- 0:07Warm welcome. It's your first time we put a
- 0:10load of effort in to bring you really interesting guests and
- 0:12great content for free. Help us keep it that way.
- 0:16Let other people in your network know about us so we get more
- 0:18listeners, share our posts on LinkedIn and Twitter, and the
- 0:21best thing you can do is rate. I'll show an Apple spots by
- 0:24YouTube or wherever else you might be listening if you
- 0:26haven't already. So thanks and let me introduce
- 0:28our latest episode and then hand over to our guests.
- 0:31So our topics around how ecommerce businesses can prove
- 0:34operational flexibility. Air table, Air Tables had a lot
- 0:39of press recently and Oliver Rhodes is our guest who's a
- 0:42cofounder of another apps who's doing a lot of interesting work
- 0:45with the platforms. Ecom business has improved
- 0:47productivity in the tech stack and we're going to find out how
- 0:49and why today. So Oliver, welcome to the
- 0:52podcast. How you doing Sir?
- 0:55Yeah, good. Thank you.
- 0:56Thanks for having me on. I'm really looking forward to
- 0:59getting into this. Yeah, I'm as well because when
- 1:03we first spoke, I openly said I don't know enough about Air
- 1:06Table. I'm trying to learn it where it
- 1:08fits in the text stack. So let's start with, do you want
- 1:11to give people a bit of your background?
- 1:12Like what are you doing and why are you doing this?
- 1:17Yeah. So if anyone that doesn't know
- 1:19me, I was one of the founding team at People Box or Warehouse
- 1:23Software that was acquired by Descartes in 2020.
- 1:27So I did that for 10 years designing tech stacks around
- 1:31warehouse management systems. And then I worked for one year
- 1:34in product lifecycle management at a startup and learn so much
- 1:39about everything that happens around creating products and
- 1:43bringing them to market, which is totally new to me because.
- 1:47Warehouse Systems is customer experience focused, but this was
- 1:50suddenly like very product and merchandising focused.
- 1:54So that was really interesting. I feel that kind of rounded me
- 1:56off a little bit. And then, yeah, for the last
- 2:00year and a half and in combination with Victoria
- 2:04Graves, who's my business partner, we've been doing a
- 2:08hybrid of tech advisory. So helping people on their plan,
- 2:13their tech stack and make decisions on different tools.
- 2:16And using air table to build solutions for them.
- 2:20So I guess that's the the short potted history of me.
- 2:24Yeah it's it's really interesting and I think this
- 2:27episode is going to add a lot of value to people because one
- 2:30thing we want to do is showcase the emerging ways that
- 2:33technology is being used and how tech stacks are are becoming
- 2:35more and more flexible. So let's let's do the, the
- 2:38strategic piece before we get into like the practice limit.
- 2:41So you do a lot obviously even a lot of experience and background
- 2:45in that kind of operation on that back office side.
- 2:47So what are the common issues you see in business regards like
- 2:50systems connectivity and interoperability?
- 2:53Like what mistakes people make, what constraints hold businesses
- 2:56back? And I think the so just to
- 3:04unwind on those, so give it, give it.
- 3:06He's earning 3 bits for me. That was the first bit.
- 3:10I think that number one is like what are the most, what are the
- 3:14key operational issues that you see businesses facing due to
- 3:17like systems inefficiency? Yeah.
- 3:21So I think the root cause of a lot of the pain in businesses is
- 3:28that they are looking at their tech stack and systems
- 3:32integration in a in an outdated way, which is they think about.
- 3:39How Shopify connects to their warehouse or how their ecommerce
- 3:43platform connects to their ERP and how their ecommerce platform
- 3:48connects to the product information management system.
- 3:51And they'll have some kind of integration platform, ipass
- 3:54that's kind of joining all these tools together.
- 3:57And like when you visualize a tech stack, I'm sure this is
- 3:59what everybody's got in their head and what I learned from my
- 4:04time at Supply Compass, the PLM. Was how many Google Sheets and
- 4:08Excel files and PDFs are actually running inside
- 4:11companies? And what we've found, and I
- 4:16think this is one of the biggest sources of operational
- 4:19inefficiency, is that everything else that isn't those core
- 4:24systems is the doc stack of everything else.
- 4:27Google Sheets and Excel files and PDFs and I would throw into
- 4:32that bucket like Slack and Teams and e-mail.
- 4:35Basically any technology and systems that you're using,
- 4:38because those two are being looked at completely separately.
- 4:41We're not actually thinking about the interoperability of
- 4:44those workflows. And many, many functional
- 4:48workflows within an e-commerce business involve data flowing
- 4:52out of one of those tech stack systems and into a dock stack
- 4:58system like a, you know, a click up, a sauna or a Monday or a
- 5:01Trello. And because those two systems
- 5:04aren't connected, they end up duplicating data between the
- 5:08tech stack and the doc stack. So all of the product data might
- 5:12be in your ERP, but it won't be in monday.com.
- 5:15So when we need to plan a product launch, we have to go
- 5:19into Monday and type in all the products and Add all the rows.
- 5:21Is this kind of making sense, James?
- 5:23Do you get what I'm getting at this?
- 5:25You see it with merchants, oh God constantly the the disparate
- 5:30systems aren't connected through any like true workflow and
- 5:34therefore there are manual processes to get to get data
- 5:38pushed from one to the other or there as you say spread.
- 5:41I mean, I I work with a huge business which at the time, and
- 5:45this is about seven years ago was was a billion plus business
- 5:50and their entire content management update into the front
- 5:54end was done from an excel sheet with macros pushing and
- 5:59generating HTML into an SFTP and it's bonkers.
- 6:04So yeah, it resonates massively. And there's like, yeah, there's
- 6:10more specific use cases around like those workflows, but I
- 6:14think my, my bigger, I guess the bigger picture I want people to
- 6:19lead into this with. To not think about this is like
- 6:22replacing any one one of those systems in the text app which
- 6:27our table can do. I'd look at it from the kind of
- 6:31think of the three buckets of planning data and communication
- 6:35in your business. So how you plan and where you
- 6:38plan the data in terms of the information that people need and
- 6:43then communication and if you're doing, if your data is in your
- 6:47ERP and Google Sheets? And then you're doing your
- 6:51planning in a sauna or click up on Monday, and then you're doing
- 6:54your communication on teams or Slack or e-mail.
- 6:58You're never bringing all of those three things together.
- 7:01And that seriously hampers your operational efficiency often in
- 7:05businesses, right at the time when they're trying to scale.
- 7:07So you start to add more people and you bring them in and they
- 7:11don't have access to the right data.
- 7:13Well, that means they have to ask someone for everything.
- 7:16You end up spending all your time in alignment meetings like
- 7:19meetings after meetings after meetings to try and figure out
- 7:22what's going on on a project rather than just being able to
- 7:24find out. And then you know Slack is 999
- 7:28for basically every process in your business that doesn't have
- 7:31a process. Every functional workflow that's
- 7:34broken is a Slack channel, and it's an urgent message.
- 7:37And I think we can all agree with we're sick to the teeth of
- 7:41that kind of information overload.
- 7:44That happens there when we get told about something three times
- 7:47across three different channels, but we actually like, we didn't
- 7:50want to do anything about it. We've been interrupted and then
- 7:53we forget about it, you know, and then we move on.
- 7:56Yeah, I think that's really nice concept.
- 7:58So with that in mind, where does air table fit in?
- 8:02Like, let's help people understand it because some
- 8:04people would have come across it, some might have played
- 8:06around with it, but not many would have ever used it.
- 8:09So what is air table and how is it relevant to what we're
- 8:12talking about? Yeah so there there.
- 8:18A good starting point is to, it is like why aren't more people
- 8:21aware of it and using it. And I think the the challenge
- 8:27with their table is it's been a like a sign up online tool with
- 8:30lots of like kind of developers and low code enthusiasts kind of
- 8:35using it And then when someone in a kind of management role
- 8:39who's looking for like a planning tool.
- 8:42Compares it to a click up a sauna or monday.com.
- 8:46The learning curve's much higher.
- 8:48It takes a bit more work to get it going.
- 8:50So they kind of look at it and go like, oh, what the hell is
- 8:52this? It's all a bit, it's all quite
- 8:54confusing. There's more to configure and
- 8:56set up and that that is true. It's definitely got a bigger
- 8:59learning curve than some of those tools.
- 9:01Certainly like Trello is just so easy.
- 9:03Everyone loves flying around in Trello, but it it does kind of
- 9:07hit a limitation there at some point.
- 9:10And then air tables focused from a services and delivery
- 9:13perspective has been on the, the big, the big companies, you know
- 9:18like VF Corporation, you know who are in Timberland and many
- 9:22other brands, they're a huge air table user, outdoor voices, you
- 9:27know they were a bit of a DCC darling.
- 9:28They were one of the big air table references.
- 9:31And so it's used by 90% of the Fortune 500.
- 9:34But ecommerce companies haven't been the focus of air table
- 9:37sales efforts. And I feel like it, it does
- 9:40require particularly what we're doing is allowing now bridging
- 9:45that gap between it being easy to use like a sauna or Monday
- 9:50and then you've got you know an enterprise team that isn't
- 9:53really interested in these e-commerce businesses.
- 9:55We're kind of helping people kind of cross that chasm and
- 9:59realize the benefits so they can on board and get using it much
- 10:02faster. Attract your complete product
- 10:07discovery growth engine. Create relevant shopping
- 10:10experiences that convert into sales and grow online revenue
- 10:13with personalized search, merchandising and recommendation
- 10:17solutions powered by AI. Find out more at attract.com and
- 10:23it's it's definitely not just you talking about it.
- 10:27I know obviously it's it you you're basing your your service
- 10:30around bringing productivity gains by using their tape
- 10:34specifically. I've seen apart from specialists
- 10:36like yeah, I've seen more people in the media referencing.
- 10:40I've seen, I've seen other posts on LinkedIn reference more
- 10:42recently. I don't know whether this is
- 10:44just because I'm more aware of it now.
- 10:45I'm noticing, but are you seeing that, that more businesses are
- 10:49starting to take this seriously and build it into their text?
- 10:55I think it, I think it's been. I think that's a bit of an echo
- 11:01chamber thing to some degree. I'm of course I'm seeing that
- 11:08more businesses are taking it seriously and using it because
- 11:11we're taking it into businesses. In terms of the the platform,
- 11:18they a big improvement that's occurred in the last year and a
- 11:23half that we've been implementing.
- 11:25It is previously my air table has.
- 11:28There's two parts to it. There's a kind of really good
- 11:31understanding is there's a base view which looks like.
- 11:36Kind of an Excel file on steroids and that is your
- 11:41relational database. That is kind of the core of our
- 11:44table. So starting point and relational
- 11:47database works a little bit like a vlookup if you're an Excel Wiz
- 11:50and you don't know that term relational database.
- 11:53So our table, the base setup side of it, is a lot like what
- 11:59Microsoft Access would have been like for anyone that's been
- 12:02around long enough to remember Microsoft Access.
- 12:04It's a lot like that or I think I can't remember there was an
- 12:07Apple product, do you remember the name of it?
- 12:09File Maker, as it File Maker was also a little bit like this like
- 12:13allowed you to build your own tools, was very visual for
- 12:16building stuff and that's what the base view is like.
- 12:20But then additive have been on this mission in the last year
- 12:24and a half to move towards having this base view but also a
- 12:30interface. View which is like you know an
- 12:34attractive user interface. And what that has enabled us to
- 12:38do is build these interfaces for the users on top of the base.
- 12:42Which means that you can on board people to air table
- 12:45without them having to go through that learning curve of
- 12:48understanding how to use a base and know everything about a base
- 12:52to be able to use it. And also, you know your thoughts
- 12:55around what if someone goes in and breaks something because
- 12:58they don't understand? You know what if they're working
- 13:00on the database? They could.
- 13:01Yeah, mess with the data. The interfaces allow us to have
- 13:05way more control over how people are using it.
- 13:08And I think that aspect of it is now making it a lot better is
- 13:13like as from a commercial proposition to really come in
- 13:16and take over some of the more business critical functional
- 13:19workflows. Yeah, that makes sense.
- 13:24And let's so let's let's add a bit of like tangible examples to
- 13:29this to help people. So one of the areas that your
- 13:32folks on the know though is build out custom apps for people
- 13:36to improve their their operational processes and one of
- 13:38the areas we discussed prior to the forecasters product
- 13:41lifecycle management. So what what are the issues that
- 13:45you've seen in other in the way that product lifecycle
- 13:48management is done. Let's start with that and then
- 13:50we can go to Where does a air table fit and what improvements
- 13:54can it make? Yeah.
- 13:57So I think the thing that resonates with almost everybody
- 14:01that I speak to about Air Table is that with the off the shelf
- 14:07SAS platforms, you're buying 100% of the features often when
- 14:12you needed 20%. So we know we're paying more
- 14:16than we needed to. We know the implementation is
- 14:19going to take longer than we needed to.
- 14:21Where we're being asked to commit to a platform, now we
- 14:24know it won't be easy to change and go to another platform.
- 14:27So we often have to buy technology ahead of where we
- 14:30are. And then we have that learning
- 14:32curve of a new SAS platform and we're tied to their future of
- 14:36all. If you go with the most
- 14:38established, it's probably a legacy code base and it's
- 14:41probably starting to creak. Or if you go with someone up and
- 14:44coming, they might be acquired and then the whole piece of
- 14:47software gets thrown in the bin. So I think everyone's.
- 14:50Everyone feels that pain of SAS system selection, and that's
- 14:56where I found, yeah. And I experienced that at Supply
- 15:00Compass. Like we built a PLM for fashion
- 15:03brands. We were the new kid on the block
- 15:06and then the business ran out of money and the whole product went
- 15:10in the bin. Like that can happen with like
- 15:13the new kid on the block to contrast that.
- 15:16To Centric PLM which is like the most established enterprise PLM.
- 15:21On the other side of that Centric is a really rigid
- 15:24enterprise software provider. It's very expensive, it takes a
- 15:27long time to implement and it's a siloed functional workflow
- 15:33tool that doesn't connect into like your Asano and your Monday
- 15:37and your click up type workflow. So I had that view from doing
- 15:43product lifecycle management and.
- 15:46Where we started with this was actually with two brands I
- 15:52started working with at the time, Hype, the street wear
- 15:55brand and Rickso who do. Yeah, like I said, like women
- 16:02women's dresses like relatively high end.
- 16:05Height was about 20 million at the time.
- 16:07Ricks are about £30 million business and they both needed
- 16:12some aspects of PLM. You know, post supply companies,
- 16:15but they didn't need a full PLM. And so that was like one of the
- 16:20use cases that we really started building with.
- 16:23But what I quickly realized was that all of these software
- 16:27categories are just, they're all made-up and they all create,
- 16:35they all create like this barrier to learning for people
- 16:37when they're trying to understand new tools.
- 16:40They can be helpful to some degree, but like ERP is an
- 16:42acronym. Just causes problems, just the
- 16:45same as PIM. Like if you say PIM to actually
- 16:4890% of people who have founded in e-commerce business, they're
- 16:53like their eyebrows go up and they're like, what are you
- 16:55talking about? What's a PIM like, just let me
- 16:57stop there for a second. And then what you find is you
- 17:00then have to explain the capabilities that make up a pin.
- 17:04And obviously it's a lot more nuance than that.
- 17:07So the start one of the starting points has been product data
- 17:11because I had so much experience of that.
- 17:14And also product data makes really good sense as a place to
- 17:20start your air table journey because once you've got your
- 17:23product data, any workflow that you do using product data is
- 17:29already there. Like go back to that example I
- 17:31gave of if you've got all your product data in your ERP and
- 17:35then you want to track like your go to market in a sauna, you
- 17:39have to copy all that information across, whereas if
- 17:41it's already in our table, it's already in there.
- 17:43Kind of makes sense. And then the other reason for
- 17:47starting there is most businesses do their product data
- 17:51on a Google Sheet. They allocate barcodes in a
- 17:55Google file or an Excel file, and the product doesn't really
- 17:59have anywhere to exist until it appears on shopper file.
- 18:02It goes into the ERP. And that's just not the way that
- 18:04businesses work. If they're developing their own
- 18:07products and bringing them to market, you need that.
- 18:11You're an inventory business. So inventory is important, but
- 18:14also product data is like the core of what you do.
- 18:18And yeah, Vic, my business partner is a data person.
- 18:22She really understands product data and how that should be
- 18:25structured. And so that's kind of formed,
- 18:28yeah, That's really formed the backbone of our practice to
- 18:31date. Yeah.
- 18:33So a question related to that because this is a bit I found
- 18:36really interesting because having worked with businesses
- 18:39where product data is a bit of a mess and there are limitations
- 18:42in ecommerce platforms in terms of of how extensively you can
- 18:47enrich and how you structure product data for different
- 18:50storefronts, for example for international and how
- 18:52challenging it can be working across multiple storefronts.
- 18:56But PIMS historically added a lot of value there where you can
- 18:59do all of your data structure in the PIM and just push it out via
- 19:03the. I'd love to know the context of
- 19:05Air Table because I guess some people listening might be
- 19:07thinking but can it handle like international versions?
- 19:09Like I've got translated versions of content or custom
- 19:13tagging and meta tags against my products to auto populate
- 19:16categories on the front end. So can you give us a feel for
- 19:19where, how air table compares and fits into that piece?
- 19:25Yes, the answer is yes it can. And then the challenge the off
- 19:31the shelf pins have is that. There's a like any like SAS
- 19:37platform, they're very resource intensive to get started like
- 19:42you need to either raise a load of money to get yourself going
- 19:48or if you're the big established player in the market, you've
- 19:52already raised loads of money. But possibly your software is
- 19:56now 56789 years old and. If any merchant, if we take
- 20:03Shopify as the example, any PIM is really trying to interface
- 20:10with that Shopify data structure.
- 20:13And as we all know, they just keep changing stuff.
- 20:17So I think very, I don't actually know if I'm sure there
- 20:22is a PIM that is totally focused on Shopify, but I'm sure this
- 20:27applies to almost every ecommerce platform.
- 20:30The, the way that those two work together is so key.
- 20:34But all of the pins seem to try and work with all different
- 20:37types of platforms and they just by default fall behind the
- 20:42latest tech like the the meta objects for example are
- 20:47incredibly powerful and we've seen like huge adoption of meta
- 20:50objects across some of our clients, particularly with
- 20:53multiple stores. Now we've got a client with 15
- 20:56international stores and there is almost as soon as Metal
- 21:01Objects is being announced, they're like right, This is
- 21:03going to solve huge problems for us in terms of how we're
- 21:06managing our data. And if you go and sit down with
- 21:11the, the presales people from the pins, you know first of all
- 21:15are they up to speed with what's happening on Shopify as they on
- 21:19the cutting edge of doing this. And even if they are, where is
- 21:22catching up with the latest Shopify feature?
- 21:25In their road map, right? Is it on the road map?
- 21:29And if it's on the road map, they're gonna say, yeah, it's on
- 21:31the road map. But the next question is gonna
- 21:33be like, well, when can we have it?
- 21:35And software companies are notoriously bad for not sticking
- 21:39to Rd. Maps and things coming later
- 21:41than they should. Never are.
- 21:47It's really well it's just really hard to keep up.
- 21:50Like Shopify is just a juggernaut in the way that they.
- 21:53I think the one thing anyone can respect about them is that they
- 21:56they continue to ship. Yeah.
- 21:59Given where they're at and they don't always get it right but
- 22:03they do continue to ship and some things take longer than
- 22:05they should. But just that kind of in the in
- 22:09the PIM conversation as one use case and the meta object stuff's
- 22:15a great example of where air tables able to leap ahead of.
- 22:19I don't know if there are pins available that can handle meta
- 22:22objects already but we've done it for clients now.
- 22:27And yeah, I think I think it's a it's a strong use case.
- 22:31I wouldn't say it's the it's the only I wouldn't just be putting
- 22:35air table into my business to do PIM.
- 22:37I think you need to think a bit bigger than that, but I
- 22:40certainly would be comparing it. If I was looking at spending 100
- 22:44and 150 grand on a pen, I would, and I wasn't completely blown
- 22:49away by it, what it was going to do.
- 22:51I'd certainly take some time to look at our table in a bit more
- 22:54detail. It's interesting you you you
- 22:58touched on the, yeah, the next question I got which is that
- 23:01wider product lifecycle management piece and that you
- 23:04said, yeah I wouldn't just do it for the the the PIN piece think
- 23:07why didn't that now some businesses, bigger businesses
- 23:11where they they have. Other software for the the some
- 23:15of the PLM like the buyers and the merchandisers are doing
- 23:19their range plan and assortment planning etcetera.
- 23:21In there they might add the the ERP where these master skews are
- 23:27getting set up, the bar codes are generated P OS that then
- 23:31enables them to raise orders, they've got him to push
- 23:34e-commerce all these things. One of the I guess one of the
- 23:36questions I've got around air table is.
- 23:40What's the connectivity like? What are the integration options
- 23:42where people have got some systems that they don't want to
- 23:44change but other things they want to do in air table?
- 23:48Is it all API base you know? Are there other formats for
- 23:51pushing data in and out? Yeah, this is where it really
- 23:56wins. So every air table base there
- 24:01might like. You can add like columns to your
- 24:03base. You can Add all different column
- 24:05formats. You can create new tables within
- 24:07your database literally on the fly.
- 24:11An AIR table dynamically builds the API for that base as you're
- 24:14doing that work. So if you've ever worked with
- 24:17something like Zapia or make.com, you can have your AIR
- 24:21table base key set up and you can be adding fields like live
- 24:25in the database. And then you can flick your tab
- 24:28to make refresh and a field that you've just added has just
- 24:32appeared. So now if you think about when
- 24:35you're trying to get systems to connect together and you realize
- 24:38like, oh, we need a unique identifier or we need a central
- 24:41base where we match all the different keys for product
- 24:45between our different systems. So I could just build that and
- 24:49have an interface on it and then connect all of that up so you're
- 24:53able to solve some of those problems around data really,
- 24:58really quickly. I think the other what I really
- 25:02meant there in terms of thinking bigger isn't just like the wider
- 25:07product life cycle. I think the thinking bigger is
- 25:10about having the conversation about you know how we're using
- 25:16e-mail in the business, how we doing project management or
- 25:21product management in the company.
- 25:23Like where are all the projects being tracked?
- 25:26Where is our, Yeah, this is part of PLM.
- 25:28I guess where's our merch plan, where's our trade plan?
- 25:31Where do we plan our campaigns and that conversation around
- 25:36where's planning done combined with what Excel files and Google
- 25:40Sheets are we using? And then if you add on top of
- 25:44that, how are we communicating? How do we use Team Slack?
- 25:47G me it's the businesses or the leaders that are able to look at
- 25:53all of those three areas and then present a combined case
- 25:57that find the fastest way to bring some value from our table
- 26:02into their business. And doing like your product data
- 26:04is actually a relatively like a relatively high barrier to doing
- 26:09it because you really need to plan it out and get it right
- 26:11because it's your data structure that you're trying to sort and
- 26:15there's going to be some data import.
- 26:16You may be better off just starting to use it for project
- 26:19management or managing like your ecommerce checklist in like a
- 26:23timeline and migrating stuff over from a Monday or an Asana
- 26:27and then adding some of these other things in later.
- 26:31Doesn't need to be a big project.
- 26:34And is that, is that typically how you start with, with your
- 26:38cards? Are you mainly working on the
- 26:40product like management and product data management or do
- 26:45you sometimes do start them smaller?
- 26:46I'm just moving over some of those kind of date, date to date
- 26:50project management pieces. I guess it it depends like I
- 26:59think our, so I can take, I'll take the example of a company
- 27:07we're working with the minute they've got 365 employees in
- 27:12total and they've raised in like the 10s of millions of pounds.
- 27:17And when they came to us they were specifically looking at the
- 27:23pen aspect. So they were, they were trying
- 27:25to find an alternative to to a very well known pen to connect
- 27:32to Shopify and do their 15 stores.
- 27:35When we showed them like how we map things out and how to think
- 27:40about this kind of three dimensionally from a planning,
- 27:44data and a communication perspective.
- 27:47When they mapped all of that out, it completely changed where
- 27:50they wanted to start their journey.
- 27:53And when you're a bigger business which they are just
- 27:57getting going on planning, so having all of their campaigns
- 28:01and promotions and all of that organized and a bit of product
- 28:04development, that in itself is a is an 8 to 12 week journey
- 28:09because there's 4050 people involved in doing that right.
- 28:15You could scale that back down to say like for any business
- 28:19like IT IT planning is often ends up in a few places and
- 28:26often I find I'm sure you do as well.
- 28:29When you go into a business and you start looking at technology
- 28:32and what projects should be done, they often don't have a
- 28:35good handle on what projects are even happening right now.
- 28:39So actually actually starting point is to put all the projects
- 28:44in air table and say when do all of these start and finish
- 28:48Because you can't actually decide to do one of the bigger
- 28:51air table projects until they workout where their resource is
- 28:54at. And that in that case that
- 28:56itself often is a really good way to go.
- 28:58Look, this is quite handy, isn't it, for planning and seeing how
- 29:01things work and they go, Oh yeah, what if as well as seeing
- 29:04our projects, we could see everything else that's going on?
- 29:07Yeah, that's the place to get going.
- 29:10So yeah, that. I mean that's a common one I
- 29:13come up across where people want to move really fast in one team,
- 29:16but the resource dependency in others not available for six
- 29:18months and therefore you just hit.
- 29:20You start and then within two months you had to stop and pause
- 29:23it and then that kills project. So, yeah, amazing for resource
- 29:29planning and like timelines and putting in like the number of
- 29:32hours you've got available of people and seeing like team
- 29:36utilization. We're using all of that stuff
- 29:38for our services and it is amazing.
- 29:41But yeah, I don't expect ecommerce businesses that
- 29:44haven't got, you know, full project management offices and
- 29:48credit managers and big tech teams to be using it like that.
- 29:51But certainly you want to have that overview of what's going
- 29:53on. Yeah, I mean that's interesting
- 29:56actually from a PMO perspective a lot of programs because just
- 29:59talking to a client at the moment or a re platforming
- 30:03project, but actually it's a program because there are loads
- 30:05of other sub projects that feed in that have dependencies and
- 30:09and that's when that resource planning is critical because
- 30:11otherwise you end up. Stalling in one part because of
- 30:15not planning from the other. And one of the questions I've
- 30:17got actually around a table is the the integrations bit because
- 30:20I know they've got a marketplace, but quite limits
- 30:23it. And yeah, every, every, every
- 30:27single tech vendor has like any ecosystem of partners and
- 30:29integrations. And those integrations can
- 30:31either mean we've spoken to them or we've actually done some
- 30:34proper integration work and there's data connectivity.
- 30:36So I'd love to know for things like the Big ecom platforms like
- 30:39Shopifies, Adobe Big Commerce, etc.
- 30:43How, how connected is it already?
- 30:46If you set up your data structures in their table to be
- 30:49able to just push it automatically into like Shopify
- 30:52and vice versa, this is how much work do you as like as an air
- 30:56table? Yeah consultant specialists have
- 30:58to do to get those connections working and so that is not non
- 31:04connected to the major platforms is the short answer.
- 31:09But it it's built to be in the same way.
- 31:13It's trying to solve this problem of making it really easy
- 31:16for data to flow within our table.
- 31:18They've built the platform in a way to make it really easy to
- 31:21get data in and out and build those connections.
- 31:24So yeah and and it's often often some of the well I saw a people
- 31:31box the warehouse software I started at.
- 31:34We took a different strategy towards integration then almost
- 31:37everybody else in our in our space we decided not to build
- 31:41any connectors to anything. We bought a Magenta 1 connector
- 31:45and got burned so badly we were like I can't imagine going
- 31:48through the pain of doing this with another ecommerce platform
- 31:52and so we didn't. And then we just, we work with
- 31:54partners to write our integrations.
- 31:57And I kind of I think that partner opportunity, it is the
- 32:03one that we're serving with our table.
- 32:04But also the reason we took that strategy at People Box is we
- 32:08also realized everybody wants integration to work in a
- 32:11slightly different way and particularly with product data
- 32:15like a really simple example is when you create a product on
- 32:20Shopify, we might apply tags automatically based on the
- 32:23information we've got in our table.
- 32:25It's a really simple automation to do.
- 32:27So we apply tags, but then lots of merchants have other apps
- 32:31that also apply tags once products have been created.
- 32:35So if we then just push the dumb update to tags again at some
- 32:40point in the future, we're going to break a whole load of stuff.
- 32:43So what we've we've really kind of really focusing on actually
- 32:48is being very process oriented in how we design, very data
- 32:52focused and very like we'd rather spend 80% of our time
- 32:57doing the design and research and requirements gathering and
- 33:0020% of our time doing the build work and be constantly reworking
- 33:05stuff and figuring stuff out. So Adam it's definitely like you
- 33:10know measure twice, cut once is the best approach because it is
- 33:13custom, it is going to be a custom integration.
- 33:16But, and yeah, from if you were working for a brand doing that,
- 33:22it means you're going to have to make a lot of decisions that you
- 33:26possibly have an app to make up until now and you're going to
- 33:29need to make sure you got all the right people involved to
- 33:32make those decisions. And that's probably one of the
- 33:34hardest bits we find. You know, people aren't haven't
- 33:37made a lot of decisions about product data and people are
- 33:40doing stuff in different ways. Yes, yeah, indeed.
- 33:45Let's talk about costs because this is the thing I'm really
- 33:48interested because having worked on quite a few PIM
- 33:50implementations and you have your upfront discovery, you have
- 33:55implementation, your test and your release, and you've got
- 33:57your ongoing monthly fees you often.
- 34:00Might take a retail, it's around 10 million and might have a
- 34:02product catalogue of about 5000. Skews it might well be a 15 to
- 34:0720 K set up fee and then a monthly fee of, you know, big
- 34:11well annual fee can be anywhere from 30K upwards.
- 34:16Where are you seeing the the? How does it cost more than
- 34:18compare 1st? And where's the bulk of the
- 34:21cost? And how much ongoing do people
- 34:24expect to pay? Yeah.
- 34:27So there's definitely a a software as a service kind of
- 34:34operating expense advantage with our table in the the, they've
- 34:40got various versions. But really for the kind of
- 34:43workflows we're talking about, you'd need to be on that
- 34:45business version or their enterprise scale version.
- 34:49And the business version is 45 U.S. dollars per person per
- 34:54month if it's filled annually or it's $54 a month billed monthly.
- 35:01There's another set of pricing on their enterprise scale
- 35:05version, which is slightly more but you need to be, you need to
- 35:10commit to to a certain number of users and that really changes.
- 35:14You know it's a it's an enterprise sale process from
- 35:17their perspective. That line I mentioned before,
- 35:19that's got 350 odd employees there.
- 35:23They're in the enterprise scale count.
- 35:24But for most companies getting started, you'd be looking at
- 35:28that business, the business model, which is the $45.00 a
- 35:33month or $54 a month per user. So that kind of, I guess links
- 35:38back to the other point I was making of using it for lots of
- 35:41things. What I found with most brands is
- 35:43they're spending money on a sauna or click up.
- 35:45You can pretty much be cost neutral on your ad table Bill by
- 35:50getting rid of an Asauna or a click up or a Trello and
- 35:53embedding our table properly. So kind of air tables paid for
- 35:56itself at that point. And then in terms of how we
- 36:00work, we've been doing projects like on all different scales.
- 36:05We've only been doing projects for the last we've been doing
- 36:08for a year and a half. We've done probably 2223 like
- 36:14meaningful like big app builds in total across 13 different
- 36:18clients ranging from sort of 5 million to like 200 million in
- 36:24revenue. I would say for anyone between
- 36:27the five and the the two 200 million, it's certainly going to
- 36:32be like cost favorable versus an off the shelf pin.
- 36:36But because it's custom the cost of actually doing it could vary
- 36:40significantly. We feature matched a pin with
- 36:45passenger clothing who are outdoor brand, they wouldn't.
- 36:50I think they're a number, they're in the fast track 100.
- 36:53I can't remember if they were the top business last year or
- 36:56where they were, but they they certainly did well.
- 36:58They just raised £19 million in funding and we feature matched
- 37:05all the pins on the market and all of the other pins were
- 37:08coming in at about you know 44 grand a month for what we were
- 37:12doing with about a 20 to £30,000 upfront fee.
- 37:18And yeah, let's say it, yeah, well, straight away you're
- 37:22saving about 3 grand a month from the ongoing and then some
- 37:25of that is kind of lost to, yeah, we we with a lot of
- 37:30clients, we've got an ongoing kind of service agreement where
- 37:33we're continuing to do the building and the support with
- 37:35them. And so that's going to kind of
- 37:37eat away a little bit of that. And then kind of on that upfront
- 37:40fee, we tend to be about tend to be cost neutral.
- 37:43But it depends on yeah, if you were looking at paying in a
- 37:46really entry level pen that's super simple like a politics for
- 37:50example. You can sign up online and
- 37:52there's like a 3K implementation fee.
- 37:54There's something really simple it could be more like that but
- 37:57for something more advanced it's going to be a lot more money.
- 38:00You know where and we're still figuring it out to be honest
- 38:03James, like it's a, it's a it's definitely part of the process
- 38:07is working out what to charge for it.
- 38:09What I'm not prepared to do is compromise on quality.
- 38:13So kind of our, our biggest thing is to do really good
- 38:16design work which and be very process oriented which we are
- 38:21and and also you know be thinking ahead.
- 38:26So one of the drawbacks of building custom software like
- 38:29anything is you can end up with a monolith, right.
- 38:32You don't plan it out right and you don't really think about
- 38:34where things are going to go. You could end up like any and
- 38:38we've all seen that custom monolith inside a retailer where
- 38:41everyone's like what the hell were they building?
- 38:43This is ridiculous. We're never going to unpick
- 38:45this. So we don't want our table to
- 38:47turn into another one of those. So definitely a focus from our
- 38:51side on on the quality of the build and the quality of the
- 38:54design at the minute over over volume of sort of knocking them
- 38:58out. It's certainly it's not.
- 39:02Yeah, it's not. It's not quick.
- 39:05Yeah, Anthony, what other things?
- 39:07Quick. It's not quick, high quality and
- 39:09cheap. Is that still that triangle?
- 39:11If you need to pick one of the three.
- 39:14But it could well be that in the past the pins were slow.
- 39:19Yeah, medium quality and very expensive.
- 39:22And we only need to beat it on, you know, a couple of aspects of
- 39:25that triangle, and we definitely did it.
- 39:28I found this really interested. We've gone through the key
- 39:31questions. I guess there might be some
- 39:35people listening. I really want to ask more
- 39:38because I'm not convinced by some of this or I want to find
- 39:40out how it would work in my use case.
- 39:41How can they reach out? Yes, if you just e-mail me
- 39:46directly is the best way. So oliver@noloapps.com, so
- 39:51Oliver Oliver at Nolo NOLO Apps APP, s.com is the best way to
- 39:58get in touch. And and yeah, well reach out to
- 40:02me on LinkedIn if we're already connected.
- 40:04That's where I'm hanging out most of the time in terms of the
- 40:07content that we're putting out. So you'll see Nolo apps at the
- 40:10minute, we're just sort of a holding page on our.
- 40:14On our website, working on all of that type of stuff at the
- 40:16minute, but our focus has been on building the internal team
- 40:19and our capability, you know versus some of the some of the
- 40:23marketing stuff. There's certainly plenty of
- 40:25demand for this type of type of work we're finding.
- 40:29That I really appreciate you coming on.
- 40:31I'm really interested. I've enjoyed watching the
- 40:33journey. I think it's a great idea.
- 40:35I'm hoping in the not too distant future I can find a
- 40:39project where it's relevant for us too.
- 40:41To have a conversation and bring you in to do some exciting data
- 40:44work. So let's watch this space.
- 40:48Yeah, that. Yeah, that would be great.
- 40:50We'd love to love to get in the mix and get your, your view on
- 40:53it up against some of the other systems that you know really
- 40:56well. So the more, the more kind of
- 40:59experts and knowledge experts we can get involved in showing them
- 41:03what's possible, yeah, it can help shape where we're going
- 41:06with it because sort of the the story of what's possible is kind
- 41:11of being written at the minute, I think, at least for the next
- 41:13few years. Excellent.
- 41:16Thanks everyone who's listening. I hope you really enjoyed it.
- 41:18I think it's it's a cracking episode.
- 41:20I do. Reach out to Oliver if you want
- 41:21to find out more or Probe or any of the areas we discussed.
- 41:24Keep your ears open for the next episode we drop on every week.
- 41:27And don't forget to give us that rating on Apple, Spotify,
- 41:29YouTube, or whatever else you'll listen and watching before you
- 41:32sign up until next week. Take care.
- 41:42More information on this topic Head over to Replatform dot FM
- 41:45for our audio podcasts to discuss a project.
- 41:48Or if you'd like to chat about any of the topics covered in
- 41:50this episode in more detail, please reach out to myself,
- 41:52James Gerd, or my cohost Paul Rogers via LinkedIn and Twitter.
- 41:55Thanks again for listening and keep your ears peeled for the
- 41:58next episode.