How to connect Facebook Ads to Google Sheets?

Are you a marketer living in Google Sheets? Connecting Facebook Ads to Google Sheets allows you to create reports, transform and blend data or pass them on to other platforms like Google Data Studio. This article covers getting automatically refreshed Facebook Ads data into Google Sheets. This includes but is not limited conversion metrics (including custom conversion events and values). In total there are more than 200 different Facebook Ads dimensions and metrics available for retrieval. Setting this up should not take you more than 5 minutes.

As a prerequisite you’ll need to connect your data here.

Let’s get started.

1. Connect your Facebook Ads account to Windsor.ai and copy your API key
2. Use this URL
   

   =IMPORTDATA("https://connectors.windsor.ai/facebook?api_key=[your API key]&date_from=2021-01-09&fields=campaign,clicks,adset_name,spend,impressions,date,source&_renderer=csv")

   and replace  [your API Key] with your API key. The fields which are listed after &fields= are simply a set of standard fields which you can customise. A full list of metrics and dimensions can be found in our Facebook Ads connector documentation. Customise the URL to your liking.

   Conversion events, the most requested fields can be found here

   Field Name for URL	Field Name Facebook User Interface
   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

   If you want to query a specific date range you can do so by changing &date_from= to the start date. Additionally you can also add in &date_to= (at the end of the URL) and specify the end date.

3. Insert your URL into Google Sheets and the data will start appearing
4. If you use the date columns it’ll likely be displayed wrongly. You’ll need to change that by using the format YYYY-MM-DD in Google Sheets
5.  Once done your date column should appear like this
6.  Now your all set and your Google Sheets document will have fresh data.