Four Queries Every P2 Land Customer Should Be Using

Four Queries Every P2 Land Customer Should Be Using

Confession … I own a minivan.

And you know what convinced me to sell my sweet, 300-horsepower, all-wheel-drive SUV to buy one? Data. I looked at a side-by-side comparison of all my options and decided it best met my family’s needs.

So, what does buying a minivan have to do with reporting? Options.

Just like I want all my car options in one place, I want to be able to view all my oil and gas assets in one location to decide the best drill site tract, the optimal formation to produce from, or the most effective order to develop my leasehold to keep the most acres.

Reporting shouldn’t be difficult – make P2 Land work for you.

Here are four queries that will give you options to help you do the most using Query Builder:

Query #1: Expiration Schedule

See all your leases coming up before expiration. Add in provisions to see which agreements have an option to extend. Even better, add in the payment information to see if the payment has been set up, and only bring back non-producing leases whose extensions have not already been paid. Also, be sure to add the prospect if you want to evaluate importance by area. This will give you a good picture of which leases to develop first.

Query #2: Expirations Continued

Are those leases in an area that you’ve decided to move on from? The payment amount and date are also useful to see how much you will have to pay each month the asset doesn’t sell. View the results in your map on top of the leasing activity in that area to find who might be interested. Low on cash? See if any of those companies are offering acreage in the areas you’ve turned your focus to and work out a trade.

Query #3: Exhibit “A”

Standard exhibit “A’s” lock you in to one format and often aren’t the best looking. And, depending on the format, they might not be as easy to drag into Microsoft Word when you’re preparing your sale document. Saving this as a query instead of using the standard report enables you to easily filter, group, and export your data in a format you can drag straight into your PSA, farmout, or other agreement needing an exhibit “A.”

Query #4: Minerals Available to Lease

What tracts should you be marketing? Show all un-leased and partially-leased minerals by county and view the results on the map. Use P2 Tobin to see leasing and well activity and gain a better understanding of which minerals you should be marketing. Identify on Tobin’s Lease layer and you can now see who you might want to call to get your minerals leased.

Bonus Query: Legal Description

Bonus round! Ok, this query doesn’t have to do with options, but I use it all the time and it's a great one to have saved. Whether it’s a call from an unknown owner who wants to know where their money is or a cessation notice that only has the API number and legal, this search will steer you straight to the agreements in question. I like to see the agreement number, tract name, and lessor name. I also like to bring back the well name, API number, and any cross references to see if the lease might be held by production elsewhere.

So, unlike the college textbooks sitting under my computer monitor, I hope these five queries get referenced, help you save time in your daily work, and empower you to evaluate your options using P2 Land.


About The Author
Aaron Farris is a Solution Consultant at P2, specializing in Land and Reporting. Prior to coming on board at P2, Aaron worked in field operations, in-house exploration, and company-owned minerals. When he’s not providing land software solutions for P2, you’ll likely find Aaron wrestling with his two kids or riding his bike. Aaron is a certified lease and title analyst and graduated in 2010 with a bachelor’s degree in Energy Commerce from Texas Tech.

Related Articles

For Exec-Level Managers and IT Personnel, Communication Hurdles Abound When It Comes To Shift Logs, Shift Handover

In previous blogs , we have examined the communication challenges for operators and supervisors around shift logs and shift handover...

The Problem with Siloed Data in Oil and Gas Reporting

Making informed and quality decisions regarding your upstream oil and gas operation requires timely and accurate data often from different...

The Painful Cost of Non-Integrated Solutions in Upstream Oil and Gas Accounting

One of the biggest challenges facing oil and gas accounting and finance teams is the lack of centralized data –...