XPO, Inc. (XPO) Earnings Call Transcript & Summary

November 12, 2020

New York Stock Exchange US Industrials Ground Transportation conference_presentation 31 min

Earnings Call Speaker Segments

Ravi Shanker

analyst
#1

Great. Good afternoon, everyone, and welcome back to the Morgan Stanley Life After COVID Conference, the e-commerce track as we have it today. For those who don't know me, I'm Ravi Shanker, the firm's freight, transportation and airlines analyst. And we're very pleased to have with us today XPO Logistics and Erik Caldwell and Matt Fassler. Gentlemen, thanks so much for joining us.

Matthew Fassler

executive
#2

Happy to be here.

Ravi Shanker

analyst
#3

Great. So before I kick off, I'll have to note that please note that this webcast is for Morgan Stanley's clients and appropriate Morgan Stanley employees only. This webcast is not for members of the press. If you are a member of the press, please disconnect and reach out separately. For important disclosures, please see the Morgan Stanley research disclosure website at www.morganstanley.com/researchdisclosures. If you have any questions, please reach out to your Morgan Stanley sales representative. And for the audience, if you have any questions to the management team, please submit them via our webcast browser, and I can pass them on to the management team. And with that, again, as I said, very happy to have with us Erik Caldwell, who's the President of Last Mile Logistics for XPO. Erik has a responsibility for XPO's last mile operations in North America. Mr. Caldwell has more than 15 years of leadership experience with complex supply chain operations in the consumer and industrial sectors. He joined XPO from Hudson's Bay Company, initially serving as Chief Operating Officer for XPO supply chain business unit in the Americas and Asia Pacific. His roles prior to XPO includes Senior Vice President, Supply Chain and Digital Operations for Hudson's Bay Company; Senior Vice President of Global Revenue Operations for Luxottica; the Director of Retail Solutions for DHL, where he also served as a Regional Director of DHL's last mile operations. And additionally, Mr. Caldwell also consulted on global operations for McKinsey & Company. He holds a Master of Engineering degree in supply chain management from MIT. Erik, welcome and thanks for joining us.

Erik Caldwell

executive
#4

Thank you.

Ravi Shanker

analyst
#5

And we also have Mr. Matt Fassler, the Chief Strategy Officer. Mr. Fassler is responsible for the company's strategy, capital structure and analysis of growth opportunities. Prior to XPO, doing more than 20 years with Goldman Sachs. He covered many of the world's most prominent brands, including Walmart, Target, Costco, Home Depot, Best Buy and AutoZone. He additionally served as Managing Director and business unit leader for more than 10 years with responsibility for the broader consumer sector. Mr. Fassler has been recognized 16 times in the Institutional Investor All-America Research Team ranking, and he holds a degree in University from Yale University. Matt, thanks for joining as well.

Matthew Fassler

executive
#6

Thanks again, folks.

Ravi Shanker

analyst
#7

So Matt, maybe, again, you guys are -- XPO Logistics is a giant in the world of freight transportation and logistics. But given that we have more of a broader, more generalist audience for this event, maybe you can kick off with kind of telling us more about XPO, its role in the freight transportation and logistics world and the specific role that you guys play in e-commerce.

Matthew Fassler

executive
#8

Of course. And Ravi, thanks again for having us. So do many more conferences with you, but hopefully no more with any COVID [ in that time ] for obvious reasons. And so we are a leader in the fastest-growing areas of transportation and logistics. We generated about $17 million in revenue in 2019, about 60% of that in North America and 40% in Europe. The logistics industry, as you all know, is getting more complex and operators with scale and technology and industry efficacy for that combination have unique opportunity to capture market share and to build incremental profit opportunity. Our own share of the global logistics market, really adjusted in the regions that we operate within, is relatively small, really less than 2%, which creates a very strong market share and revenue opportunity. There are 2 trends driving the industry opportunity today, 2 high-level [indiscernible]. The first is increased customer demand for third-party supply chain management and that has continued to grow and probably accelerate with the pandemic with brought supply chain visibility to the top of mind for senior management and for many of our customers. Also, there's the increased deployment of tech and data management across supply chains, which is helping companies to price more efficiently and to better manage their fleets and their labor. Now deep diving into e-comm. E-commerce is one of our largest verticals, and it is our fastest-growing vertical. We have exposure throughout our company, but it's focused in 2 lines of business. One is Erik's area of operation currently, our last mile for heavy goods. We are the largest provider of last mile services for heavy goods in the U.S., about 50% larger than our next largest competitor. The second area is contract logistics. We are #2 in the U.S. in contracted logistics, we're #2 in Europe, and we're #2 globally. We operate about 200 million square feet of warehouse space and we're a top 5 industrial tenant in North America. As it relates to e-commerce, in particular, we are a leader in both forward and reverse logistics. We operate the leading freight fulfillment platform in Europe. We deploy automation in the warehouse in the service of our customers and more and more of it each year. And finally, we operate XPO Direct. This is our shared service distribution network. It's expressly designed for e-commerce customers. Return to profit -- for XPO Direct, returning to profit for XPO Direct in 2020, which is only its second full year of operations.

