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.

Formula parse error.

  1. This means the add-on or Google Sheets doesn't like something in the formatting of your sheet. 
  2. Make sure your parenthesis and brackets are closed. The last character in your formula should be )
  3. Confirm when referencing cells you aren't putting the cell numbers in quotes. Correct: {"targets", A3} Incorrect: {"targets", "A3"}
  4. Confirm when using numbers in your formula you aren't putting the numbers in quotes. Correct: {"limit", 100} Incorrect: {"limit", "100"}
  5. Are you in Europe? Your Google Sheet settings may be set to European standards which treats commas as decimal points. Either update your settings or switch all commas to semicolons in your formula. Looks like this: =campaigns(“last week”; {“budget”; “spend”})
  6. Is your formula showing up without Google Sheets' formula color coordination? If your formula is only showing up in a black font color, your formatting may be off. Make sure if you copied and pasted your formula from another tool (like Slack), that you retype the quotation marks fresh. Example:

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

Did this answer your question?