Purpose
Ascent Marketing is developing a Google Sheets-based workflow to support internal research for products promoted through affiliate offers. The purpose is to organize product and keyword-planning reference data before an authorized team member decides whether or how to advertise.
How the workflow operates
- An authorized internal user enters an Amazon ASIN and country code into a private Google Sheet.
- A separate, authorized affiliate-offer data source supplies relevant product and offer reference information.
- The workflow derives a concise keyword seed from the product name or model, or uses a search term entered by the user.
- The tool calls KeywordPlanIdeaService.GenerateKeywordIdeas for the selected geography, language, and Google Search network.
- Keyword ideas and aggregated historical planning metrics are written back to the private Sheet for human review.
Google Ads API data used
Keyword ideas
Suggested keyword text relevant to the submitted seed.
Search demand
Average monthly search metrics supplied for planning.
Competition
Keyword competition indicators supplied by the planning service.
Bid ranges
Historical low and high top-of-page bid range metrics.
What the tool does not do
- It does not automatically create, enable, pause, or modify campaigns.
- It does not create or edit ads, ad groups, keywords, bids, or budgets.
- It does not create audiences, conversions, or remarketing lists.
- It does not use App Conversion Tracking or Remarketing APIs.
- It does not upload Customer Match data or personally identifiable end-user data.
- It does not sell, redistribute, or expose Google Ads API data through a public API or downloadable commercial dataset.
Users and access controls
Access is limited to authorized Ascent Marketing employees and contractors. Users must already have access to the relevant private Google Sheet and Google Ads account. The tool is not made available to the general public or external clients.
Authentication and credential security
The Sheet-bound Apps Script runs under an authorized internal Google user using OAuth 2.0 and the Google Ads scope. The developer token and related credentials are stored in Apps Script Properties, not in visible spreadsheet cells or publicly accessible source code. Administrative access is restricted.
Storage, logging, and retention
The workflow stores product identifiers and aggregated keyword-planning metrics in a private Google Sheet protected by Google account and Drive permissions. Operational logs may include timestamps, request status, and non-sensitive error details. Data is retained only as needed for internal research and can be removed by an authorized administrator.
Human oversight
The workflow is a research aid. Internal users remain responsible for keyword selection and every campaign decision. If the scope changes to include external access, campaign management, conversion tracking, remarketing, or new data uses, Ascent Marketing will review the change and update its disclosures and API access information before deployment.
Questions
For questions about this tool or its data practices, contact admin@ascentmarketing.io.