Overview
Product Feed reporting is supported in Certified Datasources
Certified Datasources support product reporting for Google Ads, Facebook Ads, and Pinterest Ads. These reports are as follows:
Google Ads
-
googleads__productfeed_performance
Facebook Ads
-
facebookads__productfeed_performance
Pinterest Ads
-
pinterestads__productfeed_performance
Cross-channel
-
productfeed_performance
This guide explains how to onboard productfeed datasources and build productfeed report within ADL.
Prerequisites
-
ADL 2.0 - Refreshapp exists for your client (Tutorial: Building and Refreshing Certified Datasources)
Instructions
Product Feed Datasources Onboarding
To enable product reporting for your client, do the following:
1.) In Alli Marketplace, install the ADL 2.0 - Onboard Platform app (see Tutorial: Onboarding a Platform)
2.) Within the app, select the platform you’d like to create product datasources for, e.g: Facebook Ads or Google Ads or Pinterest Ads
3.) Click Save and Run. When the app execution completes, you should be able to see the Facebook or Google Product Feed datasource in Alli Data.
4.) Repeat the steps above but select Product Feed as the platform to onboard the product feed datasource created by the Structured Data team to pull in product settings and attributes.
5.) Authenticate the datasource and backfill the datasource as needed
The data sources created for the product are:
-
Google Ads: googleads_insights_productfeed
-
Facebook Ads: facebookads_insights_productfeed
-
Pinterest Ads: pinterestads_insights_product_feed
-
Product Feed settings: product_feed
Refresh App setup
6.) Once the data source has pulled in data, navigate to the existing ADL 2.0 - Refresh app
7.) Within the dbt_vars JSON file, add the following vars and set whatever platform you require product feed reporting for to True, e.g., enabling Google Ads:
"data_library_googleads_product_reporting_enabled": "True"
"data_library_facebookads_product_reporting_enabled": "False" --modify to True as needed
"data_library_pinterestads_product_enabled": "False" --modify to True as needed
8.) App Setting: PLATFORMS = ALL PLATFORMS
9.) Within the app, set DEPLOYMENT to True
10.) Hit Save and Run to execute the deployment app
11.) Set DEPLOYMENT back to False and click Save
12.) Once the app completes successfully, you should be able to query the product report(s)
Related articles
- How-To: Use categorizations within your custom report
- How-to add a new datasource to an existing Data Studio dashboard
- Advanced Guide: Enabling Big Query for a Custom Alert
- How-To: Name Datasource Columns
- How-To: Enable Product Feed Reporting
- How-To: Include Custom DSP Cost in Display Reporting
- How-To: Add a new categorization
- Tutorial: Getting started with Explorer Reports
- How-To: Backfill a datasource
- How-To: Categorize CM360 Conversions
- How-To: Create a new datasource
- How-to Create a Sentiment Dashboard from FB Sentiment
- How-To: Identify Which Platforms and Report Types are Enabled for Reporting
- How-To: Enable Device and Demographic Reporting
- How-To: Manually upload data to an existing datasource
- How-To: Enable Hourly Reporting
- How-To: Reclassify Media Channel
- How-To: Add New Accounts for an Existing Platform
- How-To: Update datasource owner
- How-To: View datasource errors and warnings
- How-To: Locate Source Data Used in Reporting
- How To: Debugging Discrepancies in Alli Data Library