It is sometimes required to verify that Marketing Channel and the order against it, may to sent to 3rd party data source or data lake then data feed is very helpful.

Step 1

Pull following column through data feed:

• exclude_hit        
• va_closer_detail              
• va_closer_id      
• va_detail            
• va_finder_detail              
• va_finder_id      
• va_instance_event          
• va_master_id    
• va_new_engagement

Step 2

• apply filter on exclude_hit=0

Step 3

• apply filter on va_closer_id =Channel ID

Step 4

• apply filter on post_event_list=1

Count the rows and it will match the report.