1. Knowledge base
  2. Meta (Facebook / Instagram)

How to set up Meta integration and create custom columns

Follow the steps below to set up the Meta integration with ProfitMetrics

Intro: Please read all options carefully

Part 1: Connect to Meta

Part 2: Select the conversion event

Part 3. Set up custom columns

Part 4: Summary of Default Setup


Intro: Please read all options carefully

ProfitMetrics allows you to send profit data into Meta. You can use your existing Pixel / Data set or create a completely new pixel for ProfitMetrics. Please select the option that best suits your needs.

Shopify Note: Once you have created your pixel/data set in Meta, you can follow this guide to install the pixel on your Shopify site.

 

Option A: Use Completed Registration (Recommended)
We will send conversion into the Completed Registration event using Gross Profit as the value.
Select: Completed Registration

Advantages:

  • Gives you the ability to compare the number of attributed conversions between ProfitMetrics and your existing tracking.
  • Display Gross Profit, Gross Profit After Ad Spend, and POAS for your existing campaigns
  • Ability to optimize your Campaigns for Completed Registration if you want to optimize for ProfitMetrics tracking.
  • No need to modify your existing tracking setup

Disadvantages:

  • The number of attributed conversions might be incorrect due to Data Modeling within Meta.
  • Can NOT be used to optimize for Profit by selecting "Maximize Value of Conversions" in Advantage+

 

Option B: Use your existing Pixel / Dataset and track Purchase event with Gross Profit value

We will send conversion into the Purchase event using Gross Profit as the value. Please note that the value will switch from Revenue to Gross Profit.

SHOPIFY: This is not possible using the default Meta integration for Shopify. We recommend using a third-party app like Pixee ‑ Multi Facebook Pixels instead.

Advantages:

  • Correct number of attributed Conversions
  • Can be used to optimize for Profit by selecting "Maximize Value of Conversions" in Advantage+

Disadvantages:

  • Need to exclude the purchase event from your existing tracking.
  • Lower conversion value as it switches from Revenue to Gross Profit

 

Option C: Create a new Pixel / Dataset and track Purchase event with Gross Profit value

We will send conversion into the Purchase event using Gross Profit as the value. 

Advantages:

  • Display Gross Profit, Gross Profit After Ad Spend, and POAS for new campaigns.
  • No need to modify your existing tracking setup
  • Can be used to optimize for Profit by selecting "Maximize Value of Conversions" in Advantage+

Disadvantages:

  • Lover conversion value as it switches from Revenue to Gross Profit
  • Does NOT give you the ability to compare the number of attributed conversions between ProfitMetrics and your existing tracking.
  • Does NOT give you the ability to Display Gross Profit, Gross Profit After Ad Spend, and POAS for your existing campaigns. Only new ones.

Part 1: Connect to Meta

  1. Login to https://my.profitmetrics.io
  2. Navigate to Integrations > Connections and click MetaConnecting Profit Metrics and Creating Custom Metrics in Ads Manager - Step 2
  3. Click "Continue with Facebook" and complete the login process.Connecting Profit Metrics and Creating Custom Metrics in Ads Manager - Step 3

Part 2: Select the conversion event

  1. Click the "Facebook Event" dropdown.
    How to Add or Update a Facebook Pixel ID - Step 3
  2. Select the desired Event to use for tracking as described in the intro above.
    Option A: Use Completed Registration (Recommended)
    Select Completed Registrations. Click save.

    Option B: Use your existing Pixel / Dataset and track Purchase event with Gross Profit value
    Select Completed Registrations and change 'Purchase Event' dropdown to 'Enabled'. Click save.

    Screenshot 2024-09-11 at 9.30.44 AM

CAUTION: 

All new data coming into the Purchase event will show the calculated Gross Profit, not Revenue, as before. Hence, it will not be possible to compare old and new data as these are very different values.


Disable any existing purchase event tracking from your website to prevent the mixing of purchase events from two different sources. (NOTE: This might not be possible on some platforms.) 

Option C: Create a new Pixel / Dataset and track Purchase event with Gross Profit value
Update the Pixel ID to the newly created Pixel ID. Select Completed Registrations and change 'Purchase Event' dropdown to 'Enabled'. Click save.
.


How to Add or Update a Facebook Pixel ID - Step 2
  1. Fill in your existing or new Pixel / Dataset ID and click Save.
    How to Add or Update a Facebook Pixel ID - Step 20
  2. Click OK
    How to Add or Update a Facebook Pixel ID - Step 21

Part 3. Set up custom columns

  1. Go to https://adsmanager.facebook.com/
  2. Click the Columns dropdown
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 2
  3. Click Customize columns
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 3
  4. Click Create custom metric
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 17
  5. Under Name, type PM Conversions
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 19
  6. Click Select metric dropdown
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 20
  7. Select:
    (A) Registrations Completed or Leads
    (B) Purchases
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 24
  8. Leave the Format set to Numeric
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 26
  9. Click the "Who can access this?" dropdown and select Everyone with access to this Business.
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 28
  10. Click Create metric
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 29
  11. Click Create custom metric
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 17
  12. Under Name, type PM Gross Profit
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 35
  13. Select:
    (Option A) Registrations Completed conversion value or Leads conversion value
    (Option B) Purchases conversion value
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 34
  14. Click Format dropdown and select Currency
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 36
  15. Click the "Who can access this?" dropdown and select Everyone with access to this Business.
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 28
  16. Click Create metric
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 29
  17. Click Create custom metric
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 17
  18. Under Name, type PM Gross Profit After Ad Spend
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 43
  19. Click Select metric dropdown
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 20
  20. Select:
    (A) Registrations Completed conversion value or Leads conversion value
    (B) Purchases conversion value
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 34
  21. Click minus / subtract
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 47
  22. Click Select metric dropdown
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 48
  23. Select Amount spend
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 50
  24. Click Format dropdown and select Currency
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 52

  25. Click the "Who can access this?" dropdown and select Everyone with access to this Business.
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 28
  26. Click Create metric
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 29
  27. Click Create custom metric
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 17
  28. Under Name, type PM POAS
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 58
  29. Click Select metric dropdown
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 20
  30. Select:
    (A) Registrations Completed conversion value or Leads conversion value
    (B) Purchases conversion value
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 34
  31. Click Divide
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 63
  32. Click Select metric dropdown
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 65
  33. Select Amount spend
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 50
  34. Leave the Format set to Numeric
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 26

  35. Click the "Who can access this?" dropdown and select Everyone with access to this Business.
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 28
  36. Click Create metric
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 29
  37. Activate your columns by selecting them from the list
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 81
  38. Check Save as column preset and name it "ProfitMetrics"Create Custom Metrics and Columns in Facebook Ads Manager - Step 82

  39. Click Apply
    Create Custom Metrics and Columns in Facebook Ads Manager - Step 85

That's it. You have now completed the integration and set up custom columns.


Summary of default setup:

  1. Go to Facebook Account -> Ads Manager -> Columns -> Customize columns.
  2. Create columns (4 Columns):
    1. Name: PM Conversions
      Format: Numeric(1,2,3)
      Description: Empty
      Formula: Registration Completed (If you chose Complete Registration)
      Access: Everyone
      Click: Create Metric
    2. Name: PM Gross Profit
      Format: Currency($)
      Description: Empty
      Formula: Registration Completed Conversion Value
      Access: Everyone
      Click: Create Metric
    3. Name: PM Gross Profit After Ad Spend
      Format: Currency($)
      Description: Empty
      Formula: Registration Completed Conversion Value (- minus) Amount Spend
      Access: Everyone
      Click: Create Metric
    4. Name: PM POAS
      Format: Numeric(1,2,3)
      Description: Empty
      Formula: Registration Completed Conversion Value (%-divide) Amount Spend
      Access: Everyone
      Click: Create Metric

Language Differences:

Completed Registrations  (English, Dutch, Danish):
Registration completed = Voltooide registraties = Fuldførte registreringer

Registration completed conversion value = Conversiewaarde voltooide registraties = Konverteringsværdi for fuldførte registreringer

Amount spend = Besteed bedrag = Brugt beløb

Leads (English, Dutch, Danish):

Leads = Leads = Leads

Leads conversion value = Conversiewaarde leads = Koverteringsværdi fra leads

Amount spend = Besteed bedrag = Brugt beløb