hi!
I am trying to run this
SELECT
campaign.name, metrics.cost_micros FROM campaign WHERE metrics.cost_micros > 0 AND
campaign.name IN ["-lu","_lu","lu-","lu_"] AND segments.date >= '20220801' AND segments.date <='20221009'
but get this error:
InputError: Report not mapped: campaign
at Sh (adsapp_compiled:1690:11)
at new aH (adsapp_compiled:17206:15)
at new rH (adsapp_compiled:17432:22)
at eI.report (adsapp_compiled:18100:12)
at fI.report (adsapp_compiled:18245:21)
at Object.<anonymous> (adsapp_compiled:19052:54)
could you please point me in the direction to fix it?
thanks!