Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Typhoon
-
Fix Version/s: Typhoon
-
Component/s: None
-
Labels:None
-
Sprint:Sprint 28
Description
Run:
./facebookreport.sh -d5 -U 4617 -rt account -T 2021-03-12 -E 2021-03-13
Table data:
SELECT * FROM staging.facebookAccountPerformanceReports;
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| startTime | account_id | account_name | clicks | link_click | page_engagement | post_engagement | video_view | lead | leadgen_grouped | landing_page_view | purchase | spend | cost_per_link_click | cost_per_page_engagement | cost_per_post_engagement | cost_per_video_view | cost_per_lead | cost_per_leadgen_grouped | cost_per_landing_page_view | cost_per_purchanse | cost_per_unique_link_click | cost_per_unique_page_engagement | cost_per_unique_post_engagement | cost_per_unique_video_view | cost_per_unique_lead | cost_per_unique_leadgen_grouped | cost_per_unique_landing_page_view | cost_per_unique_click | cpc | cpm | cpp | ctr | frequency | impressions | objective | reach | unique_actions_link_click | unique_actions_page_engagement | unique_actions_post_engagement | unique_actions_video_view | unique_actions_lead | unique_actions_leadgen_grouped | unique_actions_landing_page_view | unique_clicks | unique_ctr |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 2021-03-12 | 184065229930291 | d0c81a82-aa30-46ef-b067-29fc170658bb_qa4amltest_AdmaxLocalActivePage | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 5 | 5 | 2.95683 | 5.324814 | 0.059137 | 1.800852 | 1691 | REACH | 939 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0.106496 |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
