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")
[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_infoAdds Payment Info
Adds To Cart
Adds To Wishlist
offsite_conversion_fb_pixel_customCustom pixel events defined by the advertiser
onsite_conversion_flow_completeOn-Facebook Workflow Completions
onsite_conversion_messaging_blockBlocked Messaging Conversations
onsite_conversion_messaging_conversation_started_7dMessaging Conversations Started
onsite_conversion_messaging_first_replyNew Messaging Conversations
photo_viewPage Photo Views
video_view3-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.
- 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-DDin Google Sheets
- Once done your date column should appear like this
- Now your all set and your Google Sheets document will have fresh data.