Script to Return accounts with voucher codes
Hi, I am trying to create an MCC script to return anything that will identify an account as having a voucher attached, basically the issue is that when my agents are creating new accounts they are supposed to add a voucher code but sometimes forget, I would like a script to run which returns accounts younger than 10 days that do not have a voucher code applied.
I have been searching for a while and nothing seems to come up regarding the voucher code however I was wondering if this isn't possible is there something that will return the balance of an account as I could maybe check for brackets which denotes a positive balance and would also mean a voucher had been applied.
Thanks for any help,
Re: Script to Return accounts with voucher codes[ Edited ]
July 2015 - last edited July 2015
Hi @Mark A unfortunately I'm not aware of any way to access any billing details for Accounts via scripts.
You can, of course, access all manner of stats; I'm wondering if you can simply check for impressions/clicks as an indicator that there are funds, although you will still have problems identifying new Accounts since there is no "account creation date" accessible.
What you could do is apply a Label to all new Accounts to solve the creation date problem. Run a script every day to look for a specific Label format (e.g. "DC:21072015") - you can search Labels via a contained string so you can just look for "DC:" - and, if one doesn't exist, create it and apply it.
Not sure if this helps.
Re: Script to Return accounts with voucher codes
Shame there is nothing that can access the billing information... maybe it will be an addition at some point. Good call on the creation date, perfect to create a label on accounts without labels beginning with a sub-string then check all labels with that sub-string for older than the 10 day requirement, now just to figure a work around for the voucher.... hmmmm.