Facebook insights not extracting conversion and conversion value data

How To
1

hey Guys,

im trying to send facebook metrics into an airtable crm and facebook get insights insights isnt pulling out conversion and cost per conversion values. Has anyone had this issue.

INPUT

  • Bundle 1Collection

    • SortArray

    • Get Insights for

campaign

  • Level

campaign

  • Limit

1

  • FieldsArray

  • Business Manager

1856279698028945

  • Campaign

120208341235190123

  • Ad Account

act_379567735778748

  • Date Preset

last_30d

  • Specify Date by

date_preset

  • Time Increment

all_days

  • Action BreakdownsArray

  • Action Attribution WindowsArray

  • Use Account Attribution Setting

true

OUTPUT

  • Bundle 1Collection

    • Account Currency

AUD

  • Account ID

379567735778748

  • Account Name

Darren Walters | No1 Property Guide | Main Acc

  • ActionsArray

  • Buying Type

AUCTION

  • Campaign ID

120208341235190123

  • Campaign Name

CREED | Bliss on Bracken | LEAD FORM | Adv+ 10/05/24

  • Clicks

1586

  • Conversion Rate Ranking

UNKNOWN

  • Cost Per Action TypeArray

  • Cost Per Inline Link Click

1.292827

  • Cost Per Inline Post Engagement

1.208852

  • Cost Per Outbound ClickArray

  • Cost Per Unique Action TypeArray

  • Cost Per Unique Click

0.750713

  • Cost Per Unique Inline Link Click

1.44191

  • Cost Per Unique Outbound ClickArray

  • CPC

0.504578

  • CPM

21.527991

  • CPP

39.08092

  • CTR

4.266538

  • Date Start

17 April 2024 12:00 AM

  • Date Stop

16 May 2024 12:00 AM

  • Engagement Rate Ranking

UNKNOWN

  • Frequency

1.815354

  • Full View Impressions

0

  • Full View Reach

0

  • Impressions

37173

  • Inline Link Click CTR

1.665187

  • Inline Link Clicks

619

  • Inline Post Engagement

662

  • Objective

OUTCOME_LEADS

  • Optimization Goal

Unknown Optimization Goal

  • Outbound ClicksArray

  • Outbound Clicks CTRArray

  • Quality Ranking

UNKNOWN

  • Reach

20477

  • Social Spend

75.12

  • Spend

800.26

  • Unique ActionsArray

  • Unique Clicks

1066

  • Unique CTR

5.205841

  • Unique Inline Link Click CTR

2.710358

  • Unique Inline Link Clicks

555

  • Unique Link Clicks CTR

2.710358

  • Unique Outbound ClicksArray

  • Unique Outbound Clicks CTRArray

  • Website CTRArray

  • Total number of bundles

1

  • Bundle order position

1

INPUT

  • Bundle 1Collection

    • id

120208341235190123

  • cpc

0.504578

  • cpm

21.527991

  • cpp

39.08092

  • ctr

4.266538

  • name

CREED | Bliss on Bracken | LEAD FORM | Adv+ 10/05/24

  • ad_id

empty

  • reach

20477

  • spend

800.26

  • clicks

1586

  • status

ACTIVE

  • actionsArray

  • ad_name

empty

  • adlabels

empty

  • adset_id

empty

  • date_stop

16 May 2024 12:00 AM

  • frequency

1.815354

  • objective

OUTCOME_LEADS

  • stop_time

empty

  • account_id

379567735778748

  • adset_name

empty

  • date_start

17 April 2024 12:00 AM

  • start_time

10 May 2024 4:50 PM

  • topline_id

0

  • unique_ctr

5.205841

  • buying_type

AUCTION

  • campaign_id

120208341235190123

  • conversions

empty

  • dda_results

empty

  • impressions

37173

  • pacing_type

empty

  • website_ctrArray

  • IMTINDEX

2

  • account_name

Darren Walters | No1 Property Guide | Main Acc

  • bid_strategy

empty

  • created_time

10 May 2024 4:50 PM

  • daily_budget

empty

  • social_spend

75.12

  • updated_time

10 May 2024 4:50 PM

  • IMTLENGTH

6

  • action_values

empty

  • campaign_name

CREED | Bliss on Bracken | LEAD FORM | Adv+ 10/05/24

  • purchase_roas

empty

  • unique_clicks

1066

  • unique_actionsArray

  • full_view_reach

0

  • lifetime_budget

empty

  • outbound_clicksArray

  • quality_ranking

UNKNOWN

  • source_campaignCollection

  • account_currency

AUD

  • budget_remaining

0

  • effective_status

