Discrepancy in Data from Fallout report and Data warehouse

Avatar

Avatar

anshita_savant

Avatar

anshita_savant

anshita_savant

24-03-2017

Hi,

I'm trying to create a report similar to Fallout report which shows number of visitors falling in and falling out at each step. I extracted the data from Datawarehouse as I want the report to be dynamic. There is a big difference in the numbers in both. Can anyone help me figure out why? Basically, I want to create a fallout report from Data Warehouse data with segments on campaign  column and pages column. If I extract unsegmented data it's too large and the extract fails. How do I get the data to match the numbers in Fallout report? Any help is appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Gigazelle

Employee

Total Posts

(val/1000)?string[".0"]}K

Likes

458

Correct Answer

734

Avatar

Gigazelle

Employee

Total Posts

(val/1000)?string[".0"]}K

Likes

458

Correct Answer

734
Gigazelle
Employee

04-04-2017

Clickstream data feeds are a great way to get raw data out of Adobe Analytics. Since it's 100% raw data you'll want a way to filter through and organize that data, though.

Data Warehouse does not have pathing available. Fallout is a type of pathing. For example, a fallout of product page > cart > checkout > payment info > confirmation is going to have much less data than reporting period totals.

Answers (3)

Answers (3)

Avatar

Avatar

anshita_savant

Avatar

anshita_savant

anshita_savant

04-04-2017

Gigazelle wrote...

Clickstream data feeds are a great way to get raw data out of Adobe Analytics. Since it's 100% raw data you'll want a way to filter through and organize that data, though.

Data Warehouse does not have pathing available. Fallout is a type of pathing. For example, a fallout of product page > cart > checkout > payment info > confirmation is going to have much less data than reporting period totals.

 

Thanks Gigazelle. Now I understand the reason for big discrepancy in numbers.

Can you let me know where can I find Clickstream data feeds and the data out of it?

Avatar

Avatar

anshita_savant

Avatar

anshita_savant

anshita_savant

31-03-2017

Hi Paige,

Yeah, I requested the data via email and the FTP request failed.

I didn't notice much difference between Workspace and Data Warehouse but a lot of difference in Fallout Report and Data warehouse.

Do you know of any other good way to extract raw data apart from Data Warehouse so that I can build Fallout report on that?

Appreciate your response.

Regards,

Anshita

Avatar

Avatar

PaigeFielder

Avatar

PaigeFielder

PaigeFielder

30-03-2017

Hi,

How big are the data discrepancies? 

Whenever I compare Data Warehouse and Workspace/Reports I always find a small discrepancy but have found that this is usually explained by the fact that Data Warehouse holds unprocessed data compared to the processed front end data you see in Workspace/Reports, so we accept a small difference. 

I've never had a Warehouse extract fail on size as long as the FTP Server I send it to has enough space, are you requesting it via email?

Thanks,

Paige