Discrepancy in Data from Fallout report and Data warehouse | Community
Skip to main content
anshita_savant
anshita_savant
March 24, 2017
Solved

Discrepancy in Data from Fallout report and Data warehouse

  • March 24, 2017
  • 4 replies
  • 2115 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Gigazelle

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.

4 replies

PaigeFielder
PaigeFielder
Level 2
March 30, 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

anshita_savant
anshita_savantAuthor
March 31, 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

Gigazelle
Adobe Employee
GigazelleAdobe EmployeeAccepted solution
Adobe Employee
April 5, 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
anshita_savantAuthor
April 5, 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?

Terms & ConditionsAccessibility statement

Loading footer...