1. Query GAQL cơ bản
Top 10 campaign by conversions:
- SELECT campaign.name, metrics.conversions, metrics.cost_micros
- FROM campaign
- WHERE segments.date DURING LAST_30_DAYS
- ORDER BY metrics.conversions DESC LIMIT 10
Search term có CTR cao: SELECT search_term_view.search_term, metrics.clicks, metrics.ctr FROM search_term_view WHERE metrics.clicks > 50 AND metrics.ctr > 0.05.
2. 5 use case API cho agency VN
- Dynamic Budget: auto-adjust budget theo performance hàng ngày.
- Bid Adjustment Time-of-Day: bid +30% giờ peak 10-12am, -20% giờ low 2-4am.
- Reporting → BigQuery: pull data hàng ngày vào BigQuery cho long-term analysis.
- Custom Audience Sync: sync CRM Salesforce → Customer Match hàng giờ.
- Anomaly Detection ML: train model phát hiện anomaly bằng past 90 ngày data.
3. Quota management cho agency
- Basic tier: 15K operation/ngày — đủ cho 5-10 client.
- Standard tier: 80K operation/ngày — đủ cho 20-50 client.
- Apply Standard sau 6 tháng dùng Basic tốt.
- Batch operation: combine 100-500 mutate vào 1 request.
- Cache report đã pull để không pull lại trong 1h.
