Excel Add-In for WordPress

Build 25.0.9434

Sites

Query information about a site.

Table Specific Information

SELECT

The add-in processes all the filters client-side within the add-in.

SELECT * FROM Sites

Columns

Name Type References Description
ID [KEY] Int The unique numeric identifier for the site.
Name String The site's public title as shown in WordPress.
Description String The site's tagline or short description.
ItemURL String The full public URL of the site.
CanUserManage Bool Indicates whether the current user has management permissions for this site.
Capabilities String A list of capabilities granted to the current user on this site.
IsJetpackSite Bool True if the site is connected through Jetpack.
IsJetpackConnection Bool True if the site is connected to WordPress.com via a Jetpack connection.
IsMultisite Bool True if the site belongs to a Multisite network (always true for WordPress.com sites).
SiteOwner Int The user ID of the site owner.
PostCount Int The total number of published posts on the site.
SubscribersCount Int The number of followers/subscribers for the site.
Language String The site's primary language code (for example, en, fr).
IconAggregate String A collection of icon variants, such as sizes and formats, for the site.
LogoId Int The media ID of the site's logo.
LogoSizesAggregate String Available sizes for the site's logo.
LogoUrl String Direct URL to the site's logo image.
IsVisible Bool Indicates Indicates whether this site appears in the user's site list.
IsPrivate Bool Indicates Indicates whether the site is private (requires authentication).
IsComingSoon Bool True if the site is marked as Coming Soon and not yet public.
IsSingleUserSite Bool True if the site has a single user (WordPress.com and Jetpack 3.4+ only).
IsVIP Bool True if the site runs on the WordPress VIP platform.
IsFollowing Bool True if the current user follows this site in Reader.
OrganizationId Int Identifier for the associated P2 organization.
OptionsAdminUrl String Admin settings URL, visible only to users with editing rights.
OptionsAdvancedSEOFrontPageDescription String Search Engine Optimization (SEO) description used on the front page (editors only).
OptionsAdvancedSEOTitleFormatsAggregate String SEO title format rules for the website (editors only).
OptionsAKVPBundleEnabled String Indicates whether the AKVP bundle is enabled (editors only).
OptionsAllowedFileTypesAggregate String List of allowed upload file types (editors only).
IsOptionsAnchorPodcast Bool Indicates whether Anchor podcast integration is enabled (editors only).
IsOptionsBackgroundColor Bool Indicates whether a custom background color is set (editors only).
OptionsBlogPublic Int Public visibility setting: 1 public, 0 discourage search, -1 private (editors only).
IsOptionsBloggingPromptsSettingsPotentialBloggingSite Bool Marks the site as a candidate for blogging prompts (editors only).
IsOptionsBloggingPromptsSettingsPromptsCardOptedIn Bool Indicates whether prompts cards are enabled (editors only).
IsOptionsBloggingPromptsSettingsPromptsRemindersOptedIn Bool Indicates whether prompts reminders are enabled (editors only).
OptionsBloggingPromptsSettingsRemindersDaysAggregate String Days configured for prompts reminders (editors only).
OptionsBloggingPromptsSettingsRemindersTime String Time of day for prompts reminders (editors only).
CanOptionsBlaze Bool Indicates whether Blaze promotion features are available (editors only).
OptionsCreatedAt Datetime Timestamp when site options were created (editors only).
OptionsDefaultCategory Int Default category ID for new posts (editors only).
HasOptionsDefaultCommentStatus Bool Default comment status for new posts (editors only).
HasOptionsDefaultLikesEnabled Bool Default likes setting for new posts (editors only).
HasOptionsDefaultPingStatus Bool Default pingback/trackback status for new posts (editors only).
OptionsDefaultPostFormat String Default post format for new content (editors only).
HasOptionsDefaultSharingStatus Bool Default sharing buttons visibility on new posts (editors only).
OptionsDesignType String Current design type or theme style (editors only).
IsOptionsEditingToolkitActive Bool Indicates whether the Editing Toolkit is active (editors only).
HasOptionsFeaturedImagesEnabled Bool Indicates whether featured images are enabled site-wide (editors only).
OptionsFrameNonce String Security nonce used for framed embeds (editors only).
OptionsGmtOffset Int Configured GMT offset for the site (editors only).
HasOptionsHeaderImage Bool Indicates whether a custom header image is set (editors only).
HasOptionsHeadstart Bool Indicates whether Headstart onboarding is enabled (editors only).
HasOptionsHeadstartFresh Bool Indicates whether Headstart is in a fresh state (editors only).
OptionsImageDefaultLinkType String Default link behavior for inserted images (editors only).
OptionsImageLargeHeight Int Height for the Large image size, in pixels (editors only).
OptionsImageLargeWidth Int Width for the Large image size, in pixels (editors only).
OptionsImageMediumHeight Int Height for the Medium image size, in pixels (editors only).
OptionsImageMediumWidth Int Width for the Medium image size, in pixels (editors only).
OptionsImageThumbnailCrop Int Hard crop setting for thumbnails: 1 hard crop, 0 proportional (editors only).
OptionsImageThumbnailHeight Int Thumbnail height in pixels (editors only).
OptionsImageThumbnailWidth Int Thumbnail width in pixels (editors only).
OptionsImportEngine String Selected import engine or source (editors only).
IsOptionsAutomatedTransfer Bool Indicates whether an automated transfer/migration is active (editors only).
IsOptionsCloudEligible Bool Indicates whether the site is eligible for cloud features (editors only).
IsOptionsCommercial Bool Indicates whether the site is flagged as commercial (editors only).
IsOptionsCommercialReasonsAggregate Bool Indicates whether specific reasons mark the site as commercial (editors only).
IsOptionsIsDifmLiteInProgress Bool Indicates whether a Do-It-For-Me Lite setup is in progress (editors only).
IsOptionsDomainOnly Bool Indicates whether the site uses a domain-only configuration (editors only).
IsOptionsMappedDomain Bool Indicates whether a custom domain is mapped (editors only).
IsOptionsPendingPlan Bool Indicates whether a plan change is pending (editors only).
IsOptionsRedirect Bool Indicates whether the site redirects to another URL (editors only).
IsOptionsWPComAtomic Bool Indicates whether the site runs on WP.com Atomic hosting (editors only).
IsOptionsWPComStore Bool Indicates whether the WP.com Store is enabled (editors only).
IsOptionsWPForTeamsSite Bool Indicates whether the site is a WP for Teams site (editors only).
OptionsJetpackFrameNonce String Security nonce used for Jetpack frames (editors only).
OptionsLaunchpadChecklistTasksStatusesAggregate String Statuses for Launchpad checklist tasks (editors only).
OptionsLaunchpadScreen String Current Launchpad screen state (editors only).
OptionsLoginUrl String Direct login URL for the site (editors only).
OptionsMigrationSourceSiteDomain String Source site domain used during migration (editors only).
OptionsOnboardingSegment String Onboarding segment classification (editors only).
OptionsP2HubBlogID String Blog ID of the P2 hub site (editors only).
OptionsPermalinkStructure String Permalink structure pattern (editors only).
OptionsPodcastingArchive String Podcasting archive settings (editors only).
OptionsPostFormatsAggregate String Post formats supported/configured (editors only).
IsOptionsPublicizePermanentlyDisabled Bool Indicates whether Publicize is permanently disabled (editors only).
OptionsShowOnFront String Front page display setting: posts or a static page (editors only).
OptionsSiteCreationFlow String Site creation flow identifier (editors only).
OptionsSiteGoalsAggregate String Configured site goals and progress (editors only).
OptionsSiteIntent String Stated purpose or intent for the site (editors only).
OptionsSitePartnerBundle String Partner bundle applied to the site (editors only).
OptionsSiteSegment String Site segment classification used by onboarding or analytics (editors only).
OptionsSiteVerticalID String Vertical or industry identifier (editors only).
OptionsSoftwareVersion String Current software version markers (editors only).
OptionsThemeErrorsAggregate String Detected theme errors or diagnostics (editors only).
OptionsThemeSlug String Slug of the active theme (editors only).
OptionsTimezone String Timezone string (for example, America/New_York) (editors only).
OptionsUnmappedUrl String Original URL before domain mapping (editors only).
OptionsUpdatedAt Datetime Timestamp of the last options update (editors only).
IsOptionsUpgradedFiletypesEnabled Bool Indicates whether upgraded upload file types are enabled (editors only).
OptionsVerificationServicesCodes String Site verification codes for search/analytics services (editors only).
IsOptionsVideopressEnabled Bool Indicates whether VideoPress is enabled (editors only).
OptionsVideopressStorageUsed Int Amount of VideoPress storage used, in MB (editors only).
IsOptionsCreatedWithBlankCanvasDesign Bool True if the site was created with the Blank Canvas design.
IsOptionsWoocommerceActive Bool True if WooCommerce is active on the site.
IsOptionsWordAds Bool True if WordAds is enabled (editors only).
OptionsWPComAdminInterface String The WordPress.com admin interface mode in use.
IsOptionsWPComClassicEarlyRelease Bool True if the Classic interface early release is enabled.
OptionsWPComProductionBlogID Int The WordPress.com production blog ID.
IsOptionsWPComSiteSetup Bool True if the WP.com site setup is active.
OptionsWPComStagingBlogIDsAggregate String List of staging blog IDs associated with the site.
P2ThumbnailElementsAggregate String Data used to render a site thumbnail (P2020 themes only).
PlanBillingPeriod String The billing period for the current plan (for example, monthly, yearly).
IsPlanExpired Bool True if the site's paid plan has expired.
PlanFeaturesActiveAggregate String A list of plan features currently active on the site.
PlanFeaturesAvailableadCredit String Indicates whether advertising credit is available in the plan.
PlanFeaturesAvailableadvancedSEO String Indicates whether advanced SEO tools are available in the plan.
PlanFeaturesAvailableAIAssistant String Indicates whether the AI Assistant feature is available in the plan.
PlanFeaturesAvailableAISEOEnhancer String Indicates whether AI SEO Enhancer is available in the plan.
PlanFeaturesAvailableAntispam String Indicates whether anti-spam protection is available in the plan.
PlanFeaturesAvailableArchiveContent String Indicates whether content archiving is available in the plan.
PlanFeaturesAvailableArtificia50GBStorageLimit String Indicates whether a 50 GB storage cap applies to the plan.
PlanFeaturesAvailableAtomic String Indicates whether Atomic hosting features are available.
PlanFeaturesAvailableBackups String Indicates whether site backups are included in the plan.
PlanFeaturesAvailableBigSky String Indicates whether Big Sky features are available in the plan.
PlanFeaturesAvailableBlogDomainOnly String Indicates whether a blog-domain-only configuration is available.
PlanFeaturesAvailableCalendly String Indicates whether Calendly integration is available.
PlanFeaturesAvailableCDN String Indicates whether CDN acceleration is available.
PlanFeaturesAvailableCloudflareAnalytics String Indicates whether Cloudflare Analytics is available.
PlanFeaturesAvailableCloudflareCDN String Indicates whether Cloudflare CDN is available.
PlanFeaturesAvailableConcierge String Indicates whether Concierge support is included.
PlanFeaturesAvailableConciergeBusiness String Indicates whether Concierge Business support is included.
PlanFeaturesAvailableCopySite String Indicates whether Copy Site tooling is available.
PlanFeaturesAvailableCoreAudioAggregate String Indicates whether core/audio blocks are supported.
PlanFeaturesAvailableCoreCover String Indicates whether core/cover blocks are supported.
PlanFeaturesAvailableCoreVideo String Indicates whether core/video blocks are supported.
PlanFeaturesAvailableCreditVouchers String Indicates whether credit vouchers are available.
PlanFeaturesAvailableCustomDesign String Indicates whether advanced design customization is available.
PlanFeaturesAvailableCustomDomain String Indicates whether attaching a custom domain is supported.
PlanFeaturesAvailableDomainMapping String Indicates whether mapping an external domain is supported.
PlanFeaturesAvailableEcommerceManagedPlugins String Indicates whether managed eCommerce plugins are available.
PlanFeaturesAvailableEcommerceManagedPluginsMedium String Indicates whether mid-tier managed eCommerce plugins are available.
PlanFeaturesAvailableEcommerceManagedPluginsSmall String Indicates whether the plan includes the small package of managed eCommerce plugins for lightweight online stores.
PlanFeaturesAvailableEcommerceManagedPluginsTrial String Indicates whether a trial version of managed eCommerce plugins is available under the plan.
PlanFeaturesAvailableEditPlugins String Allows users to edit plugin source code and configuration directly in the WordPress dashboard.
PlanFeaturesAvailableEditThemes String Allows users to modify theme files and settings directly from the dashboard.
PlanFeaturesAvailableEmailForwardsExtendedLimit String Provides an extended limit for creating and managing email forwarding aliases.
PlanFeaturesAvailableFullActivityLog String Enables full tracking of all site activity, including post edits, logins, and plugin changes.
PlanFeaturesAvailableGlobalStyles String Provides access to Global Styles for customizing typography, colors, and layout across the site.
PlanFeaturesAvailableGoogleAnalytics String Allows integration with Google Analytics to track visitor traffic and engagement.
PlanFeaturesAvailableGoogleMyBusiness String Enables synchronization and management of Google Business Profile listings directly from WordPress.
PlanFeaturesAvailableInstallPlugins String Allows installation of new plugins from the WordPress plugin directory or ZIP uploads.
PlanFeaturesAvailableInstallPurchasedPlugins String Allows installation of previously purchased plugins linked to the user's account.
PlanFeaturesAvailableinstallThemes String Allows installation of new themes from the WordPress theme library or via ZIP upload.
PlanFeaturesAvailableInstallWooOnboardingPlugins String Includes WooCommerce onboarding plugins to simplify initial store setup.
PlanFeaturesAvailableJetpackDashboard String Provides access to the Jetpack dashboard for managing performance, security, and marketing features.
PlanFeaturesAvailableLegacyContact String Includes legacy contact features such as old-form integrations or widgets.
PlanFeaturesAvailableListInstalledPlugins String Allows viewing and listing all plugins currently installed on the site.
PlanFeaturesAvailableLiveSupport String Provides access to real-time chat or phone support from WordPress.com staff.
PlanFeaturesAvailableLockedMode String Enables Locked Mode to restrict editing or publishing activity during maintenance or review.
PlanFeaturesAvailableMailPoetBusiness String Includes MailPoet Business plan features for advanced email marketing automation.
PlanFeaturesAvailableManagePlugins String Allows activating, deactivating, and managing plugin updates or configurations.
PlanFeaturesAvailableNoAdverts String Removes all WordPress.com advertisements from the site's pages.
PlanFeaturesAvailablENOWPComBranding String Removes default WordPress.com branding elements from the site's footer and login screens.
PlanFeaturesAvailableOpentable String Adds OpenTable integration or blocks for online reservations.
PlanFeaturesAvailableOptionsPermalink String Allows configuration of advanced permalink structures for URLs.
PlanFeaturesAvailablePayments String Enables Payments features for collecting one-time or recurring payments directly on posts or pages.
PlanFeaturesAvailablePersonalThemes String Provides access to the Personal tier's exclusive theme collection.
PlanFeaturesAvailablePremiumContentContainer String Enables the Premium Content block to restrict access to posts or sections for subscribers only.
PlanFeaturesAvailablePremiumThemes String Provides access to premium WordPress.com themes included with the plan.
PlanFeaturesAvailablePrioritySupport String Provides priority handling for support requests and faster response times.
PlanFeaturesAvailablePrivateWhois String Enables private registration to hide domain ownership details from public records.
PlanFeaturesAvailableRealTimeBackups String Provides continuous, real-time backups that capture every site change instantly.
PlanFeaturesAvailableReducedEmailPriority String Indicates that email support requests receive lower priority under this plan tier.
PlanFeaturesAvailableRepublicize String Enables advanced Publicize features for sharing posts across connected social media accounts.
PlanFeaturesAvailableRestore String Allows restoring the site from previous backups or restore points.
PlanFeaturesAvailableScan String Provides automated security scans to detect malware, threats, or vulnerabilities.
PlanFeaturesAvailableScanManaged String Includes managed scanning services that automatically detect and repair site issues.
PlanFeaturesAvailableScheduledUpdates String Allows scheduling automatic plugin and theme updates to run at defined times.
PlanFeaturesAvailableSearch String Enables advanced on-site search functionality for faster, more accurate results.
PlanFeaturesAvailableSecuritySettings String Unlocks additional security configuration options to protect site data and user access.
PlanFeaturesAvailableSendAMessage String Provides access to tools that let users send direct messages or newsletters to followers.
PlanFeaturesAvailableSEOPreviewTools String Displays live previews of how posts appear in search results and on social media platforms.
PlanFeaturesAvailableSetPrimaryCustomDomain String Allows setting a specific custom domain as the site's primary URL.
PlanFeaturesAvailableSFTP String Enables secure file transfer (SFTP) access for uploading, editing, and managing site files.
PlanFeaturesAvailableSimplePayments String Enables Simple Payments buttons for accepting direct payments or donations through posts and pages.
PlanFeaturesAvailableSitePreviewLinks String Allows creating shareable preview links for draft posts and pages before publishing.
PlanFeaturesAvailableSocialEnhancedPublishing String Improves social sharing options with advanced scheduling and post formatting tools.
PlanFeaturesAvailableSocialImageGenerator String Automatically generates optimized social media images when sharing posts.
PlanFeaturesAvailableSocialPreviews String Shows real-time previews of how posts appear on social media feeds before publishing.
PlanFeaturesAvailableSpaceUpgradedStorage String Provides increased media storage capacity beyond the default plan limit.
PlanFeaturesAvailableSSH String Grants SSH access for secure command-line management of the site's hosting environment.
PlanFeaturesAvailableStagingSites String Allows creating and managing staging environments to test changes safely before going live.
PlanFeaturesAvailableStatsCommercial String Provides enhanced analytics and commercial-grade reporting on site performance and engagement.
PlanFeaturesAvailableStatsPaid String Includes advanced statistics and reporting features available to paid plans.
PlanFeaturesAvailableStudioSync String Supports synchronization between local WordPress Studio environments and the live site.
PlanFeaturesAvailableSubscriberUnlimitedImports String Allows importing an unlimited number of subscribers for newsletters or memberships.
PlanFeaturesAvailableSubscriptioNGifting String Enables gifting of site subscriptions or memberships to other users.
PlanFeaturesAvailableUpgradedUploadFiletypes String Expands allowed upload types beyond default WordPress file extensions.
PlanFeaturesAvailableUploadAudioFiles String Allows uploading, storing, and embedding audio files directly into site content.
PlanFeaturesAvailableUploadPlugins String Permits uploading and installing custom plugin ZIP files.
PlanFeaturesAvailableUploadThemes String Permits uploading and activating custom theme ZIP files.
PlanFeaturesAvailableUploadVideoFiles String Allows uploading, storing, and embedding video files within posts and pages.
PlanFeaturesAvailableVideoHosting String Provides dedicated video hosting services for faster playback and higher quality streaming.
PlanFeaturesAvailableVideopress String Enables VideoPress integration for optimized video delivery and privacy control.
PlanFeaturesAvailableVideopressVideo String Includes the VideoPress block and features for embedding videos from the VideoPress library.
PlanFeaturesAvailableWhatsappButton String Adds a WhatsApp contact or share button for posts and pages.
PlanFeaturesAvailableWoop String Includes WooCommerce Payments features for processing online transactions.
PlanFeaturesAvailableWordAds String Enables WordAds, allowing the site to display and monetize ads.
PlanFeaturesAvailableWordAdsJetpack String Extends WordAds monetization to Jetpack-connected self-hosted sites.
IsPlanFree Bool Indicates whether the current plan is the free version.
PlanLicenseKey String The license key associated with the site's active plan or product.
PlanProductID Int Unique identifier for the active product or plan.
PlanProductName String Full name of the plan or product assigned to the site.
PlanProductNameShort String Short display name of the current plan.
PlanProductSlug String Slug identifier for the plan used in API calls and URLs.
IsPlanUserOwner Bool Indicates whether the current user is the owner of the site's plan.
ProductsAggregate String Lists all products, add-ons, or services currently active for this site.
Isa4aClient Bool True if the site is an Automattic for Agencies (A4A) client deployment managed under the A4A program.
Isa4aDevSite Bool True if the site is an A4A development instance used for testing or staging.
IsCoreSiteEditorEnabled Bool Indicates whether the WordPress core Site Editor (block editor) is enabled.
IsDeleted Bool True if the site has been flagged as deleted or removed from active use.
IsFSEActive Bool True if Full Site Editing features are currently active.
IsFSEEligible Bool True if the site supports Full Site Editing based on theme compatibility and environment.
IsWPcomAtomic Bool True if the site is hosted on WordPress.com's Atomic infrastructure.
IsWPcomStagingSite Bool True if the site is a staging instance hosted on WordPress.com.
JetpackModulesAggregate String A list of active Jetpack modules enabled on this site.
LaunchStatus String Describes the site's launch state, such as launched, prelaunch, or coming soon.
QuotaPercentUsed Double Percentage of total storage space currently used by the site.
QuotaSpaceAllowed Long Total amount of storage space allocated to the site, in bytes.
QuotaSpaceAvailable Long Amount of unused storage space remaining, in bytes.
QuotaSpaceUsed Int Total amount of storage currently in use, in bytes.
SiteMigration String Information about migration history or transfer data for this site.
UpdatesAggregate String Details of available updates for WordPress core, themes, plugins, or languages.
UserInteractionsAggregate String Aggregated metrics of user activity or engagement on the site.
WasEcommerceTrial Bool True if the site previously used an eCommerce trial plan.
WasHostingTrial Bool True if the site previously used a hosting trial plan.
WasMigrationTrial Bool True if the site previously used a migration trial plan.
WasUpgradedFromTrial Bool True if the site was upgraded from a trial plan to a paid subscription.
WPComSiteSetup String Unique identifier for the site's WordPress.com setup flow or environment.
ZendeskSiteMetaAddonAggregate String Metadata describing Zendesk add-ons linked to the site.
ZendeskSiteMetaPlan String Metadata describing the Zendesk plan associated with the site.

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