How to remove duplicate campaign IDs from the BigQuery export after campaign name edits?
I have a BigQuery export set up for my Google account, and colleagues working on this account sometimes do name edits on campaigns, ad groups and so on.
Issue is, those changes get recorded in BigQuery as new rows, under the same asset ID:
This messes my reports up, as campaign metrics like Impressions are being duplicated in tools like Power BI:
I am not sure what the best approach would be here, so I'd gladly accept your support on this matter.
You can use on a daily basis the Ads API to store into another table the list of your assets (ie. campaign). Then either in your BI tool or a BigQuery View you can left join that table to your reporting table on the asset id (ie. campaign_id) to replace the asset name (ie. campaign name) by the latest one.
- Can I prevent duplicate data in bigquery?
- How to Concatenate Data from Different Rows into One in BigQuery
- How to include DeltaLake Files from GCS to BigQuery
- Uploading multiple local parquet files to bq
- What does sql error "Analytic function cannot be an argument of another analytic function" mean?
- Issue with the IS NULL function in BigQuery
- Getting an error : AttributeError: 'MySchemaClassName' object has no attribute "..type '' while working with apache_beam to_dataframe module
- How to give access to a single Bigquery Dataset for a user to access the data in Datalooker?
- How to drop multiple tables in Big query using Wildcards TABLE_DATE_RANGE()?
- Big query multi-statement with a declare
- Delete old rows in change log for Firestore to BigQuery Extenstion
- Max number of partitions that can be created on bigquery table
- How to write data from apache beam using gcp dataflow to bigquery table?
- Is it possible in BigQuery to alias a splat?
- How to calculate a unit price with a recursive Tree structure in a database
- How to order and limit for a unique column value SQL
- Get columns of temporary table in BigQuery
- Extract BigQuery partitioned table
- How to write a BigQuery query to find rows where a value has changed but also return the previous row before that change
- How do I add the current Week number in Looker Studio on screen
- how to update rows in bigquery from a list containing array of structs using parameterized sql query in python
- MERGE WHEN MATCHED into different table
- BigQuery select __TABLES__ from all tables within project?
- Query all datasets and tables within project on bigquery?
- Can I get help resolving an error while porting code from SQL Server to BQ Query error: Scalar subquery produced more than one element at [25:12]
- Loading data to ingestion time partitioned table using Write_Truncate overwrites all partitions
- .gitignore not working in Dataform repository
- Extract previous row calculated value for use in current row calculations - SQL
- Is it possible to update schema while doing a load into an existing BigQuery table from DataFlow?
- Possible to do a Graph query in BigQuery?