Ravi Shanker

analyst
#9

Great. Thanks. That was a great summary and probably no better time to be in the e-commerce space than right now, given everything you've seen this year. I think one of the more kind of shocking or explicit changes as a result of the pandemic was the volume surge that you've seen this year on the e-commerce side. Maybe you can take us through your understanding of how much of that is permanent versus transitory? Meaning, how much of that will stay online e-commerce versus going back in the store? Also, what does this mean for growth in the coming years? If we have pulled forward 3 years of e-commerce penetration, do you think e-commerce continues to grow as the [ shredded ] rate it has been in the last few years? Or does that more [indiscernible] in the coming years?

Matthew Fassler

executive
#10

You're right. That has been an extraordinary year for e-commerce. I think we've all lived it. Certainly, Erik and I and our colleagues professionally and all of us personally as well. As to the sustainability of growth, in a sense, I want to put it right back to you. I took a look at the Morgan Stanley e-commerce model, at Brian's model for industry growth. And he expects U.S. e-commerce sales to still grow 8% in 2021, despite, if you will, a very tough comparison. That's not surprising to us. Consumers' habits are changing. Brick-and-mortar capacity is exiting the marketplace. I think both of those dynamics accelerated and in a lasting way here in 2020 with the pandemic. But we still think we can grow at an outsized pace longer term. E-commerce was a 15% growth channel, year in, year out for many, many years. [ If it took below ] that next year, it would still grow faster in overall consumption, we think it can return and will return to double-digit growth in ensuing years. If you look deeper into the composition of e-commerce growth, by the way, as you look into next year to 2021, our sense is that growth for our customers and for the verticals in which we play most in e-commerce, will be stronger than overall market growth. I'm talking about segment cargo goods and apparel. Some areas that had outsized growth this year like online grocery, for example, we do less in online grocery, very little of online grocery. We do a whole lot in food and beverage, but less on online grocery per se. Why hasn't it moved higher yet as a percent of the overall mix? I think consumer trends move gradually. There's a tremendous amount of [indiscernible] less food and purchase and [ demand ] food. Tremendous amount in value channels, tremendous amount where the economics of direct distribution are not yet superior to the store. But we think, overall, the trends that we just discussed, brick-and-mortar capacity coming out, consumer habits changing suggest an awfully long runway, it's an awfully runway for e-commerce. And we're going to participate in that as well.

Ravi Shanker

analyst
#11

Got it. So that was a look at e-commerce from the demand side. Kind of looking at e-commerce on the supply side, how does the current warehousing capacity able to support this volume? How much growth do you think we need to see there? And again, is this similar warehousing capacity to what we've seen in the last few years? Or is there something different about it compared to the way either in terms of location or the type of warehousing capability you guys have been adding over the past several years.

Erik Caldwell

executive
#12

