Advertising Made Simple
Find advertising for your business
Tell us about your business, goals and budget to get local advertising recommendations.
Dashboard
Sign in to Adhelpa
Sign in to find advertising opportunities and manage your campaigns.
Account role: Sign in to verify
Connection settings (if needed)
Connection is already configured. Customers only need an email address and password. These public settings are read-only; never use a secret or service_role key.
Not connected. Demo mode only.
For security, use a trusted device. Your password is not stored in local storage. Sessions remain protected and may expire; sign in again if asked.
Forgot your password?
Create a business account
Register your business
Create a free account to explore local advertising and manage your enquiries. If you already have an account, use Sign in above.
Advanced maintenance (administrator use)
Archive old test campaigns
One-time clean-up. Back up the existing 16 campaigns and their linked results, mark them as tests in Supabase, and hide them from normal lists. Nothing is deleted. This is an administrator maintenance action, not a normal customer feature.
Not archived yet. Sign in first.
Live opportunities
Read-only results from the live_advertising_opportunities database view. Pricing is not assumed to be verified.
Other dashboard settings
Example advertising settings
Preview only. Your saved campaign settings are managed in Campaigns.
Demo settings only. No changes are sent to Supabase.
Prices still need provider confirmation.
🏢 Business Profile
Set up your business once. Adhelpa remembers your details for your next visit. Returning customers can update their saved profile here.
Sign in to load your business profile from Supabase.
For advertising publishers
Submit your advertising opportunity for review. New submissions are private; prices and audience figures require verification.
Existing publisher? Use Sign in / Account. New publisher? Create an account below.
Complete the publisher details, describe your advertising and select Submit for review. Your listing stays private until an administrator separately approves and publishes it.
View my existing submissions ↓Create publisher account
For newspapers, magazines, websites, radio stations and other advertising providers. Registration does not give administrator permissions or publish any listings.
My submissions
Check the status of listings you have submitted. Only pending listings can be edited; approval and publication are separate administrator decisions.
Refresh to load submissions.
Select Edit to update a pending listing.
Sign in to view your submitted opportunities.
Advertising opportunities
Illustrative categories based on the Supabase project. Provider rates and reach are not verified here.
Euro Weekly News has been added as a research candidate in Recommendations; pricing is still to be confirmed.
Administrator-published listings
New genuine listings published by Adhelpa administrators. Publisher prices are not independently verified.
Advertising recommendations
Budget: €250/month
These are research candidates, not confirmed affordable bookings. We will calculate genuine fit and confidence separately after importing verified data.
Euro Weekly News
Print & Publications · Costa Blanca North · English-language local newspaper
Potential advertising for local homeowners, residents and businesses. Print and digital options may be available.
Price: Quote required · Audience, circulation and coverage need confirmation.
Research candidate — not yet a verified Supabase advertising product or a scored recommendation. Ask for the current Costa Blanca North media pack and rate card.
♡ Compare & Shortlist
Compare saved advertising against your campaign. Only verified known prices count toward the budget; quote-required or unverified prices stay separate.
Need a price? Tap Request a quote beside the saved advert. This prepares a message for you to review; nothing is sent automatically. You can save the enquiry afterward. Moving a shortlist into Campaigns does not book advertising.
Campaigns
Set up a campaign below, or jump straight to your saved campaigns.
View saved campaigns🎯 Campaign Settings
Set the goal, audience and budget that will guide future recommendations. Your campaign budget, objective, audience, location and duration are saved as a draft in Supabase after sign-in.
Sign in to load your saved campaign draft.
Current campaign brief (optional)
Budget suitability is not confirmed until providers supply verified prices. These settings do not automatically verify provider prices or recommendation scores.
Campaign planner
Budget carried from Campaign Setup above. Planned spend is the sum of known advertising allocations, not the budget.
Selected advertising
Save this campaign and its selected advertising to Supabase after signing in.
Saved campaign lifecycle
Load a real saved campaign and move it from Planned to Active to Completed. Completed campaigns can then be measured in Results.
Campaigns with the same name are kept separate; their dates and unique IDs distinguish them.
Manage supplier quotations
Record prices once received, or save notes while waiting. Leave the price blank if no quote has arrived. Quotes never change actual spend.
Quotation details are saved to Supabase when you press Save, with a backup on this device. Quoted prices do not change actual spend.
Enter campaign results
Record what actually happened after your advertising ran. Choose a completed campaign, enter confirmed figures for each advert, then save. Your totals are calculated automatically.
In this mode you can select an existing TEST campaign. Save creates a separate TEST copy and leaves the source campaign and production learning metrics unchanged.
Budget is not spending. Enter only actual confirmed costs; while awaiting a quotation, spending remains €0.
Review campaign performance
See the results you have saved and compare how advertising performed. These reports are read-only; enter or change figures in Results. TEST campaigns are hidden unless you choose to show them.
Advanced tools — testing and database maintenance
For technical maintenance only. Normal campaign reporting is above.
Test data protection — V43.20
If a campaign contains fictional results, mark it as TEST in Supabase. Its results are preserved, but it will be excluded from normal performance comparisons and future production learning updates.
No changes are made until you confirm.
Clean learning metrics — V43.21
Preview which products have results from TEST campaigns. Recalculate their learning totals using genuine campaigns only. No campaigns or results are deleted.
Important: marking a campaign TEST does not automatically undo learning metrics calculated from earlier saves. Those need a separate controlled recalculation.
V43.29 — Database integrity audit
Read-only check for duplicate result rows, orphaned advertising records, TEST campaign classification, and differences between campaign totals and advert-level attribution. No database changes are made.
Sign in before running the audit.
V43.29 — Controlled TEST repair
Preview the exact campaign IDs before marking the two confirmed fictional campaigns as TEST. Existing results are retained. No duplicate rows are deleted or merged.
No changes made.
Duplicate result investigation
Inspect all campaigns named M-Power advertising Test 1, their unique IDs, and each set of result rows. Read-only: no edits or deletions.
V43.30 — Campaign ID Visibility
Saving is locked while a request is running. If a campaign already has multiple result rows, saving is blocked rather than silently choosing one. Historical duplicates remain unchanged. This is not a database-wide uniqueness constraint.
For the previously confirmed fictional M-Power Advertising Test 1 results, use Inspect matching campaigns above to review the five rows. Do not delete or merge them automatically.
Sign in to load performance.
Controlled publishing — Admin only
Only genuine approved listings can be published. TEST listings remain blocked.
Sign in to check access.
Publisher approvals — Admin only
Review pending advertising. Approval keeps a listing private; publication is a separate administrator action.
Checking administrator access…