Export data from analytics (with Datawarehouse) to feed a database | Community
Skip to main content
Level 3
November 18, 2024
Solved

Export data from analytics (with Datawarehouse) to feed a database

  • November 18, 2024
  • 2 replies
  • 1262 views

Hi,

we export daily data from Adobe Analytics using Datawarehouse tool to feed an external database.
We do that to be able to match those online information (page, marketing channel, ...) with offline data and create audiences or analyze deeper our client behavior.
We notice that sometimes we have 10% of difference between what is in the workspace and the number of records in the exported files.
Did you already experience this?

Do you have alternative to export the data.

 

Thanks

 

Robin

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 Jennifer_Dungan

Without a little more information it will be hard to answer this...

 

But first off, Data Warehouse is sort of a flattened table of data... When you have fields  (such as lists or products) that contain multiple pieces of info, that "one" row will actually present as many.

 

Example, an order with 3 products will actually present as three rows in the export (one for each product)... this also means if you are adding up your metrics, you will actually over count them...   

 

This one "Order" will show the order metric in each row, if it's tracked on a page view, it will also track the same page view in each row...   so "1" becomes "3" because it cannot be de-duplicated.

 

Even when not looking at list type items, metrics like Visits or Unique Visitors can be inflated, again due to the inability to de-duplicate across your rows...

 

 

The better solution is to use the Raw Data Feeds... this will actually provide you with the Raw Data as Adobe gets it... but it's also not for the faint of heart... because now you will have to create all the SQL to process the information like Adobe: identifying your UVs and Visits, excluding the hits that shouldn't be counted, processing all the information... and while you may not get a 100% match (since it is challenging to replicate all the logic), you should be able to get it very very close... 

 

 

 

2 replies

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
November 18, 2024

Without a little more information it will be hard to answer this...

 

But first off, Data Warehouse is sort of a flattened table of data... When you have fields  (such as lists or products) that contain multiple pieces of info, that "one" row will actually present as many.

 

Example, an order with 3 products will actually present as three rows in the export (one for each product)... this also means if you are adding up your metrics, you will actually over count them...   

 

This one "Order" will show the order metric in each row, if it's tracked on a page view, it will also track the same page view in each row...   so "1" becomes "3" because it cannot be de-duplicated.

 

Even when not looking at list type items, metrics like Visits or Unique Visitors can be inflated, again due to the inability to de-duplicate across your rows...

 

 

The better solution is to use the Raw Data Feeds... this will actually provide you with the Raw Data as Adobe gets it... but it's also not for the faint of heart... because now you will have to create all the SQL to process the information like Adobe: identifying your UVs and Visits, excluding the hits that shouldn't be counted, processing all the information... and while you may not get a 100% match (since it is challenging to replicate all the logic), you should be able to get it very very close... 

 

 

 

Level 3
November 22, 2024

Thanks all for your feedback. Let's jump into data feed so!

Pablo_Childe
Community Advisor
Community Advisor
November 18, 2024

Check to see if in workspace you have any special attribution settings. May have to set to default to compare... 

https://experienceleague.adobe.com/en/docs/analytics/analyze/analysis-workspace/attribution/overview

 

GLTU