Importing CPL Data from Lookerstudio (ex GData Studio) or GAds/FB Ads

My name is Alessio, and I am reaching out to seek guidance on importing specific data from Lookerstudio (formerly known as GData Studio) or directly from Google Ads (GAds) and Facebook Ads (FB Ads) platforms.

Within our organization, we conduct various advertising campaigns using GAds and FB Ads. I have developed a dashboard in Lookerstudio where I can monitor the Cost per Lead (CPL) for each account, which is a vital Key Performance Indicator (KPI) for our business operations.

I am looking for the most efficient method to import the CPL data from Lookerstudio, GAds, or FB Ads. The objective is to share this data with my team members on a weekly basis, allowing them to evaluate our campaigns’ performance and make any necessary modifications.