Award

Provision of disaggregated data for no/low alcohol drinks

UNIVERSITY OF SHEFFIELD

This public procurement record has 2 releases in its history.

Award

10 Aug 2022 at 13:04

Award

10 Jun 2022 at 09:26

Summary of the contracting process

The University of Sheffield has completed a tender process for the provision of disaggregated data for no/low alcohol drinks. The project involves purchasing a longitudinal household panel dataset comprising 30,000 households in Great Britain, covering the period 2018 to 2025. The dataset will be used for statistical analyses to understand trends in purchasing of non-alcoholic and low-alcohol drinks. The University of Sheffield is the buying organisation planning to use the dataset for public health research.

This tender presents opportunities for businesses specialising in market and economic research, polling, and statistical analysis. Companies providing data supply services and consumer research insights would be well-suited to compete. As the procurement process has reached the award stage, potential suppliers can explore future opportunities with the University of Sheffield for similar projects in the service sector. The University of Sheffield has selected Kantar UK Ltd as the supplier for this specific dataset provision.

Find more tenders on our Open Data Platform.
How relevant is this notice?

D3 Tenders Premium

Win More Public Sector Contracts

AI-powered tender discovery, pipeline management, and market intelligence — everything you need to grow your public sector business.

Notice Title

Provision of disaggregated data for no/low alcohol drinks

Notice Description

The University of Sheffield is looking to contract for the purchase of a longitudinal household panel dataset comprising 30,000 households in Great Britain and containing information on purchases of alcoholic drinks, including non-alcoholic and low-alcohol drinks, that are brought into the home. The required dataset covers the period 2018 to 2025 and includes information on the sociodemographic characteristics of the households, as well as the products purchased and prices paid. The University of Sheffield will use the dataset to conduct statistical analyses of trends and patterns in purchasing of non-alcoholic and low-alcohol drink purchasing over time, and the relationship of this to purchasing of other alcoholic drinks. This work forms part of a larger programme of research to understand the public health impact of non-alcoholic and low-alcohol drinks in the UK. This work forms part of a larger programme of research to understand the public health impact of non-alcoholic and low-alcoholic drinks in the UK.

Lot Information

Lot 1

The dataset required comprises information from a longitudinal panel of 30,000 households representative of households resident in Great Britain. Households scan the barcode of all grocery products brought into the home. Households that leave the dataset panel are continuously replaced by those with similar characteristics. The purchased data will cover the years 2018 to 2025. Two sets of disaggregated shopper data (as set out below) are being purchased as follows:- i) Product and shopper demographic data for all Take Home purchases of alcohol and no/low alcohol products ii) Shopper demographic data for those shoppers not purchasing any alcohol or no/low alcohol products Details of what information/data each datasets will include are as follows:- Product Detail for all Alcohol & No/Low Alcohol Products Purchased by the Household Panel - to include: - Date of purchase - Category - Brand - Number of packs bought - Number in a pack - Pack size (ml) - Pack Type - ABV - PromoFlag (details whether/what type pf promotion) - Price paid Demographics & household information for i) shoppers who purchased Alcohol & No/Low Alcohol Products OR ii) who did not purchase any Alcohol & No/Low Alcohol Products - to include: - Household size - Age of main shopper - Region - Social Class - Presence of Children - Age of youngest child - Annual household Income - Ethnicity - Highest Qualification - Tenure - Postcode (partial - GDPR prevents otherwise) - Lifestage (empty nester, pre family, retired etc) - Urban/Rural Dweller - Total Council Tax Band - Highest qualification - Car Ownership - Newspaper Additional information: Regulation 32 of PCR 2015 is being applied as in 32. (2) (b) (ii) No contract will be entered into until after a 10 calendar day period from the submission of the VEAT notice date.

Procurement Information

