Error on creating Campaign with bulkUploads.newCsvUpload

373 views
Skip to first unread message

Max Vikharev

unread,
May 17, 2019, 1:20:16 PM5/17/19
to Google Ads Scripts Forum
Hello

We already use google ads scritps last 1 year without problems.

But since start of May we suddenly meet a error
Unable to determine the entity-type of this row. Make sure to only provide fields for columns that are appropriate for the entity.

when creating Campaign with following code:
  var csv = AdWordsApp.bulkUploads().newCsvUpload([
    "Campaign",
    "Campaign state",
    "Start Date",
    "End Date",
    "Budget",
    "Campaign type",
    "Campaign subtype",
    "Bid Strategy Type",
  ])

  csv.append({
      'Campaign': 'e8def923cb9f9fcc07d8bdd7a54f0e2d92f950dd',
      'Campaign state': 'enabled',
      'Start Date': '2019-05-17',
      'End Date': '2027-05-17',
      'Budget': 1000,
      'Campaign type': 'Search Network with Display Select',
      'Campaign subtype': 'Standard',
      'Bid Strategy Type': 'cpc',                                           
  })
 
  csv.setFileName('Create campaign e8def923cb9f9fcc07d8bdd7a54f0e2d92f950dd')
  csv.apply()

We see following message in Google Ads web interface on "All bulk actions" page:

bulk-test.png


On "download errors" we get following CSV file: 
Campaign,Campaign state,Start Date,End Date,Budget,Campaign type,Campaign subtype,Bid Strategy Type,Results
e8def923cb9f9fcc07d8bdd7a54f0e2d92f950dd,enabled,2019-05-17,2027-05-17,1000,Search Network with Display Select,Standard,cpc,Unable to determine the entity-type of this row. Make sure to only provide fields for columns that are appropriate for the entity.

Our script has no changes for 1 year we need help to determine the problem.

Google Ads Scripts Forum Advisor Prod

unread,
May 17, 2019, 3:52:28 PM5/17/19
to adwords-scripts+apn2wqf9vba0bq0k...@googlegroups.com, adwords...@googlegroups.com
Hello,

Can you please reply privately with your CID and script name so I can investigate the issue directly in your account?

Thanks,
Matt
Google Ads Scripts Team

ref:_00D1U1174p._5001UApvzq:ref

David York

unread,
May 20, 2019, 2:16:11 PM5/20/19
to Google Ads Scripts Forum on behalf of adsscriptsforumadvisor
I don't have it created but I need help creating one. Is there anyway you can help me out?



--
-- 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-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/KUc4j000000000000000000000000000000000000000000000PRNZ7900okth0CZ8SZmxt_-_aL4fVg%40sfdc.net.
For more options, visit https://groups.google.com/d/optout.

Max Vikharev

unread,
May 20, 2019, 5:36:14 PM5/20/19
to Google Ads Scripts Forum
Private message sent

Naman Jindal

unread,
May 22, 2019, 7:58:05 AM5/22/19
to Google Ads Scripts Forum
+1

I am seeing the same issue in my account. It has been working since last 1-2 years but it suddenly started throwing this error. Can this be fixed asap please.

Regards,
Naman

Naman Jindal

unread,
May 27, 2019, 5:50:17 PM5/27/19
to Google Ads Scripts Forum
Hello,

Any update on this error?

Thanks,
Naman

Max Vikharev

unread,
May 27, 2019, 10:07:15 PM5/27/19
to Google Ads Scripts Forum
We discovered that Bulk Upload CSV API changed. It seems like it switched to Adwords Editor format described here

Finally we created working version of Campaign creation with different types. 

function main() 
 Logger.log('Script started')
  var csv = AdWordsApp.bulkUploads().newCsvUpload([
    "Campaign",
    "Campaign state",
    "Start Date",
    "End Date",
    "Budget",
   "Campaign type",
    "Networks",
    "Bid Strategy Type",
    "tracking URL",
  ])

  csv.append({
      'Campaign': 'test-SearchAndContext',
      'Budget': 10001,
      'Bid Strategy Type': 'Manual cpc',             
      'Campaign state': 'paused',
      'Campaign type': 'Search',
      "Networks": 'Google Search; Search Partners; Display Network;'
  })
   csv.append({
      'Campaign': 'test-Search',
      'Budget': 10001,
      'Bid Strategy Type': 'Manual cpc',             
      'Campaign state': 'paused',
      'Campaign type': 'Search',
      "Networks": 'Google Search; Search Partners;'
  })
   csv.append({
      'Campaign': 'test-Context',
      'Budget': 10001,
      'Bid Strategy Type': 'Manual cpc',             
      'Campaign state': 'paused',
      'Campaign type': 'Display',
      "Networks": 'Display Network;'
  })
 
  csv.setFileName('test10')
  csv.apply()
  Logger.log('Script fin')
}
</pre>

Also we discovered that Adverts also not exportable. We solve problem by adding "Ad type"  column.

Max Vikharev

unread,
May 28, 2019, 6:28:05 AM5/28/19
to Google Ads Scripts Forum
Hello,

any progress ?


On Friday, May 17, 2019 at 8:20:16 PM UTC+3, Max Vikharev wrote:
Reply all
Reply to author
Forward
0 new messages