Marketing Campaign Analysis

May 2024 Business Difficulty 2/5 XLSX 1.1 MB 9,900 rows × 18 cols 0 downloads
  • marketing
  • campaigns
  • ads
  • conversion
  • geographic

9,900 marketing-campaign records with channel, device, city, impressions, CTR, clicks, CPC, spend, conversion value, and engagement metrics. Great for return-on-spend analysis and channel-device performance comparisons.

Challenge brief

slug: 2024-05-marketing-campaign-analysis title: Marketing Campaign Analysis year: 2024 month: 05 source: authored authored_at: 2026-04-19 needs_leon_review: true

Marketing Campaign Analysis - Challenge Brief

Challenge period: May 2024 Dataset: Reconstructed brief based on the shipped data file for the May 2024 DataDNA challenge.

About the data

The primary data table for this challenge carries the following columns:

  • Campaign
  • Date
  • City/Location
  • Latitude
  • Longitude
  • Channel
  • Device
  • Ad
  • Impressions
  • CTR, %
  • Clicks
  • Daily Average CPC
  • Spend, GBP
  • Conversions
  • Total conversion value, GBP
  • Likes (Reactions)
  • Shares
  • Comments

Suggested analytical angles

  • Which channels deliver the best return on marketing spend?
  • How does CTR compare across device and ad-creative combinations?
  • Which cities produce the highest conversion value per pound?
  • How do reactions, shares, and comments predict conversion lift?

What great submissions did

This brief was reconstructed from the dataset contents in 2026 as part of the Playground audit. The original May 2024 challenge brief was not preserved as a separate file in the source archive, so the analytical angles above are inferred from the column list. See the corresponding /challenges/ entry on datadna.onyxdata.co.uk for examples of how participants approached the data.

Editorial note

_This stub was authored by Claude on 2026-04-19 for Leon's review. Refine the suggested angles and confirm factual accuracy before setting brief_status = leon_reviewed in the audit log._

This dataset was the subject of the DataDNA May 2024 community challenge. The original scoring and leaderboard pre-date the current submission system and are not available for display.

Browse open challenges