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!
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! 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
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.) !!!
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
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??
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
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!
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.
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/
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.
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
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 ?
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!
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!
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
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
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.
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)
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" } }
@@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.
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)
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.
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!
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!
I appreciate!
This is exactly the information I was looking for!
Amazing Tutorial. Awaiting to see more such tutorials.
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!
Awesome , great work. It was a great added value. Is it available in Python ?
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..
Thank you very much for your help, you are the best
Thank you!
Very clear information :) Is it possible to pull all the ads preview URLs to excel?
29:30 is there a way to get the data on the nested list?
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!
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!
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 tutoring! Thanks
Can you share the subsequent webinars that follow this one?
Awesome work mate, Can you confirm if there is way to pull the paid invoices via API?
Great video. i want to how can we write ?fields= (all availabel fields) instead of typing particular fields?
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
Thanks a lot !
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??
great tutorial!!
anyway, the JSON parser result will break if we put actions, conversion, as field. Because there is object inside an object
@kitchn_io I cannot add the filtering param to the url. Do you have the same problem?
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
do you know a way to export all the interests from facebook ?
How to pull the conversions? Using "conversions" string reference doesnt work :(
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!
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!
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.
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.
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/
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.
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 and how to auto-refresh the data every 10-15 minutes?
Hi, How can i get today's leads from FB ads manager account using graph API
more videos and creativity, sir!!
More to come!
How to fetch installs and uninstalls data from this?
Hey can u help us setting up our google spreadsheet
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?
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 ?
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!
Kindly share PPT of this session
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!
bro can you do more video like this
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.
instead of Google Sheets can i upload the data into a database?
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
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.
Hi, I am looking for some help with a few things. Are you available for private hire?
Can we pull data from google ads?
It be awesome if you us how to automatically send FB ads leads go Google sheet ;)
what the purpose for doing that?
can you see who filled your lead genration from this facebook api?
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
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"
}
}
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.
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