Bid multipliers in reports

[Patrik Berggren]

Hi,

Is it possible to fetch all the different bid multipliers from reports. I think I have already found out how to fetch remarketing- and device bid multipliers, but location and ad scheduling seems to be trickier.

From what I understand I could fetch those by iterating over campaigns for instance, but what I am interested in is if I can get them in a report.

Any help would be very much appreciated! :)

[Tyler Sidell (AdWords Scripts Team)]

Hi Patrik,

There are a bunch of reports that may be of interest to you.  If you're looking specifically for bid multipliers based on ad scheduling you may want to specifically take a look at the Campaign Ad Schedule Target Report.

You can set up something similar to the code snippet below:

var report = AdWordsApp.report(
      'SELECT CampaignName, BidModifier ' +
      'FROM   CAMPAIGN_AD_SCHEDULE_TARGET_REPORT ' +
      'DURING YESTERDAY');

Thanks,

Tyler Sidell

AdWords Scripts Team

[Patrik Berggren]

Thanks for your reply.

Perhaps I should have specified that I have found both the Campaign Ad Schedule Target Report and the Campaign Location Target report, but my problem is rather to get the corresponding dimensions for the bid modifiers doesn't seem to be available in the report which is a bit confusing.

For instance, in the Campaign Ad Schedule Target Report you can get the bid modifier, but I can't find a dimension (column) for the actual time interval for which the bid modifier is active.

For instance

Campaign, Interval, Bid modifier

name, 9-13, 15%

and similiarly for Campaign Location Target. Basically, I am looking to find the same information that is available in the bid multiplier tabs in campaign settings in the GUI interface.

I suspect somewhat that there is something that I have misunderstood, because without those dimensions the bid modifier doesn't seem to mean much. 

[Tyler Sidell (AdWords Scripts Team)]

Hi Patrik,

Currently the dimensions field isn't available in reports from AdWords Scripts.  As a workaround, I would suggest to change the date range in your report query in order to see the difference between bid modifiers in your campaign.

Thanks,

Tyler Sidell

AdWords Scripts Team

[Patrik Berggren]

Thanks, that should at least mean I can get weekday-level bid multipliers.

Just to clarify since it also has to do with the original question, should the BidModifier then be interpreted as the average modification of the bid for every impression that is selected? 

[Tyler Sidell (AdWords Scripts Team)]

Hi Patrik,

Would you be able to elaborate more on your use case?  Usually the BidModifier is a fixed number.  Are you asking if it is the average in reports if you order by impressions?  The bid modifier should only be different depending on the day that you select.

Thanks,

Tyler Sidell

AdWords Scripts Team

[Patrik Berggren]

Hi,

The use case is mainly reporting. But also for potentially doing active bid changes in which case it will be important to know what the actual Max CPC (i.e. max cpc together with bid adjustments) for all impressions. It is probably possible to extract the number of impressions for each possible subset of the dimensions remarketing, device, time (for ad scheduling bid adjustments), and location. Given that one can fetch the corresponding bid adjustments for each of those dimensions separately it would be possible to get the actual max CPC for all impressions.

However, in the case that it is not possible to extract all bid multipliers I would like to opt for a as good as possible solution.

So basically I am trying to figure out what kind of information I can get about the location and ad scheduling bid adjustments seen as the "Day and Time" and "Location" dimensions aren't available.

Say for instance that I can see the following under Settings->Ad schedule

Day and Time,                             Campaign,                Bid Adj,         Impressions,       Clicks

Monday, 09:00 am-03:00 pm,      campaign1,               15%             1000                   50

Monday, 03:00 pm-06:00 pm,      campaign1,               -15%            1000                   100

Say that I use the Campaign Ad Schedule Target Report to pick out one specific monday using the date column and also campaign1. What would the bidModifier show then?

That is, how are the bidModifier computed from the bid Adjustments?

[Patrik Berggren]

Hi again,

So the first confusion about what each row represents seems to be cleared by the id column in each of the campaign location targeting report and campaign ad scheduling report.

For location the ID also seems to be enough to fetch the actual location by joining the table with the table for ID and locations:

https://developers.google.com/adwords/api/docs/appendix/geotargeting

However, I am still lost in regard to how the ID is built in the campaign ad scheduling target report. The id seems to have more information in it then would be required so I suspect that the ID is in a one-to-one correspondence with a specific time interval, but I am unable to find the table for that conversion.

[Tyler Sidell (AdWords Scripts Team)]

Hi Patrik,

The ID for the Campaign Ad Scheduling Target Report is mapped to the AdSchedule ID.  The method, AdWordsApp.AdSchedule.getId() will return the ID of the ad schedule.  Each particular ad schedule will have their own unique ID.

Thanks,

Tyler Sidell

AdWords Scripts Team

[Patrik Berggren]

Good, so then the ID to ad schedule is an injective function. Sitting down and actually trying to reverse engineer the ID was apparently much easier than I expected so I guess I should have started with that. Anyway, for anyone reading here is the conversion that I was wondering about, which together with the location ID conversion then allows you to get all bid modifiers.

An Ad schedule ID consists of 6 digits,

First digit is always 3, I guess type of bid modifier

Second digit is the weekday 0-6 for monday-sunday,

Next two digits is start time, represented as 00-96 corresponding to quarters of hours, i.e. 04 means 1 am and 06 means 1:30 am. Only "tricky" thing here is that 00 am is represented as either 00 or 96 depending on if it is the start or end time.

Next two digits is end time represented in the same way.