Notice Information
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.
Notice Details
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
Buyer & Supplier
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
Further Information
Notice URLs
Open Contracting Data Standard (OCDS)
View full OCDS Record for this contracting process
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
}
]
}
}