I'm not exactly sure what field that would be, but essentially I would like to calculate/get the cost of a lead pushed into salesforce. I know we store the values like GCLID and campaign name.. but I'm not sure how I would use that in a query to fetch the cost of a singular lead.
Something like this example on the reporting section :
SELECT
campaign.name,
campaign.status,
segments.device,
metrics.impressions,
metrics.clicks,
metrics.ctr,
metrics.average_cpc,
metrics.cost_micros
FROM campaign
WHERE segments.date DURING LAST_30_DAYS
Is there maybe a list of fields / examples of such queries?