Get Report

The Get Report node lets you fetch Snapchat Ads performance data across one or more accounts using specified metrics, dimensions, and filters. This is an AI-powered node that can understand natural language instructions.

When to Use It

Use this node to:

Generate automated performance reports and dashboards
Track campaign metrics and KPIs over time
Create data-driven insights for optimization decisions
Export data for further analysis in external tools
Monitor ad performance across multiple Snapchat Ads accounts
Build comprehensive reporting workflows

Inputs

Field	Type	Required	Description
Accounts	Dynamic multi-select	Yes	Select one or more Snapchat Ads accounts to query
Date Range	Date range picker	Yes	Select date range for the report
Metrics	Multi-select	Yes	Select metrics to include in the report
Dimensions	Multi-select	No	Select dimensions to segment your data
Filters	Rule-based filters	No	Add filters to refine your data
Order By	Sort configuration	No	Set the order of results
Limit	Number	No	Maximum number of rows to return
Options	Report options	No	Additional options for the report

Filters

Filters allow you to refine your data by applying conditions to specific dimensions or metrics. Multiple filters use AND logic - all conditions must be met for a row to be included in the results.

Available Filter Operators

Operator	Description	Example Use Case
EQUALS	Exact match	Campaign name equals “Summer Sale 2024”
NOT_EQUALS	Does not match exactly	Campaign status not equals “PAUSED”
CONTAINS	Contains substring	Campaign name contains “2024”
NOT_CONTAINS	Does not contain substring	Campaign name doesn’t contain “test”
IN_LIST	Matches any value in list	Placement in [“Snapchat”, “Audience Network”]
NOT_IN_LIST	Doesn’t match any value in list	Device not in [“DESKTOP”]
REGEXP_MATCH	Matches regular expression	Campaign name matches ”.(viral\|trending).”
NOT_REGEXP_MATCH	Doesn’t match regex	Campaign name doesn’t match “test.*“
GREATER_THAN	Numeric greater than	Spend > 100
LESS_THAN	Numeric less than	CPC < 1.50
IS_NULL	Field has no value	Conversion value is null
IS_NOT_NULL	Field has a value	Conversion value is not null

Filter Examples

Example 1: High-performing active campaigns

- Spend > 50 (GREATER_THAN)
- Campaign status = "ACTIVE" (EQUALS)
- Impressions > 10000 (GREATER_THAN)

Example 2: Video content campaigns using regex (OR logic)

- Campaign name matches ".*(video|viral|story).*" (REGEXP_MATCH)

Example 3: Exclude test campaigns

- Campaign name does not contain "test" (NOT_CONTAINS)
- Campaign name does not contain "draft" (NOT_CONTAINS)

OR Logic with Filters

Since multiple filters use AND logic, use these approaches for OR conditions:

IN_LIST operator: Placement IN ["Snapchat", "Audience_Network", "Discover"]
REGEXP_MATCH operator: Campaign name REGEXP_MATCH ".*(video|viral|story).*"
Run separate queries: Create different workflows for different conditions

Options Reference

These optional settings let you format the output from Snapchat Ads before passing it to other nodes.

Option	Description
Pretty Column Names	Converts column headers to Title Case (e.g. `campaignName` becomes `Campaign Name`)
Add Percent Sign to Ratios	Appends `%` to ratio metrics like CTR or Engagement Rate
Display Currency Symbol	Adds `$` or local currency symbol to monetary metrics
Compact Numbers	Converts large numbers to short format (e.g. `10K` instead of `10,000`)
Pivot Dimensions as Columns	Transforms dimension values into separate columns for easier comparison

Output

The node returns a structured dataset with performance metrics and dimensions. The exact format depends on your configuration and the data returned from Snapchat Ads. Typical Output Structure:

Data Rows: Performance metrics and dimensions
Column Headers: Names of metrics and dimensions
Data Types: Consistent formatting based on your options

Example Output:

[
  {
    "Campaign Name": "Summer Collection 2024",
    "Impressions": "15,420",
    "Clicks": "1,234",
    "CTR": "8.00%",
    "Spend": "$456.78",
    "Date": "2024-10-15"
  }
]

Credit Cost

Cost per run: 1 credit

FAQs

What metrics are available in Snapchat Ads reporting?

Snapchat Ads provides comprehensive metrics across different levels:Performance Metrics:

Impressions: Number of times ads were displayed
Clicks: Number of clicks on your ads
CTR (Click-Through Rate): Percentage of impressions that resulted in clicks
Spend: Total amount spent on advertising
CPM: Cost per thousand impressions
CPC: Cost per click

Engagement Metrics:

Video Views: Number of video ad views
Story Opens: Number of times Story ads were opened
Swipe Ups: Number of swipe up actions on ads
Screen Time: Time users spent viewing your content

Conversion Metrics:

Conversions: Number of conversion events
Conversion Rate: Percentage of clicks that resulted in conversions
Cost per Conversion: Average cost for each conversion
ROAS: Return on ad spend

