Override Last-Touch Channel Not Checked

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 column exclude_hit = 0

Step 3:

Apply filter on column va_new_engagement=1

Step 4:

Apply filter on column va_closer_id=channel ID

va_closer_id : Numeric ID that identifies the Last touch channel dimension. Lookup for this ID can be found in the Marketing Channel Manager.

Override Last-Touch Channel Checked

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 column exclude_hit = 0

Step 3:

Apply filter on column va_instance_event=1

Step 4:

Apply filter on column va_closer_id=channel ID

va_closer_id : Numeric ID that identifies the Last touch channel dimension. Lookup for this ID can be found in the Marketing Channel Manager.

Expectation:  Count the no. of rows left.The count should match to reports. Column Reference