**Bulk associate your bands to market data**

To bulk associate your bands to market data, you can follow these steps or work with your Implementation Manager.

**Complete the bulk association csv template**


1. Download the bulk associations csv template by navigating to Market Pricing -> Job mapping and survey logic-> Map job families-> Download CSV

    ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001ffR&feoid=00NUn00000C06g9&refid=0EMTV00000En4gl) 
2. Fill out the CSV with the related survey data per band, [see example here](https://docs.google.com/spreadsheets/d/1GFN--WS6s4TvVaFUksTfdN0sL1YpnrntejCP1D3Ty0I/edit#gid=555730742)
   * Job Code
   * Target Percentile - must be represented as p50 if 50th percentile or p60 if 60th percentile
   * Survey Location Breakout - exactly as it’s represented in the survey, e.g. US - SF Bay Area
   * Survey Breakout - if relevant, e.g. Peer Group Name, exactly as it is in the survey
   * Pay Type - must be represented as “basepay” or “totalcash”
   * Weight - include “1” in the csv
3. If you are associating multiple percentiles of the same or different job code to a single band:
   * Copy the band row and include the secondary or tertiary market data info, with the relative weight.
   * Update the weight for each additional row. You can think of weights as ratios, so if you had two benchmarks each with 1 weight, they would be weighted equally. If you wanted to weight one at 60% and the other at 40% you could add 6 and 4 or a ratio of 3 and 2.
4. If you use multiple surveys, you’ll would download the same bulk association template, and include this information for each additional survey.

You’ll also be able to easily view and edit your market data associations individually in the product.

**Upload the bulk association csv**


1. To upload your completed bulk association csv, go to the Market Data tab on the band set to associate market data with those bands
2. Select upload csv - and choose from "Add or Update Associations" and "Replace Associations" depending on your intended outcome
   * Add or Updates Associations: Add new associations or update existing associations. Existing slice associations will not be deleted.
   * Replace Associations: Replace all associations in the band set. All existing associations will be overridden
3. Select the survey you want to bulk associate your bands to
   * Note: If you use multiple surveys, you will need to upload a different association files for each band set

## Edit your market data associations on your bands

In order to view or edit your market data associations, you can navigate to Benchmark View in the upper right hand corner “view.” You can filter for specific bands using the filters at the top of the page.

 ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001ffR&feoid=00NUn00000C06g9&refid=0EMTV00000EnOYz)

 ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001ffR&feoid=00NUn00000C06g9&refid=0EMTV00000EnOab)

You can also access, view, and edit your market data associations by clicking on the Benchmarking sidepeek in Table View or clicking “Manage” to go directly to the Benchmark View of that job family and ladder.

 ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001ffR&feoid=00NUn00000C06g9&refid=0EMTV00000EnJXi)

The main actions you’ll want to take from here are:

**Update your market associations**

You can add many market associations to your band to create the best benchmark:


1. Choose a data source from your Pave data or third party market data
2. Filter down to a specific job code, title, family, level, country
3. Choose a percentile
4. Review the # of employees and # of countries to identify the best benchmark
5. Use the + icon to match market data to your band

    ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001ffR&feoid=00NUn00000C06g9&refid=0EMTV00000EnOkH)

**Update the weights to create your composite benchmark**

* A composite benchmark is a summary of the benchmark(s) associated with the band, with or without weighting
* You can weight multiple benchmarks together to create your composite benchmark by inputting a different weight under the weight section in benchmarking view
* Weights will automatically show as 1
* You can think of weights as ratios, so if you had two benchmarks each with 1 weight, they would be weighted equally. If you wanted to weight one at 60% and the other at 40% you could add 6 and 4 or a ratio of 3 and 2.

   ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001ffR&feoid=00NUn00000C06g9&refid=0EMTV00000EnItQ)

**Update the visibility of different associations on the band visualization**

* In table and chart view, only the composite benchmark is visible on the band visualization, not the individual market data associations.
* In benchmark view, the different market data associations and the composite benchmark are visible on the band visualization
* If you don’t want specific market data associations to impact your composite benchmark or you don’t want to see them on the band visualization (but want to reference them in the benchmarking expanded view for that band), you can toggle the visibility of the benchmark using the “eye” icon on the associated row.
* If you make the weight 0, the association will no longer impact the composite benchmark and will still be displayed on the band visualization but at a lower opacity.
* If you no longer want to use the market data association for benchmarking, you can delete it using the “X” icon on the associated row.

 ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001ffR&feoid=00NUn00000C06g9&refid=0EMTV00000Emu7u)

**Download your benchmark associations**

* At any point, you can download your your latest associations of your bands and market data, representative of any edits you’ve made since you’re last bulk association
* To do so, return to Band Set > Market Data Tab
* Click “Download Benchmarks” which will download a CSV

 ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001ffR&feoid=00NUn00000C06g9&refid=0EMTV00000EnOp7 " =1232x192")

