How to export lease offer data for a competitive analysis
Lease offers can reveal how operators value acreage, where competition is intensifying, and which parts of a shale play may be entering a negotiation cycle. A useful analysis, however, requires more than collecting offer amounts. The surrounding acreage, timing, mineral ownership, infrastructure, and drilling activity can materially change the meaning of each record.
Shale Navigator helps bring these factors into a common geographic and reporting workflow. Users can locate lease offers, filter them by area, review nearby properties and wells, and organize the resulting information for further analysis. Exporting a focused dataset makes it easier to compare opportunities in spreadsheets, financial models, investment memoranda, or internal land reports.
The strongest results come from defining the comparison before downloading anything. Decide whether the goal is to benchmark bonus payments, identify active competitors, rank counties, assess undeveloped acreage, or support a specific acquisition. That decision determines which records, fields, and map layers belong in the final file.
Define the competitive question
Begin by establishing the unit of comparison. A lease offer may be associated with a tract, parcel, owner, county, operator, or broader offer area. Comparing records that use different geographic units can produce misleading results, especially when a single offer covers multiple parcels or when several offers relate to the same mineral-interest owner.
Set a date range and geographic boundary before applying filters. A countywide review may be appropriate for market benchmarking, while an investment-area analysis may require a custom polygon, selected townships, or a radius around existing wells. Separating current offers from older records helps distinguish live competitive activity from historical pricing.
It is also useful to define the decision metric in advance. For example, an investor may prioritize offer value per net mineral acre, while a landman may focus on operator presence, contact frequency, or the concentration of open acreage. A consistent metric makes the exported data easier to sort and compare.
Build a clean offer dataset
Use Shale Navigator’s lease-offer layers and search tools to narrow the map to relevant records. Filters may include county, acreage, offer date, operator, owner, or other available attributes. When the search involves several counties or acreage bands, lease search methods can help create a repeatable starting point instead of relying on visual map inspection alone.
Before exporting, review the records for duplicates and incomplete entries. Duplicate offers can arise when related parcels are listed separately, while missing acreage or uncertain dates can distort averages. Preserve the original record identifier when available, since it allows later verification against the source map.
A practical export should retain fields that explain both the offer and its setting. Depending on the available data, useful columns may include:
- Offer date or reporting period
- County, state, township, range, or section
- Offered acreage and estimated net mineral acres
- Mineral owner or rights-holder information
- Company, operator, or prospective lessee
- Offer amount, payment structure, or stated consideration
- Lease term, extension options, and related conditions
- Source notes, record ID, and geographic coordinates
Keep the raw export unchanged and make a separate working copy for normalization. Standardize company names, county spelling, date formats, and currency values in the working file. This preserves an audit trail while allowing reliable grouping and calculations.
Compare offers on a consistent basis
Offer amounts should be converted into comparable measures whenever the underlying fields support it. A common calculation is the total consideration divided by net mineral acres. If only gross acreage is available, label the result clearly as a gross-acre benchmark rather than treating it as an equivalent measure.
Terms can be as important as headline price. A higher offer with a short primary term, demanding extension payment, or restrictive development clause may be less attractive than a lower offer with stronger long-term economics. Add separate columns for term length, extension rights, royalty provisions, depth limitations, pooling language, and unusual conditions when those details are available.
Use median values alongside averages. A small number of unusually large offers can pull the average upward and create an unrealistic market benchmark. Segment the results by county, play, operator, date range, acreage size, or mineral ownership type so the analysis compares similar transactions.
| Comparison factor | Why it matters | Useful export field or calculation |
|---|---|---|
| Offer value per acre | Establishes a basic price benchmark | Total consideration ÷ net or gross acres |
| Offer date | Shows pricing movement over time | Month, quarter, or year |
| Acreage size | Identifies whether scale affects terms | Offered acres and net mineral acres |
| Operator or company | Reveals competitive concentration | Standardized company name |
| Lease term | Measures duration of commitment | Primary term and extension period |
| Royalty or consideration terms | Adds context to the headline offer | Royalty rate, bonus, and payment structure |
| Location and formation | Helps explain geographic price differences | County, tract, section, and play |
| Nearby activity | Indicates development potential | Distance to wells, permits, or pipelines |
A spreadsheet can then calculate minimum, maximum, median, and percentile values for each segment. Flag records that fall far outside the normal range rather than deleting them. Exceptional offers may reflect superior geology, a strategic tract, a title complication, or a company-specific need for continuity.
Read offers in their local context
Price comparisons become more useful when they are tied to development evidence. Acreage near producing or recently permitted wells may command more attention than isolated acreage, even when both properties have similar size and lease terms. Shale Navigator users can review undrilled acreage near wells to determine whether a lease offer sits within an emerging development pattern.
Overlay wells, permits, shale-play boundaries, and property information on the offer locations. Look for clusters, gaps, and corridors. A group of offers near active drilling may indicate an operator assembling a development unit, while scattered offers far from infrastructure may require a different interpretation.
Transportation access can also affect competitive value. Pipeline proximity may influence the feasibility and timing of production, particularly in areas where gathering capacity is constrained. A custom pipeline overlay can help relate lease offers to existing or planned infrastructure without losing the focus on a specific investment area.
Document the geographic context in the exported file. Add fields for distance to the nearest well, permit, pipeline, or play boundary when those measurements are available. If the calculation is performed outside the platform, note the method and date so another analyst can reproduce it.
Recommendations for a reliable analysis
A polished export should be easy for another person to audit and update. Use clear field names, preserve source identifiers, and record the filters used to produce the file. If multiple exports are combined, add a source or batch column to distinguish reporting periods.
Keep assumptions visible. State whether acreage is gross or net, whether offer values include all consideration, and whether expired or withdrawn offers remain in the dataset. These details prevent users from treating a preliminary benchmark as a definitive market valuation.
Use the following practices when preparing the final comparison:
- Separate raw records from cleaned and calculated fields.
- Normalize company names before grouping offers by operator.
- Use median and percentile statistics alongside average values.
- Flag missing dates, acreage, terms, and uncertain geographic records.
- Save the search filters, export date, and calculation notes with the file.
Review the resulting map after exporting. A spreadsheet can show rankings, but the map may reveal overlapping offers, fragmented ownership, infrastructure constraints, or a concentration of activity that changes the interpretation. This final visual check is especially important when records cover adjacent parcels or irregular lease boundaries.
Turn findings into a defensible decision
Once the data is organized, rank opportunities according to the purpose of the analysis. A competitive land-acquisition review may emphasize offer density and operator activity. A mineral-rights investment review may weigh price per net acre, development proximity, title confidence, and transportation access. A report for a landowner may focus on the range of current offers and the terms attached to comparable acreage.
Exported lease-offer data becomes more valuable when it is refreshed consistently. Establish a recurring review schedule, retain prior versions, and compare new records against earlier benchmarks. Changes in offer amounts, participating companies, and geographic concentration can provide early indications of shifting competition within a shale play.
Create the export in Shale Navigator, validate the records against the map, and use the resulting dataset as the foundation for your next acreage review, negotiation strategy, or investment report. A disciplined workflow turns scattered lease signals into evidence that can support clearer decisions.