Skip to main content
ganesh_n
ganesh_n
Feb 22, 2016 8:37 AM UTC
Solved

Order count by Basket Size

Hello,

I am working on gathering stats for Performance Testing from historical data through Adobe Analytics. As a key input, we need number of orders grouped by the cart size, like out of 10000 orders placed in a day - 6000 are placed with 1 Item in cart, 3000 with 2 items in cart, 800 with 3 items in cart and 200 with 4 items in cart.

I am unable to pull this information. Can you please help me with a resolution? Thanks in advance.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ryanpraski
ryanpraskiAccepted solution
Level 4
Feb 22, 2016 3:33 PM UTC

Hi Ganesh,

You can run a data warehouse request with Purchase IDs as your standard Breakdown and Units as your metric. You can then apply the cart size groupings that you want in Excel to your Purchase IDs.

Best,

Ryan Praskievicz

@ryanpraski

View in thread

3 replies

ryanpraski
ryanpraskiAccepted solution
Level 4
Feb 22, 2016 3:33 PM UTC

Hi Ganesh,

You can run a data warehouse request with Purchase IDs as your standard Breakdown and Units as your metric. You can then apply the cart size groupings that you want in Excel to your Purchase IDs.

Best,

Ryan Praskievicz

@ryanpraski

Translate
ganesh_n
ganesh_nAuthor
Feb 23, 2016 2:00 AM UTC

Thanks Ryan.

I am using Discover to pull this data. Is there anyway I can get this in Discover as I am not sure where to run the DWH request.

-Ganesh

Translate
TanmayMathur
Adobe Employee
TanmayMathurAdobe Employee
Adobe Employee
Feb 26, 2016 10:30 AM UTC

Hi Ganesh,

You can go to the DWH request manager by clicking on the 'stack' icon on the top left of the analytics interface. Create your own DWH request there as described by Ryan and it would be good to go.

Thanks!

Tanmay

Translate
Terms & ConditionsAccessibility statement

Loading footer...