Skip to content
This repository has been archived by the owner on Dec 4, 2024. It is now read-only.

facebook ads v0.4.7
Compare
Choose a tag to compare
@axelazaid axelazaid released this 16 May 13:38
0.4.7
2de1382
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.

  • this update includes significant changes to how urls are parsed and utm parameters are extracted from the urls

  • incorporates the nested field macro inspired by this PR: #32

    • normalizes how nested fields are stored and then extracted across different databases

  • some facebook ads have what are called 'child links'--meaning that one ad can contain multiple urls with utm parameters:

    • in Redshift, this is stored in a subtable: adcreative__object_story_spec__link_data_child_attachments
    • in Snowflake, this is a nested field within object_story_spec called child_attachments
    • a new model was built:fb_ad_creatives__child_links, which grabs these links and the utm parameters.
      • joins to fb_ad_creatives
Assets 2
Loading