Kütüphane / Raporlar, Analitik ve Panolar
Raporlar, Analitik ve Panolar
Keyword Planner verilerinden yerel Google Ads talep hunisi PDF raporları oluştur
Koordinatlar çevresinde sürüş süresine göre bir ticari alan oluşturan, posta koduna göre Keyword Planner arama hacimlerini ve tekliflerini çeken ve yerel bir işletme için PDF talep hunisi raporu dışa aktaran manuel çalıştırma.
Ne yapar
Estimate monthly customer demand for a local business from Google Keyword Planner data, and export a PDF funnel report for a drive-time trade area. ### Who's it for Marketers, freelancers and operators of co-working, storage or office-rental sites who need local search demand modelling. ### How it works 1. Turns your coordinates into a drive-time polygon (OpenRouteService). 2. Samples points inside it, finds the ZIP codes (Nominatim) and maps them to Google Ads geo targets. 3. Pulls average monthly searches and bid ranges from Keyword Planner. 4. Models one funnel per category at a low and a high price: searches, impressions, clicks, landing page views, actions, customers, ad spend and revenue. 5. Renders a boundary map and funnel charts into a PDF (PDFShift). Google's API targets locations, not custom radii, so the trade area is approximated by ZIP codes. ### Setup 1. Create credentials: Google Ads account (OAuth2), OpenRouteService key (header Authorization), Geoapify key (query apiKey) and PDFShift key (header X-API-Key). 2. Get a Google Ads developer token (Basic access or higher) from the API Center in your manager account. 3. Open Set Configuration and enter the developer token, coordinates, customer ID and categories. 4. Run the workflow. Set pdfSandbox to false for clean PDFs. Security: the developer token lives in Set Configuration. Remove it before sharing or exporting this workflow. ### Customization Edit keywords, prices, CTR, action and close rates in categories. Funnel rates are assumptions, not Google data.
Adımlar
- Start Analysis Manually
- Set Configuration
- Get Drive-Time Polygon
- Sample Points In Polygon
- Reverse Geocode To ZIP
- Collect Unique ZIPs
- Find Google Ads Geo Targets
- Build Geo Target Set
- Get Keyword Search Volume
- Calculate Funnel Model
- Download Boundary Map
- Build HTML Report
- Convert HTML To PDF
Benzer otomasyonlar
İçerik Yazımı ve ÜretimiOpenAI ve Gemini ile Drive'dan Meta Video ve Görsel Reklamları Oluşturma49 adımSosyal Medya YayıncılığıSheets'ten Meta'ya Video ve Görsel Reklamları Yükleme34 adımMCP Sunucuları ve AraçlarıGoogle Ads Kampanyaları MCP Sunucusu Olarak3 adımE-posta OtomasyonuLog Meta lead ads to Google Sheets with Slack alerts and repeat checks8 adım