facebook-ads-reporting-google-apps-script icon indicating copy to clipboard operation
facebook-ads-reporting-google-apps-script copied to clipboard

Unable to import all columns data

Open ayushjnv2 opened this issue 4 years ago • 3 comments

Hi Frederic!

Thank you so much for the this easy to use script. I am facing an odd error with the data export - it is only exporting Impressions and Spends data though I have selected Outbound click, App Installs as well.

Screenshot 2020-06-08 at 5 40 17 PM

Also, any way to pre-define the language of the headers? It is auto inputting a regional language which I would want to change.

ayushjnv2 avatar Jun 08 '20 12:06 ayushjnv2

Hi Ayush,

Glad you find the script helpful!

Does anything change if under the FILTERING constant you replace link_clicks by outbound_click?

As far as languages go, you'll want to modify the url constant in the getFacebookReport() by adding a locale parameter. For example, if you want the output to be in english, it would look like this: https://www.facebook.com/ads/ads_insights/export_report?report_run_id=${reportId}&format=csv&access_token=${TOKEN}&locale=en_US

fredericharnois avatar Jun 18 '20 03:06 fredericharnois

Where to get the report ID?

ppcmaverick avatar Jul 07 '20 10:07 ppcmaverick

Hi @ppcmaverick!

The report ID is the result of the request-facebook-report.js. It's cached so that it can be passed on to get-facebook-report.js.

fredericharnois avatar Jul 14 '20 00:07 fredericharnois