Global Markets Review is turning its analyst-ratings coverage into a structured research product. The database is designed around the underlying research event rather than the headline generated by a news feed.

That means one analyst note can carry several fields at once: recommendation action, old and new target, estimate direction, catalyst and rationale. Storing them separately allows later analysis of which types of analyst action actually precede meaningful changes in consensus.

Deduplication rules

The same brokerage action is often syndicated by multiple outlets. GMR treats the original research action as one event and uses the research date as the primary timestamp where available.

If an outlet republishes the same note later, it should not create a second upgrade or target change. Where the original date cannot be established confidently, the record is flagged rather than assigned false precision.

Version and revision log

Schema v1.1, 9 September 2026: added catalyst, coverage-status, source-quality and deduplication-key fields to the original schema.

Future schema changes will be logged here so historical records can remain comparable even if new analytical fields are introduced.

GMR analyst-actions database schema v1.1
FieldStored valueWhy it matters
Company / tickerSecurity being coveredPrimary entity key
Brokerage / analystSource of actionAllows firm- and analyst-level history
Research dateUnderlying action datePrevents syndication-date duplication
Old ratingOriginal brokerage wordingPreserves the starting view
New ratingOriginal brokerage wordingPreserves the actual change
Normalised stancePositive / neutral / negativeEnables cross-broker comparison
Old price targetPrior target where availableMeasures target movement
New price targetUpdated target where availableMeasures target movement
Estimate directionUp / down / unchanged where supportedSeparates model change from label change
CatalystEarnings, guidance, valuation, initiation, sector, otherAdds event context
Action typeUpgrade, downgrade, maintained, initiation, target-onlyPrevents false classification
RationalePrimary stated driver where publicCaptures information content
Coverage statusActive / initiated / suspended / droppedDistinguishes rating actions from coverage changes
Source qualityDirect research, company reference, reliable reportMakes evidence quality visible
Deduplication keyTicker + brokerage + research date + action typeReduces duplicate event counts