Latest ETL Run: 20260709154547 |
Status: SUCCESS
Source tables: total=,
loaded=15,
failed=,
rows=16206
{"summary": {"source_mode": "v2", "loaded_tables": 15, "loaded_rows": 16206, "dq_issue_types": 3, "dq_issue_rows": 2753, "preserved_reporting_tables": 0, "preserved_reporting_rows": 0, "source_v2_refresh_tables": 39, "source_v2_refresh_rows": 78518}, "source_v2_refresh_counts": {"raw_v2_master.campaign_v2": 33, "raw_v2_master.campaign_v2__incoming": 15, "raw_v2_master.campaign_v2__preserved_existing": 18, "raw_v2_master.field_rep_v2": 554, "raw_v2_master.field_rep_v2__incoming": 551, "raw_v2_master.field_rep_v2__preserved_existing": 3, "raw_v2_master.campaign_field_rep_assignment_v2": 2605, "raw_v2_master.campaign_field_rep_assignment_v2__incoming": 834, "raw_v2_master.campaign_field_rep_assignment_v2__preserved_existing": 1771, "raw_v2_master.doctor_field_rep_roster_bridge_v2": 6489, "raw_v2_master.doctor_field_rep_roster_bridge_v2__incoming": 3298, "raw_v2_master.doctor_field_rep_roster_bridge_v2__preserved_existing": 3191, "raw_v2_inclinic.inclinic_assigned_doctor_roster_v2": 6489, "raw_v2_inclinic.inclinic_assigned_doctor_roster_v2__incoming": 3298, "raw_v2_inclinic.inclinic_assigned_doctor_roster_v2__preserved_existing": 3191, "raw_v2_inclinic.inclinic_collateral_v2": 52, "raw_v2_inclinic.inclinic_collateral_v2__incoming": 52, "raw_v2_inclinic.inclinic_collateral_v2__preserved_existing": 0, "raw_v2_inclinic.inclinic_campaign_collateral_v2": 27, "raw_v2_inclinic.inclinic_campaign_collateral_v2__incoming": 27, "raw_v2_inclinic.inclinic_campaign_collateral_v2__preserved_existing": 0, "raw_v2_inclinic.inclinic_campaign_field_rep_assignment_v2": 1804, "raw_v2_inclinic.inclinic_campaign_field_rep_assignment_v2__incoming": 797, "raw_v2_inclinic.inclinic_campaign_field_rep_assignment_v2__preserved_existing": 1007, "raw_v2_inclinic.inclinic_collateral_transaction_v2": 3993, "raw_v2_inclinic.inclinic_collateral_transaction_v2__incoming": 335, "raw_v2_inclinic.inclinic_collateral_transaction_v2__preserved_existing": 3658, "raw_v2_inclinic.inclinic_share_event_v2": 3309, "raw_v2_inclinic.inclinic_share_event_v2__incoming": 3309, "raw_v2_inclinic.inclinic_share_event_v2__preserved_existing": 0, "raw_v2_inclinic.inclinic_field_rep_identity_v2": 5695, "raw_v2_inclinic.inclinic_field_rep_identity_v2__incoming": 3567, "raw_v2_inclinic.inclinic_field_rep_identity_v2__preserved_existing": 2128, "raw_v2_inclinic.inclinic_campaign_v2": 34, "raw_v2_inclinic.inclinic_campaign_v2__incoming": 18, "raw_v2_inclinic.inclinic_campaign_v2__preserved_existing": 16, "raw_v2_inclinic.migration_exception_v2": 8175, "raw_v2_inclinic.migration_exception_v2__incoming": 7755, "raw_v2_inclinic.migration_exception_v2__preserved_existing": 420}, "counts": {"silver.dim_campaign": 15, "silver.dim_field_rep": 551, "silver.dim_campaign_field_rep_assignment": 834, "silver.dim_doctor": 5022, "silver.dim_collateral": 28, "silver.bridge_campaign_collateral_schedule": 25, "silver.fact_share_log": 3240, "silver.fact_collateral_transaction": 312, "silver.map_brand_campaign_to_campaign": 22, "silver.bridge_brand_campaign_doctor_base": 3285, "silver.doctor_action_first_seen": 2661, "ops.reporting_data_correction_rule_active": 125, "ops.reporting_campaign_privacy_allowlist_active": 0, "ops.reporting_person_privacy_rule_active": 0, "ops.reporting_raw_visibility_rule_active": 86}, "preservation_counts": {}, "issues": {"SHARE_DOCTOR_PHONE_AMBIGUOUS": 2557, "transaction_field_rep_identifier_conflict": 193, "transaction_field_rep_identifier_missing": 3}, "errors": {}}
Gold campaign schemas: 47
Schema: raw_server1
| Table | Exists | Row Count | Error |
|---|
| campaign_fieldrep |
Yes |
2119 |
- |
| auth_user |
Yes |
519 |
- |
| campaign_campaignfieldrep |
Yes |
1007 |
- |
| campaign_campaign |
Yes |
28 |
- |
Schema: raw_server2
| Table | Exists | Row Count | Error |
|---|
| campaign_management_campaign |
Yes |
16 |
- |
| campaign_management_campaignassignment |
Yes |
207 |
- |
| admin_dashboard_fieldrepcampaign |
Yes |
207 |
- |
| collateral_management_campaigncollateral |
Yes |
25 |
- |
| collateral_management_collateral |
Yes |
28 |
- |
| sharing_management_sharelog |
Yes |
2130 |
- |
| sharing_management_fieldrepresentative |
Yes |
0 |
- |
| sharing_management_collateraltransaction |
Yes |
3352 |
- |
| doctor_viewer_doctor |
Yes |
3177 |
- |
| prefilled_doctor |
Yes |
0 |
- |
| user_management_user |
Yes |
213 |
- |
Schema: bronze
| Table | Exists | Row Count | Error |
|---|
| campaign_fieldrep |
Yes |
551 |
- |
| auth_user |
Yes |
513 |
- |
| campaign_campaignfieldrep |
Yes |
834 |
- |
| campaign_campaign |
Yes |
15 |
- |
| campaign_management_campaign |
Yes |
15 |
- |
| campaign_management_campaignassignment |
Yes |
207 |
- |
| admin_dashboard_fieldrepcampaign |
Yes |
207 |
- |
| collateral_management_campaigncollateral |
Yes |
25 |
- |
| collateral_management_collateral |
Yes |
28 |
- |
| sharing_management_sharelog |
Yes |
2128 |
- |
| sharing_management_fieldrepresentative |
Yes |
0 |
- |
| sharing_management_collateraltransaction |
Yes |
2811 |
- |
| doctor_viewer_doctor |
Yes |
3092 |
- |
| prefilled_doctor |
Yes |
0 |
- |
| user_management_user |
Yes |
207 |
- |
Schema: silver
| Table | Exists | Row Count | Error |
|---|
| dim_field_rep |
Yes |
551 |
- |
| dim_doctor |
Yes |
5022 |
- |
| dim_collateral |
Yes |
28 |
- |
| bridge_campaign_collateral_schedule |
Yes |
25 |
- |
| fact_collateral_transaction |
Yes |
312 |
- |
| map_brand_campaign_to_campaign |
Yes |
22 |
- |
| bridge_brand_campaign_doctor_base |
Yes |
3285 |
- |
| doctor_action_first_seen |
Yes |
2661 |
- |
Schema: gold_global
| Table | Exists | Row Count | Error |
|---|
| campaign_registry |
Yes |
40 |
- |
| campaign_health_history |
Yes |
1029 |
- |
| benchmark_last_10_campaigns |
Yes |
1 |
- |
Schema: control
| Table | Exists | Row Count | Error |
|---|
| etl_run_log |
Yes |
290 |
- |
Per-Campaign GOLD Schemas
gold_campaign_b9cb94105e234cf8a492a716cba47880
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c4de5419627c4fb0833f6c17e2bb52eb
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_01b05f263a1443d48f6bd1519a4bae9c
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
17 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_01b05f26_3a14_43d4_8f6b_d1519a4bae9c
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
17 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_01d85412271749c28026bd0f6e8ac577
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_1151a492947b4c9183ac5a224b2d07b1
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_1151a492_947b_4c91_83ac_5a224b2d07b1
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_12
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
3 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_13
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
3 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_14
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
0 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_162
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
2 |
- |
| kpi_weekly_summary |
Yes |
2 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_1c17550b_e003_4449_a64e_a28ff312ac26
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
0 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_2
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
17 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_28c377653ec04554a377b8a93460b109
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
3 |
- |
| kpi_weekly_summary |
Yes |
3 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_28c37765_3ec0_4554_a377_b8a93460b109
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
9 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_2c0ca88e0b9942f59d9e5d25ffbb4a81
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
2 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_2c0ca88e_0b99_42f5_9d9e_5d25ffbb4a81
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_3
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
0 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_306125505ff5463ba5c903c15cd8976b
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_3a1f3b3f046449a9abbe84a348869a91
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_3df8f676_ec6b_4a79_8e84_f60a18e3138b
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
0 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_3df8f676ec6b4a798e84f60a18e3138b
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
2 |
- |
| kpi_weekly_summary |
Yes |
28 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_4
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
17 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_4025e9dbbcb645bfa3e43df06bf213d2
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
15 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_4ad26d90558c41fea3ad7bf13b5615ed
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
32 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_599a20233ab94227b82c5f0a1bc36579
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
4 |
- |
| kpi_weekly_summary |
Yes |
15 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_599a2023_3ab9_4227_b82c_5f0a1bc36579
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_6
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
0 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_7
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
17 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_79a08a0929014bb4a2cc84bcfc1f671c
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_8021a38932014986bd9bf6431f12d421
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_8021a389_3201_4986_bd9b_f6431f12d421
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
2 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_8065571faf0545d99d9da35ed55580a5
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_82
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
2 |
- |
| kpi_weekly_summary |
Yes |
27 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_83ce7fc7_c965_433a_b2b9_717394abe3c1
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
4 |
- |
| kpi_weekly_summary |
Yes |
27 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_83ce7fc7c965433ab2b9717394abe3c1
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
2696 |
- |
| kpi_weekly_summary |
Yes |
32 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_84eb443406464fb4b61a04721919db3f
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_c_9
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
0 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_c_9f3abbb6b73d4d8b8c86b7c8d5f1de96
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
15 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_d66ffdb423e2491fb08b216199cbb385
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_d9729fdbebfa4e2e9e3fe9e01a294ad1
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
28 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_dbf7e930c6ad4bb3ac55a033a3a4ad73
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_f333781479d248ceaf01b9e20849de77
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_f3337814_79d2_48ce_af01_b9e20849de77
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
10 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_f7261e2e177c41a89cccf8cf38426be4
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
1 |
- |
| kpi_weekly_summary |
Yes |
19 |
- |
| weekly_action_items |
No |
0 |
- |
gold_campaign_f7261e2e_177c_41a8_9ccc_f8cf38426be4
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
0 |
- |
| weekly_action_items |
Yes |
0 |
- |
gold_campaign_f87f92b11f4e477d813e1ea65c418b1c
| Table | Exists | Row Count | Error |
|---|
| fact_doctor_collateral_latest |
Yes |
0 |
- |
| kpi_weekly_summary |
Yes |
1 |
- |
| weekly_action_items |
No |
0 |
- |