Turn Advertising Observations Into Useful Competitive Insight

Record advertiser, campaign, channel, publisher, market, date range, spend, impressions and creative notes. Preserve the source and indicate whether a number is published, a third-party estimate or your own observation. This context is essential when figures are later compared.

Filter by advertiser, channel, market and time period. CPM can be calculated from spend and impressions, but only when both values refer to the same currency, campaign scope and reporting period. A low CPM alone does not prove a campaign is effective or profitable.

Look for channel mix, repeated messages and differences between markets. Treat missing values as missing, not zero. Use observations to create hypotheses for your own campaign tests, then rely on your own analytics to judge outcomes.

Shane’s Ad Intelligence accepts manually entered or CSV-imported observations, filters records, compares observed spend, calculates CPM from entered spend and impressions, displays supplied creative details and exports CSV. It does not connect to ad libraries or social networks, and entered figures are not independently verified.

Build a comparable record before calculating anything

Start with a small data dictionary. Decide what counts as an advertiser, campaign, channel, market and reporting period, then use those labels consistently. Record the currency beside every spend value and preserve the source URL or report name. If two records cover different dates or geographies, keep those differences visible instead of combining them into one total.

For example, a fictional campaign with $1,200 in observed spend and 80,000 impressions has a calculated CPM of $15. That calculation is only meaningful if both inputs cover the same campaign, currency and period. If the spend is an estimate and the impressions are an official platform total, label that mix clearly.

Compare patterns, not isolated numbers

Group records by one useful dimension at a time: channel, market, advertiser or creative theme. Ask what changed and what stayed constant. A campaign with a higher CPM may be aimed at a smaller or more valuable audience. A larger impression count may reflect a longer reporting window rather than a better creative concept.

Use the workspace to organize observations and calculate comparable ratios, then write a short interpretation outside the raw data. Separate what the record shows from what you think it might mean. That distinction makes the analysis easier for another person to review.

A practical review checklist

• Are spend and impression figures from the same scope and date range?
• Is each number published, estimated or manually observed?
• Are missing values blank rather than silently treated as zero?
• Can another reviewer trace the source?
• Does the conclusion avoid claiming profitability or conversion performance without first-party results?

Shane’s Ad Intelligence is an observation and comparison workspace, not an ad-network connection. Treat its outputs as research notes and hypotheses. Confirm campaign performance in the platform account or analytics system that owns the underlying results.