Kantar UK Ltd's Worldpanel is a longitudinal household panel dataset comprising in which 30,000 households resident in Great Britain. Participating households are selected via quota sampling based on region, household size, age of main shopper and occupation and are continuously replenished as they leave the panel. Households scan the barcodes of all grocery products brought into the home. This The resulting dataset provides detailed information on each scanned purchase, including the specific product purchased at the level of stock-keeping unit and the price paid, what different households buy, how much they pay for it and how that changes over time, as well as the sociodemographic characteristics of the households. The dataset is typically used for market research purposes but is increasingly used by public health researchers to understand the purchasing of unhealthy products. The University of Sheffield is buying a subset of this data that provides information on alcoholic drinks. Although The University of Sheffield is buying information on all alcoholic products, our interest for this project is particularly in non-alcoholic and low-alcohol drinks. We are looking to purchase datasets covering the period 2018-2025. The datasets will be delivered by Kantar UK Ltd to The University of Sheffield as per the following timetable:- * The data for 2018-2021 will be supplied in July 2022; * The data for 2022-2024 will be supplied in July 2025; * The data for 2025 will be supplied in July 2026 Whilst there may be another available dataset in the market it only contains 14,500 households (i.e. less than half the sample size). This difference is important because we know that relatively few people buy non-alcoholic and low-alcohol drinks. This means the alternative data will not provide sufficient statistical power to permit the planned whole population and subgroup analyses. For the avoidance of any doubt Kantar UK Ltd has confirmed that they do not provide the data to any third party for the purpose of re-sale. A single source authorisation form and purchase order is therefore proposed to formalise the contract for the datasets provided by Kantar UK Ltd for the following reasons:- 1) The other available panel only includes data on 14,500 households compared to Kantar World Panel which has data on 30,000 households and therefore provides substantially greater statistical power; 2) Due to the relative infrequency of alcohol purchasing (around once per week on average) the size of panel makes a material difference when looking at household-level purchasing behaviours in this sector; 3) Kantar UK Ltd will typically be providing The University of Sheffield with c900K purchase records for each year. A panel half the size will naturally give us significantly less raw data to work with.

Publication & Lifecycle

Open Contracting ID
ocds-h6vhtk-034502
Publication Source
Find A Tender Service
Latest Notice
https://www.find-tender.service.gov.uk/Notice/022019-2022
Current Stage
Award
All Stages
Award

Procurement Classification

Notice Type
Award Notice
Procurement Type
Standard
Procurement Category
Services
Procurement Method
Limited
Procurement Method Details
Award procedure without prior publication of a call for competition
Tender Suitability
Not specified
Awardee Scale
Large

Common Procurement Vocabulary (CPV)

CPV Divisions

72 - IT services: consulting, software development, Internet and support

79 - Business services: law, marketing, consulting, recruitment, printing and security


CPV Codes

72319000 - Data supply services

79300000 - Market and economic research; polling and statistics

Notice Value(s)

Tender Value
Not specified
Lots Value
Not specified
Awards Value
Not specified
Contracts Value
£223,825 £100K-£500K

Notice Dates

Publication Date
10 Aug 20223 years ago
Submission Deadline
Not specified
Future Notice Date
Not specified
Award Date
9 Jun 20223 years ago
Contract Period
Not specified - Not specified
Recurrence
Not specified

Notice Status

Tender Status
Complete
Lots Status
Cancelled
Awards Status
Active
Contracts Status
Active

Contracting Authority (Buyer)

Main Buyer
UNIVERSITY OF SHEFFIELD
Contact Name
Jamie Shaw
Contact Email
jamie.shaw@sheffield.ac.uk
Contact Phone
+44 1142221516

Buyer Location

Locality
SHEFFIELD
Postcode
S10 2TN
Post Town
Sheffield
Country
England

Major Region (ITL 1)
TLE Yorkshire and The Humber
Basic Region (ITL 2)
TLE3 South Yorkshire
Small Region (ITL 3)
TLE32 Sheffield
Delivery Location
TLE32 Sheffield

