Marketing channel DW report | Community
Skip to main content
Level 2
March 17, 2023
Solved

Marketing channel DW report

  • March 17, 2023
  • 1 reply
  • 1927 views

I want to run a DW report for all the Marketing channels. What dimensions and metrics should I use to see the sample data for a day? As, I want to see if the channel gets the correct value based on marketing channel processing rules workflow. What specifically should I be looking in the sample data?

 

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

If you are looking at Adobe Data Warehouse, then you should look for Last Touch Channel and Last Touch Channel Detail (Marketing Channel and Last Touch Channel return the same results in Workspace)

 

 

So, in Data Warehouse you can use Last Touch to get the same data:

 

 

I don't know what you mean by "want to see if the channel gets the correct value based on marketing channel processing rules workflow"... Are you comparing Workspace to Data Warehouse? Ostensibly you would use the same metrics as you are using in your Workspace....which is generally, but not necessarily be your conversion metrics... (note, if you are using something like UVs, Data Warehouse will pull values per each row, but you can't add them together)

 

If you are asking about your own Data Warehouse and you are looking for the Raw Data Feeds columns, then you can use:

  • va_closer_detail  (last touch channel detail)
  • va_closer_id  (last touch channel id - your team will have to map these ids to your channel ids in Adobe)
  • va_finder_detail  (first touch channel detail)
  • va_finder_id  (first touch channel id - same mapping needed as above)
  • va_instance_event (Marketing Channel instances)
  • va_new_engagement (Marketing Channel New Engagements)

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
March 17, 2023

If you are looking at Adobe Data Warehouse, then you should look for Last Touch Channel and Last Touch Channel Detail (Marketing Channel and Last Touch Channel return the same results in Workspace)

 

 

So, in Data Warehouse you can use Last Touch to get the same data:

 

 

I don't know what you mean by "want to see if the channel gets the correct value based on marketing channel processing rules workflow"... Are you comparing Workspace to Data Warehouse? Ostensibly you would use the same metrics as you are using in your Workspace....which is generally, but not necessarily be your conversion metrics... (note, if you are using something like UVs, Data Warehouse will pull values per each row, but you can't add them together)

 

If you are asking about your own Data Warehouse and you are looking for the Raw Data Feeds columns, then you can use:

  • va_closer_detail  (last touch channel detail)
  • va_closer_id  (last touch channel id - your team will have to map these ids to your channel ids in Adobe)
  • va_finder_detail  (first touch channel detail)
  • va_finder_id  (first touch channel id - same mapping needed as above)
  • va_instance_event (Marketing Channel instances)
  • va_new_engagement (Marketing Channel New Engagements)
Level 2
March 17, 2023

Yes, this is exactly what I was looking for in terms of last touch channel and details

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
March 17, 2023

You're welcome 🙂