Global AdSpace Management
The Global AdSpace Management page allows administrators to view, create, edit, and manage advertising spaces across websites. This centralized system controls where ads can be placed, their dimensions, pricing, and membership restrictions. Ad spaces define the locations and parameters for advertisements that can be displayed on web pages.
Quick Start
To add a new ad space: Click "Add Ad Space" â?? Fill in page location, dimensions, and fees â?? Set membership restrictions if needed â?? Save. To manage existing spaces: Use the data table to search, sort, and filter. Select multiple items for bulk operations like delete/undelete.
Permissions and Access
Access to Global AdSpace Management requires specific user permissions:
- Users Permission Required: Must have "Users" permission in your account to access this page
- Super Admin Access: Client ID 1 has unrestricted access to all ad spaces across all sites
- Site-Restricted Access: Non-admin users can only view/manage ad spaces for their specific website domain
- Workgroup Filtering: Ad spaces are filtered based on your workgroup and site assignments
The header bar displays important contextual information:
| Element |
Description |
| User Badge |
Shows your current username with person icon |
| System Title |
"Web CoPilot 2.0 - Ad Space Manager" identifies the current module |
| Current Date |
Displays today's date in full format (e.g., "Monday Jan 15, 2024") |
The toolbar provides quick access to primary actions and navigation options:
Primary Actions
| Button |
Function |
Result |
| + Add Ad Space |
Create new advertising space |
Opens Global_AdSpace_edit.cfm in add mode |
| â?쳌 Control Panel |
Return to main admin area |
Navigates to admin/admin.cfm |
| Show All |
Display all active ad spaces |
Refreshes page showing non-deleted records |
| UnDelete |
Switch to deleted records view |
Shows only soft-deleted ad spaces with recovery options |
When viewing deleted ad spaces (showdeleted=true), the toolbar changes to provide recovery options:
| Button |
Function |
| â?쳌 Back to Ad Spaces |
Return to active ad spaces view |
Data Table Columns
The main data table displays comprehensive information about each advertising space:
| Column |
Description |
Features |
| Checkbox |
Select individual records for bulk operations |
Works across paginated results; header checkbox selects all visible |
| Site |
Website domain where ad space exists |
Sortable and searchable |
| Page |
Specific page or template where ad appears |
Clickable link opens page in new tab; sortable and searchable |
| W Ã? H |
Ad space dimensions in pixels |
Format: "width Ã? height" (e.g., "728 Ã? 90") |
| Impress Fee |
Cost per thousand impressions (CPM) |
Formatted as currency (e.g., "$2.50") |
| Click Fee |
Cost per click (CPC) |
Formatted as currency |
| Conv Fee |
Cost per conversion/action |
Formatted as currency |
| Memberships |
Membership types that can view this ad space |
Comma-separated list; shows "â??" if unrestricted |
| Actions |
Quick action buttons |
Subs, Edit, View buttons (see Actions section below) |
| Status Icon |
Visual status indicator |
Green check (Active), Red X (Deleted), Gray dash (Inactive) |
| ID |
Unique ad space identifier |
Numeric ID; default sort column (descending) |
Individual Actions
Each ad space row provides several action options for individual record management:
| Button |
Function |
Destination |
| Subs |
View subscribers for this ad space |
Global_Subscribers_search.cfm with page filter |
| Edit |
Modify ad space settings |
Global_AdSpace_edit.cfm in edit mode |
| View |
Preview the actual page |
Opens page in new browser tab |
Status Icons and Quick Status Changes
The status column provides visual indicators and click-to-change functionality:
| Icon |
Status |
Click Action |
| â?쳌 Green Check Circle |
Active - ad space is live |
Click to deactivate (sets status to Inactive) |
| â?? Gray Dash Circle |
Inactive - ad space is paused |
Click to activate (sets status to Active) |
| â?? Red X Circle |
Deleted - soft-deleted record |
No click action (use bulk operations to recover) |
Bulk Operations
The system supports bulk operations on multiple selected ad spaces. These operations appear as buttons above the data table based on the current view mode.
Active View Bulk Operations
When viewing active ad spaces, the following bulk operation is available:
- Select Records: Check the boxes next to ad spaces you want to delete
- Click Delete Selected: Red "Delete Selected" button appears above the table
- Confirm Action: System prompts "Soft-delete selected ad spaces?"
- Processing: Selected records are marked as "Deleted" (soft delete)
- Result: Page redirects to show deleted records view
Deleted View Bulk Operations
When viewing deleted ad spaces, two bulk operations are available:
| Operation |
Button |
Action |
Confirmation |
| Un-Delete |
â?» Un-Delete Selected |
Restores selected records to Active status |
"Un-delete selected ad spaces?" |
| Hard Delete |
ð??? Permanently Delete |
Permanently removes records from database |
"PERMANENTLY delete selected ad spaces? This cannot be undone!" |
Bulk Operation Tips
Select All: Use the header checkbox to select all visible records on the current page. Cross-Page Selection: DataTables remembers selections across pages - you can select items on page 1, navigate to page 2, select more items, then perform bulk operations on all selected items. Hard Delete Safety: Hard delete only works on already-deleted records to prevent accidental permanent deletion.
Data Table Features
The ad space listing uses DataTables for enhanced functionality:
Search and Filtering
- Global Search: Search box in top-right searches across all visible columns
- Real-time Results: Search results update as you type
- Multi-column Search: Search terms can match content in any searchable column
- Case Insensitive: Search is not case-sensitive
Sorting Capabilities
- Column Sorting: Click any column header to sort (except checkbox, actions, and status columns)
- Multi-level Sorting: Hold Shift and click additional columns for secondary sorting
- Default Sort: Table loads sorted by ID in descending order (newest first)
- Sort Indicators: Arrows show current sort direction
| Control |
Options |
Default |
| Records per Page |
25, 50, 100, All |
25 records |
| Navigation |
Previous, Next, numbered pages |
Page 1 |
| State Saving |
Remembers page, sorting, search |
Enabled |
Status Management Workflow
Ad spaces can exist in three primary states, each with specific behaviors and available actions:
Active Status
- Visibility: Ad space is live and available for ad placement
- Display: Shows in default table view with green check circle icon
- Available Actions: Edit, View, Subscribers, Deactivate, Soft Delete
- Quick Toggle: Click green check icon to instantly deactivate
Inactive Status
- Visibility: Ad space is paused but not deleted
- Display: Shows in default table view with gray dash circle icon
- Available Actions: Edit, View, Subscribers, Activate, Soft Delete
- Quick Toggle: Click gray dash icon to instantly activate
Deleted Status (Soft Delete)
- Visibility: Hidden from default view; only visible in "UnDelete" mode
- Display: Shows red X circle icon when viewing deleted records
- Available Actions: Un-delete (restore to Active), Hard Delete (permanent removal)
- Recovery: Can be restored to Active status through bulk operations
Delete Workflows
Soft Delete Process
Soft deletion marks records as deleted without removing them from the database:
- Select Records: Check boxes next to ad spaces to delete
- Click Delete: Red "Delete Selected" button or individual delete action
- Confirmation: System prompts for confirmation
- Processing: Records marked with GlobalAdSpace_Status = 'Deleted'
- Redirect: Page automatically switches to deleted view
- Result: Records hidden from normal operations but recoverable
Recovery Process
Deleted ad spaces can be restored to active status:
- Access Deleted View: Click "UnDelete" button in toolbar
- Select Records: Check boxes next to ad spaces to recover
- Click Un-Delete: Green "Un-Delete Selected" button
- Confirmation: System prompts "Un-delete selected ad spaces?"
- Processing: Records restored to GlobalAdSpace_Status = 'Active'
- Result: Records reappear in main ad space listing
Hard Delete Process
Hard deletion permanently removes records from the database:
- Prerequisites: Records must already be soft-deleted
- Access: Only available in deleted view mode
- Select Records: Check boxes next to soft-deleted ad spaces
- Click Hard Delete: Red "Permanently Delete" button
- Strong Confirmation: System shows warning about permanent deletion
- Processing: Records completely removed from database
- Result: No recovery possible - data is permanently lost
Deletion Safety Tips
Soft Delete First: Always use soft delete initially to maintain recovery options. Review Before Hard Delete: Double-check that ad spaces are no longer needed before permanent deletion. Check Dependencies: Consider if ads, subscribers, or reports depend on these ad spaces. Backup Considerations: Hard-deleted records may not be recoverable even from backups depending on timing.
Record Count and Status
The card header displays important information about the current data set:
| Element |
Description |
Example |
| Record Count |
Total number of records in current view |
"47 records" or "1 record" |
| Deleted Badge |
Red badge appears when viewing deleted records |
Showing Deleted |
Site Filtering Behavior
The system automatically filters ad spaces based on user permissions and site access:
Super Admin Access (Client ID = 1)
- Full Access: Can view and manage ad spaces for all websites
- No Filtering: Query runs without site restrictions
- Cross-Site Management: Can create ad spaces for any domain
Regular User Access
- Site Restricted: Can only see ad spaces for their assigned website
- Domain Filtering: Query filters by current server domain (www. prefix removed)
- Isolated Management: Cannot access or modify ad spaces from other sites
Permission Enforcement
- Permission Check: System verifies "Users" permission exists
- Access Denied: Users without proper permissions redirected to denied page
- Workgroup Assignment: User's workgroup determines available features
- Site Association: Server domain determines which ad spaces are visible
Technical Specifications
Database Operations
| Operation |
Table |
Action |
| Soft Delete |
Global_AdSpace |
UPDATE GlobalAdSpace_Status = 'Deleted' |
| Activate |
Global_AdSpace |
UPDATE GlobalAdSpace_Status = 'Active' |
| Deactivate |
Global_AdSpace |
UPDATE GlobalAdSpace_Status = 'Inactive' |
| Hard Delete |
Global_AdSpace |
DELETE FROM (only if already Deleted) |
Data Sources
- Primary Query: Global_Webstore datasource
- Permission Check: Default DSN for Sponsors table
- Query of Query: Post-filtering for Active vs Deleted records
Summary
The Global AdSpace Management page provides comprehensive tools for managing advertising spaces across your websites. Key features include bulk operations for efficient management, soft delete with recovery options for data safety, site-based filtering for multi-tenant environments, real-time status changes through clickable icons, and integrated subscriber management. The system supports both individual and bulk operations, maintains data integrity through soft deletes, and provides detailed tracking of ad space dimensions, pricing, and membership restrictions. Regular users see only their site's ad spaces while super admins have cross-site access for enterprise management.
