Opportunities
Query Opportunities for a Marketo organization.
Table Specific Information
Select
Marketo allows the following columns to be used in the WHERE clause of a SELECT query: Id, Name, CreatedAt, UpdatedAt, Type, and Stage.
The CreatedAt and UpdatedAt filters can be specified twice to create a date range.
SELECT * FROM Opportunities WHERE Stage='Commercial'
Columns
| Name | Type | Description |
| Id [KEY] | Integer | The unique, Marketo-assigned identifier of the opportunity. |
| Name | String | The name of the opportunity. |
| Description | String | The description of the opportunity. |
| CompanyId | String | The Id of the company assigned to the opportunity. |
| Quantity | Double | Number of items included in this opportunity. Used in quantity-based forecasting. |
| Amount | Decimal | The estimated total sale amount from the opportunity. |
| ExpectedRevenue | Decimal | The expected revenue to result from the opportunity. |
| Stage | String | The stage that the opportunity process is currently in. |
| LeadSource | String | The source of the opportunity, such as Advertisement or Trade Show. |
| ExternalCreatedDate | Datetime | The local created date of the opportunity. |
| LastActivityDate | Date | The date of the last activity performed with this opportunity. |
| IsWon | Boolean | Determines whether the opportunity was won. |
| NextStep | String | A description of the next task in closing the opportunity. |
| IsClosed | Boolean | Determines whether the opportunity is closed. |
| CloseDate | Date | The date when the opportunity is expected to close. |
| Fiscal | String | If fiscal years are not enabled, the name of the fiscal quarter or period in which the opportunity CloseDate falls. Value should be in YYYY Q format, for example, '2006 1' for first quarter of 2006. |
| FiscalQuarter | Integer | The fiscal quarter the opportunity took place. Valid values are 1, 2, 3, or 4. |
| FiscalYear | Integer | The fiscal year the opportunity took place. |
| ForecastCategoryName | String | The name of the forecast category. |
| Probability | Integer | The percentage of estimated confidence in closing the opportunity. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| CreatedAt | Datetime | Used when performing a GET. Filters opportunities by the date they were created. |
| UpdatedAt | Datetime | Used when performing a GET. Filters opportunities by the date they were updated. |
| Type | String | Used when performing a GET. Filters opportunities by the opportunity type. |