Global Support - Stitch Integrations Troubleshooting Guide

1. First, check to see if the account is setup in Stitch by looking to see if the integration is setup.

2. If it is setup, does it follow the correct naming convention?

   • Facebook - {Affiliate Name/Abbreviation}_facebook_{identifier}

   • Google - {Affiliate Name/Abbreviation}_google_{identifier}

3. If yes, are the correct tables checked for Tables to Replicate?

   • Facebook: ads_insights

   • Google: AD_PERFORMANCE_REPORT

   • Bing: ad_group_performance_report

4. If the correct tables are checked, are the correct fields checked for tracking?

   • Facebook:

     • adGroup

     • clicks

     • cost

     • Day

     • impressions

   • Google:

     • Ad Network

     • Campaign

     • Clicks

     • Cost

     • End Date

     • Start Date

     • Impressions

   • Bing:

     • Report_datetime (default),

     • AccountID (default),

     • AdGroupName,

     • Clicks,

     • Impressions,

     • Spend,

     • TimePeriod (default)

5. If all of the above is setup correctly please reach out to the client and ask them to provide an export out of their ad platform of the promo/source codes in question to see if the ad set names are correct and follow the following naming structure:

   • Free Source Codes

     • {Source Code}:{List}:anything else

     • {Source Code} {List} anything else

     • {Source Code}|{List}|anything else

     • Example: X300W100 LIBWEALT This is free form text

   • Paid Promo Codes

     • {Promo Code}:{Primary Item}:anything else

     • {Promo Code} {Primary Item} anything else

     • {Promo Code}|{Primary Item}|anything else

     • Example: POXFV100 OXF This is free form text

   • If the ad set names are not in the above format you will need to have them correct the ad set names and then the ad spend should pull in on the next run.

   • If the next run does not balance out the costs you will need to ask the client to do a daily export out of their ad platform (Facebook/Google/Bing) which includes the start/end date, the ad name, and the ad spend. They will then need to submit a support ticket which should be escalated to the D&A Team so that they can update the costs tables with the spend provided from their ad platform. PLEASE NOTE: This situation should be rare, but from experience this is what can cause ad costs to not match what was in stitch. They had more than one item or list associated with one code, causing duplicate costs.