Search API Connector Documentation

Print

Import Facebook Ad Data to Google Sheets

In this guide, we’ll walk through how to pull Facebook ad data from the Facebook Marketing Insights API directly into Google Sheets, using the API Connector add-on for Google Sheets.

There are 2 ways to connect to the Facebook Ads API:

  • Preset “Connect” button (OAuth) premium
  • Personal access token. Please check the appendix for detailed instructions to retrieve your token.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Connect to the Facebook Ads API

To begin, we’ll initiate the connection to the Facebook Ads API.

  1. Open up Google Sheets and click Extensions > API Connector > Manage Connections.
  2. In the list of available connections, find Facebook Ads and click Connect.
    fb-ads-img13
  3. You will be directed to Facebook and asked to approve the connection. Click Done.
    fb-ads-img14
  4. You’ll then be returned to your Google Sheet, and can verify that your Facebook Ads connection is active in the Connections screen.

Part 2: Create a Facebook API Request URL

For our first request, let’s get some basic data about your Facebook ads account.

  • API root: https://graph.facebook.com
  • Endpoint: /v13.0/act_YOUR_ACCOUNT_ID/insights (Get your account ID as described here)

Putting it together, we get the full API Request URL:

https://graph.facebook.com/v13.0/act_123456789012345/insights

Just substitute in your own account ID.
(If you use the preset Facebook Ads connection, API Connector will automatically route requests to the most recent version when the version changes.)

Part 3: Pull Facebook API Ad Data into Sheets

Now let’s enter that URL into API Connector.

  1. Back in the Create Request interface, enter the Request URL we just created above.

    fb-ads-img16
  2. Under OAuth, choose Facebook Ads from the dropdown menu. You should see a badge saying Connected.
    fb-ads-img17
  3. We don’t need any headers so just leave that section blank.
  4. Create a new tab and click Set current to use that tab as your data destination.
  5. Name your request and click Run. A moment later you should see summary ad stats populate your Google Sheet. By default, without additional parameters the FB Advertising API will return impression and spend data for the last 30 days.
    fb-ads-img18

Part 4: More Example API URLs

Facebook’s API is large and complex, with many different endpoints. The cool thing about querying the API directly is that you can get ANY of the data they provide, but it can require a little digging to get exactly what you want. Take a look at these example API URLs to better understand how it all works:

  • Key metrics (reach, impressions, clicks, CPC, and spend) for the past 30 days:
    https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/insights?fields=reach,impressions,clicks,cpc,spend
    fb-ads-img19

  • Key metrics for the past 30 days, broken down by age and gender:
    https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/insights?fields=reach,impressions,clicks,cpc,spend&breakdowns=["age","gender"]
    fb-ads-img26The documentation contains a list of available breakdown dimensions and breakdown combinations.
  • Key metrics for the past 30 days, for each day:
    https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/insights?fields=reach,impressions,clicks,cpc,spend&time_increment=1
    fb-ads-img20The time_increment parameter lets you choose how to slice up the results. Options include time_increment=monthly, time_increment=all_days, or time_increment={any number from 1-90}.
  • Key metrics for a specific time period, for each day:
    https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/insights?fields=reach,impressions,clicks,cpc,spend&time_increment=1&time_range={"since":"2020-08-01","until":"2020-08-31"}
    If you prefer to use a variable time period, you can either use Facebook’s date_preset parameter, or reference cells containing dynamic dates in your API request URL.
  • Key metrics for a specific time period, for each day and campaign name:
     https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/insights?fields=campaign_name,reach,impressions,clicks,cpc,spend&time_increment=1&time_range={"since":"2020-08-01","until":"2020-08-31"}&level=campaign
    fb-ads-img22

  • Key metrics for the past 7 days, for each day and by account name, campaign ID, campaign name, adset ID, adset name, ad ID, ad name, and account currency:
    https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/insights?fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,account_currency,reach,impressions,clicks,cpc,spend&time_increment=1&level=ad&date_preset=last_7d
    fb-ads-img23
    The date_preset parameter lets you choose your reporting period. Options include date_preset=today, yesterday, this_month, last_month, etc. A full list is available in the documentation. It will be ignored if the time_range parameter is used.

  • Key metrics for the past 30 days, including conversions/actions (see more about getting conversion data in part 5). May 2021 update: the &use_unified_attribution_setting=true parameter has been added to account for iOS14-related attribution changes (info).
    https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/insights?fields=actions,reach,impressions,clicks,cpc,spend&use_unified_attribution_setting=true

    fb-ads-img24
    Note: this request was run in “compact” mode to make it easier to read the list of actions. The “single row” report style would display each action in its own column.

  • Ad status and run dates:
     https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/ads?fields=name,id,effective_status,updated_time&limit=1000
    Note: this final “Ad status” request pulls from the FB Ads API rather than the FB Insights API. The FB Ads API uses a different URL structure, and requires UNIX timestamp filters, e.g. https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/ads?fields=name,id,ad_review_feedback,effective_status,updated_time&limit=1000&filtering=[{'field':'updated_time','operator':'GREATER_THAN','value':'1616025600'}, {'field':'updated_time','operator':'LESS_THAN','value':'1629590400'}] or https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/ads?fields=name,id,effective_status&filtering=[{field: "effective_status",operator: "IN",value: ['ACTIVE']}]&limit=1000

Part 5: Understanding Conversion / Action Data

Facebook’s API treats conversions as a type of “action”, and you retrieve them by including fields=actions in your query, as shown in the conversions URL example above. Actions will automatically be returned with their action count (the number of times the action occurred).

If you would like to also retrieve the value of an action, e.g. a purchase value, you need to also request the action_values field like this: fields=actions,action_values.

The response isn’t that convenient as Facebook will return ALL of the actions they’ve tracked on your site or app, along with the action count. This is an abbreviated list of the actions tracked by Facebook (source):

  • offsite_conversion.custom.: Custom Conversions defined by the advertiser
  • offsite_conversion.fb_pixel_add_payment_info: Adds Payment Info
  • offsite_conversion.fb_pixel_add_to_cart: Adds To Cart
  • offsite_conversion.fb_pixel_add_to_wishlist: Adds To Wishlist
  • offsite_conversion.fb_pixel_complete_registration: Completed Registration
  • offsite_conversion.fb_pixel_custom: Custom pixel events defined by the advertiser
  • offsite_conversion.fb_pixel_initiate_checkout: Initiates Checkout
  • offsite_conversion.fb_pixel_lead: Leads
  • offsite_conversion.fb_pixel_purchase: Purchases
  • offsite_conversion.fb_pixel_search: Searches
  • offsite_conversion.fb_pixel_view_content: Views Content
  • onsite_conversion.flow_complete: On-Facebook Workflow Completions
  • onsite_conversion.messaging_block: Blocked Messaging Conversations
  • onsite_conversion.messaging_conversation_started_7d: Messaging Conversations Started
  • onsite_conversion.messaging_first_reply: New Messaging Conversations
  • onsite_conversion.post_save: Post Saves
  • onsite_conversion.purchase: On-Facebook Purchases
  • outbound_click: Outbound Clicks
  • photo_view: Page Photo Views
  • post: Post Shares
  • post_reaction: Post Reactions
  • rsvp: Event Responses
  • video_view: 3-Second Video Views

This means that when you run your “fields=actions” request, the Facebook API may return a lot of data about conversions you’re not interested in. Therefore, you will usually want to include some type of filtering. The next section has information on that.

Part 6: Handle Filtering

If you want to filter for specific actions, e.g. purchases, you can do so with the ‘filtering’ parameter, like this:

https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/insights?fields=actions,reach,impressions,clicks,cpc,spend&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]

If you’re using the IN operator, you can include multiple conditions like this:

&filtering=[{field: "action_type",operator:"IN", "value":["offsite_conversion.fb_pixel_purchase","offsite_conversion.fb_pixel_add_to_cart"]}]

To combine multiple filters for different fields, e.g. both a specific campaign and a specific action type, include them in the “filtering” array as a comma separated list. Facebook’s documentation isn’t very clear on this point, but it seems campaign names and ID filters need to be evaluated as a string rather than in an array, like this:

