EG: Create Snapshots from Azure Analysis Services daily ad data

[jesusitd]

Making connections with Python and PythonNET.

MySQL Prod2:

INSERT INTO bi_snapshots.azure_as_pid_snapshots (
    snapshot_timestamp,
    platform_itd,
    pid,
    lead_type,
    ad_id,
    leads_gross,
    leads_spam,
    leads_suspect,
    leads_duplicates, 
    leads_net,
    leads_qualifying,
    leads_callable,
    leads_callable_qualified,
    leads_converted,
    leads_converted_qualified,
    leads_declined,
    leads_declined_qualified,
    ad_spend,
    row_timestamp,
    cost_per_lead_gross,
    cost_per_signed_gross, 
    projected_conversions_gross, 
    projected_cost_per_signed_gross, 
    ad_set_daily_budget, 
    ad_date_modified,
    ad_status, 
    ad_lead_date_first,
    ad_lead_date_last,
    impressions,
    reach, 
    frequency,
    link_clicks, 
    calls, 
    performance_tier
) VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);

[jesusitd]

Process is working and is currently gathering data. Will circle back to this later with @fedegarza to start puling insights from this data.

[jesusitd]

[12:41 PM] Jesus Gonzalez Important!

Eduardo Garza, reporte `TEST - PID 2000 - SNAPSHOTS ADS TREND 20201105 published in Test workspace here https://app.powerbi.com/groups/453f2649-b5d0-4fac-ae39-15d7b6125d8a/reports/b2736202-5572-4c98-b8d2-5de439e79022/ReportSectionb96199fb58e1c82557bd

Tab is "Ad Snapshots - Hernia Mesh" accessible from tabs Hernia Mesh with drillthrough.

[jesusitd]

Reposted solution as a SECOND DRILLTHROUGH PAGE (Not cross-report) inside x - PID Drillthrough report. Some changes in data captured and layout presented: DONE! - Converted Today from any other day DONE! - Callable Qualified (all leads in the pool - for any other day) DONE! - Callable in A Campaigns (all leads in the pool) - I NEED A FIELD TO MARK A CAMPAIGNS ADDED Temp source CampaignsTypes DONE! - Leads DQd Today (from any other day) DONE! - Calls made

[jesusitd]

Snapshots are working as expected.