Blog > Reporting

Executive Reporting

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.

  • Communicate important business information
  • Easy-to-use data import
  • Identify strengths and weakness of your business
  • Make the right decisions
100% FREE - No Credit Card Required

What is Executive Reporting?

Executive reporting is a tool that gathers real real-time data from multiple sources and presents it to company executives in a visual format so quick data-driven decisions can be made.

Why use Executive Reporting?

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.

What KPIs should Executive Reporting Include?

The Most common KPIs to include in Executive Reporting are:

eCommerce 

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 

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

Marketing

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

Social media

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

Finance

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

Product 

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

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

Two Simple Steps to Setting it up with Lido

After creating an account in Lido, you are now only two steps away from seeing your data real-time:

Step 1: Connect data sources to Lido

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.

Step 2: Set up the report dashboard

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!

Click the Button Below to Try Lido for FREE!

  • Communicate important business information
  • Easy-to-use data import
  • Identify strengths and weakness of your business
  • Make the right decisions
100% FREE - No Credit Card Required