Data warehouse reporting

[Francis_Lemin]

Hi apologies if this is a very simple question, 

I'm trying to create a report that displays a number of details about each customer that lands on the site, including how far into their journey(quote, checkout, purchase etc as metrics) but also as much detail regarding each individual(device type, device, carrier type, browser, region etc)

I can find all the relative data in workspace quite easily for a single user, now we want to use data warehouse to export the details for 6 months.

When i try this i am getting a huge amount of data where it is has multiple values for each customer and some of the breakdowns requested are empty depending on which row of data i am looking at.

Is there a simple trick i am missing here or can you direct me to a good tutorial for creating these reports.

I know the customer column is the main issue but i cant add an ID or IP as another breakdown and then dedupe the data as other details would be lost as explained above.  (also I've tried making the segment applied visitor based and that didn't seem to help)

Ideally it would look something like this

	Quote	Checkout	Order	Mobile Device	Browser type
customer 1	1	0	0	Apple iPhone	Apple
customer 2	1	1	1	Huawei P30	Google
customer 3	1	0	0	Samsung Galaxy	Google
customer 4	1	1	1	Samsung Galaxy	Google
customer 5	1	0	0	Huawei P30	Google
customer 6	1	1	0	Apple iPhone	Apple

Also if you have links to any good data warehouse videos or tutorials that would be very much appreciated.

Thanks

[Ishan_Sinha_ · Accepted solution]

I think that's the way Data Warehouse reporting looks like. Data Warehouse gives you access to query the raw data. So, if there is a hit with two dimensions and one of the dimensions doesn't have any value in that hit, it will be shown in the report but with an empty value. It's all about report interpretation.

https://experienceleague.adobe.com/docs/analytics-learn/tutorials/exporting/data-warehouse/introduct...

[Francis_Lemin]

thanks for the reply and the link although i have viewed that already but thanks all the same. so is there no way in data warehouse of grouping a single customers data to one row?