Skip to main content
Solved

Supressed profile report?

  • July 26, 2024
  • 3 replies
  • 139 views
G
Active Contributor IV
Forum|alt.badge.img+4

My client's database has a significant number of suppressed profiles in it.

 

I'm trying to create a report or visualize the reasons why people are suppressed, so have they unsubscribed, is it spam complaints, soft bounce, hard bounce, etc.

And I also want to create a plan to prevent or minimize further accounts from being suppressed in the future so that we can maximize our marketing reach.

 

Is it possible to create a suppressed profile report? 

 

And I'll need to see the data before formulating a plan but any insight here would also be very appreciated 

 

Thanks

Best answer by ArpitBanjara

Hey @GV123 

Creating a report on suppressed profiles in Klaviyo involves exporting the list of suppressed profiles and then analyzing the reasons for suppression.

Here's a step-by-step guide to help you achieve this:

Step 1: Export Suppressed Profiles from Klaviyo

  1. Log in to Klaviyo:

    • Go to your Klaviyo dashboard.

  2. Go to ‘Profiles’ under ‘Audience’

  3. Go to View Suppressed Profiles 

  4. Export Suppressed Profiles:
    • by clicking on “Export Csv” (you need to have ‘admin access’ to your account to be able to do this)
  5. Open the csv in excel or google sheets
  6. Use formulas to count the number of suppressions for each reason.  
    =COUNTIF(B:B, "Unsubscribed")
    =COUNTIF(B:B, "Spam Complaint")
    =COUNTIF(B:B, "Soft Bounce")
    =COUNTIF(B:B, "Hard Bounce")

    Select the table and insert a pie chart or bar graph to visualize the data.

By following these steps, you can generate a report on suppressed profiles and gain insights into why suppressions are happening.

I hope this helps

Cheers

Arpit

    3 replies

    ArpitBanjara
    Principal User I
    Forum|alt.badge.img+36
    • ArpitBanjara
    • Principal User I
    • Answer
    • July 26, 2024

    Hey @GV123 

    Creating a report on suppressed profiles in Klaviyo involves exporting the list of suppressed profiles and then analyzing the reasons for suppression.

    Here's a step-by-step guide to help you achieve this:

    Step 1: Export Suppressed Profiles from Klaviyo

    1. Log in to Klaviyo:

      • Go to your Klaviyo dashboard.

    2. Go to ‘Profiles’ under ‘Audience’

    3. Go to View Suppressed Profiles 

    4. Export Suppressed Profiles:
      • by clicking on “Export Csv” (you need to have ‘admin access’ to your account to be able to do this)
    5. Open the csv in excel or google sheets
    6. Use formulas to count the number of suppressions for each reason.  
      =COUNTIF(B:B, "Unsubscribed")
      =COUNTIF(B:B, "Spam Complaint")
      =COUNTIF(B:B, "Soft Bounce")
      =COUNTIF(B:B, "Hard Bounce")

      Select the table and insert a pie chart or bar graph to visualize the data.

    By following these steps, you can generate a report on suppressed profiles and gain insights into why suppressions are happening.

    I hope this helps

    Cheers

    Arpit

    Arpit Banjara - Lead Email Marketing Specialist at Flowium - https://flowium.com/lp/klaviyo-agency/
      G
      Active Contributor IV
      Forum|alt.badge.img+4
      • GV123
      • Author
      • July 26, 2024

      Thanks @ArpitBanjara I will try this out.

       

      Is there a similar method I can use to quantify my new profiles? Or is that a completely different matter?

       

      Thanks again!

      ArpitBanjara
      Principal User I
      Forum|alt.badge.img+36
      • ArpitBanjara
      • Principal User I
      • July 26, 2024

      Hey @GV123 

      For new profiles you can visualize that in Klaviyo itself. New profiles usually go to a list and you can see list growth graphs (example below)

      I hope this helps

      Cheers

      Arpit

      Arpit Banjara - Lead Email Marketing Specialist at Flowium - https://flowium.com/lp/klaviyo-agency/

        Search saves time. Contributing compounds value.

        The ROI of your reply? One helpful answer can support dozens of teams, build your credibility, sharpen your own expertise over time, foster connectivity, and create good karma – because what goes around comes around. The community is what YOU make it.
        Terms & ConditionsAccessibility statement

        Links & Resources

        Platforms

        Partners

        Useful Things

        About

        • Terms and Privacy |
          © 2024 Klaviyo All rights reserved. Klaviyo and the Klaviyo logo are trademarks or registered trademarks of Klaviyo, Inc. or its affiliates.