Campaign Sheet & Google Sheets file
Here you'll learn some Mergo best practices to manage and maintain your campaign sheets.
In this article
Can I use multiple campaign sheets in a single Google Sheets file?
The ideal setup would be 1 campaign sheet (sheet or tab) for 1 Google Sheets file. But you can use multiple sheets or tabs in a single Google Sheets file as well (like in our example below).
If you're going to use multiple sheets, you need to Refresh the Mergo sidebar each time you run a campaign on another sheet/tab. This ensures that Mergo is referencing the correct campaign sheet (datasource). To do this, just click the relevant sheet/tab > More actions > Refresh.
Note: By default, Mergo will always reference the 1st sheet/tab of a Google Sheets file as the datasource when the file is first opened. This is why it's important to Refresh the Mergo sidebar each time you move to a different sheet/tab.
Caution: Do not hide a sheet/tab in your Google Sheets file. This may disrupt Mergo's ability to reference the correct datasource and fields (header labels).
Will my campaign keep running if I delete my Sheets?
Your campaign will continue to run only if you removed it (put the campaign sheet file in Google Drive's Trash). But your campaign will stop running when:
- Campaign sheets that have been in your Drive's Trash for more than 30 days are automatically & permanently deleted by Google.
- You click the Empty trash button
💡 Tip: If you only need to stop an ongoing campaign, click the Abort button.
Note: If you've only removed the campaign sheet, you can restore it from the Trash. Then open Mergo > click Campaign Tracking Report > Abort to stop the campaign.
Can I set several scheduled campaigns from the same spreadsheet?
Yes, you can. You can set up several campaigns per sheet! You can learn more about this here