Symfony Profiler

"{"queryId":"be378b3e-b1de-4f54-82dd-87f5bb05eac4","data":{"summary":"Data Source: Global Network Report (Performance Data: events, clicks, revenue, costs, ROI).<br><br><table style=\"width:100%; border-collapse:collapse; font-size:13px; margin:10px 0;\"><tr style=\"background:#1B3A5C; color:white;\"><th style=\"padding:8px 10px; text-align:right; border:1px solid #ddd;\">Mafo Advertiser Id<\/th><th style=\"padding:8px 10px; text-align:left; border:1px solid #ddd;\">Advertiser Name<\/th><th style=\"padding:8px 10px; text-align:right; border:1px solid #ddd;\">Gross Total Revenue<\/th><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">235<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">PMG Worldwide, LLC<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$1,678,031.00<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">767<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Gaurav) Swiggy Delivery Partner<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$539,271.00<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">77<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Grace) Crypto.com 2020<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$388,939.00<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">425<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Vlad) Fetch Rewards<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$223,734.50<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">410<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(EU Max) Tikla ATA EXPRESS <\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$117,938.00<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">374<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Jade) IVY Mobile(Combo Blast) - 60 % CTV<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$110,552.40<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">87<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Jack) Bybit Fintech Limited<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$105,690.00<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">411<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(EU Max) Benjamin Capital Partners Inc<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$103,654.00<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">367<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">Sezzle Inc<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$74,310.00<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">405<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(EU Max) Bolt Operations OU<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$69,142.00<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">290<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">Hotel Tonight, LLC (subsidiary of Airbnb)<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$66,100.00<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">580<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">Latam Spanish - Bitso SAPI de CV (Bitso)<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$64,928.00<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">416<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(EU Ana) Uphold <\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$63,000.00<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">427<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Vlad) Sports Interaction_Entain<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$54,420.00<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">602<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">Brazil (Camila)Bradesco<\/td><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">$53,214.00<\/td><\/tr><\/table><div style=\"margin-top:14px; padding:12px 14px; background:#f0f7ff; border-left:4px solid #1B3A5C; font-size:13px; line-height:1.6;\"><b>\ud83d\udcca Volume Leaders:<\/b><br>\u2022 <b>PMG Worldwide, LLC<\/b> leads with 235 Mafo Advertiser Id (4.0% of total)<\/div>","chart_url":"https:\/\/quickchart.io\/chart?c=%7B%22type%22%3A%22bar%22%2C%22data%22%3A%7B%22labels%22%3A%5B%22PMG_Worldwide%2C%22%2C%22Gaurav)_Swiggy%22%2C%22Grace)_Crypto.com%22%2C%22Vlad)_Fetch%22%2C%22EU_Max)%22%2C%22Jade)_IVY%22%2C%22Jack)_Bybit%22%2C%22EU_Max)%22%2C%22Sezzle_Inc%22%2C%22EU_Max)%22%2C%22Hotel_Tonight%2C%22%2C%22Latam_Spanish%22%2C%22EU_Ana)%22%2C%22Vlad)_Sports%22%2C%22Brazil_Camila)Bradesco%22%5D%2C%22datasets%22%3A%5B%7B%22label%22%3A%22Mafo%20Advertiser%20Id%22%2C%22data%22%3A%5B235%2C767%2C77%2C425%2C410%2C374%2C87%2C411%2C367%2C405%2C290%2C580%2C416%2C427%2C602%5D%2C%22backgroundColor%22%3A%22%23FF6384%22%7D%2C%7B%22label%22%3A%22Gross%20Total%20Revenue%20(%24)%22%2C%22data%22%3A%5B1678031%2C539271%2C388939%2C223734.5%2C117938%2C110552.4%2C105690%2C103654%2C74310%2C69142%2C66100%2C64928%2C63000%2C54420%2C53214%5D%2C%22backgroundColor%22%3A%22%2336A2EB%22%7D%5D%7D%2C%22options%22%3A%7B%22responsive%22%3Atrue%2C%22plugins%22%3A%7B%22legend%22%3A%7B%22display%22%3Atrue%7D%7D%2C%22scales%22%3A%7B%22y%22%3A%7B%22beginAtZero%22%3Atrue%7D%7D%7D%7D&w=800&h=400&bkg=white","sql_query":"SELECT mr.mafo_advertiser_id, ma.name AS advertiser_name, COALESCE(ROUND(SUM(CASE WHEN mr.affiliate = 'Organic' AND mr.mmp_source IN ('appsflyer_agency', 'appsflyer_agency_unilead', 'appsflyer_agency_unilead_2', 'appsflyer_agency_mobupps_in', 'appsflyer_agency_webmedia', 'appsflyer_agency_aura_dsp', 'appsflyer_agency_traffic4you', 'appsflyer_agency_my_app_media') THEN 0 ELSE IF(mr.mmp_source IN ('tune_mobile', 'tune_web'), mr.total_revenue, IF(mr.mmp_partner_rules_revenue IS NOT NULL, (mr.mmp_partner_rules_revenue * mr.event_count), (mr.mmp_offer_default_revenue * mr.event_count))) END), 2), 0) AS gross_total_revenue FROM mafo_data_lake_parquet.mmp_reports mr LEFT JOIN mafo_data_lake_parquet.mafo_advertisers ma ON mr.mafo_advertiser_id = ma.id LEFT JOIN mafo_data_lake_parquet.mafo_offers mo ON mr.mafo_offer_id = mo.id LEFT JOIN mafo_data_lake_parquet.mafo_offers_mapping mafo_om ON mo.id = mafo_om.mafo_offer LEFT JOIN mafo_data_lake_parquet.mmp_offers mmo ON mafo_om.system_identifier IN ('adjust', 'appsflyer_agency', 'singular') AND mafo_om.system_identifier_id = mmo.id LEFT JOIN mafo_data_lake_parquet.app_info ai ON mr.app_id = ai.app_id LEFT JOIN mafo_data_lake_parquet.mmp_mobile_apps mma ON mr.app_id = mma.bundle_id AND mr.mmp_source = mma.tracking_system AND mr.os = mma.platform WHERE mr.report_date >= CAST(to_unixtime(TIMESTAMP '2026-01-01 00:00:00') * 1000000000 AS BIGINT) AND mr.report_date < CAST(to_unixtime(TIMESTAMP '2026-02-01 00:00:00') * 1000000000 AS BIGINT) AND (mr.mmp_offer_id IS NULL OR mr.mmp_offer_active_flag = 1) AND mr.mmp_source NOT IN ('appsflyer_agency_account_manager', 'appsflyer_agency_af_agency') AND mr.mmp_mobile_apps_id IS NOT NULL AND (mr.affiliate NOT IN ('unilead_int', 'webmedia_int', 'auradsp42_int', 'mobinovo52_int', 'traffic4yoil300', 'af-agencyil647', 'myappmediail647', 'mobuppsxil619') OR mr.is_from_appsflyer_blocked_capping = 1) AND (mr.mmp_source NOT IN ('tune_mobile', 'tune_web') OR mr.app_id NOT IN (SELECT mobile_app FROM mafo_data_lake_parquet.mmp_offers WHERE is_deleted = 0)) GROUP BY mr.mafo_advertiser_id, ma.name ORDER BY gross_total_revenue DESC LIMIT 15"}}"

false