Merge Lists takes multiple separate lists and combines them into one unified list. Essential for consolidating data from different sources, combining campaign results, or preparing merged datasets for processing.


When to Use It

  • Combine campaign lists from different advertising platforms
  • Merge client data from multiple spreadsheets
  • Consolidate URL lists from various sources
  • Unify keyword lists before processing

Inputs

FieldTypeRequiredDescription
Lists to MergeMultiple ListsYesAdd multiple lists that you want to combine into one

Outputs

OutputDescription
Merged ListSingle list containing all items from the input lists

Credit Cost

Free to use - no credits required.


How It Works

Takes multiple lists and combines them in the order you provide them:

Example:

List 1: ["Campaign A", "Campaign B"]
List 2: ["Campaign C", "Campaign D"] 
List 3: ["Campaign E"]
Merged Result: ["Campaign A", "Campaign B", "Campaign C", "Campaign D", "Campaign E"]

Items are added in sequence - first all items from List 1, then all from List 2, and so on.


Real-World Examples

Unified Cross-Platform Reporting:

Google Ads Get Report (campaign performance data) → List 1
Meta Ads Get Report (campaign performance data) → List 2
LinkedIn Ads Get Report (campaign performance data) → List 3
→ Merge Lists → Write to Sheets
"Create one master report with all platform data in a single table"

Best Practices

Order Matters:

  • Lists are merged in the order you add them
  • First list items appear first in the merged result
  • Consider priority when arranging your lists

Data Consistency:

  • Ensure all lists contain similar types of data
  • Mixed data types work but may complicate later processing
  • Consider standardizing formats before merging

Post-Merge Processing:

  • Often useful to use Remove Duplicates after merging
  • Count List Items to verify expected total
  • Consider splitting large merged lists for processing

FAQ