The 15 tables behind every answer
The PYRAMYD Data Foundation is a stack of 15 typed tables behind 10 enrichment field groups, with counts measured in our production database, refreshable on demand and citable per row.
The 6 core taxonomies
Products, reviews and contacts point at these six through checked links. Change one and every view built on it changes with it.
| Table | Rows | Columns per row | Fields (rows × columns) |
|---|---|---|---|
| Categories | 2,546 | 212 | 539,752 |
| Countries | 249 | 101 | 25,149 |
| Industries | 463 | 118 | 54,634 |
| Roles | 4,349 | 86 | 374,014 |
| Feature TaxonomyUnique features, capabilities & modules per product category | 502,574 | 119 | 59.8M |
| Vendor Feature TaxonomyEvery review-platform-listed feature × product × vendor | 2.33M | 290 | 676.9M |
Category, Country, Industry and Role carry the same 10 enrichment field groups documented below. Feature Taxonomy holds the unique features, capabilities, and modules per product category. Vendor Feature Taxonomy holds every review-platform-listed feature for every product, every vendor.
The 4 core data tables
Products, Companies, Contacts, Reviews · this is where the volume lives. 7M+ rows of vendor, buyer, and signal data, each row tied back to the six taxonomies above.
| Table | Rows | Columns per row | Fields (rows × columns) |
|---|---|---|---|
| Products | 250,632 | 316 | 79.2M |
| Companies | 1.44M | 314 | 451.2M |
| Contacts | 3.38M | 126 | 426.3M |
| Reviews | 2.46M | 118 | 289.8M |
Counts read from our production database. Companies and Contacts feed every CI, RFX, and Battlecard workflow · Reviews drive the Pulse field group below.
The 5 secondary taxonomies
What the buyer is trying to do, the value they want, the process they run, the metrics they care about, and the requirements they hand to procurement. Each one ties Products and Capabilities back to a business frame.
| Table | Rows | Columns per row | Fields (rows × columns) |
|---|---|---|---|
| Business Capability Taxonomy | 597 | 33 | 19,701 |
| Business Value Taxonomy | 778 | 41 | 31,898 |
| Business Process Taxonomy | 23,005 | 41 | 943,205 |
| Business Metric Taxonomy | 48,077 | 66 | 3.2M |
| Business Requirement TaxonomySchema defined · data ingestion in progress | — | 69 | — |
Business Capability, Value, Process, Metric and Requirement taxonomies map raw product features to the language enterprise buyers actually use. The Requirement taxonomy is defined and not yet filled.
The depth
Every taxonomy node carries the same 10 enrichment dimensions. Real columns, real provenance, refreshable on demand.
01 · Overview
tab in every 360Identity, descriptions, definitions, brand, names · what it is.
Grounds every downstream answer in a canonical, citable definition. APEX never invents what a category is.
Sample fields · categories
02 · Demand
tab in every 360Buyers, personas, GTM motion, customer evidence — who buys/uses and why.
Turns abstract category data into who-buys-this-where signals. The bedrock under every ICP and segmentation play.
Sample fields · categories
03 · Market
tab in every 360Market sizing, presence, footprint, distribution · where it sits.
Stops the "how big is this market" guesswork. Real numbers from public filings and review data, refreshed on demand.
Sample fields · categories
04 · Landscape
tab in every 360Competitors, leaders, alternatives, adjacent nodes — competitive and peer view.
The competitive map every battlecard needs — leaders, innovators, emerging entrants, niche specialists, and the open-source alternatives.
Sample fields · categories
05 · Trends
tab in every 360Forward direction, AI disruption, automation, roadmap — where this is heading.
Forward-looking signals so product strategy doesn't get blindsided. Includes AI disruption, automation pressure, and sunset risk per node.
Sample fields · categories
06 · Operations
tab in every 360Implementation, support, infrastructure, day-to-day · how this gets done.
The implementation reality after the demo. Training, change management, data migration, and the day-in-the-life that closes deals.
Sample fields · categories
07 · Compliance
tab in every 360Regulatory posture, certifications, standards, pitfalls, risks — compliance and risk profile.
Pre-flight check for every RFP question on data residency, certifications, and jurisdiction. Each value keeps the source it came from.
Sample fields · categories
08 · Economics
tab in every 360Pricing, spend, revenue, funding, ROI, contracts · the financial picture.
Pricing, ROI, switching costs, renewal dynamics — what RevOps and procurement always end up asking. Already structured.
Sample fields · categories
09 · Capabilities
tab in every 360Features, integrations, requirements, tech stack — what it can do.
The feature-level depth an RFP response needs — every capability, integration partner, deployment option, and required certification.
Sample fields · categories
10 · Pulse
tab in every 360KPIs, scores, signals, news, recent activity — measurable indicators and live signals.
Surfaces what changed since the last refresh, so analysts see the deltas, not stale Q3 numbers.
Sample fields · categories
Across every taxonomy
The schema is identical so APEX can reason across taxonomies. Each row is one field group; the columns inside specialize per node type — a category's compliance is different from a product's.
| Field group | Categories | Industries | Countries | Roles | Products |
|---|---|---|---|---|---|
| 01Overview | Category DescriptionCategory DefinitionFeaturesSimilar CategoriesAlternative Categories+5 more | Industry DescriptionIndustry DefinitionAlternative NamesKey TerminologyRelated Industries+2 more | Country DescriptionCountry DefinitionAlternative NamesRegion DescriptionSub Region Description | Role Focus DescriptionRole Focus DefinitionSkillsPersona ArchetypesKey Responsibilities | Feature DescriptionFeature DefinitionCapability DescriptionModule DescriptionEssence+2 more |
| 02Demand | Target BuyersTypical Sales CycleBuying InsightsTarget AudienceTarget Business Sizes+6 more | Key Buyer PersonasDecision MakersBuying Committee by SizeProcurement ProcessEvaluation Criteria | Software MarketBuyer SignalsBusiness Culture | Target BuyersBuying Authority by SizeEvaluation CriteriaDecision MakersSoftware Adoption Patterns | Value PropsBuyer SignalsDiscovery QuestionsObjectionsProof Points+3 more |
| 03Market | Market SizeMarket Growth RateMarket MaturityCompetitive IntensityVendor Count Estimate+4 more | Industry Size (billions)Growth Rate (%)Geographic DistributionMarket LeadersBarriers to Entry | IT SpendingSaaS AdoptionMarket BarriersMarket AccessSoftware Spending Trends | Seat Count by Company SizeSoftware Spend per Seat (usd) | Adoption SignalMaturity SignalIndustry RelevanceImplementations by VendorTypical Consumers+1 more |
| 04Landscape | Top ProductsCompetitive LandscapeMarket LeadersInnovation LeadersEmerging Players+4 more | Market LeadersEmerging PlayersConsolidation TrendsMa ActivityPE Consolidators Active | Local VendorsChannel LandscapePartner Ecosystem | Common ToolsTool Stack ArchetypeTypical Tech Stack | AlternativesComplementsLeader ExamplesDifferentiation AxesGaps in Market+4 more |
| 05Trends | Future TrendsAI Disruption PotentialSunset Risk SummaryVendor Consolidation TrendRegulatory Impact+3 more | Industry TrendsTechnology DriversAI Disruption PotentialAutomation TrendsEmerging Technologies+2 more | Technology LandscapeRegulatory PipelineAI Regulation | Automation PotentialAI Disruption PotentialAI Agent Replacement Risk | AI CapabilitiesFeature RubricsAutomation Seam |
| 06Operations | ImplementationTraining GuidanceMonitoring GuidanceData Migration GuidanceChange Management+1 more | Workforce DynamicsTalent TrendsSkill GapsChannel Preferences | Business CultureLanguage RequirementsSupport ExpectationsTimezone Business Hours | Day in LifeWorkflow SummaryCareer PathwaysKPI Tree | Architecture PatternsData ModelIntegration PointsPerformance SlosState Management+4 more |
| 07Compliance | Compliance StandardsData Residency RequirementsLocalization ComplexityRegulatory ImpactCommon Pitfalls+2 more | Regulatory LandscapeCompliance StandardsData Privacy RequirementsRegulatory BodiesRegulatory Complexity | Data Privacy LawsTax ReportingEinvoicing MandatesLabor RegulationsAI Regulation+2 more | Compliance Considerations | Security ModelCompliance ImplicationsData Residency PostureMulti Tenancy ModelRegulatory Drivers+2 more |
| 08Economics | Pricing RangePricingNegotiation Leverage PointsContract ConsiderationsContract Guidance+5 more | ROI DriversBudget CyclesSoftware Spend per Employee | IT SpendingVAT GST for SaaSCurrency InfoPayment Norms | Software Spend per Seat (usd)Software Spend YearSeat Count by Company Size | Pricing MetricPricing PositionPricing BenchmarksBuy vs Build |
| 09Capabilities | Common IntegrationsFeature GlossaryAPI Ecosystem MaturityMandatory CapabilitiesDeployment Options+5 more | Typical Tech StackIntegration RequirementsSystems of RecordInterop StandardsVertical Data Models+1 more | Payment RailsDigital Identity SystemsEgovernment SystemsHealth IT SystemsBanking Infrastructure+1 more | Common ToolsTypical Tech StackMandatory IntegrationsData Systems UsedFeature Requirements+1 more | API ShapeIntegration PointsExtensibility ModelOpen StandardsLanguage Requirements+4 more |
| 10Pulse | Score DistributionStatisticsVendor Count EstimateReview SummaryROI+4 more | Industry Size (billions)Growth Rate (%)Investment ActivityMa ActivityConsolidation Trends | Economic IndicatorsIT SpendingSaaS AdoptionSoftware Spending Trends | Productivity MetricsWorkforce AggregatesBuyer Signals | Adoption SignalMaturity SignalKPIs DrivenHistoryInnovation Examples+4 more |
Categories, Industries, Countries, Roles, and Products all carry the identical 10-field-group schema in production, checked against our production database. Sample columns shown are real database fields per group.
Book a demo and we'll walk you through one of your competitor's categories, industries and roles, with every field group shown.