All current search automation tools integrate with Google Sheets, leveraging its versatile spreadsheet capabilities alongside the automated application scheduling of the Alli Marketplace.
These sheets facilitate data transfer between a user-friendly interface, like Google Sheets, and the actual platform itself, like Google Ads.
Within these sheets, a shared language is used to combine functionality across disparate SEM processes, like Sitelinks, RSAs, or Google Merchant Promotions.
Each column can be broken down into two groups:
Common
These are values that are shared across various processes.
|
Column Name |
Description |
Usage |
|---|---|---|
|
Start Date End Date |
These refer to the “flight date” of the specific ad the row is referring to. |
Provide in MM/DD/YY |
|
Account Inclusions Account Exclusions |
Utilizes Matching Logic to pair the row with applicable “Accounts” in the platform |
Applicable accounts need to match what is included in ‘Accounts’ or ‘HQ’ tabs |
|
Camp Adgrp Inclusions Camp Adgrp Exclusions |
Utilizes Matching Logic to pair rows with applicable campaigns / adgroups based on the most specific value provided. |
This will match to what is pulled from the platform. |
|
Priority |
A safeguard against improper user asset management, activated when the number of assets exceeds platform limits |
If Priority is TRUE, the app will prioritize this asset if start and end dates are applicable. |
|
Approved |
A True / False checkbox indicating whether to send the row to the platform |
|
Unique
These are specific to the unique asset the automation supports.
|
Column Name |
Description |
Usage |
Used By |
|---|---|---|---|
|
Sitelink Id |
This links SENT sitelinks to what is in the platform. |
Do not change this column, the app will dynamically populate this. |
Sitelinks |
|
Sitelink Display Text |
The headline display text. |
Please adhere to Google’s usage guidelines. |
Sitelinks |
|
Sitelink Descriptions |
The sitelink descriptions. |
Please adhere to Google’s usage guidelines. |
Sitelinks |
|
Sitelink Landing Page URL |
The URL for the associated sitelink. |
URLs must include https. Please adhere to Google’s usage guidelines. |
Sitelinks |
|
Timezone |
The timezone for the provided values. Determines when the sitelink will go live relative to the app execution. |
America/Chicago America/Los_Angeles America/New_York Asia/Tokyo |
Sitelinks |
|
Headlines 1-6 |
Variable headlines which will contribute to the larger RSA, please follow copy guidelines. |
Should include copy that can be dynamically generated using dynamic replacements. |
RSAs |
|
Default Headlines 1-6 |
Headlines that will fill the headline’s slot if included dynamic replacements can not be made. |
Should include generic copy. |
RSAs |
|
Path |
Refer to the path listed in the ad. |
Should align with copy guidelines. |
RSAs |
|
Default Path |
This path will be used if dynamic replacements are included and fail to match. |
|
RSAs |
|
URL |
The URL of the add. |
Must use https:// |
RSAs |
|
Default Url |
This URL will be used if the other column includes a dynamic replacement that fails to match. |
Must use https:// |
RSAs |
|
Label |
Label for the ad |
|
RSAs |
|
Default Label |
Label for the ad |
|
RSAs |
|
Pin to x |
Whether or not the headline will be considered “pinned” in platform. |
h1, h2, h3, etc. follow a similar format. |
RSAs |
|
Message Type |
This is a field for internal usage purposes and does not impact the application. |
Fill with either Promo or Evergreen. |
RSAs |