Facebook Sync: Report on Ads and Campaigns Changes Log

[jesusitd]

Working in Power BI report "FACEBOOK CHANGES" https://intakedesk.sharepoint.com/:u:/r/sites/power-bi-docs/Power%20BI%20Desktop%20Files/-%20Datasets/-%20Operations%20Workspace/FACEBOOK%20CHANGES.pbix?csf=1&web=1&e=yg6e4i

[jesusitd]

Still in data exploration phase.

Reports are being created for changelogs in:

• AdAccount
• Campaign
• AdSet
• Ad

Another changelog will be added for AdCreatives, so landing pages can be tracked as well.

Still a lot of cleanup needed, as well as better visualization options for the data.

Spoke to @CesarITD about possible future for this report, on how this could be incorporated in current reporting for Providers:

• Dates with changes marked as points
• Performance Trend changes driven by configuration changes in Ads
• Summaries of changes applied

All without breaking current database set up.

[jesusitd]

ADDED AdSets Tracking.

[jesusitd]

Added Accounts tracking.

Might consider changing model to snowflake the FB dimensions instead of keeping it starred. This is because there might be dashboards that need to explore from top to bottom which it not currently possible under the star schema.

[jesusitd]

Uploaded report to BUSINESS INTELLIGENCE workspace, Facebook Changes Tracking report. https://app.powerbi.com/groups/55d75080-a146-47d2-84fb-ebebffc8bf80/reports/64cb06b8-96be-4706-8b7a-8e0a0348dd22/ReportSectionde0695523d0b9b26e2b4

Enabled daily scheduled refresh.

[jesusitd]

Report should be released in draft by 5/16/20, as discussed in email with HK where he points out Google Sheet for Facebook changes by PID 8000.

[jesusitd]

This was left behind as more requirements arrived. Backlogged