Category Archives: Facebook Ads

Please reduce the amount of data you’re asking for

When the Facebook Ads API returns an error 500, it is telling you that the combination of the number of metrics and rows of data being asked for is too large for them to process all at once. You may hit the limit around 1000 rows, or it could be higher or lower depending on the fields you are asking for. With v2.6.0 of the Facebook Ads connector, Analytics Edge provides a mechanism to work around this limitation of the API to get the data you want.

Using a divide-and-conquer approach, you can split up the query into smaller chunks of data (make a query for each campaign, ad set or ad) and merge the results. The new connector release features a new capability — Ads Listing — that lets you get all of the Ad Accounts for a specific login, or all the Campaigns, Ad Sets and/or Ads for a specific Ad Account, Campaign or Ad Set. Using that listing as a guide, you can repeat your query for each campaign, ad set and/or ad, then merge the results together for your report.

The Analytics Edge Core Add-in can be used to automate this process, and the rest of this article describes the steps to take.

Continue reading


Use this Analytics Edge wizard to select sorting options for your Facebook Ads query.

Note that only some columns can be sorted by the API. Sorting of other columns will need to be done in Excel or using the Analytics Edge Sore Add-in’s Sort function.

You can only sort on one selected column, in either Ascending or Descending order. Selecting No Sort will clear the selection.



Use this Analytics Edge wizard to set filter options for the Facebook Ads query.

By selecting options at the left, the filters will be update at the right. To enter metric-based filters, select the column, comparison and value then click Add to add the expression to the current filter list below.



This Analytics Edge wizard lets you pick different attribution windows for your Facebook Ads Insights query. When you select attributions, new columns will appear in your report for each metric that has values for that attribution option.




Use this wizard to log in to your Facebook Ads account and authorize Analytics Edge to access your data.


Enter a name for the account you want to login with, then click the Add Account button. Multiple accounts can be stored, and you can change which account gets used by default by selecting it and clicking the Make Default button.


Dates Tab

This Analytics Edge wizard lets you pick the date range for your Facebook Ads Insights query.

NOTE: only dates where the campaign/ad set/ad were active will appear.

You can pick from several preset values, or pick a combination of start date, duration and/or end date. With the start/duration/end selections, you can also offset the selected dates for the previous period or the same period in the previous year.



For the dates, you can select a specific calendar date, pick from one of several dynamic dates like ‘start of last month’, or enter a date value.

When entering a date manually, you can type in the date, use an Analytics Edge range name (like [Date]), or enter a cell reference to a worksheet containing a date.

Finally, you can select to use the date range chosen, or use the same duration period previous to the chosen date range, or use the same period from the previous year.

Columns Tab

This Analytics Edge wizard lets you select the Facebook Ads Insights metrics you want.

Select the field you want on the left, then double click or click the Add button to copy it to the selected fields list on the right. Repeat for all the fields you want. Note that the Dimensions are determined by the selections you made on the Campaigns/Ads tab.



Campaigns/Ads Tab

Use this Analytics Edge wizard to select one of your saved logins, and the Facebook Ad Account, Campaign, Ad Set, or Ad you want to use for this query.

Login – Select your login account (set in the Accounts wizard), or use a cell reference to get the value from a worksheet.

Ad Account – select the ad account to use. Once selected, the list of campaigns will be displayed below. If you use the cell reference feature, use the account id in the format of “act_######”.

Select Item – select the Campaign, Ad Set or Ad that you want to report on, or use a cell reference to get the value from a worksheet. The value should be the id of the item (campaign_####, adset_####, or ad_####).

Active Only – include only active campaigns and ads in the report.

Show All – expands the display to show all campaigns and ads in the listing.


Reporting Level – you can select a Campaign above, and report at the campaign, ad set or ad level producing new report lines for each ad, for example.

Campaign/AdSet/Ad Filter – filter the report to include campaigns that match the phrases entered. If the ‘Not” check box is checked, exclude matching entries.

Breakdown – for each item, break down the results by the selections made. Combinations can be made but some combinations are not allowed and will result in an error.

* Facebook Ads Help

The Facebook Ads Connector for Analytics Edge makes it possible to automate your Facebook Ads Insights downloads into Microsoft Excel. Get just the metrics you want, formatted for use in Excel.

Before you can use the connector, you MUST log in to a valid Facebook account (with the Accounts wizard) and have ads_read access.