LogoLogo
HomeDocumentation
  • 🐳Using Whaly Guides
  • Core concepts
    • 📚Getting started
      • Data stack architecture
      • Consumers vs Builders
      • Data layers in Whaly
      • License Mapping
    • 🪄Data modeling
      • Understanding data models
      • Designing data models
      • Common modeling patterns
        • Event schema
      • Maintaining data models
      • Data models best practices
    • 🖌️Explorations
      • Understanding Explorations
      • Designing Explorations
      • Maintaining Explorations
      • Mistakes to avoid
  • Training
    • 👁️For viewers
    • 👩‍💻For editors
    • 🧙For builders
      • Setting up the training material
      • Creating a chart
      • Using and editing explorations
      • Filtering a dashboard
      • Creating explorations and models
  • Inspiration
    • 🗒️Use cases
      • Billing / Invoicing
      • Customer success
      • Fundraising
      • Marketing
      • Partnerships
      • Product
      • Sales
      • Strategy
    • 💬Communication
    • 💡Tips
  • Recipes
    • 🤝Customer care
      • How to build a 360° customer dashboard
    • 🏦Finance
      • Modeling your recurring revenue
        • SQL for simplified MRR calculation
        • SQL for advanced MRR calculation
    • 📣Marketing
      • Track your entire Marketing Funnel
      • Calculate your Customer Acquisition Cost
      • Create a partner dashboard
    • 💼Sales
      • Analyze the impact of your Sales velocity on your closing rate
      • Create a sales performance dashboard
      • Build a target oriented sales dashboard
  • Misc
    • 🧐SQL Fanout
    • 📦Backup your data using BigQuery
    • ☁️Embedding reports in Salesforce
    • 👨‍💻Useful SQL operations
      • Flattening categories
Powered by GitBook
On this page
  • High level plan
  • Understanding our partner dashboard
  • Making our dashboard partner ready
  • Adding a sharing link
  • Hiding the partner filter from the report
  1. Recipes
  2. Marketing

Create a partner dashboard

Objective

In every partnership, it is important to share, be it in life, in love or in business. For example, if your company outsources part of its lead acquisition process to external partners, it is important for them to have an overview of how successful you are with converting their leads into deals.

In this guide, you will learn how to structure and configure a partner dashboard that enables you to securely share this information back with your partners.

High level plan

  • Understanding our partner dashboard

  • Making our dashboard partner-ready

    • Adding a partner filter to our dashboard

    • Adding a sharing link

    • Hiding the partner filter from the report

Understanding our partner dashboard

For this guide, we will assume that we have already built our Partner Dashboard, which gives us information about:

  • Our leads conversion funnel

    • Number of new leads received

    • Number of qualified leads

    • Number of converted leads

  • Our partners based generated revenue

  • Our partners commission

You can take a look at our example dashboard below:

Making our dashboard partner ready

Adding a partner filter to our dashboard

To make our dashboard partner ready, we will firstly need to be able to breakdown our view per partner. This steps essentially consists in adding a "Partner" filter to our dashboard, and will allow us to restrict the leads to the partner they are generated from.

Let's get to work. On Whaly, open your partner dashboard, then:

  • click on Edit

  • click on Add a filter

  • select you partner identifier in the "Fields to filter from" list (in this example we will use partner_name) and give your filter a name

  • in the "Tiles to update" tab, verify that the filter is applied to all the tiles you need

Adding a sharing link

We will use the sharing link feature to create a pre-filtered view of our dashboard that we will be able to send to our partners.

In order to do so:

  • Click on share

  • Click on new sharing link

  • Give it a name (we will use "Partner: Duff"), a password if you need to, and select set partner filter value to your partner's name.

Hiding the partner filter from the report

Great, now we have a sharing link. But before sending it, we will probably want to prevent our partner to filter on our others partners. To do so, we will hide the partner filter from the dashboard:

  • Click on edit

  • Click on the partner filter settings

  • Check "Hide your filter from the report" and save

PreviousCalculate your Customer Acquisition CostNextSales

Last updated 2 years ago

That's it, now we can send our sharing links to our partners. They will be able to view the dashboard to gain insights of how the partnership is performing

📣
🎉