You can activate your first-party data from InfoSum to GAM.

To activate your first-party data from InfoSum to GAM you need to implement Google’s self-service data ingestion process. Google requires using a Google Cloud Storage (GCS) bucket to onboard external data for new integrations. GAM provides a GCS bucket that you can set up as your activation destination in InfoSum. You can then directly send the file with your activation segment and make it available in GAM. This uses Google’s batch file upload identifiers for audiences segments feature - click here to see how it works. Let’s see how.

Prepare for activation in GAM

Please complete Google’s prerequisites section for batch file upload identifiers for audience segments before commencing activation through the InfoSum Platform - click on the link here.

In addition to the above, you will need to obtain the JSON credentials for your newly created GAM bucket. You can obtain these from the Google Management Interface, whereby you can generate the key file for the service account. This is a JSON file for a service user that allows InfoSum Bunker to access the Google Cloud Storage bucket for export. You do not need to amend this file in any way.

Data activation in InfoSum

Create an activation Bunker

To export your audience segment from InfoSum, you’ll need to set up an activation Bunker. If you don’t have one, you’ll need to set this up first. See creating a dataset for details.

While setting up your activation Bunker, please make sure to select, as an output column, one of the identifiers that GAM can ingest:

• Publisher Provided IDs (PPIDs)
• Mobile Advertising IDs (MAIDs)
• Roku IDs, tvOS IDs
• Vizio IFAs
• Samsung TIFAs
• Cookies sourced from Google’s Data transfer “UserId” field.

The following image shows you how to set a column as an output column:

Create your activation segment

Now that you’ve prepared your activation Bunker, it’s time to activate your segment either using Segment Builder or the Query Tool. 

Using Segment Builder

For more information on how to create a segment, see using Segment Builder.

Once the segment is created, click New Activation on the top right corner of Segment Builder.

Choose the dataset you want to use for activation, the output column you want to export and add a Campaign ID to identify your campaign within InfoSum.

Set the Output data column label based on the identifier that is being exported from the activation Bunker. You must set the new column header to one of the following based on Google Ad Manager’s requirements:

• For encrypted cookies and encrypted identifiers obtained from Google’s Data Transfer reports use “cookie_encrypted”
• For raw Apple IDFAs, use “cookie_idfa”
• For raw Android AdIDs, use “cookie_adid”
• For raw PPIDs, use “ppid”
• For raw Roku IDs, use “cookie_rida”
• For raw tvOS IDs, use “cookie_tvos”

Select Add a column of string values to your output data, set the Column Name to “list_id”, and set the Column Value to the corresponding audience segment ID that was created earlier in GAM.

Set the Column Delimiter to comma and click Submit. You’re now ready to connect your GCS bucket to your activation Bunker.

To delete all identifiers from a segment:

You can use the same upload file to delete all identifiers from a segment by adding a column called delete. This deletes all identifiers from the segment in GAM and then a new segment can be pushed to the same segment.

To delete all identifiers from a segment, select Add a column of string values to your output data and define as “list_id” the segment ID from which you want to delete all users. On a new row, set the Column Name to “delete”, and set the Column Value to “1”.

The example below deletes all identifiers in the segment/list with “list_id” 3153490.

Using the Query Tool

For more information on how activation queries work, see activation query. 

To write an activation query, go to the Query Tool and select Activation as your query type. Under the Query Text box, you can see the Settings. Check the Add a column of string values to your output data option, to easily build the CSV file as requested by the GAM ingestion process. Set the Column Name to “list_id” and the Column Value to the corresponding audience segment ID that was created earlier in GAM.

Next, select Override queried column headers with new headers (please contact your Customer Success Representative if override queried column headers are not available). Set the Header to override to the header name of the key that’s to be exported and set the New Column header to one of the following based on Google Ad Manager’s requirements:

• For encrypted cookies and encrypted identifiers obtained from Google’s Data Transfer reports use “cookie_encrypted”
• For raw Apple IDFAs, use “cookie_idfa”
• For raw Android AdIDs, use “cookie_adid”
• For raw PPIDs, use “ppid”
• For raw Roku IDs, use “cookie_rida”
• For raw tvOS IDs, use “cookie_tvos”

Add a Campaign ID to identify your campaign within InfoSum, set the Column Delimiter to comma and click Submit. You’re now ready to connect your GCS bucket to your activation Bunker.

To delete all identifiers from a segment:

You can use the same upload file to delete all identifiers from a segment by adding a column called delete. This deletes all identifiers from the segment in GAM and then a new segment can be pushed to the same segment.

To delete all identifiers from a segment, select Add a column of string values to your output data and define as “list_id” the segment ID from which you want to delete all users. On a new row, set the Column Name to “delete”, and set the Column Value to “1”.

The example below deletes all identifiers in the segment/list with “list_id” 3153490.

Connect your GCS bucket to your activation Bunker

After building the segment or running the activation query, you must connect the results with the GAM GCS bucket.

Go to the Activation tab under Activate and select the campaign you created for the data activation. At the bottom of the page, you will see a box containing three menu tabs - Details, Export Configuration and Export History. Switch to Export Configuration and use the slider to enable Google Cloud Storage.

Fill out the form with details of the GAM account obtained earlier when preparing for activation. You can find more information on how to fill out the form here. Please set your Destination Path to the desired GAM file path.

Select the option to Split large files, and keep the Max file size in MB to 1024. This will create a separate file for every 1GB of exported data. When you select Save, the Activate button becomes clickable. Selecting this button begins the file stream.

Verify that GAM is ingesting data correctly

Google suggests users should wait up to 48 hours from the time an audience is activated from InfoSum to the time it will be available in GAM.

Please note

Due to Google’s rate limiting requirements, you cannot upload more than 1GB per hour and up to 5GB per day.