* In the CSV you will see:
  * Band information
  * Market data information for related to each band: Survey name (as you’ve named it in Pave), job code, break out, location, job family, job level, slice type (third party survey, Pave), currency, pay type, pay amount (benchmark value), percentile, weight, and aging factor (if aged)
  * You will see separate rows for each market data slice associated to the band and separate rows for each pay type (as well as market data slices)

 ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001ffR&feoid=00NUn00000C06g9&refid=0EMTV00000En2zw)

Bulk & Manually Associate Market Data to Bands

Pay Types: Calculated TDC, Annual Equity, and Refresh Equity

Band Sets

Employee Distribution in Bands

Editing Bands

View changes

Upload/Download Bands

Unmatched Employees

Calculated Columns

Managing & Reordering Calculated Columns

How to duplicate band sets

Survey aging

Edit and apply benchmarks

Set weights and logic

Map data sources to jobs

Supported survey providers

Manage Pave data sources

Manage survey data sources

Benchmarks overview

Step 2: Benchmarking

Bands Set Audit Log

Manually Create New Band Sets

Job Architecture 101

Pay Zone Manager

Grades

Setting up Company Job Architecture

Company Job Architecture

Step 1: Build Foundation

Generate Bands from Market Data

Step 3: Update Ranges

Generate Bands for New Jobs in Your Job Architecture

Compare Bands

Relative Permissions

Advanced Filters

Ongoing Management & Analysis

Market Pricing

Market Data Connections Set up

Market Data Connections Overview

Integrations 101

Integrations

Adding Columns

Team View Overview

Team View Column Configuration

Team View Customizations

Re-ordering Columns

Deleting Columns

Team View Settings

Team View

Comp Planner Configurations Overview

Compensation Planner 101

Getting Started - Compensation Planner

Compensation Planner FAQs

Cycle Specific Permissions

Employee Eligibility

Step 1: Initial Cycle Setup

First-Class Columns

Using Handlebars Formula for Calculated Columns

Columns

Step 2: Column Configuration

OTE Planning Configuration Guide

What is OTE Planning?

Step 3: OTE Planning

Am I able to update or change approval chains during a cycle?

Updating Approval Chains

Compensation Cycle Data Upload

Step 4: Data Management

How can I configure market adjustment recommendations for employees?

How can I configure variable raise recommendations for employees?

Recommendation Logic

What are Recommendations?

Step 5: Recommendation Logic

Budgets

Budget Dashboard

Top Down Budgets: In-app Configurations

Step 6: Budget Confirmation

Planning Windows Setup Guide

Planning Windows Overview

Monthly & Hourly Pay

Employee Compensation History Popout

UI Toggles

Filtering & Sorting

Approval Statuses

Step 7: Planner Experience

Smart Flags

Compensation Outliers

Manager Compression Flag

Vesting Drop Flag

Step 8: Controls & Governance

Peers Overview

Cycle Outcomes

Value Rounding in Compensation Planning

In App Reward Letter Editor

Reward Letters

Peers Configuration Guide

Cycle Progress Dashboard Overview

Other Cycle Actions

 Compensation Planner

Logging In

Custom Role Creation Guide

Creating an Account

How to add a colleague to Pave’s Market Data Platform

Market Data Role Management

Why does it matter to get levels and role families right?

SSO Configuration Guide

Account Setup

Contact Us

How much does Pave Market Data access cost?

How does Pave Work?

Intro to Pave

Pave 101

Compensation Philosophy

Total Compensation

Compensation 101

The Stock Option Lifecycle

ISO Tax Implications

The Basics of Stock Options

The Confusing AMT (Alternative Minimum Tax)

ISO Strategies

An Overview of How Stock Options Work

Equity 101

Account Creation Troubleshooting and FAQs

How to Benchmark Executive Compensation

Login Troubleshooting and FAQ

How does company size affect which department, job family and job level I should choose?

How does Pave determine a role level and role family?

What are Job Levels, Departments and Job Families? Why are they important?

Troubleshooting Rippling Zero Records Error

What Market Data Connections does Pave currently support?

FAQs

Getting Started

Option Driver Deprecation FAQs

Option Driver

Option Impact Deprecation FAQs

Option Impact

Option Impact & Option Driver

Executive Reporting Dashboard

Cycle Monitoring and Reporting

Building Market-Based Compensation Bands

Employee Groups

Cycle Configuration

How does Recommendation Logic work?

Am I able to change another user’s permissions or login credentials while impersonating?

Bulk & Manually Associate Market Data to Bands

Share

Share

Bulk & Manually Associate Market Data to Bands

Share

Share