I'm currently working on a workflow to fetch all posts made by my company on social medias. On Facebook, I'm currently using the ads_posts endpoint to fetch both organic and paid posts (was previously using /feed for organic posts and /ads on the business account for paid posts, however the ads endpoint was lacking some posts that were created through dynamic ads).

The current request is like this:

https://graph.facebook.com/v21.0/{FB_PAGE_ID}/ads_posts?fields=id,created_time,updated_time&include_inline_create=true&access_token={PAGE_ACCESS_TOKEN}.

The problem is, this endpoint only gets me data from within about a month ago. Any try to fetch data older than that using the filters "since" and "until" returns no data, and trying to go there manually through pagination gets me an error of:

Please reduce the amount of data you're asking for, then retry your request

(the "limit" filter doesn't help with this either).

Am I missing something here? Is this a limitation of the ads_posts endpoint? I couldn't find anything related to this on the API reference.

Also, i saw that the posts returned via /ads_posts are sorted by their creation time, while the ads fetched on the /ads are sorted by their update time. Is there any way to change the sorting of the ads_posts entries to their update time as well?

Thanks in advance!

Using https://graph.facebook.com/v21.0/{AD_ACCOUNT_ID}/ads?fields=id,created_time,updated_time,creative{effective_object_story_id}&access_token={USER_ACCESS_TOKEN} i'm able to get ads from 2024-12-01 and before, with their effective_object_story_id that I can access through the post endpoint and check that they in fact exist.

Using the mentioned /ads_posts request, it gets me only posts as old as from 2024-12-06 (3101 posts total). Anything older than this gets me an error or no data at all.

All the posts have been published the same way, and the tokens used have all the needed permission.

The goal is to get data from my submissions table in the database as shown in my code below and upload it to google ads customer match list automatically without having to upload csv files manually with this data. Currently when I ran the command to do upload the data automatically I get this error :

{ "message": "<!DOCTYPE html>\n<html lang=en>\n  <meta charset=utf-8>\n  <meta name=viewport content=\"initial-scale=1, minimum-scale=1, width=device-width\">\n  <title>Error 404 (Not Found)!!1<\/title>\n  <style>\n    *{margin:0;padding:0}html,code{font:15px\/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(\/\/www.google.com\/images\/errors\/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(\/\/www.google.com\/images\/branding\/googlelogo\/1x\/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(\/\/www.google.com\/images\/branding\/googlelogo\/2x\/googlelogo_color_150x54dp.png) no-repeat 0% 0%\/100% 100%;-moz-border-image:url(\/\/www.google.com\/images\/branding\/googlelogo\/2x\/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(\/\/www.google.com\/images\/branding\/googlelogo\/2x\/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}\n  <\/style>\n  <a href=\/\/www.google.com\/><span id=logo aria-label=Google><\/span><\/a>\n  <p><b>404.<\/b> <ins>That\u2019s an error.<\/ins>\n  <p>The requested URL <code>\/v14\/customers\/{$customerID}\/offlineUserDataJobs:create<\/code> was not found on this server.  <ins>That\u2019s all we know.<\/ins>\n", "code": 5, "status": "NOT_FOUND", "details": [] }

My current code in my command, since I want it to run in the background every night looks like:

<?php namespace App\Console\Commands; use Illuminate\Console\Command; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Storage; use Carbon\Carbon; use Google\Auth\OAuth2; use Google\Ads\GoogleAds\Lib\V14\GoogleAdsClientBuilder; use Google\Ads\GoogleAds\Util\V14\ResourceNames; use Google\Ads\GoogleAds\V14\Services\UserDataOperation; use Google\Ads\GoogleAds\V14\Enums\OfflineUserDataJobTypeEnum\OfflineUserDataJobType; use Google\Ads\GoogleAds\V14\Common\UserIdentifier; use Google\Ads\GoogleAds\V14\Common\OfflineUserAddressInfo; use Google\Ads\GoogleAds\V14\Common\UserData; use Google\Ads\GoogleAds\V14\Services\OfflineUserDataJobOperation; class BulkUploadGoogleAds extends Command{     protected $signature = 'googleads:bulk-upload';     protected $description = 'Fetch today\'s leads, create CSVs, and upload to Google Ads Customer Match lists';     public function handle(){         $this->info('Fetching today\'s leads and preparing CSVs...');         // Fetch today's leads from submissions table         $leads = DB::table('submissions')             ->select(                 DB::raw("JSON_UNQUOTE(JSON_EXTRACT(applicant_info, '$.email')) as email"),                 DB::raw("JSON_UNQUOTE(JSON_EXTRACT(applicant_info, '$.phone')) as phone"),                 DB::raw("JSON_UNQUOTE(JSON_EXTRACT(applicant_info, '$.first_name')) as first_name"),                 DB::raw("JSON_UNQUOTE(JSON_EXTRACT(applicant_info, '$.last_name')) as last_name"),                 DB::raw("'US' as country"),                 DB::raw("JSON_UNQUOTE(JSON_EXTRACT(applicant_info, '$.zip_code')) as zip"),                 DB::raw("JSON_UNQUOTE(JSON_EXTRACT(form_fields, '$.experience')) as experience")             )             ->where('is_qualified', 1)             ->whereDate('created_at', Carbon::today())             ->get();         if ($leads->isEmpty()) {             $this->info('No leads found for today.');             return;         }         // Customer Match list IDs for driving experience         $experienceLists = [             '0'  => '8667734072',             '3'  => '8667763201',             '6'  => '8667739115',             '12' => '8667741140',             '24' => '8668576641',         ];         // Generate and upload CSVs for each list         foreach ($experienceLists as $experience => $listId) {             // Filter leads by experience level             $filteredLeads = $leads->filter(fn($lead) => $this->matchesExperience($lead->experience, $experience));             if ($filteredLeads->isEmpty()) {                 $this->info("No leads for experience level {$experience}. Skipping...");                 continue;             }             // Upload directly to Google Ads             $this->uploadToGoogleAds($filteredLeads, $listId);         }         $this->info('Bulk upload to Google Ads completed successfully.');     }     private function matchesExperience($userExp, $criteria){         $userExp = (int)$userExp;         switch ($criteria) {             case '0': return $userExp == 0;             case '3': return $userExp >= 3 && $userExp < 6;             case '6': return $userExp >= 6 && $userExp < 12;             case '12': return $userExp >= 12 && $userExp < 24;             case '24': return $userExp >= 24;             default: return false;         }     }     private function uploadToGoogleAds($leads, $listId){         $this->info("Uploading data to Google Ads list ID: {$listId}");         $iniConfig = parse_ini_file(base_path('config/google_ads.ini'), true)['GOOGLE_ADS'];         // Build the OAuth2 credentials and Google Ads client         $oauth2 = new \Google\Auth\Credentials\UserRefreshCredentials(             'https://www.googleapis.com/auth/adwords',             [                 'client_id' => $iniConfig['clientId'],                 'client_secret' => $iniConfig['clientSecret'],                 'refresh_token' => $iniConfig['refreshToken'],             ]         );         $googleAdsClient = (new GoogleAdsClientBuilder())             ->withDeveloperToken($iniConfig['developerToken'])             ->withOAuth2Credential($oauth2)             ->withLoginCustomerId($iniConfig['loginCustomerId'])             ->build();         $offlineUserDataJobService = $googleAdsClient->getOfflineUserDataJobServiceClient();         $userDataList = [];         foreach ($leads as $lead) {             $userIdentifiers = [];             if (!empty($lead->email)) {                 $userIdentifiers[] = new UserIdentifier([                     'hashed_email' => $this->normalizeAndHash($lead->email)                 ]);             }             if (!empty($lead->phone)) {                 $userIdentifiers[] = new UserIdentifier([                     'hashed_phone_number' => $this->normalizeAndHash($lead->phone)                 ]);             }             if (!empty($lead->first_name) && !empty($lead->last_name) && !empty($lead->country) && !empty($lead->zip)) {                 $userIdentifiers[] = new UserIdentifier([                     'address_info' => new OfflineUserAddressInfo([                         'hashed_first_name' => $this->normalizeAndHash($lead->first_name),                         'hashed_last_name' => $this->normalizeAndHash($lead->last_name),                         'country_code' => $lead->country,                         'postal_code' => $lead->zip,                     ])                 ]);             }             if (!empty($userIdentifiers)) {                 $userDataList[] = new UserData(['user_identifiers' => $userIdentifiers]);             }         }         if (empty($userDataList)) {             $this->info("No valid user data for list ID: {$listId}. Skipping...");             return;         }         $operations = array_map(fn(UserData $userData) => new OfflineUserDataJobOperation(['create' => $userData]), $userDataList);         $offlineUserDataJob = new \Google\Ads\GoogleAds\V14\Resources\OfflineUserDataJob([             'type' => OfflineUserDataJobType::CUSTOMER_MATCH_USER_LIST,             'resource_name' => ResourceNames::forUserList(                 $iniConfig['loginCustomerId'],                 $listId             ),         ]);         $jobResponse = $offlineUserDataJobService->createOfflineUserDataJob(             $iniConfig['loginCustomerId'],             $offlineUserDataJob         );         $jobResourceName = $jobResponse->getResourceName();         $offlineUserDataJobService->addOfflineUserDataJobOperations($jobResourceName, $operations);         $offlineUserDataJobService->runOfflineUserDataJob($jobResourceName);         $this->info("Job successfully submitted for list ID: {$listId}");     }     private function normalizeAndHash($value){         return hash('sha256', strtolower(trim($value)));     } }

My client has an ad agency. I have to develop a comprehensive reporting of all the ads running currently, cost per lead and other details. I don't have much experience with Meta APIs, they have already given me full access to their entire business portfolio, ad accounts and pages.

The problem I am facing is that there does not seem to a straightforward way to achieve this. Even though I have full privileges, I am unable to figure it. This is what I have thought:

  1. get Meta realtime updates through their webhooks.
  2. call Meta API when necessary.

I am stuck on the first step. I am following the instructions on this page: https://developers.facebook.com/docs/graph-api/webhooks/getting-started It asked to do the following two things and I have done it

Create an endpoint on a secure server that can process HTTPS requests. Configure the Webhooks product in your app's App Dashboard.

Now, to get the updates of Leads, I am following the instructions on the page: https://developers.facebook.com/docs/graph-api/webhooks/getting-started/webhooks-for-leadgen

It asks:

Install your app using your Facebook page

these are the steps mentioned to install the app on Facebook page but the instructions are broken.

  1. Select your app in the Application dropdown menu. This will return your app's access token.

  2. Click the Get Token dropdown and select Get User Access Token, then choose the pages_manage_metadata permission. This will exchange your app token for a User access token with the pages_manage_metadata permission granted.

  3. Click Get Token again and select your Page. This will exchange your User access token for a Page access token.

  4. Change the operation method by clicking the GET dropdown menu and selecting POST.

  5. Replace the default me?fields=id,name query with the Page's id followed by /subscribed_apps?subscribed_fields=leadgen, then submit the query.

  6. Select your app in the Application dropdown menu. This will return your app's access token. IT doesn't..

  7. in step 2, the moment I select User access Token, a popup opens which asks to reconnect the app. there is no time to choose pages_manage_metadata. cannot move beyond this. I have already tried several things out of frustration, searched on google, ask ChatGPT and Gemini. Nothing seem to work.

I don't understand why this is so difficult and confusing when I have the full rights and doing it just for myself. If I had this public app on which multiple people were able to connect, but just for an in-house things, it seems unnecessarily complicated.

if anyone can, please help.

  1. 1
  2. ...
  3. 52
  4. 53
  5. 54
  6. 55
  7. 56
  8. 57
  9. 58
  10. ...
  11. 526