Device bid adj. - Script to change adj in bulk

617 views
Skip to first unread message

Hadar Yanos

unread,
Aug 21, 2016, 9:47:21 AM8/21/16
to AdWords Scripts Forum
HI,

Now that DBA rolled out in many accounts, I was wondering if you have any script that can change in bulk all the device adj in the account?
I want to create a sheet with each campaign and adj for every device and use Adwords scripts to set it. Is this possible? 
(Adwords editor version that supports the new feature will only come out at the end of September).

Thanks! 
Hadar 

Tyler Sidell (AdWords Scripts Team)

unread,
Aug 22, 2016, 11:12:55 AM8/22/16
to AdWords Scripts Forum
Hi Hadar,

To get started with Device Bid Adjustments, you would want to use the follow script.  It looks for all ad groups currently in that account and applies a device bid modifier for mobile.  If you want to target a different device, please follow the suggestions here.

function main() {
 
var agDevice = AdWordsApp.adGroups().get();  
 
while (agDevice.hasNext()) {
   
var ag = agDevice.next();
    ag
.devices().setMobileBidModifier(0.1);
 
}
}

Thanks,
Tyler Sidell
AdWords Scripts Team

Trevor

unread,
Aug 22, 2016, 11:14:42 AM8/22/16
to AdWords Scripts Forum
This is definitely possible. The new platform bidding entities are covered here: https://developers.google.com/adwords/scripts/docs/reference/adwordsapp/adwordsapp_platform

If you gave us a little more information about how you'd want to lay out the spreadsheet I could look at putting something together, though this also might be possible (and easier) through bulk uploads.

Hadar Yanos

unread,
Aug 22, 2016, 1:05:37 PM8/22/16
to Trevor via AdWords Scripts Forum
Hi Trevor!
Thanks for answering. 

How can i do it with bulk uploads? As i see, Editor will only be available during end of September. 

About the script - I want to create a spread sheet with 5 columns: Account name, campaign name, Tablet bid adj., Mobile bid adj., Computer bid adj. 
The script will go over the spreadsheet and will update the adj. in all of the campaigns.

Many thanks for your help!

Hadar 





Inline image 1
 Hadar Yanos
 Analytical lead
 Google Israel

--
-- 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 "AdWords Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/4yHH5FgPGFk/unsubscribe.
To unsubscribe from this group and all its topics, 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/0421d377-2a63-4662-9af8-d1d22cffba1a%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Tyler Sidell (AdWords Scripts Team)

unread,
Aug 22, 2016, 5:05:04 PM8/22/16
to AdWords Scripts Forum
Hi Hadar,

Our documentation will walk you through setting up a Bulk Upload.  These are the supported Bulk Upload entities that you could use.  Also, check out the samples that we provide.

As for reading from a spreadsheet, you can use the openByUrl method in the SpreadsheetApp class in order to achieve this.

Thanks,
Tyler Sidell
AdWords Scripts Team

On Monday, August 22, 2016 at 1:05:37 PM UTC-4, Hadar Yanos wrote:
Hi Trevor!
Thanks for answering. 

How can i do it with bulk uploads? As i see, Editor will only be available during end of September. 

About the script - I want to create a spread sheet with 5 columns: Account name, campaign name, Tablet bid adj., Mobile bid adj., Computer bid adj. 
The script will go over the spreadsheet and will update the adj. in all of the campaigns.

Many thanks for your help!

Hadar 





Inline image 1
 Hadar Yanos
 Analytical lead
 Google Israel

On Mon, Aug 22, 2016 at 6:14 PM, Trevor via AdWords Scripts Forum <adwords-scripts+APn2wQeVOIP5BuPKjpb7evbS_EU1kUiB0CsiCPJZNJhOXcgo@googlegroups.com> wrote:
This is definitely possible. The new platform bidding entities are covered here: https://developers.google.com/adwords/scripts/docs/reference/adwordsapp/adwordsapp_platform

If you gave us a little more information about how you'd want to lay out the spreadsheet I could look at putting something together, though this also might be possible (and easier) through bulk uploads.


On Sunday, August 21, 2016 at 6:47:21 AM UTC-7, Hadar Yanos wrote:
HI,

Now that DBA rolled out in many accounts, I was wondering if you have any script that can change in bulk all the device adj in the account?
I want to create a sheet with each campaign and adj for every device and use Adwords scripts to set it. Is this possible? 
(Adwords editor version that supports the new feature will only come out at the end of September).

Thanks! 
Hadar 

--
-- 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 "AdWords Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/4yHH5FgPGFk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.

Hadar Yanos

unread,
Aug 23, 2016, 2:53:58 AM8/23/16
to AdWords Scripts Forum on behalf of Tyler Sidell (AdWords Scripts Team)
Thanks Tyler, 
I checked the entities but there aren't metrics of Bid Adjustment, so how can i use bulk uploads?


Hadar 




Inline image 1
 Hadar Yanos
 Analytical lead
 Google Israel

To unsubscribe from this group and all its topics, 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/d3c73320-e924-4cf6-ace7-ffe39263be37%40googlegroups.com.

Anthony Madrigal

unread,
Aug 23, 2016, 3:54:43 PM8/23/16
to AdWords Scripts Forum
Hi Hadar,

Unfortunately, device bid adjustments are not available through bulk uploads. You will need to set them as Tyler mentioned initially.

Please let me know if you run into any issues in doing so.

Regards,
Anthony
AdWords Scripts Team

Yoann Ferrand

unread,
Sep 7, 2016, 10:12:42 AM9/7/16
to AdWords Scripts Forum
Hi Trevor,

We have currently a similar need to Hadar.

We would need a script that set the device modifiers (tablet, mobile & desktop) at the ad group level from a google spreadsheet.

[AccountID] / [CampaignName] / [AdgroupName] / [BidModifier] / [Device]
0000000 / +{d} +table tennis / Buy / 1.3 / Desktop => setDesktopBidModifier
0000000 / +{d} +table tennis / Buy / 0.5 / Mobile => setMobileBidModifier
0000000 / +{d} +table tennis / Buy / 0.7 / Tablet =>setTabletBidModifier

Are you able to put something together with these details?

Thank you in advance,

Yoann

Tyler Sidell (AdWords Scripts Team)

unread,
Sep 7, 2016, 10:32:12 AM9/7/16
to AdWords Scripts Forum
Hi Yoann,

Would you mind creating a separate thread?  It will better help us track your particular issue.

Thanks,
Tyler Sidell
AdWords Scripts Team

Reply all
Reply to author
Forward
0 new messages