Transforming data into value with MBI
By now most businesses understand how important it is to collect and analyze data to enhance a customer’s shopping experience and inform strategic business decisions. In order to harness your data’s true value, you need the ability to centralize and manage data which can sometimes be a challenge.
In this webinar we discuss how you can get the most out of your commerce data using Magento Business Intelligence (MBI). MBI is a cloud-based data management and analytics platform which provides you with the ability to easily consolidate and manage your data sources, model your data, create charts and reports, and maintain a single source of truth.
You will hear from Daniel Rios (Senior Manager, Product Management) who will be covering the following topics:
- Transforming data into value
- Building a strong data foundation
- Combining MBI and Analytics data
You will also see a live demo of the platform to bring these concepts to life.
MBI simplifies reporting with dashboards displaying everything from average order value to customer lifetime value and retention rates. With these powerful insights, you can be empowered to take action and drive incremental value for your online business.
Good afternoon, good morning all, thank you for joining us. This is the sixth in our APAC webinar series, Commerce webinar series, so we’re excited to have you on the call today. Thanks for joining us. Today we have an exciting webinar topic of MBI and we’re going to be talking about how you can leverage the platform to uncover insights about your customers and your products and really get under the skin of your website performance. We’ve got Daniel Rios joining us who is the senior manager for product management. He’s dialing in from Austin, Texas, so really excited to have you here Daniel, thanks for joining us. Glad to be here. Thanks Daniel, so if you could post any questions that you might have as we’re going through the presentation and demo into the chat and we will aim to answer those questions towards the end, that would be fantastic. We’re also going to have a few polls as we go through, so please submit your feedback in those and I’m going to, with that I’m going to hand over to Daniel. Thank you very much Sophia. Let me just go ahead and start sharing here. All right. And before we begin, we’ll go ahead and put up a poll I believe, Erica. Give people a couple, give people a minute or two just to go through and answer to the poll and then we’ll go ahead and get started here quickly.
Great. And we’ll go ahead and get it, go ahead and get started here. All right, so on the agenda for today, we’re really going to cover over kind of over six sections. The first section is really transforming commerce data into value. Then we’ll go how MBI supports kind of that mission. Then we’ll go into kind of a question that we’ve been getting a lot is what is the difference between advanced reporting and MBI? And we’ll cover and go over between those two. Then I’ll jump into a demo of MBI and kind of do a high level demo of what becomes available in MBI itself. And then we’ll kind of talk about MBI plus Adobe Analytics. It’s not a versus, but it’s actually plus. So those two, really those products working together. Then I’ll put up a slide for additional resources so that anyone wants additional resources to our some available. And then we’ll go into a Q&A session towards the end. All right, so why don’t we go ahead and get started. So when you transfer your commerce data, it’s really, you know, it tells a story. Data is really available and it really needs to be transformed into something useful in order to be able for that to be able to happen. Just having data doesn’t really do you any good, but really being able to tell stories from this data and really transforming from data to a story to tell and not just a story that is just simplistic in nature, but really being able to give kind of an insight or being able to share that story with others is really where we need to achieve that in transforming our data into being able to tell these stories. And when we talk about a storytelling, we really look at it from a maturity model. And there’s really four phases of this maturity model of storytelling. The first phase is kind of uninspired. We think of uninspired, it’s a very blasé statement without any kind of numbers behind it or without even really telling the story. In this example, it says it looks like sales are growing or revenues are increasing. Really it’s just a statement. The next level kind of in the maturity model of storytelling is kind of really being reflective. And we think of reflective, it’s kind of looking at things that have happened. So you could say, in last month, our revenue went up 15%. It just tells a very, very flat story in itself and just giving a number and then really being just able to say a simple metric in that number. When we look at the next level of maturity level in storytelling, we look at a compelling story. This is when we start really driving more and more availability into insights. So an example of this is looking at week over week trends or month over month trends of revenue or other KPIs that are really important to you. And basing those in comparison to a campaign that was run so that you really can drive and tell a story, not just as we said before, an uninspired story, which is just basically sales are growing or a reflective where sales went up 15%. But in here, we’re saying the trend overall is the build up and really compelling to really be able to analyze an action based upon a campaign in itself. And then at the highest level, when we look at storytelling maturity models, we’re looking at rich stories. And these are really being able to draw a picture, really being able to drive something beyond that. So in this example, you have based upon the 30 day lifetime build of the customers we acquired from the SHR campaign, it has an ROI of 35% after factoring returns and canceled orders. So you can see the richness of the data really starts to drive and that there’s more data available to really tell a compelling story to really be able to draw insights. So how do we now compare this storytelling kind of this maturity model into our commerce reporting framework? You know, when we look at kind of the uninspired, really that leads digital commerce teams up in the dark. Really the data is informal. It’s restricted data access. It’s a static. It’s non-recurring. When we go into the reflective area, digital commerce teams are now starting, are still dependent upon other teams, really being able to give them the data itself. It’s very templated, what are the capabilities that they have? It’s a kind of a manual process. We start to see a little bit more of this data become available, but it’s still very limited. When we get into this kind of proactive view, it is now barely really becoming compelling. Digital commerce teams are really becoming self-sufficient at this time. They get access to their data. They really are able to be very flexible in their reporting and they can provide some automation, not just manual processes. And then when we look at rich digital commerce teams, they really are becoming fully empowered because they have the ability to not only be insightful, but they also are able to build customizable reports. They’re able to augment their data. The data is democratized, so it is available. And they’re able to share this data with other teams and really being able to drive that. So we’ll use this model continuously when I speak about MBI and when I speak about different aspects of reporting that are available for Adobe Commerce in itself. So really, how do you really drive teams to reach that higher levels in the reporting framework? By having that data available, by breaking down those silos. And really that’s one of the missions that we have for MBI in itself. It’s really being able to support that and empower digital commerce teams to be able to write customized reporting and tell rich stories based upon their data in one physical location from multiple data points into a single data warehouse in itself. In order to really get the most from your commerce data and utilizing MBI, really MBI was built for capabilities built for Adobe Commerce. It replaces the manual work with automation so that you’re able to build out reports in an automated fashion that you don’t have to change because the data flows in for you. There’s no work that you need to do because the data comes in for you into the product itself, but you also control the data that you bring in. There are pre-constructed analysis that are provided on day one. So you have these four dashboards based upon products, orders, customers, and an executive summary. That information is given to you on day one in a pre-constructed out-of-the-box dashboards that are also comprised of over 75 reports. And we’ll go into more detail about what’s given in those out-of-the-box dashboards from day one. You have ability to really customize your entire account. You really have this ability to go in there and drive whatever levels of customization that you want, but you also have controls so that you can control who sees what data or who can share what report or the level of access on a per user basis in itself. And of course, this is all based on a modern cloud-based SaaS platform. So it’s available to you everywhere. Log in via URL, cloud-based, so you can get to your data, you can get to your reporting from any location that you’re at in itself. So let’s dive in a little bit further. I started talking about those out-of-the-box commerce reporting that we started at the beginning. And really, this is just a starting point to give you the customer a way to look at your data in a visualized way to start you on your journey of really building these compelling stories. These dashboards, as I said earlier, are built around four major pillars, the first being the customer, the order, the product, and then an executive summary. These pre-built reports have metrics already available that are brought in from your Adobe Commerce database, which is already synced into MBI. You can then customize everything within the account in itself and really make it yours, really being able to drive over what it is that you need to see or what type of analysis you need to build. You also can customize it upon the data that you bring in into yourself. So really, this out-of-the-box commerce reporting framework allows you really to be the driver and really be able to drive this portion of it. It is fully integrated, as I said earlier, and synced with the Commerce database. There is no work. This is a managed service for you once this is set up. Data is replicated into MBI from your Magento database, excuse me, from your Adobe Commerce database directly into MBI itself, and then that data is made available for all those people who have access to MBI itself to build these reports or possibly only have access to reports that have been built for them. Like I was just saying, you can stay in control. You set how frequently this data gets auto-updated for you, whether it be every day, every four hours. This data will completely refresh with no work needed to be done by anyone. So this allows the Commerce department to be really self-sufficient in being able to use this tool in itself and being able to bring data into just this one singular reporting tool. And as we said earlier, it is always accessible by being browser-based user interface in itself.
So really, to empower digital Commerce teams, we look at this information and we talk about what becomes available. And really, you are able to augment your reporting. You layer on data not only from your Commerce databases, but also being able to bring in third-party data via integrations and API or being uploaded directly into the product itself. So this allows you to really get all your different data silos, break them down and bring them into one singular location so that your analysis can be built out from the singular reporting tool. You have unlimited capacity to really create new metrics, reports, and dashboards. There is no limitation upon how many reports or dashboards you build or how many metrics you bring in or how many metrics you build yourself. There is no limit to this. So you are able to really look at it from yourself to build out what it is that you need. We have a powerful visualization library with up to 16 visualizations that are made available, whether it be a bubble chart, a bar chart, a line chart, pie charts, or any type of other visualizations inclusive of heat maps to really be able to tell your story driven within the UI itself. You can democratize the data so you can send whether you give different people user logins, various user logins. Within those user logins, you can also really limit, you can limit the accessibility based on various permissions. Some people may have read only access. Others may be able to have edit access. Or you have the superpower being an administrator and being able to control all facets of it. But not only that, if you don’t want to necessarily give anyone a login, you also can schedule reports to be sent via email and leverage that additional collaboration options that is had within the product itself, including an export API to send data to other systems if needed be.
So that was kind of like a really high level overview of MBI. I’ll drive a little bit more about the product itself and via demo. But before we get there, let’s talk a little bit about some of the reporting capabilities that are available within Adobe Commerce. One of the questions that we get a lot is, hey, I have advanced reporting that’s free within Adobe Commerce. Why do I need MBI? So let’s take a look at what is the difference between advanced reporting versus MBI.
So going back to our Commerce Framework maturity model and itself, advanced reporting really is giving someone ability to look at a snapshot at point in time. It’s kind of between this informal area where digital commerce teams are still dependent or in the dark because what they have with advanced reporting is a visualization tool that does not allow any customization. It’s actually built pre-built. It shows you metrics, key metrics in a dashboard to allow you really to give a quick insights and view into that. Whereas MBI really fits more in this repetitive or proactive portion of the maturity model in that it really empowers commerce teams to really drive their own self-sufficiency to build their own reporting and build out customizations within the report or build out their own visualizations and not tied to a singular view of the data itself.
So this is a very long list of capabilities between the two. But I’ll go over a really high level about what’s available and what’s not. If we look at kind of our campaign analysis, part of advanced reporting does contain a coupon code analysis. But with the ability of MBI, you also can analyze those coupons impacts on an acquisition or a retaining of customers. You can do free shipping thresholds. You can do your marketing ROI. You really are empowered to be able to drive and look at variations of your analysis for a campaign. If you’re looking at a business performing analysis, advanced reporting gives you a view into kind of those high level tracking goals or actual metrics such as revenue, orders, into that capabilities. But it really limits that view and gives you just that snapshot over a period of time. Whereas within MBI, because you have availability to all the data that’s available within the commerce platform itself, you’re able to build year over year comparisons or month over month, week over week. You can analyze order returns. You can look at your inventory levels. You can report on a retail calendar. It really allows you to really drive more analysis and empower yourself.
And it goes on further, you know, where we get in advanced reporting, we get that analyzing of that customer repurchasing behavior because we are seeing it within a visualization within a dashboard. You know, the key takeaway here is advanced reporting is meant to be viewed if you needed a quick picture of a dashboard that has been pre-built based upon the data that you have into a already pre-built dashboard. Whereas MBI allows you to not only take in this pre-built out of the box dashboards that have been created, but also lets you look at bringing in additional other additional data. Being able to customize and build your own visualizations or customize the visualizations that are already there and reports, and also being able to share this information. So it really is a full business intelligence tool in order that it brings in data from different data sources, inclusive of your data within commerce. It allows you to build dashboards and reporting at an unlimited number of them and then build that visualizations and analysis to really find those deep nuggets that you need in order to run your business. It is very operational reporting because you’ll have actual revenue made available to you whether they’re returns, refunds, cancellations, or anything else. It also helps you to drive down what also is available within your data, such as sales tax, or if you have multiple currencies being able to deal within multi currencies in itself. So really when we look at these two, as I said earlier, advanced reporting is kind of that simple visual into your data, whereas MBI allows you to really analyze and build insights and become empowered as a commerce team. So let me take a break here to show you what MBI really looks like and do kind of a quick demo of MBI and its various parts of it. Let me share over here. So here’s MBI in itself in the UI. When we look at MBI, those dashboards that I talked about, well, here’s one of those and it’s the executive summary dashboard. As you can see, you could have everything from a scaler, which is essentially just a snapshot over a period of time, or you can build out a bar chart over a period of time that allows you to see the different revenue points as you go over. As you can see in this executive summary, we’ve built out for revenue, your orders, and then really your registrants or your customers to really build out those that are available, getting that insights from day one as your store is kind of put into an implementation mode. Not only that, but we also offer four others in itself. So the customer, in which it really gives you who your customers are, whether they’re orders by new versus existing customers, percentage of conversion from registration to first order, or even looking at the time between your orders, or looking at the lifetime orders by customers, or looking at a lifetime value by first order with a cumulative over average by utilizing a cohort chart in itself. Really, this is all being able to drive visualization, but these are not anything that you have to build. This is actually included in the product itself from day one. When we look at MBI overall, it’s split up into three main areas. It’s dashboards, your report builder, and your managed data. So let’s go ahead and start with managing your data at the very beginning of all of this. So MBI gives you the ability, MBI Pro gives you the ability to bring in integrations. And integrations could be we pre-built the integration with your commerce database itself. We create that for a certain amount of tables and then allow you to see what additional other additional data you want to bring in from your commerce back end. But not only do we integrate to commerce, we also have integrations that are pre-built integrations. These pre-built integrations can be inclusive of Facebook, Google Analytics, another SQL server, MongoDB, or even going out to an Amazon Redshift or Mixpanel or Salesforce CRM. We’ve also have included now of just recently Adobe Analytics and bringing in your Adobe Analytics data into MBI. And I’ll be talking about that a little bit later about what the value that is given there. These are all pre-built integrations that come along with MBI based upon a contract basis. But you can also import, utilize our import API for those areas in which we don’t have a pre-built integration for. And bring in any data via an import API. Or you can upload a file or a CSV directly into the data warehouse so that is also available for you within that portion. So really the goal is to you bring in your data and then you really leave it alone because we’ll do the hard work of replicating your data into your MBI instance in itself. Then being able to bring in all this data allows you to really drive those stories. So whether it be bringing in your Google Analytics data, your Facebook Ads data, bringing that data in along with your commerce data really gives you that visualization of where you are your revenue streams or what’s happening with your behavioral information. And tying that along with your online transactional data that really gives you the full picture of what is going on with your store itself.
So once you built in kind of your have your integrations pre-built and you have that data flowing you can always look at what’s going on within your data itself by looking within your data warehouse. And within the data warehouse I talked earlier about being able to look at data and deciding what data you want to have replicated within your commerce instance. And that’s all controlled through the data warehouse area in which you can set how often or what field even within a table that you want to have replicated within MBI. So now that data becomes available to all users that have access to this data and then they can drive visualizations for this data itself.
Within this area also of the managed data you can view all the metrics. So in here what it’s showing me is being able to see all the metrics that are available. So the metric here is the average first 30 days of revenue. I know that’s coming from this table that I’ve replicated and it’ll show me everywhere where that data report where that information is used within a dashboard or report. So it really gives you that visibility as an administrator to see where all this information is being used and what data is being used and what data is not being used within MBI. So it allows you to keep controls of your information to make sure. In addition there’s a concept called filter sets. Filter sets are the ability to set a metric so that everyone in your company actually defines the metric the same way. So if you wanted to say revenue is calculated utilizing this methodology you can set a metric that’s called revenue and create the definition of that revenue of that metric revenue so that everyone uses the same definition of revenue throughout the product. That way if you have multiple users from different departments trying to figure out what the revenue is everyone’s using the same exact metric and definition of that metric. Now this doesn’t stop people from building out their own definitions that they can do on their own by building a customized metric. But at least you can keep controls and really be able to keep governance within the tool itself. We’ll come back a little bit more on talking about managed data but let’s go on and see where it is that we build reports and how we build reports within MBI. Within MBI there are two ways of building reports and then we have two report builders. We have the visual report builder and we have the SQL report builder. I’ll go over the SQL report builder really quickly and then come back to the visual report builder here. The SQL report builder is really for those advanced users who basically want to write a SQL statement. Within MBI you’re able to use things, able to write SQL code such as select and select the table that you wanted to and then just being able to write a simple query in SQL directly in syntax. It also can be complex queries that are allowed to be done. All of this within the UI itself and then you would see your results in a table format and if necessary and if possible in a chart format based upon the SQL syntax that you have written. So really a powerful tool for those who know how to write SQL and being able to drive some valuable insights and using that as a very simplistic manner really made for the analyst in itself. But we’ve also made a simple library of doing this by using a visual report builder. So in the visual report builder you would choose a metric. So let’s go ahead and choose revenue.
And really the visual report builder that you would choose is the metric. And really the visual report builder then brings it into kind of the visualization section. It has a scaler where it has revenue at this point in time is from January 1st to now is what I’ve kind of preset as my setup here. I have a chart that I can reference and I can change this chart by simply going over here and showing whether I want to go to a bar chart. Maybe it’s column chart. Maybe a stacked area chart in itself. Really very simplistic to add in things. In addition you’ll also see a table version. So in the singular view of the visual report builder you have three different versions of ways that you can look at this data. Once you save it you’ll save it to one of these ways by naming the report. So in this case I’ll just call it test report. And then it’ll give me the option of how I want to say this. Is it a chart? If I want to say the table or if I just want to say the scaler of the number for the revenue in itself. So really giving you flexibility to see how you want to build this. Not only do we have standard reports but you’re also able to build cohorts. I won’t go into cohorts since that’s more of a more advanced topic. But I can tell you we do have webinars in which we do go over the abilities of building up cohorts. And we also have a course that will also help you in understanding how cohort works if you’re unfamiliar with them or how to build them.
In addition within the visual report building you have the capability of duplicating a metric. So I could have two metrics within this thing or I could add a different metric for another source. Or I can also create a conditional metric by adding a formula in itself and then driving a formula. So in this case A plus B would give me a metric in itself and it would give me a calculation if I apply that. It would be the calculation of A of revenue plus B to give you that total revenue. So really you can build your own metrics even on top of that in its sense. You also have the capability of looking at perspectives that are pre-built. So percentage change versus a period of time, a rolling average window. Really the kind of the use cases are endless within it. And you also have time options that you can look at for different metrics that you want to measure upon the times itself. Now these report builder, you know, there’s more about this but I won’t go into more detail about this. As it really has a lot of flexibility for you to build your reports, to build those stories and to tell that visualization story in itself.
And then the third section that we have is really all about dashboards. And dashboards are basically a kind of a pain in order to bring in all of your reports that you want in a singular view so you can tell a story. And it’s really a drag and drop capability of choosing the report that you want to add so you can add a report. It’ll give you a listing of reports and you’re able to add those reports in there and really build dashboards for people to be able to utilize. You then are able to share to users and really select the users and set their permissions whether it be edit, view or none. And none, they really have no capability of doing anything except to just viewing this. In view, they have the capabilities of utilizing some filters and being able to share those, differentiate those filters. So MBI is really helping you transform and build out those concepts and really build out what it is that you’re trying to tell within your story. If I go back to my managed data, other areas within MBI on a more advanced feature are kind of things of call and pass. Which are basically if you know about SQL just joins. So it’s basically joining data, joining two data sets into a singular data set so you can really grow that view of it and really really advance the kind of analysis that you can do. Also we have the capability of creating data warehouse views. In a data warehouse view, it’s kind of a table that is made up of multiple tables into a singular table and it becomes a view. So you don’t have to rebuild this kind of view that you utilize all the time, you have it pre-built for you.
Also within managed data, you have the concept of being able to export data whether it be through an export API or being able to send email summaries and these are scheduled emails that can be sent out with embedded reports directly into the email itself to send out to users. And of course you always have a raw data export if that’s what you find necessary. So really MBI gives you this flexibility of being able to share data with anyone that you want to share the data with. And overall on the product if you look at MBI, we started with what data do I want to bring in and utilize, then building reports around that data and then building the visualization where those reports go into dashboards. And then finally sending that data or sharing that data. So that’s a quick demo of what MBI is and how MBI works and really being able to drive the value of being able to tell the story so that you know what’s happening with your store at any point in time, whether it be in the past or upcoming in the future itself. So let’s go back into kind of our deck here and our presentation in itself.
So we kind of talked about MBI in itself and I kind of mentioned during the demo that we were going to talk a little bit about MBI but as Adobe Analytics. Now I’m very careful to say MBI plus Adobe Analytics and not versus Adobe Analytics. And I’ll explain what I mean by that here shortly and how they are really work together rather than our replacement for each other at all. Again when we look at a whole maturity cycle of this, if we look at MBI plus analytics, it really brings in this richness or this insightful. Now explain how we’re really getting to driving now to that to really drive this whole picture of it.
Really when we talk about data and different shopping data at different level, MBI is meant to really look at your kind of your commerce intelligence. What is your actual revenue? Tell me what my actual revenue is. Tell me what my merchandise. Tell me about my product lines, my SKUs. Show me how this merchandise is performing. What are my promotions? How are my promotions doing? Whereas Adobe Analytics is customer intelligence. It’s really based upon what’s happening in the storefront. So helping understand what is working or not working for each customer. Help me create better targeting to create a customer cost channels. Help me to build segments so my customers so I can build out these richer segments in itself. So as you can see these are really two products that coexist with each other rather than are against each other. Whereas commerce intelligence with MBI is really operational data. Adobe Analytics is customer intelligence or behavioral data. You put these two data points together and you really drive this entire loop of information of data that is shareable.
So you noticed earlier I talked about bringing Adobe Analytics data into MBI. Just this month we just released the Adobe Analytics integration into MBI where you can bring your analytics data into MBI so that you have another data source within MBI to really look at your full customer. And so now within this kind of the full picture you now have transactional data which is what was always kept within MBI. But you can now bring in that behavioral data of what happened on the site. What did my customer do within my site? Where did my customer drop off when they were purchasing something? If it was an abandoned cart what really happened to that? If I was looking at it just from a lens of analytics I would never know what my refunds were or what my cancellations were of a product. Because analytics is a behavioral storefront view of the data. MBI is an operational view of the data. You put these two sources together and you’re able to have a full and complete picture of both areas.
With e-commerce data sales is accurate. With analytics you’ll have a 10 to 30 percent possible drop off because of ad blockers. But within MBI because we bring in data directly from the back end you’re able to see your actual revenue not impacted by ad blockers in itself. We have increased fixability. With Adobe Analytics it has a deeper way to integrate with MBI whereas Google or Google Analytics really has some limitations. And with the end of life of Universal Analytics in itself and having to rebuild your schema it really drives more of the availability of utilizing Adobe Analytics with MBI in order to really drive that full picture. Enhanced metrics and dimensions. Specific dimensions and metrics from analytics are now easily being able to leverage within MBI itself so you can build out these different reports. I kind of talked about you know where did my customer, what did my customer view? What was the products they viewed? You now have that information to see what is driving conversion. So at the end of the day with these two data sets we’re able to drive kind of this whole picture of conversion in itself. And because we built this integration with analytics and MBI and using both of these it really cuts down on integration time to bring in this data. Because it’s a very simplistic way just like all our other integrations to really bring in all this information into MBI so that you can really build out those full insights.
By combining both Adobe Analytics data to really bring out this rich view. You’re seamlessly bringing together like I said your analytical behavior data with your commerce sales. You’re able to uncover shoppers’ trend and dive deeper into the customer behavior and really see what ended up happening. And you can further enhance existing reports with updated metrics or dimensions. So it’s not only just bringing in all this data to a singular point but it’s really giving you a full picture and view of this.
So I kind of went over quickly on kind of the whole picture and overview of MBI in itself and kind of what the capabilities of MBI. Really MBI was built as a tool for Adobe Commerce. It was built to integrate directly to Adobe Commerce and give you the customers from day one insights into your data without having to do without having to do any work but being very minimal on the amount of IT work that needs to be done. Because we handle the heavy hands of bringing the data in, replicating that data consistently in itself. MBI, your data is safe within MBI because each instance it’s a separate data warehouse. There is no cross-bleeding of data because your instance is your own data warehouse within MBI. Your data is completely siloed to that instance itself and to that warehouse in there. You control the data that you can want to bring into MBI. We don’t force data to come in. You can stop flow of data or you can add additional data. It doesn’t have to be just commerce data. It can be third party data that you’re bringing into MBI via pre-build integrations or via a custom API. Then we let you go and do your imagination as you will by building out your reports and dashboards so that you can really see the value of what your store is doing. And for those aha moments, if there’s any issues, which I’m sure there won’t be any issues with your store, but in case there are, you’re able to drive these insights and view where that is also. And at the end of the day, being able to be operational, whether it’s whatever KPI you’re trying to measure against, you have visibility into that KPI to trend and view over periods of time and break it down, whether it be breaking it down by a campaign or breaking it down by a coupon code, if you have coupons. Really looking at the insights and looking at your data, not just from where your data sits, but being able to drive those visualizations, to be able to tell that story with your data. Now there are additional MBI resources.
There are some recorded webinars. There is an introduction to MBI video series. And just this past week, we introduced Adobe Digital Learning Center MBI course, which is now available with a commerce subscription to Adobe Digital Learning. And that course is an 11-unit course to really give you more information to it so that you can self-serve and learn more about MBI on your own without needing anyone there. It’s a self-serve course that has tests at the end of it. So you really have an understanding of what you’re learning. And it’s built into different sections of MBI. So if you really don’t want to look at one aspect of visual report building or really going to advanced report building, all that is available within this single course.
All right. And that’s what I got for you today. And I’ll turn it back over to Sophia for any questions that we have. Thanks, Daniel. That was fantastic. And really good to hear about that new course that’s been made available in Adobe Learning. I did actually post the link to that in the chat for anyone who’s interested to have a look at that and find out a bit more. That’s really great to see. We do have some questions. So the first one is, how would MBI help to give data meaning for B2B businesses that might not have very many transactions? Yes. So we do have capabilities of going to the B2B and really looking at your order requisitions and seeing how your order statuses are going or where you might possibly have some stoppage within your B2B process in itself. Or your leads. Did we have a problem with our leads or did we need to really look at a product in itself? Inventory levels. Were there issues with inventory levels so we weren’t able to fulfill certain quotes? Or really, where did the quote stand? Where did your quote end up at in itself? With the capabilities of going back, it’s not only for a B2C view, but it’s also for a B2B view going into the data commerce tables themselves. Excellent. Great. So it’s very much kind of operational troubleshooting and visibility into those operational stats. Correct. We have another question around the data center for MBI. I think you touched on the data being safe within MBI. Could you maybe talk a bit more about the data centers that hold the information? Where are they? What are they? So we have two data centers that are currently one is located in the US and one is currently located in the EU. Depending upon your location is where your data would live within that within that region itself. We also store the data within AWS and it’s either for those little bit more technical, it’s either a Postgres or Redshift warehouse in which this data is stored depending upon the amount of data that you have in itself. And there’s another question here about availability of MBI to on-premise customers. So the assumption is that it’s available for all customers. You don’t have to be on Adobe Commerce Cloud. That is correct. It’s available for on-prem or Adobe Commerce Cloud customers. With on-prem, there’s a little bit more on the onboarding portion of it because your databases are on an on-prem basis. But it is still usable within both. Perfect. And another question here. Can we connect MBI with staging and production databases and what are the pros and cons of doing that? That’s a great question and it’s kind of a tricky question there. So yes, you can put your single instance of MBI to both staging and production. The cons are with the with the pros of it. Pros, it gives you availability to look at your data early on from your staging to build out reports that you can then utilize and test out the reports in itself before you go into production basis. The cons of it is you’re now pointing your reports to a staging environment and you have to be careful with naming because when we replicate data to the back end, it becomes as the source of the data what the name of that data table was. So you really have to be careful on the appropriate naming of your table so you differentiate and your users can differentiate between staging and production tables. So that’s really the largest con in itself. It’s really being able to do that data cleanse it. Clarity. Sure, that makes sense. And there’s another question here around exporting MBI data. So if we wanted to export data for use in campaigns in Mailchimp, what would be the best way to do that? You can either do it through an export API, which would be a direct report. So if you have a single report that you’ve created, that report can be done via an export API or you can do a download an export file and then upload that file within there. Both are capabilities to be able to be able to use. Great. That’s all the questions that have come through so far. If anybody else has questions, oh, we’ve got one more. Apart from analytics, are there any roadmaps to connect it with other Adobe products? Right now, the biggest value that we saw within Adobe Analytics at this point in time is really bringing that behavioral data into MBI so you can really have that full view of transactional and operational data. Transaction on behavioral data. At this point, we have not taken into consideration of bringing other data. It would be great to hear of some use cases that people would have of bringing some other products data into MBI and more than willing to listen to that to see. Cool. Thank you. Okay. What could be the best way to see dashboard for a particular currency? This would be mainly for websites that have multi-store views. Yeah. So with currency, there’s different ways to handle currency. You can either do a conversion to a singular currency and show that singular currency along with the multi-currencies within a single report. Typically, what we say is to convert to a single currency for being able to see the full view of an entire report so that we could see the final data points in itself. But if you also need it within that report to have the original currency, you could have the original currency in that report itself also. But typically, we would say to convert to a single currency. And that is available to do within MBI. Excellent. We’ll see if any more questions are coming through. I’ve got one. What would you see as the benefit for Adobe Commerce customers to leverage MBI over something such as Power BI or Tableau? Is there much difference? Is there a benefit there for them to use MBI rather than one of these other similar tools? Yeah. With MBI, we have the direct connections into commerce. We already pre-built those for you. So the lift is already taken care of. We understand the data that is within Adobe Commerce. So we pre-built these integrations and these out-of-the-box dashboards really to differentiate it from that perspective. And really, MBI is really meant to be a tool to use with commerce. Other tools are meant to use any other product. This is really a concentration on commerce itself. Yeah. Excellent.
All right.
I think we’ve got a few posts. I just have one question. Sorry. Sophia from a customer and I apologise to anyone who can’t submit questions in the chat. But the question from the back is, can you pull data from Google Sheets on a schedule? Oh, on a schedule from Google Sheets. That one I don’t have a direct answer for, but I could get back to you. Typically, through a spreadsheet, it would be just an uploadable file which aren’t done on a scheduled basis. It’s just a simple upload of that file itself. I was trying to think if there was a way to utilise an import API in order to refresh it coming back or to write something within R in order to utilise the import API to bring that data in. There isn’t anything pre-built within the system itself, but there might be a workaround that some of my analysts have figured out on their own, as they’re kind of subject matter experts on the product in that sense. But out of the box now. All right. I think we’ve got a few polls as we’re wrapping up as well. So we’ll launch those shortly and maybe I’ll just talk about just a few updates on the series in general. So we’re taking a break in November and December. So there won’t be any webinars for the rest of the year, but we will be back in early 2023. We know that November, December is a busy time for everybody. So we’re going to take a small break, but yeah, we will be back with more sessions in the new year. If you’ve got any feedback on the sessions so far, we’ve covered lots of topics in the sessions that we’ve had to date since we launched the series in May. We’ve covered New Relic, Site-wide Analysis Tool, Roadmap, Holiday Readiness, all sorts of things. So if you have any feedback at all, anything in particular you’d like to hear about in future, please do let your audience know. And if you’ve got any questions as a follow up to this session specifically as well, please do reach out to your account manager. If you’d like to learn more about the courses or resources available to support you to use this product, please let us know. If you don’t already have MBI, but you’re interested in learning more and potentially purchasing it, again, your account manager is going to be the best person to help you out with those. All right, I don’t see any further questions. So with that, I think we’ll wrap it up. Thank you, everyone who joined and thank you so much to Daniel for joining us from Texas. Good afternoon, everybody. We’ll see you in the new year.
Thank you, everyone. Thank you.