...

Global Support - Stitch Integrations Troubleshooting Guide

1. If a user has stated that their ad costs are not showing in reporting you may use this as a first step to try to diagnose the issue.

2. Go to the GS audit pinboard (linked above) and filter to the source/promo codes in question (and make sure to adjust the correct date range) by using the ‘Promo Code’ filter at the top of the board & date range filter.

3. Once you’ve filtered on the source/promo codes you should refer to the column ‘Is Error?’. If the value = ‘True’ then look to the ‘Invalid Fields’ column to see the invalid reason code.

   1. If there the ‘Is Error’ field says ‘False’ and there are ad costs in there please inform the user that they will populate in ad cost reporting (e.g. Marketing Performance data set or Lead Gen data set) later on.

   2. REMINDER: It takes about 2 days for ad costs to catch up, but if the costs in the stitch audit board match the costs that the affiliate has provided, they will make it into the ad cost reports mentioned in section 3a.

4. Invalid Reason Code Definitions

...

b. Google Ad Words = {Affiliate Name/Abbreviation}_google_{identifier}

c. Google Sheet = {Affiliate Name/Abbreviation}_google_{identifier}

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

...

c. Bing: ad_group_performance_report

d. Google Sheet: Default

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

a. Facebook: table name should be ads_insight

i. adGroup

ii. clicks

iii. cost

iv. Day

v. impressions

b. Google: table name should be AD_PERFORMANCE_REPORT

i. Ad Network

ii. Campaign

...

vi. Start Date

vii. Impressions

c. Bing: table name should be ad_group_performance_report

i. Report_datetime (default),

...

vii. TimePeriod (default)

d. Google Sheet: table name should be default

i. Ad Network

ii. Campaign

iii. Clicks

iv. Cost

v. End Date

vi. Impressions

vii. Start Date

12. 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. This should be indicated via the Global Support Stitch Audit pinboard in ThoughtSpot.

...

...