Forum Discussion

Batten_Company's avatar
Batten_Company
New Member
2 years ago
Solved

Market Study Brand Funnel

Dear all,   my colleague and I are currently working on creating a report to visualize the results of a market research. In this report, we want to show a brand funnel covering the steps awareness,...
  • Ritaf1983's avatar
    2 years ago

    Hi Batten_Company 

    Based on the provided description, it is difficult to understand what you are trying to achieve and what the goal is.

    In order to make it easier to advise on which visualization to choose, I would appreciate the following clarifications:

    • What exactly are you measuring at each stage of the funnel? (Quantity of something, time, something else?)
    • Is the comparison between brands or are you looking at each brand separately?
    • Who is the audience for this report?

    I would also recommend attaching a sample of the data or a link to the PBIX file.

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi again Batten_Company 
    You should bring this table to the form :

    BrandFunnel stageQTY
    aAwareness

    10

    aConsideration8
    aPurchase5
    b.......
    b.... 
    b... 
    .....  

    Create a simple ranking chart like mine on the attached picture (+ filter/slicer for selecting a brand)

    In your case, the KPIs will be the stages of your funnel.
    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly