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 and the sources behind every 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 |
| FeaturesUnique features, capabilities & modules per product category | 190,885 | 136 | 26.0M |
| Vendor featuresEach vendor product mapped to each standard feature it offers | 3.85M | 124 | 477.1M |
Category, Country, Industry, and Role carry the same 10 enrichment field groups documented below. Features holds the unique features, capabilities, and modules per product category. Vendor features maps each vendor product to each standard feature it offers.
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 battlecard, RFP answer, and account view; 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.
01 · Overview
tab on every taxonomy pageIdentity, descriptions, definitions, brand, names · what it is.
Gives every answer a stored, citable definition to start from, so APEX answers from what the record says.
Sample fields · categories
02 · Demand
tab on every taxonomy pageBuyers, 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 on every taxonomy pageMarket sizing, presence, footprint, distribution · where it sits.
Stops the "how big is this market" guesswork: a model estimate, with the sources it rests on.
Sample fields · categories
04 · Landscape
tab on every taxonomy pageCompetitors, 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 on every taxonomy pageForward 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 on every taxonomy pageImplementation, 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 on every taxonomy pageRegulatory posture, certifications, standards, pitfalls, risks — compliance and risk profile.
Pre-flight check for every RFP question on data residency, certifications, and jurisdiction. Nearly every value keeps the source it came from.
Sample fields · categories
08 · Economics
tab on every taxonomy pagePricing, 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 on every taxonomy pageFeatures, 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 on every taxonomy pageKPIs, scores, signals, news, and recent activity: the measurable indicators.
Shows what changed at the last refresh, with its date.
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 your own product's category, with its industries and roles and every field group shown.