Successive Bulk uploads

[Francisco Ortiz]

Hello,
I'm using scripts to bulk upload AdGroups and then Responsavice Ads and finally keywords.

I do not manage to do it in a single script as AdGroup need to be created before uploading Ads and keywords needs the Ads.
It is a template to do all this uploads at once ?
Another way to do it ?
Thanks in advance for you support ?
Francisco

[Google Ads Scripts Forum Advisor]

Hi Francisco,

 

Thanks for reaching out to the Google Ads Scripts Team.

 

Upon checking your concern, it appears that you would like to create ad groups, (responsive search) ads and keywords all consolidated within one spreadsheet to be uploaded using the bulk upload feature of Google Ads Scripts. I'm afraid, however, that there isn't a direct way in order to do all these three operations at once. You would first need to create the ad group, and if you'd like to associate other entities with it such as ads and keywords, you would need to create those afterwards and supply the Ad group or Ad group ID to associate them with.

 

On that note, what I could recommend is using Google Ads Scripts' methods, by first using an AdGroupBuilder. After having created the ad group, you can select it and make use of the ResponsiveSearchAdBuilder and/or the KeywordBuilder. Kindly check the below links for more information:

• Bulk upload documentation - https://developers.google.com/google-ads/scripts/docs/features/bulk-upload
  • Supported entities - https://developers.google.com/google-ads/scripts-legacy/docs/features/bulk-upload-entities
• AdsApp.​AdGroupBuilder - https://developers.google.com/google-ads/scripts/docs/reference/adsapp/adsapp_adgroupbuilder
• AdsApp.AdGroupSelector - https://developers.google.com/google-ads/scripts/docs/reference/adsapp/adsapp_adgroupselector
• AdsApp.ResponsiveSearchAdBuilder - https://developers.google.com/google-ads/scripts/docs/reference/adsapp/adsapp_responsivesearchadbuilder
• AdsApp.KeywordBuilder - https://developers.google.com/google-ads/scripts/docs/reference/adsapp/adsapp_keywordbuilder

 

Let us know how it goes or if you have any clarifications.

 

Best regards,

 

Google Ads Scripts Team

ref:_00D1U1174p._5004Q2kW9s1:ref

[Sigurd Fabrin]

Hi Fransisco,

It is possible to use just one bulk upload spreadsheet and add everything in one go. 

Google Ads will read and apply the spreadsheet from top left to bottom right. Knowing this, you can create the adGroups first, by having them in the first rows. Under that, you can add e.g. the keywords and bellow there again, you can add the ads. It took me a bit of trial and error to get the order right as it is not described in the documentation or anywhere else I could find. But it is working fine nonetheless

Example: in row 2 you can create a new adGroup with some label, max cpc etc. In row 3 you can add a keyword to this new adGroup that you just created. And in row 4 you can add an ad with some ad level label etc

To get you started, here's the headlines I use in a script I use to build new adGroups with ads and keywords

bulkArr.unshift([ // prepend headlines

'action',

'customer id',

'campaign',

'ad group',

'max cpc',

'labels',

'Headline 1',

'Headline 1 position',

'Headline 2',

'Headline 3',

'Headline 4',

'Headline 5',

'Headline 6',

'Headline 7',

'Headline 8',

'Headline 9',

'Headline 10',

'Headline 11',

'Headline 12',

'Headline 13',

'Headline 14',

'Headline 15',

'Description 1',

'Description 2',

'Description 3',

'Description 4',

'path 1',

'path 2',

'final url',

'ad type',

'keyword',

'keyword type'

]);

sigurd

[Francisco Ortiz]

Hi Sigurd,
Thank you very much, I will make a try this way.
Best regards

Francisco

---

De : Sigurd Fabrin via Google Ads Scripts Forum <adwords...@googlegroups.com>
Envoyé : mardi 18 avril 2023 12:03
À : Google Ads Scripts Forum <adwords...@googlegroups.com>
Objet : Re: Successive Bulk uploads

 

