Hi Guys! We are just getting started with Meltano and my only question for now is about getting data from multiple accounts in Google Ads, google ads config allows just one one customer_id so I'm not sure how to get data from multiple customer ids

Checkout inheriting plugins https://docs.meltano.com/concepts/project#inheriting-plugin-definitions you can inherit it a bunch of times and change the customer id config for each inheritance

Take a peak at https://github.com/AutoIDM/tap-googleads (all clients accessible are pulled)

I went through something similar with Google Analytics and ended up with 49 inheriting plugins - you can see some of my notes here https://github.com/meltano/meltano/issues/7165

for google ads looks like that if you can add the additional accounts as sub-accounts the tap will pull all sub-accounts data as well

I believe so. I do, anyway.

As an alternative to inherited plugins you can use environment variables to pull multiple accounts with the same project. That’s our normal approach. A couple of weeks ago Derek suggested a blog post / paper on this exact topic! I’m 100% going to get on with writing it next week!

@aaron_phethean Please let me know when is ready, it would be really useful to us, do you have an example how to to implement this by chance?

Come to think of it, I do have an example actually! It’s in our docs, but you should get the idea clearly: https://www.matatika.com/docs/how-to-guides/import-data/running-your-data-import-locally

Is that going to work with Airflow on the cloud as well @aaron_phethean>

Yes. Set the environment variables and ‘meltano run’.