Skip to main content
Solved

Supressed profile report?

  • July 26, 2024
  • 3 replies
  • 96 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
    • 384 replies
    • 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
    • 25 replies
    • 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
    • 384 replies
    • 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/


    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.