--
-- 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/-M4fpUwo5pg/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/12310318-4207-44c7-ac43-c82c4843ce07n%40googlegroups.com.

[Google Ads Scripts Forum Advisor]

Hi All,

 

@Sigurd - Thank you for providing your insights on this as well as your continued patronage to this public forum.

 

@Fransisco - You can follow Sigurd's previous response as it appears to be able to do all three operations at once. If you do encounter any issue on your end, please let us know so our team can be able to further investigate.

[Francisco Ortiz]

Hi All,

To do a test I used the columns below with 5 records, put them in a Google Sheet, did an upload and I got 5 errors : Upgraded extension bulk upload support coming soon 

I haven't try to do it using a Google script because it is some more work but I expect to get the same error. Do you agree ?
Best regards,

Francisco

Action

Customer Id

Campaign

Ad Group

Max CPC

Ad Type

Headline 1

Headline 2

Headline 3

Headline 4

Headline 5

Headline 6

Headline 7

Headline 8

Headline 9

Headline 10

Headline 11

Headline 12

Headline 13

Description 1

Description 2

Description 3

Description 4

Path 1

Path 2

Final URL

Ad rotation

Languages

Keyword

Match Type

---

De : Google Ads Scripts Forum on behalf of adsscripts <adwords...@googlegroups.com>
Envoyé : mardi 18 avril 2023 13:14
À : adwords...@googlegroups.com <adwords...@googlegroups.com>
Objet : RE: successive bulk uploads

 

--

-- 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/-M4fpUwo5pg/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/8Nd2F000000000000000000000000000000000000000000000RTB5WR00k3HGp_vMRQ6sWdF_AewxiA%40sfdc.net.

[Google Ads Scripts Forum Advisor]

Hi Francisco,

 

Thanks for providing more information to this. Would you be so kind as to provide the following information so our team can investigate this further?:

• Google Ads account ID or CID
• Name of the script
• Complete and uncropped screenshot showing the error

 

You may send these 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 on your end still, you may send it through our email (googleadsscr...@google.com) instead.

[Sigurd Fabrin]

Yeah, you're confusing it somehow - error sounds like wrong enumerates

Try exactly following this template. It will add one new adGroup, with one keyword and one RSA. Google Ads reads and apply row 1, then row 2 etc. So make sure to feed it data in the right order

sigurd

[Francisco Ortiz]

Hi Sugurd,
Got it ! 

I was putting all information on the same line.

Thank you I will give a try.

Best regards

Francisco

---

De : Sigurd Fabrin via Google Ads Scripts Forum <adwords...@googlegroups.com>

Envoyé : mercredi 19 avril 2023 10:54

À : Google Ads Scripts Forum <adwords...@googlegroups.com>

Objet : Re: successive bulk uploads

 

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/60846658-aabb-48cc-ae7e-946a7afb125fn%40googlegroups.com.

[Google Ads Scripts Forum Advisor]

Hi Francisco,

Let us know if you encounter any issue and provide the information we requested privately using the Reply to Author option or send directly to our email (googleadsscr...@google.com) instead.

Regards,

[Francisco Ortiz]

Hi Sigurd and support

Just to let you know that I have modified my script following your advices and now it works the way I was looking for.
Thank you and have a nice weekend.

Best regards

Francisco

---

De : Francisco Ortiz <francis...@maison.fr>
Envoyé : mercredi 19 avril 2023 12:32
À : Sigurd Fabrin via Google Ads Scripts Forum <adwords...@googlegroups.com>

Objet : RE: successive bulk uploads

 

Hi Sigurd,
Got it ! 

[Google Ads Scripts Forum Advisor]

Hi Francisco,

 

We're glad that you were able to get the script working on your end. In the event that you'd need further assistance from our team, just let us know so we're able to further investigate it.