Contributor IV

Solved

Get average, statistics from Database for single customer and sorting

Forum|Forum|4 years ago
September 1, 2021
7 replies
177 views

Hi,

I have integrated klaviyo with our custom laravel database.

We excluded orders and using only products(ordered product, fulfilled product, refunded product) and i explored in klaviyo but im not sure where/how to get a stats of a customer(eg:avg value purchased by customer) and sort customers in the way of highest purchaser to lowest etc..

Can you please advise on the above.

Thankyou

Analytics

This topic has been closed for replies.

Best answer by stephen.trumble

Hey @Vijay

It is so great that your custom ecommerce integration with Laravel is set up! Happy to help!

Since you have the integration setup, make sure you have the Server-Side Track API set up properly. This is the recommended way for you and others in the Community to programmatically send data on purchase information in your custom integration.

Then you can manage your metrics from the Analytics tab on your Klaviyo Dashboard. If you open one of your metrics such as “Ordered Product” you can click the Best People tab at the top right of your dashboard, and it will sort your customers based on that metric.

I hope this helped clarify how to find the metrics you were looking for and gave others in the community helpful information if they are looking to do the same! Thank you for being an engaged member of the Klaviyo Community, we appreciate you!

stephen.trumbleAnswer

Klaviyo Alum

Hey @Vijay

It is so great that your custom ecommerce integration with Laravel is set up! Happy to help!

Since you have the integration setup, make sure you have the Server-Side Track API set up properly. This is the recommended way for you and others in the Community to programmatically send data on purchase information in your custom integration.

Then you can manage your metrics from the Analytics tab on your Klaviyo Dashboard. If you open one of your metrics such as “Ordered Product” you can click the Best People tab at the top right of your dashboard, and it will sort your customers based on that metric.

I hope this helped clarify how to find the metrics you were looking for and gave others in the community helpful information if they are looking to do the same! Thank you for being an engaged member of the Klaviyo Community, we appreciate you!

-Stephen

V

VijayAuthor

Contributor IV

Hey @stephen.trumble ,

Thankyou for your reply, yes it shows the users list based on Counts and Value.

However as mentioned in the document link you have shared i don’t see ‘Export to CSV’ option under Best People.

Also when i click the column to change the sorting(asc/desc) it doesn’t load accordingly(the order remains same)

-VJ

stephen.trumble

Klaviyo Alum

Hey @Vijay,

From the main screen of your chosen metric, you can choose to export that specific metric with profiles to a CSV, you can then use Excel to sort and rank your customers if you would like to.

Hope this helped!

-Stephen

V

VijayAuthor

Contributor IV

Hi Stephen,

Yes, but its only visible in “Charts” section and not in “Best People” section. Please check attached screenshots for reference.

-VJ

stephen.trumble

Klaviyo Alum

Hey @Vijay

I am so sorry for my confusion. You are 100% correct that you cannot export “Best People” from a custom report. Unfortunately at this time it is not possible to do this with custom reports from Klaviyo. However you can use REST API to export data from Klaviyo and import into a third party analytics tool to accomplish this. I will share this feature request with our development team for them to take a closer look at. If there are any product updates that will allow this functionality to work within the Klaviyo Dashboard I will update this thread!

Thank you again!

-Stephen

V

VijayAuthor

Contributor IV

Thankyou @stephen.trumble

-VJ

stephen.trumble

Klaviyo Alum

Hey @Vijay

Absolutely my pleasure! And I will keep you update if there is any new information. Thank you so much for contributing to the Klaviyo Community, we appreciate you so much!

-Stephen

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials