Remove Fields

Remove Fields eliminates unnecessary columns/fields from your data to reduce clutter, improve performance, and focus on relevant information. Choose specific fields to remove or keep only the fields you need.

​

When to Use It

• Clean up datasets with too many unnecessary columns
• Remove sensitive data before sharing reports
• Prepare data for systems with field limitations
• Reduce data size for better performance
• Focus on specific metrics for analysis

​

Inputs

​

Outputs

​

Credit Cost

Free to use - no credits required.

​

How It Works

Remove Specific Fields Mode: Removes only the fields you specify, keeps everything else.

Keep Only Specific Fields Mode: Keeps only the fields you specify, removes everything else.

Example:

Clean Client Reports:

Google Ads Get Report → Remove Fields → Write to Sheets
Remove: ["campaign.id", "ad_group.id", "customer.id", "segments.date"]
Keep: Campaign performance metrics only
"Remove technical IDs and internal data before sending to client"

​

Choosing the Right Mode

Use “Remove Specific Fields” when:

• You have mostly useful data with a few unwanted fields
• You want to remove sensitive or technical fields
• Most of your columns should stay in the final dataset

Use “Keep Only Specific Fields” when:

• You have lots of data but only need a few specific fields
• You want to create a focused, minimal dataset
• You’re dealing with very wide datasets with many unnecessary columns

​

Tips

Field Identification:

• Run a small test first to see what fields are available
• Check field names carefully - they’re case-sensitive
• Use data preview to understand your dataset structure

Mode Selection:

• If you need most fields, use “Remove Specific Fields”
• If you need only a few fields, use “Keep Only Specific Fields”
• Keep mode is often faster for very wide datasets

Data Quality:

• Remove fields with mostly empty or null values
• Eliminate duplicate or redundant information
• Keep fields that provide unique, valuable insights

​

FAQ