• Welcome to affLIFT!
    We are happy you have decided to check out our awesome affiliate marketing forum. Register your account today to join our amazing community!
  • Find the best prices and largest volumes across Push, Popunder, and Native Ad Networks. Discover traffic price drops with Traffic Lab's historical data!
    Check out Traffic Lab!

Guide How to use Google Sheets to check Monetizer offer status and start/stop traffic on PropellerAds

Geozo

dood

🚀
Staff Member
Community Leader
Joined
May 2, 2018
Messages
2,871
Are you tired of wasting budget and sending traffic from PropellerAds to paused Monetizer offers?

Using this simple Google Sheets script you can automate the process - this script will check the offer status every 5 minutes and if the Monetizer offer is offline (or outage is detected) it will pause your campaign in PropellerAds. It can also resume traffic when an offer comes back online. Setting up this script won’t take more than 5 minutes of your time!

This is how the script looks like:

00-png.36069


First thing you’ll need to do is copy this Google Sheets script to your account. Use this link:

https://docs.google.com/spreadsheets/d/15QLwfBIhaiuy512davoixMNwedzeIbUAPPyc1fu9MaY/copy

01-png.36070


Click on Make a copy.

Once you’ve created a copy of the script, go to the Configuration tab where you’ll need to enter PropellerAds API key and Monetizer Access Token.

03-png.36072


04-png.36073


Copy-paste the keys into the grey cells.

You can get your PropellerAds API key from your profile:

https://partners.propellerads.com/#/profile/api

05-png.36074


Create a token if you haven’t already, and copy paste it in the Configuration sheet.

To get the Monetizer Access Token , go to your Monetizer profile:

https://app.monetizer.com/profile

06-png.36075


And
 
To view the premium content in our affiliate marketing forum (including this awesome thread), you must first register and upgrade your account. Register today and become a part of our amazing community!
Top