ACTIVE

  • boosted_object_id

empty

  • can_use_spend_cap

true

  • configured_status

ACTIVE

  • conversion_values

empty

  • cost_per_thruplay

empty

  • optimization_goal

Unknown Optimization Goal

  • inline_link_clicks

619

  • source_campaign_id

120208256849330123

  • video_play_actions

empty

  • cost_per_conversion

empty

  • outbound_clicks_ctrArray

  • special_ad_category

NONE

  • canvas_avg_view_time

empty

  • cost_per_action_typeArray

  • smart_promotion_type

GUIDED_CREATION

  • budget_rebalance_flag

false

  • cost_per_unique_click

0.750713

  • full_view_impressions

0

  • inline_link_click_ctr

1.665187

  • special_ad_categoriesArray

  • website_purchase_roas

empty

  • estimated_ad_recallers

empty

  • inline_post_engagement

662

  • unique_link_clicks_ctr

2.710358

  • unique_outbound_clicksArray

  • canvas_avg_view_percent

empty

  • conversion_rate_ranking

UNKNOWN

  • converted_product_value

empty

  • cost_per_outbound_clickArray

  • engagement_rate_ranking

UNKNOWN

  • estimated_ad_recall_rate

empty

  • mobile_app_purchase_roas

empty

  • video_play_curve_actions

empty

  • unique_inline_link_clicks

555

  • video_p25_watched_actions

empty

  • video_p50_watched_actions

empty

  • video_p75_watched_actions

empty

  • video_p95_watched_actions

empty

  • converted_product_quantity

empty

  • cost_per_inline_link_click

1.292827

  • is_skadnetwork_attribution

false

  • unique_outbound_clicks_ctrArray

  • video_p100_watched_actions

empty

  • can_create_brand_lift_study

false

  • cost_per_unique_action_typeArray

  • unique_inline_link_click_ctr

2.710358

  • video_30_sec_watched_actions

empty

  • cost_per_unique_outbound_clickArray

  • video_avg_time_watched_actions

empty

  • video_thruplay_watched_actions

empty

  • cost_per_estimated_ad_recallers

empty

  • cost_per_inline_post_engagement

1.208852

  • cost_per_unique_inline_link_click

1.44191

  • instant_experience_clicks_to_open

empty

  • instant_experience_clicks_to_start

empty

  • instant_experience_outbound_clicks

empty

  • instagram_upcoming_event_reminders_set

empty

  • qualifying_question_qualify_answer_rate

empty

OUTPUT

  • Bundle 1Collection

    • ArrayArray

      • 1Collection

        • Campaign ID

120208341235190123

  * CPC

0.504578

  * CPM

21.527991

  * CPP

39.08092

  * CTR

4.266538

  * Campaign Name

CREED | Bliss on Bracken | LEAD FORM | Adv+ 10/05/24

  * Ad ID

empty

  * Reach

20477

  * Spend

800.26

  * Clicks

1586

  * Status

ACTIVE

  * Actions<small>Array</small>

  * Ad Name

empty

  * Ad Labels

empty

  * Adset ID

empty

  * Date Stop

16 May 2024 12:00 AM

  * Frequency

1.815354

  * Objective

OUTCOME_LEADS

  * Stop Time

empty

  * Account ID

379567735778748

  * Adset Name

empty

  * Date Start

17 April 2024 12:00 AM

  * Start Time

10 May 2024 4:50 PM

  * Topline ID

0

  * Unique CTR

5.205841

  * Buying Type

AUCTION

  * Campaign ID

120208341235190123

  * Conversions

empty

  * DDA Results

empty

  * Impressions

37173

  * Pacing Type

empty

  * Website CTR<small>Array</small>

  * Bundle order position

2

  * Account Name

Darren Walters | No1 Property Guide | Main Acc

  * Bid Strategy

empty

  * Created Time

10 May 2024 4:50 PM

  * daily_budget

empty

  * Social Spend

75.12

  * Updated Time

10 May 2024 4:50 PM

  * Total number of bundles

6

  * Action Values

empty

  * Campaign Name

CREED | Bliss on Bracken | LEAD FORM | Adv+ 10/05/24

  * Purchase ROAS

empty

  * Unique Clicks

1066

  * Unique Actions<small>Array</small>

  * Full View Reach

0

  * Lifetime Budget

empty

  * Outbound Clicks<small>Array</small>

  * Quality Ranking

UNKNOWN

  * source_campaign<small>Collection</small>

  * Account Currency

AUD

  * Budget Remaining

0

  * Effective Status

ACTIVE

  * Boosted Object ID

empty

  * Can Use Spend Cap

true

  * Configured Status

ACTIVE

  * Conversion Values

empty

  * Cost Per Thruplay

empty

  * Optimization Goal

Unknown Optimization Goal

  * Inline Link Clicks

619

  * Source Campaign ID

120208256849330123

  * Video Play Actions

empty

  * Cost Per Conversion

empty

  * Outbound Clicks CTR<small>Array</small>

  * Special Ad Category

NONE

  * Canvas Avg View Time

empty

  * Cost Per Action Type<small>Array</small>

  * Smart Promotion Type

GUIDED_CREATION

  * Budget Rebalance Flag

false

  * Cost Per Unique Click

0.750713

  * Full View Impressions

0

  * Inline Link Click CTR

1.665187

  * Special Ad Categories<small>Array</small>

  * Website Purchase ROAS

empty

  * Estimated Ad Recallers

empty

  * Inline Post Engagement

662

  * Unique Link Clicks CTR

2.710358

  * Unique Outbound Clicks<small>Array</small>

  * Canvas Avg View Percent

empty

  * Conversion Rate Ranking

UNKNOWN

  * Converted Product Value

empty

  * Cost Per Outbound Click<small>Array</small>

  * Engagement Rate Ranking

UNKNOWN

  * Estimated Ad Recall Rate

empty

  * Mobile App Purchase ROAS

empty

  * Video Play Curve Actions

empty

  * Unique Inline Link Clicks

555

  * Video P25 Watched Actions

empty

  * Video P50 Watched Actions

empty

  * Video P75 Watched Actions

empty

  * Video P95 Watched Actions

empty

  * Converted Product Quantity

empty

  * Cost Per Inline Link Click

1.292827

  * Is SKAdNetwork Attribution

false

  * Unique Outbound Clicks CTR<small>Array</small>

  * Video P100 Watched Actions

empty

  * Can Create Brand Lift Study

false

  * Cost Per Unique Action Type<small>Array</small>

  * Unique Inline Link Click CTR

2.710358

  * Video 30 Sec Watched Actions

empty

  * Cost Per Unique Outbound Click<small>Array</small>

  * Video Avg Time Watched Actions

empty

  * Video Thruplay Watched Actions

empty

  * Cost Per Estimated Ad Recallers

empty

  * Cost Per Inline Post Engagement

1.208852

  * Cost Per Unique Inline Link Click

1.44191

  * Instant Experience Clicks to Open

empty

  * Instant Experience Clicks to Start

empty

  * Instant Experience Outbound Clicks

empty

  * Instagram Upcoming Event Reminders Set

empty

  * Qualifying Question Qualify Answer Rate

empty

  • IMTAGGLENGTH

1

image
image1395Ă—316 39.6 KB

image
image549Ă—944 62.5 KB

image
image483Ă—931 55.8 KB

image
image510Ă—989 79.2 KB

3

Hey mate, Did you find a solution?

4

No, I havent. Make.com developers/support gave up on the issue

5

Can someone help us here? I have the same issue. @samliew

6

Welcome to the Make community!

Make doesn’t have an integration for this third-party service, or a module for this particular endpoint, or the module does not output all the available data that you are expecting from the external API.

If the external service has a Developer API Reference/Documentation then you should be able to integrate the endpoints in Make using the app’s universal module (Make an API call) or generic HTTP “Make a request” module.

You can also suggest for it to be made in the Idea exchange. Don’t forget to search for it first, just in case someone already suggested it, so that you don’t end up creating a duplicate.
Screenshot_2024-01-17_130153

If you need assistance in setting up the app’s universal module, or the generic HTTP module, please provide additional information about what you have tried with regards to the external service’s Developer API Reference – how you are setting the connection up, a link to the endpoint are you trying to connect to, and what errors you are encountering.

You can also complete this brand new course/tutorial in the Make Academy on how to use external APIs — API calls with HTTP modules

  • API and Endpoints
  • Header and body
  • Multipart/form-data
  • OAuth 2.0

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

3 Likes
7

Are you able to show how we can create a HTTP module api call for facebook conversions and cost per conversions for get insights

8

Sorry, I am unable to provide a tutorial as this requires a lot of work to set up, since I do not specialize in Facebook Business.

The options you have is to make a feature request, do it yourself, or hire someone to do it for you.

You can also complete this brand new course/tutorial in the Make Academy on how to use external APIs — API calls with HTTP modules

  • API and Endpoints
  • Header and body
  • Multipart/form-data
  • OAuth 2.0

If it is urgent, you can also hire a professional by posting in the Professional Services category.Welcome to the Make community!

2 Likes