Excel Add-In for Marketo

Build 23.0.8839

NamedAccounts

Query Named Accounts for a Marketo organization.

テーブル固有の情報

Select

名前付きアカウントを取得するには、フィルターを指定する必要があります。Valid filters are any searchable columns which include MarketoGUID, Name, Industry, State, City, etc.

SELECT * FROM NamedAccounts WHERE Name = 'MyAccount'

Insert

新しいNamedAccount レコードを作成するには、名前付きアカウントに関するデータベースに入力する情報を指定します。

次の例では、新しいNamedAccount を挿入する方法を説明します。

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

Update

読み取り専用以外のフィールドは、すべて更新可能です。

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

Delete

Marketo から名前付きアカウントを削除するために使用します。削除を実行するには、MarketoGUID フィールドかName フィールドのどちらかが必須です。

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839