Transfer on MCC level for more than 50 accounts Custom Label and click data to a Google spreadsheet

[Stijn]

Hi all,

At the moment I am manually exporting via a report on MCC level the following data on a daily basis:

- Adwords Customer-ID

- Custom Label 3

- Clicks    Condition: Number of clicks =>1

- Costs

- Avg CPC

We have over 50 accounts in Google Ads and regular scripts are limited to a max number of 50 accounts. 

What I would like is to automatically export the data above on MCC level for all our accounts (+50) on a daily (or weekly) basis to a Google Spreadsheet file via a script. 

Could anybody help me with this?

[googleadsscrip...@google.com]

Hi Stijn,

The 50 account limit only applies if the script is using executeInParallel. Otherwise, the 50 account limit does not apply. If your script must use executeInParallel to gain the 30 minute increase in processing time, then you could break the script up into several scripts, with the account selector getting a specific subset of your accounts in each script.

Regards,
Matt

Google Ads Scripts Team
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_scripts
    https://developers.google.com/google-ads/scripts/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scripts+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/eeda9e91-5e92-4a9c-b56e-e9a38ed5640e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jerry H]

Hi Matt,

How are you grabbing a specific subset of accounts for each account iterator? Is there a conditional format to grab (for example:) the first 30 accounts sorted by name in ascending order? Then setting the second scripts iterator to pick up at the 31st account through the 60th account utilizing the same sorting?

At the moment our team is looking at all options within the API documentation to align the iterators in a structured format so they pick up where the last iterator left off, but have been unsuccessful so far. We have been avoiding using specific ID's to accomplish this, so the script is dynamic to our accounts. Any insight is appreciated.

[googleadsscrip...@google.com]

Hi Jerry,

There is not an exact way to break up the accounts in selectors (e.g. alphabetically), but you could use metrics to partition them. For example, you could have a selector get accounts with less than some number of impressions, and have another account selector in a different script get accounts with more than that number of impressions. 

The best way to break up the accounts depends on the specific conditions of the account.

Regards,

Matt

Google Ads Scripts Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_scripts
    https://developers.google.com/google-ads/scripts/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--

-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scripts+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/b4968409-33b1-4792-81a0-a2f13532ad9c%40googlegroups.com.