Wrangling, Transpose and Pivot

[yrstruly]

Please assist? I would like to use Transpose and Pivot function in Data Fusion to get the desired results in tabs (i. Transposed and ii.Test Pivot Data).see: https://docs.google.com/spreadsheets/d/1bClY4BmIecc8s63XO96Xxr2Y4j4BJAbx/edit?usp=sharing&ouid=11070...  There are no tutorials or documentation on these tools to get the results i want.

[Shrieya]

Hi @yrstruly 

When you transfer the data from Google campaign manager there are some pre requistes we need to ensure.

1. Migration steps  must be correct : Here is the blog for help: 

• https://cloud.google.com/bigquery-transfer/docs/doubleclick-campaign-transfer
• https://developers.google.com/doubleclick-advertisers/dtv2/overview

2. After migration of data we need to sample it before pulling it to a excel sheet or any reporting platform . You can use SQL query to sort the data. For example : The following sample query analyzes the number of impressions and distinct users by campaign over the past 30 days. (Impressions and distinct users by campaign) 

# START_DATE = DATE_ADD(CURRENT_DATE(), INTERVAL -31 DAY)
# END_DATE = DATE_ADD(CURRENT_DATE(), INTERVAL -1 DAY)

bq query --use_legacy_sql=false \
'SELECT
  Campaign_ID,
  _DATA_DATE AS Date,
  COUNT(*) AS count,
  COUNT(DISTINCT User_ID) AS du
FROM
  `dataset.impression_campaign_manager_id`
WHERE
  _DATA_DATE BETWEEN start_date
  AND end_date
GROUP BY
  Campaign_ID,
  Date'

Thanks!

Hope this helps!!