Sales – Mapping

Sales – Mapping

Mapping is an important feature of Curve. By creating links between values in the sales data & your settings & catalogue, the statements & data analytics you produce will contain accurate, standardised metadata. Sales reporting from different sources will inevitably use different phrasing or spelling for key metadata. DSPs may use territory names versus codes (The Netherlands/NLD/NL), or have different terminology for configurations (Premium Stream/Interactive Stream/On-Demand Stream), or Distributors sometimes spell retailer names differently (itunes/i-Tunes/Itunes). The Mapping tool allows you to map these varieties in terminology or spelling to your Curve standards.

As you will see in the Post Ingestion section of the Sales Upload documentation, the most convenient way to create a Map is when uploading a sales file. However, the Mapping Tabs on the Sales Templates is a useful way to review, create, delete or edit your Maps. Below are some examples from the Mapping Tab on a Sales Template.


In the first example when “The Netherlands”, displayed on the right, is reported in sales data, it will be mapped to “Netherlands”, selected on the left. The second example has “On-Demand Stream” mapped to our configuration “Premium Stream”. NB You can change or increase the available options in the Settings Area. In the final example the Source value “I-Tunes” is mapped to the user’s preferred spelling “iTunes”.

COPY FIELDS

Also on the Mappings tab, you can match a single column with multiple fields using the Copy Fields section. If for example, the original sales file has a column that specifies the Net Amount but does not have a column specifying the Gross Amount, we can use a Copy Field for this. In our example, we would match the column specifying the net amount to our Net Amount field. Then using a Copy Field we can copy this value to the Gross Amount, essentially making both fields match to the same column and storing the same values.