11-16-2023 05:51 AM
Hey!
Maybe somebody knows the answer to that 👇
In premade Facebook Ads report tables (destiation BigQuery) there is a table called:
basic_ad_set_cost_per_action_type
There are 3 values there that I need clarification on.
_1_d_view - cost of action based on 1 day view attribution
_7_d_click - cost of action based on 7 day click attribution
value - and this is the thing I don't know how its calculated?
Also, when I connect that to looker studio - if a aggregate "Value" by MIN - then its equal to the value in Facebook UI, when I use AVERAGE then its much higher.
Can somebody explain it to me by any chance?
Solved! Go to Solution.
11-22-2023 08:27 AM
Good day @Dawid_Wielec
I have found 2 resources for you and I hope they help.
Please ask any additional questions below.
Cheers,
Toby
11-16-2023 06:21 AM
Good day @Dawid_Wielec
Thank you for your question - I will investigate the calculation.
Best,
Toby
11-22-2023 08:27 AM
Good day @Dawid_Wielec
I have found 2 resources for you and I hope they help.
Please ask any additional questions below.
Cheers,
Toby
11-28-2023 12:35 PM
Good day @Dawid_Wielec
Following up on the links I shared to see if they were helpful and if you are all set?
If you are back in business, would you please mark my post as correct because it will make the answer easy for all Community members to find? If you have additional questions, would you please reply to this post?
Best,
Toby