Let's say I have Facebook Ads source and Big Query...
# replication-troubleshootingc
Claire Viland
12/02/2022, 5:38 PMLet's say I have Facebook Ads source and Big Query Destination. Using the Campaign data stream, how could I query last month spend for all campaigns? Having a heck of a time finding all the necessary components so any help would be much appreciated.
Claire Viland
12/02/2022, 5:55 PMNevermind, I believe I found everything I need in the adinsights datastream. everything except date. 😢
Claire Viland
12/02/2022, 6:04 PMAre there even date fields?
a
Alon Bar
12/03/2022, 5:48 PM@Claire Viland isnt it
Time Increment
field ?
I’m just creating one myself now
Alon Bar
12/04/2022, 4:03 PMTested it
at first glance it seems good
I’d be happy to jump on a call and talk about it
Just make sure that date_start is some Monday so that the increments will be Monday - Sunday all the time
j
Jonathan Cachat PhD (JC)
12/06/2022, 4:57 AMyou want to replicate facebook ad_insights source