select advertiser, advertiser_id,'Adjust' as MMP, outcome_ltag from advertiser_lookup where outcome_ltag in ( select distinct(l_tag) from new_pixel where user_agent ='adjust.com' and date = '2024-03-22') union select advertiser, advertiser_id, 'AppsFlyer' as MMP, outcome_ltag from advertiser_lookup where outcome_ltag in ( select distinct(l_tag) from new_pixel where user_agent ='http-kit/2.0' and date = '2024-03-22') union select advertiser, advertiser_id, 'Singular' as MMP, outcome_ltag from advertiser_lookup where outcome_ltag in ( select distinct(l_tag) from new_pixel where user_agent ='Apsalar-Postback' and date = '2024-03-22') union select advertiser, advertiser_id, 'Kochava' as MMP, outcome_ltag from advertiser_lookup where outcome_ltag in ( select distinct(l_tag) from new_pixel where u11_tag ='Kochava' and date = '2024-03-22') order by MMP
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter