04:52 Using Facebook API and Google Sheets to pull data 07:57 Accessing insights from ad accounts using get request 13:10 Accessing Facebook data in a browser 15:41 Adding access token in the link for Facebook API requests 20:20 Use importJSON functionality to parse JSON data into something more usable in Google Sheets. 22:36 Optimizing control over requests using JSON import 27:13 Using parameters and fields in the API for filtering data 29:10 Understanding Facebook ad metrics in Google Sheets 33:04 Requesting and managing ad sets in Google Sheets 35:19 Setting up Facebook ad data in Google Sheets 40:07 Ensure correct daily budget by dividing amount by a hundred 42:28 Using custom functionality in Google Sheets for post requests 46:46 Creating a link to push data back to Facebook 49:21 Adding custom menu buttons and making changes in Google Sheets using functions Crafted by Merlin AI.
you have no idea how much these webinars helped me! The only thing I can't figure out as you didn't have time to show this is pulling the custom conversions or "actions" into google sheets If you could do a followup video or link any resources I'd be more than thankful but either way I really appreciate your work!
Can you not just connect a google sheet document to data studio? The Facebook API connector is updating itself automatically, right? Or am I missing something here? :) Thank you for an awesome video!
Thanks for great video! Need next video idea? Please create a tutorial how to automatically send leads from Facebook Ad to Google Sheet without any 3-party integration (like zippier etc. etc.) !!!
Fantastic work! Thank you so much for putting this together. Did you ever get around to making a video about how to "flatten" action values to use them in the google sheet?
Hey, thanks for making this video... Got a doubt, The same way you mentioned above to get the insights, how can we get the Facebook Ads Lead form data to google sheet using Graph API... Please reply
Do anybody know how to get "link_click" from this. NOT CLICKS but link clicks. it's available on documentation as link_click but the console keeps throwing an error saying 'link_click' is not valid for 'field' parameter.
Hello guys I have a problem when I try to put the url in browser I get this message message: (#200) Provide valid app ID .. I tried to add the app id manually, but it didn't work .. anyone faced this problem and what is the solution plz ?
has anyone tried normalizing/flattening the request to python dataframe? The results just come out as one row and 4 columns, even if you have waay more data there.
Hey Simon, when I fetch the data for maximum time or let's say for last 90 days it just gives me some 26 rows, how do i get the complete data on google sheet? Thank you. Edit: I use the limit field to get the complete data
Did you face the same issue ? I Am trying to run the code but once i change date it gives me the same values of insights, itls fixed on dtaw from 19-10 to 17-11-2023 How can solve this issue to extact data using puython in excel sheet
Hey! Wanted to ask how you "flaten" this "nested list" in the actions part, is there also a small version how to do it? Would be nice! Thank you in advance 29:00
Hello, i'm trying to use the function importJson and it gives me an error and i dont know why it says #ERROR! exception invalid argument and i have the exactly same thing
I Am trying to run the code but once i change date it gives me the same values of insights, itls fixed on dtaw from 19-10 to 17-11-2023 How can solve this issue to extact data using puython in excel sheet
Hi, Simon!! Thanks for this great tutorial!! Can I ask something?? Is it possible to get the information about other people(accounts)'s AD information using FB API??
Amazing Tutorial! I have one question, how can I pull to Google Sheets the Offsite Conversion Value (from FB pixel purchases)? It is the only metric I can't find through the API, but I can see it in custom reports in the Ads Manager.. Thanks!
following the steps of this video is configured so that the sheets are automatically updated with new information from facebook?, or how can I do so that every x minutes the sheets are updated automatically
Every time something is changed the data would be refreshed. Follow this tutorial if you want to refresh it once a minute: spreadsheetpoint.com/auto-refresh-google-sheets/
Awesome video! I'm using a Facebook source in GDS which is connected to my custom report. Everything is ok but I want to know: Can I create custom groups/segments? For example: All campaigns that contain "X" in the name to be in "Group 1" All campaigns that contain "Y" in the name to be in "Group 2" and then show and compare the data only for the total selected group/segment And btw I'm not talking about simply using filters as this wont do the trick. I'm talking about custom segmentations and aggregating that data in one or more segments/groups. Is this possible? Thanks!
Thanks very much, please how to do to get count of reactions about a post (like [wow,haha,sad,angry,..] and name of people than press reaction. Thanks advanced
Hey, Is it possible to pull amount spent at an adid level from graph api. I need this level of granularity for my use case.Any help is much much appreciated! Thanks in advance! Also I really like your content. I have subscribed to your channel!
Why i always have this when i start : I link the ressources on my ads manager?.... { "error": { "message": "Unsupported get request. Object with ID 'act_4062129938*****' does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at developers.facebook.com/docs/graph-api", "type": "GraphMethodException", "code": 100, "error_subcode": 33, "fbtrace_id": "ADNbUXDtml9ROwZwaa2SMNQ" } }
Unfortunately, that's not available via API. You basically have to do that manually by reading out the specific field you optimize for and then calculate yourself.
Yeah but why are you mirroring this when u can just do all of this or view it all from just the analytics account within your TikTok, or meta ads manager? Why use and duplicate this into a Google sheets?
Yea, but why are you here watching this video if you don't see the use for it? :) There are many use cases - combine all ad platforms in one place - build reports for clients (if you're an agency or freelancer) - combine ad platform data with other analytics data (like Google Analytics)
@@kitchnio Thank you Simon, I've sorted this as I wanted the purchase value and not the roas by calling the action_values field and using the filtering parameter. Though, I thing I would like to know that, I'm using this app for a webhook on local server. Should I need to put this app which you made us created in the first session into a review ? can you pls advice on this
@@mehrosenasir9974 how did you use the filtering parameter inside the IMPORTJSON function? I tried to filter the action_type but it didn't work :( can you help me? Thanks!
@@FernandaKuvabara I used the filtering for filter out purchase values so i did this. Filtering parameter is a list that accepts array. So in my particular example I did something like this. Filtering = [{filter : 'action_value', operator : "IN", value : ['offsite_conversion.fb_pixel_purchase']}]. You can use multiple filters inside the filtering parameter. Depending on your need you may want to use different values for operator field. If I were to used *Contain* for the *operator* value , I would get an empty result.
That's in the "status" field. So e.g. to get all paused ads you could do: /act_{ad-account-id}/ads?fields=name,id,status&effective_status=PAUSED Or if you wanted to ask a specific ad, the endpoint would be /{ad-id}=fields=status,effective_status,configured_status (there are three different status types on the API)
04:52 Using Facebook API and Google Sheets to pull data
07:57 Accessing insights from ad accounts using get request
13:10 Accessing Facebook data in a browser
15:41 Adding access token in the link for Facebook API requests
20:20 Use importJSON functionality to parse JSON data into something more usable in Google Sheets.
22:36 Optimizing control over requests using JSON import
27:13 Using parameters and fields in the API for filtering data
29:10 Understanding Facebook ad metrics in Google Sheets
33:04 Requesting and managing ad sets in Google Sheets
35:19 Setting up Facebook ad data in Google Sheets
40:07 Ensure correct daily budget by dividing amount by a hundred
42:28 Using custom functionality in Google Sheets for post requests
46:46 Creating a link to push data back to Facebook
49:21 Adding custom menu buttons and making changes in Google Sheets using functions
Crafted by Merlin AI.
you have no idea how much these webinars helped me! The only thing I can't figure out as you didn't have time to show this is pulling the custom conversions or "actions" into google sheets
If you could do a followup video or link any resources I'd be more than thankful but either way I really appreciate your work!
Thank you! I will follow up on this soon.
@@kitchnio please! this is the last piece of the puzzle for me also
look forward to it
Hi, same problem. Someone have the answer pls?
@@kitchnio still waiting for this! would love a video like this!
Awsome, make this a Google Data Studio conecctor and teach us how to do it =)
Can you not just connect a google sheet document to data studio? The Facebook API connector is updating itself automatically, right? Or am I missing something here? :) Thank you for an awesome video!
Thank you much Simon! Saved me so much time and money doing this.
I am really liking your content. Great work. Been searching for something like this for a long time. Thank you.
My thoughts exactly.
Thank you!
I appreciate!
This is exactly the information I was looking for!
Thank you very much for your help, you are the best
Thank you!
Thanks for great video! Need next video idea? Please create a tutorial how to automatically send leads from Facebook Ad to Google Sheet without any 3-party integration (like zippier etc. etc.) !!!
Amazing Tutorial. Awaiting to see more such tutorials.
Thanks a lot !
Amazing tutoring! Thanks
Is there a way to pull data directly into data studio or bigquery considering attribution settings (i.e: refreshing data for the last 28 days) ?
Fantastic work! Thank you so much for putting this together. Did you ever get around to making a video about how to "flatten" action values to use them in the google sheet?
or if you have any resources that teaches me how to do it i would very much appreciate it!
Dude your content is unbelievable great! Are you going to make more tutorial like this? For google ads and stuff?
You rock!
Yes, getting back into it now. :) And thanks so much!
Hey, thanks for making this video... Got a doubt, The same way you mentioned above to get the insights, how can we get the Facebook Ads Lead form data to google sheet using Graph API... Please reply
Do anybody know how to get "link_click" from this. NOT CLICKS but link clicks. it's available on documentation as link_click but the console keeps throwing an error saying 'link_click' is not valid for 'field' parameter.
How to pull the conversions? Using "conversions" string reference doesnt work :(
Hello guys I have a problem when I try to put the url in browser I get this message message: (#200) Provide valid app ID .. I tried to add the app id manually, but it didn't work .. anyone faced this problem and what is the solution plz ?
Hi, How can i get today's leads from FB ads manager account using graph API
Very clear information :) Is it possible to pull all the ads preview URLs to excel?
Awesome , great work. It was a great added value. Is it available in Python ?
has anyone tried normalizing/flattening the request to python dataframe? The results just come out as one row and 4 columns, even if you have waay more data there.
@kitchn_io I cannot add the filtering param to the url. Do you have the same problem?
great tutorial!!
anyway, the JSON parser result will break if we put actions, conversion, as field. Because there is object inside an object
Hey Simon, when I fetch the data for maximum time or let's say for last 90 days it just gives me some 26 rows, how do i get the complete data on google sheet? Thank you.
Edit: I use the limit field to get the complete data
Did you face the same issue ?
I Am trying to run the code but once i change date it gives me the same values of insights, itls fixed on dtaw from 19-10 to 17-11-2023
How can solve this issue to extact data using puython in excel sheet
Hey! Wanted to ask how you "flaten" this "nested list" in the actions part, is there also a small version how to do it? Would be nice! Thank you in advance
29:00
Hey there, have you solved the probem? I am having the same issue..
Hey, is it possible and how to auto-refresh the data every 10-15 minutes?
Hello, i'm trying to use the function importJson and it gives me an error and i dont know why it says #ERROR! exception invalid argument and i have the exactly same thing
I Am trying to run the code but once i change date it gives me the same values of insights, itls fixed on dtaw from 19-10 to 17-11-2023
How can solve this issue to extact data using puython in excel sheet
That sounds like the default date_preset. You should only use either date_range OR date_preset.
How to fetch installs and uninstalls data from this?
Awesome work mate, Can you confirm if there is way to pull the paid invoices via API?
Hi, Simon!! Thanks for this great tutorial!! Can I ask something?? Is it possible to get the information about other people(accounts)'s AD information using FB API??
Amazing Tutorial!
I have one question, how can I pull to Google Sheets the Offsite Conversion Value (from FB pixel purchases)? It is the only metric I can't find through the API, but I can see it in custom reports in the Ads Manager.. Thanks!
It be awesome if you us how to automatically send FB ads leads go Google sheet ;)
following the steps of this video is configured so that the sheets are automatically updated with new information from facebook?, or how can I do so that every x minutes the sheets are updated automatically
Every time something is changed the data would be refreshed. Follow this tutorial if you want to refresh it once a minute: spreadsheetpoint.com/auto-refresh-google-sheets/
Can you share the subsequent webinars that follow this one?
do you know a way to export all the interests from facebook ?
Awesome video! I'm using a Facebook source in GDS which is connected to my custom report. Everything is ok but I want to know:
Can I create custom groups/segments? For example:
All campaigns that contain "X" in the name to be in "Group 1"
All campaigns that contain "Y" in the name to be in "Group 2"
and then show and compare the data only for the total selected group/segment
And btw I'm not talking about simply using filters as this wont do the trick. I'm talking about custom segmentations and aggregating that data in one or more segments/groups. Is this possible? Thanks!
instead of Google Sheets can i upload the data into a database?
Great video. i want to how can we write ?fields= (all availabel fields) instead of typing particular fields?
This was amazing dude. Thank you SO MUCH! Do you have a paypal so we can contribute?
No need, but thank you so much! :) You could be most helpful just letting me know what else I should post a video about!
Hi, I am looking for some help with a few things. Are you available for private hire?
29:30 is there a way to get the data on the nested list?
bro can you do more video like this
Thanks very much, please how to do to get count of reactions about a post (like [wow,haha,sad,angry,..] and name of people than press reaction. Thanks advanced
more videos and creativity, sir!!
More to come!
Hey, Is it possible to pull amount spent at an adid level from graph api. I need this level of granularity for my use case.Any help is much much appreciated! Thanks in advance!
Also I really like your content. I have subscribed to your channel!
Super valuable. Im just very stuck on how to see leads generated per ad. I used 'conversions' as a Field type but it brought back the wrong thing.
Hi there, did you find a solution for it?
Hey can u help us setting up our google spreadsheet
Why i always have this when i start :
I link the ressources on my ads manager?....
{
"error": {
"message": "Unsupported get request. Object with ID 'act_4062129938*****' does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at developers.facebook.com/docs/graph-api",
"type": "GraphMethodException",
"code": 100,
"error_subcode": 33,
"fbtrace_id": "ADNbUXDtml9ROwZwaa2SMNQ"
}
}
can you see who filled your lead genration from this facebook api?
Can we pull data from google ads?
hi is possible get information from an all business manager, I work with a lots of accounts...Good work! Excellent explained!
You'd probably have to break up the request into first getting all ad accounts from a business manager id and then getting results for each account.
what the purpose for doing that?
Hey, Thanks for the video !
Can you make a tutorial for automatically retrieving leads from Facebook Ad to Google Sheet ?
Yes, that's one of the things I'll be looking at next!
How will get cost per result and result type column?
Unfortunately, that's not available via API. You basically have to do that manually by reading out the specific field you optimize for and then calculate yourself.
Yeah but why are you mirroring this when u can just do all of this or view it all from just the analytics account within your TikTok, or meta ads manager? Why use and duplicate this into a Google sheets?
Yea, but why are you here watching this video if you don't see the use for it? :)
There are many use cases
- combine all ad platforms in one place
- build reports for clients (if you're an agency or freelancer)
- combine ad platform data with other analytics data (like Google Analytics)
@@kitchnioagree, when it comes to data cleaning, using Google sheet is much more handy for me
How can I retrive daily facebook return/ website purchases value?
Purchase values are part of the action_values field. But there is another special field called 'purchase_roas' that you can use.
@@kitchnio Thank you Simon, I've sorted this as I wanted the purchase value and not the roas by calling the action_values field and using the filtering parameter.
Though, I thing I would like to know that, I'm using this app for a webhook on local server. Should I need to put this app which you made us created in the first session into a review ? can you pls advice on this
@@mehrosenasir9974 how did you use the filtering parameter inside the IMPORTJSON function? I tried to filter the action_type but it didn't work :( can you help me? Thanks!
@@FernandaKuvabara I used the filtering for filter out purchase values so i did this. Filtering parameter is a list that accepts array. So in my particular example I did something like this. Filtering = [{filter : 'action_value', operator : "IN", value : ['offsite_conversion.fb_pixel_purchase']}]. You can use multiple filters inside the filtering parameter. Depending on your need you may want to use different values for operator field. If I were to used *Contain* for the *operator* value , I would get an empty result.
how to check ads on or off >> please help me
That's in the "status" field. So e.g. to get all paused ads you could do: /act_{ad-account-id}/ads?fields=name,id,status&effective_status=PAUSED
Or if you wanted to ask a specific ad, the endpoint would be /{ad-id}=fields=status,effective_status,configured_status (there are three different status types on the API)
@@kitchnio thanks bro