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

Avatar

Avatar
Level 1
Francis_Lemin
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Francis_Lemin
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
Francis_Lemin
Level 1

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
Give Back 10
Employee
ishans52004352
Employee

Likes

149 likes

Total Posts

297 posts

Correct Reply

98 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
ishans52004352
Employee

Likes

149 likes

Total Posts

297 posts

Correct Reply

98 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
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...