I am having a problem with a data transfer from Google Ads. When I schedule the backfill I get the following error for some dates:

Invalid value: Load configuration must specify at least one source URI

When I check the log inside of the details of execution I get the following message:

Failed to start job for table p_ClickStats_5419416216$20201117 with error INVALID_ARGUMENT: Invalid value: Load configuration must specify at least one source URI

The weird part is that this happens for random dates which I had transfered before in a previous transfer. Did anyone have a problem similar to that?

Using Google Ads API "Get Account Hierarchy" to get all accounts. https://developers.google.com/google-ads/api/docs/account-management/get-account-hierarchy?hl=en

Found out that canceled accounts are not being retrieved.

I do see the canceled accounts are being reported in the UI and in their Google Data Studio connector. I guess both use the old AdWords API.

Is there a way to fetch and report canceled accounts via Google Ads API? Is it recommended to use the old AdWords API?

I am trying to Create a Client test account under Test manager account of google ads API but my test manager account is marked as closed. See below

As mentioned in the picture a, we need to use new google account to create test manager account that is not been used in production manager account, I did the same. I created new google account and created test manager account but when I try to generate Refresh token for test account by using OAuth playground, It generates an error. see picture b.

Picture a.

Picture b.

Am I doing something wrong to configure the test manager account? Is there anything I need to follow to enable test account? The request to generate refresh token is getting denied. Is it because my account is closed?

I am looking to add ads to my Xcode project using google ads. I already downloaded cocoapods successfully and was able to connect it to my Xcode project but then I ran into an error while trying to download the pod required to get ads.

### Error 

LoadError - dlsym(0x7fdb515e63e0, Init_ffi_c): symbol not found - /Library/Ruby/Gems/2.6.0/gems/ffi-1.14.2/lib/ffi_c.bundle /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require' /Library/Ruby/Gems/2.6.0/gems/ffi-1.14.2/lib/ffi.rb:6:in `rescue in <top (required)>' /Library/Ruby/Gems/2.6.0/gems/ffi-1.14.2/lib/ffi.rb:3:in `<top (required)>' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require' /Library/Ruby/Gems/2.6.0/gems/ethon-0.12.0/lib/ethon.rb:2:in `<top (required)>' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require' /Library/Ruby/Gems/2.6.0/gems/typhoeus-1.4.0/lib/typhoeus.rb:2:in `<top (required)>' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/sources_manager.rb:74:in `cdn_url?' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/sources_manager.rb:36:in `create_source_with_url' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/sources_manager.rb:21:in `find_or_create_source_with_url' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/installer/analyzer.rb:178:in `block in sources' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/installer/analyzer.rb:177:in `map' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/installer/analyzer.rb:177:in `sources' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/installer/analyzer.rb:143:in `update_repositories' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/installer.rb:235:in `block in resolve_dependencies' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/user_interface.rb:64:in `section' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/installer.rb:234:in `resolve_dependencies' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/installer.rb:160:in `install!' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/command/install.rb:52:in `run' /Library/Ruby/Gems/2.6.0/gems/claide-1.0.3/lib/claide/command.rb:334:in `run' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/lib/cocoapods/command.rb:52:in `run' /Library/Ruby/Gems/2.6.0/gems/cocoapods-1.10.1/bin/pod:55:in `<top (required)>' /usr/local/bin/pod:23:in `load' /usr/local/bin/pod:23:in `<main>'

here is the error message I get while trying to use the command install pod --repo-update. I updated cococapods already and still had this problem. I am using an M1 MacBook Pro for this. Do you know how to solve this?

I have a mobile game, in which i have user engagement of 10 minutes and user retention day 1 of 27%, I'm doing app promotion on Google Ads, so in USA and United Kingdom my CPI in Google Ads is 0,15$, But i still have ROI = 0,4, is that not too small?

Can anyone help me on some suggestions on what makes that so small? Thanks in advance.