SiteWordAdsSettings

Query and Update detailed WordAds settings information about a site.

Table Specific Information

SELECT

The connector processes all the filters client-side within the connector.

SELECT * FROM SiteWordAdSettings

Update

To update a site word ad settings you must specify the following Site ID column: ID, PayPalAddress. Incase the Terms of Service have not been signed, it will be required for Update. The API will always return a single record for the site, depending on the URL specified in the connection string.

UPDATE SiteWordAdSettings SET  PayPalAddress= '[email protected]', TermsOfService='signed' WHERE ID = 241575003

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	Integer	True		The unique identifier of the site associated with the WordAds settings.
Name	String	True		The display name or title of the WordPress site.
ItemURL	String	True		The full URL of the site whose WordAds settings are being managed.
IsSettingsOptimizedAds	Boolean	True		Indicates whether ad placement is optimized automatically by WordAds for better performance.
IsSettingsDisplayOptionsDisplayArchive	Boolean	False		Determines whether ads are displayed on archive pages such as category or tag listings.
IsSettingsDisplayOptionsDisplayFrontPage	Boolean	True		Determines whether ads appear on the site's front page or homepage.
IsSettingsDisplayOptionsDisplayPage	Boolean	True		Determines whether ads are displayed on static pages.
IsSettingsDisplayOptionsDisplayPost	Boolean	True		Determines whether ads are shown on individual post pages.
IsSettingsDisplayOptionsEnableHeaderAd	Boolean	True		Specifies whether a header ad is enabled at the top of the site.
IsSettingsDisplayOptionsInlineEnabled	Boolean	True		Specifies whether inline ads (within content) are enabled.
IsSettingsDisplayOptionsSidebar	Boolean	True		Specifies whether sidebar ads are enabled.
IsSettingsDisplayOptionsSecondBelowpost	Boolean	True		Specifies whether an additional ad unit appears below post content.
PayPalAddress	String	False		The PayPal email address associated with WordAds payouts.
TermsOfService	String	False		Indicates whether the WordAds Terms of Service have been accepted. Required for enabling or updating ad settings if not yet signed.
ShowToLoggedIn	String	False		Specifies whether ads should be shown to logged-in users.
IsCCPAEnabled	Boolean	False		Enables or disables targeted advertising for visitors in California, in compliance with the California Consumer Privacy Act (CCPA).
CCPAPrivacyPolicyURL	String	False		The URL displayed at the bottom of the CCPA notice pop-up, linking to the site's privacy policy. A pop-up window opens in a new browser tab, while a pop-up dialog box appears as an overlay on the same page.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.