Conversion value rules (CVRs) allow you to provide additional value information that isn’t already reflected in your account and optimize in real time to those values. Conversion values are adjusted by the specific rules and reported in the conversion value column of your account. Learn how to set up conversion value rules.
The bulksheet can only support conversion value rule uploads for CVRs created for campaigns. This article explains how to format the bulksheet for uploading CVRs for campaigns.
Before you begin
Search Ads 360 allows you to upload CVRs in bulk. Bulk uploads for CVRs allow you to set conditions, such as audience or locations, to adjust conversion values based on your customers’ attributes and their relative value to your business. Using bulk uploads help you do all the adjustments using a bulksheet, saving you from manual effort. The bulksheet supports creation, edit and removal of CVRs.
Format the “value rules” column in the bulksheet
Set the following values in the “value rules” column:
- Conversion goal: [all, OR store visits]
- Primary condition: condition type, conditions
- condition type: [device, location, audience segment, no condition].
- device conditions: [tablet, desktop, mobile], multiple values should be separated by "||"
- location conditions: [inclusion list: followed by a list of locations separated by "||", exclusion list: followed by a list of locations separated by "||", inclusion list option: "People in these locations" OR "People in, or showing interest in, these locations", exclusion list option: "People in these locations" OR "People in, or showing interest in, these locations]
- audience segment conditions: segment_1 || segment_2 || segment_3
- condition type: [device, location, audience segment, no condition].
- (If necessary) Secondary condition: condition type, conditions
- Operation: [add, or multiply]
- Value: [enter value]
- Status: [enabled OR paused]
Important things to note:
- The bulksheet can only support conversion value rule uploads for CVRs created for campaigns.
- CVR bulksheet supports creation, edit and removal.
- To create a new CVR, enter the desired parameters with a status: enabled.
- To remove all CVRs from a campaign, enter ‘remove_value’.
- To edit an existing CVR, enter the CVRs with updated parameters.
- To remove only 1 CVR for a campaign that has multiple CVRs, edit the CVR column with the CVRs you want to keep.
- For example, if a campaign has CVR1 CVR2, the user will just fill out the Value rules column with only CVR1 to remove CVR2.
- You can also pause or create new CVRs as paused. To do so, enter status: paused
- If the Value Rule column is left empty, the bulksheet will not change the CVRs for the campaign. Similarly, if no change is made to the Value Rule cell, the bulksheet will not make any updates to the CVRs.
- This feature does not support Google Ads CVRs in Search Ads 360.
Example bulksheet rows
| Row type | Action | Campaign ID | Customer ID | Campaign type | Value rules |
|---|---|---|---|---|---|
| Campaign | Edit | 123456789 | 159112345 | Search |
Conversion goal: store visits Primary condition: no condition Operation: set Value: 10 Status: paused
Conversion goal: all Primary condition: location, inclusion list: Redmond, Washington, United States, inclusion location option: People in, or showing interest in, these locations , exclusion list: Seattle, Washington, United States || Orange County, California, United States, exclusion location option: People in these locations Secondary condition: audience segment, Autos & Vehicles || Banks Online || Frequently Visits Salons Operation: add Value: 99 Status: enabled
Conversion goal: all Primary condition: device, tablet || desktop Secondary condition: audience segment, Office Supplies || Parents of Toddlers (1-3 years) || custom audience Operation: add Value: 50 Status: paused
Conversion goal: all Primary condition: device, all Secondary condition: location, all Operation: add Value: 1 Status: enabled |
| Campaign | Edit | 123456789 | 159112345 | Search | remove_value |
Upload the bulksheet for CVRs
Use the following steps to upload the bulksheet for CVRs:
- Sign in to your new Search Ads 360.
- From the page menu, click Campaigns.
- From the table toolbar, click on the
3-dot menu.
- Click Upload.
- Under “Upload spreadsheets”, select “Select source” and click Upload file.
- Click Select a file from your computer.
- Select if you want to apply the changes to a single account or multiple accounts.
- Click Apply.
3-dot menu.