Search Term → Content Strategy

import os, requests
from google.ads.googleads.client import GoogleAdsClient

MV = os.environ["MAVERA_API_KEY"]
CUSTOMER_ID = os.environ["GOOGLE_ADS_CUSTOMER_ID"]

client = GoogleAdsClient.load_from_env()
ga_service = client.get_service("GoogleAdsService")

query = """
    SELECT
        search_term_view.search_term,
        metrics.impressions,
        metrics.clicks,
        metrics.conversions,
        metrics.cost_micros
    FROM search_term_view
    WHERE segments.date DURING LAST_30_DAYS
        AND metrics.impressions > 10
    ORDER BY metrics.impressions DESC
    LIMIT 100
"""

response = ga_service.search(customer_id=CUSTOMER_ID, query=query)

terms = []
for row in response:
    stv = row.search_term_view
    m = row.metrics
    terms.append({
        "term": stv.search_term,
        "impressions": m.impressions,
        "clicks": m.clicks,
        "conversions": m.conversions,
        "cost": m.cost_micros / 1_000_000,
    })

term_block = "\n".join(
    f"- \"{t['term']}\" (imp: {t['impressions']}, clicks: {t['clicks']}, conv: {t['conversions']:.0f}, cost: ${t['cost']:.2f})"
    for t in terms
)

mave = requests.post(
    "https://app.mavera.io/api/v1/mave/chat",
    headers={"Authorization": f"Bearer {MV}", "Content-Type": "application/json"},
    json={"message": f"""Cluster these {len(terms)} Google Ads search terms by user intent.

For each cluster:
1. Cluster name and intent type (informational, navigational, commercial, transactional)
2. Representative terms
3. Total impressions and conversions for the cluster
4. Recommended content type (blog post, landing page, comparison guide, tutorial, etc.)
5. Suggested title and angle

Prioritize clusters by conversion potential.

SEARCH TERMS:
{term_block}"""},
).json()

print("--- Search Term Content Strategy ---")
print(mave.get("content", "")[:3000])
print(f"\nSources: {len(mave.get('sources', []))}")

const DEV_TOKEN = process.env.GOOGLE_ADS_DEVELOPER_TOKEN;
const ACCESS_TOKEN = process.env.GOOGLE_ADS_ACCESS_TOKEN;
const CUSTOMER_ID = process.env.GOOGLE_ADS_CUSTOMER_ID;
const MV = process.env.MAVERA_API_KEY;

const gaql = `
  SELECT
    search_term_view.search_term,
    metrics.impressions,
    metrics.clicks,
    metrics.conversions,
    metrics.cost_micros
  FROM search_term_view
  WHERE segments.date DURING LAST_30_DAYS
    AND metrics.impressions > 10
  ORDER BY metrics.impressions DESC
  LIMIT 100`;

const gaRes = await fetch(
  `https://googleads.googleapis.com/v23/customers/${CUSTOMER_ID}/googleAds:searchStream`,
  {
    method: "POST",
    headers: {
      Authorization: `Bearer ${ACCESS_TOKEN}`,
      "developer-token": DEV_TOKEN,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({ query: gaql }),
  }
).then((r) => r.json());

const terms = (gaRes[0]?.results || []).map((row) => ({
  term: row.searchTermView.searchTerm,
  impressions: parseInt(row.metrics.impressions),
  clicks: parseInt(row.metrics.clicks),
  conversions: parseFloat(row.metrics.conversions),
  cost: parseInt(row.metrics.costMicros) / 1_000_000,
}));

const termBlock = terms
  .map((t) => `- "${t.term}" (imp: ${t.impressions}, clicks: ${t.clicks}, conv: ${t.conversions.toFixed(0)}, cost: $${t.cost.toFixed(2)})`)
  .join("\n");

const mave = await fetch("https://app.mavera.io/api/v1/mave/chat", {
  method: "POST",
  headers: { Authorization: `Bearer ${MV}`, "Content-Type": "application/json" },
  body: JSON.stringify({
    message: `Cluster these ${terms.length} Google Ads search terms by user intent.\n\nFor each cluster:\n1. Cluster name and intent type\n2. Representative terms\n3. Total impressions and conversions\n4. Recommended content type\n5. Suggested title and angle\n\nSEARCH TERMS:\n${termBlock}`,
  }),
}).then((r) => r.json());

console.log("--- Search Term Content Strategy ---");
console.log((mave.content || "").slice(0, 3000));
console.log(`\nSources: ${(mave.sources || []).length}`);