Discrepancy in Data from Fallout report and Data warehouse

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.

Mark Solution

Are these answers useful?
Help other community members by marking useful answers as accepted.

Accepted Solutions (0)

Answers (4)

Answers (4)

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?

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.

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

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