# OrderId Lookup Report

<a href="https://pxa.impact.com/student/activity/1117597?sid=0c0e3e5c-54c9-4435-9bee-ebcdccb7f292&#x26;sid_i=0?utm_source=app.impact.com&#x26;utm_medium=owned-platform&#x26;utm_content=tra-350&#x26;utm_campaign=help-center" class="button primary">Take the PXA course</a>

The *OrderId (OID) Lookup* report gives you more information about a specific order, like what program it's associated with, its status, the associated payout, and more.

#### Find the OrderId Lookup report

You will need the Order ID number of the order you want to look up. You can retrieve the Order ID from multiple locations, like the [*Action Listing*](https://help.impact.com/brand/what-would-you-like-to-learn-about/platform-features/multi-program-reports/performance-reports-for-brands/advanced-action-listing-report) report or the [*Pending Payouts*](https://app.impact.com/secure/advertiser/engage/actions/open/pending-actions-flow.ihtml) screen. Once you have the Order ID number for the order you want to look up, you can use it to search within this report.

Importantly, the Order ID appears only once in the *OrderId Lookup* report, even if the order has several items. However, in the *Action Lookup by OID* report, the Order ID may appear more than once because it lists each item or action separately.

1. From the left navigation bar, select ![](https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2Fgit-blob-230534471fef5f40808e921e41ee44e4a06ded03%2Fe6cb9548999afdc1ed3ce4942e4cb5b45b5cecbd323267aac2a7cd1915fccc09.svg?alt=media) **\[Engage] → Transactions → Pending Payouts → Actions**.
2. In the top right corner, select ![](https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2Fgit-blob-65c4944ad47b13f7674253361abf76d63f4e96e8%2Ff7a699862181a6c829d80dc210586ea889343ba9fbf066bbc7488ed7dde8a389.svg?alt=media) **\[Reports]** → **OID Lookup**.
3. Enter your Order ID number, then select **Lookup**.
4. View the report.
   * Here you can view information about the order you looked up. If you need information about the order's associated action, see the [Action Lookup by OID report](#section-idm133445742406368) section below.
   * See the *OrderId Lookup table reference* for more information about each column.

<details>

<summary>OrderId Lookup table reference</summary>

|                  |                                                                                                                       |
| ---------------- | --------------------------------------------------------------------------------------------------------------------- |
| **Table Column** | **Description**                                                                                                       |
| Event Date       | The date and time that the order happened. This will be in [ISO 8601](https://en.wikipedia.org/wiki/ISO_8601) format. |
| Campaign         | The program (formerly known as *campaign*) associated with this order.                                                |
| Action Tracker   | impact.com's ID number for the event type (formerly known as *action tracker*) associated with the order.             |
| Status           | Any status updates or warnings for this order.                                                                        |
| Payout           | What the payout for this specific order is.                                                                           |
| Referrer Info    | Information about how the order was tracked, like impact.com's number ID for the partner that drove the order.        |
| Error Message    | If there are any terminal error messages for the order, they will appear here.                                        |

</details>

#### Action Lookup by OID report

This report will show you action data related to the Order ID number you use. You can view the sale amount, the payout, the client cost, and more. This report will not work if you do not have a valid Order ID number and will not work with Order IDs associated with pending actions.

1. From the left navigation bar, select ![](https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2Fgit-blob-230534471fef5f40808e921e41ee44e4a06ded03%2Fe6cb9548999afdc1ed3ce4942e4cb5b45b5cecbd323267aac2a7cd1915fccc09.svg?alt=media) **\[Engage] → Transactions → Pending Payouts → Actions**.
2. In the top right corner, select ![](https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2Fgit-blob-65c4944ad47b13f7674253361abf76d63f4e96e8%2Ff7a699862181a6c829d80dc210586ea889343ba9fbf066bbc7488ed7dde8a389.svg?alt=media) **\[Reports]** → **Action Lookup by OID**.
3. Under *Action Lookup by OID*, select **Enter OID value**, then enter the Order ID value.
4. Select ![](https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2Fgit-blob-26956d35e17c61868ca8dba76097721fd6066ab4%2F69945c787eb2db89761c82e0cd32fb31d2fc690bfb8592d9a08b7e7983b7445b.svg?alt=media) **\[Search]**.
5. View the report.
   * See the *Action Lookup table reference* for more information about the columns.

<details>

<summary>Action Lookup table reference</summary>

|                  |                                                                                                                                                                                                                               |
| ---------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Table Column** | **Description**                                                                                                                                                                                                               |
| Action Date      | The date and time that the order happened. This will be in [ISO 8601](https://en.wikipedia.org/wiki/ISO_8601) format.                                                                                                         |
| Action ID        | <p>The ID for the order's associated tracked action.</p><p>Select the Action ID number to view the Action Detail report, where you can see the journey the consumer took, the sale amount, and more.</p>                      |
| OID              | The order ID number. This will match the order ID number you enter in Step 3 above.                                                                                                                                           |
| Sale Amount      | The sale amount for the associated action.                                                                                                                                                                                    |
| Payout           | The payout for the associated action.                                                                                                                                                                                         |
| Rate             | The payout rate for the associated action.                                                                                                                                                                                    |
| Client Cost      | The client cost for driving the associated action.                                                                                                                                                                            |
| Media Fee        | The media fee for the associated action.                                                                                                                                                                                      |
| Action Status    | What stage in the [action locking process](https://help.impact.com/brand/what-would-you-like-to-learn-about/platform-features/actions-and-payouts/understand-the-action-life-cycle-and-finance) the associated action is.     |
| Payable Status   | What stage in the [payment scheduling process](https://help.impact.com/brand/what-would-you-like-to-learn-about/platform-features/actions-and-payouts/understand-the-action-life-cycle-and-finance) the associated action is. |
| Promo Code       | If a [promo code](https://help.impact.com/brand/what-would-you-like-to-learn-about/platform-features/promo-codes/promo-codes-overview) was used, it would appear in this column.                                              |
| Partner          | Which publisher drove the associated order event?                                                                                                                                                                             |
| Event Type       | The type of action which was tracked. E.g., Online sale/CPA, lead submit, app download.                                                                                                                                       |
| Show             | If you added any columns with the *Show* filter, they would appear at the right end of the table.                                                                                                                             |

</details>
