search

fivetran / dbt_facebook_ads_source

Fivetran data models for Facebook Ads built using dbt.
https://fivetran.github.io/dbt_facebook_ads_source/
Apache License 2.0
14 stars 16 forks source link

QUESTION - basic_ad table is not there in facebook_ads schema #7

Closed sriram23kmm closed 3 years ago

sriram23kmm commented 3 years ago

using Facebook ads connector i pulled all tables to my warehouse when i using dbt_facebook_ads_source package in my project it was excepting basic_ad table which was not there in my schema

kristin-bagnall commented 3 years ago

@sriram23kmm Is it safe to assume you figured out this problem? I'm curious, were you possibly using the old Facebook connector, and this was a matter of setting up our new facebook connector?

wuservices commented 3 years ago

I'm running into this issue too. I'm currently trialing Fivetran and set up the newer Facebook Ads connector. Do I need to add the pre-built report BASIC_AD and choose Day for aggregation and name the table basic_ad?

Update: I added this and the report seems to run, so maybe the READMEs of this source and the facebook_ads model need to give a little heads up to create this like the google_analytics_source does.

Related to https://github.com/fivetran/dbt_facebook_ads_source/issues/8#issue-921728863

fivetran-jamie commented 3 years ago

hey there @wuservices thanks for reaching out -- we'll be pushing some instruction around this in the README (PR https://github.com/fivetran/dbt_facebook_ads_source/pull/13)

macmietek commented 2 years ago

Hi, basic_ad table is still not syncing. I followed all the steps listed in the description. I even tried configuring basic_ad table manually using the Fivetran documentation. It didn't work.