straight-raincoat-91897
01/26/2023, 8:58 AMbig-art-65238
01/26/2023, 9:03 AMpage
calls are being fired? (see the network screenshot)
1 is type preflight
and the other is type xhr
This seems to be resulting in 2 page views being triggered in GA4 (see the debugger screenshot)happy-chef-27567
01/26/2023, 1:15 PMcurved-analyst-44208
01/26/2023, 3:52 PMbig-art-65238
01/26/2023, 8:50 PMcreamy-table-83685
01/26/2023, 11:51 PMrs_database
and rs_schema
in the dbt_project.yml?
Or my little test set of data has something corrupt? (the test data set was created by rudderstack it sent to my big query from the standard .js tracking script source, and the pages and pages_view tables look normal/have data.
for BigQuery.. what should the rs_database name be? (I've tried a bunch of permutations.. but I assume it's the name of the bigquery which has inside it all of the datasets... and for rs_schema, I just supply the name of the dataset that rudderstack created, which contains the pages and page_view tables ( when clicking the 3 dots next to the dataset, choosing 'copy id' I get database.dataset < not my actual names).. but for schema I've tried dataset, database.dataset and all kinds of things)... thank you so much for your help!! Once I can do this, I can then get onto user stitching and everything else... just stumbling here on the basics.
I've loaded up the rudder-event-analytics git, replaced the rs_database
and rs_schema
vars.... but maybe not properly for BigQuery? When I run dbt build... at first it seems to go OK,, the running node model, acquiring new bigqueryconnection is all going... then it goes to this step:
`create or replace table cschatbot
.csDevAnalytics
.`rs_stg_user_first_touch``
below that shows OPTIONS()... and shows all the code etc... then below that:
Database Error in model rs_stg_user_first_touch (models/intermediate/rs_stg_user_first_touch.sql)
Syntax error: Illegal escape sequence: \. at [31:76]
I looked at what's on rs_stg_user_first_touch.sql at that spot and it's:
first_value(source_medium) over (
... rest of that function...
As far as I can tell... this means something invalid was passed in as source_medium?
I have like 5 rows of data from just testing out the .js snippet, which Rudderstack successfully wrote into the DB... so either one of the rows is corrupt (how? I just followed the tutorials.. and loaded this and that page with some urls like .local?utm_source="testing" etc... and some URL's with no UTMs.)
Or... it's not getting anything? The docs say to put in the 'database name' for the var rs_database
but I'm actually not sure which thing in BigQuery to use..
For the database name is that the dataset, or databasename.dataset? I was assuming I'd go to the dataset, click the 3 dot menu then use the copy ID which gives me cschatbot.credit_suite_com where cschatbot is the name of the bigquery, and credit_suite_com is the dataset rudderstack created when it synced my events from the .js source.cuddly-exabyte-13884
01/27/2023, 1:14 AMimportant-sandwich-44633
01/27/2023, 11:13 AMquiet-microphone-89528
01/27/2023, 1:36 PMdry-morning-71112
01/28/2023, 6:35 AMfancy-answer-79663
01/28/2023, 9:21 AMbillowy-eye-18709
01/29/2023, 1:27 AMalert-vegetable-59655
01/29/2023, 9:44 PMhappy-microphone-57447
01/30/2023, 12:32 PMlemon-balloon-16076
01/30/2023, 5:33 PMeager-terabyte-34579
01/31/2023, 10:13 AMstocky-eve-69133
01/31/2023, 1:02 PMbroad-island-80682
01/31/2023, 5:39 PMhashed_email = '0004a24e0703258e73cc36a44284bc509de973ed1802882379f0cf00e4c83d56'
rudder_analytics.track(hashed_email, 'opt-in', {
'email': hashed_email,
})
The destination is āenabledā and it isnāt showing any errors. Any ideas on what I might be missing?magnificent-vr-70778
02/01/2023, 5:57 AMwhite-oxygen-35861
02/01/2023, 10:34 AMoriginalTimestamp
,timestamp
, and that value should be mapped to $time
and $timestamp
but that is not happening. The events on PostHog have the time of arrival in those fields.
Do you know what could be the reason?
Thanks!.fancy-answer-79663
02/01/2023, 12:55 PMmelodic-lion-74852
02/01/2023, 1:22 PMvalue
field in our Purchase
events is always zero despite their being valid values set in both properties.price
and properties.value
2. (major) User data is nested in the custom_data
object not user_data
object so won't be picked up by Facebook for identifying customers
3. (minor) The server IP address is included and being picked up by Facebook as a client IPancient-kite-25270
02/01/2023, 2:14 PMaverage-monkey-86292
02/01/2023, 2:52 PMambitious-engineer-11304
02/01/2023, 3:02 PMstraight-raincoat-91897
02/01/2023, 8:03 PMacceptable-lion-84959
02/01/2023, 11:00 PMcreamy-table-83685
02/02/2023, 1:08 AMerror creating snapshot table in WH for snapshot run: cfdgf0fv3uoi7ebbppa0/cfdgf0fv3uoi7ebbppag, Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key,global_account_id,created_at,updated_at, FALSE AS rudder_invalid, TIME' at line 3
Followed the setup instructions, and created the RUDDER user, schema etc.. but in order to get the data I want, I need to select the schema that actually has the tables... which when selected, properly loads the tables of the DB I want, I can then select the specific table I want to sync, and at the bottom of the screen, I even see the first row of data from that table correctly....so all that looks good.
The table has 680,235 rows total that would need to sync on the initial run... the sync runs for about 20 minutes before it finally fails with that error...witty-beard-29204
02/02/2023, 5:15 AMfreezing-animal-5972
02/02/2023, 7:00 AMcampaigns: error in page response from blendo taskId: 3e01d4af
as seen on the sync status UI.
Preliminary google searches and the Facebook Ads source documentation have not yielded any useful resources so far to handle the error.
Any help to fix this would be greatly appreciated. TIA