NamedAccounts

Query Named Accounts for a Marketo organization.

Table Specific Information

Select

A filter must be specified when retrieving named accounts. Valid filters are any searchable columns which include MarketoGUID, Name, Industry, State, City, etc.

SELECT * FROM NamedAccounts WHERE Name='MyAccount'

Insert

To create a new NamedAccount record, specify the information about the named account to be entered into the database.

The following example demonstrates how to insert a new NamedAccount:

INSERT INTO NamedAccounts (Name, City, Country, Industry) VALUES ('MyAccount', 'MyCity', 'USA', 'Tech')

Update

Any field that is not read-only can be updated.

UPDATE NamedAccounts SET NumberOfEmployees=100, State='NC', AnnualRevenue='10000000.00' WHERE Name='MyAccount'

Delete

Delete is used to remove named accounts from Marketo. To perform a delete, either the MarketoGUID field or the Name field is required.

DELETE FROM NamedAccounts WHERE Name=='MyAccount'

Columns


Name	Type	ReadOnly	Filterable	Description
MarketoGUID [KEY]	String	True	True	The unique, Marketo-assigned identifier of the named account.
Name	String	False	True	The name of the account.
AccountOwnerId	Integer	False	True	The owner id of the account.
AnnualRevenue	Double	False	True	The annual revenue for the account.
City	String	False	True	The city for the account.
Country	String	False	True	The country for the account.
DomainName	String	False	True	The name of the domain for the account.
Industry	String	False	True	The industry for the account.
LogoURL	String	False	True	The URL to the logo for the account.
MembershipCount	Integer	True	True	The number of members for the account.
NumberOfEmployees	Integer	False	True	The number of employees for the account.
OpptyAmount	Double	True	True	The total amount of opportunities for the account.
OpptyCount	Integer	True	True	The total number of opportunities for the account.
SICCode	String	False	True	The SIC Code for the account.
State	String	False	True	The state for the account.
CreatedAt	Datetime	True		The date and time the named account was created.
UpdatedAt	Datetime	True		The date and time the named account was last updated.