In this project I want to retrieve reporting data from Google Ads account to be able to measure values from google ads with data I am storing in a Airtable database.
Suggested tools to use (I am open to other suggestions though)
1) Connection between Google ads and Redshift
2) Selection of appropriate google ads reports
3) Suggestions and implementing of a data warehouse (redshift , snowflake bigquery and so on).
4) Sending specific data from warehouse to airtable through zapier (if possible)
5) Setting up the comparison.
Please do not answer if you have not read the description - Please describe how your are thinking that the zapier connection would work.