Use Lido to set up Executive Reporting in just a few clicks. Pull in real-time data from multiple sources and visualize it in a customized report so your company executives can track major KPIs for the entire company in a single report.
Show the state of the business: executive reporting will allow you to see the state of the business at a glance and also show how close it is in achieving the strategic goals.
Helps communicate business information: as the most important data is summarized in visual format, it becomes easier to analyze even with those who only have basic understanding of the workings of the business. You can similarly use it to easily communicate the state of your business to your stakeholders and prospective investors.
Identify issues and risks: certain KPIs can help the top brass uncover potential problems in the future, giving them time to implement new measures to prevent them or mitigate their resulting effects.
Help make right decisions: executive reporting helps you get the most important information about your business in a summarized form helps you make the right decisions to further the growth of your business.
The Most common KPIs to include in Executive Reporting are:
Average order value: the average amount spent per order
Conversion rate: percentage of the total number of visits to a website that result in a conversion action
Lifetime value: the total amount of money a customer is expected to spend on your products during their lifetime
Inventory turn: how fast the inventory is replaced over time
Rate of return: rate an item is returned by the buyer
Sell-through rate: compares the inventory that enters your store and the inventory that you sell within a period of time
Bounce rate: the percentage of visitors who enter the site and then leave (‘bounce’) rather than continuing to view other pages within the same site
Click-through rate: number of users who click on a specific link compared to the number of total users who view a page, email, or advertisement
Engagement rate: how actively your audience is involved with your content
Follower count: number of followers of your social media pages
Impressions: number of instances where an advertisement or any other form of digital media renders on a user's screen
Reach: number of unique people who are exposed to an advertisement or social media post
Cash conversion cycle: how long it takes a company to convert a dollar invested in inventory into cash received from customers
Net working capital to assets ratio: how much capital you have at your disposal to invest in the business (or payout to the owners/shareholders) at any point in time
Operating cash flow margin: provides an indicator of how much cash your business is generating as a percentage of revenues
Conversion rate: The percentage of customers who are purchasing the paid version of the product versus the ones using the free version
Monthly/weekly/daily active users: Number of product users over a specific period
Percentage of revenue from new products: total revenue brought in by selling new products.
Customer satisfaction score: How happy the customers are with the product
Net promoter score: How likely your customers will recommend your product to others
Number of support tickets a month: Number of customers requesting product support
After creating an account in Lido, you are now only two steps away from seeing your data real-time:
Click Data on the upper-left corner of Lido to select the source.
Follow the instructions on entering access info and selecting the data columns to import in the Dataset Editor. Once you have finished selecting your data, click Save dataset & edit view in the top right corner. The data is now loaded to your Lido spreadsheet.
Do this again for each aspect of your business you want to include.
First set up the formulas for the KPIs you include. Lido functions are similar to that of Google Sheets, so you can apply to Lido what you have learned in our tutorials.
After loading the data, click the Dashboard on the top of the Lido spreadsheet, then click the Components tab on the right side. Drag-and-drop components and add data to them.
You need to create a new dashboard for each aspect of your business you include. Once you have finished placing the components, click Preview on the upper-right corner to see how it will look once deployed.
Do it a few more times for each aspect you want included.
If you are satisfied, click Share to share your report with others!