2 INNER JOIN con COUNT a la misma tabla

[quimfv]

Código MySQL:

SELECT SUM(if(action=1,1,0)) as impresion,
SUM(if(action=2,1,0)) as clic,
SUM(if(action=3,1,0)) as conversion
FROM ads_tracking_history
WHERE DATE_FORMAT(TH.DATE, '%Y-%m-%d') = DATE_FORMAT(NOW(), '%Y-%m-%d');
 

No te compliques la vida....

Otra complicación es usar `DATE` TIMESTAMP teniendo DATETIME.

TIMESTAMP son milisegundos

DATETIME es YYYY-mm-dd hh:mm:ss