To get started with the Facebook Ads connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Facebook Ads button and select the Accounts menu item.
ADD AN ACCOUNT
Enter a Reference Name for the account and click the Add Account button. You will step through a Facebook login sequence to authorize Analytics Edge to access your account. *
* A note about security: an account access token is encrypted and stored in a file on your computer using the reference name you entered. Your workbook queries use the reference name, and during refresh, the connector looks up your access token and sends it direct to Facebook’s API server with your queries. Your access tokens are not stored in your workbooks, so you can freely share the workbooks.
MAKE A QUERY
In Excel, on the Analytics Edge ribbon bar, click the Facebook Ads button and select the Ads Insights menu item. Select the account (Login) and Ad Account for your query, then choose the Campaign/Ad, Columns, Dates, Filters, Sorting and Attribution options for your query. Click Finish when you are ready to make the query.