wsjc
Active Member
- Joined
- Feb 2, 2024
- Messages
- 68
It seems there are already many related automation tutorials, such as those for Google Sheets, but Iām not very familiar with or have used Google Sheets. Iād like to share a solution that I find very convenient. When you want to test an offer with a budget of less than $10, I hope this can be helpful to you.
The main feature of this solution is that when setting the PropellerAds campaign name, you can add [PROFIT=-XX][ROI=-50]after the name to specify the campaignās stopping condition. When ROI is less than specified value and profit is lower than specified value, the campaign will automatically stop. PROFIT and ROI is calculated based on the current dayās data. For example, the name can be set like this:
When the profit loss exceeds $2.5, the campaign will automatically stop. Otherwise, the campaign will continue to run until the budget is exhausted.
When the profit loss exceeds $8 and the ROI is less than -60%, the campaign will automatically stop. Otherwise, the campaign will continue to run until the budget is exhausted.
Advantages:
The main feature of this solution is that when setting the PropellerAds campaign name, you can add [PROFIT=-XX][ROI=-50]after the name to specify the campaignās stopping condition. When ROI is less than specified value and profit is lower than specified value, the campaign will automatically stop. PROFIT and ROI is calculated based on the current dayās data. For example, the name can be set like this:
When the profit loss exceeds $2.5, the campaign will automatically stop. Otherwise, the campaign will continue to run until the budget is exhausted.
When the profit loss exceeds $8 and the ROI is less than -60%, the campaign will automatically stop. Otherwise, the campaign will continue to run until the budget is exhausted.
Advantages:
- Once the program is running, thereās no need to reopen your server again.