So Ravi, it's Erik. It's the most exciting time to be a professional supply chain, right? This invisible industry where if you did everything perfectly, no one noticed you is the focal point of the entire country. And we're seeing such a strong growth in warehouse space. Talking to real estate brokers, there were 70 million square feet of space added alone this year in Q1, Q2, Q3 for e-commerce. If you split out Q2, 46 million square feet was added around e commerce. And as a general guideline, we think for every $1 billion of online sales translates to about an additional 1 million square feet of warehouse space that's required to support that. As we're seeing this really strong growth, if you compare the ratio of industrial space that went to e-commerce last year, it was about 35% and this year it's over half. So the answer is yes. Very strong growth. And if anything, we're seeing supply chains and customers really chasing this trend at this point to get additional space going into this peak and then preparing for next year. I think these trends have legs, and we're going to continue to see consumers shop more online. I don't see that changing. And that's going to drive this warehouse space. We as a company added $61 million -- excuse me, $61 billion -- I'm sorry, I missed it, [indiscernible] again. $61 billion of e-commerce sales were added year-over-year in the market as a whole. And so we're seeing the benefit of that as a company as a real strong macro tailwind with the secular growth in that space. The other part is we're seeing a change. Our XPO Direct network allowed companies to get into a regional model. Historically, you can get away with a central DC supporting the country with catalog sales and retail sales. We went by coastal and we're seeing a lot of activity on the West Coast, and we're seeing a lot more companies get into the regional model. Our XPO Direct network allows companies to integrate directly to that and not have to get the footprint and share the benefit of consolidation with other customers in that. The other part is a lot of companies such as Connected Fitness, [ Mattresses in a Box ], these new e-comm direct-to-consumer offerings need a national network, and they need to forward stock inventory in market because they're very sensitive to service. And they also need to consolidate transportation into the metro market. So our WMx cloud-based warehouse solution supports this. Our XPO Connect technology gives us complete visibility around this. And the other part, it gives the customers the ability to understand what inventory to position in those metro markets, in particular, around last mile because it's difficult to move product from market to market. And so this is offerings that we're providing to the market that there's a great need for that. In fact, we built 88 last mile hubs across the U.S. and Canada, and we are within 90% -- excuse me, 125 miles of 90% of the U.S. population. And so we're giving customers that coverage for the last mile delivery and the ability to forward stock in our locations and XPO Direct to give them regional coverage for unallocated warehousing space. So I think these are real big secular trends. As I said, $61 billion of expansion in the e-commerce market is going to be a long-term tailwind for the logistics industry. I don't see that changing anytime soon, Ravi.

Ravi Shanker

analyst
#13

Got it. That's great color. And also a great segue to my next question. But you touched on the service needs and kind of being within 125 miles of 90% of the U.S. population. I think one of the big trends coming into this year was the real ramp-up in service levels for e-commerce delivery. Obviously, we went from 2-day delivery to 1-day delivery. We're in the process of making that transition as an industry. That's sort of going to hit a wall this year, obviously, with the COVID-related disruptions. And with the pandemic, I mean, service standards have dropped precipitously. They have come back since then. I mean today, if I place an order that's supposed to be delivered in 2 days, but it takes 5, in April, I would have said that's fine. Now I think I should be upset about it. I'm not sure. So again, how much of this do you think is a permanent shift? Do you think with the pandemic, customers have kind of permanently made the shift away from saying, "Hey, I need my box in a day whether I want it or not," to kind of maybe relaxing a little bit on that and kind of maybe going in different direction in terms of the variety of SKUs, they will probably rather order online.

Erik Caldwell

executive
#14

So we're seeing the increase of agility in supply chains to meet the needs and have product available. Supply chains were strained during COVID. And we're seeing that even going into the peak period, especially in the large ticket items. And we do our own internal surveys, and we saw a 9% drop in the strongly impacted importance of free shipping. And we're seeing other categories take more importance there about reliability and accessibility for that product. So I think, Ravi, you're seeing that shift where that's become more important, less than 1 day less than free shipping, it's the availability of goods and the reliability of the goods. The other part is we did see parcel and post, probably more strained in that space with the volume increase, and it's harder to flex their network. And we saw delays in now. We also saw large companies increasing parcel surcharges and premiums on that along with that tightness in capacity. The other part is, we're really proud we saw peak level -- higher than peak level volumes this summer in the last mile delivery space as compared to last year's peak. Matt, on the earnings call, talked about an 11% increase in revenue while increasing our operating performance substantially. And then the final part of that trifecta is we saw our voice of the customer and our online impressions of our service improve by 200 to 300 basis points in that same time frame. And so I think you have to do all these well. You have to handle large volumes. You have to be able to scale up and scale back down to be nimble with your technology. And you have to really focus on the consumer and maintain that service level, especially in times of pandemic with uncertainty because the consumer, especially in a large good, it's an emotional, expensive product that you're very tied to that happens with the delivery in your own home. You have to remain focused on that and provide that continuity and that comfort for the customers during that deliver.

