Share your GA4 click records

Google Analytics 4 keeps every landing URL, fbclid included, in its BigQuery export. This is the fastest way to give AI Ads Audit your Meta click history.

GA4 doesn’t store visitor IPs. Add them from another tool if you can: see visitor IPs from other tools.

Your BigQuery dataset is named analytics_ plus your GA4 property ID. Find both in GA4 under Admin > Product links > BigQuery links (project ID) and Admin > Property details (property ID).

Invite us (recommended)
Send a CSV
Not linked to BigQuery

We run the queries and the download from our own Google Cloud account, so this adds nothing to your bill.

Open the dataset

Go to console.cloud.google.com/bigquery, pick your project and select the dataset analytics_PROPERTY_ID.

Add us as a viewer

Click Sharing > Permissions > Add principal. Under New principals, enter the Google account your Dash.fi contact sends you. Role: BigQuery Data Viewer. Click Save.

Tell your Dash.fi contact

Reply with your project ID and property ID.

If your organization only allows Google accounts from its own domain, the invite will be blocked. Use Send a CSV instead.

For whoever runs your Google Cloud project. You need BigQuery Job User and BigQuery Data Viewer on it. BigQuery bills this query to your project.

Run the export query

Open a new query tab, paste this and click Run. Replace your-project-id and PROPERTY_ID. The query starts from 1 Jan 2025.

Meta clicks

SELECT DISTINCT
  FORMAT_TIMESTAMP('%Y-%m-%d %H:%M:%S', TIMESTAMP_MICROS(event_timestamp)) AS timestamp_utc,
  (SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'page_location') AS url
FROM `your-project-id.analytics_PROPERTY_ID.events_*`
WHERE _TABLE_SUFFIX >= '20250101'
  AND event_name = 'page_view'
  AND (SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'page_location') LIKE '%fbclid=%'

Save the results

Click Save results and choose CSV (Google Drive). CSV (local file) also works for a small result.Too large to save? Write it straight to a Cloud Storage bucket in the same location as the dataset. Replace YOUR_BUCKET:

Large results

EXPORT DATA OPTIONS (
  uri = 'gs://YOUR_BUCKET/dashfi-fbclid/clicks-*.csv',
  format = 'CSV',
  header = true,
  overwrite = true
) AS
SELECT DISTINCT
  FORMAT_TIMESTAMP('%Y-%m-%d %H:%M:%S', TIMESTAMP_MICROS(event_timestamp)) AS timestamp_utc,
  (SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'page_location') AS url
FROM `your-project-id.analytics_PROPERTY_ID.events_*`
WHERE _TABLE_SUFFIX >= '20250101'
  AND event_name = 'page_view'
  AND (SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'page_location') LIKE '%fbclid=%'

Send it to us

Google Drive: open the file, click Share, add the Google account your Dash.fi contact sends you as a viewer.
Cloud Storage: open the bucket’s Permissions, click Grant access, add the same account with Storage Object Viewer.
Local file: upload it to Google Drive and share it as above.

Then reply to your Dash.fi contact.

​Share the records

Share the records