Refreshing the access token for the Facebook Ads BigQuery Data Transfer
This article extends the Facebook Data Transfer walkthrough by a mini guide showing how to refresh the access token in a few minutes when it expires every 60 days.
The BigQuery Data Transfer for Facebook Ads is a (currently still) free alternative to 3rd party ELT tools and to writing and maintaining a connector yourself. It has a few shortcomings though, and one is the fact that it does not manage the refresh of the access token (which many 3rd party ELT tools do, without you having to worry about it ever).
While the Facebook Transfer is a bit "minimalistic" in its configuration and output data structure, it might just do the job for a lot of use cases. So this guide aims to reduce the moderate inconvenience of manually refreshing the token to a minor one.
Free subscribers can take the full walkthrough article and infer the necessary steps from there. If you're a premium user, read further and save time every time your transfer expires.