Ravi Shanker

analyst
#15

Got it. Maybe shifting gears a little bit and coming closer to your direct wheelhouse, which is last mile logistics. Obviously, kind of an area where XPO really specializes. And as Matt said at the top, is delivery of heavy goods, like appliances and exercise equipment and that sort of thing. That has been, I think, probably the biggest winner of 2020 if there has been any winner in 2020. But again, that was a space that was already growing very quickly. It has accelerated even more this year. What has surprised you so far about the growth of heavy goods last mile delivery this year? And where do you think that market goes from here?

Matthew Fassler

executive
#16

So Ravi, I'll start, and I'll just take a moment to reinforce your comment on the momentum in that sector. I'm going to throw Erik a little bit of sunshine here, Erik and his team. So you mentioned one of these numbers. But if you look at the XPO Last Mile business in North America, in the third quarter, our revenue was up 11%. Our net revenue or gross margin, kind of interchangeable phrases, up 15%. This was the seventh consecutive quarter in which we achieved expansion in last mile net revenue margin rate. So it's a business that accelerated, grew at a rapid rate and has grown more profitable. So the good news for us is that has persisted. That trend is often limited to the pandemic. But certainly, to your point, it's a business that saw our customers' needs and consumers' needs arise during the pandemic. And Erik, I think, will give you just a bit more color here.

Erik Caldwell

executive
#17

Thanks, Matt. And so we've walked off of these incredibly high industry standards for service and improved those. We've improved the revenue. We've improved our operation ratio. And what we're seeing from a macro trend in there, not just to our performance. But in 2013, the heavy goods delivery market was around a $8 billion market. And this year, it's going to end up somewhere around $13 billion. And many companies, on their programs, who were online have actually pulled forward a couple of years what they plan to do online, especially around the heavy goods. And what we're forecasting, what the market is showing that this market will grow to somewhere between $16 billion and $18 billion by the end of 2023. So the market is growing as a whole. Within that market, there's some interesting trends. In 2013, 22% of orders for heavy goods were ordered online. This year, it's somewhere between 33% and 35%. By the end of 2023, it's going to be greater than 38% of all heavy good orders are going to be placed online. Again, talk about secular macro tailwind. These online orders are driving more outsourced transportation. They're adding a lot more complexity that requires providers of scale with national coverage, with amazing service and really capable technology to deliver these. And so that's what we're seeing in this space, and we don't see it slowing down at all. It's a good time to be in supply chain, and it's a really great time to be in last mile.

Ravi Shanker

analyst
#18

Got it. Erik, Can you give a little more insight into that business because it's a business where you don't have too many players, especially with national scale. You have -- I think you've seen several entrants into the space, both new entrants as well as giants in parcel delivery who have expanded into heavy goods with mixed, in fact, probably very little success. What makes this business so challenging to get into and these -- and successfully scale up, do you think?

Erik Caldwell

executive
#19

I think there's a moat to get to that national scale, and you have to have a great basis of stable, long-term customers. Our biggest customers we've had relationships with for over a decade, and we continue to expand and grow with them. So I think that's the first part is there's this hurdle or this moat. To have that scale, you have to have a strong existing customer base. The other part is the technology piece. We're adding a lot of Connected Fitness equipment. We're adding a lot of direct-to-consumer business. And you have to have the technology in order to support the customer to do that. And you really have to have a digitized consumer experience. And we rolled out our XPO Connect tool this year, and it's giving us all of that and actually delivering more meaningfully than we had even hoped. Routing efficiency, visibility to the trucks, capacity planning, consumer notifications and AI and using all that. And it is also giving our customers those abilities to forward stock inventory to help get visibility to returns, which is about 10% in heavy goods, 15%, 20% in parcel. Those are heavy goods. So the more we can do around that space with that technology advantage, that gives us a decisive advantage in the marketplace. That's very difficult for new entrants to come in and do. And so Ravi, I think that's what you're seeing is there's a lot of smaller players out there, but they're playing in a more transactional space, and we're really focused on trying to provide that stable long-term relationship with customers and offering a differentiated solution inside this space.

Ravi Shanker

analyst
#20

