Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Data Feeds

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

6 Replies

Avatar

Community Advisor

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)

Avatar

Level 3

the data sets are huge and around 100 reporlets.

Avatar

Employee Advisor

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?

Avatar

Level 3

Like for a pagename if we need clicks and pageviews, and a calculated metric. Do we need to setup something in data feeds.

Avatar

Correct answer by
Community Advisor

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.

Avatar

Level 3

Thanks, that clears my doubts about the same.