&filtering=[{field: "campaign.id",operator:"CONTAIN", value: '123456789'},{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]

To filter for custom conversions, open up FB Business Manager, click Events Manager, then click Custom Conversions in the lefthand sidebar. You’ll see a list of custom conversions and their IDs. Substitute in that ID, like offsite_conversion.custom.398028550584411 instead of offsite_conversion.fb_pixel_purchase.

Part 7: Handle Actions

Facebook’s API lists conversions together in a single “actions” field. Therefore, if you’re requesting multiple actions at once, I suggest using a JMESPath expression to move each action into its own column. The expression for each metric looks like this, where you name your new field on the left side, and query for the action you want on the right, like this:

cart_adds:actions[?action_type=='offsite_conversion.fb_pixel_add_to_cart']|[0].value

Example

Let’s take an example request URL of https://graph.facebook.com/v13.0/act_1111111/insights?fields=campaign_id,campaign_name,unique_clicks,spend,actions&level=campaign

The following JMESPath would create a report with the following fields: campaign_id, campaign_name, unique_clicks, spend, cart_adds, purchases, date_start, date_stop

data[*].
{campaign_id:campaign_id,
campaign_name:campaign_name,
unique_clicks:unique_clicks,
spend:spend,
cart_adds:actions[?action_type=='offsite_conversion.fb_pixel_add_to_cart']|[0].value,
purchases:actions[?action_type=='offsite_conversion.fb_pixel_purchase']|[0].value,
date_start:date_start,
date_stop:date_stop}
fb-ads-img27

Part 8: Sort Data

Facebook allows sorting of data using the sort parameter. You enter the field name you’d like to sort on, and then append “_ascending” or “_descending” to specify the sort order (the default sort order is ascending). For example, to sort data in descending order of spend amount, you would append the following to your URL:

&sort=spend_descending

If you’re sorting on actions, you would sort by action type using the syntax sort=["actions:<action_type>"]. For example, to sort data in ascending order of cart adds, you would append the following to your URL:

&sort=["actions:offsite_conversion.fb_pixel_add_to_cart_ascending"]

Part 9: Handle Pagination

  1. By default Facebook limits the number of results in a single response (usually to 25 records) as described here. To get more records, you can add the ‘limit’ parameter to the end of your URL, like this: https://graph.facebook.com/v13.0/act_YOUR_ACCOUNT_ID/insights?fields=reach,impressions,clicks,cpc,spend&limit=1000

  2. There seems to be an undocumented limit of 5000, so if you need more records after that, you can loop through them using pagination handling (paid feature).
    • API URL: enter your request URL, including &limit=5000
    • Pagination type: cursor
    • Next token parameter: after
    • Next token path: paging.cursors.after
    • Run until: choose when to stop running the request

      facebook-pagination-cursor

Part 10: API Request URL Builder

This is a convenient tool for easily building Facebook API request URLs as shown below. Just select your dates and parameters.

Once you’ve constructed your URL, you can copy and paste it into API Connector’s request URL input field. Here’s the link: Facebook API Request Builder

Part 11 [Business Plan]: Get the Facebook Ads Report Pack

Note: this report pack makes use of API Connector’s Facebook Ads OAuth2 connection, so you’ll need a paid Business account with API Connector for it to work (or install API Connector for a free trial).

The Facebook Ads report pack is a pack of pre-built report templates to get you started. All you need to do is enter your own Facebook account ID to populate the reports with your own data. The report pack includes the following:

  • Overview: A summary overview of key metrics
    fb-ads-img28
  • Campaign Data: A report showing all your campaigns, with key metrics including impressions, frequency, clicks, spend, purchases, etc.
    fb-ads-img29
  • Monthly Data: A report showing a summary of key metrics broken out by month
  • Device Data: clicks and impressions by device
  • Demographic: clicks and impressions by age and gender

Here is the link (click File > Make a Copy to get your own copy).

Part 12: API Documentation & Resources

Appendix: Connect with a Facebook API User Access Token

This section is provided as a totally free alternative to the method described above. Instead of clicking Facebook Ads in the Connections manager, you will retrieve and refresh your token yourself every 2 months.
  1. Begin by navigating to https://developers.facebook.com/, and click My Apps.
    fb-ads-img1
  2. Click Add a New App.
    fb-ads-img2
  3. Facebook will ask you to choose an app type. Select Business and click Next.
    fb-ads-app-type
  4. Finally, enter your app details. You can name your app anything as long as it doesn’t include terms related to Facebook. Click Create App.
    fb-ads-app-details
  5. You’ll be directed into your Developer dashboard. Under the heading “Add Products to Your App”, scroll down to Marketing API and click Set Up.fb-ads-img5
  6. On the left sidebar, you’ll now see Marketing API listed under Products. Click Tools.
    fb-ads-img6
  7. This will produce a screen where you can select your token permissions. All the example API requests in this article use the “ads_read” permission, which allows you to read ads reports from the Ads Insights API for ad accounts you own or have been granted access to by the ad account owner. Click Get Token.fb-ads-img7
  8. You’ll now see your access token. Copy it down and keep it safe as they won’t show it again. Congrats, you can now access the Facebook Advertising API!
    fb-ads-img8
  9. Now that you have your token, you can use it by appending access_token=YOUR_ACCESS_TOKEN to any API URL, e.g. https://graph.facebook.com/v13.0/act_123456789012345/insights?fields=clicks,cpc,spend&access_token=YOUR_ACCESS_TOKEN. Since you’re manually including a token, leave OAuth2 authentication set to None.
This access token will expire in 2 months. Once it expires, go back to your Developer Dashboard, select your app, click Tools, and get a new token. Repeat this process each time your token expires. To view the status and expiration date of a token, you can paste it into Facebook’s Access Token Debugger tool.

Previous Import EventTemple Data to Google Sheets
Next Import Facebook Leads to Google Sheets

236 thoughts on “Import Facebook Ad Data to Google Sheets”

  1. Great article! I’m looking to add lead events from the pixel in mine, and I’ve found the documentation for it (action_type and offsite_conversion.fb_pixle_lead) but I don’t know how to add this to what I have so far:

    https://graph.facebook.com/v6.0/act_{account ID}/insights?date_preset=yesterday&level=ad&fields=campaign_name,adset_name,ad_name,reach,impressions,spend,inline_link_clicks,inline_link_click_ctr,cost_per_inline_link_click&access_token={access token}

    Reply
    • It should be the same pattern as the example above that filters for purchases. Something like this: https://graph.facebook.com/v6.0/act_{account ID}insights?date_preset=yesterday&level=ad&fields=campaign_name,adset_name,ad_name,reach,impressions,spend,inline_link_clicks,inline_link_click_ctr,cost_per_inline_link_click,actions&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_lead']}]&access_token={access token}

      Reply
  2. Is there a way how to get the daily breakout of performance and show the corresponding day for the data in each row? Right now I have:

    https://graph.facebook.com/v6.0/act_{account}/insights?time_range={"since":"2020-03-01","until":"2020-03-31"}&level=ad&fields=account_name,campaign_name,adset_name,ad_name,account_id,campaign_id,adset_id,ad_id,reach,impressions,spend,inline_link_clicks,inline_link_click_ctr,cost_per_inline_link_click,actions&filtering=[{field: "action_type",operator:"IN", value: ["lead"]}]&access_token={access token}

    This above request is working however, I am not able to pull in the specific date of each row (ad performance for a specific day within the time range), I only have date_start, date_stop (the first and last days of the whole time period).

    Thanks!

    Reply
  3. Hi, Thanks for the tutorial, very nice! Have a few questions that you might have time to answer… First of I have: https://graph.facebook.com/v6.0/act_XXXXXXXX/insights?date_preset=last_7d&time_increment=all_days&level=ad&fields=account_id,account_name,campaign_name,adset_name,ad_name,account_currency,impressions,reach,conversions,clicks,conversion_values,ctr,cpc,cpm,cpp,cost_per_conversion,spend,social_spend&access_token=

    However, I don´t get the fields Conversions, Conversion_values, cost_per_conversion to display any value. Any idea?

    Secondly, the data from the following fields looks very wierd. Have tried to work with different formats but it still doesn’t make sense. Any idea?

    data » ctr data » cpc data » cpm data » cpp data » spend
    8307.28.00 10121.09.00 11354.04.00 10961.36.00 138.25.00

    Thanks!

    Reply
    • conversions isn’t a field like impressions and clicks etc. Simple fields are listed in the documentation as “string” or “numeric string” etc, while conversions is followed by a link to “list-AdsActionStats“. If you click that link you’ll find information on pulling in conversions. (you can see some examples above in the section on filtering for specific actions.)

      I’m not sure about your weird cpc/cpm data, in my own tests those fields come through fine. What does the data look like when you’re logged into FB Ads Manager? If it’s OK there, I’d check if it’s related to the locale of your spreadsheet, since that can affect how commas and periods get processed. You can change your locale by navigating to File > Spreadsheet Settings > Locale. Try setting it to United States and see if that helps.

      Reply
  4. Great article! Would it be unwise to use this to pull in info from two different fb users? I’m thinking it might not be a good idea to show facebook a link between the two separate users/accounts so they don’t suspect something fishy is going on? Could they know two APIs are linked to the same Google sheet??

    Reply
    • I don’t really have any idea what Facebook is looking at, or if they even can tell that the API is being pulled from a Google Sheet, but I would be very surprised if this is an issue. Many agencies & companies work with multiple brands and accounts, so it’s totally normal to bring data from separate FB accounts into the same sheet.

      Reply
  5. This is amazing! Thanks so much – do you know if it is possible to pull in multiple actions and also action values? I’m looking to pull in Link Clicks, ViewContent, AddToCart, InitiateCheckout and Purchases, along with Purchase Value.

    Also – is there a limit to the size of the request coming back that can be handled? I’ve tried using the date range last year to date (split by day) and this works at the overall level, but when I try and break this down by campaign as well I get an “unknown error” and not sure if this is due to the size of the request that’s coming back (I’m not using any pagination, just setting the limit to a super high value so I get all the info in one sheet).

    Reply
    • Sure, you can get multiple actions just by leaving off the filter condition, like this:
      https://graph.facebook.com/v6.0/act_YOUR_ACCOUNT_ID/insights?date_preset=last_7d&fields=actions&access_token=YOUR_ACCESS_TOKEN
      I suggest switching to the compact report style, it makes the output a bit easier to read.

      If you want purchase value, you’d include the field action_values, e.g. &fields=actions,action_values.

      Facebook does have limits on the size of the request, but I don’t think that’s the case here since the API usually returns a useful error message when their limits are hit. I just searched online for information about the “unknown” error, and found some related bug reports and some people saying it’s related to including the “likes” field in your requests. You can check as well, but you may need to just experiment with your request parameters until you get a working response.

      Reply
  6. Ana I need your helpppp Please
    I want to have a sheet for every single campaign on fb ads, but i can’t because it writes me all the campaigns in a single sheet. Secondly I really need the conversions number and conversion cost but i really can’t add them. Thank you very very much for this work.

    https://graph.facebook.com/v6.0/act_11111111111111/insights?date_preset=last_14d&time_increment=14&level=ad&fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,account_currency, impressions,reach,clicks,ctr,cpc,cpm,cpp,spend,social_spend&access_token=XXXXXXXX

    Reply
    • Here I am! 😀 If you want to get campaign data into individual sheets, you should create multiple requests, each one filtering for the campaign ID. Like this:
      https://graph.facebook.com/v6.0/act_11111111111111/insights?date_preset=last_14d&time_increment=14&level=ad&fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,account_currency,actions&access_token=XXXXXXXX&filtering=[{field: "campaign.id",operator:"IN", value: ['23842750602790045']},{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]
      You can get all your campaign IDs by first running the above request without the filtering parameter.
      The “actions” field shows all conversions. The example above shows the actions field filtered for just purchase conversions.

      Reply
      • Thank you very much ana. I’m sorry but I just can’t create the code that shows me the conversions (in a cell) and the conversions cost (in another cell). In fact if i use “access” it gives all the results in one cell and I can’t analyse them with sheets’ formula. (really sorry but I am not a developer… I think you understand it ahaha)

      • Ah ok, I included all the metrics/breakdowns from the URL in your question, but if you just want a simple cost + conversions by campaign, then you can use something like this instead:
        https://graph.facebook.com/v6.0/act_111111111111/insights?level=campaign&fields=campaign_id,campaign_name,spend,actions&access_token=YOUR_TOKEN&filtering=[{field: "campaign.id",operator:"IN", value: ['23842750602790045']},{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]
        When I run that, it produces a simple report with just campaign ID, campaign name, spend, conversions, and date. Can you please check if that works better for you?

    • Hi, thank you for reading my site. I’m afraid I’m not sure what you mean by URL parameter, do you mean the parameters that go on the end of your ad URLs? I don’t know if FB provides that, the only thing I see related to URLs is the action_destination breakdown, which they describe as “The destination where people go after clicking on your ad.” You can pull that field like this: https://graph.facebook.com/v6.0/act_YOUR_ACCOUNT/insights?fields=actions&action_breakdowns=action_destination&access_token=YOUR_TOKEN

      Reply
      • Yes sorry for the confusion. I mean the url parameters that go at the end of your website link when someone clicks your ad. They are called “url_tags” as referenced here https://developers.facebook.com/docs/marketing-api/reference/ad-creative

        Note I keep getting “No Breakdown” when I try your code above. When I replaced action_destination with action_device I get a HTTP ResponseCode 500 (internal error) which is weird because, unless I read the docs wrong, that is another option I can use for action_breakdowns. Any ideas? 🙂

      • I tested based on that documentation and this successfully pulled in the url parameters, can you please try it and see if it gets what you’re looking for?
        https://graph.facebook.com/v6.0/act_11111111/adcreatives?fields=url_tags&access_token=TOKEN

        I’m not sure about your “no breakdown” error, I just retested and that request URL still worked for me.

  7. Hello dear Ana, Tahnk you so much of this Topic that helped me so much !
    I’m wondering if you have any idea about the API Url to use to generate a report that includes the spending per day per campaign?
    Also, I’d like to know if there is a way to automate for a daily update and keep the previous data stored (yesterday’s for example)

    Thanks you in advance

    Reply
    • You can choose your metrics from the fields listed in the documentation. If you’re looking for information on tracking specific actions on your site like purchases, you can include something like https://graph.facebook.com/v7.0/act_ID/insights?fields=actions,cost_per_action_type&access_token=TOKEN. (add a filter or switch to compact mode to make it easier to read)

      Reply
  8. Hi Ana and great site! I’ve been playing around the API Connector and it’s been working great but when I tried to add any information about ad sets, ad ids, etc, it seems to completely ignore it. Much appreciated!
    https://graph.facebook.com/v7.0/act_id/insights?date_preset=lifetime&fields=reach,clicks,adset_id,adset_name,ad_id,ad_name,spend&time_increment=1&access_token=

    Reply
    • Also Ana, what I would really like to track are results and it seems like offsite_conversion is specifically what I need but there seems to be a custom number attached to each event. Not sure if that can be had. link_click would be helpful in place of offsite_conversion if that’s not available. Cheers!

      Reply
      • That sounds like a custom conversion. One of the example URLs is a request for “offsite_conversion.fb_pixel_purchase” (number of purchases), and the only number returned is the number of purchases. Is that what you’re looking for?

    • Thank you! Your request is missing the parameter &level=ad, so that’s why it won’t work. You’ll need to include that parameter if you’re pulling ad-level metrics like ad ID and name.

      Reply
  9. Thanks Ana! I thought all of my offsite conversions had custom numbers but there are actually only two types: offsite_conversion.custom.2384461294947489 or offsite_conversion.custom.410251349618741. So the question is, can the API Connector show me my daily count of offsite conversions? Thanks again!

    Reply
    • Yep, you need to add the time_increment=1 parameter.
      So the whole thing would be like this: https://graph.facebook.com/v7.0/act_111111111111111/insights?date_preset=last_7d&fields=actions&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]&access_token=token&time_increment=1

      Reply
  10. Hello Ana, I have joined the family for a week now, so far has been so great! Thanks!
    However, there’s one thing about this Facebook api bugs me. The time zone is always in GT-8 time zone, and I’m in Auckland (GT+12), how can I convert the time(data » date_start) and date to my local time?

    Thanks!

    Reply
    • Hi James! I’m glad you like API Connector 🙂 It’s rather hidden, but Facebook’s documentation says “We report ad insights data in the ad account’s timezone.” Therefore, please check the timezone your ad account is set to. You should be able to view that at this URL: https://www.facebook.com/ads/manager/account_settings/information.
      The default is GMT-8 (Pacific time), so this is probably the reason you’re seeing that time zone from the API. If you have admin access to the FB Ads account, you can change that value to your local time.

      Reply
  11. Hi, how much would it cost for you to set this up for me? We’re currently considering Supermetrics / Monday.com / Integromat as a software stack but we’re looking to avoid these software applications completely by pulling the data directly from Facebook’s API. Please email me with a quote if you can help, thank you very much!

    Reply
  12. Hi Ana,

    Thank you so much for this documentation! It really helps.

    I just have one thing to raise: Is this realtime data that gets displayed on Sheets or is there an auto update? If so, how often does the update happen?

    Thank you so much again!

    Reply
    • Hi Alex! Thank you for the comment, I’m glad you like the article.
      The data is up to date at the moment you pull it, and you can run the request manually at any time to get newly refreshed data. Alternately you can set up scheduling (paid feature) to run the requests automatically on a schedule. Please let me know if that answers your question.

      Reply
  13. hi there, I followed your guide and the integration was super cool and worked fine for the last couple months. Today, however, I keep getting server error 400 when I send a new API. What could that be?

    Reply
    • Hi there, a 400 error generally means there’s an error with how you’ve entered the request (info). Since the error just started, it’s likely related to an expired token. If you click ‘show response’ in the footer of API Connector, you should be able to see the exact error message from Facebook.

      Reply
  14. Hi Anna,

    thanks so much for the detailed explanation. I have one issue, which I can’t solve with google.
    The format of numbers is very weird.

    Example:
    CTR in FB-ads-manager is 5,76%. In Google Sheets it’s 5.781.521
    Costs in FB-ads-manager is 78,37€. In Google Sheets it’s 78.37

    Language of sheets is german.
    I already tried to change the format, but nothing helped.

    Do you know the solution to this?

    Thanks!
    Niklas

    Reply
    • Someone above had this issue too. I’m not sure but I think it’s related to the locale of the sheet. Can you please try changing it to the United States to see if it helps? The setting is located under File > Spreadsheet Settings > Locale.

      Reply
      • Oh, no worries, I didn’t expect you to have seen it. And that commenter never responded to say if it worked or not, so I wasn’t sure, haha. Thank you for coming back with an update!

  15. Hi Ana,

    I only need specific regions which got conversions for this month. I tried; but it is not working for me.

    Please check the below URL:

    https://graph.facebook.com/v7.0/act_XXXXXXX/insights?action_attribution_windows=['28d_click','28d_view']&action_report_time=conversion&date_preset=this_month&fields=actions,action_values&time_increment=1&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]&level=campaign&access_token=XX

    Reply
      • Hi Ana,

        I am trying to add region field in the URL so that I can get revenue details regionwise.

        E.g. when I am using this tag – time_range={"since":"2020-07-01","until":"2020-07-01"}&action_attribution_windows=['28d_click','28d_view']&action_report_time=conversion&fields=campaign_name,actions,action_values&time_increment=1&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]&level=campaign

        I only get information about orders and its value; but I also information about from Which region I got that order.

        Please help.

      • Your new URL above seems to have some problem unrelated to region, it gives me an error. But assuming you have a working request URL, you add “region” as a breakdown element, like this: &breakdowns=["region"]. For reference, multiple breakdowns would be added to the array, e.g. &breakdowns=["age","gender"].

  16. Hi Ana,

    I’m trying to get the following columns to populate:

    Spend, Link Clicks, Impressions, Add to Carts, Checkouts Initiated, Purchases, and Purchase Conversion Value for 1 day click, 7 day click, 28 day click, and 1 day view windows on the ad level by day for the past 7 days. This is the URL I have so far, and it is not working (just says unknown error occurred). Could you help troubleshoot?

    https://graph.facebook.com/v7.0/act_*****/insights?action_attribution_windows=['28d_click','1d_view','1d_click','7d_click']&action_report_time=conversion&date_preset=last_7d&time_increment=1&level=ad&fields=campaign_name,adset_name,ad_name,impressions,inline_link_clicks,spend,actions&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase','offsite_conversion.fb_pixel_add_to_cart','initiate_checkout']}]&access_token=******&limit=5000

    Reply
    • The problem seems to be that your request can’t be broken down to such a granular level. It works when I replace level=ad with level=campaign, can you please try that?

      Reply
  17. Hi Ana,

    I tried this 2 weeks ago and was getting each campaign in a separate row, however now it’s not working and I am only getting all ads data in one single row which is no good. Here’s my query without the identifiers:

    https://graph.facebook.com/v7.0/act_REMOVED/insights?date_preset=this_month&fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,reach,impressions,outbound_clicks,cost_per_outbound_click,outbound_clicks_ctr,actions,spend&access_token=REMOVED&sort=["campaign_name_ascending"]&limit=1000

    Thank you!

    Reply
    • Hey Amy, it sounds like you may have inadvertently switched your report style back to the default single-row style.
      Under Output Settings, please click Output options > Report style: compact to see if that resolves the issue.

      Reply
  18. Hi Ana,

    This is really a great article, which can make Facebook Ads numbers appear on Google Sheet, and it really helped me a lot in my work. I have a question about connecting accounts, can I extract campaign’s data of all accounts in the my Facebook Business Manager through one API request? I hope that campaign spending of all accounts in one Business Manager can be presented on the same sheet. The request URL in this article seems to be designed for a single Ads account using. Was wondering whether you can help me to adjust the requested URL?

    Thank you very much!

    Reply
    • Thanks, Murphy, I appreciate the nice comment! Unfortunately you can’t pull data from multiple accounts at the same time, as the Facebook API only allows for a single account ID. You would need to duplicate your requests, substitute in different account IDs for each request, and then aggregate them together into a single sheet (you should be able to do that using Sheets functions like VLOOKUP() and QUERY() ).

      Reply
      • Hi Ana, thanks a lot for this great tutorial. In that particular case – pulling data from multiple ad accounts – will it be necessary to generate one access token for each request, every 2-3 months, or only one access token is needed for my App?

      • Hi Patrice, you only need one access token. It’s tied to the user, so it will provide access to all the accounts that the user — you — has access to.

  19. Hi Ana,

    Thanks for the post. Really helpful.

    I am looking to pull inlcude paused campaigns in my data pull. Do you have an idea on how I can acheive this?

    Reply
    • Nice, I’m glad it’s helpful 🙂 All campaign types including paused campaigns should be included by default, at least I don’t see anything in the docs indicating that they’re not. Are you seeing something different?

      Reply
  20. I’ve been looking for something like this product for *soooooooo long*
    I’m sooo happy. really.

    and this tutorial is amazing. and it’s working.

    what can I say? You got yourself a loyal customer.
    keep rockin’

    Reply
    • Oh, this is a really nice comment, thank you! I’m interested to know whether you were looking for a tool to get FB data specifically, or just for an API connection tool in general.. sent you a message 🙂

      Reply
  21. hi – super excited about this add on but when I import my FB ad data (append it) it randomly puts it into different columns, making it unusable as an automatic tool for syncing reports (also, because the numbers aren’t distinct I don’t know what order it’s putting the columns in!)

    Any idea why this is happening to me?

    Reply
    • Hey Rob, this happens because the FB API doesn’t return fields when they contain only null values. So if one of your fields contains data one day, but not the second day, Facebook won’t include it at all on day 2, which shifts around the order of columns.

      To address this, you can limit your requests to pull just the fields that always contain data, you can use a Sheets formula to pull in data to a second sheet with fixed column headers, and/or you can use JMESPath filtering to lock response fields into certain columns regardless of the underlying API response. You can see more detail about this issue here: https://mixedanalytics.com/knowledge-base/troubleshooting-api-requests/#num3

      Reply
  22. From the Facebook Marketing API, how could you get the exact attribute an ad is charging for? in cost_per_action_type it sends me a list, but I don’t know exactly why they are charging me.

    I would appreciate a help with this problem.

    Reply
    • I’m not totally sure I understand your question, the response should contain each action type and its value. Can you use filtering to get the action types you’re looking for, like this? &filtering=[{field: "action_type",operator:"IN", value: ['mobile_app_install']}]

      Reply
    • Conversion actions like installs are shown under the “actions” field, so you need to add “actions” to your list of fields and include a filter for the action you’re interested in (if you’re not sure of the action name, then first pull all the actions and add your filter after). The question above this one has an example of that.

      Reply
      • Thanks for your prompt reply…..

        this is my code:
        https://graph.facebook.com/v8.0/*******/insights?date_preset=this_month&time_increment=1&level=ad&fields=campaign_name,adset_name,ad_name, impressions,reach,clicks,ctr,cpc,cpm,cpp,spend&fields=actions&filtering=[{field: "action_type",operator:"IN", value: ['mobile_app_install']}]&access_token=**************

        it’s not showing the all value filed.

      • That looks all right to me. Facebook doesn’t display null values, could that be the issue? Feel free to share your sheet if you’d like me to take a look (email support at mixedanalytics.com)

  23. Hey Ana ! Thanks for the great tutorial.
    I just want to know if I can access Leads of my Facebook ads through this method or not ?
    Is there any way to automate leads from Facebook Ads to Google sheets without using third party integrations like Zapier etc ?

    Reply
  24. Nice Article, Ana!

    But i am getting the below error.

    {“error”:{“message”:”Invalid OAuth access token.”,”type”:”OAuthException”,”code”:190,”fbtrace_id”:”AsnC2jHPNAav8JXp_7090vx”}}

    Can you pls help me in understanding this?

    Reply
  25. Hi Ana, I’m really so happy to read this article. It really helps me so much to start get data from Facebook optimize fee in this time.
    Special that your example URL. But when I tried to add more fields is Error or not get data.
    Can you show me how to mix 2 this example:
    https://graph.facebook.com/v8.0/act_YOUR_ACCOUNT_ID/insights?date_preset=last_7d&time_increment=1&level=ad&fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,account_currency,impressions,reach,clicks,ctr,cpc,cpm,cpp,spend,social_spend&access_token=YOUR_ACCESS_TOKEN

    And
    https://graph.facebook.com/v8.0/act_YOUR_ACCOUNT_ID/insights?date_preset=last_7d&fields=actions&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]&access_token=YOUR_ACCESS_TOKEN

    Because I wanna get important field as ad_id, ad_name, spend, Post Comments, Messaging Conversation Started, Cost per Messaging Conversation Started, Messaging Replies. Please help me with an example ♥. Thank you, Ana

    Reply
    • Hi Phuc, you should be able substitute in the specific action type you’re interested in. All possible action types are listed here. So I think it would look like this:
      https://graph.facebook.com/v8.0/act_111111111111111/insights?date_preset=last_7d&fields=ad_id,ad_name,spend,actions&level=ad&access_token=YOUR_ACCESS_TOKEN&filtering=[{field: "action_type",operator:"IN", value: ["onsite_conversion.messaging_conversation_started_7d","onsite_conversion.messaging_first_reply","post_reaction"]}]

      Reply
  26. Hi Ana,

    Great tutorial.

    Everything is working fine, but when i use it for a live campaign the api is not giving the live stats and seems to be only updating once a day?

    I see this when i open ads manager and see different results there than from the api

    Any way around this

    Reply
      • Hi Henrik, in my own tests the data has always matched, and I’m not aware of any delay between the API and FB Ads Manager. Maybe you’ve found a bug on Facebook’s end, but I’d also double-check that you’ve set your request up with the same exact conditions (metrics, time, attribution window) as your report in FB Ads Manager. In this Stack Overflow post you can see someone else with the same issue you’re having, and they resolved it by changing their attribution windows.

  27. Hi Ana,

    Thank you for this insightful documentation! This really helped with my weekly reporting for the company i work at.

    However, i have trouble to get my conversion data into sheets. We have 3 different custom conversions. I used the template from this blog and tried to change the conversion type, but it doesnt show the right conversions.Right now it only shows purchases, but we don’t use this goal.

    Could you please help me out? Every other metric comes out fine, i only have problems with the conversions. Thanks in advance and i hope to hear from you soon!

    -Jael

    Reply
    • Hi Jael, you should be able to substitute in the conversion you’re interested in. The entire request would then be something like this:
      https://graph.facebook.com/v8.0/act_YOUR_ACCOUNT_ID/insights?date_preset=last_7d&fields=campaign_name,impressions,reach,clicks,spend,actions&level=campaign&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.YOUR_CONVERSION']}]&access_token=YOUR_ACCESS_TOKEN

      Reply
      • Hi Ana,

        Thanks for the fast and extensive response! The thing i dont understand is what to fill in at ‘offsite_conversion.YOUR_CONVERSION. Should i replace ‘YOUR_CONVERSION’ with the custom conversion id? Or should it be the name of the conversion? For example the name of the conversion is ‘Registration bootcamp’.

        Thanks again, i hope my explenation is clear!

        – Jael

      • You should replace it with your custom conversion ID. To find your ID, you can open up FB Business Manager, click Events Manager, then click Custom Conversions in the lefthand sidebar. You’ll see a list of custom conversions and their IDs. So then you would substitute in that value, like offsite_conversion.custom.398028550584411

        If you don’t have immediate access to FB Ads Manager, an alternate method is to run this request:
        https://graph.facebook.com/v8.0/act_1111111111111/insights?fields=actions&access_token=+++'Tokens'!B1+++
        It will return a list of all your conversions and custom conversion IDs, but it won’t include their name. Still, it could work if you only have one or two custom conversions and are able to identify them.

      • Hi Ana,

        Thank you so much, it worked :D. This is amazing. I used the custom conversion id from FB Business manager.

        I have one more question, we have a total of 3 custom conversions, how should the request look like if i want to include all 3 of them?

        Thanks again!

        – Jael

      • woohoo, I’m glad it worked! So, you have two options here:
        1) Run them separately. I think this might be best because the output can get complicated when you’re looking at multiple conversions in a single response.
        2) Run them together. In that case your query would look like this:
        &filtering=[{field: "action_type",operator:"IN", "value":["offsite_conversion.custom.398028550584411","offsite_conversion.custom.123456789","offsite_conversion.custom.987654321"]}]

        You can try the second one and see what you think, and if the output is too complicated try the first one 🙂

  28. Hey,

    This API request I have created starting of this month after running smoothly now it’s throwing error –
    i.e.
    Status
    Request failed: The server responded with an error (500) show response
    {“error”:{“code”:1,”message”:”Please reduce the amount of data you’re asking for, then retry your request”}}

    Is there any data limitation I should know about?

    Reply
    • This error message comes from Facebook itself. FB doesn’t seem to provide any documentation on it, but based on some comments here, their limits aren’t based on specific numbers, but rather on how many resources it takes to get the data. You can reduce the amount of data you’re asking for by using the limit parameter or using date parameters like since and until.

      Reply
  29. When we create the token manually and copy it for use in the API Connector, where exactly do we put it in the API Connector? I’ve tried a few things and they haven’t worked.

    Reply
    • Once you have your token, you can use it by appending it to any API URL, like https://graph.facebook.com/v8.0/act_123456789012345/insights?access_token=YOUR_ACCESS_TOKEN.

      Reply
    • Thanks, I’m glad you like the article. You would just need to run your query twice, once for a 3 day period and once for a 7 day period, like this:
      3 days: https://graph.facebook.com/v8.0/act_1111111111111/insights?fields=campaign_name,adset_name,spend,actions&level=ad&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]&date_preset=last_3d
      7 days: https://graph.facebook.com/v8.0/act_1111111111111/insights?fields=campaign_name,adset_name,spend,actions&level=ad&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]&date_preset=last_7d

      That will pull in the raw data to your sheet, and you can then reconfigure it however you like to make it match your desired dashboard output.

      Reply
      • Hi Ana, Thanks for your reply. But I want to display my conversion column. I use the below URL but display an error.

        https://graph.facebook.com/v8.0/act_XXXXX/insights?date_preset=last_3d&fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,actions&access_token=XXXX&filtering=[{field: "campaign.id",operator:"IN", value: ['Conversion ID']},{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]

        Fieza

      • Hi Fieza, what does your error message say? That usually identifies the issue.
        Also I don’t see any “level” parameter in your URL. If you’re breaking out data by adset name, you will need to include level=ad.

      • Thanks Anna.

        How I can display my conversion column? I using this request.

        https://graph.facebook.com/v8.0/act_XXXXX/insights?date_preset=last_3d&fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,actions&access_token=XXXX&filtering=[{field: "campaign.id",operator:"IN", value: ['Conversion ID']},{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']}]

        Is my request wrong? It display “Request processed, no records found”. I’m sure my account and conversion id are right.

      • Hmm, maybe Facebook doesn’t accept an array filter for campaign name. Also your request URL is missing the “level=ad” parameter. Can you please try the following instead, substituting in your campaign ID where it says 1234567? Let me know if this works better.

        https://graph.facebook.com/v8.0/act_111111111111111/insights?date_preset=last_3d&fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,actions&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_purchase']},{field: "campaign.id",operator:"CONTAIN", value: '1234567'}]&level=ad&access_token=XXXX

  30. Hey there,

    Very good article, thank you for making it. I am trying to create an API URL for my Google Sheet reports, but need very specific requirements to get the Facebook data I need. Since my developer skills are not great I was wondering if I might be able to get help with creating a URL with the following requirements:

    Metrics
    – Impressions, Link Clicks, Add To Cart, Initiate Checkout, Purchases, Revenue, Amount Spent, Attribution, 28 Days Click, 7 Day View

    Date Range
    – Lifetime (Broken down by Mon to Sun), Basically being able to see each week’s performance over the lifetime period

    Is this something can be possible to create?

    Reply
    • Thank you, I’m glad you like the article! You don’t need any developer skills for this, but since your requirements are rather specific and complex, you need to be comfortable reading API documentation to construct your queries. Otherwise, I suggest picking a different tool that doesn’t require working with the API directly (if you search the Google Marketplace for “Facebook” you can find a few).

      With that said, something like this should work to pull in the raw data for your query.
      https://graph.facebook.com/v8.0/act_11111111111/insights?fields=impressions,clicks,spend,actions,action_values&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_add_to_cart','offsite_conversion.fb_pixel_initiate_checkout','offsite_conversion.fb_pixel_purchase']}]&action_attribution_windows=["7d_view","28d_click"]&date_preset=lifetime&time_increment=7&limit=5000

      Reply
      • Hey Ana,

        Thank you that is exactly what I was looking for!

        The data currently pulls from Friday to Thursday for the 7 day period within the lifetime range. In order to get it to do Mon to Sun would I need to run the request on a certain day of the week? or is there a way to filter the code to make it pull Mon to Sun each time?

      • Good question… I could be wrong, but I don’t see anywhere to specify the week start date when you’re pulling for date_preset=lifetime. If you used the since and until parameters you could choose the day of week you wanted to start on, but only 90 days of data can be pulled when using since and until. So it’s probably easiest to just wait and run this request on a certain day of the week. Alternatively, you could pull it for all days (time_increment=1 instead of time_increment=7) and do your weekly aggregation yourself.

  31. Hi Ana,

    Thank you very much for the article, but I stumble on a problem, can you please point me where i did wrong? By the way, I am not a coder, so it would be very helpful if you explain it in simple terms. Thank you so much 🙂

    I try to add “yesterday” date to the fields, and i use this URL https://graph.facebook.com/v8.0/act_xxxxxxxxxxxxxxxxx/insights?date_preset=yesterday&fields=date_presets{yesterday},spend,reach,impressions,click

    Reply
    • Hi Adya, thanks for the message. Date presets aren’t added into the “fields” parameter. Please try the following instead:
      https://graph.facebook.com/v9.0/act_xxxxxxxxxxxxxxxx/insights?date_preset=yesterday&fields=spend,reach,impressions,clicks

      Reply
  32. When I added a JMES Path it accurately organized the data in the correct columns. Except for ‘Spend’, that value is coming back as a blank cell.

    I added a Screenshot and additional info below to help you with answering my question. Thank you in advance for your help with this!

    Screenshot: https://cln.sh/3eBqi9

    API URL Path: https://graph.facebook.com/v8.0/act_xxxxxxxx/insights?date_preset=yesterday&fields=impressions,frequency,inline_link_clicks,spend

    JMESPath: data[].
    {impressions:impressions,frequency:frequency,inline_link_clicks:inline_link_clicks,spend:spend
    [*] | [0].value,date_start:date_start,date_stop:date_stop}

    Reply
    • Hi Blake! You don’t need the | [0].value piece of this, that’s only for when you’re adding actions (since actions get returned as an array). Please try this instead and let me know if the results come through as expected.
      data[].
      {impressions:impressions,frequency:frequency,inline_link_clicks:inline_link_clicks,spend:spend,date_start:date_start,date_stop:date_stop}

      Reply
  33. Hello there!

    2 quick questions:

    Is there a way to add the page name in which the campaigns are set? Cause with 1 Ad Account I have 2 different pages linked in which I’m doing campaigns, so it would be good to know from which pages are the results coming.

    Also, can we see the locations (cities) for the results shown? Cause 1 campaign is set for different locations (one location for each Ad group) and I can’t see which cities are the ones that work better in each campaign.

    Reply
    • Hey Vaiana, sorry, I’m not sure about adding in a page name, I thought FB ads are just running on Facebook in general, not a specific page. So I think you’ll need to consult their docs for info on that. For location, you would add a breakdown, but I don’t see any way to break it down by city. The closest I see is region, like https://graph.facebook.com/v9.0/act_111111111111/insights?fields=reach,impressions,clicks,cpc,spend&breakdowns=["region"].
      You can see more info about breakdowns here: https://developers.facebook.com/docs/marketing-api/insights/breakdowns

      Reply
  34. Hi there,

    I’m trying to export the time of day (viewer’s time zone) as a breakdown but without success. Can you please let me know how to do that?

    Reply
    • Hi Francesco, please try this:
      https://graph.facebook.com/v9.0/act_1111111111111/insights?breakdowns=["hourly_stats_aggregated_by_audience_time_zone"]

      Reply
  35. Hi Ana, I need to extract the spend from every day ever since the ad account has been created, and it should be updated once a day moving forward. And unfortunately, I am stuck.

    https://graph.facebook.com/v8.0/act_xxxxxxxxxxxxxxxx/insights?fields=spend/&time_increment=all_days

    Reply
    • You should be able to get historical data with a query like this:
      https://graph.facebook.com/v9.0/act_1111111111111111111/insights?date_preset=lifetime&fields=spend&time_increment=1&limit=5000
      Going forward you can just switch your date_preset value to ‘yesterday’ and run it each day.

      Reply
    • Hi Milica! It is possible, but since Facebook is giving you the “Please reduce the amount of data you’re asking for” error message, you’ll need to split up your request into smaller bits.
      There are several ways you could do this, here is one way you can try:
      Request 1: https://graph.facebook.com/v8.0/act_xxxxxxxxxxxxx/insights?time_range={"since":"2019-01-01","until":"2020-01-01"}&fields=spend&time_increment=1&limit=500
      Request 2: https://graph.facebook.com/v8.0/act_xxxxxxxxxxxxx/insights?time_range={"since":"2020-01-01","until":"2021-01-01"}&fields=spend&time_increment=1&limit=500
      (and so on)

      Another method would be to set the limit to something smaller (e.g. limit=500) and then set up pagination handling as described in the article.
      Can you please try and see how it goes?

      Reply
    • You can add a filter to the end of your URL like this:
      &filtering=[{field: "campaign.name",operator:"CONTAIN", value: 'your_campaign'}]
      Substitute in your own campaign name where it says your_campaign.

      Reply
      • Their documentation is very unclear about this, but in my own tests I can only get the CONTAIN operator to work on campaigns. So I think you can only do this if you find a string that both of your campaigns contain. You can also test out some other operators like STARTS_WITH as shown here (all operators are listed under the entry for ‘filtering’).

  36. Hi, I’m Facebook Ads Marketer. I have a question:

    Can I get Data Bill Payment account or invoice payment?

    Because now I used “Sum amount spend” but it not good for charge fee with customer. I wanna get data payment in bill transaction to know exactly Facebook charge fee me and notify customers when the deposit is almost exhausted.

    Reply
    • Hi there, this page shows how to get invoices from the Facebook API. It says you would send a URL like this:
      https://graph.facebook.com/v10.0/Business_ID/business_invoices?start_date=2017-01-01&end_date=2017-04-01

      However it’s not that easy, since the page also says your account needs a finance role and your connection requires business_management scope, which is not provided by API Connector’s built-in Facebook Ads connection. So you would need to create your own app at https://developers.facebook.com/, and then add the permissions needed for the invoices endpoint. Hope that helps point you in the right direction.

      Reply
  37. Hi Ana,

    your API still uses version 8.0 as far as I know.
    I just received a mail from facebook that apps using version 8.0 are not supported after May 2021.
    Do you have any plans to upgrade to version 9.0 or 10.0?

    Thanks for the API! It helps me a lot 🙂

    Thanks,
    Niklas

    Reply
    • Yeah, if your client has provided your account with access to their FB Ads account, you can access their data via FB Ads Manager or the API.

      Reply
  38. Hello,
    Could you help, please?
    I am pulling data using … &time_increment=1&date_preset=last_7d.
    Today is 03/30. But I am only getting data for the period 03/23 – 03/26. And no data for 03/27 – 03/30

    I have tried … &time_increment=1&time_range={“since”:”2021-03-24″,”until”:”2021-03-30″}
    The same problem – only getting data for the period 03/24 – 03/27. And no data for 03/28 – 03/30

    What could be the problem?

    Reply
    • I don’t see anything wrong with your request URL (at least the part you’ve shared) so if you aren’t getting data it’s because there is no data matching the conditions of your query. Can you please double check that you’re seeing data for that date range in the FB Ads Manager interface? If so then make sure you haven’t added any filters to your API request URL that would exclude data for those days, e.g. campaign name filters, device filters, action filters etc. It’s also possible that it’s related to attribution since default attribution via the API doesn’t automatically match what you’ve set in FB Ads Manager. If you’ve set an attribution window in FB Ads Manager you would need to explicitly set it in your request URL with a parameter like &action_attribution_windows=['1d_click','1d_view']

      Reply
      • Thanks for the reply. It still does not work for some reason.

        1) There is data in the FB Ads Manager interface for sure.
        2) I have cut my request to a very simple one, just to be sure that there are no filters.
        https://graph.facebook.com/v10.0/act_ХХХХХХ/insights?fields=campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,reach,impressions,clicks,inline_link_clicks,cpc,spend&level=ad&time_increment=1&date_preset=last_7d

        3) I have also tried adding attribution window to the request
        https://graph.facebook.com/v10.0/act_ХХХХХХ/insights?fields=campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,reach,impressions,clicks,inline_link_clicks,cpc,spend&level=ad&action_attribution_windows=['7d_click','1d_view']&time_increment=1&date_preset=last_7d

        with ['7d_click','1d_view'] that’s what I have in my campaigns

        If I use … &date_preset=last_3d, it correctly pulls data for the last 3 days

      • Well that’s pretty weird then, if it shows up when you do a last_3d date preset. Maybe it’s just getting cut off by Facebook’s 25 row limit. Can you please add &limit=1000 to the end of your URL and see if it makes a difference?

  39. Hi Ana!

    Thanks for such a helpful resource. I was wondering if you could tell me why I can’t get my date period to extend beyond 30 days. I am using the below script, and no matter what I put into date_preset I can’t get more than 30 days of data.

    https://graph.facebook.com/v10.0/act_573612180245821/insights?date_preset=last_90d&fields=campaign_name,account_name,campaign_id,actions,reach,impressions,clicks,cpc,spend&filtering=[{field: "action_type",operator:"IN", "value":["offsite_conversion.fb_pixel_purchase","offsite_conversion.fb_pixel_add_to_cart"]}]&time_increment=1&level=campaign&limit=5000

    Thank you!

    Reply
    • Hi Peter, thanks for the message and sorry you’re having trouble with your request. However, I just tested your request URL and it retrieved the past 90 days of data as expected. Therefore, I don’t think there’s any issue with the request itself, and I’m thinking about what else could be the problem. Do you have more than 5000 rows of data by any chance? Or any JMESPath filter on your request? Do you see more than 90 days of data in FB Ads Manager?

      Reply
      • Strange…I don’t have more than 500 rows of data, and I do have more than 90 days of data in ads manager. I will look into any JMESPAth filters I may have on my request.

      • Can you also try removing the filtering part of your request to see if that makes a difference? Basically, try to simplify and isolate what could be producing the problem.

  40. hey there

    Very good article, thank you for making it. I am trying to create an API URL to read all the data from form id, but I am getting no response.
    Kindly suggest how can I fetch all the columns and data.

    Response
    {
    "data": []
    }

    URL: https://graph.facebook.com/v10.0/{form-id}/leads?access_token=

    Reply
  41. Hello!

    I am in love with the API Connector, however I am trying to do one thing that I find impossible to do. Could you give me a hand?

    I would like to create a column to show an action, for example lead or like.

    For example: when I use https://graph.facebook.com/v9.0/+xxxxxx/insights?fields=account_name,campaign_name,actions,action_values&time_range={"since":"2020-01-01","until ":"2025-03-31"}&level=campaign&limit=50&filtering=[{field:"action_type", operator: "IN", value: ['like', 'comment', 'lead']}], I believe 6 Columns disordered according to action, one column is called data »actions» 1 »action_type with the value lead and another data» actions »1» value with the value number of like.

    Could you create a column called “lead” which contains the lead number?

    I hope I have explained myself 🙂

    Thanks!

    Reply
    • Hey Daniel, thanks for the comment, I’m glad you like API Connector 🙂
      If I’ve understood correctly, this is the issue discussed under the section called Set Column Order. When you select multiple actions, Facebook will send that data back in all different orders. The best way to deal with this is use a JMESPath expression, for example this one would create separate, fixed columns for likes, comments, and leads:
      data[*].{account_name:account_name,campaign_name:campaign_name,likes:actions[*] | [?action_type=='like'] | [0].value,comments:actions[*] |[?action_type=='comment'] | [0].value,leads:actions[*] |[?action_type=='lead'] | [0].value,date_start:date_start,date_stop:date_stop}

      Otherwise you can try pulling one action at a time, or switching to compact or grid style to make it a bit easier to read. Hope that helps, just let me know if you still have questions.

      Reply
      • Yes, it’s what i need! Thank you!

        On the other hand, when I use date_start and date_stop, I get the dates that I use to filter, I mean: time_range = {"since": "2020-01-01", "until": "2025-03-31"}.

        I would like to indicate the exact day when the campaign started and when it ended, but in “date_start” I see 2020-01-01 and “date_stop” the date of today.

        I have tried https://graph.facebook.com/v9.0/xxxx+/campaigns?fields=name,objective,status,start_time,stop_time and it works correctly as I need. But, when using two different queries (/ insights and / campaigns), everything appears in different lines.

        Could you help me? 🙂

        I hope I have explained myself correctly.

        All the best.

      • Hey Daniel, that’s how Facebook returns date data so we can’t do anything about that. However you can create your own summary dashboard with a VLOOKUP (or similar) function to match the 2 data sets together and pull in campaign start/stop dates into the same sheet as your insights data. Just let me know if you need further clarification.

  42. Hi Ana.
    Please help me!

    I get an error and cannot get the data from late April.
    error message;
    Completed with errors
    – Server responded with an error (500) show response{“error”:{“code”:1,”message”:”Please reduce the amount of data you’re asking for, then retry your request”}}

    I use;
    https://graph.facebook.com/v10.0/act_+++account!C2+++/insights?time_range={"since":"+++account!B6+++","until":"+++account!B8+++"}&level=ad&fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,impressions,inline_link_clicks,inline_link_click_ctr,cost_per_inline_link_click,spend,actions&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_complete_registration','offsite_conversion.fb_pixel_lead','onsite_conversion.lead_grouped']}]&access_token=+++account!E2+++&time_increment=1&limit=500

    Thank you!

    Reply
    • Hi Yoshi! 🙂 I think the error message says it all: you need to reduce the amount of data you’re asking for and then try again.
      The simplest way is probably to just reduce your date range. You could break it into a couple different requests and then merge the data back together at the end. Alternatively, you could pull fewer metrics, or pull one action at a time, or perhaps choose level=campaign instead of level=ad if you don’t need that level of detail. Basically Facebook doesn’t like it when we try to extract too much data at once…

      Reply
  43. Hi Ana.
    Please help me!

    Is it possible to pull data for FB Ad Accounts Failed Payments? I’m new to API and don’t know how to set up this.

    Thanks in advance,
    Mye

    Reply
    • Hi Mye, this article is about getting advertising metrics, but it sounds like you’re looking for data about your account, right? So I am not really sure, but I just searched online and didn’t find anything information about that. If there is any relevant endpoint I suppose it would be in Facebook’s Business Manager API, so you can poke around there and see if there are any relevant data points I missed. Hope that helps!

      Reply
      • Hi Ana,

        Thank you so much for your reply, yes me too can’t find information about that. Will definitely check the Business Mgr API.

        All the Best!

  44. Hi Ana,

    First of all congratulations on such a great product, I’ve been looking for a while for something just like this and I’m thrilled of all the possibilities I have thanks to this API Connector.

    I’ve successfully been able to get all FB Ads information on a daily basis and going through the results, I’ve found out that the total actions for the events on the action_type field are not the same totals found on FB Ads Manager directly. Doing some research, I think this is due to new iOS 14 policies and I’m wondering if there’s a way in which I can get the total amount of actions for the conversions through the API Connector.

    What I’ve understand so far is that it can be possible but I’m not sure how to get iOS conversion actions information through the API Connector.

    Thanks in advance,
    Santiago

    Reply
    • Hey there, thank you for the nice comment!
      Yeah, at the end of April, Facebook changed its attribution changes to comply with iOS 14.
      Based on their docs, I think you now need to add &use_unified_attribution_setting=true to the end of your API request URL. This will force the data to use the attribution setting of the ad being queried, and should result in data matching between Ads Manager and the API response. Please try and let me know if it works for you.

      Reply
  45. Hi There

    I got the message: “Completed with errors – Server responded with an error (400)” When trying to connect to pull Facebook Ads marketing data… Any idea how to fix this?

    Reply
    • The detailed error is here: “{“error”:{“message”:”Unsupported get request. Object with ID ‘act_123456789012345’ does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at https:\/\/developers.facebook.com\/docs\/graph-api”,”type”:”GraphMethodException”,”code”:100,”error_subcode”:33,”fbtrace_id”:”AHzSs70GnGnPvk7oXCBssF-“}}”

      Reply
  46. Hi Ana,

    This is really helpful and thank you for the great explanation.

    I have one issue with filtering, it seems on certain dates where we have 0 value for metrics like ‘comment’, the API will not show that metric on google sheet, so it breaks the report format.

    How do we add more filtering like the value should be >= 0 or make sure FB show all metrics although it’s 0?

    I have below for the filtering
    filtering=[{'field': 'campaign.name','operator':'CONTAIN', value: 'XXX'},{'field':'action_type','operator':'IN','value':['spend','like','comment','post_reaction','post','onsite_conversion.post_save','video_view','photo_view','page_engagement','post_engagement','app_install','landing_page_view','link_click','landing_page_view','offsite_conversion.fb_pixel_add_to_cart','impressions','reach','video_play_actions','video_30_sec_watched_actions','video_avg_time_watched_actions','video_p100_watched_actions','video_p25_watched_actions','video_p50_watched_actions','video_p75_watched_actions','video_p95_watched_actions']}]&limit=1000`

    Reply
  47. Hi, i have some questions about your url builder.

    1) Can i choose data only for one campaign or it is only possible for all of them at the time?
    2) When i choose conversion (purchase) and try to get cost per action, action value and roas this data arent showing in my google sheet.
    3) I got the this error several times in a row and exactly dont know how to solve this because my limit is now 500 {“error”:{“code”:1,”message”:”Please reduce the amount of data you’re asking for, then retry your request”}}

    Can you help me with that?

    Reply
    • 1) You can add in filters for your campaigns. Please see here, the final example shows how to filter for a specific campaign.
      2) If those values don’t show up, it means those values don’t exist for the selected Action. You can test some of the other similar Actions (e.g. “Grouped Action: Purchases”) or make an API request to https://graph.facebook.com/v10.0/act_YOUR_ACCOUNT_ID/insights?fields=cost_per_action_type,action_values,purchase_roas to see what Actions are available for each of those metrics.
      3) That error message comes from Facebook, so unfortunately I can’t really say much more than they did: you’ll need to reduce the amount of data you’re requesting at once. You might need to reduce your date range or number of parameters, or try an even lower limit like 100. I would experiment with reducing your request until you do get data back, and then add complexity back to your query to see where it fails.

      Reply
      • Thank you. I also have problem like this

        Server responded with an error (400) show response{“error”:{“message”:”(#2635) You are calling a deprecated version of the Ads API. Please update to the latest version: v11.0.”,”type”:”OAuthException”,”code”:2635,”fbtrace_id”:”Ai6GRn7bfD1C4uqWoi-OFAN”}}

        But dont understand what should i update. Can you help me please?

      • Looks like Facebook updated its API version today (their schedule). Are you connecting through an API token or through OAuth2? If OAuth2, we automatically handle the version number so you shouldn’t have this issue. Otherwise, you can just change your base URL from graph.facebook.com/v10.0/ to graph.facebook.com/v11.0/.

  48. Also, can you write me an email how much it will be cost to install it for me? I study it for 2 days but i have some problems i cannt really solve

    Reply
    • How about trying a different tool like Supermetrics that doesn’t require working with the API directly? Big platforms like Facebook have plenty of specialized connectors (just click Add-ons > Get Add-ons and search for “Facebook”). Those connectors don’t require creating your own API URL, so they will be simpler to use.

      Reply
  49. Hello, i’m having trouble using the pagination.
    Ive used the excat same set-up described in the article but it does not work. can you help?
    – added the &limit=5000 in the API request
    – pagination : cursor
    – Next token parameter : after
    – Next token field : paging.cursors.after

    Reply
      • If it’s only showing the first 25 requests, that means it’s not recognizing your limit parameter. Please double-check that you’ve constructed the URL correctly (make sure you have no extra spaces, and that parameters start with a ? mark, etc).
        If you can copy and paste in your entire URL I can take a look.

      • Sorry, I was using the wrong API call it’s me/adaccounts and not me?fields=adaccounts 🙂 every thing is fine now
        thanks again

  50. My comment did not paste correctly. This is the URL I’m using https://graph.facebook.com/v10.0/me?fields=adaccounts&limit=5000&access_token=XXX
    – added the &limit=5000 in the API request
    – pagination : cursor
    – Next token parameter : after
    – Next token field : paging.cursors.after (also tried adaccounts.paging.cursors.after) but did not work either.
    either I have only 25 results, or I keep having the same results pasted over and over again.

    Thanks a lot!

    Reply
    • Not too sure since that’s not a Facebook API I’ve worked with, it might have a different limit. How about trying limit=100, or turning off pagination handling? You don’t really need it if you’re pulling so many records at once anyway.

      Reply
  51. Hi!

    Our data in Ads Manager only pulls the results that come as browser events. We have the server side data coming into our FB account via a server side CAPI (conversions API for FB).

    Unfortunately, all of the lead info that has been added to FB through server events does NOT show up in the spreadsheet that we have connected to mixed analytics API Connector.

    It does show up in Ads Manager.

    I did try your suggestion to others to add &use_unified_attribution_setting=true to the end of the API url, just in case, but that only makes the action (lead) data column pull blank.

    So it’s not an attribution issue.

    It appears to strictly be from when we set up and turned on server events. Any thoughts on how to pull that data also? Since it’s not technically a pixel event?

    Thank you.

    Reply
    • Hi Vicki! Good question. I’m not that familiar with the Conversions API but I think the issue might be related to the name of the action you’ve chosen. If you look at Facebook’s list of actions here, you can see that actions prepended by offsite_conversion come from the Facebook Pixel. So if you were using, say, offsite_conversion.fb_pixel_lead, that would pull only data tracked through the Facebook pixel, rather than data tracked through the server.

      So here are my suggestions:
      1) replace offsite_conversion.fb_pixel_lead with simply the word lead, in both your URL and JMESPath.
      This might resolve the issue, but if not it means that these actions aren’t tracked there either. In that case…
      2) open up FB Business Manager, click Events Manager, then click Custom Conversions in the lefthand sidebar. See if you can find your server events there, and, if so, note the custom ID number.
      3) run an API request to https://graph.facebook.com/v11.0/act_YOUR_ACCOUNT_ID/insights?fields=actions. Use compact mode to see a list of all the actions tracked by your account. See if you can find your leads data there.

      Sorry I can’t be more specific since I haven’t pulled conversions API data into Sheets before, and all the official documentation only refers to POSTing data to Facebook, rather than the other way around. Feel free to message me via support if you’d like to work on this together.

      Reply
  52. Hi guys! Thanks for the tutorial, I followed all the steps but I get this error:

    1) Completed with errors
    – Server responded with an error (400) show response
    {“error”:{“message”:”Unsupported get request. Object with ID ‘act_XXXXXXXXXXXXX’ does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at https:\/\/developers.facebook.com\/docs\/graph-api”,”type”:”GraphMethodException”,”code”:100,”error_subcode”:33,”fbtrace_id”:”AIn_XwAfTDga0rujxxxxxxxxx”}}

    Reply
  53. Hi Ana, thank you for a great blog post
    I have a couple of doubts:

    How can I include a column with the number of leads my campaigns are generating?
    I have try different way, just including “lead”, “action_type=lead” and also by filtering. But I think I have been typing something wrong. Could you tell me how to include it here:

    https://graph.facebook.com/v11.0/act_ACCOUNT/insights?fields=account_id,account_name,campaign_name,adset_name,ad_name,objective,reach,inline_link_clicks,inline_link_click_ctr,cost_per_inline_link_click,inline_post_engagement,spend&level=campaign&level=adset&level=ad&time_increment=1&time&limit=5000&date_preset=this_year&time_range={"since":"2021-01-01","until":"2021-01-31"}

    My second doubt, I created my app and token, now what? I past the token as de “API URL path:” in the API Connector but is not working.

    Thank you so much for your help

    Reply
    • Hi! I have managed to extract the leads.

      Regarding the token, it’s still not working. I get this error message:

      1) Completed with errors
      – Server responded with an error (400) show response
      {“error”:{“message”:”(#2635) You are calling a deprecated version of the Ads API. Please update to the latest version: v11.0.”,”type”:”OAuthException”,”code”:2635,”fbtrace_id”:”AiQ7t_Vl8E-wjXx6hcPBLQG”}}

      Reply
      • Great, I’m glad you’re able to access leads now.
        As for your error message, Facebook updates its API version regularly. It looks like you’re calling one of its deprecated versions, so please update your API request URL such that it begins with https://graph.facebook.com/v11.0/

  54. I’m trying to pull these metrics from my FB Ads account:

    https://graph.facebook.com/v10.0/act_XXXXXXXXXXXXXXXXX/insights?level=ad&filtering=[{field: 'action_type',operator:'IN', value: ['landing_page_view','onsite_conversion','link_click','like','photo_view','video_view','comment','post_reaction','post','post_engagement','page_engagement','lead']}]&fields=account_currency,campaign_name,account_name,adset_name,ad_name,reach,impressions,frequency,spend,cpm,inline_link_clicks,cost_per_inline_link_click,inline_link_click_ctr,clicks,cost_per_unique_click,cost_per_action_type,actions,conversion_values,cpc,ctr&time_range={"since":"2021-05-22","until":"2021-05-22"}&time_increment=1&limit=10000

    But even when I’m trying to pull for one single day, I am getting an error saying: “Please reduce the amount of data you’re asking for, then retry your request.”
    If I reduce the no. of metrics to just 1 or 2, I can see there are ~400 rows for the day.

    What am I doing wrong?

    Reply
    • Hey Walter, Facebook produces this error when you request too much data at once. I’m not sure exactly where their limits lie, but you’re currently requesting 12 different actions at once, 20+ different metrics, and 10,000 rows, so it’s a huge request. I would test pulling just a couple actions at once and reducing your limit to 1000, then you can increase the limit and add back complexity as you see where their limits kick in.

      Reply
      • Hi Ana,

        Thank you for the quick response. The response on this (if I keep only a couple of metrics) actually has only 400 rows. I think the problem is probably with the structure of the request?

        Per your advice, I set the limit to 10. And still got the “Please reduce the amount of data you’re asking for, then retry your request” message back.

      • It’s not (just) about the number of rows, it’s about how much their servers need to process on the fly and the total number of fields. Facebook’s documentation doesn’t contain any information about what exactly triggers this error but if you Google for your error message you can find many people discussing this. Since reducing the limit didn’t help, I suspect it’s related to the combination of all those actions and metrics. What happens when you remove all those actions except one or two? Or reduce your metrics?

    • For some reason, I can’t reply to your final answer, so just posting as a reply to my original question: If I keep only two metrics, I can pull the data. I think it is the “actions” that is breaking it—but those are link clicks etc. which are pretty important metrics to pull.

      Does the structure of the query itself appear to be ok?

      Reply
      • The structure of the query is totally fine. I agree it’s probably the total number of actions/conversions. As far as I’ve seen, people don’t usually track more than 2-3 of those at once. By default, Facebook Ads Manager itself only shows 2-3 actions, dependent on what column template you choose (their templates include “Performance”, “Setup”, “Delivery”, etc). How about duplicating those reports you see in Facebook Ads instead of pulling in everything at once? Or just copy/paste some of the example URLs in this article and start from there. I think you can also optimize your query, e.g. there’s no reason to have an action of “link click” AND a metric of “clicks”.

  55. Hi,

    I wanted to give this a shot but I’m stuck at the very first step. Whenever I try to connect the add on to facebook, I get an error message on facebook “Could not link API Connector for Ads to Facebook, You may not be connected to the network or we could not establish a connection with our server. Check your connection and try again later.”

    Any idea why that is ?

    Thanks

    Reply
    • Hey Julien, I haven’t seen this before but I just Googled the error message and found some people saying it’s related to your browser settings. Could you please try with a different browser? Also I read that it can happen if you just created your Facebook account within the past hour, any chance it’s a new account?

      Reply
      • Hi Ana, thanks for the very quick reply. I won’t get too much into boring details but indeed, I had to create a new facebook account for this. Went to get some lunch, came back, and it works now. Thanks again !

  56. Hi!

    I want to pull the number of times a video was played at 75%. Buy if I include an “actions&filtering” I don’t wet this KPI. Look, this is my URL:

    https://graph.facebook.com/v11.0/act_531771314822499/insights?fields=account_id,account_name,campaign_name,adset_name,ad_name,objective,reach,inline_link_clicks,inline_link_click_ctr,cost_per_inline_link_click,inline_post_engagement,video_p75_watched_actions,cost_per_action_type,conversions,spend,actions&filtering=[{field: 'action_type',operator:'IN', value:['lead', 'like', 'onsite_conversion.messaging_conversation_started_7d']}]&level=campaign&level=adset&level=ad&time_increment=1&time&limit=5000&date_preset=this_year&&date_preset=yesterday

    I don’t get any error, but either the 75% video plyaed

    Reply
    • video_p75_watched_actions is an action-based metric so you’ll need to include the corresponding action in your filter (where you’ve put ‘lead’, ‘like’, etc.). The action name is video_view.

      I also see a few issues with the structure of the URL. You should only set a single level (to tell FB which level you want to report on), a single date_preset, and remove extra parameters like &time&.

      Reply
      • Thank you a lot!

        Does this look fine to you?

        https://graph.facebook.com/v11.0/act_531771314822499/insights?fields=account_id,account_name,campaign_name,adset_name,ad_name,objective,reach,inline_link_clicks,inline_link_click_ctr,cost_per_inline_link_click,inline_post_engagement,video_p75_watched_actions,spend,actions&filtering=[{field: 'action_type',operator:'IN', value:['lead', 'like', 'video_view', 'onsite_conversion.messaging_conversation_started_7d']}]&level=adset&time_increment=1&time&limit=5000&date_preset=yesterday

        I still can’t pull the number of times a video was played at 75%

      • That looks right to me so I wonder if you just didn’t have any data yesterday. I would try simplifying your query to just the 75% video view elements and increasing the date range to see if they show up then, e.g.
        https://graph.facebook.com/v11.0/act_531771314822499/insights?fields=account_id,video_p75_watched_actions&filtering=[{field: 'action_type',operator:'IN', value:['video_view']}]&level=account&time_increment=1&limit=5000&date_preset=this_year

  57. Hi Ana!
    Im not sure how to use this URL to get the leads from a lead ads campaign:

    https://www.facebook.com/ads/lead_gen/export_csv/?id=&type=form&from_date=1482698431&to_date=1482784831

    Could you elaborate it?

    Reply
    • Hi Nazarrii, instead of directly adding your other data to your FB API output sheet, I suggest doing all your transformations and data merging in a summary sheet. The summary sheet can pull in your API data with a formula like =query(Sheet1!A:H), so it pulls in fresh data without overwriting your other data.
      Update: You can now set a starting cell to avoid overwriting your saved formulas.

      Reply
  58. Hi,

    I’m trying to pull ad set level data for the last 7 days using this query: https://graph.facebook.com/v11.0/act_XXXXXXXXX/insights?fields=campaign_id,campaign_name,adset_id,adset_name,impressions,clicks,spend&time_increment=1&level=adset&date_preset=last_7d

    I’m only getting the first 3 of the previous 7 days though, do you know why this is happening?

    On a seperate note, do you have anything similar to this for Microsoft Ads?

    Reply
  59. Hi Ana.
    Please help me!
    I get an error and cannot get the data today.
    error message;
    {“error”:{“message”:”(#100) Missing permissions”,”type”:”OAuthException”,”code”:100,”fbtrace_id”:”A7Whs5ymYcefTVWxLamrwLv”}}

    I use;
    https://graph.facebook.com/v12.0/act_+++account!C2+++/insights?time_range={"since":"+++account!B32+++","until":"+++account!B32+++"}&level=ad&fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,impressions,inline_link_clicks,inline_link_click_ctr,cost_per_inline_link_click,spend,actions&filtering=[{field: "action_type",operator:"IN", value: ['offsite_conversion.fb_pixel_complete_registration','offsite_conversion.fb_pixel_lead','onsite_conversion.lead_grouped']}]&access_token=+++account!E2+++&time_increment=1&limit=100&use_unified_attribution_setting=true

    Thank you!

    Reply
  60. Hi Ana,
    I have a question I was hoping you could help me with. I manage ad placements for 100+ facebook/instagram accounts & I’d like to have their monthly spends populate automatically for me in one sheet instead of me manually going in each day and keying it in. I’m getting tripped up a little bit though with crafting my API URL path. I would like it to always pull in the current month without me having to go in and key in the new month each month, if that makes sense? So I need something like [current month] where google sheets knows what month we’re in instead of me saying “{"since":"2021-10-01","until":"2021-10-31"}“. I also noticed that when I put “{"since":"2021-10-01","until":"2021-10-31"}” in my URL, that also populates in the cell. I want that to qualify the data I want, but don’t want to the date ranges pulling thru in the actual sheet…way to hide? Also, how do I get the API URL to add up the spends in the current month (assuming I have multiple campaigns running in a given month) instead of spitting out each campaigns data spend?

    Essentially need to know:
    -How can I roll up all campaign spends in a given month to give me one lump sum number
    -How to tell the URL I was the [current month] without actually qualifying what the current month is
    -How to ONLY have the lump sum spend populate in my sheet
    -How often does the data reload? Does it refresh automatically or do I have to run it daily?

    this is url I was working with if this helps: https://graph.facebook.com/v12.0/act_794801067272984/insights?fields=spend&time_increment=1&time_range={"since":"2021-10-01","until":"2021-10-31"}

    Reply
    • Hi Paige!
      -How can I roll up all campaign spends in a given month to give me one lump sum number
      https://graph.facebook.com/v12.0/act_1111111111/insights?fields=account_id,account_name,spend&date_preset=last_month
      -How to tell the URL I was the [current month] without actually qualifying what the current month is
      You can either use date presets like this_month, last_month, etc., or you can set up your dates with functions in cells, and then use those cells in your requests, e.g. https://graph.facebook.com/v12.0/act_88976240/insights?fields=account_id,account_name,spend&time_range={"since":"+++Sheet1!A1+++","until":"+++Sheet1!A2+++"}
      -How to ONLY have the lump sum spend populate in my sheet
      By default, API Connector will return whatever data comes back from the API, and Facebook sends back some “extra” fields like dates. If you only want to display certain fields, you could either pull the fields you need into a second summary sheet, or use a JMESPath expression to filter all the extra fields out. If you need help constructing that expression, feel free to send a message to support.
      -How often does the data reload? Does it refresh automatically or do I have to run it daily?
      You can refresh it manually by clicking Run or turn on scheduling to refresh automatically.
      Hope that helps clarify, just let me know if you have any other questions.

      Reply
    • I’m not really familiar with dark posts and couldn’t find any way to test (found some guides online but none of them matched the current interface / options in FB Ads Manager. Are dark posts still available?) Anyway assuming they’re a type of page post, I think you’d pull stats for them using the Facebook Page API.

      Reply
  61. Hi there! Is there also a way to pull the data from facebook lead ads directly in the sheet (name, email address, phone number,….)

    Looking forward to your reply!

    Reply
  62. Hi Ana,

    I’m looking to pull campaign data from ALL of my manages FB ad accounts. Is there a way to generate a single API URL path that would allow this? I have about 250 accounts I manage and would like reports generated for all of them in one place.

    Reply
    • Sorry, unfortunately Facebook’s API requires the account ID in the URL path, so it needs a separate URL for each report. You can probably find some tools specialized for Facebook that automate this for you though, I imagine other agencies also need bulk reporting.

      Reply
  63. Oh man, this might just be a lifesaver; I’ve been trying to build my own FB Ads connector in Data Studio and I think this covers all the pain points I was stuck on. Thank you, thank you, thank you!

    Reply
  64. Hi Ana,
    Yesterday I made my connection with Facebook and it worked. But today I see this error:

    {“error”:{“message”:”(#200) Provide valid app ID”,”type”:”OAuthException”,”code”:200,”fbtrace_id”:”…

    What should I do?
    Thanks a lot

    Reply
    • Sure, please try this: https://graph.facebook.com/v12.0/act_111111111111/insights?limit=1000&fields=spend&time_increment=1&time_range={"since":"2021-01-01","until":"2021-12-31"}

      Reply
  65. When I add the ad title

    1) 2: Completed with errors
    – We received an error from facebook.com (500) show response
    {“error”:{“code”:1,”message”:”An unknown error occurred”,”error_subcode”:99}}

    https://graph.facebook.com/v12.0/act_248762389092142/insights?fields=account_name,campaign_name,adset_name,ad_name,spend,impressions,clicks,ctr,actions,action_values,conversion_values,cost_per_inline_link_click,cpc,cpm,inline_link_click_ctr,inline_link_clicks,reach,purchase_roas,cost_per_action_type&limit=5000&time_increment=1&date_preset=yesterday&level=ad

    Reply
    • Facebook doesn’t clearly define this error message but it seems to be associated with requesting too much data at once. It also tends to be an intermittent error, so you may be able to resolve it just by waiting and trying again, otherwise you’ll need to request less data from their server.

      Reply
  66. Hello Ana, This is a very great work. By any chance do you have maybe a guide or an article on how to do all this using app script in google sheets? I was planning on creating functions in google sheet that can pull these data in into sheet cells. Hoping that is something you can help others like me.

    Reply
    • Do you have telegram account or any chat apps I can contact you maybe? I know I’m disturbing you but if you have some time to spare that would be of great help to me. If not, I understand no worries.

      Reply
    • function FBInsights2() {
      var access_token = 'XXXX';
      var url = 'https://graph.facebook.com/v13.0/'
      + XXXX
      + '/insights'
      + '?fields=clicks,cpc,spend'
      + '&access_token=' + access_token

      var response = UrlFetchApp.fetch(url);
      var json = response.getContentText();
      var data = JSON.parse(json);

      return data;
      }

      Above is what i’m trying to do but I get this error. If you have time kindly help me please. thank you in advance.

      Exception: Request failed for https://graph.facebook.com returned code 400. Truncated server response: {“error”:{“message”:”(#100) Missing permissions”,”type”:”OAuthException”,”code”:100,”fbtrace_id”:”AykF1uFxFq32i7toDZl4Xg_”}} (use muteHttpExceptions option to examine full response)

      Reply
      • That looks all right to me so I’d double check that your token works. Does your request URL work when you plug it into your browse URL bar? If yes then it’s a problem in your script; if not, then please make sure you’ve requested the ads_read scope.
        Btw, if you just want to pull data into sheet cells, you can do that using API Connector’s IMPORTAPI custom function.

  67. is there a limit with the api connector results? im trying to do last_30d or last_7d using this url

    https://graph.facebook.com/v13.0/xxxx/insights?fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,account_currency,reach,impressions,clicks,cpc,spend&time_increment=1&level=ad&date_preset=last_30d

    but the no. of rows remain only 26 rows. it doesn’t show me per day until today. how do i fix this limitation?

    Reply
  68. Thank you Ana. Appreciate your great work! One last thing, when I use last_3d or last_7d is there a tweak to include today’s date as well? I noticed that it means 3/7days excluding today.

    Reply
    • You’re welcome, thank you for reading 🙂 You can see all the time parameters Facebook allows here (check the section called date_preset). I see some presets that might work for you, e.g. this_week_sun_today. Alternatively, you can pull in exactly the time period you want by using time range parameters instead of date presets, e.g. &time_range={"since":"2022-02-14","until":"2022-02-16"}

      Reply
  69. Hi Ana, appreciate your help for the above. It is working great now. Thank you so much! One more favor, do you think you have a similar article for importing google adwords insights?

    Reply
    • Looks like you can do a request URL like https://graph.facebook.com/v13.0/12345/?fields=account_id,campaign,name,adset_schedule,budget_remaining, where you replace 12345 with your adset ID. Please check if that works for you.

      Reply
  70. Is it possible to get results for date_preset (e.g. last_7d) along with previous period data?
    maybe I have to add something to the following request in order to get the previous period results?

    https://graph.facebook.com/v13.0/act_123456789012345/insights?fields=reach,impressions,clicks,spend&date_preset=last_7d

    Reply
    • I don’t think you can get a comparison period through the FB API, but you could set your date_preset to last_14d, or run two requests where each one uses a different time_range parameter.

      Reply
    • Sorry, we don’t support async requests, you need to receive the data when you make the request.
      If the issue is that your request is timing out, could you try reducing the time range or number of metrics?

      Reply

Leave a Reply to Varun Sharma Cancel reply

Table of Contents