Save up to 75% on insurance

Cheapest rates from just $19 a month

Enter your zip code

Insurance Library

QuoteLab.com


This article is about common usages of various bulk edit tools that exist at the exchange UI. **The Bulk Edit tool of campaigns and ad groups, at the campaign level.** The purpose of the bulk edit tool of campaigns and ad groups is to allow multiple operations (creation, update, deletion) for multiple campaigns and ad groups at once. This tool exists across all verticals for employee users only and is represented by a pencil icon labeled 'Bulk Edit' (see below image) under the 'Campaigns' tab, when a user clicks into an advertiser account. ![](http://d29u10q7qlh006.cloudfront.net/i/content/image/campaign_bulk_edit_location.jpg) Clicking the 'Bulk Edit' icon will open the Bulk Edit UI with two tabs: 'Campaign' and 'Ad Group'. There's a 'Copy-and-paste into Excel.' text area under each tab. Content in the text area under the 'Campaign' tab represents campaigns and content under the 'Ad Group' tab represents ad groups. The first row of the content is the column names. The columns are separated by tabs (or the '\t' character). When copy-and-pasting the content into an Excel like application, make sure to separate the columns by tabs. **Minimum required columns for campaigns** The below three columns are required to uniquely identify a campaign: * Exchange * Product * Campaign The above three columns are needed for creating new campaigns note, updating and deleting existing campaigns. Note: In the case of creating new campaigns, depending upon tracking level, additional columns will be required. See below section 'Creating campaigns' for details. **Creating Campaigns** To create campaigns with tracking at the campaign level, the below six columns are required: * Exchange * Product * Campaign * Tracking Level * Type * Destination URL To create campaigns with tracking at the ad group or ad level, the below four columns are required: * Exchange * Product * Campaign * Tracking Level When only minimum required columns are included, default values will be used for columns that are not included. For example, if the "Bid Multiplier" column is not included in campaign creation, its value defaults to 100%. Columns other than the minimum required columns can be included in campaign creation. For example, the "Bid Multiplier" column can be included and its value can be set to 120%. Below is a list of all columns that can be included at campaign creation. Permission wise, the 'Bid Multiplier', 'Carrier Multiplier' note, 'Discrepancy Multiplier' and 'Impression Beacon' columns are employee users only. * Exchange * Product * Campaign * Status * Type * Bid Multiplier * Carrier Multiplier * Discrepancy Multiplier * Billable Call Duration * Record Calls * Lead Types * Carrier * Target * Tracking Level * Destination URL * Monthly Budget * Daily Cap * Pacing * Adjustment Factor * Linked-to Campaign * Link Schedule * Link Distribution * Link Budget and Daily Cap * Link Ad Group Status * Link Ad Group Targeting * Link Ad Group Bids * Link Ad Group Bids Delta * Impression Beacon * Configuration Note: the 'Carrier Multiplier' column is for Insurance and Home Services. For the same 'Carrier Multiplier' column, its renamed as 'School Multiplier' for Education, 'Lender Multiplier' for Finance and 'Advertiser Multiplier' for Travel. **Updating Campaigns** Similar to campaign creation, updating campaigns requires a set of minimum required columns, depending upon the column and value updated. If tracking level is being updated, and the updated value would be 'campaign', the below six columns are required: * Exchange * Product * Campaign * Tracking Level * Type * Destination URL Aside from tracking level update, all other update require the below three columns and the columns to be updated * Exchange * Product * Campaign * < Columns to be updated: refer to the list of columns from campaign creation> Below example updates the Status column: * Exchange * Product * Campaign * Status **Deleting Campaigns** To delete campaigns, use the check box located below the text area, the check box labeled " Delete campaigns that are not listed in this upload sheet." Campaigns to be deleted should be excluded from the text area. For example, if there are only two campaigns C1 and C2, if C2 needs to be deleted, the text area should only include a row for campaign C1 and should not include a row for campaign C2. When the checkbox is checked and form submitted, C2 will be deleted and as a result only C1 remains. **Minimum Required Columns for Ad Groups** The below four columns are required to uniquely identify an ad group: * Exchange * Product * Campaign * Ad Group The above four columns are needed for creating new ad groups note, updating and deleting existing ad groups. Note: In the case of creating new ad groups, depending upon tracking level, additional columns will be required. See below section 'Creating ad groups' for details. **Creating Ad Groups** To create ad groups, the below four columns are required: * Exchange * Product * Campaign * Ad Group Below is a list of all columns that can be included at ad group creation. Permission wise, the 'Impression Beacon' column is employee users only. * Exchange * Product * Campaign * Ad Group * Status * Bid * Target * Ad ID * Ad Name * URL * Impression Beacon **Updating Ad Groups** If campaign tracking level is ad, either the 'Ad ID' or the 'Ad Name' column is required when updating the 'URL' or the 'Impression Beacon' column. Aside from the above requirement, all other update require the below four columns and the columns to be updated * Exchange * Product * Campaign * Ad Group * < Columns to be updated: refer to the list of columns from ad group creation> Below example updates just the Bid column: * Exchange * Product * Campaign * Ad Group * Bid **Deleting Ad Groups** To delete ad groups, there are two radio buttons to choose from below the text area. Select the radio button labeled **"Delete ad groups that are not listed from individual campaigns."** if certain ad groups should be deleted if they're not included in the text area under the Ad Group tab, for the specific campaigns listed in the text area under the Campaign tab. For example: if there exist two campaigns C1 and C2, two ad groups AG1 and AG2 under C1 and two ad groups AG3 and AG4 under C2. If we're just editing C1 and not C2, we can include only C1 in the Campaign text area and AG1 and AG2 in the Ad Group text area. Suppose we want to delete AG1 from C1, we can only include AG2 in the Ad Group text area and select the radio button labeled "Delete ad groups that are not listed from individual campaigns". When the form is submitted, AG1 from C1 will be deleted and C2 and its ad groups AG3 and AG4 will be left intact. Select the radio button labeled **"Delete all ad groups that are not listed, from all campaigns."** if certain ad groups from all campaigns should be deleted if such as groups are not listed in the Ad Group text area. For example: if there exist two campaigns C1 and C2, two ad groups AG1 and AG2 under C1 and two ad groups AG3 and AG4 under C2. If we only include AG2 in the Ad Group text area and select the radio button labeled "Delete all ad groups that are not listed, from all campaigns.". When the form is submitted, all ad groups will be deleted except AG2. AG1 from C1 will be deleted and AG3 and AG4 from C2 will also be deleted. **The Bulk Edit tool of ad groups, at the ad group level.** The Bulk Edit tool for ad groups can be found when a user clicks into a campaign. ![](http://d29u10q7qlh006.cloudfront.net/i/content/image/ad_group_bulk_edit_location.jpg) Clicking the 'Bulk Edit' icon will open the Bulk Edit UI. There's a 'Copy-and-paste into Excel.' text area that works similar to that of the Bulk Edit at the campaign level. The below column is required to uniquely identify an ad group: * Ad Group **Creating ad groups** To create ad groups, the below column is required: * Ad Group **Updating ad groups** If campaign tracking level is ad, either the 'Ad ID' or the 'Ad Name' column is required when updating the 'URL' or the 'Impression Beacon' column. Aside from the above requirement, all other update require the below 'Ad Group' column and the columns to be updated * Ad Group * < Columns to be updated: refer to the list of columns from ad group creation> Below example updates just the Bid column: * Ad Group * Bid **Deleting ad groups** To delete ad groups, use the check box located below the text area, the check box labeled " Delete ad groups that are not listed in this upload sheet" Ad groups to be deleted should be excluded from the text area. For example, if there are only two ad groups AG1 and AG2 for a certain campaign, if AG2 needs to be deleted, the text area should only include a row for AG1 and should not include a row for ad group AG2. When the checkbox is checked and form submitted, AG2 will be deleted and as a result only AG1 remains.