Setting up the Add-on

To add the Google Sheets AdStage Add-on follow this link. Once you grant AdStage permissions and add the AdStage Add-on simply go to any Sheet. In the Add-ons Menu you'll see AdStage. 

Choose, Launch Sidebar.  

You must have an AdStage account to use the Add-on. Sign in to continue. 

Once signed in. You'll see documentation in the sidebar. The documentation is also listed in this article

Start Building Sheets

If you're a Google Sheets wizard then the documentation should provide now have enough info to start building some powerful reports in Sheets. We've also created a few templates for you to check out if you prefer to get a head start. 

Simply open the template, make your own copy, and start building reports!

Cross Network Reporting Template

A/B Testing Report

Things to Know

  1. Column Headers/Metrics: When choosing your column headers/metrics you must use the AdStage API Keys.  You can make the column headers/metrics human readable by changing capitalizing and removing underscores. For example, the Add-on is smart enough to turn column names like "Link Clicks" to "link_clicks", but for something like "Website Conversions", which we are internally calling just "conversions", that logic breaks down a bit. 
  2. Google has a built in 30 second cap on any queries. If you query is too big and it exceeds the 30 second timeout, your query will fail. If your query keeps failing, try to make it less complex by removing parameters or limit rows (either with the "limit" parameter, or by grouping data by network - {"group_by", "network"} - if you just need an overview) and/or data lookback.
  3. We recommend you limit rows to 1000 rows to keep queries under the Google timeout. You can use the "offset" parameter to effectively add paging to you request. 
  4. When reporting on the Account Group level, the creator of the Sheet must have the Account Group set up in their own AdStage account. Head over to Integrations to confirm that you have the Account Group already set up, or create a new one before adding it to your Sheet.

Known Issues

  1. Certain combinations of parameters may cause issues. If you have an unknown error try removing a parameter. 

#ProTips for Advanced Users

Pro Tip 1: You can use "targets"  to pull data for specific accounts or folders.  

To find the folder ID head into the AdStage Management tables and choose the folder. The ID is in the URL - but you must prefix it with "/network/adstage/folder/" to create a valid target identifier. For example: "/network/adstage/folder/a2404b24-6f39-48ea-b5ea-0df661b7195b"

An entire query will look something like this:

=campaigns("this week", A1:H1, {"targets", "/network/adstage/folder/1dab401a-84f6-41ba-97d9-784b8fe09910f"})

This trick can also be used for Account Group level reporting - if this sounds interesting to you - let us know and we can help you find out your account group IDs.

Pro Tip 2:
You can access Facebook's native data to create cross-account Facebook Real-time Widgets through the Google Sheets Plugin.

Simply add the "provider" property - {"provider", "facebook"} to your formula bar. This will aggregate multiple accounts in your Sheet via separate cells. A query including "provider" will look something like this:

=accounts("last year", {A1:H1}, {"provider", "facebook"}, {"dimensions", "age"}, {"sort_by", "age"},{"order","asc"}, {"targets", M2}) 

Pro Tip 3:
As you may have noticed in the previous #ProTip, you can choose the order of your dimensions with the "sort_by" property. This will allow you to better organize your dimensions in either ascending ("asc") or descending ("desc"). A query including "sort_by" will look something like this:

=accounts("last year", {A1:H1}, {"provider", "facebook"}, {"dimensions", "age"}, {"sort_by", "age"},{"order","asc"}, {"targets", M2}) 

Did this answer your question?