Создание PDF-отчётов о воронке спроса для локального бизнеса в Google Ads на основе Keyword Planner

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.