Got it. I think 1 area where I think customers kind of like that hybrid of an in-store versus an e-commerce experience is in heavy appliances where I can go to a store, check out what my options are and a push a few buttons and then go on my phone and kind of place the order online. And kind of one of the trends that we've been tracking for a long time hasn't really picked up, but maybe has gotten more traction this year with COVID, is a shift from store and the ability and/or willingness of brick-and-mortar retailers to kind of leverage their [ shutter ] store network this year to do e-commerce delivery. Again, we have seen mixed success with getting this to work the last few years. Do you think anything's happened with the pandemic that retailers have now figured out how to make it work?

Erik Caldwell

executive
#21

I think ship-from-store is a great tool in the toolkit. And there's some really great pros to it. So if you think about, you've got trapped inventory to store, by able to ship from there, I can reduce obsolescence, I can reduce how many SKU base I have to maintain there. And when I look back when I was running supply chain and digital ops at HBC, in Saks Fifth Avenue office, Hudson's Bay in Canada and [ Galleria Kaufen ], which is about 1/3 of our business in Germany, we were somewhere around 15% of our e-comm orders were shipping from stores. We would always like that to be higher because, again, it does reduce the obsolescence and it reduces the markdowns of inventory. The other benefit is you're closer to the consumer. Being in a store and being able to ship from that market into the store. So some real positives there. And there are some big-box retailers that are reenergizing the space. They are very smart, and I suspect they'll be successful. The cons to this and the difficulties to this is store-based labor is not as efficient as warehouse-based labor, right? You don't have the automation, you don't have the density of the picks. When you send an order to a store, you have to send it to multiple stores. A lot of times, the inventory is not as accurate, it's not as located in the stores. So you're sending an order out to multiple stores and, again, have some service delays. And the third part of that, as we mentioned, being closer to the consumer in a market, the challenge is if you have 2.7 or 3 units per average order. Well, if you're filling some from a store and you're filling some from the DC, you end up with a lot of split orders. So the transportation cost is offset because we're actually doing 2 shipments now in a lot of cases, both from the DC and the store. So I think it's a unique tool in the toolbox, and there's many cases where it works really well, but there are some headwinds against that as well. On the heavy goods side, what we're seeing is a trend of stores have been shifting away from heavy goods shipping from directly from the store, but sales associates in brick-and-mortar are focused on the consumer experience in the store and the sale versus trying to fulfill heavy goods, appliances, furniture from the back of the store with a dedicated truck. So we're starting to see that increase and move upstream to consolidation points regionally or in market and then doing the deliveries from there. So again, adding a lot of complexity, requiring a lot more scale, but then allowing the stores to focus more on the consumer experience in the store and capture that sale.

Ravi Shanker

analyst
#22

Got it. I wanted to kind of shift gears a little bit because, again, as we know very well as transportation analysts following logistics, XPO is absolutely at the cutting-edge of technology adoption whether it's rolling our cloud-based apps or being a leader in warehouse robotics. Obviously, you announced the warehouse of the future that you've teamed up with Nestlé to open in Europe, which is kind of the warehouse of the future, right? So maybe you can kind of, Erik or Matt, walk us through what are some of the more exciting kind of technology solutions you guys have put in place, whether it's warehouse robotics or even electrification of last mile autonomous vans for delivery, drones, kind of what are some of the work that you're doing out there on the [ comp side ]?

Erik Caldwell

executive
#23

So I'll talk electrification just briefly and then hand it over to Matt. So electrification is happening in last mile. It makes sense because you're in a metro area, you can recharge, you're not long distance over the road. We're seeing Daimler and Volvo playing in the space and rolling out trucks in this space. We're seeing demand from large multinational customers really concerned about environmental footprint and how does EV play into that, especially in the last mile piece, and we're seeing some other small arrivals come up. Rivian, Lion and [ Change ] are some of the other new companies coming out with electric vehicles with box trucks for the local market. So I think that's going to evolve. You don't see a large presence with it yet. But I think that's going to evolve. And we want to be leaders in that space and the industry. And again, talking to some large international retailers and manufacturers to help play in that space for the home delivery. So Matt, on the other automation, do you want to cover that a bit then?

Matthew Fassler

executive
#24

Well, why don't you handle really warehouse automation, which is really more so, I guess, Erik Caldwell, in your wheelhouse. I'd be a real poser if I tried to step over you on that one.

Erik Caldwell

executive
#25

