Bulk Upload from MCC account not making any changes to child accounts

[Mathis LAVAUD]

Hello everyone,

First here is some context on what I am trying to do.
I have several accounts (we'll call them children accounts) managed by several MCC accounts (parents accounts), themselves managed by a MCC account (grandparent account).

I am currently using a script to make bulk changes to my children accounts : it creates a bulk upload CSV, fills it with informations from a Gsheet, and upload the changes to Google Ads.
(The changes are changes to the maximum CPC of certain keywords, hence the columns of the CSV)

function localBulkUpload(){

      

    var columns = ["Campaign", "Campaign ID", "Ad group", "Ad group ID", "Keyword", "Keyword ID", "Match type", "Max. CPC", "Action" ] ;

     var upload = AdsApp.bulkUploads().newCsvUpload(columns) ;

[...] Fills the CSV with the list of changes [...]

      upload.forCampaignManagement();

      upload.preview();      

}

This script is "local" : I have a version of it for each children account, eventhought they all get their changes from the same GSheet.

It works perfectly, here we can see a bunch of changes I could upload for a given account.

I am now trying to have only one version of this script, that I would run from the Grandparent MCC account. 

It would only change one account at a time.
Here is how I did it :

function globalBulkUpload(){

    

    var accountName = "name_of_the_account_I_want_changed" ;

      var accountSelector = AdsManagerApp.accounts().withCondition("AccountDescriptiveName = '" + accountName + "'") ;

  accountSelector.executeInParallel('localBulkUpload') ;

}

Where localBulkUpload is the same function I use in my children accounts scripts.

This seems to work at first. The script finishes and I don't get any error.

However when I go check the changes in the "All bulk actions" section here is what I see :

"No changes" instead of the same "36 valid changes" it should be (I used the same information to change the CPCs).

I don't see a problem in my method, so I don't understand why it doesn't work.

I have standard access to the grandparetn MCC account, and Admin access to the children accounts. 

Can you help me with this problem ?

Regards,

Mathis

[Google Ads Scripts Forum Advisor]

Hi Mathis,

This issue will be easier to troubleshoot directly in your account. Can you please privately reply with the relevant CIDs (grandparent, parent and child account) along with the script name in the grandparent account?

Thanks,
Matt
Google Ads Scripts Team

ref:_00D1U1174p._5004Q22XrOF:ref

[Mathis LAVAUD]

I am having trouble finding how to answer privately.

--
-- 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 a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/6oIUBp_m4bo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/B75pF000000000000000000000000000000000000000000000QDTXMW00G3Py1NQjRZO_obxGSfLV0w%40sfdc.net.

[Mathis LAVAUD]

I am having trouble finding how to reply privately.

Is this answer private for instance ? I am not sure.

Regards

On Tue, 21 Jul 2020 at 19:23, Google Ads Scripts Forum on behalf of adsscriptsforumadvisor <adwords...@googlegroups.com> wrote:

--

[Google Ads Scripts Forum Advisor]

Hi Mathis,

I work with Matt and allow me to assist you.

The Reply privately to author option should be available in the upper right corner where a dropdown can be seen. Could you confirm if you are able to see it?

Best regards,
Peter

[Mathis LAVAUD]

Hi Peter,

I can see the option but can't use it. It's in grey and says :
You don't have permission to reply to the author in this group.

Best regards,

Mathis

[Google Ads Scripts Forum Advisor]

Hi Mathis,

Please see this support page on replying privately. For this particular issue, the page suggests:

"Note: If Reply to author is grayed out, check your Chrome Browser mailto setting."
 

Regards,
Matt
Google Ads Scripts Team

ref:_00D1U1174p._5004Q22XrOF:ref

[Mathis LAVAUD]

Hi, 

So I went into my Browser's setting and set Gmail as my mailing link handler. It didn't work, even after I close everythong and restard the PC.

I then added a Mailto extension to my Browser and set Gmail as my handler in it. Restarted the PC, and it still doesn't work...

Can you send me an email address I can contact directly ? It would be easier than trying to make the Mailing Link work.

Regards, 

Mathis

[Google Ads Scripts Forum Advisor]

Hi Mathis,

Could you send your customer ID via this forum thread instead? We'll make sure to remove it as soon as we receive your response.

Best regards,
Peter

[Google Ads Scripts Forum Advisor]

Hi Mathis,

Thank you for the CID. Can you please provide the script name as well?

Thanks,
Matt

[Mathis LAVAUD]

Hi, 

Yes, the script name is "Refonte Data Pusher MCC Level"

Mathis

[Google Ads Scripts Forum Advisor]

Hi Mathis,

I appreciate your effort in providing the requested details. I work with Matt and Peter, and let me help you to address the issue.

Upon checking the Uploads section (TOOLS & SETTINGS > BULK ACTIONS > Uploads) of the provided account, I can see that the script is indeed made no changes to child accounts. With this, could you provide an access to the spreadsheet that you are using in the script to further check and to try this script on my test account?

Regards,
Ejay

[Mathis LAVAUD]

Hi Ejay,

I still can't share information privately to you. I don't know how to provide you with the access without giving an open sharing link away.

So I will only be sharing a copy of the gsheet reduced to the minimum information for the script to work. 

Here is a sharing link to the copy :

https://docs.google.com/spreadsheets/d/1Rs0Tj1n18N7uo-lBLyXK3AYLf2th0an6OJtKMVfHCsg/edit?usp=sharing

You will need to change the line 4 of the script to this :

var spreadsheet_url = "https://docs.google.com/spreadsheets/d/1Rs0Tj1n18N7uo-lBLyXK3AYLf2th0an6OJtKMVfHCsg/edit#gid=0";

So the script accesses the copy and not the original gsheet. 

The information we use to make the bulk upload are in the "Bulk Upload Sasroom" sheet. Specifically the columns "Campaign Id", "Campaign", "Ad Group Id", "Ad Group", "Keyword Id", "Keyword", "Match Type" and "New CPC".

I let a sample of changes as an exemple.

The other columns "Old CPC", "Indicator", "Clicks" and "Abs. Top Impr. %"  are only here for readability and give some contexts to the user.

Thank you for your time and attention,

Best regards, 

Mathis

[Google Ads Scripts Forum Advisor]

Hi Mathis,

There appear to be two unique spreadsheets in the script, so I've requested access to the one in your uploadChanges function, for the sake of completeness. 

Looking in the account specified in the 'interface' tab, the changes specified in the next tab appear to already have been made in the account. If there is no difference between the upload and the current entity, then 'no changes' will be shown on the bulk uploads page. It should also be noted that the script is only using columns A - F in the spreadsheet, which provide campaign, ad group and keyword IDs/names. The Old/New CPC columns are not in the range of script. Additionally, those column headers are not supported by bulk upload.

Regards,
Matt

[Mathis LAVAUD]

Hi Matt,

Depending on wich documents you checked, it is possible the changes you saw have been applied (using the same script located in a children account).

However, even when giving new changes we get the result "no changes" you mentionned.

I will loaded new changes in the document if you want to check again.

The script gets the columns with the method var values = sheet.getDataRange().getValues();. It does get the whole array of data in the sheet "Bulk Upload Sasroom", not just the columns A-F, I checked too.

So values[i][8] does get the new Max CPC bid we want to apply (line 54 in the script).

The "Old CPC" column is indeed not supported in google ads, so it is not included in the bulk upload CSV (wich is called "upload" in our case).

I know the CSV is supposed to work, as I use the same one to make bulk changes from the same script that I run from the individual accounts.

Regards, 

[Google Ads Scripts Forum Advisor]

Hi Mathis,

My apologies for the confusion and inconvenience.

I tried previewing the script in your account and I was able to replicate issue. The changes should be applied in one of your account, however, no changes has been shown in all bulk actions view.

With this, let me discuss the issue to my team. Rest assured that we will get back to you once we receive updates. 

Regards,
Ejay

[Mathis LAVAUD]

Hi,

I realize you are solicited a lot on many different subjects, but do you have any news on my issue ?

Regards,

Mathis 

[Google Ads Scripts Forum Advisor]

Hi Mathis,

My apologies for the inconvenience and back and forth.

Our team is currently investigating the issue that you encountered. But let me send a follow up to our team to get some updates about the issue. Rest assured that I will share updates to this forum thread once I get some.

[Mathis LAVAUD]

Hi, 

No problems don't worry.

Thank you,

Mathis

[Dmytro]

I have the same problem with bulkUpload in structure MCC -> MCC -> Child account.

[Google Ads Scripts Forum Advisor]

Hi Dmytro,

Thanks for reporting this. We are currently investigating the issue and we will provide an update when there is more information.

Thanks,
Matt

[Mathis LAVAUD]

Hi,

I just wanted to ask if you had any update on the subject. 

Thank you again for your help so far,

Regards, 

Mathis

[Google Ads Scripts Forum Advisor]

Hi Mathis,

Thanks for your patience on this. At the moment, this issue is still being investigated. I have reached out to the team for an update, and if they have any update I will share that information with you.

[Albert]

Hi All,

We are also experiencing the same thing, Is there a fix now? or any wordaround

Regards

[Google Ads Scripts Forum Advisor]

Hi Albert,

Harry here, part of the Google Ads Scripts Team. can you kindly provide the script name and your CID so that I could check this on our end? You may send them here or privately via the reply to author option. Note that you may need to join the Google Group for you to use this option. 

If this option is not available at your end still, you may send it through our email (googleadsscr...@google.com) instead.


Thanks,

Harry Cliford Rivera Google Ads Scripts Team

ref:_00D1U1174p._5004Q22XrOF:ref

[Google Ads Scripts Forum Advisor]

Hi Albert,

Thanks for coming back. Would you be able to also provide a shareable link to the csv file (or a copy of it) you are using for the bulk upload? You can send it via the options I mentioned earlier.

[Google Ads Scripts Forum Advisor]

Hi All,

I appreciate your patience with this concern. I received an update from the team and let me share it to you.

The issue that was discussed in this forum thread has already been fixed. With this, kindly verify it on your end. If the issue persists, please provide the following details so that our team can further investigate:

• Script name
• Customer ID where we can see the created script name
• File that is used in the script for bulk upload which our team can access
• Description on how you observed the issue again

You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Regards,

Ernie John Google Ads Scripts Team

ref:_00D1U1174p._5004Q22XrOF:ref

[John Albert Catama]

Hello Team!

All good now, We already fixed it in our end :)

Cheers!

--
-- 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 a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/6oIUBp_m4bo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/91qoM000000000000000000000000000000000000000000000R9HXYM00S11lX-2iRwmXPjuaXp5_aw%40sfdc.net.

[Google Ads Scripts Forum Advisor]

Hello,

We are glad to know that the issue on your end is now fixed. If you have any further questions or concerns, feel free to contact us again. We’re happy to assist you.

Regards,

James Howell Google Ads Scripts Team

ref:_00D1U1174p._5004Q22XrOF:ref