Getting results/ actions metrics accurately

[Schumzy]

Hi - I have pulled data from FB ads, to my bigquery, I have removed the multiple batches issue, so the numbers are fairly accurate.

My spend/ impressions counts are similar to FB HOWEVER...

I am trying to get counts for "website leads", and "landing page views" etc. It seems I should be able to get it using a combination of the columns seen below

---

Attached are the columns I believe will let me get the right numbers, but everytime I do the filtering of actions.1d_click by actions.actions_type = "landing_page_view" the result actions.1d_click is waay off, worse when I use a table and include "spend" the spend result is completely off more than 10x the number.

Would like a simple breakdown of how to get the right result/action counts in a table with other metrics such as spend.

Please note I am accessing the data through data studio and tableau and getting the same issues

[rechall]

I don't know how to use it. Can you tell me how to use it?