I need to create a report on asset performance from google ads transfer data in bigquery. The report should be similar to the one in Google Ads UI (under Assets with assets names, campaigns, clicks etc). I have enabled PMAX within the bigquery data transfer and now have views about Assets (e.g. ads_Assets, ads_CampaignAssetStats etc) When I query ads_CampaignAssetStats I see an asset field campaign_asset_asset of format customers/1111111111/assets/111111111111, I would like to somehow get the name of this particular asset, but I cannot find this in any asset related tables.

So either that data is not available in BQ data transfer and I need to get it from the api or I am not searching or understanding the data. Where can I find this data within BQ data transfer tables (if at all?

I have looked through google ads data transfer documentation expecting some more insights into the asset views but it didn't clarify how I can get the names of the assets.

I have browsed through other tables within BQ google ads data transfer but haven't found a way to connect the data.

When I try to create a flow (Account tools > Flows), a screen appears asking for company verification. But, when I click the Start button, a message appears: Congratulations, your business has been verified by Meta. However, the screen to manage access to the flows does not appear. Please see the screenshot attached. Kindly let me know what needs to be done in order to create Whatsapp Flows.

While Integrating the Facebook login for business I am facing "It looks like this app isen't available". I have followed all the steps mention in the META documentation. please click here to refer the images which I have followed.

<!DOCTYPE html> <html> <head>     <title>Facebook Login JavaScript Example</title>     <meta charset="UTF-8">     <script type="text/javascript" src="<c:url value='/facebooksdk/js/fbsdk.js'/>"></script>     <script>         window.fbAsyncInit = function() {           FB.init({             appId      : APPID,             cookie     : true,             xfbml      : true,             version    : APIVERSION,             response_type: "code"           });           checkLoginState();         };         (function(d, s, id){            var js, fjs = d.getElementsByTagName(s)[0];            if (d.getElementById(id)) {return;}            js = d.createElement(s); js.id = id;            js.src = "https://connect.facebook.net/en_US/sdk.js";            fjs.parentNode.insertBefore(js, fjs);          }(document, 'script', 'facebook-jssdk'));       </script> </head> <body>       <fb:login-button onlogin="checkLoginState();"> </fb:login-button>     <div id="status">     </div> </body> </html> const APPID = "1450727115804587"; const APIVERSION = "v19.0"; const CONFIGID = "422168783777066"; function statusChangeCallback(response) { // Called with the results from FB.getLoginStatus().     console.log('statusChangeCallback');     console.log(response); // The current login status of the person.     if (response.status === 'connected') { // Logged into your webpage and Facebook.         testAPI();     } else { // Not logged into your webpage or we are unable to tell.         document.getElementById('status').innerHTML = 'Please log '             + 'into this webpage.';     } } function checkLoginState() { // Called when a person is finished with the Login Button.     FB.getLoginStatus(function (response) { // See the onlogin handler         statusChangeCallback(response);     }); } function testAPI() {     console.log('Welcome!  Fetching your information.... ');     FB.api('/me', function (response) {         console.log('Successful login for: ' + response.name);         document.getElementById('status').innerHTML = 'Thanks for logging in, '             + response.name + '!';     }); } 

Step 1 : Create a new app Note : I have selected Other option

Select an App Type -> I have selected an second option Business App Type

Provide App Name & Business Profile and click on Create App

(3.1) Business App details - Business app is verified

App Details : - Display Name - EduCRM - App Domain : educloud.app - Privacy policy & Terms of service Url : https://zdp2.educloud.app/lms/tandc - Category : Education - Image Update : Yes

Add Product “facebook login for business”

Click Setup button of Facebook Login for Business

Facebook Login for business get Advance permission Permission requested pages_show_list ads_management
leads_retrieval pages_read_engagement
pages_manage_metadata
pages_read_user_content pages_manage_ads
pages_manage_engagement public_profile

Configuration Quick Start steps: Select Web option : to get SDK code Make the App live :

We have carried out a review regarding our blocked account And explains what we use in sending WhatsApp messages using the API from meta.
But our review was rejected. Honestly we don't know why this happened.