Data warehouse reporting

Avatar

Avatar

Francis_Lemin

Avatar

Francis_Lemin

Francis_Lemin

09-11-2020

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

 QuoteCheckoutOrderMobile DeviceBrowser type
customer 1100Apple iPhoneApple
customer 2111Huawei P30Google
customer 3100Samsung GalaxyGoogle
customer 4111Samsung GalaxyGoogle
customer 5100Huawei P30Google
customer 6110Apple iPhoneApple

 

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

 

Thanks

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar

ishans52004352

Employee

Avatar

ishans52004352

Employee

ishans52004352
Employee

10-11-2020

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...