Problem uploading MCC level offline conversions

[Yaniv Frenkel]

Hi,

I was using a daily scrip to run over all of our MCC account and upload offline conversions to each account.
(Conversions are set at the MCC level).
Since July 2nd , all of our upload are failing due to:
"The click associated with the given GCLID isn't from the account where conversion tracking is set up."

When I manually upload the file to the mcc level - everything works.

Nothing changed on our side. This is what we are using:

function main() {

  var accountIter = MccApp.accounts().get();

  var successfulUploads = [];

  

  while(accountIter.hasNext()) {

    var account = accountIter.next();

    Logger.log("getting account");

    MccApp.select(account);

   

    //Logger.log("test");

    var rootFolder = findOrCreateFolder(ROOT_FOLDER_NAME,null);

    // The folder name for each account will be in the format  

    var accountFolderName = 'Conversions-' + AdWordsApp.currentAccount().getName() +'-'+ AdWordsApp.currentAccount().getCustomerId();

    

    // This will create the folder structure we need

    var accountFolder = findOrCreateFolder(accountFolderName,rootFolder);

    Logger.log("getting accountFolder - "+accountFolder.getName());

    var toProcessFolder = findOrCreateFolder(TO_PROCESS_FOLDER_NAME,accountFolder);

    Logger.log("getting toProcessFolder - "+toProcessFolder.getName());

    var processedFolder = findOrCreateFolder(PROCESSED_FOLDER_NAME,accountFolder);

    Logger.log("getting process folders");

    

    // Now we look in the "To Process" folder for any new CSV files

    var filesToProcessIter = toProcessFolder.getFilesByType(MimeType.CSV);

     Logger.log("filesToProcessIter started");

    while(filesToProcessIter.hasNext()) {

      var file = filesToProcessIter.next();

       Logger.log("processing file - "+file.getName());

      // Change the following line to use .apply() instead of .preview()

      // once you are satisfied things are working correctly. When using .preview(),

      // you will need to log into your account to apply the change.

      Logger.log("uploading");

      var upload = AdWordsApp.bulkUploads().newFileUpload(file);

      upload.forOfflineConversions();

      upload.apply();

Any ideas what changed?

  

[Google Ads Scripts Forum Advisor]

Hi Yaniv,

Thanks for reaching out to us. Harry here, from the Google Ads Scripts Team.

For us to be able to assist you, kindly provide the script's name and your CID so that I could check this on our end and investigate what caused the issue. 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._5004Q2JYhMJ:ref

[Google Ads Scripts Forum Advisor]

Hi Yaniv,

Thanks for coming back and providing requested details. Can you also provide me a copy of the spreadsheet file that resulted into the issue upon upload so I can full test this out on my end as well? You may send them through the options I have mentioned previously.

Looking forward to your reply.

[Google Ads Scripts Forum Advisor]

Hi Yaniv,

Thanks for your cooperation. Can you kindly try to create the same script, but at the single account level and in the account of yours in question so we can identify whether the issue is with regard to account level restrictions or with the bulk upload function? Kindly let me know how it goes and we'll proceed from there.

[Yaniv Frenkel]

I already duplicated this script with a small change:
now even though I integrate through the child account the scrip uploads the conversions to the master account - that solved my problem.
You should still look into that as it means that someone released a version that doesn't support backward compatibility as there is not reason for why the child account won't recognize its one conversions even if those are mcc level conversions. 
I saw on your blog post that there was a release for the bulk uploading tool at the beginning of this month - that's probably a backward compatibility bugs and it could be that other accounts are also effected by this.

[Google Ads Scripts Forum Advisor]

Hi Yaniv,

Thank you for providing me the results. Much appreciated. I will absolutely raise this with the rest of the team for further investigation. However, can you kindly provide when did you encounter the error #1 below for further context on the issue? I was not able to replicate that specifically, but run into the  error #2.

1. The click associated with the given GCLID isn't from the account where conversion tracking is set up

1. No header row found in this sheet.

I would appreciate it if you can provide screenshots. As an aside, can you kindly point to the working script you have created just for reference?

[Google Ads Scripts Forum Advisor]

Hi Yaniv,

Please excuse us for the delay here. Can you also point me to the working script (CID and script name) you have created just for reference? You can share it privately through the options mentioned previously.

[Google Ads Scripts Forum Advisor]

Hi Yaniv,

In addition, I have deleted your latest post as it contains your personal information.

[Google Ads Scripts Forum Advisor]

Hi Yaniv,

Thank you for your continued cooperation. I have now raised this with the rest of the team with the provided information and my investigation. Rest assured that I will update you here once updates becomes available. On the other hand, I have once again deleted your post as it contains your email which is considered as one of your PIIs. Kindly take note of this when sending screenshots next time or you may send them privately instead.

Let me know if I can assist you of anything else.

[Yaniv Frenkel]

Hi Harry,
It looks like something was changed again as even my new script version which was working fine until today is currently not wroking.
Was something changed again? This is really frustrating

Yaniv Frenkel

Founder & CEO

Tel: 972.50.7494639

TravelMediaDirect.com

--
-- 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/_mDQ7K3Gcmw/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/Q9pAW000000000000000000000000000000000000000000000QWL4ZP006ozYjN3GQaORdVmsviOOGA%40sfdc.net.

[Yaniv Frenkel]

TypeError: Cannot read property "useLegacyUploads" from undefined. (file Code.gs, line 53)

Yaniv Frenkel

Founder & CEO

Tel: 972.50.7494639

TravelMediaDirect.com

[Google Ads Scripts Forum Advisor]

Hi Yaniv,

I do understand the frustration. Please excuse us for the inconvenience that this issue has caused you. I am note aware of any recent change aside from what was described in this blog: Updating Bulk Upload in Google Ads Scripts. Can you kindly confirm if you encountered the error with the same set of spreadsheets you used in your script that uploads conversions for single/child accounts? Can you provide copies of those to me as well so I can investigate and provide further details to the team to work with?

[Yaniv Frenkel]

Thanks Harry,
Yes - those are the same spreadsheets.
What email can I use for sending the account's private data?

Yaniv Frenkel

Founder & CEO

Tel: 972.50.7494639

TravelMediaDirect.com

--

-- 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/_mDQ7K3Gcmw/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/Ynmau000000000000000000000000000000000000000000000QWOTA5008l7RiF63RG2pbJwfIM27Vg%40sfdc.net.

[Google Ads Scripts Forum Advisor]

Hi Yaniv,

Thanks for confirming. Kindly provide further information through this email googleadsscr...@google.com. Looking forward to your reply.

[Google Ads Scripts Forum Advisor]

Hi Yaniv,

Thank you for your continued cooperation here. I have now added this on the former issue for the rest of team to investigate on. As soon as any updates becomes available, I will provide them to you here in this thread. Kindly let me know of anything else I can assist you with in the meantime.