The report suits in the data feed are missing the fields I need, but they are available in the project in the workspace

[leozh1]

Hello,

   I selected the report suits as xxxx prd in the project within Workspace, and I was able to retrieve the product column. However, when I also selected the report suits as xxxx prd in Data Feed, I couldn't find the product column. Why is this happening?

WorkSpace:

Data Feed:

[MandyGeorge · Accepted solution]

Hi @leozh1, so what you have in your screenshot is the product column. If you haven't worked with data feeds before, there are a lot of nuances that might be difficult at first. The first is that the product column is going to come into product_list and post_product_list. You likely want to bring both of those fields into your data feed. The product list is going to be captured as an array, so you will need to unnest it when you're using it in your data lake. That being said, there are other columns that come in as arrays as well, such as the event_list and post_event_list. 

Some other things about data feeds, there are a lot of columns that are named a bit differently than they are in workspace. There's also a lot more fields available in data feeds than workspace. Most fields have a "post" version, those are the post-processed versions of the field, which will be what you need to make the data match to workspace. Also, there are some columns that come with lookup tables for the values in them. 

If you haven't read through this page, this is the most comprehensive explanation of all of the columns in the data feeds. https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/d...