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.
- Connect your Facebook Ads account to Windsor.ai and copy your API key
- 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 advertiseroffsite_conversion_fb_pixel_add_payment_info
Adds Payment Infooffsite_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 Registrationoffsite_conversion_fb_pixel_custom
Custom pixel events defined by the advertiseroffsite_conversion_fb_pixel_initiate_checkout
Initiates Checkoutoffsite_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 Completionsonsite_conversion_messaging_block
Blocked Messaging Conversationsonsite_conversion_messaging_conversation_started_7d
Messaging Conversations Startedonsite_conversion_messaging_first_reply
New Messaging Conversationsonsite_conversion_post_save
Post Saves onsite_conversion_purchase
On-Facebook Purchasesoutbound_click
Outbound Clicks photo_view
Page Photo Viewspost
Post Shares post_reaction
Post Reactions rsvp
Event Responsesvideo_view
3-Second Video ViewsIf 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. - Insert your URL into Google Sheets and the data will start appearing
- 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 - Once done your date column should appear like this
- Now your all set and your Google Sheets document will have fresh data.