We are using stitchdata to get data from Facebook ads data to Google BigQuery warehouse. We retrieved tables like ads, ads_insights, campaigns, adcreative etc. How can I get transformed data like ad, clicks, impressions, reach, spend amount, leads count etc? Which table & fieldset can provide me these details?
I searched for this and on that basis I have collected data like impression, click, reach, lead count but if compare that data with Facebook ad manager then there is a big difference. Can anyone help to get the correct data.