Hello, as a marketer who daily uses fb ads, google ads (mainly for lead generation campaigns) tik-tok ads, zapier chatbors, integrations, google sheets, etc.... I am thinking about how AI automation could be used in to make my work easier....Do you have experience with how to accurately link data from, for example: facebook ads manager, google ads and google sheets, in such a way that I would ask an AI assistant e.g. how many leads were added in the last 7 days from which campaigns, compare it with lead from google sheets ( if numbers are correcet ) what is the CPA, etc...
I know that zapier central has something similar, but I can't think of how to connect google ads manager and its real time data with all this. Any ideas? :) Thank you :)