FPDS Query Library
About Us
Contact Us

Website URL

The website URL recorded in the contract marketing section of an IDV. It identifies the web address associated with the marketing information for the instrument, usually as a string value rather than a coded selection.

Family: IDV
Category: Contract Marketing
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__contractMarketingData__websiteURL
Title
Website URL
FPDS Path
IDV/contractMarketingData/websiteURL
Description
The website URL recorded in the contract marketing section of an IDV. It identifies the web address associated with the marketing information for the instrument, usually as a string value rather than a coded selection.
Business Meaning
This field helps analysts locate and validate the public-facing presence tied to an IDV, which can support market research, vendor outreach, and contract transparency analysis. It is also useful for linking FPDS records to external sources when assessing how agencies present and promote contract vehicles.
Example Value
WWW.FSS.GSA.GOV
Observed Non-Null Count
2,018,441

FPDS Compare

FPDS Query Variable
content__IDV__contractMarketingData__websiteURL
FPDS XML Path
IDV/contractMarketingData/websiteURL
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/contractMarketingData/websiteURL' into the SQL-ready variable 'content__IDV__contractMarketingData__websiteURL'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building

Common Usage

  • Linking an IDV to a vendor or vehicle website
  • Normalizing URLs for external data enrichment
  • Filtering records with populated marketing contact information

Common Mistakes

  • Assuming the value is standardized or validated
  • Using it as a proxy for active website availability

Query Guidance

Select and normalize the field with functions such as TRIM and LOWER before comparison or grouping. For searches, use exact-match or domain-based pattern logic only after accounting for missing protocols, case variation, and possible duplicate URLs across records.

SQL Examples

Preview values

SELECT
    content__IDV__contractMarketingData__websiteURL AS website_u_r_l
FROM fpds.data
WHERE content__IDV__contractMarketingData__websiteURL IS NOT NULL
LIMIT 25

Top values

SELECT
    content__IDV__contractMarketingData__websiteURL AS value,
    count() AS record_count
FROM fpds.data
WHERE content__IDV__contractMarketingData__websiteURL IS NOT NULL
GROUP BY value
ORDER BY record_count DESC
LIMIT 25

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.