Hi folks,
How can I use data feeds to pull out reports,
eg:
1 dimension, 2 metrics and 1 calculated metrics.
Is there any restriction on the data volume. Expected rows for 3 months is around 30,000.
Thanks
Solved! Go to Solution.
You cannot pull calculated metrics via Data Feeds.
Data feeds do not have size limitations. At the end of each day, the data for the day is processed and delivered to you via FTP.
It can deliver either one compressed file or multiple compressed file of 2GB of size each.
Each compressed file will contain the data plus additional lookup files.
Data feed requires you to do your own processing of the data
Ideally you might want to extract only post column as it will hold the value post all processing steps from Adobe Analytics.
Data feed is the raw data as it is being received and you will need to import it in a database and create queries to output what you want to see. If you want to ovoid this, Data Warehouse might be more suited for what you want to do.
There is also an options when you built a report in Adobe Analytics (not Analysis Workspace), to export data using "...more" >> Extract Data . Data Extracts can process a maximum number of 50,000 rows in a single request.
why dont you use a warehouse export?
you can set up scheduled exports as well, might be easier to maintain (if you dont need more information than described)
but be careful, not all calculated metrics are available in data warehouse export: you should see the availability when creating/modifying the metric (below preview data graph)
Views
Replies
Total Likes
the data sets are huge and around 100 reporlets.
Views
Replies
Total Likes
The complexity to get the report from Data feeds would totally depend on the dimension and metrics you are looking for.
Can you share some information regarding those?
Views
Replies
Total Likes
Like for a pagename if we need clicks and pageviews, and a calculated metric. Do we need to setup something in data feeds.
Views
Replies
Total Likes
You cannot pull calculated metrics via Data Feeds.
Data feeds do not have size limitations. At the end of each day, the data for the day is processed and delivered to you via FTP.
It can deliver either one compressed file or multiple compressed file of 2GB of size each.
Each compressed file will contain the data plus additional lookup files.
Data feed requires you to do your own processing of the data
Ideally you might want to extract only post column as it will hold the value post all processing steps from Adobe Analytics.
Data feed is the raw data as it is being received and you will need to import it in a database and create queries to output what you want to see. If you want to ovoid this, Data Warehouse might be more suited for what you want to do.
There is also an options when you built a report in Adobe Analytics (not Analysis Workspace), to export data using "...more" >> Extract Data . Data Extracts can process a maximum number of 50,000 rows in a single request.
Thanks, that clears my doubts about the same.
Views
Replies
Total Likes