New Facebook Ads Conversion Table

What is Conversion Data?

Facebook Conversion Data refers to the information collected by Facebook's advertising platform that tracks the actions users take after interacting with ads on Facebook. These actions, or conversions, can include a variety of activities such as:

• Purchases: Users buying a product or service.
• Sign-ups: Users registering for newsletters, accounts, or events.
• Downloads: Users downloading apps, e-books, or other digital content.
• Leads: Users submitting contact information for future sales opportunities.
• Page Views: Users visiting specific web pages after clicking an ad.
• Add to Cart: Users adding items to their shopping cart.

Facebook conversion data is essential for businesses to measure, optimize, and understand the impact of their advertising efforts, ultimately driving better business outcomes and more effective marketing strategies.

Benefits of Tracking Facebook Conversion Data

Tracking Facebook conversion data helps businesses in several ways:

• Measure Ad Performance: Understand which ads drive desired actions.
• Optimize Campaigns: Refine targeting and bidding strategies.
• Gain Audience Insights: Improve retargeting efforts.
• Data-Driven Decision Making: Use detailed analytics to identify and fix user journey issues.

New Conversion Insights Table In Weld

At Weld, we've made it easier to track and utilize your Facebook conversion data with our new dynamic conversions table, 'ad_roas_insight_conversion_insights'. This table provides a daily overview of conversion metrics for both online and offline, standard and custom conversion events, giving you a comprehensive view of your conversion data.

• Table will dynamically update based on your events defined in Facebook Ads console

Setting Up Facebook Ads Integration

Follow these steps to set up Facebook ads integration in Weld:

Step 1 - Begin Configuration

1. In the connector setup form, enter the destination schema name of your choice.
2. Click Authorize to allow Weld to access your Facebook account using OAuth. You will be redirected to your Facebook account to approve access.
3. Once authorization is complete, you will be redirected back to the Weld connections overview, and the configuration will be complete.

Step 2 - Connection Settings

1. Select all the Facebook Ad accounts you want to sync data from.
2. Limit historical data to only sync data after a selected date to include only that data in the initial sync.

Step 3 - Data to Sync

1. Select the pre-built reports you wish to include in the sync.
2. Create customized Facebook Ads reports tailored to your specific requirements by defining dimensions, breakdowns, fields, and other criteria.

Step 4 - Configure Sync

1. Select how often you would like the data to sync.
2. Provide a unique destination table name.

For more detailed instructions, visit Weld's Facebook Ads Documentation.

Join Conversion Metrics with Facebook Ad Insights

You can integrate your conversion metrics with the rest of your Facebook ad insights using our SQL template available here. Below is an example of how to use the template:

1WITH stats AS (
2    SELECT *
3    FROM {{raw.facebook_ads.ad_insight}}
4),
5ad AS (
6    SELECT *
7    FROM {{raw.facebook_ads.ad}}
8),
9action_data AS (
10    SELECT * EXCEPT (account_id, account_name, account_currency, campaign_id, adset_id)
11    FROM {{raw.facebook_ads.ad_roas_insight_conversion_insights}}
12)
13SELECT
14    CAST(stats.date AS DATE) date_day,
15    stats.account_id,
16    stats.account_name,
17    stats.campaign_id,
18    stats.campaign_name,
19    stats.adset_id,
20    stats.adset_name,
21    stats.ad_id,
22    stats.ad_name,
23    bid_amount,
24    bid_type,
25    configured_domain,
26    configured_status,
27    created_time,
28    effective_status,
29    last_updated_by_app_id,
30    status,
31    updated_time,
32    spend,
33    reach,
34    impressions,
35    clicks,
36    inline_link_clicks,
37    ctr,
38    cpm,
39    cpc,
40    action_data.* EXCEPT (ad_id, date)
41FROM stats
42LEFT JOIN ad ON stats.ad_id = ad.id
43LEFT JOIN action_data ON action_data.ad_id = stats.ad_id
44AND CAST(action_data.date AS DATE) = CAST(stats.date AS DATE)
45ORDER BY created_time DESC;
46By following these steps and utilizing our tools, you can efficiently track and analyze your Facebook conversion data, enhancing your marketing strategies and business outcomes.
47