Local Authority
Sheffield
Electoral Ward
Broomhill and Sharrow Vale
Westminster Constituency
Sheffield Central

Supplier Information

Number of Suppliers
1
Supplier Name

KANTAR

Open Contracting Data Standard (OCDS)

View full OCDS Record for this contracting process

Download

The Open Contracting Data Standard (OCDS) is a framework designed to increase transparency and access to public procurement data in the public sector. It is widely used by governments and organisations worldwide to report on procurement processes and contracts.

{
    "tag": [
        "compiled"
    ],
    "id": "ocds-h6vhtk-034502-2022-08-10T14:04:59+01:00",
    "date": "2022-08-10T14:04:59+01:00",
    "ocid": "ocds-h6vhtk-034502",
    "initiationType": "tender",
    "tender": {
        "id": "3396/SSA/JS",
        "legalBasis": {
            "id": "32014L0024",
            "scheme": "CELEX"
        },
        "title": "Provision of disaggregated data for no/low alcohol drinks",
        "status": "complete",
        "classification": {
            "scheme": "CPV",
            "id": "79300000",
            "description": "Market and economic research; polling and statistics"
        },
        "mainProcurementCategory": "services",
        "description": "The University of Sheffield is looking to contract for the purchase of a longitudinal household panel dataset comprising 30,000 households in Great Britain and containing information on purchases of alcoholic drinks, including non-alcoholic and low-alcohol drinks, that are brought into the home. The required dataset covers the period 2018 to 2025 and includes information on the sociodemographic characteristics of the households, as well as the products purchased and prices paid. The University of Sheffield will use the dataset to conduct statistical analyses of trends and patterns in purchasing of non-alcoholic and low-alcohol drink purchasing over time, and the relationship of this to purchasing of other alcoholic drinks. This work forms part of a larger programme of research to understand the public health impact of non-alcoholic and low-alcohol drinks in the UK. This work forms part of a larger programme of research to understand the public health impact of non-alcoholic and low-alcoholic drinks in the UK.",
        "lots": [
            {
                "id": "1",
                "description": "The dataset required comprises information from a longitudinal panel of 30,000 households representative of households resident in Great Britain. Households scan the barcode of all grocery products brought into the home. Households that leave the dataset panel are continuously replaced by those with similar characteristics. The purchased data will cover the years 2018 to 2025. Two sets of disaggregated shopper data (as set out below) are being purchased as follows:- i) Product and shopper demographic data for all Take Home purchases of alcohol and no/low alcohol products ii) Shopper demographic data for those shoppers not purchasing any alcohol or no/low alcohol products Details of what information/data each datasets will include are as follows:- Product Detail for all Alcohol & No/Low Alcohol Products Purchased by the Household Panel - to include: - Date of purchase - Category - Brand - Number of packs bought - Number in a pack - Pack size (ml) - Pack Type - ABV - PromoFlag (details whether/what type pf promotion) - Price paid Demographics & household information for i) shoppers who purchased Alcohol & No/Low Alcohol Products OR ii) who did not purchase any Alcohol & No/Low Alcohol Products - to include: - Household size - Age of main shopper - Region - Social Class - Presence of Children - Age of youngest child - Annual household Income - Ethnicity - Highest Qualification - Tenure - Postcode (partial - GDPR prevents otherwise) - Lifestage (empty nester, pre family, retired etc) - Urban/Rural Dweller - Total Council Tax Band - Highest qualification - Car Ownership - Newspaper Additional information: Regulation 32 of PCR 2015 is being applied as in 32. (2) (b) (ii) No contract will be entered into until after a 10 calendar day period from the submission of the VEAT notice date.",
                "awardCriteria": {
                    "criteria": [
                        {
                            "type": "price"
                        }
                    ]
                },
                "hasOptions": false,
                "status": "cancelled"
            }
        ],
        "items": [
            {
                "id": "1",
                "additionalClassifications": [
                    {
                        "scheme": "CPV",
                        "id": "72319000",
                        "description": "Data supply services"
                    }
                ],
                "deliveryAddresses": [
                    {
                        "region": "UKE32"
                    },
                    {
                        "region": "UKE32"
                    }
                ],
                "deliveryLocation": {
                    "description": "The dataset will be provided to the School of Health and Related Research (SCHARR), The University of Sheffield, Regent Court, 30 Regent Street, Sheffield, S1 4DA"
                },
                "relatedLot": "1"
            }
        ],
        "procurementMethod": "limited",
        "procurementMethodDetails": "Award procedure without prior publication of a call for competition",
        "coveredBy": [
            "GPA"
        ],
        "procurementMethodRationaleClassifications": [
            {
                "scheme": "TED_PT_AWARD_CONTRACT_WITHOUT_CALL",
                "id": "D_TECHNICAL",
                "description": "The works, supplies or services can be provided only by a particular economic operator due to absence of competition for technical reasons"
            }
        ],
        "procurementMethodRationale": "Kantar UK Ltd's Worldpanel is a longitudinal household panel dataset comprising in which 30,000 households resident in Great Britain. Participating households are selected via quota sampling based on region, household size, age of main shopper and occupation and are continuously replenished as they leave the panel. Households scan the barcodes of all grocery products brought into the home. This The resulting dataset provides detailed information on each scanned purchase, including the specific product purchased at the level of stock-keeping unit and the price paid, what different households buy, how much they pay for it and how that changes over time, as well as the sociodemographic characteristics of the households. The dataset is typically used for market research purposes but is increasingly used by public health researchers to understand the purchasing of unhealthy products. The University of Sheffield is buying a subset of this data that provides information on alcoholic drinks. Although The University of Sheffield is buying information on all alcoholic products, our interest for this project is particularly in non-alcoholic and low-alcohol drinks. We are looking to purchase datasets covering the period 2018-2025. The datasets will be delivered by Kantar UK Ltd to The University of Sheffield as per the following timetable:- * The data for 2018-2021 will be supplied in July 2022; * The data for 2022-2024 will be supplied in July 2025; * The data for 2025 will be supplied in July 2026 Whilst there may be another available dataset in the market it only contains 14,500 households (i.e. less than half the sample size). This difference is important because we know that relatively few people buy non-alcoholic and low-alcohol drinks. This means the alternative data will not provide sufficient statistical power to permit the planned whole population and subgroup analyses. For the avoidance of any doubt Kantar UK Ltd has confirmed that they do not provide the data to any third party for the purpose of re-sale. A single source authorisation form and purchase order is therefore proposed to formalise the contract for the datasets provided by Kantar UK Ltd for the following reasons:- 1) The other available panel only includes data on 14,500 households compared to Kantar World Panel which has data on 30,000 households and therefore provides substantially greater statistical power; 2) Due to the relative infrequency of alcohol purchasing (around once per week on average) the size of panel makes a material difference when looking at household-level purchasing behaviours in this sector; 3) Kantar UK Ltd will typically be providing The University of Sheffield with c900K purchase records for each year. A panel half the size will naturally give us significantly less raw data to work with."
    },
    "awards": [
        {
            "id": "015965-2022-1",
            "relatedLots": [
                "1"
            ],
            "status": "active",
            "suppliers": [
                {
                    "id": "GB-FTS-55144",
                    "name": "Kantar UK Ltd"
                }
            ]
        },
        {
            "id": "022019-2022-1",
            "relatedLots": [
                "1"
            ],
            "status": "active",
            "suppliers": [
                {
                    "id": "GB-COH-03073845",
                    "name": "Kantar UK Ltd"
                }
            ]
        }
    ],
    "parties": [
        {
            "id": "GB-FTS-613",
            "name": "UNIVERSITY OF SHEFFIELD",
            "identifier": {
                "legalName": "UNIVERSITY OF SHEFFIELD"
            },
            "address": {
                "streetAddress": "Western Bank",
                "locality": "SHEFFIELD",
                "region": "UKE32",
                "postalCode": "S102TN",
                "countryName": "United Kingdom"
            },
            "contactPoint": {
                "name": "Jamie Shaw",
                "telephone": "+44 1142221516",
                "email": "jamie.shaw@sheffield.ac.uk"
            },
            "roles": [
                "buyer"
            ],
            "details": {
                "url": "https://www.sheffield.ac.uk",
                "classifications": [
                    {
                        "scheme": "TED_CA_TYPE",
                        "id": "BODY_PUBLIC",
                        "description": "Body governed by public law"
                    },
                    {
                        "scheme": "COFOG",
                        "id": "09",
                        "description": "Education"
                    }
                ]
            }
        },
        {
            "id": "GB-FTS-55144",
            "name": "Kantar UK Ltd",
            "identifier": {
                "legalName": "Kantar UK Ltd"
            },
            "address": {
                "locality": "London",
                "region": "UKI73",
                "countryName": "United Kingdom"
            },
            "roles": [
                "supplier"
            ],
            "details": {
                "scale": "large"
            }
        },
        {
            "id": "GB-FTS-614",
            "name": "High Court of England, Wales and Northern Ireland",
            "identifier": {
                "legalName": "High Court of England, Wales and Northern Ireland"
            },
            "address": {
                "locality": "London",
                "countryName": "United Kingdom"
            },
            "roles": [
                "reviewBody"
            ]
        },
        {
            "id": "GB-UKPRN-10007157",
            "name": "UNIVERSITY OF SHEFFIELD",
            "identifier": {
                "legalName": "UNIVERSITY OF SHEFFIELD",
                "id": "10007157",
                "scheme": "GB-UKPRN"
            },
            "address": {
                "streetAddress": "Western Bank",
                "locality": "SHEFFIELD",
                "region": "UKE32",
                "postalCode": "S102TN",
                "countryName": "United Kingdom"
            },
            "contactPoint": {
                "name": "Jamie Shaw",
                "telephone": "+44 1142221516",
                "email": "jamie.shaw@sheffield.ac.uk"
            },
            "roles": [
                "buyer"
            ],
            "details": {
                "url": "https://www.sheffield.ac.uk",
                "classifications": [
                    {
                        "scheme": "TED_CA_TYPE",
                        "id": "BODY_PUBLIC",
                        "description": "Body governed by public law"
                    },
                    {
                        "scheme": "COFOG",
                        "id": "09",
                        "description": "Education"
                    }
                ]
            }
        },
        {
            "id": "GB-COH-03073845",
            "name": "Kantar UK Ltd",
            "identifier": {
                "legalName": "Kantar UK Ltd",
                "id": "03073845",
                "scheme": "GB-COH"
            },
            "address": {
                "locality": "Ealing",
                "region": "UKI73",
                "countryName": "United Kingdom"
            },
            "roles": [
                "supplier"
            ],
            "details": {
                "scale": "large"
            }
        }
    ],
    "buyer": {
        "id": "GB-UKPRN-10007157",
        "name": "UNIVERSITY OF SHEFFIELD"
    },
    "contracts": [
        {
            "id": "015965-2022-1",
            "awardID": "015965-2022-1",
            "status": "active",
            "value": {
                "amount": 223825,
                "currency": "GBP"
            },
            "dateSigned": "2022-06-10T00:00:00+01:00"
        },
        {
            "id": "022019-2022-1",
            "awardID": "022019-2022-1",
            "status": "active",
            "value": {
                "amount": 223825,
                "currency": "GBP"
            },
            "dateSigned": "2022-07-26T00:00:00+01:00"
        }
    ],
    "language": "en",
    "bids": {
        "statistics": [
            {
                "id": "1",
                "measure": "bids",
                "relatedLot": "1",
                "value": 1
            }
        ]
    }
}