Trouble with tabulating data

Copper Contributor

I have a bit of trouble trying to tabulate the data in the right way.

 

So this project was to tabulate the data exported from facebook ads.

In which so far I was able to achieve this:

 

 

But I want to seperate out the list of records in cost_per-unique_action_type to achieve something like this

 

8e2036cd857848cee3cd8f308424f4d9.png

 

 

 

1 Reply
{
"data": [
{
"campaign_name": "A",
"objective": "CONVERSIONS",
"spend": "1.00",
"impressions": "2.00",
"cpm": "3.00",
"purchase_roas": [
{
"action_type": "omni_purchase",
"value": "4.00"
}
],
"cost_per_unique_action_type": [
{
"action_type": "omni_purchase",
"value": "5.00"
},
{
"action_type": "video_view",
"value": "6.00"
},
{
"action_type": "landing_page_view",
"value": "7.00"
},
{
"action_type": "onsite_conversion.post_save",
"value": "8.00"
},
{
"action_type": "link_click",
"value": "9.00"
},
{
"action_type": "omni_view_content",
"value": "10.00"
},
{
"action_type": "post_engagement",
"value": "11.00"
},
{
"action_type": "page_engagement",
"value": "12.00"
},
{
"action_type": "add_payment_info",
"value": "13.00"
},
{
"action_type": "omni_add_to_cart",
"value": "14.00"
},
{
"action_type": "omni_initiated_checkout",
"value": "15.00"
},
{
"action_type": "omni_search",
"value": "16.00"
}
],
"date_start": "2020-05-14",
"date_stop": "2020-05-14"
},
{
"campaign_name": "B",
"objective": "CONVERSIONS",
"spend": "1.00",
"impressions": "2.00",
"cpm": "3.00",
"purchase_roas": [
{
"action_type": "omni_purchase",
"value": "4.00"
}
],
"cost_per_unique_action_type": [
{
"action_type": "omni_purchase",
"value": "5.00"
},
{
"action_type": "video_view",
"value": "6.00"
},
{
"action_type": "landing_page_view",
"value": "7.00"
},
{
"action_type": "onsite_conversion.post_save",
"value": "8.00"
},
{
"action_type": "link_click",
"value": "9.00"
},
{
"action_type": "omni_view_content",
"value": "10.00"
},
{
"action_type": "post_engagement",
"value": "11.00"
},
{
"action_type": "page_engagement",
"value": "12.00"
},
{
"action_type": "add_payment_info",
"value": "13.00"
},
{
"action_type": "omni_add_to_cart",
"value": "14.00"
},
{
"action_type": "omni_initiated_checkout",
"value": "15.00"
},
{
"action_type": "omni_search",
"value": "16.00"
}
],
"date_start": "2020-05-14",
"date_stop": "2020-05-14"
}
}]}