Skip to main content
M
Problem Solver I
Mathilde
Problem Solver I
March 7, 2025
Solved

Query Metric Aggregates Endpoint for Back in Stock Reports?

  • March 7, 2025
  • 4 replies
  • 110 views

Hi :)

I want to pull data for “Back in Stock” and Back in Stock reports are not flexible enough to get the data in the way I need.

I'm thinking about using the Query Metric Aggregates Endpoint instead. Does anybody know if that’s possible?

I want to create a daily report for the Products team that shows how many products and which SKUs were added each day.

I'm looking for a hint, as I've never tried this before.

Thanks!

/Mathild

    Best answer by Byrne C

    Hey again ​@Mathilde,

    I looked into this, and looked through our API endpoints to see if we have any endpoints that you could use to pull this information. At this time, there isn’t a method to pull that back in stock data out of Klaviyo via API. That being said, I definitely see how this would be useful, and I’m happy to reach out to our product team and recommend that we implement this in the future.

    -Byrne

    4 replies

    Byrne C
    Community Manager
    Byrne C
    Community Manager
    March 10, 2025

    Hi ​@Mathilde,

    While I don’t believe this is possible through the Query Metric Aggregates endpoint, I’m happy to look into this for you. Would you mind describing in a little more detail what you’re looking for, that our back in stock report doesn’t provide? You do have the ability to schedule a report to send to somebody each day, which should show you the number of products added and the SKUs of those products. Were you looking for the data to be presented in a different way, or for some data that our scheduled reports don’t have? I can reach out to our engineers to see what our options are!

    -Byrne

    M
    Problem Solver I
    MathildeAuthor
    Problem Solver I
    March 11, 2025

    Hi Byrne,

    Thank you for looking into it :)

    I would like the report to include SKU, Queue, Moved to next step, Cancelled, Last Added.

    Most importantly I need to determine the date periods (not only predetermined aggregate periods).

    Preferably this would simply be available in the portfolio, so I don’t have to monitor 11 accounts :)

    Also, I am really missing an option  to cancel products manually, as the overview can be cluttered with tests and excluded products.

    /Mathilde

     

     

    Byrne C
    Community Manager
    Byrne CAnswer
    Community Manager
    March 19, 2025

    Hey again ​@Mathilde,

    I looked into this, and looked through our API endpoints to see if we have any endpoints that you could use to pull this information. At this time, there isn’t a method to pull that back in stock data out of Klaviyo via API. That being said, I definitely see how this would be useful, and I’m happy to reach out to our product team and recommend that we implement this in the future.

    -Byrne

    M
    Problem Solver I
    MathildeAuthor
    Problem Solver I
    March 20, 2025

    Hi ​@Byrne C ,

    Thanks for that! Hope there will be a future solution :)

    /Mathilde

     

    Terms & ConditionsAccessibility statement

    Links & Resources

    Platforms

    Partners

    Useful Things

    About

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