Below are a few common errors you may encounter when using AdStage's Google Sheet add-on.

Deciphering Error Messages:

#error {:message “Service access error. Please sign in to your AdStage account and try again. Need help? Check out our troubleshooting..."}} (line 472)“

  1. Log out and log back into the add-on.
  2. If that doesn't work, update the formula by making a change to a parameter to kick off a fresh call. For example, change sort by clicks to sort by spend. After you make the change, feel free to swap it back once the data pulls through.
  3. If those two options don't do the trick, check to see if you are the owner of the sheet. The owner of the sheet needs to access and log into the add-on. If the owner of the sheet doesn't have an AdStage account, consider helping them login to the add-on with your credentials. Alternatively, you can duplicate the sheet, which switches ownership to yourself, then your formulas should pull through.

Array result was not expanded because it would overwrite data in A3.

  1. Check the cells where the formula would expand, are there formulas/numbers/letters in the way? The formula won't be able to build out if the cells required are already occupied. The error message will let you know where one of the occupied cells is. In the above example, A3 had a digit in it. 

Internal error executing the custom function.

  1.  A custom function call must return within 30 seconds. If it does not, the cell will display an error: Internal error executing the custom function. This is a limitation on Google's end. Read more here. To fix the issue, lower your limit or use a smaller date range.

Request failed for https://platform.adstage.io/api/organizations/31061/build_report returned code 500. [...]

  1. Refresh the formula. 500 errors sometimes go away on refresh.
  2. The request is too large. Try adjusting the parameters to make the call return less data. A few ideas:
  •  Lower the limit parameter. After a limit of 1000 you are more likely to hit 500 errors.  {"limit", 100}. 
  • Use targets to only include data from certain ad accounts instead of all ad accounts connected to your AdStage account. {"targets", "/network/facebook/account/29234932,/network/linkedin/account/597452157"}. More on targets here.

Unknown function: accounts/campaigns/ad groups/ads/keywords

  1. Log out and log back into the add-on.
  2. If that doesn't do the trick, go to Tools and select Script Editor in your Google Sheet.
  3. In the toolbar there will be a dropdown with a function in it. Select any function (myfunction is fine).
  4. Click play.
  5. You might have to approve permissions.
  6. Close out new script tab, refresh your original sheet, potentially reload the formula.
  7. If you are still hitting the error, repeat steps 2-6.

Need more help? Reach out to us at support@adstage.io. 

Did this answer your question?