Skip to content

Instantly share code, notes, and snippets.

@absyah

absyah/from mojaco

Created September 28, 2016 02:24
Show Gist options
  • Save absyah/b1d59d708d0f1203ce75e7ec874822d7 to your computer and use it in GitHub Desktop.
Save absyah/b1d59d708d0f1203ce75e7ec874822d7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
from mojaco
{"data"=>
[{"date_start"=>"2016-08-30",
"date_stop"=>"2016-09-28",
"account_id"=>"1378976532319552",
"account_name"=>"日本ロレアル/HDY",
"campaign_id"=>"6051654876004",
"campaign_name"=>"MAYBELLINE_HSL_video_fb_cv_160805_0905",
"adset_id"=>"6051654882204",
"adset_name"=>"MAYBELLINE_HSL_video_イベント_160805_0905",
"objective"=>"VIDEO_VIEWS",
"actions"=>
[{"action_type"=>"link_click", "value"=>151},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>14},
{"action_type"=>"post", "value"=>1},
{"action_type"=>"post_like", "value"=>49},
{"action_type"=>"video_play", "value"=>187},
{"action_type"=>"video_view", "value"=>25765},
{"action_type"=>"page_engagement", "value"=>25966},
{"action_type"=>"post_engagement", "value"=>25966},
{"action_type"=>"offsite_conversion", "value"=>14}],
"unique_actions"=>
[{"action_type"=>"link_click", "value"=>148},
{"action_type"=>"offsite_conversion", "value"=>13},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>13},
{"action_type"=>"page_engagement", "value"=>24344},
{"action_type"=>"post", "value"=>1},
{"action_type"=>"post_engagement", "value"=>24344},
{"action_type"=>"post_like", "value"=>40},
{"action_type"=>"video_play", "value"=>185},
{"action_type"=>"video_view", "value"=>24320}],
"total_actions"=>25980,
"total_unique_actions"=>24344,
"total_action_value"=>0,
"impressions"=>"99014",
"social_impressions"=>15218,
"clicks"=>1097,
"social_clicks"=>165,
"unique_impressions"=>91664,
"unique_social_impressions"=>14368,
"unique_clicks"=>1040,
"unique_social_clicks"=>159,
"spend"=>29391,
"frequency"=>1.0801841508117,
"deeplink_clicks"=>0,
"app_store_clicks"=>0,
"website_clicks"=>0,
"cost_per_inline_post_engagement"=>25.25,
"inline_link_clicks"=>151,
"cost_per_inline_link_click"=>194.64238410596,
"inline_post_engagement"=>1164,
"unique_inline_link_clicks"=>148,
"cost_per_unique_inline_link_click"=>198.58783783784,
"inline_link_click_ctr"=>0.15250368634739,
"unique_inline_link_click_ctr"=>0.16145924245069,
"reach"=>91664,
"social_reach"=>14368,
"ctr"=>1.1079241319409,
"unique_ctr"=>1.1345784604643,
"unique_link_clicks_ctr"=>0.16145924245069,
"cpc"=>26.792160437557,
"cpm"=>296.83681095603,
"cpp"=>320.63841857218,
"cost_per_total_action"=>1.1312933025404,
"cost_per_action_type"=>
[{"action_type"=>"link_click", "value"=>194.64238410596},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>2099.3571428571},
{"action_type"=>"post", "value"=>29391},
{"action_type"=>"post_like", "value"=>599.81632653061},
{"action_type"=>"video_play", "value"=>157.17112299465},
{"action_type"=>"video_view", "value"=>1.1407335532699},
{"action_type"=>"page_engagement", "value"=>1.1319032581068},
{"action_type"=>"post_engagement", "value"=>1.1319032581068},
{"action_type"=>"offsite_conversion", "value"=>2099.3571428571}],
"cost_per_unique_click"=>28.260576923077,
"cost_per_10_sec_video_view"=>[{"action_type"=>"video_view", "value"=>2.1418889374727}],
"cost_per_unique_action_type"=>
[{"action_type"=>"link_click", "value"=>198.58783783784},
{"action_type"=>"offsite_conversion", "value"=>2260.8461538462},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>2260.8461538462},
{"action_type"=>"page_engagement", "value"=>1.2073200788695},
{"action_type"=>"post", "value"=>29391},
{"action_type"=>"post_engagement", "value"=>1.2073200788695},
{"action_type"=>"post_like", "value"=>734.775},
{"action_type"=>"video_play", "value"=>158.87027027027},
{"action_type"=>"video_view", "value"=>1.2085115131579}],
"website_ctr"=>[{"action_type"=>"link_click", "value"=>0.15250368634739}],
"video_avg_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>17}],
"video_avg_pct_watched_actions"=>[{"action_type"=>"video_view", "value"=>100}],
"video_p25_watched_actions"=>[{"action_type"=>"video_view", "value"=>21332}],
"video_p50_watched_actions"=>[{"action_type"=>"video_view", "value"=>14760}],
"video_p75_watched_actions"=>[{"action_type"=>"video_view", "value"=>13271}],
"video_p95_watched_actions"=>[{"action_type"=>"video_view", "value"=>11167}],
"video_p100_watched_actions"=>[{"action_type"=>"video_view", "value"=>9423}],
"video_complete_watched_actions"=>[{"action_type"=>"video_view", "value"=>10672}],
"video_10_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>13722}],
"video_15_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>10705}],
"video_30_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>10672}],
"estimated_ad_recallers"=>7530,
"estimated_ad_recallers_lower_bound"=>7530,
"estimated_ad_recallers_upper_bound"=>7530,
"estimated_ad_recall_rate"=>8.2147844300925,
"estimated_ad_recall_rate_lower_bound"=>8.2147844300925,
"estimated_ad_recall_rate_upper_bound"=>8.2147844300925,
"cost_per_estimated_ad_recallers"=>3.903187250996,
"canvas_avg_view_time"=>0,
"canvas_avg_view_percent"=>0,
"gender"=>"female"},
{"date_start"=>"2016-08-30",
"date_stop"=>"2016-09-28",
"account_id"=>"1378976532319552",
"account_name"=>"日本ロレアル/HDY",
"campaign_id"=>"6051654876004",
"campaign_name"=>"MAYBELLINE_HSL_video_fb_cv_160805_0905",
"adset_id"=>"6051654882004",
"adset_name"=>"MAYBELLINE_HSL_video_ファッション_160805_0905",
"objective"=>"VIDEO_VIEWS",
"actions"=>
[{"action_type"=>"link_click", "value"=>101},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>15},
{"action_type"=>"post", "value"=>2},
{"action_type"=>"post_like", "value"=>57},
{"action_type"=>"video_play", "value"=>116},
{"action_type"=>"video_view", "value"=>22984},
{"action_type"=>"page_engagement", "value"=>23144},
{"action_type"=>"post_engagement", "value"=>23144},
{"action_type"=>"offsite_conversion", "value"=>15}],
"unique_actions"=>
[{"action_type"=>"link_click", "value"=>100},
{"action_type"=>"offsite_conversion", "value"=>7},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>7},
{"action_type"=>"page_engagement", "value"=>22672},
{"action_type"=>"post", "value"=>2},
{"action_type"=>"post_engagement", "value"=>22672},
{"action_type"=>"post_like", "value"=>54},
{"action_type"=>"video_play", "value"=>116},
{"action_type"=>"video_view", "value"=>22656}],
"total_actions"=>23159,
"total_unique_actions"=>22680,
"total_action_value"=>0,
"impressions"=>"96794",
"social_impressions"=>16867,
"clicks"=>804,
"social_clicks"=>128,
"unique_impressions"=>90432,
"unique_social_impressions"=>16640,
"unique_clicks"=>766,
"unique_social_clicks"=>125,
"spend"=>29360,
"frequency"=>1.0703512031139,
"deeplink_clicks"=>0,
"app_store_clicks"=>0,
"website_clicks"=>0,
"cost_per_inline_post_engagement"=>35.288461538462,
"inline_link_clicks"=>101,
"cost_per_inline_link_click"=>290.69306930693,
"inline_post_engagement"=>832,
"unique_inline_link_clicks"=>100,
"cost_per_unique_inline_link_click"=>293.6,
"inline_link_click_ctr"=>0.10434531065975,
"unique_inline_link_click_ctr"=>0.11058032554848,
"reach"=>90432,
"social_reach"=>16640,
"ctr"=>0.83062999772713,
"unique_ctr"=>0.84704529370134,
"unique_link_clicks_ctr"=>0.11058032554848,
"cpc"=>36.517412935323,
"cpm"=>303.32458623468,
"cpp"=>324.66383581033,
"cost_per_total_action"=>1.2677576752019,
"cost_per_action_type"=>
[{"action_type"=>"link_click", "value"=>290.69306930693},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>1957.3333333333},
{"action_type"=>"post", "value"=>14680},
{"action_type"=>"post_like", "value"=>515.08771929825},
{"action_type"=>"video_play", "value"=>253.10344827586},
{"action_type"=>"video_view", "value"=>1.277410372433},
{"action_type"=>"page_engagement", "value"=>1.2685793294158},
{"action_type"=>"post_engagement", "value"=>1.2685793294158},
{"action_type"=>"offsite_conversion", "value"=>1957.3333333333}],
"cost_per_unique_click"=>38.328981723238,
"cost_per_10_sec_video_view"=>[{"action_type"=>"video_view", "value"=>2.4653623310102}],
"cost_per_unique_action_type"=>
[{"action_type"=>"link_click", "value"=>293.6},
{"action_type"=>"offsite_conversion", "value"=>4194.2857142857},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>4194.2857142857},
{"action_type"=>"page_engagement", "value"=>1.2949894142555},
{"action_type"=>"post", "value"=>14680},
{"action_type"=>"post_engagement", "value"=>1.2949894142555},
{"action_type"=>"post_like", "value"=>543.7037037037},
{"action_type"=>"video_play", "value"=>253.10344827586},
{"action_type"=>"video_view", "value"=>1.2959039548023}],
"website_ctr"=>[{"action_type"=>"link_click", "value"=>0.10434531065975}],
"video_avg_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>16}],
"video_avg_pct_watched_actions"=>[{"action_type"=>"video_view", "value"=>100}],
"video_p25_watched_actions"=>[{"action_type"=>"video_view", "value"=>18860}],
"video_p50_watched_actions"=>[{"action_type"=>"video_view", "value"=>12731}],
"video_p75_watched_actions"=>[{"action_type"=>"video_view", "value"=>11538}],
"video_p95_watched_actions"=>[{"action_type"=>"video_view", "value"=>9558}],
"video_p100_watched_actions"=>[{"action_type"=>"video_view", "value"=>7957}],
"video_complete_watched_actions"=>[{"action_type"=>"video_view", "value"=>9165}],
"video_10_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>11909}],
"video_15_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>9200}],
"video_30_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>9165}],
"estimated_ad_recallers"=>7180,
"estimated_ad_recallers_lower_bound"=>7180,
"estimated_ad_recallers_upper_bound"=>7180,
"estimated_ad_recall_rate"=>7.9396673743808,
"estimated_ad_recall_rate_lower_bound"=>7.9396673743808,
"estimated_ad_recall_rate_upper_bound"=>7.9396673743808,
"cost_per_estimated_ad_recallers"=>4.0891364902507,
"canvas_avg_view_time"=>0,
"canvas_avg_view_percent"=>0,
"gender"=>"female"},
{"date_start"=>"2016-08-30",
"date_stop"=>"2016-09-28",
"account_id"=>"1378976532319552",
"account_name"=>"日本ロレアル/HDY",
"campaign_id"=>"6051654876004",
"campaign_name"=>"MAYBELLINE_HSL_video_fb_cv_160805_0905",
"adset_id"=>"6051654875804",
"adset_name"=>"MAYBELLINE_HSL_video_アイライナー_160805_0905",
"objective"=>"VIDEO_VIEWS",
"actions"=>
[{"action_type"=>"link_click", "value"=>187},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>26},
{"action_type"=>"post", "value"=>2},
{"action_type"=>"post_like", "value"=>67},
{"action_type"=>"video_play", "value"=>307},
{"action_type"=>"video_view", "value"=>38647},
{"action_type"=>"page_engagement", "value"=>38903},
{"action_type"=>"post_engagement", "value"=>38903},
{"action_type"=>"offsite_conversion", "value"=>26}],
"unique_actions"=>
[{"action_type"=>"link_click", "value"=>187},
{"action_type"=>"offsite_conversion", "value"=>21},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>21},
{"action_type"=>"page_engagement", "value"=>38064},
{"action_type"=>"post", "value"=>2},
{"action_type"=>"post_engagement", "value"=>38064},
{"action_type"=>"post_like", "value"=>66},
{"action_type"=>"video_play", "value"=>304},
{"action_type"=>"video_view", "value"=>38064}],
"total_actions"=>38929,
"total_unique_actions"=>38112,
"total_action_value"=>0,
"impressions"=>"161525",
"social_impressions"=>23605,
"clicks"=>1456,
"social_clicks"=>187,
"unique_impressions"=>152832,
"unique_social_impressions"=>21088,
"unique_clicks"=>1401,
"unique_social_clicks"=>175,
"spend"=>29097,
"frequency"=>1.05687944933,
"deeplink_clicks"=>0,
"app_store_clicks"=>0,
"website_clicks"=>0,
"cost_per_inline_post_engagement"=>19.51509054326,
"inline_link_clicks"=>187,
"cost_per_inline_link_click"=>155.59893048128,
"inline_post_engagement"=>1491,
"unique_inline_link_clicks"=>187,
"cost_per_unique_inline_link_click"=>155.59893048128,
"inline_link_click_ctr"=>0.11577155239127,
"unique_inline_link_click_ctr"=>0.12235657453936,
"reach"=>152832,
"social_reach"=>21088,
"ctr"=>0.90140845070423,
"unique_ctr"=>0.91669283919598,
"unique_link_clicks_ctr"=>0.12235657453936,
"cpc"=>19.984203296703,
"cpm"=>180.1392973224,
"cpp"=>190.38552135678,
"cost_per_total_action"=>0.74743764288834,
"cost_per_action_type"=>
[{"action_type"=>"link_click", "value"=>155.59893048128},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>1119.1153846154},
{"action_type"=>"post", "value"=>14548.5},
{"action_type"=>"post_like", "value"=>434.28358208955},
{"action_type"=>"video_play", "value"=>94.778501628665},
{"action_type"=>"video_view", "value"=>0.75289155691257},
{"action_type"=>"page_engagement", "value"=>0.74793717708146},
{"action_type"=>"post_engagement", "value"=>0.74793717708146},
{"action_type"=>"offsite_conversion", "value"=>1119.1153846154}],
"cost_per_unique_click"=>20.768736616702,
"cost_per_10_sec_video_view"=>[{"action_type"=>"video_view", "value"=>1.4150172640179}],
"cost_per_unique_action_type"=>
[{"action_type"=>"link_click", "value"=>155.59893048128},
{"action_type"=>"offsite_conversion", "value"=>1385.5714285714},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>1385.5714285714},
{"action_type"=>"page_engagement", "value"=>0.76442307692308},
{"action_type"=>"post", "value"=>14548.5},
{"action_type"=>"post_engagement", "value"=>0.76442307692308},
{"action_type"=>"post_like", "value"=>440.86363636364},
{"action_type"=>"video_play", "value"=>95.713815789474},
{"action_type"=>"video_view", "value"=>0.76442307692308}],
"website_ctr"=>[{"action_type"=>"link_click", "value"=>0.11577155239127}],
"video_avg_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>17}],
"video_avg_pct_watched_actions"=>[{"action_type"=>"video_view", "value"=>100}],
"video_p25_watched_actions"=>[{"action_type"=>"video_view", "value"=>31889}],
"video_p50_watched_actions"=>[{"action_type"=>"video_view", "value"=>21868}],
"video_p75_watched_actions"=>[{"action_type"=>"video_view", "value"=>19959}],
"video_p95_watched_actions"=>[{"action_type"=>"video_view", "value"=>16617}],
"video_p100_watched_actions"=>[{"action_type"=>"video_view", "value"=>13822}],
"video_complete_watched_actions"=>[{"action_type"=>"video_view", "value"=>15868}],
"video_10_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>20563}],
"video_15_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>15922}],
"video_30_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>15868}],
"estimated_ad_recallers"=>12200,
"estimated_ad_recallers_lower_bound"=>12200,
"estimated_ad_recallers_upper_bound"=>12200,
"estimated_ad_recall_rate"=>7.982621440536,
"estimated_ad_recall_rate_lower_bound"=>7.982621440536,
"estimated_ad_recall_rate_upper_bound"=>7.982621440536,
"cost_per_estimated_ad_recallers"=>2.385,
"canvas_avg_view_time"=>0,
"canvas_avg_view_percent"=>0,
"gender"=>"female"},
{"date_start"=>"2016-08-23",
"date_stop"=>"2016-09-21",
"account_id"=>"1378976532319552",
"account_name"=>"日本ロレアル/HDY",
"campaign_id"=>"6051654876004",
"campaign_name"=>"MAYBELLINE_HSL_video_fb_cv_160805_0905",
"adset_id"=>"6051654882004",
"adset_name"=>"MAYBELLINE_HSL_video_ファッション_160805_0905",
"objective"=>"VIDEO_VIEWS",
"total_actions"=>0,
"total_unique_actions"=>0,
"total_action_value"=>0,
"impressions"=>"1",
"social_impressions"=>1,
"clicks"=>0,
"social_clicks"=>0,
"unique_impressions"=>0,
"unique_social_impressions"=>0,
"unique_clicks"=>0,
"unique_social_clicks"=>0,
"spend"=>0,
"frequency"=>0,
"deeplink_clicks"=>0,
"app_store_clicks"=>0,
"website_clicks"=>0,
"cost_per_inline_post_engagement"=>0,
"inline_link_clicks"=>0,
"cost_per_inline_link_click"=>0,
"inline_post_engagement"=>0,
"unique_inline_link_clicks"=>0,
"cost_per_unique_inline_link_click"=>0,
"inline_link_click_ctr"=>0,
"unique_inline_link_click_ctr"=>0,
"reach"=>0,
"social_reach"=>0,
"ctr"=>0,
"unique_ctr"=>0,
"unique_link_clicks_ctr"=>0,
"cpc"=>0,
"cpm"=>0,
"cpp"=>0,
"cost_per_total_action"=>0,
"cost_per_unique_click"=>0,
"estimated_ad_recall_rate"=>0,
"estimated_ad_recall_rate_lower_bound"=>0,
"estimated_ad_recall_rate_upper_bound"=>0,
"cost_per_estimated_ad_recallers"=>0,
"canvas_avg_view_time"=>0,
"canvas_avg_view_percent"=>0,
"gender"=>"male"},
{"date_start"=>"2016-08-20",
"date_stop"=>"2016-09-18",
"account_id"=>"1378976532319552",
"account_name"=>"日本ロレアル/HDY",
"campaign_id"=>"6051654876004",
"campaign_name"=>"MAYBELLINE_HSL_video_fb_cv_160805_0905",
"adset_id"=>"6051654882204",
"adset_name"=>"MAYBELLINE_HSL_video_イベント_160805_0905",
"objective"=>"VIDEO_VIEWS",
"total_actions"=>0,
"total_unique_actions"=>0,
"total_action_value"=>0,
"impressions"=>"1",
"social_impressions"=>1,
"clicks"=>0,
"social_clicks"=>0,
"unique_impressions"=>0,
"unique_social_impressions"=>0,
"unique_clicks"=>0,
"unique_social_clicks"=>0,
"spend"=>0,
"frequency"=>0,
"deeplink_clicks"=>0,
"app_store_clicks"=>0,
"website_clicks"=>0,
"cost_per_inline_post_engagement"=>0,
"inline_link_clicks"=>0,
"cost_per_inline_link_click"=>0,
"inline_post_engagement"=>0,
"unique_inline_link_clicks"=>0,
"cost_per_unique_inline_link_click"=>0,
"inline_link_click_ctr"=>0,
"unique_inline_link_click_ctr"=>0,
"reach"=>0,
"social_reach"=>0,
"ctr"=>0,
"unique_ctr"=>0,
"unique_link_clicks_ctr"=>0,
"cpc"=>0,
"cpm"=>0,
"cpp"=>0,
"cost_per_total_action"=>0,
"cost_per_unique_click"=>0,
"estimated_ad_recall_rate"=>0,
"estimated_ad_recall_rate_lower_bound"=>0,
"estimated_ad_recall_rate_upper_bound"=>0,
"cost_per_estimated_ad_recallers"=>0,
"canvas_avg_view_time"=>0,
"canvas_avg_view_percent"=>0,
"gender"=>"male"}]}
Raw
from_api
{"data"=>
[{"date_start"=>"2016-08-05",
"date_stop"=>"2016-09-05",
"account_id"=>"1378976532319552",
"account_name"=>"日本ロレアル/HDY",
"buying_type"=>"AUCTION",
"campaign_id"=>"6051654876004",
"campaign_name"=>"MAYBELLINE_HSL_video_fb_cv_160805_0905",
"objective"=>"VIDEO_VIEWS",
"actions"=>
[{"action_type"=>"comment", "value"=>27},
{"action_type"=>"link_click", "value"=>6632},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>317},
{"action_type"=>"photo_view", "value"=>1},
{"action_type"=>"post", "value"=>143},
{"action_type"=>"post_like", "value"=>3610},
{"action_type"=>"video_play", "value"=>13688},
{"action_type"=>"video_view", "value"=>1985936},
{"action_type"=>"page_engagement", "value"=>1996349},
{"action_type"=>"post_engagement", "value"=>1996349},
{"action_type"=>"offsite_conversion", "value"=>317}],
"unique_actions"=>
[{"action_type"=>"comment", "value"=>22},
{"action_type"=>"link_click", "value"=>6548},
{"action_type"=>"offsite_conversion", "value"=>207},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>207},
{"action_type"=>"page_engagement", "value"=>1162240},
{"action_type"=>"photo_view", "value"=>1},
{"action_type"=>"post", "value"=>141},
{"action_type"=>"post_engagement", "value"=>1162240},
{"action_type"=>"post_like", "value"=>3056},
{"action_type"=>"video_play", "value"=>12372},
{"action_type"=>"video_view", "value"=>1161216}],
"total_actions"=>1996666,
"total_unique_actions"=>1162240,
"total_action_value"=>0,
"impressions"=>"6563570",
"social_impressions"=>965256,
"clicks"=>72477,
"social_clicks"=>10246,
"unique_impressions"=>1945081,
"unique_social_impressions"=>339454,
"unique_clicks"=>64815,
"unique_social_clicks"=>9647,
"spend"=>1902992,
"frequency"=>3.3744455886413,
"deeplink_clicks"=>0,
"app_store_clicks"=>0,
"website_clicks"=>0,
"cost_per_inline_post_engagement"=>25.540774145058,
"inline_link_clicks"=>6632,
"cost_per_inline_link_click"=>286.94089264174,
"inline_post_engagement"=>74508,
"unique_inline_link_clicks"=>6548,
"cost_per_unique_inline_link_click"=>290.62186927306,
"inline_link_click_ctr"=>0.10104257286812,
"unique_inline_link_click_ctr"=>0.33664407806153,
"reach"=>1945081,
"social_reach"=>339454,
"ctr"=>1.104231386273,
"unique_ctr"=>3.3322519730541,
"unique_link_clicks_ctr"=>0.33664407806153,
"cpc"=>26.256495163983,
"cpm"=>289.93246053596,
"cpp"=>978.36131245948,
"cost_per_total_action"=>0.95308479234885,
"cost_per_action_type"=>
[{"action_type"=>"comment", "value"=>70481.185185185},
{"action_type"=>"link_click", "value"=>286.94089264174},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>6003.1293375394},
{"action_type"=>"photo_view", "value"=>1902992},
{"action_type"=>"post", "value"=>13307.636363636},
{"action_type"=>"post_like", "value"=>527.14459833795},
{"action_type"=>"video_play", "value"=>139.02630040912},
{"action_type"=>"video_view", "value"=>0.95823430362308},
{"action_type"=>"page_engagement", "value"=>0.95323613255999},
{"action_type"=>"post_engagement", "value"=>0.95323613255999},
{"action_type"=>"offsite_conversion", "value"=>6003.1293375394}],
"cost_per_unique_click"=>29.360364113245,
"cost_per_10_sec_video_view"=>[{"action_type"=>"video_view", "value"=>1.7435400333317}],
"cost_per_unique_action_type"=>
[{"action_type"=>"comment", "value"=>86499.636363636},
{"action_type"=>"link_click", "value"=>290.62186927306},
{"action_type"=>"offsite_conversion", "value"=>9193.1980676328},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>9193.1980676328},
{"action_type"=>"page_engagement", "value"=>1.6373485682819},
{"action_type"=>"photo_view", "value"=>1902992},
{"action_type"=>"post", "value"=>13496.397163121},
{"action_type"=>"post_engagement", "value"=>1.6373485682819},
{"action_type"=>"post_like", "value"=>622.70680628272},
{"action_type"=>"video_play", "value"=>153.81441965729},
{"action_type"=>"video_view", "value"=>1.6387924382716}],
"website_ctr"=>[{"action_type"=>"link_click", "value"=>0.10104257286812}],
"video_avg_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>16}],
"video_avg_pct_watched_actions"=>[{"action_type"=>"video_view", "value"=>100}],
"video_p25_watched_actions"=>[{"action_type"=>"video_view", "value"=>1668204}],
"video_p50_watched_actions"=>[{"action_type"=>"video_view", "value"=>1158628}],
"video_p75_watched_actions"=>[{"action_type"=>"video_view", "value"=>1061675}],
"video_p95_watched_actions"=>[{"action_type"=>"video_view", "value"=>905508}],
"video_p100_watched_actions"=>[{"action_type"=>"video_view", "value"=>765415}],
"video_complete_watched_actions"=>[{"action_type"=>"video_view", "value"=>866541}],
"video_10_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>1091453}],
"video_15_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>869151}],
"video_30_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>866541}],
"estimated_ad_recallers"=>285000,
"estimated_ad_recallers_lower_bound"=>285000,
"estimated_ad_recallers_upper_bound"=>285000,
"estimated_ad_recall_rate"=>14.652346097669,
"estimated_ad_recall_rate_lower_bound"=>14.652346097669,
"estimated_ad_recall_rate_upper_bound"=>14.652346097669,
"cost_per_estimated_ad_recallers"=>6.6771649122807,
"canvas_avg_view_time"=>0,
"canvas_avg_view_percent"=>0,
"gender"=>"female"},
{"date_start"=>"2016-08-05",
"date_stop"=>"2016-09-05",
"account_id"=>"1378976532319552",
"account_name"=>"日本ロレアル/HDY",
"buying_type"=>"AUCTION",
"campaign_id"=>"6051654876004",
"campaign_name"=>"MAYBELLINE_HSL_video_fb_cv_160805_0905",
"objective"=>"VIDEO_VIEWS",
"total_actions"=>0,
"total_unique_actions"=>0,
"total_action_value"=>0,
"impressions"=>"7",
"social_impressions"=>3,
"clicks"=>0,
"social_clicks"=>0,
"unique_impressions"=>0,
"unique_social_impressions"=>0,
"unique_clicks"=>0,
"unique_social_clicks"=>0,
"spend"=>1,
"frequency"=>0,
"deeplink_clicks"=>0,
"app_store_clicks"=>0,
"website_clicks"=>0,
"cost_per_inline_post_engagement"=>0,
"inline_link_clicks"=>0,
"cost_per_inline_link_click"=>0,
"inline_post_engagement"=>0,
"unique_inline_link_clicks"=>0,
"cost_per_unique_inline_link_click"=>0,
"inline_link_click_ctr"=>0,
"unique_inline_link_click_ctr"=>0,
"reach"=>0,
"social_reach"=>0,
"ctr"=>0,
"unique_ctr"=>0,
"unique_link_clicks_ctr"=>0,
"cpc"=>0,
"cpm"=>142.85714285714,
"cpp"=>0,
"cost_per_total_action"=>0,
"cost_per_unique_click"=>0,
"video_avg_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>0}],
"video_avg_pct_watched_actions"=>[{"action_type"=>"video_view", "value"=>0}],
"estimated_ad_recall_rate"=>0,
"estimated_ad_recall_rate_lower_bound"=>0,
"estimated_ad_recall_rate_upper_bound"=>0,
"cost_per_estimated_ad_recallers"=>0,
"canvas_avg_view_time"=>0,
"canvas_avg_view_percent"=>0,
"gender"=>"male"}],
"summary"=>
{"date_start"=>"2016-08-05",
"date_stop"=>"2016-09-05",
"objective"=>"VIDEO_VIEWS",
"actions"=>
[{"action_type"=>"comment", "value"=>27},
{"action_type"=>"link_click", "value"=>6632},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>317},
{"action_type"=>"photo_view", "value"=>1},
{"action_type"=>"post", "value"=>143},
{"action_type"=>"post_like", "value"=>3610},
{"action_type"=>"video_play", "value"=>13688},
{"action_type"=>"video_view", "value"=>1985936},
{"action_type"=>"page_engagement", "value"=>1996349},
{"action_type"=>"post_engagement", "value"=>1996349},
{"action_type"=>"offsite_conversion", "value"=>317}],
"unique_actions"=>
[{"action_type"=>"comment", "value"=>22},
{"action_type"=>"link_click", "value"=>6548},
{"action_type"=>"offsite_conversion", "value"=>207},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>207},
{"action_type"=>"page_engagement", "value"=>1162240},
{"action_type"=>"photo_view", "value"=>1},
{"action_type"=>"post", "value"=>141},
{"action_type"=>"post_engagement", "value"=>1162240},
{"action_type"=>"post_like", "value"=>3056},
{"action_type"=>"video_play", "value"=>12372},
{"action_type"=>"video_view", "value"=>1161216}],
"total_actions"=>1996666,
"total_unique_actions"=>1162240,
"total_action_value"=>0,
"impressions"=>"6563577",
"social_impressions"=>965259,
"clicks"=>72477,
"social_clicks"=>10246,
"unique_impressions"=>1945081,
"unique_social_impressions"=>339454,
"unique_clicks"=>64815,
"unique_social_clicks"=>9647,
"spend"=>1902993,
"frequency"=>3.3744491874631,
"social_spend"=>260881,
"deeplink_clicks"=>0,
"app_store_clicks"=>0,
"website_clicks"=>72478,
"cost_per_inline_post_engagement"=>25.540787566436,
"inline_link_clicks"=>6632,
"cost_per_inline_link_click"=>286.94104342581,
"inline_post_engagement"=>74508,
"unique_inline_link_clicks"=>6548,
"cost_per_unique_inline_link_click"=>290.62202199145,
"inline_link_click_ctr"=>0.10104246510706,
"unique_inline_link_click_ctr"=>0.33664407806153,
"call_to_action_clicks"=>1103,
"reach"=>1945081,
"social_reach"=>339454,
"ctr"=>1.1042302086195,
"unique_ctr"=>3.3322519730541,
"unique_link_clicks_ctr"=>0.33664407806153,
"cpc"=>26.256508961464,
"cpm"=>289.93230368136,
"cpp"=>978.36182657689,
"cost_per_total_action"=>0.95308529318374,
"cost_per_action_type"=>
[{"action_type"=>"comment", "value"=>70481.222222222},
{"action_type"=>"link_click", "value"=>286.94104342581},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>6003.1324921136},
{"action_type"=>"photo_view", "value"=>1902993},
{"action_type"=>"post", "value"=>13307.643356643},
{"action_type"=>"post_like", "value"=>527.14487534626},
{"action_type"=>"video_play", "value"=>139.02637346581},
{"action_type"=>"video_view", "value"=>0.95823480716398},
{"action_type"=>"page_engagement", "value"=>0.95323663347441},
{"action_type"=>"post_engagement", "value"=>0.95323663347441},
{"action_type"=>"offsite_conversion", "value"=>6003.1324921136}],
"cost_per_unique_click"=>29.360379541773,
"cost_per_10_sec_video_view"=>[{"action_type"=>"video_view", "value"=>1.7435409495416}],
"cost_per_unique_action_type"=>
[{"action_type"=>"comment", "value"=>86499.681818182},
{"action_type"=>"link_click", "value"=>290.62202199145},
{"action_type"=>"offsite_conversion", "value"=>9193.2028985507},
{"action_type"=>"offsite_conversion.fb_pixel_complete_registration", "value"=>9193.2028985507},
{"action_type"=>"page_engagement", "value"=>1.6373494286894},
{"action_type"=>"photo_view", "value"=>1902993},
{"action_type"=>"post", "value"=>13496.404255319},
{"action_type"=>"post_engagement", "value"=>1.6373494286894},
{"action_type"=>"post_like", "value"=>622.70713350785},
{"action_type"=>"video_play", "value"=>153.81450048497},
{"action_type"=>"video_view", "value"=>1.6387932994378}],
"website_ctr"=>[{"action_type"=>"link_click", "value"=>0.10104246510706}],
"video_avg_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>16}],
"video_avg_pct_watched_actions"=>[{"action_type"=>"video_view", "value"=>100}],
"video_p25_watched_actions"=>[{"action_type"=>"video_view", "value"=>1668204}],
"video_p50_watched_actions"=>[{"action_type"=>"video_view", "value"=>1158628}],
"video_p75_watched_actions"=>[{"action_type"=>"video_view", "value"=>1061675}],
"video_p95_watched_actions"=>[{"action_type"=>"video_view", "value"=>905508}],
"video_p100_watched_actions"=>[{"action_type"=>"video_view", "value"=>765415}],
"video_complete_watched_actions"=>[{"action_type"=>"video_view", "value"=>866541}],
"video_10_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>1091453}],
"video_15_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>869151}],
"video_30_sec_watched_actions"=>[{"action_type"=>"video_view", "value"=>866541}],
"estimated_ad_recallers"=>285000,
"estimated_ad_recallers_lower_bound"=>285000,
"estimated_ad_recallers_upper_bound"=>285000,
"estimated_ad_recall_rate"=>14.652346097669,
"estimated_ad_recall_rate_lower_bound"=>14.652346097669,
"estimated_ad_recall_rate_upper_bound"=>14.652346097669,
"cost_per_estimated_ad_recallers"=>6.6771684210526,
"canvas_avg_view_time"=>0,
"canvas_avg_view_percent"=>0}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment