<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Ilja Zonov on Medium]]></title>
        <description><![CDATA[Stories by Ilja Zonov on Medium]]></description>
        <link>https://medium.com/@iljazonov?source=rss-3db34215765c------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*8jhW4GuiVKWKIomO9V6a8g.png</url>
            <title>Stories by Ilja Zonov on Medium</title>
            <link>https://medium.com/@iljazonov?source=rss-3db34215765c------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 03:06:40 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@iljazonov/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Boost the quality of your leads in Google Ads with value-based bidding]]></title>
            <link>https://iljazonov.medium.com/boost-the-quality-of-your-leads-in-google-ads-with-value-based-bidding-ea7de6d44c99?source=rss-3db34215765c------2</link>
            <guid isPermaLink="false">https://medium.com/p/ea7de6d44c99</guid>
            <category><![CDATA[marketing-strategies]]></category>
            <category><![CDATA[lead-generation]]></category>
            <category><![CDATA[google-ads]]></category>
            <category><![CDATA[performance-marketing]]></category>
            <category><![CDATA[crm]]></category>
            <dc:creator><![CDATA[Ilja Zonov]]></dc:creator>
            <pubDate>Tue, 27 May 2025 12:01:24 GMT</pubDate>
            <atom:updated>2025-05-27T12:01:24.029Z</atom:updated>
            <content:encoded><![CDATA[<h3>Not All Leads Are Equal: How Lead Generation Businesses Can Optimize Google Ads with Dynamic Conversion Values</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ok8BHpdAVZZ7m5Ug4YZz0A.jpeg" /></figure><p>If you’re running lead generation campaigns with Google Ads and treating all conversions the same, you’re missing out on significant performance potential.</p><p><strong>In reality, not every lead is equally valuable</strong>. A form submission, a scheduled call, and a closed deal represent different levels of intent. Yet, most advertisers assign the same value to all funnel actions — or none at all — which makes it difficult for Google’s algorithms to prioritize what truly matters.</p><p>In this article, I’ll explain how to use dynamic conversion values to show Google which leads are the most valuable and how to optimize bidding strategies, such as tROAS, to improve results without increasing spending.</p><h3>The Problem with Equal Conversion Values</h3><p>Many lead generation campaigns track multiple actions — such as a basic form submission or a booked consultation with qualifying questions — but either assign no specific conversion value to each event or treat them all the same.</p><p>When all actions in the funnel are valued equally, Google Ads lacks the right signals to prioritize the prospects that matter most. While every step of the funnel is important — from initial interest to final qualification — actions occurring deeper in the funnel typically carry greater business value. Additionally, certain qualifying actions, like answering high-intent questions or booking a consultation, can further indicate stronger intent and should be weighted more heavily.</p><p>Without properly differentiated conversion values, you risk training Google’s algorithms to optimize for sheer volume rather than meaningful outcomes — leading to lower-quality leads, higher acquisition costs, and ultimately, weaker campaign performance in competitive lead generation markets.</p><h3>Introducing Dynamic Conversion Values</h3><p>With Dynamic Conversion Values, you can assign different monetary weights to different conversion actions based on their true business value — helping Google Ads bid more intelligently throughout your lead funnel.</p><p>For example:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*i9AgcIiStOgExg95nCGBxQ.jpeg" /></figure><p>Each event in the funnel is weighted to reflect its relative impact, guiding Google’s algorithms to prioritize higher-value conversions — not just the most frequent ones.</p><p>These values feed directly into the Google Ads Target ROAS (tROAS) bidding formula:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*msgZTc13TQWkcqu8WU6Stg.jpeg" /></figure><h3>Currency Matters: Matching your account currency</h3><p>It’s important to note that all conversion values should match the default currency of your Google Ads account. For example, if your account is set to EUR, your values must be sent in EUR.</p><p>If you send a value in a different currency — say, 100 AED — Google will automatically convert it to your account currency at the time of processing (e.g., 24 EUR), which could skew your tROAS calculations and lead to unintended optimization behavior.</p><p>Best practice: Always send conversion values in the same currency as your Google Ads account. There’s no need to specify the currency parameter unless you’re intentionally working with multiple currencies.</p><h3>How to Refine Values Using Historical Data</h3><p>If you have access to historical lead data, you can fine-tune your dynamic conversion values based on actual conversion patterns — making your bidding strategy even more precise.</p><p>For example, if your lead form includes qualifying questions, you can assign higher conversion values to responses that historically correlate with stronger purchase intent.</p><h4>Example: B2B SaaS — Lead Qualification Question</h4><p><em>“How many team members will use the product?”</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DpH3105YTXGkphKAYobdBw.jpeg" /></figure><p>By analyzing your CRM data to see which responses lead to actual sales-and how much those customers are worth-you can build a data-driven value model that reflects real business outcomes.</p><p>This approach ensures that even top-of-funnel conversions are scored based on expected revenue potential, allowing you to focus your budget on the highest-value opportunities-not just the easiest ones to acquire.</p><h3>Optimizing Phone Call Conversions</h3><p>Phone call conversions often signal high intent, but tracking just call duration doesn’t tell the full story.</p><p><strong>To properly capture call quality:</strong></p><ul><li>Record the GCLID (Google Click ID) when someone clicks your ad.</li><li>Match the GCLID to the phone call event.</li><li>After the call, assess the quality — was the caller qualified?</li><li>Upload the result using Offline Conversion Import with the appropriate value attached.</li></ul><p>This post-call feedback loop helps Google prioritize not just any call, but calls that actually drive your business goals.</p><h3>Choose the Right Bidding Strategy: Maximize Conversion Value or Target ROAS</h3><p>Once you assign dynamic conversion values, it’s important to pair them with the right bidding strategy.</p><p>✅ Use Maximize Conversion Value or Target ROAS (tROAS) bidding.</p><p>🚫 Avoid Maximize Conversions or Target CPA (tCPA) strategies, which only focus on quantity, not value.</p><p>By using value-based bidding, you ensure Google Ads is optimizing towards what really matters: high-quality, high-value leads — not just lead volume.</p><h3>Real-World Example: Assigning Funnel Values</h3><p>Let’s say your lead funnel generated the following conversion counts over the last 30 days:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Pxf2fjdmYEgyINmadNMmEQ.jpeg" /></figure><p>To reflect the relative importance of each step, you can assign dynamic conversion values using a normalized inverted weight formula, which gives more value to rarer, higher-quality actions.</p><p>📊 How the formula works:</p><p>We calculate the value for each event using the following formula:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vnv91eecQdMhLPYC-Y0HeA.jpeg" /></figure><p>Where:</p><ul><li>Step 1: (1/100) = 0.01</li><li>Step 2: (1/80) = 0.0125</li><li>Step 3: (1/30) = 0.0333</li><li>Step 4: (1/10) = 0.1</li></ul><p><strong>Sum of inverted weights</strong> = 0.01 + 0.0125 + 0.0333 + 0.1 = <strong>0.1558</strong></p><p>Now normalize each:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aj2nZU8YfEKgBGEy8q0bsg.jpeg" /></figure><p>These values total 100, which makes them easy to interpret, report on, and use in tROAS calculations.</p><p>With this structure in place, Google’s optimization engine learns to:</p><ul><li>Prioritize later-stage, higher-value actions; and</li><li>Still gain learning signals from earlier steps in the funnel.</li></ul><p>This model ensures your <strong>budget is optimized for quality rather than quantity</strong>, while providing Google with richer data at every stage of the customer journey.</p><h3>Conclusion: Make Every Lead Count</h3><p>Lead generation isn’t just about collecting the most form submissions; it’s about attracting valuable, qualified prospects who are most likely to generate revenue.</p><p>By implementing dynamic conversion values, leveraging qualifying signals, and shifting to value-based bidding, you give Google Ads the data it needs to prioritize quality over quantity, dramatically improving lead quality, efficiency and overall campaign profitability.</p><p><strong>🔑 Key takeaways:</strong></p><ul><li>Assign higher values to funnel events that indicate stronger intent (e.g. qualified leads vs. form fills).</li><li>Use conversion value-based bidding strategies such as Target ROAS, not just tCPA.</li><li>Send values in your account’s currency to avoid data mismatches.</li><li>Use historical data and qualifying questions to refine values based on actual conversion performance.</li></ul><h4>💬 Need help setting this up for your own campaigns?</h4><p><strong>I help lead generation businesses</strong> implement value-based tracking, improve funnel attribution and drive more qualified leads with smarter Google Ads strategies.</p><p>Feel free to <a href="https://www.linkedin.com/in/ilja-zonov-18600a177//"><strong>message me on LinkedIn</strong></a> or <a href="https://calendly.com/ilja-scaleup-agency/call-with-ilja"><strong>book a quick 30-minute consultation</strong></a> to discuss how I can help you improve your results.</p><p>This article was originally published on LinkedIn and shared with marketers. You can view the original post and join the conversation here: <a href="https://www.linkedin.com/pulse/all-leads-equal-how-lead-generation-businesses-can-optimize-zonov-rzlbf/">LinkedIn article</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ea7de6d44c99" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Connect Meta Ads to Looker Studio for Free Without Paid Connectors]]></title>
            <link>https://iljazonov.medium.com/how-to-connect-meta-ads-to-looker-studio-for-free-without-paid-connectors-0c34fdaa9f72?source=rss-3db34215765c------2</link>
            <guid isPermaLink="false">https://medium.com/p/0c34fdaa9f72</guid>
            <category><![CDATA[marketing-automation]]></category>
            <category><![CDATA[meta-ads]]></category>
            <category><![CDATA[digital-marketing]]></category>
            <category><![CDATA[looker-studio]]></category>
            <category><![CDATA[marketing-analytics]]></category>
            <dc:creator><![CDATA[Ilja Zonov]]></dc:creator>
            <pubDate>Wed, 23 Apr 2025 05:11:32 GMT</pubDate>
            <atom:updated>2025-04-23T05:11:32.147Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GRyCuT-tLbAHdq8nyVmUSg.png" /></figure><p>If you’re tired of using expensive reporting tools like Supermetrics, Funnel or other connectors just to look at your Facebook Ads data, then this guide is for you.</p><p>In this article I’ll walk you through how to:</p><p>✅ Pull Meta Ads performance data using the Meta Marketing API</p><p>✅ Send it to Google Sheets via a custom Apps script</p><p>✅ Visualize it beautifully in Looker Studio (formerly Data Studio) — all for free, no third-party services required…</p><p>‏‏‎ ‎</p><p><strong>Let’s get started</strong></p><p><strong>⚠️ Problem</strong>: Looker Studio has no native connector for Facebook Ads. Most integrations rely on paid tools like Supermetrics, Funnel, or Windsor.ai.</p><p><strong>🚀 Solution</strong>: Use Google Sheets as a data bridge:</p><ol><li>Connect Google Sheets to the <strong>Meta Ads API</strong> via Google Apps Script</li><li>Connect that Google Sheet to <strong>Looker Studio</strong></li></ol><p>‏‏‎ ‎</p><p>This lets you build automated campaign performance reports, completely free.</p><h4><strong>🛠 Step 1: Create a Facebook App for API Access</strong></h4><ul><li>Go to the <a href="https://developers.facebook.com/">Facebook Developer Portal</a></li><li>Log in with a Facebook account that has access to the Ad Account</li><li>Click <strong>My Apps</strong> in the top right → Then click <strong>Create App</strong></li><li><strong>App name</strong>: e.g. “YourBrand Dashboard”</li><li><strong>App contact email</strong>: your email</li><li><strong>Use cases</strong>: other</li><li><strong>Type</strong>: Business</li></ul><p>‏‏‎ ‎</p><ul><li>After the app is created</li><li>Go to the App Dashboard</li><li>In the left sidebar, click <strong>Add Product</strong> → <strong>Marketing API</strong> → <strong>Set Up</strong></li><li>Under <strong>Permissions</strong>, check: ads_read</li><li>Click <strong>Get token</strong></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KOZaa3t6BsFcPlIeJ73QWA.png" /></figure><p>‏‏‎ ‎</p><h4><strong>🔐 Step 2: Get a Long-Lived Access Token</strong></h4><ul><li>Convert the token to a long-lived token using this URL format in your browser:</li></ul><p><a href="https://graph.facebook.com/v19.0/oauth/access_token">https://graph.facebook.com/v19.0/oauth/access_token</a>?grant_type=fb_exchange_token&amp;client_id=<strong>YOUR_APP_ID</strong>&amp;client_secret=<strong>YOUR_APP_SECRET</strong>&amp;fb_exchange_token=<strong>YOUR_SHORT_LIVED_TOKEN</strong></p><p>‏‏‎ ‎</p><p><strong>Hit Enter</strong> — Facebook will return a JSON with your <strong>long-lived token</strong></p><p><strong>Save it somewhere secure </strong>— this token will be used in your script.</p><p>‏‏‎ ‎</p><ul><li>YOUR_APP_ID → from<a href="https://developers.facebook.com/apps/"> App Settings</a></li><li>YOUR_APP_SECRET → also in App Settings (under Basic)</li><li>YOUR_SHORT_LIVED_TOKEN → the token you just got from Graph API Explorer</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*HN5w-j3Q-iFd3p1PilCpLA.png" /></figure><p>‏ ‎‏‏‎ ‎</p><h4><strong>📌 Step 3: Get Your Ad Account ID</strong></h4><ul><li>Open <a href="https://business.facebook.com/adsmanager">Meta Ads Manager</a> and select your account</li><li>Copy the Ad Account ID from the URL or settings</li><li>Format: act_123456789012345</li></ul><p>‏‏‎ ‎</p><h4><strong>📊 Step 4: Prepare Your Google Sheet</strong></h4><ul><li>Create a new Google Sheet</li><li>Rename the default sheet tab to: “Campaign_Report”</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CM9D7Pjm_Mdq_8cDHkd4iA.png" /></figure><p>‏‏‎ ‎</p><h4><strong>💻 Step 5: Set up Google Apps Script</strong></h4><ul><li>In the Google Sheet → Go to Extensions → Apps Script</li><li>Rename the default script to Campaign_Report_Code</li><li>Replace the default code with the script below:</li><li>Run the script once using ▶️ to test it (authorize when prompted)</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ts5eBoax8pAF-g0wxffXCw.png" /></figure><p><strong>Notes</strong></p><ul><li>This script only counts offsite conversions.</li><li>To track other conversions (e.g. breaking down by category), change the action_type line.</li></ul><p>‏‏‎ ‎</p><p><strong>Campaign Level Reporting Script</strong></p><pre>function fetchMetaAdsData() {<br>  const ACCESS_TOKEN = &#39;YOUR_LONG_LIVED_ACCESS_TOKEN&#39;; // Replace with your token<br>  const AD_ACCOUNT_ID = &#39;act_YOUR_AD_ACCOUNT_ID&#39;; // Replace with your Ad Account ID<br>  const API_VERSION = &#39;v19.0&#39;;<br><br>  const startDate = &#39;2025-04-23&#39;;<br>  const today = new Date();<br>  const yesterday = new Date(today);<br>  yesterday.setDate(today.getDate() - 1);<br>  const endDate = yesterday.toISOString().split(&#39;T&#39;)[0];<br><br>  const FIELDS = [<br>    &#39;date_start&#39;,<br>    &#39;campaign_id&#39;,<br>    &#39;spend&#39;,<br>    &#39;impressions&#39;,<br>    &#39;clicks&#39;,<br>    &#39;reach&#39;,<br>    &#39;frequency&#39;,<br>    &#39;actions&#39;<br>  ];<br><br>  const url = `https://graph.facebook.com/${API_VERSION}/${AD_ACCOUNT_ID}/insights` +<br>              `?fields=${FIELDS.join(&#39;,&#39;)}` +<br>              `&amp;level=campaign` +<br>              `&amp;time_range[since]=${startDate}&amp;time_range[until]=${endDate}` +<br>              `&amp;action_attribution_windows=default` +<br>              `&amp;time_increment=1` +<br>              `&amp;limit=500` +<br>              `&amp;access_token=${ACCESS_TOKEN}`;<br><br>  try {<br>    const response = UrlFetchApp.fetch(url);<br>    const data = JSON.parse(response.getContentText());<br><br>    const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(&#39;Campaign_Report&#39;);<br>    if (!sheet) {<br>      SpreadsheetApp.getActiveSpreadsheet().insertSheet(&#39;Campaign_Report&#39;);<br>    }<br>    const activeSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(&#39;Campaign_Report&#39;);<br>    activeSheet.clear();<br>    activeSheet.appendRow([<br>      &#39;Date&#39;,<br>      &#39;Campaign ID&#39;,<br>      &#39;Campaign Name&#39;,<br>      &#39;Spend&#39;,<br>      &#39;Impressions&#39;,<br>      &#39;Clicks&#39;,<br>      &#39;Reach&#39;,<br>      &#39;Frequency&#39;,<br>      &#39;Offsite Conversions&#39;<br>    ]);<br><br>    const campaignNames = fetchNameMap(&#39;campaigns&#39;, ACCESS_TOKEN, AD_ACCOUNT_ID, API_VERSION);<br><br>    if (data.data &amp;&amp; data.data.length &gt; 0) {<br>      data.data.forEach(row =&gt; {<br>        const campaignName = campaignNames[row.campaign_id] || &#39;(Unknown)&#39;;<br>        let totalConversions = 0;<br><br>        if (Array.isArray(row.actions)) {<br>          row.actions.forEach(action =&gt; {<br>            if (action.action_type &amp;&amp; action.action_type.startsWith(&#39;offsite_conversion&#39;)) {<br>              totalConversions += parseInt(action.value || 0);<br>            }<br>          });<br>        }<br><br>        activeSheet.appendRow([<br>          row.date_start || &#39;&#39;,<br>          row.campaign_id || &#39;&#39;,<br>          campaignName,<br>          parseFloat(row.spend || 0),<br>          parseInt(row.impressions || 0),<br>          parseInt(row.clicks || 0),<br>          parseInt(row.reach || 0),<br>          parseFloat(row.frequency || 0),<br>          totalConversions<br>        ]);<br>      });<br>    } else {<br>      Logger.log(&#39;No campaign-level data returned from Meta Ads API.&#39;);<br>    }<br><br>  } catch (error) {<br>    Logger.log(&#39;Error fetching campaign-level data: &#39; + error);<br>  }<br>}</pre><p>‏‏‎ ‎</p><p><strong>(Optional) Ad Set–Level Reporting</strong></p><ul><li>Create another Google sheets tab: “AdSet_Report”</li><li>Add a new script file: AdSet_Report_Code</li><li>type = script</li><li>Insert the code below</li><li>Run the script once using ▶️ to test it</li></ul><p>‏‏‎ ‎</p><p><strong>Adset Level Reporting Script</strong></p><pre>function fetchMetaAdSetSummary() {<br>  const ACCESS_TOKEN = &#39;YOUR_LONG_LIVED_ACCESS_TOKEN&#39;; // Replace with your token<br>  const AD_ACCOUNT_ID = &#39;act_YOUR_AD_ACCOUNT_ID&#39;; // Replace with your Ad Account ID<br>  const API_VERSION = &#39;v19.0&#39;;<br><br>  const startDate = &#39;2025-04-23&#39;;<br>  const today = new Date();<br>  const yesterday = new Date(today);<br>  yesterday.setDate(today.getDate() - 1);<br>  const endDate = yesterday.toISOString().split(&#39;T&#39;)[0];<br><br>  const FIELDS = [<br>    &#39;date_start&#39;,<br>    &#39;adset_id&#39;,<br>    &#39;campaign_id&#39;,<br>    &#39;spend&#39;,<br>    &#39;impressions&#39;,<br>    &#39;clicks&#39;,<br>    &#39;reach&#39;,<br>    &#39;frequency&#39;,<br>    &#39;actions&#39;<br>  ];<br><br>  const url = `https://graph.facebook.com/${API_VERSION}/${AD_ACCOUNT_ID}/insights` +<br>              `?fields=${FIELDS.join(&#39;,&#39;)}` +<br>              `&amp;level=adset` +<br>              `&amp;time_range[since]=${startDate}&amp;time_range[until]=${endDate}` +<br>              `&amp;time_increment=1` +<br>              `&amp;limit=500` +<br>              `&amp;access_token=${ACCESS_TOKEN}`;<br><br>  try {<br>    const response = UrlFetchApp.fetch(url);<br>    const data = JSON.parse(response.getContentText());<br><br>    const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(&#39;AdSet_Report&#39;);<br>    if (!sheet) {<br>      SpreadsheetApp.getActiveSpreadsheet().insertSheet(&#39;AdSet_Report&#39;);<br>    }<br>    const activeSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(&#39;AdSet_Report&#39;);<br>    activeSheet.clear();<br>    activeSheet.appendRow([<br>      &#39;Date&#39;,<br>      &#39;Ad Set ID&#39;, &#39;Ad Set Name&#39;,<br>      &#39;Campaign ID&#39;, &#39;Campaign Name&#39;,<br>      &#39;Spend&#39;, &#39;Impressions&#39;, &#39;Clicks&#39;,<br>      &#39;Reach&#39;, &#39;Frequency&#39;,<br>      &#39;Offsite Conversions&#39;<br>    ]);<br><br>    const adsetNames = fetchNameMap(&#39;adsets&#39;, ACCESS_TOKEN, AD_ACCOUNT_ID, API_VERSION);<br>    const campaignNames = fetchNameMap(&#39;campaigns&#39;, ACCESS_TOKEN, AD_ACCOUNT_ID, API_VERSION);<br><br>    if (data.data &amp;&amp; data.data.length &gt; 0) {<br>      data.data.forEach(row =&gt; {<br>        const adsetName = adsetNames[row.adset_id] || &#39;(Unknown)&#39;;<br>        const campaignName = campaignNames[row.campaign_id] || &#39;(Unknown)&#39;;<br>        let totalConversions = 0;<br><br>        if (Array.isArray(row.actions)) {<br>          row.actions.forEach(action =&gt; {<br>            if (action.action_type &amp;&amp; action.action_type.startsWith(&#39;offsite_conversion&#39;)) {<br>              totalConversions += parseInt(action.value || 0);<br>            }<br>          });<br>        }<br><br>        activeSheet.appendRow([<br>          row.date_start || &#39;&#39;,<br>          row.adset_id || &#39;&#39;, adsetName,<br>          row.campaign_id || &#39;&#39;, campaignName,<br>          parseFloat(row.spend || 0),<br>          parseInt(row.impressions || 0),<br>          parseInt(row.clicks || 0),<br>          parseInt(row.reach || 0),<br>          parseFloat(row.frequency || 0),<br>          totalConversions<br>        ]);<br>      });<br>    } else {<br>      Logger.log(&#39;No ad set–level data returned from Meta Ads API.&#39;);<br>    }<br><br>  } catch (error) {<br>    Logger.log(&#39;Error fetching ad set–level data: &#39; + error);<br>  }<br>}<br><br>function fetchNameMap(objectType, token, adAccountId, apiVersion) {<br>  const nameMap = {};<br>  const supported = [&#39;campaigns&#39;, &#39;adsets&#39;, &#39;ads&#39;];<br>  if (!supported.includes(objectType)) {<br>    Logger.log(`Invalid objectType: ${objectType}`);<br>    return nameMap;<br>  }<br><br>  const url = `https://graph.facebook.com/${apiVersion}/${adAccountId}/${objectType}` +<br>              `?fields=id,name&amp;limit=500&amp;access_token=${token}`;<br><br>  try {<br>    const response = UrlFetchApp.fetch(url);<br>    const parsed = JSON.parse(response.getContentText());<br><br>    if (parsed.data &amp;&amp; parsed.data.length &gt; 0) {<br>      parsed.data.forEach(item =&gt; {<br>        if (item.id &amp;&amp; item.name) {<br>          nameMap[item.id] = item.name;<br>        }<br>      });<br>    } else {<br>      Logger.log(`No data returned for ${objectType}`);<br>    }<br>  } catch (e) {<br>    Logger.log(`Error fetching ${objectType} names: ${e}`);<br>  }<br><br>  return nameMap;<br>}</pre><p>‎ ‎</p><h4><strong>🔁 Step 6: Schedule the Script to Run Automatically</strong></h4><ul><li>In Apps Script → Click the clock icon (⏱️) or go to <strong>Triggers</strong></li><li>Click “<strong>+ Add Trigger</strong>”</li><li>Set:</li><li><strong>Function</strong>: fetchMetaAdsData</li><li><strong>Event source</strong>: Time-driven</li><li><strong>Type of time based trigger</strong>: Day timer</li><li><strong>Select time of day:</strong> e.g. 8am to 9am</li><li>Click Save</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7FBONZVgLtcR7UubtU7aTg.png" /></figure><p>‏‏‎ ‎</p><h4><strong>🔗 Step 7: Connect Google Sheets to Looker Studio</strong></h4><ul><li>Open <a href="https://lookerstudio.google.com/navigation/datasources">Looker Studio</a></li><li>Click Create → <strong>Data source</strong></li><li>Select Google Sheets</li><li>In the left sidebar, select “URL”, paste your sheet URL and select the Campaign_Report tab</li><li>Check:</li><li>✅ “Use first row as headers”</li><li>✅ “Include hidden and filtered cells”</li><li>Click Connect, adjust field types, and save</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aoyv6PIyIuO1ecoid8xI9w.png" /></figure><p>‏‏‎ ‎</p><h4><strong>📈 Step 8: Use the Data in Your Dashboard</strong></h4><ul><li>Go to your Looker Studio dashboard</li><li>Click “Data” → “Add data” → “My data sources”</li><li>Select your Google Sheet source</li><li>Drag the metrics and dimensions into charts and scorecards</li></ul><p>‏‏‎ ‎</p><p>🎉 Done! Your Meta Ads data will now be updated daily and feed into your Looker Studio dashboard — for free.</p><p>‏‏‎ ‎</p><p><strong>🧠 Final Tips</strong></p><p>You can add any Meta Ads metric by modifying the FIELDS array in the script (e.g. inline_link_clicks, unique_inline_link_clicks, cost_per_result)</p><p>‏‏‎ ‎</p><p>Want deeper insights? Extend the report by adding query parameters like:</p><ul><li>&amp;level=ad → for ad-level performance</li><li>&amp;breakdowns=placement → for placement-level data (e.g. Feed, Reels)</li><li>&amp;breakdowns=age, gender → for demographic breakdowns</li></ul><p>‏‏‎ ‎</p><p>The script is modular and flexible — tailor it to your exact reporting needs without using paid connectors</p><p>‏‏‎ ‎</p><p><strong>🗣 Did you like this tutorial?</strong></p><p>If it helped simplify your Meta Ads reporting workflow, feel free to leave a 👏 or share it with a teammate.</p><p>Follow me here on Medium for more no-code and low-code automation guides focused on marketing ops, reporting, and scalable growth.</p><p>‏‏‎ ‎</p><p>💬 Need help building custom dashboards for your team? I help startups and marketing teams automate their reporting workflows.</p><p>Feel free to <a href="https://www.linkedin.com/in/ilja-zonov-18600a177/">connect with me on LinkedIn</a> or <a href="https://calendly.com/ilja-scaleup-agency/call-with-ilja">book a 30-minute consultation</a> to discuss your needs.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0c34fdaa9f72" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>