malkavian-librarian

# -*- coding: utf-8 -*-
import time
from facebook_business.adobjects.serverside.event import Event
from facebook_business.adobjects.serverside.event_request import EventRequest
from facebook_business.adobjects.serverside.user_data import UserData
from facebook_business.adobjects.serverside.custom_data import CustomData
from facebook_business.api import FacebookAdsApi

access_token = '****************************************************************************************************'
pixel_id = '**********************'

malkavian-librarian

--Generate Date Dimension Table for BigQuery - adjust date range as required
--this is a modified version of ewhauser/date_dim.sql gist
SELECT
  d as id,
  FORMAT_DATE('%Y-%m', d) as yearMonth,
  FORMAT_DATE('%F', d) as yearMonthDay,
  EXTRACT(YEAR FROM d) AS year,
  EXTRACT(MONTH FROM d) AS month,
  FORMAT_DATE('%m', d) as monthPadded,
  EXTRACT(DAY FROM d) as day,