Run GAQL Query

​

When to Use It

• Data isn’t available in Get Report: You need specific fields, resources, or data combinations not supported by the standard reporting node
• Advanced filtering requirements: You need complex WHERE clauses or JOIN operations beyond basic filters
• Custom data relationships: You want to fetch data from multiple Google Ads resources in a single query
• Specific API resources: You need access to account structure, extensions, keywords, ads, or other non-reporting resources
• Expert-level control: You’re comfortable with GAQL syntax and want full control over your data queries

​

What is GAQL?

• Direct API access: Query any resource available in the Google Ads API
• Flexible data selection: Choose exactly which fields you want to retrieve
• Advanced filtering: Use complex WHERE conditions with multiple operators
• Resource relationships: Access related data across different Google Ads entities
• Performance optimization: Write efficient queries for large datasets

​

Inputs

​

Query Builder Tool (Recommended)

• Generate queries visually: Select resources and fields through a user interface - no coding required
• Validate syntax: Ensures your queries are properly formatted
• Discover available fields: Browse all available resources and their fields
• Test queries: Verify your queries before using them in workflows
• Learn GAQL: See how your selections translate to GAQL syntax

1. Visit the Query Builder link above
2. Select your resource (e.g., “campaign”, “ad_group”, “keyword_view”)
3. Choose the fields you want to retrieve
4. Add any filters or conditions
5. Copy the generated query and paste it into this node

SELECT campaign_id, campaign_name, campaign_status 
FROM campaign 
WHERE campaign_status != 'REMOVED'

SELECT ad_group_criterion_keyword_text, 
       ad_group_criterion_quality_info_quality_score,
       campaign_name
FROM keyword_view 
WHERE ad_group_criterion_quality_info_quality_score > 5

​

Output

• AI Analyze Data for insights and analysis
• Google Sheets for detailed data export
• Data transformation nodes for further processing
• Email or Slack for reporting

​

Credit Cost

• Cost per run: 1 credit (per successful execution)

​

Example Setup

Scheduler (Daily 6 AM) →
Run GAQL Query →
AI Analyze Data →
Google Sheets →
Email Summary

​

FAQs