> ## Documentation Index
> Fetch the complete documentation index at: https://docs.markifact.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Get Report
> Fetch Snapchat Ads data based on specified metrics and dimensions
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:
1. **IN\_LIST operator**: `Placement IN ["Snapchat", "Audience_Network", "Discover"]`
2. **REGEXP\_MATCH operator**: `Campaign name REGEXP_MATCH ".*(video|viral|story).*"`
3. **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:**
```json theme={"dark"}
[
{
"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
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.
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.
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
**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.
**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
**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:**
1. **Daily Performance Dashboard**: Snapchat data → Google Sheets → Slack notification
2. **Weekly Optimization Report**: Multi-platform data → Analysis → Optimization recommendations
3. **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