Excel Add-In for Marketo

Build 24.0.9175

LandingPages

Create, update, delete and query Landing Pages for a Marketo organization.

Note: This table uses the draft/approved versioning API. By default both versions are retrieved/modified. To interact with a specific version use the filter Status='draft' or Status='approved'.

Select

Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.

For example, the following queries are processed server-side:

	SELECT * FROM LandingPages WHERE status='approved'
	SELECT * FROM LandingPages WHERE folderId=1001
	SELECT * FROM LandingPages WHERE folderId=1001 AND status='draft'
	SELECT * FROM LandingPages WHERE name='string'

Insert


	INSERT INTO LandingPages (Name, CustomHeadHTML, Description, FacebookOgTags, FolderId, FolderType, Keywords, MobileEnabled, Robots, Template, Title)
	VALUES ('test insert landing page', '<!DOCTYPE html>\\n<html>\\n<body>\\n<h1>My landing page</h1>\\n<p>My landing page content.</p>\\n</body></html>', 'Testing  Insert operation', '', 1184, 'Program', '', true, 'index,  nofollow', 1, 'Insert Operation')	

Update


	UPDATE LandingPages SET Description='Testing Update', FacebookOgTags='', Keywords='',
	MobileEnabled=false, Name='Test Update', Robots='index, nofollow',Title='Updating Landing Page',
	CustomHeadHTML='<!DOCTYPE html>\n<html>\n<body>\n<h1>Updating Landing Page</h1>\n<p>Editing Landing Page</p>\n</body></html>'
	WHERE Id=1009

Delete

Note: Approved landing pages cannot be deleted. Use UnApproveAsset to revoke landing page approval.

	DELETE FROM LandingPages WHERE Id=1003
	DELETE FROM LandingPages WHERE Id=1003 WHERE status='draft'

Columns

Name Type ReadOnly Operators Description
Id [KEY] Int True =

The unique, Marketo-assigned identifier of the landing page.

Status [KEY] String True =

Status filter for draft or approved versions.

Name String False =

The name of the landing page.

Description String False

The description of the landing page.

Title String False

Title element of the landing page.

URL String True

The URL of the landing page in the Marketo UI.

ComputedURL String True

Computed URL of landing page.

WorkspaceName String False

Workspace name of the asset.

Template Int False

Id of the template used.

Robots String False

Robots directives to apply to the pages meta tags

MobileEnabled Bool False

Whether the page has mobile viewing enabled. Free-form pages only. Default false.

CustomHeadHTML String False

Any custom HTML to embed in the tag of the page.

Keywords String False

Keywords

FormPrefill Bool True

Boolean to toggle whether forms embedded in the page will prefill. Default false.

FacebookOgTags String False

Any OpenGraph meta tags to apply to the page.

FolderId Int False =

The unique, Marketo-assigned identifier of the parent folder/program.

FolderName String True

The name of the folder

FolderType String False =

The type of folder (Folder,Program)

CreatedAt Datetime True

Datetime the landing page was created.

UpdatedAt Datetime True

Datetime the landing page was most recently updated.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175