The Google team is sunsetting Bulkdozer on August 15th, 2023. Bulkdozer was originally developed to help users automate bulk editing capabilities that can reduce trafficking time in Campaign Manager 360. As Google products evolve, the gap that Bulkdozer covers has successfully shrunk and we encourage users to work with the new product features and offerings.
Campaign Manager 360 added a new feature to leverage spreadsheets to easily manage CM360 entities and assignments in bulk. The new Campaign Import/Export functionality will allow you to specify the format of the spreadsheet so that you can easily update CM360. This update adds column selection and saved templates, row filtering, custom timezone for dates and more. Please visit the CM360 support page for more information.
We appreciate the contributions of the community that helped make Bulkdozer a success for many years.
Bulkdozer is a Google Sheets-based tool leveraging Apps Script and the CM360 API to load and visualize CM360 campaign data, allowing the user to traffic more efficiently at scale. Bulkdozer can create and edit Campaigns, Placement Groups, Placements, Ads, Creative Assignments, Landing Pages and Event Tags.
- Products
- Campaign Manager 360
- Google Workspace (Google Sheets)
Use the link below to navigate to the tool. Refer to the "Instructions" tab of for details on how to deploy and use the solution.
Due to recent Apps Scripts changes, an extra configuration is required for Bulkdozer to work properly. Please follow the steps below:
- In your Bulkdozer Google Sheet copy navigate from menu 'Tools' > 'Script Editor'.
- In the Script Editor, navigate to the 'Editor' tab in the outer left nav (icon looks like '< >' brackets)
- Under the 'Services' section of the inner left nav, click on the vertical three-dots next to the 'DoubleClickCampaigns' service and click 'Remove' and then click 'Remove service' on the confirmation pop-up.
- Click the '+' button next to Services in the inner left nav to re-add the service.
- In the list of services select 'Campaign Manager 360 API' and check that the version is 'v4' at this time and that the 'Identifier' is the same 'DoubleClickCampaigns'.
-
Make a Copy of the Bulkdozer Google Sheet Bulkdozer 0.4
-
Your permissions in Bulkdozer are tied to your CM360 Profile’s Permission for a given CM360 Account. In the Store tab, next to profileid (Row 2B), input your CM360 Profile ID for the appropriate CM360 Account that you will be trafficking in. Without this, Bulkdozer will not work.
-
The Bulkdozer Sidebar: The Bulkdozer sidebar is where you access all Bulkdozer functionality. To open the sidebar select the custom menu at the top Bulkdozer -> Open.
-
Status: The "Status" text tells you what Bulkdozer is currently doing. "Ready" means it is not executing any jobs and it is ready to process your next command. When jobs are running, this status text changes to reflect the actions that are being performed. Ensure you see “Ready” everytime after Loading From/Clearing Feed/Pushing To CM.
-
Clear Feed: This button will clear CM data from all tabs in the feed, preparing it for the next activity, such as switching to work on a new campaign. In general, best practice is to Clear Feed before each use.
-
Load from CM: This button will load data from CM
- Which data to load is identified by the IDs in the ID columns of the respective tabs. For instance, if you would like to load all entities under a given Campaign, enter the Campaign ID in the Campaign ID column of the Campaign tab and click Load from CM.
-
Push to CM: This button will push any feed changes back to CM.
-
Bulkdozer loads data from CM based on IDs you input in the respective tabs. You can load entire campaigns or specific Placement Groups, Placements, and Ads. Bulkdozer will load items in "cascade", e.g. if you decide to load a Campaign(s) everything under the specified Campaign(s) will be loaded. If you decide to load Placements, everything under the placements will be loaded but not upstream items such as Campaigns or Placement groups. This behavior is intended to allow you to load only the specific items you want to modify.
-
Next, go to the tab that represents the top level entities you want to load. E.g. if you want to load an entire Campaign go to the Campaign Tab and enter the appropriate CM360 Campaign ID in the Campaign ID field. If you only wanted to load specific placements go to the Placement tab and enter the Placement IDs instead, and so on.
-
You can also mix and match, for instance you could load 1 entire campaign, 3 placement groups from another campaign, and 2 placements from yet another placement group by specifying the correct ids in the correct tabs. Bulkdozer’s power is in its flexibility to bulk edit across many Placements, Campaigns and Advertisers. You may very well choose to pull in several Campaigns and traffic them all at once in a single sheet.
-
Finally open the sidebar and click "Load from CM". Monitor the Log tab until the sidebar status changes to "Ready", which indicates the loading process is complete and CM data is populated in the respective tabs.
-
-
-
Orange: User provided, used on insert only, not updateable after initial creation.
-
Black: IDs. User provided:
- In the “ext..” format for initial creation or, actual IDs for existing items for mapping purposes.
- Creating new entities, the “ext..” format:
- Seen below, there are two existing Placements in this CM Campaign. We are telling Bulkdozer to create a third placement by entering “extP3” in the Placement ID field, while also filling out the other fields. This is what your entry might look like BEFORE clicking “Push to CM”:
- Once the push is completed (Status: Ready), extP3 will be replaced by the newly created CM360 Placement ID, looking something like this:
- You can use any alphanumeric combination after ext to notate a new entry. You could just as easily use “extNewThing99” in this Placement ID example to create an additional Placement. We advise on simple naming conventions to make it easier to manage, such as “extP1” and “extP2” for two new unique Placements, “extA1” for a new Ad, “extC1” for a new Campaign, etc.
- In the “ext..” format for initial creation or, actual IDs for existing items for mapping purposes.
-
Gray: Populated upon “Load From CM” by Bulkdozer for trafficker convenience.
- Example, in the Placement tab the Campaign Name column is provided so you know the Campaign with which a Placement is tied to but- it is not an editable field.
- Not used for insert or update.
-
Green: Updateable fields, used for inserting new items, and can be updated in subsequent executions.
Column Headers that are underlined are required fields for their tab.
-
Load From CM: at the Campaign-level. Enter the appropriate Campaign ID in the that field on the Campaign tab
-
Let's create a new Event Tag that we will apply in bulk to all Ads under one of our Placements.
-
Go to the Event Tag tab enter a new row:
- Advertiser ID: The same Advertiser ID as your campaign, refer to the Campaign tab.
- Campaign ID: Select your campaign ID from the dropdown.
- Event Tag ID: extET1
- Event Tag Name: Bulkdozer Event Tag 1
- Event Tag Status: (ENABLED)
- Enable By Default: (TRUE or FALSE)
- Event Tag Type: (Image or Script)
- Event Tag URL: Any valid url starting with https://
-
Associate Event tag to an Ad
- Navigate to the Event Tag Ad Assignment tab:
- Event Tag ID: Select EXT1 from dropdown
- Ad ID: Select appropriate Ad ID from dropdown Status: Select ACTIVE from dropdown
- Navigate to the Event Tag Ad Assignment tab:
-
Push to CM
-
Load From CM: at the Campaign-level. Enter the appropriate Campaign ID in the that field on the Campaign tab
-
Create a new Ad
- Go to the Ad tab and add a new row with the following:
- Campaign ID: Pick the campaign ID from the drop down.
- Ad Type: AD_SERVING_DEFAULT_AD
- Ad Priority: AD_PRIORITY_1
- Ad ID: extAD1
- Ad Name: Bulkdozer new ad in existing campaign
- Ad Start Date: Same as the start date in the Campaign tab
- Ad End Date: Same as the end date in the Campaign tab
- Fields not mentioned above can be left blank.
- Go to the Ad tab and add a new row with the following:
-
Assign new Ad to existing Placements: In the Ad Placement Assignment tab, add a new row:
- Placement ID: Pick an existing placement ID from the drop down.
- Ad ID: extAD1
-
Assign existing creative to new Ad: In the Ad Creative Assignment tab, add a new row and include:
- Ad ID: extAD1
- Creative ID: Pick a creative ID from the drop down.
- Fields not mentioned above can be left blank.
-
Push to CM
Important: Bulkdozer helps with the swapping of Creative assignments. However, the actual creative must be previously loaded into either the Advertiser or (preferably) the Campaign. Bulkdozer does not facilitate the uploading of creatives.
-
Load From CM: at the Campaign-level. Enter the appropriate Campaign ID in the that field on the Campaign tab
-
(Skip this step if the creative is already uploaded to the Campaign-level) Pull Creative stored in the CM Advertiser into a specific Campaign. Go to the Creative Tab and enter a new row including:
- Advertiser ID: The Advertiser ID associated with the applicable Campaign and Creative.
- Campaign ID: Select your Campaign in the drop down.
- Creative ID: The ID of the Creative you want to import from the Advertiser-level to the Campaign-level for assigning
- Creative Name: Name of the Creative you want to import from the Advertiser-level to the Campaign-level for assigning (To note: what is entered here will replace that Creative’s Name at both the Advertiser and Campaigns-level. Leave blank if keeping the existing name)
-
Swap the creatives
- Go to the Ad Creative Assignment tab, and update the Creative ID Column to be the ID of the Creative you want to swap in to each respective Ad.
-
Push to CM
By using Bulkdozer the user agrees with the Terms & Conditions.
Bulkdozer is community supported, if you have any issues or questions please post a new issue here.
Sign up for updates and announcements: Bulkdozer Announcements.
The files below are a simplified version of Bulkdozer 0.4 and only include a specific Bulkdozer feature.
These modules are not actively maintained