Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Data warehouse reporting

Francis_Lemin
Level 1
Level 1

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

 

2 Replies
ishans52004352
Employee
Employee

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
Level 1
Level 1

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?