No response about facebook-ads-reporting-google-apps-script

[fredericharnois]

Hi @maychenn!

This is meant to be run in the Google Apps Script environment and calls on APIs/methods that are exclusive to that environment.

Don't hesitate if you have any issues getting it setup there.

Thanks!

[maychenn]

Thanks so much for responding! I was finally able to get it set up. Do you know how I can get 1d_click, 1d_view, 7d_click, etc. to show up? This is what I have for filtering currently (based on another comment). I got an error when I included it in fields.

[fredericharnois]

You'd actually want to add an additional parameter to do that.

First, add this constant:

const ATTRIBUTION_WINDOWS = '['1d_view','7d_view','28d_view','1d_click','7d_click','28d_click']'

Then add &action_attribution_windows=${ATTRIBUTION_WINDOWS} to the facebookUrl constant in the url parameters.

Let me know if it works!

[maychenn]

That's actually what I tried, and I'm now getting an error that says this even when I take the attribution window portions out:

Exception: Request failed for https://graph.facebook.com returned code 400. Truncated server response: {"error":{"message":"Invalid OAuth access token.","type":"OAuthException","code":190,"fbtrace_id":"Ab0OHVHQYS1rXAuAZm11xtW"}} (use muteHttpExceptions option to examine full response) (line 50, file "Code")

Could it have to do with Graph v8.0 that just came out? I've checked that the tokens I'm using are still valid & I switched v7.0 to v8.0