Answers & ito training - PowerPoint Presentation

Slide1

Answers &

ito

training

Slide2

Overview

Agenda

Data Selections

Data Output

Interface to Office

Some of the topics also include links to additional training material – please note that these cover the basic training but may also go into some more advanced detail

Slide3

NIELSEN ANSWERS DESKTOP OVERVIEW AND INTERFACE

https://nielsen.wistia.com/medias/9a62ah01lz

Please click on the video or the link at the bottom of the page

Slide4

DATA SELECTIONS

Slide5

DATA SELECTOR

https://nielsen.wistia.com/medias/hq4ovgnpn4

Please click on the video or the link at the bottom of the page

To access the PDF summary, please click here:

https://answers.nielsen.com/portal/workspace/GB+Nielsen+Answers+Training+Documentation/NAD+Digital+Training+Library/NAD+Job+Aids/2.2+Data+Selector+Overview.pdf

Slide6

PRODUCT SELECTIONS

Products are organised following a hierarchy

Each product is coded with a set of attributes or characteristics

This is the way you will be able to find, filter and select them in Answers

CATEGORY:

COSMETICS

Attributes/characteristics -

describe a product and define the selling points, based on physical characteristics of the product as noted on the retailer description of the item

MANUFACTURER: BARRY M COSMETICS

BRAND: BARRY M

SECTOR: NAIL

SUB-SECTOR: NAIL COLOUR

VARIANT: UNDER THE SEA

Slide7

WORKING WITH CHARACTERISTICS & HIERARCHIES

Total

Cosmetics

Barry M Cosmetics

Barry M

Lip

Total

Category

Manufacturer

Coty

Brand

Sector

Sub-Sector

Variant

Nail

Nail Care

Nail Colour

Under The Sea

Classic Nail Paint

Slide8

DATABASE HIERARCHIES

Database Hierarchies

Main Attributes

Some databases will have additional hierarchies underneath the Main Attributes (e.g. KAD hierarchies)

Slide9

Step 1. Select one box/level in one of the hierarchies. If you select more than one you risk double counting

You can only filter by the characteristics present in that hierarchy (if the characteristic is not there then use another hierarchy).

HIERARCHIES VS. CHARACTERISTICS

Step 2. Filter

your selections by characteristic to get to the exact products you need.

Slide10

AIM: SELECT

BARRY M NAIL COLOUR variants

Step 1. Select

Variant

in the main hierarchy

Step 2

. Filter on characteristic e.g. Brand (Barry M), Sub Sector (Nail Colour)

Slide11

AIM: SELECT BARRY M NAIL COLOUR variants

1

2

3

Products selected using the characteristics button

All data pulls have a similar method – the more you practise the better you will understand the databases and how to navigate them!

To access the PDF summary, please click here:

https://answers.nielsen.com/portal/workspace/GB+Nielsen+Answers+Training+Documentation/NAD+Digital+Training+Library/NAD+Job+Aids/2.1+Creating+a+Basic+Query+Overview.pdf

Slide12

DATA OUTPUT

Slide13

CREATING AND MANAGING FAVOURITES

https://nielsen.wistia.com/medias/tytiph3nj6

Please click on the video or the link at the bottom of the page

To access the PDF summary, please click here:

https://answers.nielsen.com/portal/workspace/GB+Nielsen+Answers+Training+Documentation/NAD+Digital+Training+Library/NAD+Job+Aids/5.1+Managing+Favorites.pdf

Slide14

WORKING WITH TABLES

https://nielsen.wistia.com/medias/7prz7if6z3

Please click on the video or the link at the bottom of the page

To access the PDF summary, please click here:

https://answers.nielsen.com/portal/workspace/GB+Nielsen+Answers+Training+Documentation/NAD+Digital+Training+Library/NAD+Job+Aids/6.1+Working+with+Tables.pdf

Slide15

SAVING, EXPORTING AND SHARING REPORTS

https://nielsen.wistia.com/medias/7f8zqdlxcc

For any more information log in to CSO 2.0 and search ‘Creating a Saved Selection’ and ‘Sharing your Answers Favourite file’

Please click on the video or the link at the bottom of the page

To access the PDF summary, please click here: https://answers.nielsen.com/portal/workspace/GB+Nielsen+Answers+Training+Documentation/NAD+Digital+Training+Library/NAD+Job+Aids/10.1+Saving+Exporting+and+Sharing+Reports.pdf

Slide16

ADDING DESCRIPTIONS IN A TABLE

https://nielsen.wistia.com/medias/wx9furnjry

Please click on the video or the link at the bottom of the page

To access the PDF summary, please click here:

https://answers.nielsen.com/portal/workspace/GB+Nielsen+Answers+Training+Documentation/NAD+Digital+Training+Library/NAD+Job+Aids/16.1+Displaying+Characteristics.pdf

Slide17

INTERFACE TO OFFICE

Slide18

EXPORT TO AND REFRESH RANGES IN ITO

https://nielsen.wistia.com/medias/34w7o9ln7x

Please click on the video or the link at the bottom of the page

To access the PDF summary, please click here:

https://answers.nielsen.com/portal/workspace/GB+Nielsen+Answers+Training+Documentation/NAD+Digital+Training+Library/NAD+Job+Aids/Nielsen+Interface+to+Office+Basics.pdf

Slide19

CREATE A RANGE IN ITO

https://nielsen.wistia.com/medias/8rm8rav50j

Please click on the video or the link at the bottom of the page

Slide20

MODIFY A DATA RANGE IN ITO

https://nielsen.wistia.com/medias/9a1sb929wp

Please click on the video or the link at the bottom of the page

To access the PDF summary, please click here:

https://answers.nielsen.com/portal/workspace/GB+Nielsen+Answers+Training+Documentation/NAD+Digital+Training+Library/NAD+Job+Aids/Modifying+Data+Ranges+in+Nielsen+Interface+to+Office.pdf

Slide21

NOW IT’S YOUR TURN…

Slide22

Pick one

database to complete these activitiesPlease complete the quiz following the link below

https://forms.gle/nvd8ZVteS7nmbByGA

Slide23

PANEL build your own

(for panel CLIENTS ONLy)

Slide24

Within the market tab we have a couple of additional market breakdowns VS RMS such as Aldi, Lidl, and Bargain Stores.

You can also split out online sales for stores and total Online (including sales from all sources such as Amazon…

etc)

You will also find demographic breakdowns such as social class, household size, age…etc.Apart from the additional markets you will also have the same breakdowns which are available in RMS – e.g. Grocery

Mults.

Accessing Custom data – market tab

Slide25

The products tab Hierarchies will be almost identical to the RMS database. Coding rules will match exactly.

Do not sum Products! The only case you can sum is if you are pulling value/volume/unit sales.

Accessing Custom

data – products tab

Slide26

In the Facts tab you will find the basic panel facts.

The facts are grouped based on time spans – you will have 4W/12W/24W/52W

When analysing panel data consider the effect time span has on penetration. The longer time you allow the higher penetration will be. When pulling any type of data, it is worth pulling the corresponding penetration fact. If penetration is lower than 1% the data is not robust (there are not enough panellists buying the product)

Accessing Custom

data – facts tab

4w

12w

24w

Slide27

Within the periods tab you will have all the periods available, broken down 4 weekly. You have a total of 156 weeks of

backdata

available – a total of 39 periods.

When selecting the time period you are telling the software which period to “roll” the fact from which you have selected.E.g. if you select the latest time period and a 52W fact you are looking at the latest MAT. To look at MAT YA go back 13 periods (match the month)

Accessing Custom data – periods tab