Use the field browser in the node to see all available metrics for your account.

How do I segment my data with dimensions?

Dimensions allow you to break down your metrics by different attributes:Campaign Structure:

Campaign: View performance by campaign
Ad Set: Analyze ad set level performance
Ad: Get individual ad performance
Creative: Break down by creative assets

Audience & Targeting:

Age: Performance by age groups
Gender: Male vs female performance
Location: Geographic performance breakdown
Device: Mobile vs desktop performance

Placement & Format:

Placement: Snapchat vs Audience Network
Ad Format: Video, image, collection ad performance
Position: Story vs Discover placement

Time-based:

Date: Daily performance breakdown
Hour: Hourly performance patterns
Day of Week: Performance by day patterns

Example: Select “Campaign” and “Date” dimensions to see daily performance for each campaign.

How do I query multiple accounts efficiently?

The Snapchat Ads Get Report node is optimized for multi-account reporting:Single Query Approach:

Select multiple accounts in the Accounts field
Run one query to get data from all selected accounts
Data will include an account dimension automatically

Best Practices:

Use account filters: If you need data from specific account types
Group similar accounts: Accounts with similar time zones or business types
Consider data volume: More accounts = more data, may need pagination

Account Management:

Use the Select Accounts node for complex account selection
Filter accounts by name patterns or IDs
Reuse account selections across multiple report nodes

Performance Tips:

Limit date ranges for large account sets
Use appropriate metrics to reduce data volume
Consider breaking very large account sets into smaller batches

What's the best way to filter campaign data?

Common Filtering Strategies:Performance-Based Filtering:

Spend > 50 AND Impressions > 10000

Focus on campaigns with significant activity.Status and Quality Filtering:

Campaign Status = "ACTIVE" AND CTR > 1.0

Show only active, well-performing campaigns.Naming Convention Filtering:

Campaign Name CONTAINS "2024" AND 
Campaign Name NOT_CONTAINS "test"

Focus on current year campaigns, exclude tests.Advanced Regex Filtering:

Campaign Name REGEXP_MATCH ".*(video|story|snap).*"

Include campaigns with specific content types.Time-Sensitive Filtering:

Use date ranges instead of date filters when possible
Filter by spend thresholds to focus on meaningful data
Exclude inactive or paused elements

Pro tip: Start with broader filters and gradually narrow down based on your analysis needs.

How do I handle large datasets and optimize performance?

Data Volume Management:Use Limits Effectively:

Set reasonable limits (1000-10000 rows)
Use sorting to get top performers first
Implement pagination for complete datasets

Optimize Date Ranges:

Use shorter date ranges for detailed analysis
Longer ranges for trend analysis with daily/weekly grouping
Consider account-specific seasonality patterns

Smart Metric Selection:

Choose only metrics you need for analysis
Remove calculated metrics you can compute later
Focus on core KPIs first

Filtering Strategies:

Filter at the source rather than post-processing
Use spend or impression thresholds to exclude low-activity items
Exclude paused or inactive elements

Performance Tips:

Batch processing: Split large requests into smaller chunks
Caching: Save frequently used data configurations
Scheduling: Run large reports during off-peak hours
Incremental updates: Query only new data when possible

Memory Considerations:

Very large datasets may require streaming or chunked processing
Consider aggregating data before detailed analysis
Use compact number formatting to reduce memory usage

Can I automate Snapchat Ads reporting workflows?

Automation Capabilities:Scheduled Reporting:

Set up daily, weekly, or monthly automated reports
Use consistent date ranges (e.g., “last 7 days”)
Combine with email or Slack notifications

Dynamic Account Selection:

Use the Select Accounts node for flexible account management
Filter accounts based on naming conventions or performance
Update account lists automatically as new accounts are added

Cross-Platform Integration:

Combine Snapchat data with other advertising platforms
Export to Google Sheets for collaborative analysis
Send data to BI tools for advanced visualization

Alert Systems:

Set up threshold-based alerts for performance changes
Monitor key metrics automatically
Trigger optimization workflows based on performance

Workflow Examples:

Daily Performance Dashboard: Snapchat data → Google Sheets → Slack notification
Weekly Optimization Report: Multi-platform data → Analysis → Optimization recommendations
Monthly Executive Summary: Aggregated performance → Email report → Stakeholder distribution

Best Practices:

Test automation workflows thoroughly before deployment
Include error handling and fallback scenarios
Document automated processes for team maintenance
Regular review and optimization of automated workflows

Get Started

Guides

Nodes

When to Use It

Inputs

Filters

Available Filter Operators

Filter Examples

OR Logic with Filters

Options Reference

Output

Credit Cost

FAQs

Get Started

Guides

Nodes

​When to Use It

​Inputs

​Filters

​Available Filter Operators

​Filter Examples

​OR Logic with Filters

​Options Reference

​Output

​Credit Cost

​FAQs

When to Use It

Inputs

Filters

Available Filter Operators

Filter Examples

OR Logic with Filters

Options Reference

Output

Credit Cost

FAQs