Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Data warehouse reporting

Avatar

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

 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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

 

View solution in original post

2 Replies

Avatar

Correct answer by
Employee Advisor

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

 

Avatar

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?