TenderlineUK
Procurement Intelligence
Official OCDS
Find a Tender
complete
Official procurement procedure

Provision of disaggregated data for no/low alcohol drinks

Market and economic research; polling and statistics
Yorkshire & Humber (UKE32)
Published value
Not published
Submission deadline Not published
Lots published1
Procurement Executive Summary
AI & Search Synopsis
Generated from official OCDS record
Tenderline Synopsis: Sheffield Hallam University: "Provision of disaggregated data for no/low alcohol drinks". Published status: complete. Published value: Value not published. 1 published lot. Submission deadline not published. See the official notice for participation instructions.
Contracting AuthoritySheffield Hallam UniversityScope & CategoriesNot publishedSubmission Window
complete
No deadline published
Submission GatewayDirect notice routeLegal Basis & RegimeStandard procurementEstimated Value (exc. VAT)Not published
Bidder Intelligence · Authority Profile: Sheffield Hallam University
Market Analytics
View Authority Profile →
Derived from OCDS awards & bid statistics
Published history for Sheffield Hallam University. These figures describe retained records, not a forecast of bids or a measure of buyer bias.
Average Price Reduction
Not availableInsufficient comparable data
Requires at least 5 comparable procedures
Competition Density
4.2Bids / Report
33.3% of reports have one bid
Supplier ConcentrationNo estimate
Insufficient attributable awardsNo concentration estimate available
Payment Terms
Check noticePublished terms
Payment obligations depend on the applicable regime and contract. Consult the official documents.
Coverage: 9 active published awards; 9 bid reports (which may be per lot). Supplier values exclude multi-supplier awards, frameworks and DPS, and use GBP only. They are published award values, not payments. Price reduction compares single-lot, single-award, single-supplier GBP procedures with explicitly non-framework/non-DPS status; increases remain in the average. Unpublished data stays unknown. Awarded suppliers are winners, not all bidders.
Procedure terms
Contracting AuthoritySheffield Hallam University
Procedure methodNot published
Procurement categoryNot published
Statuscomplete
Framework / DPSNot published
CompetitionNot published
Above thresholdNot published
Legal basisNot published
Tender period startsNot published
Clarification deadlineNot published
Electronic submissionNot published
Submission languagesNot published
Published10 Aug 2022, 14:04 BST
Last source update10 Aug 2022, 14:04 BST
Recurring procurementNot published
ClassificationMarket and economic research; polling and statistics
Delivery area
Yorkshire & Humber (UKE32)
OCIDocds-h6vhtk-034502
What is being bought
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.
What changed
From the official release history
  1. Official notice release published
    10 Aug 2022, 14:04 BST
  2. Buyer information updated
    10 Aug 2022, 14:04 BST
  3. Status changed to complete
    10 Jun 2022, 10:26 BST
  4. Official notice release published
    10 Jun 2022, 10:26 BST
  5. Buyer information updated
    10 Jun 2022, 10:26 BST
Lots and requirements (1)
Published by the contracting authority
  • Lot 1 · #1
    Individual lot title not published
    cancelled
    Published valueNot published
    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.
    Contract periodNot published
    EligibilityNot published
    Options / renewalNot published
Timeline
  1. Procedure published
    10 Aug 2022, 14:04 BST
  2. Award active
    Not published · Not published
  3. Contract active
    Signed 26 Jul 2022, 00:00 BST · £223,825
Commercial outcome and competition
Awards
Kantar UK Ltd
Not published · Not published · active
Contracts
Contract
£223,825 · signed 26 Jul 2022, 00:00 BST · active
Bid statistics
bids: 1 (lot 1)
Buyer and organisations in this procedure

Sheffield Hallam University

Contracting authority GB-UKPRN-10007157
View buyer profile

  • UNIVERSITY OF SHEFFIELD
    buyer

    GB-UKPRN: 10007157
    Western Bank, SHEFFIELD, UKE32, S102TN
    jamie.shaw@sheffield.ac.uk
    +44 1142221516

  • High Court of England, Wales and Northern Ireland
    reviewBody

    London

  • Kantar UK Ltd
    supplier

    GB-COH: 03073845
    Ealing, UKI73
Documents (0)
Official links; attachments are not copied
No data
No linked documents are published
Related procedures (0)
No data
No related procedures published
Planning and rationale
Planning budgetNot published
No-engagement rationaleNot published
Procedure rationaleKantar 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.