That's a lie. Matt and I spent time in the warehouses together on robotics. So he knows almost as much as I do, I'm sure. So Ravi, first of all, I've been inside the Nestlé warehouse of the future in England, and it is amazing. It was like Star Wars when they saw the Death Star. It just takes your breath away. We're like this is incredible. And the ability to run that with as few people as they do with all the automation going [ on ].

Ravi Shanker

analyst
#26

Erik, so sorry for interrupting. But can you just kind of give us a little more detail on what is so fascinating about it? Kind of how -- what would be the big difference if I walk in that warehouse versus any other regular warehouse?

Erik Caldwell

executive
#27

So as the pallets come in off the truck, you obviously have a forklift still going in and out of the truck. But once it comes off the truck, you can double-stack pallets on a carousel, which then moves them throughout the entire warehouse. It's got a case shuttle storage, double high pallets that's larger than anything else in the world. And so the scale of the automated retrieval is unlike anything else we've seen. For the value-added services, you have massive robotic arms that are building pallets specific for the store with mixed cases, without human intervention. Oddly enough, one of the jobs, forkless on and off trucks is always difficult, right? And we've done the autonomous vehicles having forkless on and off trucks is always hard. The other hard thing we ran into that DC with the European team was having someone cut the shrink wrap on the side of the pallets. It was very difficult to automate. So we still have people using a box cutter, safe box cutter to actually cut the shrink wrap down to the right level. So the robotic arm then can take and build the different rainbow pallets, which is interesting. But that was 1 of the constraints in the whole operation. We have cobots that are handpicking individual items along with the associates to build out smaller cases that then are put into the bigger robotic arms and consolidated. Everything that comes out of those robotic arms is, again, not touched by a human until it's put back on to a truck. And so it's a massive facility. The booms on the case shuttle for putting pallets in and out are, I think, they're 8 feet or 9 feet wide in the base, if I remember correctly. And it's incredibly tall. It takes your breath away when you see it. You're like, this is amazing. This is truly the future of warehousing and so excited to see that. And the team there is very fired up about it as well. Our relationship with Nestlé -- Nestlé had their Board meeting on the floor of the warehouse while it was being built because they're so excited about how do they really push the edge of supply chain automation partnering with XPO. Did I point that well enough, Ravi, did I [indiscernible]?

Ravi Shanker

analyst
#28

No, no. That has really teed me up, and I'm really looking forward to when we can get on a plane again and do field trips. Matt, please note next Analyst Day or kind of field trip event should be at that warehouse. Pretty excited to see it.

Erik Caldwell

executive
#29

Absolutely. Ravi, the other one I do want to cover, too, is we're doing a lot around goods to person. And so historically, warehouse associates are walking a lot. It's very difficult, straining, and we've built goods-to-person solutions, leveraging our WMx and partnership around technology where the shelves are coming to the associate in a safe, comfortable work environment. It's increasing productivity. It's increasing engagement and happiness, reducing injuries. Our rate of injuries was 1/3 of the national average for safety. And we cut that down to around 20% in the last couple of years. And so we take that very seriously. And these robots really help us focus on the safety and associate engagement. Repetitive motion. So we're launching very big goods-to-person operations on the East Coast and a lot on the West Coast in order to support the e-commerce. In particular, e-commerce really makes sense here because the time-sensitive of the orders and getting those out and those robots really give us that advantage.

Ravi Shanker

analyst
#30

Got it. On that, exciting and hopeful note in the future. We are out of time. Erik and Matt, thanks so much for joining us. Fascinating discussion, and will be very interesting to see where we go from here. Thanks, again, for joining us.

Erik Caldwell

executive
#31

Thank you.

Matthew Fassler

executive
#32

Thank you.

Ravi Shanker

analyst
#33

That does conclude our session.

Read the full transcript via the API

You're viewing the first half of this call. Get the complete XPO, Inc. transcript — plus 252,000+ transcripts from 12,000+ companies, speaker segments, AI summaries and full-text search — through the EarningsCalls.dev API.

Get the API View API docs →

This call discussed

For developers and AI pipelines

Programmatic access to XPO, Inc. earnings transcripts and 252,000+ others is available through the EarningsCalls.dev REST API. Plans from $24.99/month — full transcripts, speaker segments, full-text search, and the recently-added /api/v1/transcripts/recent polling endpoint for ETL pipelines.